PROFESSIONAL SYNOPSIS:

• 7 years of Data Warehousing experience in Analysis, Design, development and implementation of Data warehousing solutions using Informatica Power Center as an ETL Autosys as a Scheduling and OBIEE as a reporting tool.
• Working experience in using Informatica Power Center to create and schedule workflows which will reduce manual intervention.
• 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 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 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.
• Power Center Mapping Design Certification.

TECHNICAL SKILLS

ETL/Scheduling: Informatica Power Center 9.01/8.6.1,Autosys 4.5

OLAP/DSS Tools: OBIEE 10

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

BI Technical Analyst

Confidential, Louisville, KY

Administration:

• Install Informatica 9.0 on a Solaris OS.
• Creating Folders and manages user and user group access to objects based on LDAP settings.
• Creating SR 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 all databases required for development, testing, education and production usage.
• Performs the capacity planning required to create and maintain the databases.
• Work with UNIX / DB2 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 deployments as well as probably Unix Shell Script and Database DDL deployments
• Write Repository Queries in support of developments and Production statistics.
• 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.

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

Sr.ETL Developer

Confidential, Orange, CA

Responsibilities

• 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, Business Objects, Oracle 10g/9i,IBM DB2 UDB V9.0, IBM - AIX Unix, Erwin.

Confidential

Sr.ETL Developer

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 and Teradata Utilities like Mload TPump.

Confidential

ETL Developer

Responsibilities:

• The goal of the project is to migrateall systems likecase, claims, billing and loss processing etc. to correspondingUSAA systems. Each system is interdependent on the other. The migrated data will be fed to the existing data warehouse with USAAsystem.
• Responsibilities:
• Created the design documents and technical specifications based on the Mapping requirements between the two systems.
• Designed Source to Target mapping from primarily Flat files, Oracle using Informatica Power Center
• Various kinds of transformations were used to implement simple and complex business logic. Transformations used are: Connected & Unconnected Lookups, Router, Expressions, Source Qualifier, Aggregator, Filter, Sequence Generator, etc.
• Created and Configured Sessions to load the data in to target tables.
• Automated Batch and Session schedule using PMCMD and Unix Shell scripts.
• During development, used Workflow Manager to schedule and run batches and sessions as well as to check session logs and other session related activities.
• Troubleshoot problems by checking sessions and error logs. Also used debugger for complex problem troubleshooting.
• Interacted with metadata to trouble shoot session/batch related issues as well as global performance issues. Tuning of Applications using Explain Plan and SQL TRACE.
• Coordinated with testing team in all three phases of testing and their end-to-end testing.
• Shared the development effort to design the audit control mechanism to track the defects
• Wrote number of stored procedures to validate the complex mappings and automated the validation process.
• Maintained different versions of technical specifications in PVCS and mappings and promptly resolved and gave explanations for defects assigned from business users as well QA team through test director.

Environment Informatica Power Center 8.1.1, Cognos, Oracle 10g/9i, DB2 UDB V8.x, IBM - AIX UNIX, Erwin.

Confidential

ETL Development t

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.