SUMMARY

• 10 plus years of experience in DW/BI Architect, Analysis, Development, and Implementation of business applications including Development and Design of ETL methodologies using Informatica Power Center in various domains like Financial, Insurance, and Banking sectors.
• Over 9 years as a ETL Developer in designing and implementing Data Mart / Data Warehouse applications using INFORMATICA Power Center 9.x /8.x / 7.x (Designer, Workflow manager, Workflow monitor and Repository Manager)
• Designed and developed Complex mappings from various Transformations like re - usable transformations, and Mappings/Mapplets, Unconnected / Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more, mappings using Stored Procedure’s, Normalizer, XML, External Procedure.
• Good knowledge on SDLC (software development life cycle) and good experience with unit testing and integration testing.
• Preparing the High level Design Specifications for ETL Coding and mapping standards.
• Experience in Performance tuning of targets, sources, mappings and sessions.
• Experience in integration of various data sources like Oracle, SQL server and MS access, flat files, and XML files.
• Experience in Ralph Kimball Methodology, Logical Modeling, Physical Modeling, Dimensional Data Modeling, Star Schema, Snowflake Schema, FACT tables, Dimension tables
• Experience in working in ERWIN tool for data modelling
• Experience in working as DW/BI architect role in a development project for one of the client
• Expertise in OLTP/OLAP System study, developing Database schemas like star schema, snow flake schema Dimensional Data Modeling used in relational, dimensional modeling and slowly changing dimensions (SCD’s).
• Very good exposure to Oracle 10g, 9i, IBM DB2 databases.
• Strong expertise in Relational data base systems like Oracle 8i/9i/10g, SQL Server 2000/2005, MS Access, design and database development using SQL, PL/SQL, SQL PLUS, TOAD,SQL LOADER.
• Knowledge of reporting tool like Crystal reports, and Business Objects.
• Experience inInformaticaDACTool for Customizing Data warehouses and Creating Task and Task Groups in it.
• ETL experience in development of mappings and tuned existing mappings for better performance using InformaticaPowerCenter as per the business rules.
• Expertise in writing Oracle PL/SQL Stored Procedures/Functions/Packages and cursors Triggers.
• SQL Tuning and creation of indexes for faster database access, better query performance in Informatica by creating Explain Plan, SQL hints for query and indexing the required columns.
• Develop, execute ETL test plans, Document ETL processing and generate required metadata.
• Develop a transformation by marking the relevant data directly on a sample of the data source, and mapping that data to a chosen XML schema
• Experience with UNIX commands, VI editor and writing Shell scripts.
• Experience in creating reports using Oracle Business Intelligence 10x

PROFESSIONAL EXPERIENCE

Confidential, CA

ETL Tech Lead

Responsibilities:

• Worked with customers, end-users, technical architects, and application designers to define the data requirements and structure for Business Intelligence (BI) applications.
• Designed models for the data warehouse or data mart (data structure, storage, and integration)
• Had a good experience working with different kinds of data sources like Excel, Flat file, DB tables,
• Responsible for design, development and maintenance of ETL processes to populate warehouse.
• Lead the database analysis, design, and build effort.
• Created complex mappings in Power Center Designer using Expression, Filter, Sequence Generator, Update Strategy, Joiner and Stored procedure transformations.
• Cleansed the source data, extracted and transformed data with business rules, and built reusable mappings, known as ‘Mapplets’ using Informatica Designer.
• Daily, Weekly and Monthly processing of the farmers EDBI applications
• Maintenance activities of the farmers EDBI application (FDR, MLCDM, AOI, HOI, HGDM, SABER).
• Demonstrated expertise utilizing ETL tools, including Informatica and ETL package design, and RDBMS systems like MYSQL, Oracle.
• Analyzed the source data coming from Oracle ERP system to create the Source to Target Data Mapping in INFORMATICA.
• Worked with developers to design and improve complex SQL queries so they are optimized
• SQL development of queries, optimization, reporting & schema creation
• Designed maps of source system data to data warehouse models
• Developed strategies for data acquisitions and integration of the new data into Domo's Data engine.
• Access Box Folders and pulling data directly from them at run time.
• Monitor performance and tune databases to optimize for different workloads
• Conducted Post deployment analysis on production server for the new changes.
• Present defect report to the higher management.
• Developing Procedures and Functions in PL/SQL.
• Using Procedure Components to invoke Oracle PL/SQL Procedures.
• Optimizing and Tuning SQL queries and PL/SQL blocks to eliminate Full Table scans to reduce Disk I/O and Sorts.
• Used UNIX to create Parameter files and for real time applications and developed shell scripts.
• Performing Data Masking for preserving the referential integrity of the user data.
• Performing Data Encryption on user data and client data for maintaining consistency and security.
• Load balancing of ETL processes, database performance tuning and capacity monitoring.
• Involve in Unit testing and System testing of the individual.
• Analyze existing system and developed business documentation on changes required.

Environment: Informatica Power center 9.5.1, DB2, TOAD, MYSQL, UNIX.

Confidential, DENVER

ETL Tech Lead

Responsibilities:

• Worked as a data warehouse architect in initial stages of this project.
• Used ERWIN tool for performing data modelling activities
• Worked with business directly to understand the requirement and providing the solution and architecture of the data flow from source to target
• Responsible for design, development and maintenance of ETL processes to populate warehouse.
• Lead the database analysis, design, and build effort.
• Created complex mappings in Power Center Designer using Expression, Filter, Sequence Generator, Update Strategy, Joiner and Stored procedure transformations.
• Cleansed the source data, extracted and transformed data with business rules, and built reusable mappings, known as ‘Mapplets’ using Informatica Designer.
• Worked with developers to design and improve complex SQL queries so they are optimized
• SQL development of queries, optimization, reporting & schema creation
• Designed maps of source system data to data warehouse models
• Developed strategies for data acquisitions and integration of the new data into Domo's Data engine.
• Monitor performance and tune databases to optimize for different workloads
• Conducted Post deployment analysis on production server for the new changes.
• Present defect report to the higher management.
• Developing Procedures and Functions in PL/SQL.
• Using Procedure Components to invoke Oracle PL/SQL Procedures.
• Optimizing and Tuning SQL queries and PL/SQL blocks to eliminate Full Table scans to reduce Disk I/O and Sorts.
• Used UNIX to create Parameter files and for real time applications.
• Developed shell scripts.
• Load balancing of ETL processes, database performance tuning and capacity monitoring.
• Involve in Unit testing and System testing of the individual.
• Analyze existing system and developed business documentation on changes required.
• Worked in data modelling using ERWIN tool

Environment: Informatica Power center 9.1.1, DB2, TOAD, PL/SQL, AB INITIO, UNIX

Confidential, PITTSBURGH

Sr. ETL Developer

Responsibilities:

• Responsible for design, development and maintenance of ETL processes to populate warehouse.
• Lead the database analysis, design, and build effort.
• Created complex mappings in Power Center Designer using Expression, Filter, Sequence Generator, Update Strategy, Joiner and Stored procedure transformations.
• Cleansed the source data, extracted and transformed data with business rules, and built reusable mappings, known as ‘Mapplets’ using Informatica Designer.
• Worked with developers to design and improve complex SQL queries so they are optimized
• SQL development of queries, optimization, reporting & schema creation
• Designed maps of source system data to data warehouse models
• Developed strategies for data acquisitions and integration of the new data into Domo's Data engine.
• Monitor performance and tune databases to optimize for different workloads
• Conducted Post deployment analysis on production server for the new changes.
• Developing Procedures and Functions in PL/SQL.
• Using Procedure Components to invoke Oracle PL/SQL Procedures.
• Optimizing and Tuning SQL queries and PL/SQL blocks to eliminate Full Table scans to reduce Disk I/O and Sorts.
• Used UNIX to create Parameter files and for real time applications.
• Developed shell scripts.
• Work on the scheduler tool like DAC (Dynamic Access Controller) to schedule and monitor the Informatica jobs
• Work on the reporting tool like OBI
• Created simple and complex universes through OBI in alignment of the business requirement
• Load balancing of ETL processes, database performance tuning and capacity monitoring.
• Involve in Unit testing and System testing of the individual.
• Analyze existing system and developed business documentation on changes required.

Environment: Informatica Power center 8.6.1, TOAD, PL/SQL, DAC, OBIEE

Confidential

Sr. ETL Developer

Responsibilities:

• Responsible for design, development and maintenance of ETL processes to populate warehouse.
• Lead the database analysis, design, and build effort.
• Created complex mappings in Power Center Designer using Expression, Filter, Sequence Generator, Update Strategy, Joiner and Stored procedure transformations.
• Cleansed the source data, extracted and transformed data with business rules, and built reusable mappings, known as ‘Mapplets’ using Informatica Designer.
• Worked with developers to design and improve complex SQL queries so they are optimized
• SQL development of queries, optimization, reporting & schema creation
• Designed maps of source system data to data warehouse models
• Monitor performance and tune databases to optimize for different workloads
• Conducted Post deployment analysis on production server for the new changes.
• Load balancing of ETL processes, database performance tuning and capacity monitoring.
• Involve in Unit testing and System testing of the individual.

Environment: Informatica Power center 8.6.1, PL/SQL

Confidential

ETL Developer

Responsibilities:

• Responsible for design, development and maintenance of ETL processes to populate warehouse.
• Lead the database analysis, design, and build effort.
• Created complex mappings in Power Center Designer using Expression, Filter, Sequence Generator, Update Strategy, Joiner and Stored procedure transformations.
• Cleansed the source data, extracted and transformed data with business rules, and built reusable mappings, known as ‘Mapplets’ using Informatica Designer.
• Worked with developers to design and improve complex SQL queries so they are optimized
• SQL development of queries, optimization, reporting & schema creation
• Designed maps of source system data to data warehouse models
• Developed strategies for data acquisitions and integration of the new data into Domo's Data engine.
• Monitor performance and tune databases to optimize for different workloads
• Conducted Post deployment analysis on production server for the new changes.
• Developing Procedures and Functions in PL/SQL.
• Using Procedure Components to invoke Oracle PL/SQL Procedures.
• Optimizing and Tuning SQL queries and PL/SQL blocks to eliminate Full Table scans to reduce Disk I/O and Sorts.
• Used UNIX to create Parameter files and for real time applications.
• Developed shell scripts.
• Work on the scheduler tool like AUTOSYS to schedule and monitor the Informatica jobs
• Involve in Unit testing and System testing of the individual.
• Analyze existing system and developed business documentation on changes required.

Environment: Informatica Power center 8.6.1, PL/SQL, AUTOSYS, SQL SERVER

Confidential, CA

ETL Developer / Production support executive

Responsibilities:

• Worked with customers, end-users, technical architects, and application designers to define the data requirements and structure for Business Intelligence (BI) applications.
• Designed models for the data warehouse or data mart (data structure, storage, and integration)
• Had a good experience working with different kinds of data sources like Excel, Flat file, DB tables, Cloud Based Folders.
• Responsible for design, development and maintenance of ETL processes to populate warehouse.
• Lead the database analysis, design, and build effort.
• Created complex mappings in Power Center Designer using Expression, Filter, Sequence Generator, Update Strategy, Joiner and Stored procedure transformations.
• Cleansed the source data, extracted and transformed data with business rules, and built reusable mappings, known as ‘Mapplets’ using Informatica Designer.
• Daily, Weekly and Monthly processing of the TFS DW BI applications
• Maintenance activities of the TFW DW BI application (ONE SOURCE, INSURANCE, RMS, DRS).
• Demonstrated expertise utilizing ETL tools, including Informatica and ETL package design, and RDBMS systems like Oracle.
• Analyzed the source data coming from Oracle ERP system to create the Source to Target Data Mapping in INFORMATICA.
• Worked with developers to design and improve complex SQL queries so they are optimized
• SQL development of queries, optimization, reporting & schema creation
• Designed maps of source system data to data warehouse models
• Monitor performance and tune databases to optimize for different workloads
• Conducted Post deployment analysis on production server for the new changes.
• Present defect report to the higher management.
• Developing Procedures and Functions in PL/SQL.
• Using Procedure Components to invoke Oracle PL/SQL Procedures.
• Optimizing and Tuning SQL queries and PL/SQL blocks to eliminate Full Table scans to reduce Disk I/O and Sorts.
• Used UNIX to create Parameter files and for real time applications.
• Developed shell scripts.
• Performing Data Masking for preserving the referential integrity of the user data.
• Performing Data Encryption on user data and client data for maintaining consistency and security.
• Load balancing of ETL processes, database performance tuning and capacity monitoring.
• Involve in Unit testing and System testing of the individual.
• Analyze existing system and developed business documentation on changes required.

Environment: Informatica Power center 8.6.1, HYPERION SYSTEM 9, AUTOSYS, TOAD, UNIX