SUMMARY:

• Over 12+ years of IT experience with specialization in Data Warehousing, Decision support Systems and extensive experience in implementing Full Life cycle Data Warehousing Projects.
• Strong ETL experience using Informatica PowerCenter 8.x/7.x/6.x/5.x (Repository Manager, Designer,oracle, Teradata, Workflow Manager, Workflow Monitor), Mappings, Mapplets, Transformations.
• experience in Informatica, Business Intelligence, TERADATA, Oracle, DB2 and Netezza POC development and also has very good experience to create new TERADATA DATABASE and corresponding roles, functional ID and Grants on complete environments setup.
• Strong skills in IBM - Ascential DataStage 8.X 7.5/7.0/6.0(DataStage Enterprise Edition(PX)& Server Edition), SQL, PL/SQL, Stored Procedures and Triggers, Performed Debugging, Troubleshooting and performance tuning.
• Extensive experience in extraction, transformation and loading of data directly from different heterogeneous source systems like flat files, Excel, Oracle, SQL Server.
• Developed complex mappings in Informatica & Datastage to load the data from various sources into the Data Warehouse, using different transformations/ Stages like Joiner, Transformer, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter, Source Qualifier, Stored Procedure transformation etc.
• Expertise in tuning existing mappings, identifying and resolving performance bottlenecks at various stages.
• Extensive experience in designing and developing jobs using DataStage Designer, Data Stage Manager, and DataStage Director.
• Thoroughly proficient in SQL and PL/SQL development in Oracle 8i/9i.
• Expertise in Data Modeling, Designing of Logical and Physical datamarts.
• Experienced in designing and writing on-demand UNIX shell scripts.
• Exceptional analytical and problem solving skills. Good team player with the ability to communicate effectively at all levels of the development process.

TECHNCIAL SKILLS:

ETL: Informatica 8.x/7.x/6.x/5.x, TERADATA, Oracle, DB2 and Netezza POC

Databases: Oracle 10g/9i/8i/7.x,Teradata, DB2 UDB 8.2/7.2/6.1, MS Access

Operating Systems: IBM AIX 5.2/5.1, SunOS 5.8, SuSe Linux V9.0, Windows XP/NT/2000/98

BI TOOLS: Siebel Analytics 7.x, Business Objects 5.x, 6.x, Cognos Impromptu 6.0/7.0/7.1, Cognos Power Play 6.0/7.0/7.1, and Crystal Reports 9.0.

Languages: C, C++, Visual Basic, SQL, PL/SQL, Pascal, FORTRAN and COBOL

Version Controls: Rational Clear Case, CVS and DataStage Version Control

WORK EXPERIENCE:

Confidential, Chicago, IL

Senior Data warehouse Developer/ Analyst

Responsibilities:

• Managing high caliber offshore development team and ensured all the development work meets business requirements and is delivered as per the plan.
• Involved in implementing of integrated enterprise data management system (GoldenSource) for org level, pricing and securities Reference Master Platform.
• Worked on enriching the master data platform from various internal and external (Reuters, Anna, CRS, Cusip, Bloomberg, etc.) data sources.
• Designed and built daily FX rates distribution process (Master to downstream consumers).
• Helped with coordinating data requirements from master data platform for downstream consumers with stewardship for various projects.
• Involved in designing and developing of new Informatica process and also re-used lot of existing objects.
• Designed and built end-to-end orchestration process for key projects which helped analysts (end-users) in getting the required data near real-time.
• Migrated over one Terabyte of data from old to new Reference Data Management (Oracle DB) and addressed all the performance issues while loading the data.
• Helped Architecture and DBA team with Oracle CDC setup.
• Built Oracle CDC Monitoring and Archiving/Purging process for audit data on various DBs.
• Involved in monitoring File System and DB storage (High Watermark/ Online Shrink).
• Involved in maintenance/enhancements and production support for various projects.
• Worked on lot of ad-hoc request from users (one time load, export/import of data, data quality).
• Highlighting Key Risks\\Issues across Onsite & Offshore team and working with the team to resolve them.

Environment: Informatica Power Center 8.1/8.6, GoldenSource, Autosys, Oracle 10g, SQL, PL/SQL, SQL * Loader, SQL Navigator, Business Objects, Erwin, Test Director, CVS, Agile development methods.

Confidential, Lake Forest, IL

Senior ETL Tech Lead & Architect, Data Analyst and Onsite Coordinator

Responsibilities:

• Aided in the design and development of the logical and physical data models, business rules and data mapping for the Enterprise Data Warehouse system.
• Involved in Design and development of Data Marts for specific Business aspects which include Policy, Claim, Enterprise Billing and eQuote .
• Worked with Business Users and designed report layouts
• Developed and implemented ETL (Extract, Transform and Loading) Components based on the filter rules to obtain needed data from different source systems for calculating required metrics using Informatica Power center, UNIX, PL/SQL.
• Worked on Informatica - Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformation Developer.
• Fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
• Worked extensively with mappings usingexpressions, aggregators, routers, lookupandproceduresto develop and feed Data Mart.
• Scheduled Sessions and Batches on the Informatica Server using Informatica Server Manager/Workflow Manager.
• Modified and tested PL/SQL stored procedures.
• Developed UNIX Korn shell scripts to load the flat files from the source system into the tables in staging area.

Environment: Informatica Power Center 6.1/5.1 (ETL), Oracle 9i, DB2/UDB, UNIX AIX, Unix Shell Scripting, PL/SQL, SQL, PVCS, TOAD, ERWIN

Confidential, Melrose Park, IL

Module Leader/ Technical Lead/ Onsite Coordinator

Responsibilities:

• Assisted in gathering business requirement from end users.
• Coordinated tasks with onsite and offshore team members in India.
• Developed Shared Containers for reusability in all the jobs for several projects.
• Used stages like Transformer, sequential, Oracle, and Hash for Lookup, Aggregator, Folder,
• Worked with Metadata Definitions, Import and Export of Datastage jobs using Data stage Manager.
• Involved in creating different projects parameters using Administrator.
• Used Datastage Director for running, monitoring and scheduling the Jobs.
• Used Audit Sequence Jobs to run Each and Every DataStage job which generates Audit key which will be used in Audit purpose.
• Familiar with import/export of DataStage Components (Jobs, DSRoutines, DSTransforms, Table Definitions etc.) between DataStage Projects, use of DataSet Management (DSM) utility and multiple job compile utility with use of Data Stage Manager.
• Used Shared container for simplifying design and easy maintenance purpose.
• Experienced in fine tuning, Trouble shooting, bug fixing, defect analysis and testing of DataStage Jobs.
• Used Unix shell scripts to invoke DataStage jobs from command line.
• Involved in Unit testing, Functional testing and Integration testing. Designed the Target Schema definition and Extraction, Transformation and Loading (ETL) using Datastage.
• Developed SQL queries to performed DDL, DML, and DCL.

Environment: IBM WebSphere DataStage EE/7.0/6.0 (Manager, Designer, Director, Administrator), Ascential ProfileStage 6.0, Ascential QualityStage 6.0, Erwin, TOAD, Autosys, Oracle 9i, PL/SQL, SQL, Unix Shell Scripts, Sun Solaris, Windows 2000.

Confidential, Bloomington, IL

Informatica Developer

Rsponsibilities:

• Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements.
• Used PL/SQL features such as stored procedures, functions, packages and database triggers for maintaining complex integrity constraints and implementing the complex business rules.
• Responsible for extracting, transforming and loading data Using UTL FILE, SQL LOADER.
• Tuned SQL queries and performed refinement of the database design leading to significant improvement in system response time and efficiency.
• Involved in writing Unix Shell Scripts.
• Responsible for Unit level testing, Module level testing and Application testing.

Environment: Oracle 9i, UNIX Shell Scripting, SQL Loader, PL/SQL, TOAD, Windows 2000, UNIX.

Confidential

Informatica Developer

Responsibilities:

• Participated in all aspects of the software development Life cycle, design the solution, present for design review, develop code, perform unit/integration testing and support the product by serving as the top-tier customer support.
• Responsible for writing PL/SQL packages, procedures, functions and triggers.
• Improved application performance by tuning SQL statements and fixing proper indexes, Designed data models.
• Involved in writing Unix Shell Scripts.
• Responsible for extracting, transforming and loading data Using UTL FILE, SQL LOADER.
• Responsible for writing test plans and testing procedures.

Environment: Oracle 8i, Erwin, UNIX Shell Scripts, PL/SQL, TOAD, Windows 2000, UNIX.

Confidential

Informatica Developer

Responsibilities:

• Gathered business requirements from Business Analyst.
• Designed and implemented appropriate ETL mappings to extract and transform data from various sources to meet requirements.
• Designed and developed Informatica ETL mappings to extract master and transactional data from heterogeneous data feeds and load
• Installed and Configured the Informatica Client tools.
• Worked on loading of data from several flat files to XML Targets.
• Designed the procedures for getting the data from all systems to Data Warehousing system.
• Created the environment for Staging area, loading the Staging area with data from multiple sources.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Created UNIX shell scripts for Informatica ETL tool to automate sessions.
• Monitored sessions using the workflow monitor, which were scheduled, running, completed or failed. Debugged mappings for failed sessions.

Environment: Informatica Power Center 5.1.2/7.1, Erwin 4.5, Oracle 9i, Windows NT, Flat files, SQL, Relational Tools, Clear Case, UNIX (HP-UX, Sun Solaris, AIX) and UNIX Shell Scripts.