PROFESSIONAL SYNOPSIS:

• 8 years of Data Warehousing experience as a lead in Installing, Upgrade, administer, Analyze, Design, development and implementation of Data warehousing ETL solutions using Informatica Power Center, Power Exchange, Data Quality Tools.
• I am Informatica 8 Version Certified developer.
• Experience in Configuring Oracle Business Intelligence of Enterprise Applications, Knowledge in DAC Client/Server installation and configuration. Experience in creating Metadata Objects and Web Catalog Objects (Dashboards, Pages, and Reports) using Admin Tool and Siebel Analytics Web.
• Creating and configure connections for ODBC, ORACLE, SDFC, SQL Server and FTP Connections on Informatica PC.
• Creating/managing OBIEE repository, Intelligent Dashboards, Answers, Delivers and IBots to create alerts based on results.
• Experience in creating Metadata Objects and Web Catalog Objects (Dashboards, Pages, and Reports) using Admin Tool and Siebel Analytics Web.
• Experience on assigning Data security & UI level security to the users using OBIEE repository objects & external database.
• Used Informatica Power Center to build new agent data warehouse by following slowly changing dimensions (SCD) type II process.
• Creating Data maps through Power Exchange Navigator which will access all the VSAM, SEQ Files from the mainframe environment.
• Writing Unix shells to automate the Informatica weekly repository back up process for the restoration in case of crashes.
• Working experience in using Informatica Power Center to create and schedule workflows which will reduce manual intervention.
• Automate the weekly repository backups, archiving logs and remove unnecessary caches to free up the space on the file system.
• Experience in design and development of decision support systems (DSS) and experience in Release management and Production Deployment activities, Production support.
• Working on automated regression testing with each release into production which involved in creating some UNIX Scripts and coding some Informatica Mappings to compare the data Quality and release it to end the users.
• Working on Audit Balance and controlling the jobs to make sure of not dropping transactions during our ETL using automated shell scripts which will control sending notifications to the support team.
• Experience in integration of various data sources like Oracle, DB2 and Teradata into staging area and also involved in SDLC for the projects.
• Experience in Data warehousing, Data migration and Data modeling
• Data modeling knowledge using Dimensional Data Modeling, Star Join Schema Modeling, Snow - Flake Modeling, FACT and Dimensions Tables.
• Experience in Business Objects5.1 (designer, and reports), data integrator.
• Exposure on Data transformation to create definitions for Unstructured /Complex data, Good Knowledge with B2B Data Exchange.
• As a part of universe development, created classes, different kinds of objects, cardinalities, strategies using designer in business objects.
• Involved in configuration and customization with SF.com
• Designed and developed Informatica Mappings for sales force. Built Informatica mappings to migrate data from Sql server, Oracle and Flat files into sales force Sandbox & production using the Informatica Power Center with sales force power connect adaptor
• Experience in handling with large deployments.
• Successfully performance tuned and maintained ETL applications and SQL databases with significant reduction in the process run time and standardization of the process in production.
• Creating UNIX Shell scripting and supported implementation of automated ETL solutions which included scheduling of jobs with Informatica PMCMD Commands.
• Excellent communication and interpersonal skills
• Consistently provided metrics (effort estimation and tracking on ETL tasks) and status reports for the senior management.
• Known as competent team leader of 5 people with ability to support all the change requests from business sponsors from gathering the requirements, providing estimates through to implementation and UAT.

TECHNICAL SKILLS

ETL/Scheduling: Informatica PC,DQ,PE - 9.1

OLAP/DSS Tools: Oracle Business Intelligence 10x, Business Objects XI 3.1

Database Modeling: Erwin3.5.2/4.0

Databases: Oracle 8i/9i/10g, 11g Teradata, Netezza

DB Tools: Toad, SQL Developer, SQL* plus, SQL* Loader, Import, Export

OS: IBM AIX, Solaris UNIX

PROFESSIONAL EXPERIENCE

ETL Lead and Administration

Confidential, ST Paul, MN

Responsibilities:

• Upgrade the existing version of Informatica 8.6 to 9.1 for all 11 environments.
• Migrating the Informatica 9.1 application onto the new servers and support the testing which involve new installation, profile set up, code migrations, connections, user configurations which should be synced up with the existing system.
• Writing scripts to Schedule weekly domain and Repository backups.
• Provide application support 24/7.
• Coordinating with Business Teams / Functional Subject Matter Experts (SME) to gather Requirements and transforming them into technical specifications for the ETL Designs through which Implement ETL solutions using Informatica Power Center (v8.1.1/8.6.1/(9.0 - Started recently)
• Creating SR’s to Informatica Inc- related to any Power center product issues. As per Fulfillment requests (FR) migration of objects in all phases (DEV, QA and PRD) of project and trained developers to maintain system when in production.
• Involving Testing, Debugging, Validation and Performance Tuning of data warehouse, help develop optimum solutions for data warehouse deliverables.
• Creates and maintains the repository configurations.
• Performs the capacity planning required to create and maintain the databases.
• Work with UNIX / DBA team related to OS and Database related issues.
• Monitoring the Jobs and sever space availability and CPU Process.
• Developed, Modified and Tested UNIX Shell scripts and necessary Test Plans to ensure the successful execution of the data loading process.
• Preparing standard operating Procedures for related Informatica issues.
• Ensures proper configuration of the Power Center Domain components. Experience in nodes, Repository services, Integration services, Reporting Services
• Experience in Create, backup, restore for Informatica Repositories.
• Setup and maintain ETL administration best practices and procedures
• Maintain all necessary updates and/or patches for the ETL environments
• Monitors and tunes ETL repository and system for performance improvements
• Ability to perform root cause analysis, performance monitoring and application related issues
• Handle user access / security role requests for new developers and projects
• Coordinate deployments that include Informatica objects, Unix Shell Script and Database DDL deployments
• Write Repository Queries in support of developments and Production statistics.

Environment Informatica Power Center 9.1, Oracle 11g, IBM - AIX 6.1, SAP Business Objects XI 3.1.

ETL Administration

Confidential, Louisville, KY

Responsibilities:

• Installation of Informatica 9.1 and Autosys 5.0 Instances on a Solaris OS with single node architecture and multiple file systems for different applications.
• Creating Folders and manages user and user group access to objects based on LDAP settings.
• Coordinating with Business Teams / Functional Subject Matter Experts (SME) to gather Requirements and transforming them into technical specifications for the ETL Designs through which Implement ETL solutions using Informatica Power Center (v8.1.1/8.6.1/(9.0 - Started recently)
• Experienced in facilitating deployment of the ETL jobs into the Production environment along with primary production support which involved handling Change Requests and Defect Resolution and testing them thoroughly till the Business user’s certification (UAT).
• Worked extensively to propose some changes to the existing ETL architecture to facilitate the balancing of premiums with the Business financials.
• Worked with multiple Databases like Oracle (8i / 9i) and DB2 (v8.1 / v9.5). Designed automated solutions for ETL using Dynamic SQLs.
• Worked on Performance Tuning and Maintenance of ETL Applications and SQL databases with significant reduction in the process run time and standardization of the process in production which was appreciated by the users who were getting the data within 36 from 48 Hours.
• Automate the production jobs using UNIX Shell scripting and worked to implement automated ETL solutions which include scheduling of jobs with Informatica PMCMD Commands to remove manual dependencies.
• Optimizing/Tuning mappings/sessions, indexing and partitioning for better performance and efficiency to reduce the data latency to be less than 36 Hours and to make sure that the Business IT SLA’s are met with every incremental loads.
• Proposed new solutions to enhance the existing Error handling mechanisms in architecture.
• Experienced in Data profiling using both Tools based (Informatica Data profiling) and customized techniques and worked on different types of sources - Relational, Flat files etc.
• Regularly provided metrics (effort estimation and tracking on ETL tasks) and Status reports for the senior management. Currently handling a team of 5 people and working on all the change requests from business sponserers from gathering the requirements, provide estimates till implementation and UAT.
• Create/Modify Metadata repository (.rpd) as per the data requirements by using Oracle BI Analytics Server Admin tool.
• Worked with Business Groups to identify, analyze, and document Business Requirements.
• Created Business Facts, Dimensions and defined Logical relation between them at the Business model and mapping layer.
• Installing and Configuring Oracle Business Intelligence, both stand-alone & Enterprise Applications, Knowledge in DAC Client/Server installation and configuration.
• Extensively worked on IBots using OBIEE Delivers to create alerts based on results.
• Identified and created aggregate tables to improve query performance.
• Created Aggregate level and level based measures.
• Created Web-groups for security purpose with access privileges.
• Created Dashboards & Answers.
• Involved in setting up ibots to run reports at scheduled time for Cache Seeding to Improve Query Performance using Caching.
• Worked on cache purging strategy using event-polling table cache purging technique.
• Created filters using repository variables, Presentation variables. Also created saved filters that can be reused by multiple reports.

Environment Informatica Power Center 9.0, Oracle 10g/9i, IBM Netezza, IBM - RH - Linux, Siebel Analytics 7.x / OBIEE 10.x, BI Publisher

ETL Lead

Confidential, Orange, CA

Responsibilities Include:

• Involved in full project life cycle - from analysis to production implementation and support with emphasis on identifying the source and source data validation, developing particular logic and transformation as per the requirement and creating mappings and loading the data into BID.
• Extracted the data from Flat files, Oracle, DB2 and load the data into flat files, Oracle and DB2 Using Informatica Power center
• Based on the business requirements created Functional design documents and Technical design specification documents for ETL Process.
• Reviewed data models using Erwin tool to find out data model dependencies.
• Designing and developing ETL solutions in Informatica Power Center
• Designing ETL process and creation of ETL design and system design documents.
• Developing code to extract, transform, and load (ETL) data from inbound flat files and various databases into various outbound files using complex business logic.
• Created automated shell scripts to transfer files among servers using FTP, SFTP protocols and download files from web servers and hosted files.
• Developed Informatica mappings, enabling the extract, transform and loading large volumes of data into target tables.
• Designed and developed process to handle high volumes of data and high volumes of data loading in a given load window.
• Effectively used all the kinds of data sources to process the data and finally creating load ready files (LRF) as out bound files which are inputs to other downstream applications.
• Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, filter, update strategy, Connected and Un-connected lookup, sorter, Normalizer, and sequence generator.
• Created Workflows, Worklets and Tasks to schedule the loads at required frequency using Informatica scheduling tool. Created control files to handle job dependencies.
• Created and Customized Dimensional Hierarchy, Logical columns, Aggregate columns, Levelbased Measures and Aggregate navigations using Business Objects.
• Assisted in performance testing, data quality assessment, support & product deployments.
• Worked on Parameterize of all variables, connections at all levels in UNIX.
• Involved in jobs scheduling and production deployment activities creation of the deployment guide migration of the code to production, monitoring and production support in a 24/7 environment.

Environment Informatica Power Center 8.6,Oracle 10g/9i,IBM DB2 UDB V9.0, IBM - AIX Unix, Erwin.

ETL Designer

Confidential

Responsibilities:

• Developed Mappings & Workflows as per business logic, quality and coding standards prescribed for the module.
• Anticipated and addressed critical issues in a timely and effective manner.
• Used Informatica tool to handle complex Mappings and extensively used the various transformations like Source Qualifier, Aggregator, Lookup, Filter, Expression, Sequence Generator, Normalizer, Union and Sorter etc.
• Built Mapplet, worklets and re-usable transformations.
• Extensively used Teradata loader scripts for bulk load and export utilities like Tpump & Mload.
• Prepared Unit Test Plan (UTP) documents for all the test cases for the developed mappings.
• Performing reviews on peer developed code in later phases.
• Mentoring and assisting team as SME in later phases.
• Interacting with Client Team on weekly calls on progress and deliveries.
• Worked on Teradata SQL Assistant for complex queries in build and test.
• Performed Informatica and Database level performance tuning.
• Worked as only and Primary ASKMIG (Ask Migration Team email group) member from offshore which involved migration of Informatica objects across environments (DEV, TEST, UAT). PROD is handled by On-Shore.
• Rewarded as Subject Matter Expert in AUTO and ComLine.
• Primary SME contact on AUTO and ComLine Subject Area for troubleshooting incase of Job failures in Production for Monitoring member.

Environment Informatica Power Center 8.6.1, IBM - AIX UNIX, Teradata - Mload TPump.

Confidential

ETL Development

Responsibilities:

• Used Informatica Power Center to build new agent data warehouse by following slowly changing dimensions (SCD) type II process.
• Analyzed ETL requirement documents.
• Participated in development phase meetings for business analysis and reviewed requirement documents.
• Performed source system data profiling.
• Used error handling strategy for trapping errors in a mapping and sending errors to an error table.
• Implemented change detection process to send only incremental data for all the subject areas.
• Handled performance issues at various levels such as target, sessions, mappings, and sources.
• Optimized and tuned mappings/sessions, and indexed and partitioned for better performance and efficiency.
• Implemented the session partition strategy to improve the workflow performance.
• Designed the parallel and sequential session workflows and scheduled the workflows and Sessions using the Workflow Manager.
• Created mapping documents and design documents.
• Acted as a key contributor with team to ensure delivery.
• Performance tuned Informatica mappings.
• Defined testing strategy and supported UAT and Regression testing.
• Collaborated with business for queries and clarifications during UAT.
• Performed production implementation of the system.
• Supported post-production activities.

Environment: Informatica Power Center 8.1.1, Oracle 10g/9i, IBM - AIX UNIX.