Nisha Singh

Mobile: +* (***) -***- **** Work Authorization: H1B

Cincinnati, OH

E-mail: acuuwe@r.postjobfree.com

Professional Summary:

Worked as a Data Warehouse developer & ETL Lead. Managed large Projects for Healthcare, Media & Entertainment, Commercial Finance and Apple Contact Center Domain.

Overall 8 years of IT experience in designing, administering and implementing solutions using various technologies as a consultant and IT professional.

Technical expertise in Teradata, Informatica, DataStage, HP Vertica, Oracle and have good exposure to Unix shell scripting, Autosys scheduling, Control-M Scheduling.

Worked on Data modeling using Power designer tool.

Extensively worked on Teradata Utility tools like Bteq, Fast load, Multi load, tPump, Fast Export and TPT.

Written complex SQL procedures to perform aggregations in semantic layer.

Written complex UI procedures to perform dynamic query generation for UI dashboard reporting.

Worked on automation of data replication across multiple Teradata environments and to Oracle.

Worked on Teradata performance tuning by analyzing CPU, Skewness and IO metrics.

Designed complex mappings using Informatica Transformations.

Worked on Mapping re-usability using Workflow Variables, Mapping Variables and Mapping Parameters.

Good knowledge on migration of the Informatica interface from one repository to another repository.

Developed the logic to achieve various SCD types.

Autosys job scheduling and monitoring.

Worked as Teradata techno-functional lead and is well versed with onsite-offshore model

Key Skills

8 years of experience on Data warehousing, ETL, Commercial Finance and Healthcare Data warehousing.

Teradata v12, 13, 14 – Stored Procedures, Loading Utilities, performance tuning.

Vertica 7.1

Informatica PowerCenter v7, 8.1, 9.0.

DataStage Server and Parallel.

SQL, Oracle Database

UNIX.

MS Office

Employment History

S. No

Name of Organization

Time Period

1

EXILANT Technologies

Jan’ 2014 to Feb’ 2016

2

Dell Services

Jan’ 2011 to Jan’ 2014

3

Tata Consultancy Services

Nov’ 2007 to Jan’ 2011

Project Experience

1.Project : Product Feedback Index (PFI)

Senior Teradata Developer /ETL Lead

Client: Apple Inc.

Duration: (Oct’ 2015 to Feb’ 2016)

The project provided a central location for the business to monitor product performance, the ability to easily investigate out of spec scenarios, and implement performance/usability improvements.

Product Feedback Index (PFI): This index lets Apple know the performance of Apple products based on cost involved to support contact center services for several channels, i.e., calls, chat, email, and retail. This helps analytics teams know how much fluctuation is against the forecasted values or how we have performed against predicted forecasted values.

Responsibilities:

Analyzed the requirement from Business and designed the application.

Created both functional and technical design documents.

Written Teradata procedures to load incremental/aggregated data from Core to Semantic layer of Teradata.

Written Teradata Utility scripts to load the data from file or to extract and load the data from one environment to another for data Sync up.

Developed the Informatica outbound interfaces to generate the feeds.

Written Autosys JIL files to automate the jobs execution.

Created Tables, Views, Indexes and Procedures in Teradata.

Compiled/Run the Teradata objects using Bteq.

Created Tables, Views, Synonyms, Triggers and Procedures in Oracle.

Created the DLD (Design level Doc) and KT Supporting docs.

Prepared the test specifications and test logs.

Involved in UT, IT, UAT and production deployment.

Technologies/Tools: Vertica 7.1, Teradata procedures, utilities, BTEQ, SQL, UNIX, Autosys etc.

2.Data warehousing – iScore Dashboard for Managers

Senior Teradata Developer /ETL Lead

Client: Apple Inc.

Duration: Jun’ 2015 to Sep’ 2015

iScore dashboard provided a central location for the apple business to monitor metric performance, the ability to easily investigate out of spec scenarios, and implement performance/usability improvements. It had pre-built/defined dashboards (daily, weekly, QBR).

Ability for users to build their own highly customized dashboards. Provided ability to drill (down & sideways) to analyze root cause. View key metrics in near real time.

Responsibilities:

Designed, Maintained, enhanced, and optimized the Teradata stored procedures.

Worked independently as a Teradata/ETL developer with responsibilities for coding, testing as well as in a lead role guiding others with the same responsibilities.

Developed a framework which will copy data from Teradata to Vertica database

Created table, projections in vertica database and worked on performance tuning in vertica database.

Provided application performance monitoring and tuning for improvements

Developed and implemented standards for ETL processes using Teradata

Prepared and Reviewed the ETL Design documents after meetings with Business for migration of data from Source to Target database.

Ensured that the system design is aligned with the business requirements through appropriate documentation and requirements mapping.

Independently researched, escalated, and resolved support issues.

Development and testing of UNIX shell scripts using Teradata Utilities such as BTEQ, Multiload.

Co-ordinated with onsite/offshore delivery team client managers/business analyst.

Technologies/Tools: Vertica 7.1, Informatica, Teradata procedures, utilities, BTEQ, SQL, UNIX, Autosys etc.

3.Data warehousing – North Star-Compass project for Sales Advisors process compliance

Senior Teradata Developer /ETL Lead

Client: Apple Inc.

Duration: Jan’ 2014 to May 2015

North Star is an existing tool utilized by Apple managers to regularly monitor and evaluate the behavior of Apple‘s sales advisors during customer transactions to ensure that the advisors’ interactions meet Apple’s quality standards. The Compass Project will drive required improvements in the North Star application and the Admin Console interface. These changes include enhancing admin capabilities and extending the functionality of multiple applications such as Wave and Maestro.

Responsibilities:

Designed, Maintained, enhanced, and optimized the Teradata stored procedures and Informatica jobs.

Worked independently as a Teradata/ETL developer with responsibilities for coding, testing as well as in a lead role guiding others with the same responsibilities.

Provided application performance monitoring and tuning for improvements

Developed and implemented standards for ETL processes using Informatica/Teradata

Prepared and Reviewed the ETL Design documents after meetings with Business for migration of data from Source to Target database.

Ensured that the system design is aligned with the business requirements through appropriate documentation and requirements mapping.

Independently researched, escalated, and resolved support issues.

Development and testing of UNIX shell scripts using Teradata Utilities such as BTEQ, Multiload.

Co-ordinated with onsite/offshore delivery team client managers/business analyst.

Technologies/Tools: Informatica PowerCenter 9.x, Teradata procedures, utilities, BTEQ, SQL, UNIX, Autosys etc.

4.Data warehousing – Healthcare Domain Development Project for Harvard Pilgrim Health Care

Senior ETL Developer and Team Lead.

Client: HPHC

Duration: Mar’ 2012 to Jan’ 2014

This was a Data warehousing Project for a Leading Healthcare Insurance company of USA and Nisha was involved in the design, documentation, development, testing, install and support of complex data extract, transformation and load (ETL) programs.

Regular tasks included Design and Development of Datastage ETL Jobs, Development of Unix shell scripts, SQL scripts using Teradata utilities such as BTEQ, Fast Load, Multiload, TPump, Design and Review of Technical Document

Responsibilities:

Designed, Maintained, enhanced, and optimized DataStage jobs.

Worked independently as an experienced lead DataStage developer with responsibilities for coding, testing as well as in a lead role guiding others with the same responsibilities.

Provided application performance monitoring and tuning for improvements

Developed and implemented standards for ETL processes using DataStage

Prepared and Reviewed the ETL Design documents after meetings with Business for migration of data from Source to Target database.

Ensured that the system design is aligned with the business requirements through appropriate documentation and requirements mapping.

Independently researched, escalated, and resolved support issues.

Development and testing of UNIX shell scripts using utilities such as BTEQ, Fast Load, Multiload, and TPump.

Coordinated with onsite/offshore delivery team client managers/business analyst.

Technologies/Tools: Datastage, Oracle, Teradata utilities, SQL, UNIX, Autosys, MPP, CA Harvest

5.Data warehouse Migration - EBI LITE Migration

Senior ETL Developer and Team Lead.

Client: HPHC

Duration: Jan’ 2011 to Mar’ 2012

HPHC had an existing data warehouse in database Microsoft SQL Server which used various datasets as its source system. This project was to migrate existing data warehouse to Teradata database using Informatica as ETL Tool.

Regular tasks involved migrating datasets, metrics and reporting from SQL

(EBI Lite) environment to Teradata.

Refer to the data model of the dataset in EBI Lite, Design and create data

Model. Identifying the subject area that data model gets merged into and producing mapping documents accordingly.

Responsibilities:

Designed, Maintained, enhanced, and optimized Informatica mappings.

Mapped functional and business requirements with test cases.

Worked independently as an experienced lead Informatica developer with responsibilities for coding, testing as well as in a lead role guiding others with the same responsibilities.

Provided application performance monitoring and tuning for improvements

Developed and implemented standards for ETL processes using Informatica, Control M jobs.

Prepared and Reviewed the ETL Design documents after meetings with Business for migration of data from Source to Target database.

Technologies/Tools: Informatica PowerCenter 8.1, Teradata, Microsoft SQL Server, Control-M, UNIX

6.Data Warehousing – GE Capital’s Teradata DEV for General Electricals

Senior ETL Developer, Technical & Functional Consultant.

Client: GE Capital.

Duration: Dec’ 2009 to Jan’ 2011

GE Capital is focusing on merging data from all its sub business into an Enterprise wide data warehouse. Teradata proprietary Financial Services Logical Data Model (FSLDM) is selected as the data model and is customized to suit the needs for GEC.

For integrating the data from different source systems Informatica and Teradata Utilities are used as data transformation modes. Informatica is used for sourcing the data from the source systems when is then stages into Teradata and BTEQ scripts are used to move it to Core database.

Responsibilities:

Understanding and Analysis of the specifications and pre-prepared design

Developed, optimized, and engaged in performance tuning of ETL jobs. Used databases including Teradata and Oracle. Responsible for interfacing with the database design team and performance tuning the data loads.

Understanding of Complete System architecture, Process Flow, Jobs Flow and Job Run Frequency

Made recommendations towards the development of new code or reuse of existing code.

Analysis of the design to find and resolve bugs

Creating and scheduling control-M jobs.

Technology/Tools: Informatica, Oracle, Teradata, Control M, VSS.

7.Data warehousing – Sales Data Mart development for Warner Bros

Senior ETL Developer, Technical & Functional Consultant - Offshore India.

Client: Warner Bros.

Duration: Jan’ 2008 to Nov’ 2009

The project deals with Theatrical Distribution division of Warner Bros. for its domestic market (i.e. US & Canada). The key business objective for building this platform is to facilitate business decisions through a single-source of analytical data and information for business users of theatrical sales. Moreover, to remain competitive in the market there was the need for unification, congregation & integration of current source systems.

Sales Data Intelligence Mart was developed considering the need of integrated & robust reporting platform. The ETL is done through Informatica and reporting is done using Business Objects

Responsibilities:

Worked in analyzing the source and target databases and in creating source-to-target mapping documents.

Have developed Informatica mappings of various complexities involving all kinds of transformations

Developed the ETL Informatica mappings and created Business Objects Reports.

After six Months of Development Phase acted as Technical and Functional Consultant in same project.

Monitored newly designed Informatica Mappings which ran daily for populating final facts and dimensions in the Data warehouse having Teradata as database.

Technology/Tools: Informatica, Oracle, Teradata, Control M, VSS.

Education

Degree

Institute

Year

Grade

Bachelors of Engineering Information & Technology

Bhilai Institute of Technology, Bhilai-India

2003-2007

7.9/10

Higher Secondary Examination

Jyoti Higher Secondary school, Rewa-India

2002-2003

80%

Senior Secondary Examination

Jyoti Higher Secondary school, Rewa-India

2000-2001

82%

Personal Profile

Gender

Female

Languages Known

English And Hindi

Passport Number

G3983850

US H1B Visa

H1B Work Visa with 5 years remaining

Citizenship

India

Present Country

USA

Contact this candidate