Supriya Rai

Client: UKG

Team Size: 14

Technology: Salesforce, SOQL, Advanced Excel, Informatica

Project Description: Kronos and Ultimate Software—two of the largest HR technology vendors. The two companies had announced a merger and formed UKG, creating the largest pure HR tech company by market share, which brought changes and new possibilities for customers. The primary objective of this Project is to migrate Ultimate Data to Kronos by using Informatica.

Responsibilities

I am responsible for testing end to end ETL process and migrated data.

• Creating Test Plan, Test Summary and Test Scripts
• Defined project wide performance metrics such as data migration testing milestones, timeline goals, required completion dates.
• Supervised aspect of testing team such as hiring, training and remedial assignments.
• Collaborated with stakeholders regarding project capabilities and limitations to deliver optimal functionality.
• Spearheaded technical discussion round tables to track progress and optimize future resource distribution.
• Communicated directly with project stakeholders, proving timely updates on project advancement.
• Explained project technical risks and benefits during project kick-off.
• Involved in analyzing data, developing ETL logic, data archival, validating and maintaining the data.

Client: Chubb

Team Size: 50

Technology: SQL Server 2014, SSIS

Project Description:

Chubb is the world’s largest publicly traded P&C insurance company and the largest commercial insurer in the U.S. With operations in 54 countries and territories, Chubb provides commercial and personal property and casualty insurance, personal accident and supplemental health insurance, reinsurance and life insurance to a diverse group of clients. The primary objective of this Project was to complete the build and migration efforts for the ESIS Claim Operating System (ECOS).

Responsibilities

• I was responsible for end-to-end ETL process by creating new SSIS packages for handling data. Migrated data from Fixed width Files to Target Tables by applying business rules.
• Also responsible for creating tables and complex queries as per business requirements.
• Involved in analyzing data, developing ETL logic, validating and maintaining the data.
• Designed best practice documentation for development.
• Guided team in layout modifications to improve functionality.

Client: Plan International Organization

Team Size: 4

Technologies: SQL Server 2014, SSIS

Project Description:

This project was about to create and maintain portal for plan international organization.

Responsibilities:

• I was responsible for creating new SSIS packages and modifying existing SSIS packages for handling data.
• Also responsible for creating tables and complex queries as per business requirements.
• Involved in analyzing data, developing ETL logic, validating and maintaining the data.
• Developed visualizations and dashboards using Tableau Desktop and Provided 24/7-production support for Tableau users.

Client: American Express

Team Size: 15

Technologies:

SQL Server 2012, SSIS, Teradata, SAS, Tableau

Project Description: This project was to publish report which shows the account falls under defaulters according to business requirement. Initially Amex tries to collect due amount by itself. After certain Period of time, it assigns the accounts to different outside agencies. These agencies track the cardholder and try to collect the due amount.

Responsibilities:

• I was responsible for writing Teradata script from SAS code and then load data from Teradata to SQL server using SSIS packages and generating the reports
• Involved in developing database objects like tables, stored procedure, views, triggers, complex queries as per business logics
• Data validation with respect to the developed dashboards
• Developing the ETL data model and creating stored procedures
• Involved in analyzing data, developing ETL logic, innovating new solutions, optimizing the data flow and queries, validating and maintaining the data front.

Client: JPMorgan Chase & Co.

Team Size: 10

Technologies:

Informatica Power Centre 9.5, SQL Server

Project Description:

The project was to generate BO reports using Informatica and Sybase. The task was to cleanse the data and then uploading the data into the database and then generate the reports.

Responsibilities:

• Created data marts as per business logics
• Data and functional testing with respect to the developed dashboards
• Developed the ETL data model and creating stored procedures
• As an Extraction, Transformation and Loading (ETL) developer at off-shore, I was involved in creating the mappings and reports on the business logic provided.
• Involved in ad-hoc activities like Testing reports and mappings.