SUMMARY:

• More than 10 years of IT experience in the DWH designing, ETL, OLAP, Data Analysis, Design, Development, Implementation, Testing and trouble shooting of DW.
• 10 + years of technical hands - on experience in development of Data warehousing solutions using Confidential Datastage 9.1/Informatica Power Center 8.5.1(Workflow Manager, Workflow Monitor, Repository Manager, Designer -- Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, and Transformation Developer), Informatica Data Mart, ETL, OLAP, ROLAP, MOLAP, OLTP, Star/Snowflake Schema, Autosys.
• Strong expertise as solution architect designing and delivering solution deployment architecture, Infrastructure sizing, performance and scalability options, benchmarking & tuning (application, database and hardware) for test, development and production environment
• Hands on experience in all aspects Software Development Life Cycle (SDLC).
• Experience in Optimizing the Performance and Oracle/Teradata database/application tuning.
• Worked with Dimensional Data warehouses in Star and Snowflake Schemas, created slowly growing target mappings, Type1/2/3 dimension mappings.
• Experience in design of logical and physical data modeling using Erwin.
• Expertise in using Teradata utilities like Fload, Mload and TPT to load Data from external files to Teradata DB.
• Experience in integration of various data sources Multiple Relational Databases like Oracle,
• Developed Batch Jobs using UNIX Shell scripts (csh, bash, ksh) to automate the process of loading, pushing and pulling data from & to different servers.
• Excellent verbal and communication skills, has clear understanding of business procedures and ability to work as an individual or as a part of a team.

TECHNICAL SKILLS:

DWH/BI Tools: IBM Datastage 9.1,Datastage Administrator,Datastage director,Informatica PowerCenter 8.6.1/8.5.1/8.1 (Source Analyzer, Data Warehouse Designer, Mapping Designer, Mapplet, Transformations, Workflow Manager, Workflow Monitor, Worklets), Informatica Data Analyzer 8.6/8.5/8.1, Informatica Power Connect, Data cleansing, OLAP, ROLAP, MOLAP, Autosys, Control M, Star Schema, Snowflake Schema, OLTP, SQL*Plus, SQL*Loader.

Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin 7.2/7.0, Visio 2003, Oracle Designer, PL/SQL Developer 5.1.4. Dimensional Data Models /, 3rd NF, TOAD.

Databases: Oracle 11g/10g/9i,MS SQL 7.0, SQL Server 2008/2005, MS Access, Teradata 13.10.

Programming: C, C++, SQL, PL/SQL, ANSI SQL, T-SQL, SQL*Plus 3.3/8.0, Java 1.4, HTML, UNIX Shell Scripting.

Environment: UNIX, Windows 2008/7/XP, WinNT4.0, MS DOS 6.22.

PROFESSIONAL EXPERIENCE:

Confidential

ETL SOUTIONS ARCHITECT

Responsibilities:

• Provided leadership and direction to project team by understanding business processes, gathering requirements, identifying potential usability issues, managing scope, and ensuring that an appropriate level of application quality was maintained at all times.
• Used Confidential Infosphere 9.1 (DataStage, QualityStage, Information Analyzer and IGC)
• Developed a number of jobs using Confidential Datastage 9.1,Datastage director to load data from relational and flat file sources into the ATM data marts.
• Created Project,users,folders and assigning the privileges to them for the Security also administration of repository using Confidential DS Administrator.
• Used various debugging techniques to debug the Datastage jobs.
• Used SCD stages, transformer, sequence generator and other stages to implement slowly changing dimension (SCD) and extensively worked to tune performance on the stages like Lookup, Aggregator, Sorter, sequence generator.
• Migrating the jobs and job sequencers from DEV server to QA Server,UAT server.
• Automated the ETL Process and scheduling jobs during night time.
• Directed the software development efforts of 2 senior developers and 4 junior developers and provided mentoring to prepare them for taking on more responsibility at the end of the project.
• Created Data Warehouse Data Modeling used by Erwin 9.0.
• Coordinated with the client and gathering the User requirements.
• Extensively worked with the dimensional data modeling methodology Star, Snow Flake or hybrid data model based on the business requirements.
• Created the Entity Relationship for the Facts and Dimensions for the Data Modeling Design.
• Created high-level process flow diagram using MS Visio.
• Used various Index techniques to improve the DS job performance.
• Done Various Performance Tuning of SQL and worked with DBA for table partitioning and high volume of data efficiently.
• Created Materialized views in ORACLE for refreshing the data.
• Developed parameter variables files to filter the daily data from the source system.
• Creating Test cases for Unit Test, System Integration Test and UAT to check the data quality.
• Did the Root cause Analysis to find the problem.

Environment: IBM Datastage 9.1, Datastage Administrator,Datastage director, Cognos 10.2, Flat files. Oracle 11i, SQL Server 2008,Erwin, MS Visio, SQL Developer, Windows 2007, PL/ SQL, SQL, SQL*Plus.

Sr. ETL/TERADATA CONSULTANT

Responsibilities:

• Worked with Boeing EFDW team in analysis and design of the EFBI - CLAS data mart to migrate data into Teradata.
• Worked on Boeing data standards, Teradata structures and DWH design documents.
• Participated in Project plan, Time estimations and Resource allocation estimations.
• Performed Data profiling of data model from existing Oracle environment to proposed Teradata model 3NF
• Analysis of BI impacts based on Teradata implementation
• Creating Logical(LDM), Extended Logical (ELDM) and Physical Data Model (PDM) using ER Studio 9.0 with respect to Teradata based on the existing data model.
• Creating Analysis and design documents with data models and approaches required to get the data population
• Created/Tested/Reviewed ETL Mappings(Informatica) with Source systems Ordering, Customer profiles, Partner Profiles to the destination data mart.
• Extensively used Export and Import utilities and Teradata FastExport, MultiLoad, Tpump in Data Migration
• Develop Views/indexing strategies for Tables / Materialized Views in Teradata environment.
• Designing joining indexes if required for simple fact tables exists in Data mart.
• Performance tuning of BI queries and data population jobs.
• Collecting stats on tables, indexes and join columns and automating the stats collections.
• Automating the skew factor analysis job to alert any SKEWED table in TD.
• Prepared project deliverables documents like Design recommendations & Enhancements, Design issues and resolutions.
• Worked with offshore team on daily through meetings, working sessions and meetings .

Environment: Teradata 13.0, Confidential Datastage 9.1,Workflow Manager, Workflow Monitor, Sharepoint, Putty, PL/SQL Developer V7, Oracle 10g, Erwin 7.2, UNIX, Toad 9.0.

Sr. INFORMATICA/ETL DEVELOPER

Responsibilities:

• Requirement gathering and Business Analysis.
• End-to-end ETL development of the Premium Module Data Mart.
• Involved in the full life cycle development of the project including: Design, development, and testing.
• Designed and developed Informatica Data Quality (IDQ) for data analysis, data cleansing, data matching and exception handling.
• Responsible for Informatica production support operations to distribute and assign internal on-call production support.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Designed the ETL processes using Informatica to load data from Mainframe DB2, Oracle, SQL Server, Flat Files, XML Files and Excel files to target Teradata Warehouse database.
• Parsing high-level design spec to simple ETL coding and mapping standards..
• Responsible for designing and developing Schemas using Entity Relationships, Data Modeling, Normalizing the relations, creating Tables, Views, Indexes, Sequences and coding.
• Designed and developed Work closely with DBA for installation, upgrades & troubleshooting on Informatica Mapping.
• Created and Monitored Workflow using Workflow Manager and Workflow Monitor.
• Collaborated with Informatica Admin in Process of Informatica up gradation from power center 8.1 to power center 8.5.1.
• Extensively involved in capturing the incremental changes in the source systems for updating in the staging area and data warehouse respectively
• Used pmcmd commands for interacting with Informatica, especially to invoke and run sessions.
• Designed and developed Logical/physical Data Model, Forward/Reverse engineering Using Erwin 7.2
• Involved in Loading XML incremental and full data files into Staging Area and Warehouse with Business Rules. Involved in the Development of informatica mappings and also tuned them for Optimum performance, Dependencies and Batch Design.
• Extensively used ETL to load data from XML source feed from vendor and Flat Files to Staging area using Informatica PowerCenter 8.5.1 Worked with pre and post sessions, and knowledge of identifying facts and dimensions tables.
• Worked extensively with XML source, modified XML source definition, redefined entity relationships and hierarchy relationships, created new views, and created a custom XML source definition to accept new XML structural layout.
• Designed and developed database/application support for a number of business-critical applications, which are coupled to Microsoft SQL Server database.

Environment: Informatica Power Center 8.5.1,Terdata 13.0, Workflow Manager, Workflow Monitor, Informatica Power Connect / Power Exchange, Data Analyzer 8.1, PL/SQL Developer V7, Oracle 11/10g, SAP R3, Erwin 7.2, UNIX, Toad 9.0.

ETL DEVELOPER

Responsibilities:

• Involved in the full life cycle development of the project including: Design, development, and testing.
• Responsible for Informatica production support operations to distribute and assign internal on-call production support.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Parsing high-level design spec to simple ETL coding and mapping standards..
• Responsible for designing and developing Schemas using Entity Relationships, Data Modeling, Normalizing the relations, creating Tables, Views, Indexes, Sequences and coding.
• Designed and developed Work closely with DBA for installation, upgrades & troubleshooting on Informatica Mapping.
• Created and Monitored Workflow using Workflow Manager and Workflow Monitor.
• Collaborated with Informatica Admin in Process of Informatica up gradation from power center 8.1 to power center 8.5.1.
• Extensively involved in capturing the incremental changes in the source systems for updating in the staging area and data warehouse respectively
• Used pmcmd commands for interacting with Informatica, especially to invoke and run sessions.
• Designed and developed Logical/physical Data Model, Forward/Reverse engineering Using Erwin 7.2
• Involved in Loading XML incremental and full data files into Staging Area and Warehouse with Business Rules. Involved in the Development of informatica mappings and also tuned them for Optimum performance, Dependencies and Batch Design.
• Extensively used ETL to load data from XML source feed from vendor and Flat Files to Staging area using Informatica PowerCenter 8.5.1 Worked with pre and post sessions, and knowledge of identifying facts and dimensions tables.
• Worked extensively with XML source, modified XML source definition, redefined entity relationships and hierarchy relationships, created new views, and created a custom XML source definition to accept new XML structural layout.
• Designed and developed database/application support for a number of business-critical applications, which are coupled to Microsoft SQL Server database.

Environment: Informatica Power Center 8.5.1, Workflow Manager, Workflow Monitor, Informatica Power Connect / Power Exchange, Data Analyzer 8.1, PL/SQL Developer V7, Oracle 11/10g, SAP R3, Erwin 7.2, UNIX, Toad 9.0.

Informatica Developer

Responsibilities:

• Worked on performance tuning for ETL processes.
• Interacted with business community and gathered requirement based on changing need. Incorporated identified factor into Informatica Mapping to build Data Warehouse.
• End-to-end ETL development of the Premium Module Data Mart.
• Designed and developed Star and Snow Flake Schema in Data warehouse.
• Used Informatica Designer to create complex mapping using different transformation like filter, lookups, stored procedure, joiner, update strategy, expressions and aggregator transformation to move data to a Data warehouse.
• Worked closely with the business analyst’s team in order to solve the problem Tickets, Service Request.
• Designed and developed Experience with Informatica Power Center Mapping, Data Cleansing, Matching, Data Profile, Change Data Capture and Power Exchange, Metadata Repository.
• Provide technical support and training to internal users of Data Mining products.
• Extracted data from shipping department to flat files and load the data to the Teradata database.
• Designed and developed Informatica Mappings to load data from Source systems to ODS and then to Data Mart.
• Responsible for designing Worked on Informatica Power Center 8.5.1 - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer.
• Translated business requirement to technical specifications and developed Informatica mapping/Workflows.
• Used Windows Scripting and Scheduled pmcmd to interact with Informatica Server from command mode.
• Used ETL to extract and load data from Global Repositories, Folders, Permission and user using repository manger.
• Maintaining source definitions, transformation rules and targets definitions using Informatica Repository Manager.

ETL Developer

Responsibilities:

• Developed various Sessions, Batches for all Mappings for loading from Source flat files, tables to Target tables.
• Worked on performance tuning for ETL processes.
• Created complex mappings using Unconnected, Lookup, and Aggregate transformations for populating target table in efficient manner.
• Extraction, Transformation and Load was performed using Informatica Power Center to build the data Mart.

Environment: Informatica Power Center 6.2, Oracle 8i, PL/SQL, Erwin 3.5, Windows 2000.