ETL developer

Trupti Bagwe

Email: ac1de1@r.postjobfree.com

Cell: 847-***-****

PROFESSIONAL SUMMARY

6.10 years of experience in ETL Developer/Lead,Software Quality Assurance Analyst,Business analysis and Data Analyst.

Very strong professional background in Data warehouse and IT experience in the software engineering, processes and methodologies of SDLC and STLC.

Strong knowledge and experience in Insurance, Banking domains.

Experienced in client interaction to capture and document business rules, business and system requirements. Also, understanding client issues and translating into functional requirements.

Skilled in project planning, estimations, analysis, designing, developing, testing and deploying ETL/Data warehousing projects.

Highly experienced in manual testing, System testing and UAT testing.

Experience in creating the requirement traceability matrix and performing the corresponding testing.

Skilled in developing Test strategy, test plans,test scenarios,test cases using standard template of MS Excel and in Quality Center (defect tracking system).

Involved in ETL Migration strategy, Data Lineage and defining the data granularity.

Good hands-on experience in creating Use cases, UI specs, Process flow, Change request, traceability matrix, technical design document, ETL Process design, ETL logic conversion, Deployment, Production Data volume estimation.

Experience in UNIX Shell scripting to provide effective solutions, creating Parameter files, Process Log files, Automated Archival of log files, Scheduling ETL jobs

Performed Advanced level Data warehouse testing, which verifies and validates the ETL Mappings, table loads.

Experienced in conducting requirement analysis meeting with stakeholders and creating business requirement document, scheduling meetings with development/test team for requirement walk through.

Trained on Agile best practices and Version One tool.

Experience working on Agile projects.

Experience working on different databases like Oracle, Teradata, Netezza and DB2.

Good Team player possessing good inter-personal, strong analytical and problem solving skills, communication skills, presentation skills, proven leadership qualities, mentored a team of developers with industry best practices.

TECHNICAL SKILLS

ETL

Abinitio ETL Tool (Co>operating System: 3.0.4.3, GDE version: 3.1.3)

Data base

DB2, Netezza, Oracle SQL Developer, Teradata

Operating Systems

Windows, UNIX

Programming Languages

C/C++, UNIX shell scripting, SQL, JAVA (Basic)

Applications

MS Office Suite (Word, Visio, Excel, PowerPoint)

Other tools

Tivoli scheduler, QRM /TDM, Abinitio Meta data hub, Version One,

Quality Center, ALM, OFSAA

EDUCATION

Mumbai University - Atharva College of Engineering, India August 2008

Bachelor of Engineering in Electronics and Telecommunication

PROFESSIONAL RECOGNITION

To appreciate the contribution towards the support of different projects along with managing other task and making process improvements awarded with “Excellence in work” and “Stretch” awards.

Email appreciations by Client Project Managers for successful and timely delivery of challenging projects.

PROFESSIONAL EXPERIENCE

May 2012 - 2016

Nov 2014- 2016

ETL Onsite Lead/Business analyst

Project: GFIT (Global Finance Information Transformation)

Client: Capital One Bank McLean, VA/San Diego,CA

The GFIT project has been established to transform the data architecture in Global Finance to improve data quality, consistency and stream line certain business processes.

Responsibilities:

Working as Business system analyst to analyze and gather all existing source system information to develop data warehouse for LCR calculation and to improve data quality and consistency.

Planning user stories/tasks in Version one.

Worked on requirement document and data analysis.

As ETL lead/developer working with business to understand the requirement, creating mapping design to map all source to target details, creating technical design document as per requirements, developing ETL process based on requirement. Guiding other application developers to optimize code/process improvements.

Perform peer review and code optimize sessions within team.

Scheduling/Migrating projects to QA and PROD environments.

Supporting Production runs.

Environment:

Abinitio (Co>operating System: 3.0.4.3, GDE version: 3.0.2)

Oracle SQL Developer /OFSAA

UNIX

April 2014-Oct 2014

ETL Onsite Lead /Data and Business analyst (Team size 20)

Project: LCR (Liquidity Coverage ratio) Calculator McLean, VA/San Diego,CA

Client: Capital One Bank

Calculate Liquidity Coverage Ratio (LCR) for all line of business.

Responsibilities:

As data analyst- Data profiling, data analysis of all line of business source to check existing data related to LCR and map to target systems.

Writing queries for data analysis, data volume, data quality checks for existing data for LCR reporting

Worked with the stakeholders to gather business requirements for designing purpose.

Creating Source to Target mapping tracker. Creating Analysis reports.

As ETL lead- Gathering requirement for ETL development scope in the calculating LCR.

Active participation in Design, Analysis and project planning meeting to finalize design, implementation approach.

Creating technical design document.

Developing Abinitio code based on requirement, guiding offshore team for code optimization.

Created test cases, entered in ALM to perform tests, logged defects. Helping testing team for system testing

Code review, Unit Testing, Design review, QA/ Production Implementation of code, Scheduling.

Oct 2013–March 2014 Omaha, NE

Onsite ETL Lead/Coordinator and developer (Team Size 12)

Project: FDIS

Client: First Data

The client data from various sources has been processed as per business requirement and needs and stored in the data ware house (Oracle tables/DB2 tables).

Responsibilities:

Requirement gathering for Design.

Preparing high level design and project estimations.

Technical discussions with Client for design approach.

Helping offshore team members for designing and developing ETL processes based on the design.

End to end unit and integration testing.

Production rollout and Worked on Post implementation issues.

Environment:

Abinitio (Co>operating System: 3.0.4.3, GDE version: 3.0.2)

Oracle SQL Developer (Version 11.1)

May 2012–Oct 2013 Omaha, NE

Onsite ETL Lead and developer ( Team Size 9)

Project: Symphony Data Vault

Client: First Data

Implement data warehouse with latest modeling technique ‘Data Vault’ with Netezza backend to store all FD client user’s data.

Responsibilities:

Requirement gathering for Design and audit exception process.

Design the data vault design as per data model.

Develop the abinitio graphs based on the design in the form of Hub, link and satellite.

Design and develop Audit and exception process based on the model.

End to end unit and integration testing.

Production rollout and Worked on Post implementation issues.

Production support.

Production server migration activities.

Environment:

Abinitio (Co>operating System: 3.0.4.3, GDE version: 3.0.2)

IBM DB2( Version 9)

Aginity workbench for Netezza (Version 3)

Syntel Inc

Oct 2009 – Apr 2012

Oct 2011 - Apr 2012 Chicago, IL

Onsite ETL Lead and developer (Team Size 3)

Project: Common messaging format (CMF)

Client: Allstate

This project was developed to extract agent related staff and employee’s information based on business requirement and sends the extract to various downstream in the form of XML. The data was loaded to a Database or transferred to various UNIX landing zone locations. We used XML combine, Rollup and Call web service components in this project.

Responsibilities:

Working on various requirements gathering from End user for any new development or enhancement.

Clarify client issues and concerns regarding Application.

Understanding the business process and impact for the new requirements with System Analyst of the project.

Impact Analysis, design and developed the Abinitio graphs based on the requirement.

Unit and system testing of code.

Writing wrappers scripts in UNIX to run the Jobs.

Tivoli scheduler to schedule jobs.

End to end production migration of code from Development environment to production environment.

Worked on Post implementation issues.

Environment:

Abinitio (version: 2.5)

Oracle SQL Developer (Version 9g)

Aug 2011 - Oct 2011 Mumbai,India

Offshore developer and coordinator ( Team Size 8)

Project: Password Reset for security violation restriction

Client: Allstate

The scope of this project was to restrict the password of UNIX server sharing with various upstream and downstream teams which sends the inbound files to UNIX server or access UNIX servers for any file transmission.

Responsibilities:

Interacting and coordinating with clients which accessed UNIX server locations.

Created common transmission id and password with restricted permissions and ACL’s.

Coordinate with all upstream and downstream to update the password changes.

Dec 2010 - Jul 2011 Mumbai, India

Offshore developer and coordinator (Team Size 8)

Project: Easy match development

Client: Allstate

The goal of this development project was to develop interface which provides the list of all potential donors to vendors outside of Allstate.There were three module of this project named Remittance, Yearly payroll and monthly delta creation of agent’s donor process. Also, we developed process to extracts agents data and corresponding support staff and merge with employee data to send the indicative and accounting data to the vendor in preparation for the annual appeal. We used XML Split component to translate XML data to data format file.

Responsibilities:

Understand and coordinate with Business analyst for requirements gathering.

Develop the Abinitio code based on design documents.

Daily status reporting with client on call.

Unit and system testing.

Production migration and implementation

Handled Post production implementation issues.

Environment:

Abinitio (version: 2.5)

Oracle SQL Developer (Version 9g)

Jun 2010 - Nov 2010 Mumbai, India

Offshore developer and coordinator (Team Size 8)

Project: Agent Number remediation (ANR)

Client: Allstate

The goal of ANR enhancement project was to change the Agent number data type from string to hex to handle alphanumeric agent number. Analyze 350 interfaces and change the Agent number data type to Hex

Responsibilities:

Analyzed around 400 interfaces to identified Agent number field in the interfaces.

Run the Abinitio interfaces with new alphanumeric agent number.

Test the transformation function results to convert the string to Hex data type.

Validate the interface output file before and after change.

Coordinate with QC team for the QA testing.

Daily status reporting with the updates to client.

Writing wrappers scripts in UNIX to run the Jobs.

Use Tivoli scheduler to schedule jobs by raising the appropriate job scheduling requests.

Migrate the updated interfaces to production.

Handled Post production implementation issues.

Environment:

Abinitio (version: 2.5)

Oracle SQL Developer (Version 9g)

Mar 2010 - May 2010 Mumbai, India

Offshore developer and coordinator (Team Size 8)

Project: Data Center Migration (DCM)

Client: Allstate

The goal of this project to migrate all jobs, scripts and interfaces setup from one server to other server.

Responsibilities:

Identified all the landing zone, prerun locations, interfaces, scripts and Abinitio related objects path to convert the old server location to new server location for the execution.

All database changes for the new server.

Project level parameters changes for new servers.

Coordinate with upstream team of all applications to update the changes with landing zone and prerun locations.

Coordinate with UNIX admin to form the MFS and folders on the new UNIX servers.

All interfaces migrated from old server to new server.

Test the interface running successfully on new server.

Environment:

Abinitio (version: 2.5)

Oracle SQL Developer (Version 9g)

Oct 2009 - Feb 2010 Mumbai, India

Offshore developer (Team Size 8)

Project: Encompass Enhancement

Client: Allstate

This was enhancement project to restrict all other agents to pass from the applications apart from Allstate agents.

Responsibilities:

Analyze all Abinito interfaces to filter out the agents apart from Allstate agents.

Run the interface with filter condition and test the interface output after changes.

Unit and system testing and creation of test results.

Writing wrappers scripts in UNIX to run the Jobs.

We use Tivoli scheduler to schedule jobs by raising the appropriate job scheduling requests.

Production migration of the impacted interfaces.

Post production implementation issues.

Environment:

Abinitio (version: 2.5)

Oracle SQL Developer (Version 9g)

Patni Computer Systems

Oct 2008 – Sep 2009

Oct 2008 - Sep 2009 Mumbai, India

Offshore developer (Team Size 7)

Project: IBM- Content management (IBMCM))

Client: GE

The project was developed on Content management technology’s is IBM database to store data. We were provided web services to store that data to database. We were using JAVA programming language to handle the tool.

Responsibilities:

Analysis, Testing, Documentation, Maintenance, application Support.

Production support (Application monitoring, monitoring job Abends, and fixing production issues).

Environment:

IBM CM content management tool

Java

Contact this candidate