Ch Amara Saradhi

ac2ut9@r.postjobfree.com

732-***-****

Summary:

** ***** ** ** ********** in the field of Data warehousing in tools like Informatica 8x, 9x, 10x Power Center,Developer (IDQ),Analyst,MDM,Cloud, Oracle,Teradata,SQL Server and UNIX Shell Scripting.

Technical proficiency in the Data Warehousing teamed with Data Analysis, Data Modeling, Business Requirements Analysis, Application Design, Development & testing, Data profiling, data standardization & Quality Control and full life cycle Implementation of Data Warehouse.

Involved in Requirement gathering, Data Analysis, Application Design, Data Modeling, Application Development, Implementations and Data Quality in different Data warehouse Projects.

Experienced in using IDQ tool for profiling, applying rules and develop mappings to move data from source to target systems.

Hands on Labeling, Standardization, validating address using Address doctor by Informatica Developer of IDQ.

Experience in designing error and exception handling procedures to identify, record and report errors.

Extensive Experience in developing and performance tuning of informatica mappings

Worked extensively in onsite (client location and having exposure of direct involvement with client).`

Created source to target mapping documents for input into ETL specifications by Identifying, analyzing data sources

Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.

Created transformations such as Joiners, Lookups, Filters, Aggregator, Sequence Generators, according to the business rules

Created Complex mappings using Connected and Unconnected Lookups, Aggregate, Update Strategy, Stored Procedure and Router transformations for populating target table in efficient manner.

Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting

Experience in testing the data using debugging mapping method. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.

Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.

Created unit test cases to test data loads and check whether the components adhere to the technical design

Used SQL tools to run SQL queries to view and validate the data loaded into the warehouse and troubleshoot data issues.

Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.

Used SQL tools to run SQL queries to view and validate the data loaded into the warehouse and troubleshoot data issues.

Education:

M.C.A (Masters in Computer Application) from Osmania University, India

Technical Skills:

ETL Tools: Informatica 10.X/9.X/8.x (Power Center),IDQ BODS,Teradata SQL Assistant, TOAD, Putty

EIM Tools: Informatica MDM Multi-Domain, IDD, SIF

Data Modeling: Physical Modelling, Logical Modelling, Relational Modelling, Dimensional Modelling (Star Schema, Snow-Flake, Fact, Dimensions), Entities, Attributes

Databases: Teradata, Oracle 12g/11g/10g/9i, MS SQL Server, MS Access

Languages: SQL, PL/SQL, Data Structures, Unix Shell Script,

Tools: SQL plus, PL/SQL Developer, SQL* Loader

Operating Systems: Windows NT/2000/2003/XP/Vista/7, Unix, Linux

Scheduling Tools: DAC, BMC-CTRL-M, Autosys

Supporting Tools: Service Now, TSRM

Professional Experience:

NUCOR, Chemung NY Jul 2015 – Present

Sr. Informatica Consultant

Project: NUCOR ROSS RUN .

Responsibilities:

Develop the mappings using needed Transformations in Informatica tool according to technical specifications

Implemented Informatica error handling, dynamic parameter file generations and coding best practices

Responsible for technical Design Document and Details mapping document

Analyzing and understanding functional requirements.

Used Informatica reusability at various levels of development.

Involved in the performance tuning of the Informatica mappings and stored procedures and the sequel queries inside the source qualifier.

Designed and developed Informatica mappings for data sharing between interfaces utilizing SCD type 2 and CDC methodologies

Develop informatica mappings and workflows for new change requests.

Responsible for creating Source to Target data mapping.

Developing Informatica ETL jobs to extract data from EBS and to load into the SQL Server.

Extensively used Informatica Power Center and created mappings using transformations like SourceQualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator.

Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data.

Created scripts for Batch test and set the required options for overnight, automated execution of test scripts

Conceptualized and developed initial and incremental data loads in Informatica using Update strategy transformation, variables

Resolving issues raised by customer

Handling Issues during development and analyzing phase and Fixing Bugs if any

Preparing Test Results

Unit testing

Environment: Informatica 10.1.0/9.6, Oracle 12g, Tableau, EBS,SQL Developer

CMEC – Child Management Enforcement Commission,UK Feb 2014 – Jun 2015

Sr Informatica Consultant/Developer

Project: CMG – Child Management Group

Responsibilities:

Responsible for technical Design Document and Details mapping document

Develop the mappings using needed Transformations in Informatica tool according to technical specifications

Responsible for creating Source to Target data mapping.

Interacting with the onsite people and resolving the offshore issues.

Developing Informatica ETL jobs to extract data from Source and to load into the Oracle.

Implemented Informatica error handling, dynamic parameter file generations and coding best practices

Used Informatica reusability at various levels of development.

Involved in the performance tuning of the Informatica mappings and stored procedures and the sequel queries inside the source qualifier.

Designed and developed Informatica mappings for data sharing between interfaces utilizing SCD type 2 methodologies

Develop informatica mappings and workflows for new change requests.

Involved in Developing UNIX shell Scripts to generate parameter files and executed oracle procedures as batch jobs.

Extensively used Informatica Power Center and created mappings using transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator.

Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volumeof data

Environment: Informatica 9.1,IDQ,Oracle 11g, DAC

UNILEVER, London,UK Mar 2013 – Jan 2014

Sr Informatica Consultant/Developer

Project: Unilever Voice of Consumer

Responsibilities:

Extract, transform and Load data from different sources into Oracle database using SAP BODS XI4.0 as ETL tool.

Experience in BTEQ scripts

Have designed history logics and written good SQLs in Teradata.

Have involved in solving complications in the production level issues.

Have involved SIT and UAT defects closing.

Worked extensively in Perl, shell scripting and click stream analysis

Handled off shore for related work in respect of unit test case preparation and documentation like implementation, warranty & support.

Have helped in re-building of Jobs based on requirement.

Environment : BODS, TERADATA

ABN AMRO BANK, Miami, FL May 2011– Feb 2013

Informatica Consultant

Project: PC-NGM CDWH

Responsibilities:

Develop the mappings using needed Transformations in Informatica tool according to technical specifications

Responsible for technical Design Document and Details mapping document

Interacting with the onsite people and resolving the offshore issues.

Developing Informatica ETL jobs to extract data from Source and to load intothe Oracle.

Implemented Informatica error handling, dynamic parameter file generations and coding best practices

Responsible for creating Source to Target data mapping.

Used Informatica reusability at various levels of development.

Attended weekly status meetings and provide detailed status report to the client.

Involved in the performance tuning of the Informatica mappings and stored procedures and the sequel queries inside the source qualifier.

Involved in Developing UNIX shell Scripts to generate parameter files and executed oracle procedures as batch jobs.

Preparing Test Results, Unit testing, Defect Fixing

Environment: Informatica 9.1, Oracle,Unix

Invensys, Amarillo, TX Jun 2007 – Apr 2011

Informatica Consultant

Project: Avantis Decision Support System

Responsibilities:

Developing Informatica ETL jobs to extract data from Source and to load into the Oracle.

Develop the mappings using needed Transformations in Informatica tool according to technical specifications

Responsible for technical Design Document and Details mapping document

Extensively used Informatica Power Center and created mappings using transformations like SourceQualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator.

Used Informatica reusability at various levels of development.

Fixed the invalid mapping's and troubleshoot the technical problems of the database.

Attended weekly status meetings and provide detailed status report to the client..

Develop informatica mappings and workflows for new change requests.

Involved in Developing UNIX shell Scripts to generate parameter files and executed oracle procedures as batch jobs.

Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data.

Preparing Test Results, Unit testing, Defect Fixing

Environment: Informatica, Oracle

Xerox Corporation, Creve Coeur, MO Mar 2005 – May 2007

ETL Consultant

Project: Free Flow System Testing

Responsibilities:

Defect identification.

Execute regression tests and feature tests, Build/Patch Verification

AR/SPAR verification and validation

Raising Bugs using JIRA Tool

Preparing Quality and Technical Related Documents

System Test effort estimation and planning.

Feature description change request review.

System Test matrix creation/ Updating.

Contact this candidate