SUMMARY:

• 7+ Yea rs of ETL Developer Experience, DB Experience ( Oracle, SQL server, Teradata) & Unix Experience
• Over 7 years of IT experience in F ull life cycle of Software Development (SDLC) including Business Requirements Gathering & Analysis, System Study, Application Design, Development, Testing, Implementation, System Maintenance, Support and Documentation
• 7 +years of Data Warehousing experience using Informatica Power Center 9.5/9.1/ 8.6.1/ 8.5/ 8.1.1/8.0/7.1 (Designer, Workflow Manager, Workflow Monitor, Repository M anager),Informatica MDM 9.6.1,PowerConnect, Power Exchange 8.6,IDQ,Data Stage 6.0, ControlM 6.4, Autosys 3.4.4, TIDAL, SQL, PL/SQL, S tored Procedures, Triggers, etc.,
• Vast experience working on the various transformations - Aggregator, Expression, Sorter, Joiner, Rank, Filter, Router, Lookup, U pdate S trategy, etc.Excellent understanding of Data warehousing Concepts - SCD Type1/Type2, CDC, Surrogate Keys, Normalization/De-Normalization, Dimension & Fact tables.
• 3 years of Dimensional Data Modeling experience using ER win 7.2/4.5, ER/Studio v7. Sound knowledge on Dimensional Modeling, Ralph Kimball and Bill Inmon Methodologies, Star/Snowflake schemas, Data Marts, Facts & Dimensions, Logical & Physical data modeling.
• 3 years of Business Intelligence experience using Cognos, Cognos Impromptu Web Reports (IWR), Cognos Report Net 1.01/1.1(Report Studio & Query Studio, Cognos Frame Work manager, Adhoc, Business Objects XIR2/XI/6.5/6.0/5.1, (Web-Intelligence 2.5, Designer 5.1, BO Developer Suite, Broadcast Agent, Supervisor, Designer, Info View, BO Universe Developer, BO Supervisor, BO Set Analyzer 2.0), Crystal Reports 6.x/5.x/4.x/3.x,Tableau.
• 7+ years of experience using Oracle 11g/10g/9i/8i, DB 2 8.0/7.0/6.0 , MS SQL Server 2005/2000/7.0 , Teradata V2R6/V2R5, Teradata SQL Assistant, MLoad, Fastload, BTEQ, Fastexport, TPump, Sybase 12.x/11.x, SAP R/3, MS Access 7.0/2000, PL/SQL, SQL*Plus, SQL*Loader and SQL Developer

TECHNICAL SKILLS:

Data Warehousing: Informatica Power Center 9.5/ 9.1/8.6.1/8.5/ 8.1.1/8.0/7.1 (Source Analyzer, Target Designer, DataStage6.0,IDQ,MDM,Transformation Developer, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor, and Admin Console). B2B DX/DT v 8.0,PowerConnect, ControlM, Autosys, Cobol, Data Mining, Data mart, OLAP, OLTP, SQL* Plus, SQL*Loader, TIDAL

BI Tools: Microstrategy 8.1.2/9.1, Cognos Impromptu Web Reports (IWR), Business Objects XIR2/XI/6.5/6.0/5.1, QlikView,SAP Business Objects 4.0, XI 3.1, Crystal reports 10x.

Environment: Sun Solaris 2.6/2.7, HP-UX 10.20/9.0, IBM AIX 4.2/4.3, MS DOS 6.22, Novell NetWare 4.11/3.61, Win 3.x/95/98, Win NT, Red Hat Linux, Sun-Spark, Sun Classic, SCO Unix, HP9000, RS6000, Win 3.x/95/98, Win 2000, Win XP. MS-Dos.

Databases: Teradata 12/13.0/14,Oracle 11g/10g/9i/8i/8.0/7.x, IBM DB2 UDB 8.0/7.0, TOAD, SQL*Plus, SQL*Loader, MS SQL Server 2005/2000/7.0 /6.0,Teradata V2R6/V2R5/R4.1/R4/R3, Teradata SQL Assistant, Sales force, MLoad, Fload, BTEQ, Fexport, TPump, Sybase 12.x/11.x, MS Access.

Data Modeling: Dimensional Data Modeling, ER Modeling, Star Schema/Snowflake Schema, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERWIN 7.2/4.5, Oracle Designer, Visio and Sybase Power Designer.

Programming: C, C++,.NET,C#,SQL, PL/SQL, sql*plus, T-SQL, ANSI SQL, SQL Scripting, HTML, DHTML, Unix Shell Scripting, Kernel Programming, Mainframes VSAM, PERL Programming.

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

Sr. Informatica Developer

Responsibilities:

• Working on a migration project where I have to design and decommission the existing Oracle to a Teradata db.
• Interact with Business and have to create the data models, design them and create the ETL components.
• Extracting data from excel files, high volume of data sets from data files, Oracle, DB2, Confidential using Informatica ETL mappings/SQL PLSQL scripts and loaded to Data Store Area
• Designed and developed ETL and Data Quality mappings to load and transform data from source to DWH using Power Center and IDQs.
• Migrating Data from Oracle to Teradata DW using Oracle Data Pump/OWB, OLE DB and DTS.
• Design and Develop Data stage ETL jobs and test cases on Teradata.
• Using BIPM while working with Analyst team for process management.
• Perform an impact analysis from end to end to decommission the existing Oracle tables.
• Successfully migrated and decommissioned 15 tables to help the reporting team to use a single source of truth.
• Created data models and updated the Meta data for future references.

Environment: Used: Informatica 9.5, IDQ, Oracle 11g, Teradata 14.10, DataStage6.0, Linux, Erwin 9.2,Toad Data point, Microsoft Office 2010, Teradata Viewpoint, Salesforce.

Confidential, Phoenix, AZ

Sr. Informatica Developer

Responsibilities:

• Involved directly with the Business and Business Analyst to create Confidential ’s and handling the Confidential ’s.
• Developed the ETL processes using Informatica Power Center to load data into the oracle database from Flat Files.
• Experience with Tableau for Data Acquisition and data visualizations.
• Developed shell scripts to handle file watcher, file transfer using trigger the process and sending email task based on file availability.
• Designed developed and implemented Master Data Management solution Customer Party MDM Domain using MDM 9.6.1.
• Gathered requirements from Business users and created a Low level technical design documents using high level design document.
• Created various data marts from data warehouse and generated reports using Cognos.
• Implement Informatica MDM workflow including data profiling configuration specification and coding match rules tuning migration.
• Worked as an ETL Admin and production support on rotation basis during the implementation of project.
• Developed mapplets and reusable transformations to reduce the redundancy of transformation usage.
• Successfully implemented Credit Data Mart, by creating a new design altogether which made the project to go live successfully on time.
• Worked on performance improvements of old ETL objects to decrease the production load time.

Environment: Used: Informatica 9.0.1, B2B DX/DT v 8.0, Informatica MDM 9.6.1/9.1 Oracle 11g, SVM, Unix, Visio, Microsoft Office 2010, Toad, Autosys, Clear quest, Cognos8.x.

Confidential, Bentonville, AR

Sr. Informatica Developer

Responsibilities:

• Converting logical data model to Physical data model in RSA and script generation for DBA’s.
• Created mapping document (TSD) from high level design.
• Implemented Change Data Capture using Informatica Power Exchange 9.1.
• Managing development team in offshore and provide status to senior management.
• Performed Data Analysis and Data matching between Siebel CRM and Siebel OBIEE Database.
• Actively involved in knowledge sharing, documentation and troubleshooting any SAP business objects related problems.
• Responsible for all activities related to the development, implementation, administration and support of ETL processes for large-scale data warehouses using PowerCenter and PowerExchange.
• Developed mappings, workflows to pull data from Informix.
• Deployment of ETL and DB changes to higher environments.
• Used TOAD and MS SQL Server to run SQL queries and validate the data in warehouse and mart.
• Performed Unit Testing and Component Integration testing before handing over the code to QA
• Supported QA and UAT phases.
• Design and Development of UNIX Shell Scripts.
• Debugging and Defect fixing of Mappings.
• Review of mappings and workflows developed by Peers and report the defects.
• Created documents to hand over the project to support team.

Environment: Used: Informatica 9.1, Oracle11g, Informix, OBIEE, UNIX, RSA, SAP Business Objects XI 3.2, Teradata SQL Assistant. SQL Server, Windows, Toad 10.0, SQL Developer 3.0, WinScp, Putty

Confidential, San Jose, CA

ETL Developer

Responsibilities:

• Lead a team of 5 members to do the ETL Design and Development.
• Designed ETL process to handle intraday transactions from the source and building an SCD in Teradata.
• Interact with Data Modelers to understand and finalize the conversion strategies.
• Interaction with the Business Partners to understand the business of the application, gather requirements analyzed and put into technical design documents.
• Designed and Developed qlik view reports to reconcile the data between vendor CGI and target systems
• Performed unit testing on the Informatica code using the Informatica Debugger and by manually checking through Sql queries.
• Worked on performance improvement for weblogs project. Redesigning the existing ETL’s to use pushdown optimization and use TPT instead of regular Teradata utilities.
• Came up with new design templates to create the ETL components.
• Managed the account to grow from 2 onsite, 5 offshore to 5 onsite and 34 offshore developers.

Environment: Used: Power Center 8.6.1, UNIX Shell, Flat Files,Agile, SQL Server, Teradata, ESP, Remedy, TFS, Salesforce, QlikView.

Confidential

Developer

Responsibilities:

• Involved in creation of Confidential Module for Component Information System.
• Monitored a central / secure Confidential Repository, Advanced Component Search Capability which provides central repository of components used in projects.
• Developed complete Module and coded for Shristi Web poll application.
• Designed process flow for Shriti’s as per the flow charts provided by the TL and PL.
• Involved in creation of complete Module and coded for signal integrity effort estimation tool.
• Was able to restore the Confidential application up and running which was not used for few years.

Environment: Java/J2EE- Servlets, Struts, Tomcat Web Server,Oracle, Win Runner, Test Director, Windows 2000