Data Project

Vindhiya Narmada Duraisingam ********.*******@*****.***

Senior ETL Developer /Lead 848-***-****

Career Summary

Having overall experience of 8 years and 6 months in a challenging IT industry.

Hands on Experience in all phases of the project life cycle include Requirement, Analysis, Design, Development, Maintenance and Testing.

Worked in the areas of Finance, HealthCare, and Insurance domains.

Data warehousing exposure with exceptional technical background in Application designing, developing, analysis and implementation of Enterprise Data warehouse applications.

Strong Data Warehousing ETL experience using Informatica Power Center (Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer, Informatica Server, Repository Manager).

Experience in all the phases of ETL such as Extraction, Cleaning, Transformation and Loading using Informatica power center and extensively worked on Data Warehouse Full Life Cycle Projects for Finance, Healthcare and Insurance industries.

Extracted and transferred source data from different databases like Oracle, Teradata, SAP BW, JDE and Flat file into target database.

Involved in design and implementation of the ETL for load automation. This reduced a lot of manual work every day.

Performed major role in understanding the business requirements, designing and loading the data into data warehouse (ETL).

Developed Reusable ETL codes for multiple deployments which need to be integrated to Financial Data Warehouse.

Subject Matter Expert (SME) in Financial data warehousing (FDW) subject areas like General ledger, Cost center and Profitability analysis.

Played role as Data Analyst with in the team and developed multiple Validation sqls and guide BI team to create the validation report model.

Extensively worked with large databases (>10TB) in Production environments.

Good knowledge in Implementing the star and snowflake schema of DWH using Informatica power center 9.x

Worked on performance improvements of the interfaces by implementing techniques like partitioning, compressing techniques, tuning of complex queries, PDO’s and TPT’s.

Designed and developed the modules which include very complex business requirements and are critical for business.

Have good problem solving and analytical skills. Highly motivated professional, Team player and the ability to effectively work with communicate and mentor people.

Have extensive experience in leading onshore and offshore team working from different locations and has successfully completed several projects.

Have experience in Communicating activities/progress to project managers and lot more experience in having one-to-one call with business architects, business analysts and clients.

Conducted trainings to the entire team and new joiners for Reusability ETL code.

Quickly adaptive to any new technologies and deal with an ever changing baseline.

Great Team player and maintain a positive Work Culture

High commitment and dedication towards the work

Strong verbal and written communication, interpersonal and people management skills.

Education

Bachelor of Engineering in Electronics & Communication from Periyar Maniammai College of Technology for Women, Anna University, India.

Technical Skills

ETL Tools

Informatica Power Center 8.x, 9.x

Databases

Teradata v14 &v15, Oracle 9i, Oracle 10g

Scripting Language

UNIX Shell scripting

Scheduling Tools

Autosys, Tidal, WLM

UNIX & Database Tools

Putty, WINSCP, Toad & SQL Developer

Operating Systems

Windows, UNIX, Linux

Professional Experience

CLIENT : Johnson & Johnson – New Brunswick, NJ

PROJECT : Global Financial Data Warehouse - FPNA

Company : Cognizant Technology Solutions

Duration : Jan 2014 – Till Date

Designation : Onsite ETL Lead

Technology Used : Informatica Power Center 9.x & Teradata v15.

Global Financial Data Warehouse – Financial Planning and Analysis (FPNA) is an enterprise wide program that is being implemented in Johnson & Johnson that will include sales data. Sales reports and a sales dashboard will be accessible from this system. The reports will be available via a portal to Finance including but not limited to regional and corporate CFO’s and their staff; Shared Services, and their functional business partners.

Global Financial Data Warehouse (FDW) is an enterprise wide program that is being implemented to deliver Financial Data Warehouse to support Financial Planning and Analysis. FDW will eventually support FP&A for 70 Billion+ Revenue and Expense planning. Design the global solution to integrate financial information from 15+ key J&J ERP platforms (SAP, JDE and etc.) from NA, Asia, EMEA and LATAM to support the diversity of the business lines: Pharm, Consumer and Medical Device.

Responsibilities

Solution Architect/ETL Lead for Global Finance Data Warehouse (FDW). The project used Informatica Power Center as ETL tool to extract financial information(FI-GL, FI-CO-PA, FI-CO-CCA, and FI-IO & FI-COST) from SAP ECC systems,Oracle and JDE Systems into Teradata Enterprise Data Warehouse.

Played role as Internal Data Analyst also with in the team and developed multiple Validation sqls and guide BI team to create the validation report model.

Analysis of the Interface Requirements, Change Requests and Defects.

Preparing Functional and Technical design of the Interfaces.

Developing Informatica mappings, SQL Queries for the approved design.

Owner of Reusable ETL code for 15 source systems from EMEA/ASPAC/NA/LATAM regions.

Review of test scripts in Quality Center and defect tracking.

Testing and Functional Review of the Interfaces, Onsite – Offshore coordination

Assisting TM1 Team for establishing the Planning data.

Responsible for overseeing the Quality procedures related to the ETL

Participated in all the data modeling design discussions of the entire application.

Actively involved in Production deployments for every major release.

Interacted with the Business and Data Modelers and all other stakeholders to get a better understanding of the Business Processes and Gathered Business Requirements.

Reaching to right people to resolve the dependencies.

Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems

Responsible for code reviews and Informatica/Teradata best practices.

CLIENT : The Hartford Financial Services Group Inc.

PROJECT : Reinsurance

Company : Cognizant Technology Solutions

Duration : Feb 2013 – Dec 2013

Designation : ETL Lead

Technology Used : Informatica Power Center 8.x, Teradata v14 & Oracle 10g

The HPC Reinsurance DW Maintenance and support started in September 2010 with an objective of increasing the value proposition for the client through intellectual arbitrage and by

oSharing and implementing Cognizant best practices

oImproved process using MPS and MAS Framework

oProvided Thought Leadership.

oCost effective Onsite-Offshore model for round the clock support

This project has been initiated to create a single source of data for Business Intelligence needs. The objective is to be able to fully integrate organization and participation functionality within the Business Objects universe.

Responsibilities

Developed Complex Mappings by using synchronized queries, multiple data providers and user defined objects.

Worked with system supporters, developers and DBAs in automating and evaluating the testing process.

Handled performance tuning in various PL/SQL blocks and responsible to schedule all the newly created jobs using Autosys Tool.

Monitor the database sessions and identify bottlenecks that is slowing down the applications

Responsible for assigning the minor enhancement to my team members and make sure team is completing the task without much delay.

Responsible for handling minor enhancements, planning, tracking, change control aspects of the enhancements

Responsible for effective communication between the project team and the client. Provide on call monitoring status report on a daily basis to update the daily status of various project activities.

Translate customer requirements into formal work request form documents

Responsible in handling Production issues like (Performance issues, Job failures, fixing the data issues).

CLIENT : Wellpoint Inc.

PROJECT : ICD10 -Wellpoint

Company : Cognizant Technology Solutions

Duration : Jan 2011 – Jan 2013

Designation : ETL Lead

Technology Used : Informatica Power Center & Teradata

WellPoint has made a strategic commitment to move from locally based business intelligence architecture to WellPoint wide enterprise architecture to bring consistency and improved accuracy for business intelligence reporting and analytics. The goal of this ICD effort is to avoid the cost of ICD10 remediation for non-strategic data warehouses by accelerating the migration of numerous BI applications to the new strategic database, EDWARD.

Responsibilities

Responsible for development, testing and implementation for Adjudication Management Application.

Refactored the existing system for better performance using the query tuning techniques.

Prepared Approach document, Business specifications documents and Technical specifications document to meet the requirements.

Performed peer code reviews to meet the coding standard.

Worked on Defect fixes in System test and UAT environments.

Was recognized for fixing many defects with a quick turnaround time.

Mentored team members on Query writing.

Actively involved in Production deployments for every major release.

Reaching to right people to resolve the dependencies.

Coordinated and communicated with Subject matter expert for production Defect fixes.

CLIENT : Wellpoint Inc.

PROJECT : NASCO - PRODUCT

Company : Cognizant Technology Solutions

Duration : Nov 2009 – Dec 2010

Designation : Senior ETL Developer

Technology Used : Informatica Power Center & Teradata

National Account Service Company or NASCO is the single source system, which feeds data for the ETL process of the claims, which will ultimately, loads the ADW. NASCO is a system dedicated exclusively to health benefits processing for Blue Cross Blue Shield Plans nationwide by the company of the same name. It was formed in 1987 by five Blue Cross Blue Shield Plans and offers a total solution approach to health benefits processing. NASCO offers comprehensive solutions for administering traditional, point-of-service, preferred provider, consumer-directed, and other health benefits services to national, regional and local employers

Responsibilities

Responsible for development, testing and implementation.

Created Technical Design Documents for ETL process Functional Specification Documents.

Worked as a single person and delivered the project without any issues.

Worked on improving the performance of Informatica mappings by using various Informatica performance tuning techniques so that maximum throughput can be maintained.

Created/Modified the TAD (Technical Architecture document), TDD (Technical Design Document) with the database implementation strategy.

Involved in creating the deployment groups and labels for migrating the code for test environments.

Coordinated and communicated with Subject matter expert for production Defect fixes.

Provided post implementation support.

Act as Mentor for new joiners for fast and effective ramp up in projects.

Responsible for the Code migration across different test environments.

Implemented the push down optimization approach and MD5 for the SCD type II.

Involved in Performance tuning of mappings, transformations and sessions to optimize session performance.

CLIENT : Wellpoint Inc.

PROJECT : ACES - PRODUCT

Company : Cognizant Technology Solutions

Duration : Mar 2009 – Oct 2009

Designation : ETL Developer

Technology Used : Informatica Power Center & Teradata

Anthem Consolidated East System(ACES) is the source system, which feeds data for the ETL process of the claims, which will ultimately, loads the EDW. The Product tables in EDW house the entire product and benefits related information. The data for the product EDW tables will come from ACES tables.

Responsibilities

Worked as Informatica Developer in the Team.

Responsible for creating the High level design and Low level Design documents.

Responsible for the mapping and Workflows development.

Involved in the process of extracting data from integrated heterogeneous sources and sorting extracted data.

Handled the complex transformation logics using Union, Normalizer, Aggregator, Joiner and Lookup Transformations.

Involved in Implementing the star and snowflake schema of DWH using Informatica.

Performed data validation, data reconciliation on the target oracle table and source data.

Created the solution documents for the mappings. Created the Proof of excellence mappings during the development.

Implemented the slowly change dimension Type I and Type II for change data capture.

Involved in identifying the bottlenecks of the transformations/Mappings and sessions and worked for tuning of the long running jobs.

Responsible for migrating the code from development environment to different test environments by creating the deployment groups and labels in Informatica.

CLIENT : Washington-Mutual.

PROJECT : Home Loans Data Strategy Phase

Company : Cognizant Technology Solutions

Duration : Aug 2008 – Feb 2009

Designation : ETL Developer

Technology Used : Informatica Power Center & Teradata

Credit Data Integrity was recently identified as one of the top five risks for WaMu by the Enterprise Risk Management Council. Given the current economic and credit environment, the enterprise focus is to prevent further Earnings deterioration and manage Capital and Liquidity. Better Credit data and information infrastructure is needed to support this task

Responsibilities

Created the low level design documents and solution documents.

Debugging the code and providing the permanent fixes for the code.

Responsible for conducting the unit test cases.

Responsible for the mapping and Workflows development.

Implemented the push down optimization approach and MD5 for the SCD type II.

Handled ETL tasks like developing mappings, running workflows and monitoring them and fixing the issues.

Contact this candidate