Resume

Sign in

Project Data

Location:
Saint Petersburg, Florida, United States
Posted:
October 25, 2016

Contact this candidate

SANDHYAA M

***** *** ** *, *** ****

St. Petersburg,

Florida – 33716

Telephone: 727-***-****

Email:acw71u@r.postjobfree.com

CAREER ASPIRATION:

An accomplished Data Warehouse Professional with demonstrated success designing and implementing ETL solutions that improve business functionality. Proven ability to implement Data Warehouse Design and Solutions that decreases effort, Maximize Usage and positively affect the Clients Performance.

SUMMARY OF QUALIFICATION:

Total Experience of 6.5 years in IT Industry.

Extensive Experience in ETL Design and Development using Teradata, Informatica, Oracle, SQL Server, SAS DI and UNIX.

Have handled multiple projects at the same time.

Have good ability in data analysis and data mapping.

Have designed few data warehouse architectures.

Have designed the entire architecture for a project, sole handedly for RBS client.

Good Analytical and Communication skills.

Has the ability to handle projects single handedly which I did so most of my career.

Have scaled up to take responsibility of handling project in short span.

Considered Reliable by my managers.

Have received Award of Performance for my project with RBS client.

Completed World-Class Infosys Training in Business Intelligence (SSIS, SSAS & SSRS) and .NET with CGPA 4.97 out of 5.00.

Apart from the project responsibilities have supported the account by developing internal projects using .NET and SQL server.

Also have given training on Teradata, Informatica and Insurance domain.

Have also attended training in Business Objects and Greenplum.

PROJECT EXPERIENCE:

PROJECT : MEDICARE & MEDICAID PRODUCTION SUPPORT

ROLE : Senior Associate (Mar 2015 – Aug 2015)

CLIENT : Wellcare, Tampa

TECHNOLOGIES : Informatica 9.6, Oracle 11g

Wellcare provides Medicare & Medicaid managed care. This project is for revenue tally on day to day basis and end of month summation. The key challenge of this project is to monitor all the jobs and fix any issues as per the SLA’s. Code enhancements are done very often to fix the current issues.

Roles and Responsibilities

•Verification of daily reports on Medicare & Medicaid systems.

•Worked with SME’s to understand the incidents and fix the code for enhancements.

•Production support on day to day basis.

•Code tuning on performance issues.

PROJECT : D3 PRODUCTION SUPPORT

ROLE : ETL Technical Lead & Onsite Coordinator (Oct 2014 – Till Date)

CLIENT : Walt Disney Parks & Resorts, Orlando

TECHNOLOGIES : Informatica 9.6, Teradata 12, BTEQ Scripts

This project is handling of real time data for key operations of Walt Disney Parks & Resorts on daily basis. The key challenge of this project is to monitor all the jobs and fix any issues as per the SLA’s. Code enhancements are done very often to fix the current issues.

Roles and Responsibilities

•One of the onsite leads for composite systems at Walt Disney

•Offshore coordinator for Informatica and Teradata issues.

•Worked with SME’s to understand the incidents and fix the code for enhancements.

PROJECT : DATA GOVERNANCE

ROLE : ETL Technical Lead & Onsite Coordinator (Dec 2013 – Sep 2014)

CLIENT : American Express, Phoenix

TECHNOLOGIES : Informatica 9.1, Oracle 11g, Control M

This project is to implement data governance activities in the existing BASEL II implementation of American Express Data warehouse. The key challenge of this project is modifying the existing mappings in production without affecting the current flow of business. I was leading for the Individual Portfolio which contains data of individual credit card records from eight different sources.

Roles and Responsibilities

•I am handling offshore of 5 members across multiple vendors of Infosys, IBM and CTS.

•Interacting with client for Requirement Gathering and Requirement Analysis.

•Designing the architecture for the new DG implementation with optimal performance in existing production code.

•Creating the data mapping for eight different source systems across the global to the final target data warehouse.

•Creating informatica mappings and workflows for the requirements which are common to all portfolios across AMEX.

•Leading the team for Individual Cards portfolio.

•Delegating works for offshore and reviewing informatica mappings, sessions and workflows.

•Production implementation and support.

PROJECT : ETRADING

ROLE : ETL Developer and Team Lead(Sep 2012 – Oct 2013)

CLIENT : Royal Bank Of ScotLand – Insurance, Chennai

TECHNOLOGIES : SQL Server, SAS DI

This project is to migrate data from Teradata data warehouse to Mainframes IS2000 systems as files. The key challenge of this project is in data mapping between two complete different architectures. One of the challenging projects in the insurance domain for Infosys.

Roles and Responsibilities

•I have leaded a team of 15 members in this project.

•Interacting with client for Requirement Gathering and Requirement Analysis.

•Creating the data mapping between two different systems.

•Designing the architecture with optimal performance.

•Developed and reviewed SAS DI mappings.

PROJECT : MANUAL REKEY

ROLE : ETL Developer and Team Lead(Feb 2013 – July 2013)

CLIENT : Royal Bank Of ScotLand – Insurance, Chennai

TECHNOLOGIES : SQL Server, SAS DI, Windows workload Manager

This is a temporary solution project to the same client using SQL server scrips and SAS DI implementation.

Roles and Responsibilities

•I have leaded a team of 4 members in this project.

•This was the second project handled by me while I was leading the Etrading project as well.

•Interacting with client for Requirement Gathering and Requirement Analysis.

•Creating the data mapping between two different systems.

•Designing the architecture with optimal performance.

•Developed SQL scripts and SAS DI mappings.

•Have given my support for maintenance as well.

PROJECT : IAUTOMATE – FINANCE SUBROGATION

ROLE : ETL Developer (Oct 2011 - Aug 2012)

CLIENT : WellPoint Inc., Chennai

TECHNOLOGIES : Informatica 9.1, Teradata 12, EXCEL VBA Macros, Unix Shell Scripting, WLM (IBM Workload Manager)

This project is to automate the process of extracting the details of members under Wellpoint Insurance who have migrated to a particular region from various legacy systems. The complexity of the project resided in the complete automation without any manual interference. It required to use VBA macros for param file generation, unix, bteq and fast export scripts for the extract generation.

Roles and Responsibilities

•The entire project was single handled by me at offshore.

•Interacting with client for Requirement Gathering and Requirement Analysis.

•Designing the architecture with optimal performance.

•Developed Excel macros using VBA code for auto param file generation.

•Developed Informatia mappings and UNIX scripts to Extract, Transform and Load the data.

PROJECT : EDLR1 - Decommission

ROLE : ETL Developer and Module Lead (May 2011 – Oct 2011)

CLIENT : WellPoint Inc., Chennai

TECHNOLOGIES : Informatica 9.1, Teradata 12, Unix Shell Scripting

This project was a result of decommission of a Datawarehouse. Hence the extracts to different vendors which was sent from EDLR1 datawarehouse had to be extracted from EDLR2 datawarehouse.

Roles and Responsibilities

•Leading the module for a single vendor.

•Interacting with client for Requirement Gathering and Requirement Analysis.

•Developed informatica mappings and UNIX scripts for data extraction.

•Trained the new resources on Informatica and took up development activities simultaneously.

PROJECT : ESI –PKG FIX

ROLE : ETL Developer (Jan 2011 – May 2011)

CLIENT : WellPoint Inc., Chennai

TECHNOLOGIES : Teradata 12, BTEQ scripts, WLM (IBM Workload Manager)

This project was a support and maintenance project which was as a result of the client changed the source feed layout which required fixes in the code. Major challenge exists in the updating of the primary key of the CLAIM database.

Roles and Responsibilities

•Interacting with client for Requirement Gathering and Requirement Analysis.

•Developed BTEQ scripts to Extract, Transform and Load the data.

•Handled few fixes individually.

PROJECT : ESI – CLAIMS

ROLE : ETL Developer (Jul 2009 - Dec 2010)

CLIENT : WellPoint Inc., Chennai

TECHNOLOGIES : BTEQ Scripts, Teradata 12

This project was a result of the accumulation of Pharmacy benefit management business from WellPoint by Express Scripts Inc. (ESI). All pharmacy data from different source systems will be sourced into a centralized DW residing in DB2 by ESI. This in turn will be selectively extracted, related, transformed and loaded into EDW residing in Teradata using Teradata BTEQ scripts. In this I was CLAIMS subject area.

Roles and Responsibilities

•Interacting with client for Requirement Gathering and Requirement Analysis.

•Developed BTEQ scripts to Extract, Transform and Load the data.

•Prepared handover documents and gave a transition to the maintenance team on the entire CLAIMS subject area.

EDUCATIONAL INFORMATION:

Course

Institution

Year of Completion

Percentage

B.E (Computer Science Engineering)

Jaya Engineering college

( affiliated to Anna University)

2009

79

Higher Secondary

Nazareth Mat Hr Sec School

2004

90

Matriculation

Nazareth Mat Hr Sec School

2002

93

PERSONAL PROFILE:

Nationality : Indian

Date of Birth : 16-10-1986

Linguistic Proficiency : Tamil and English

Thanks

Sandhyaa



Contact this candidate