Sharma Neha dv4op0@r.postjobfree.com

+91-756*******

Professional Summary:

Having 3.2+ years of professional experience in the implementation of Data Warehousing projects with the tools like TERADATA and INFORMATICA.

Significant Strengths:

Have around one year experience on Informatica tool.

Extensively worked on Data extraction, transformation, loading with Oracle, Flat Files using Informatica

Having 2+years of experience as a Teradata Developer.

Currently working as a Teradata developer.

Good Understanding in protection concepts like Fallback, Raids, and Journals

Worked with Teradata 12 utilities like BTEQ, Fast Load, Multi Load and Query man.

Have experience on implementing business rules in BTEQ scripts.

Worked with parameters like UPI,USI and other Indexes.

Proficient in understanding business processes / requirements and translating them into technical requirements.

Did Data Reconciliation across Source System

Worked with different sources like Flat files and Relational Databases.

Strong Knowledge on Data warehousing concepts.

Ability to work in groups as well as independently with minimum supervision and initiative to learn new technologies and tools quickly.

Having basic knowledge on UNIX.

Work Experience:

Working as a Software Engineer for HSBC Global Technologies, Hyderabad from Jun 2008 to july 2012.

Education:

B.Sc. Barkatulla University Bhopal

PGDCA, Barkatulla University Bhopal.

Technical skills:

Operating Systems Windows Family, UNIX Basics

RDBMS Teradata v2r12), Oracle 9i,10g

Tools Informatica 8.6

Query Tools

Tools BTEQ, Query man

Teradata Utilities Fast load, Multi Load, Fast Export

Project Title: RDC – ARW Maintenance and Enhancements

Client : HSBC Technology Services(HTSA), USA, Buffalo

Organization : HSBC Global Technology, Hyderabad

Duration :oct 2011 to july 2012

Role : Teradata Developer

Project description:

HSBC is a global banking and financial services company headquartered in Canary Wharf, London, United Kingdom As of 2011 it was the world's second-largest banking and financial services group and second-largest public.

This product offering is a benefit of the “Check Clearing for the 21st Century” (Check 21) legislation that enables financial institutions to provide substitute checks as legal tender for check processing, in place of the original US paper checks. ARW is a warehouse of the data from an Image Exchange file.Data in this warehouse is to be maintained for minimum 8 years.

This Project involves the creation of a Data Warehouse for the Sales Reporting System. Data from Operational Source System is extracted and loaded into data warehouse Using Teradata.

Roles and Responsibilities:

• Initiated sit down sessions with the Sales team for requirement gathering. Created and loaded tables, views

• Created scripts using FastLoad, Multi-Load to load data into the Teradata data warehouse.

• Involved in Sql scripts Macros, stored procedures in Teradata to implement business rules.

• Updated numerous Bteq/Sql scripts, making appropriate DDL changes and completed unit and system test.

• Involved in peer to peer reviews.

• Identifying Bugs and reporting defects.

• Knowledge transition to new team member.

• Daily Communication regarding the status of the work to Onsite coordinator

Project Title: Debt Manager-Recovery Management

Client : Avago, Finance DSO

Duration : aug 2010 to sep 2011

Role : ETL Developer.

Environment : Informatica Power Centre 8.6.0, Oracle 10g, Teradata V2R6, Windows 2000

Project description:

Avago Finance DSO provides daily sales out standings to its customers.The objective of this project and applications describes the functional requirements gathered for different receivable reports and build Data Marts for all metrics of Overview, AR Balance, Payments Due, Effectiveness, Payment Performance, Customer Report, and Invoice Details. Based on these metrics, they analyze their business and make the decisions to improve the business. Distributed data residing in heterogeneous data sources is consolidated into the target Teradata database. Performing some Aggregate calculation. Data Mart is developed in Star Schema Fashion consisting the Facts and Dimensions. The sources included Oracle databases. Using these Facts and Dimensions BI Team generate the various types of reports and distributed to Company Level.

Roles & Responsibilities:

• Uploaded data from operational source system (Oracle 8i) to Teradata.

• Used utilities of FLOAD, MLOAD, FEXP of Teradata and created batch jobs using BTEQ.

• Imported Metadata from Teradata tables.

• Prepared BTEQ scripts to load data from Preserve area to Staging area.

• Worked on Teradata SQL Assistant querying the source/target tables to validate the BTEQ scripts.

• Involved in peer to peer reviews.

• Identifying Bugs and reporting defects.

• Knowledge transition to new team member.

• Daily Communication regarding the status of the work to Onsite coordinator

• Daily Communication regarding the status of the work to Onsite coordinator

Project Title: HSBC Cards

Client : HSBC Technology Services, USA

Organization : HSBC Global Technology, Hyderabad

Duration : June 2009 to July 2010

Role : ETL developer

Description:

HSBC is a global banking and financial services company headquartered in Canary Wharf, London, United Kingdom As of 2011 it was the world's second-largest banking and financial services group and second-largest public.

One HSBC cards project is used to find out the performance of their product across various regions and the also the business behavior across the territories.

Responsibilities:

Responsible for Extracting, Transforming and Loading data from Oracle and placing it into Data warehouse.

Worked extensively on different types of transformations like Expression, Aggregator, Lookup, Sequence Generator and Joiner.

Involved in testing the Informatica Objects to validate the test data based on the test data.

Creating / Building and Scheduling workflow and Sessions using the Workflow manager.

Involved in unit testing.

Involved in reviewing the Mappings.

Contact this candidate