SUMMARY

• 11+ years of professional work experience in analysis, design, development and support using ETL Tools like Ab initio and Informatica Power Center in finance, telecom, retail, banking and healthcare domain.
• 8 Years of strong experience using Informatica PowerCenter 6.x/7.x/8.x/9.x. with various tools designer, repository manager, workflow manager and workflow monitor. Excellent with all the Transformations - connected and unconnected lookup, Joiner, expression, aggregator, normalizer, router.
• Excellent knowledge and working experience in Informatica Data Analyzer (IDA).
• Excellent working experience with Informatica Data Quality (IDQ) with plans in workbench application.
• Used Data Quality Assistant and DQ command line tools. Plans were transformed to mappets
• Excellent Knowledge of Master Data Management(MDM)
• Strong working experience in databases like Teradata, Oracle, DB2 and Sybase. Written complex SQL queries for testing developed ETL objects against databases.
• 3+ Years of strong working experience using Ab initio (2.13/2.14/3.02/3.1.2 ). Designed and developed complex graphs with multiple sub-graphs in a very large Database Systems (VLDB) environment with massive parallelism that handle complex data sources..
• Excellent experience in dimensional modeling and data modeling. Deep insight of normalization techniques. Used Erwin tool to define various database objects.
• Good Knowledge of Hadoop
• Over 5 Years of strong experience using Teradata utilities like MLoad, Bteq, and FLoad. Excellent knowledge on Teradata architecture. Used Teradata loader utilities in conjunction with ETL tools (Informatica) and independently designed, developed and maintained ETL process which was loading huge volume of data into teradata using Teradata loader utilities
• 3+ years of IBM DB2 UDB experience in SQL, performance tuning, indexing, reorg and hinting..
• Used PL/SQL scripts to a greater extent. Created stored procedures and functions, used triggers.
• Excellent knowledge and working experience in UNIX commands (Sun Solaris). Proficient in shell scripting. Proficient with Load Balancing and clustering of the system. Involved in filesystem management
• Worked on complete software development life cycle (SDLC) starting from information strategy planning, requirement analysis, design, development, coding, testing, debugging, performance tuning and implementation to production support.
• Good knowledge of working with Mainframe files and XML files
• Thorough knowledge and experience in implementing data warehousing concepts like SCD, CDC, and dimensional modeling (Star and Snowflake schema). .
• Knowledge of Version Control tool Clear Case, CVS and defect tracking tools like Clarify and Clear Quest.
• Good knowledge of Testing Methodologies.
• Strong communication skills, systematic approach, and quick adaptability to new technologies and new working environment.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 5x/6x/7x/8x/9x, Informatica Data Analyzer and Data Quality Abinitio Co-op 2.13/2.14/3.02 GDE 1.13/1.14/3.0.2

OLAP Tool: Cognos 7.x, 8x, Business Objects XI.

Modeling Tool: Erwin V7

Scheduling: Redwood Cronacle, Autosys

Languages: UNIX Shell Scripting, PL/SQL, SQL*Plus

Databases: Oracle 8i/9i/10g, Teradata V2R5/R6/R13.5, DB2 UDB, MS SQL Server 2005

Operating System: Win 95/98/2000 Professional/XP/2003, UNIX (Sun Solaris),AIX 5.3

Others: Toad 7.x, AQT, Rapid 7.5.5,Sql-Developer

PROFESSIONAL EXPERIENCE

Confidential, Holmdel NJ

Informatica Architect/Developer

Responsibilities:

• Understand client business strategy and develop technical roadmap to support that business strategy.
• Used Data Quality to analyze and enhance the quality of data. To identify and remove duplicate using workbench plans.
• Involved in designing dimensional data model for building the Data warehouse.
• Created low level design(Source-Target relationship) and High level design(Functional Specification) for creating the Mappings/Reports.
• Lead and guide development of an Informatica based ETL architecture.
• Used various transformation connected Join, lookup, filter. Created mapplets. Used parameters and variables wherever required. Utilized user defined functions in coding
• Importing metadata from sources such 1as data modeling tools, databases, files
• Analyzing metadata to design new metadata custom interface extending existing system
• Designed/developed Mappings and Workflows for Extraction Transformation and loading of data from source to target
• Performed Unit testing and performance tuning of the code. Debug and troubleshoot production issues
• Involved in code migration to different environment for QA and Prod environments
• Performed design review/code reviews and ensure all the solutions are aligned to pre-defined architectural specifications
• Assume ownership and accountability for the assigned deliverables thru all phases of the Development lifecycle

Environment: Database - Teradata 13.10, Oracle11g Tools - Informatica 9.1, IDQ 9.1 Unix scripts

Confidential, Franklin Lakes NJ

Sr. Informatica Developer

Responsibilities:

• Understand client business strategy and develop technical roadmap to support that business strategy.
• Used Data Quality to analyze and enhance the quality of data. To identify and remove duplicate using workbench plans
• Involved in discussion and decision of data model.
• Co-ordinate with other source teams, DBAs and reporting teams.
• Designed/developed Mappings and Workflows for Extraction Transformation and loading of data from source to target
• Used active and passive transformations for coding
• Performed Unit testing and performance tuning of the code .Debug and troubleshoot production issues
• Involved in code migration to different environment for QA and Prod environments
• Performed design review/code reviews and ensure all the solutions are aligned to pre-defined architectural specifications

Environment: Database - DB2, Tools - Informatica powercenter 8.6,IDQ-8.6 Mainframe Files Unix scripts

Confidential, Deerfield, IL

ETL Architect/Developer

Responsibilities:

• Analyzed data using Abinitio data profiler to estimate different Patterns of data, identifying duplicates, frequency, consistency, accuracy, completeness and integrity of data.
• Created low level design (Source-Target relationship) and High level design (Functional Specification) for creating the Graphs/Reports.
• Co-ordinate/Assign tasks to the offshore team for on time delivery of the requirements.
• Designed, developed and unit tested Abinitio graphs for Extraction, Transformation and Loading of data from source to target.
• Designed and developed Plans using Conduct IT for screduling the Graphs to create a logical unit
• Used EME Technical Repository Management console to Manage the objects in EME
• Maintained metadata in EME and designed parameter driven graphs. Tuned graphs for better performance.
• Extensively used various source systems like flat file, Input table, and Output table and transform components like Joiner, Lookup, Reformat, Filter by expression, Reformat and other components.
• Generously used MLOAD and FLoad Teradata utilities to load the data
• Involved in unit testing, integration testing and troubleshooting.
• Provided pre and post production as well as QA support. Prepared Scripts for UAT.
• Tagged objects and created save files for migrating objects from one environment to another

Environment: Database - Teradata, Tools - Abinitio 3.02/ Abinitio Data Profiler/Abinitio Conduct IT, Erwin

Confidential, Jersey City, NJ

Abinitio Architect/Lead Developer

Responsibilities:

• Initiate meetings and closely worked with Business Users/Business Analysts in getting functional knowledge and drafted the functional and data requirements for the ETL/QA team.
• Created dimensional modeling and data modeling of the warehouse . Used Erwin to define various database objects and referential integrity.
• Extensively used various source systems like flat file, Input table, and Output table and transform components like Joiner, Lookup Filter, Router and other components Workflow session.
• Responsible for coordinating with DBA for initial setup as well as throughout the project requirements and with change management team for code promotion.
• Used File Transmission Protocol(FTP)
• Involved in Capacity planning, resource allocation and dependency analysis.
• Co-ordinate/Assign tasks to the offshore team for on time delivery of the requirements.
• Involved in developing UNIX Korn Shell wrappers to run various Scripts.
• Involved in unit testing, integration testing and troubleshooting.
• Provided pre and post production as well as QA support. Prepared Scripts for UAT.

Environment: Database - IBM DB2, Tools - Informatica 8.1, Java Engine, Erwin and O/S - AIX, Windows XP Reporting: Business Objects.

Confidential, Omaha, NE

Informatica Lead

Responsibilities:

• Closely worked with Business Users/Business Analysts in getting functional knowledge and developed detail design, strategies for ETL processes.
• Involved in Capacity planning, resource allocation and dependency analysis.
• Co-ordinate with the offshore team in on time delivery of the requirements.
• Involved in dimensional modeling and data modeling of the warehouse as a Junior Architect.
• Designed, developed and unit tested mappings for Extraction, Transformation and Loading of data from source to target.
• Tuned mappings for better performance.
• Extensively used various source systems like flat file, Input table, and Output table and transform components like Joiner, Lookup Filter, Router and other components Workflow session.
• Involved in developing UNIX Korn Shell wrappers to run various Scripts.
• Involved in unit testing, integration testing and troubleshooting.

Environment: Database - IBM DB2, Tools - Informatica 8.1, Java Engine, Erwin and O/S - AIX, Windows XP Reporting: Business Objects.

Confidential, SFO, CA

ETL Lead

Responsibilities:

• Requirement analysis and creation of ETL specifications.
• Guided the team in designing and developing ETL graphs using abinitio for creating csv file and modified the existing graph to accommodate non supplier information.
• Deeply involved in data modeling using Erwin.
• Utilized Teradata utilities and performance tuned the database.
• Inserted the last used card value and other values for the online use.
• Created graph level parameters to co-ordinate with the java properties file for automation.
• Unit testing and integration testing of data samples.
• Tuned graphs for better performance. Created functional and unit test cases and executed the same.
• Post-production support.

Environment: Database - DB2 UDB, Teradata Tools - AQT, Abinitio 1.13, Java Engine and O/S - UNIXWindows XP

Confidential

Responsibilities:

• Loading data into various target locations for deals from various banks.
• Certification of new bringons (new member banks).
• Creating a status report of all the deals.
• Ad-hoc requests and troubleshooting the system.

Environment: Database - DB2, Tools - AQT, and O/S: UNIX, Windows XP.

Confidential, Milwaukie

ETL Developer

Responsibilities:

• Created transformations and complex mappings for data loading from relational and flat file source into teradata targets using Teradata loader utilities.
• Created sessions, tasks and workflows by using Informatica workflow manager.
• Used transformations like unconnected lookup, joiner, expression…
• Created parameter files and shell script.
• Created B-teq Scripts and used utilities MLOAD and FLOAD.
• Unit testing and integration testing of data samples.
• Performance tuning of mappings. Creating functional and Unit test cases, executing the same.
• Post-Production Support.

Environment: Database - Oracle 9i/10g, Teradata, Tools - Informatica 8.1, Toad, Cognos Report Net, and O/S - UNIX, Windows XP.