Experience

Core Digital Media

• United States
• Software Development
• 100 - 200 Employee

• Principal Data Engineer

  • Aug 2021 - Present

• BI Developer-Expert

  • Jan 2019 - Jul 2021

  - Created Customer Master Data Management to better understand, engage and reach out to our customers with better products- Worked on cutting edge technologies such as Apache Kafka and Spark structural streaming to load Cost Data in real time Into Data Warehouse- Performed migration of Data Warehouse from Teradata to Snowflake using lift and shift approach- Migrated ETL servers from Data Center to AWS for both development and production environments

• Senior BI Developer

  • Jun 2017 - Dec 2018

  - Leverage Google AdWords and Python to build automated ETL Data pipelines- Work on cutting edge technologies such as Apache Kafka and Spark structural streaming - Provide operational support to the EDW data loads and provide recommendations to reduce support issues- Design and implement automated production deployment of Informatica codes by leveraging script based XML import/export- Automate API data pull and setup offline data upload processes to publishers like Facebook and Google- Partner with reporting team to understand reporting requirements and the corresponding design strategy for Data Warehouse Show less



OeP

• United States
• Business Consulting and Services
• 1 - 100 Employee

• Data Warehouse Developer- Intern

  • Mar 2017 - Jun 2017

  - Designed, created and maintained a Data warehouse solution by replacing existing legacy systems enabling brand managers to analyse trends in historical Data and make meaningful forecasts leading to 25% efficiency improvement - Designed and implemented ETL, developed SQL and SSIS packages and integrated with front end reporting application Technologies Used- SQL Server Database, T-SQL, SSIS, Power BI, Visio for Data Modelling - Designed, created and maintained a Data warehouse solution by replacing existing legacy systems enabling brand managers to analyse trends in historical Data and make meaningful forecasts leading to 25% efficiency improvement - Designed and implemented ETL, developed SQL and SSIS packages and integrated with front end reporting application Technologies Used- SQL Server Database, T-SQL, SSIS, Power BI, Visio for Data Modelling



Fidelity International

• United Kingdom
• Financial Services
• 700 & Above Employee

• Business Intelligence Developer

  • Dec 2014 - May 2016

  Worked in Enterprise Data Warehouse project which is the single source of all Sales (of various wealth management products such as mutual funds, ISA plans etc.) and Assets (of clients) data for the company. EDW serves the reporting needs of various teams such as marketing, business finance and advisors/Brokers. Apart from this, various regulatory reports are extracted out of EDW. - Built data marts to suffice business requirements and created both high level and low level designs to cater to the system changes necessary to enhance the platform - Used ETL tools to process ~10 million transactional records daily and extracted business insights for clients - Created Dashboards using Tableau to visualize client-Asset data for marketing products according to client’s age and portfolio - Created complex SQL queries for production support data analysis and Sales-Assets data reconciliation - Ran an initiative to create a robust automated regression test suite which cut down the testing efforts by more than 50% and ensured better quality of codes - Tuned performance of jobs to bring down the SLA of the entire batch cycle from 10 hours to 5.5 hours - Merged 35 Unix scripts into 10 while maintaining the functionality, thus reducing the maintenance - Performed impact analysis for migration from legacy fund accounting system (GFAS) to SONATA application - Acted as a Subject Matter Expert on Sales and Assets entities of the Enterprise Data Warehouse - Lead a team of 4 programmers to successfully deliver “FATCA Regulatory Project”. The purpose of this project was to develop a system that will generate legal and compliance reports supposed to be sent annually to IRS- the USA tax authority Show less



Accenture

• Ireland
• Business Consulting and Services
• 700 & Above Employee

• Business Intelligence Developer

  • Aug 2013 - Dec 2014

  Worked for Zurich Financial Services- a diamond client of Accenture, that provides general and life insurance solutions to its customers. It uses TIA, a well-known global insurance application,for policy issuance, claim management and re-insurance. In this project Informatica Power Center was used as a middleware/ETL tool to integrate data from different systems and applications with TIA.- Created ETL design documents, mapping documents, test cases, Informatica mappings and workflows, oracle procedures, Unix scripts and control-M jobs- Designed and implemented a configurable ETL error handling framework which ensured validation of data flowing into the staging area from source systems achieving a process efficiency of 30%- Standardized and automated deployment of Informatica codes to higher environments through deployment groups- Created a detailed effort estimation model for ETL deliverable bringing down the estimation of a specific module by 25%- Performed peer code reviews and documentation of the best practices- Worked closely with BAs and Architects for analysis of business requirements, functional design specifications and software requirements specifications to design the ETL flows- Successfully steered the integration of a third party insurance application, Zconnect, to expand business in Latin America- Performed tasks such as Leading defect calls, status reporting of ETL team to the client and resource allocation- Trained and mentored 8 new onshore and offshore team members ensuring smooth on-boarding and transitioning into the project Show less

• Senior ETL Developer

  • Aug 2011 - Aug 2013

  Client- Zurich Financial Services- Data Integration Project- Created Informatica workflows and mappings to orchestrate the invocation of stored procedures and transform data according to the business rules that need to be applied before loading the data in transaction tables- Performance tuning of codes to remove bottlenecks, achieved max gain of 80% in one of the jobs efforts and increasing readability- Performed migration of complex PL/SQL procedures to Informatica codes Show less

• ETL Developer

  • Jul 2010 - Aug 2011

  Vodafone,Telecommunication domain- Data integration project- Analysed and implemented small scale enhancements on the existing codes with minimal efforts- Developed ETL workflows, technical design documents and Unit Test case documents- Developed and implemented reusable Informatica Mapplets, thus increasing the re-usability by 25% and reduced overall build effort