Built data foundations & frameworks for AI, ML & Product Analytics.

Built in-house

• experimentation data platform

• audiencing data platform

• member 360 platform

• datawarehouse AI RAG bots

Built foundational datasets to unlock product insights in creation team for newsfeed, stories & reels product in facebook app.

Working in marketing scrum to deliver data pipelines catering business requirements in every sprint cycle. Collaborating with business users and data science team for their data needs, giving them the data insights valuable for decision making.

• Automated direct mail marketing process which reduced the overall operation time of a campaign by 70%

• Created ingestion pipelines in hive which consumes huge data from credit bureaus and transformation of this huge data to be able to load in to data marts.

• Creating credit models and underwriting in hive sql to process this data and send automated files to printshop for printing mails.

• Created analytical tables for capturing all the user’s interaction across multiple marketing channels like direct marketing, email, partner websites, digital ads, etc. so as to make them personalized offer and market them efficiently.

• Created automation to ingest data from partners, building analytics on it to change our pricing based on competitor’s pricing.

• Help email marketing team with all the data attributes needed for their campaign like eligible products, user’s loan, pay plan, whether prospective borrower, etc

• Developed UNIX shell scripts for business validations and operational use cases.

• Creating oozie workflows to schedule hive etl jobs

• Creating alert mechanism using splunk, wavefront and Opsgenie to track SLA for critical processes and failure alerts notifications.

• Development of ETL pipelines using Datastage ETL tool or complex SQL to integrate the website & store data from various sources like Hadoop (HDFS), Oracle, DB2, Tibco, MQ & Flat files into data warehouse.

• Develop complex scripts to consume huge files from big-data/HDFS to data warehouse using Hive & Sqoop.

• Mitigated risks & challenges involved in the migration of ETL jobs from Datastage v8.5 to v11.3.

• Optimized performance of existing production jobs which were bottlenecks.

• Developed UNIX shell scripts to create validation frameworks and scripts to trigger the ETL jobs which are scheduled in Control-M scheduler.

• Used XML stages to consume and publish XML files to MQ.

• Interaction with System analysts, business users to understand their requirements during Plan and define phase of the project.

• Managing multiple projects and driving the projects in parallel from development phase to deployment.

• Preparation of deployment documentation to handover to support team for production support.

• Followed the release engineering & defect management process using JIRA tool and used SVN for version management.

• Used Version One tool for Agile software development cycle.

• Providing solution with respect to SAP BODS and Redwood scheduler

• SAP Repository Management/ Data store setup

• Worked in different modules of the projects related to Financial Data processing, Business Performance Management, Sales Marketing Analysis and Reporting, e-Statements.

• Interaction with Clients, managers, business team to understand their requirements during Plan and define phase of the Change Request.

• Used transformations like Connected and Unconnected Lookups, Expression, Joiner, Update, Router, Aggregator and Sequence generator.

• Development of jobs in SAP Redwood Scheduler following SDLC cycle.

• Maintenance of Database, SAP BODS server, Recycling services by coordinating with the hosting team.

• Connecting with Oracle product support, SAP product support for issues with Tool.

• Configuration changes, recycling services of Essbase server.