Title: ETL Informatica Developer
Primary Skills: ETL, Informatica, Data warehousing, Oracle and Shell scripting.

PROFESSIONAL SUMMARY

• Over 7 years of IT expertise in Analysis, Design, Development, Implementation, Testing and Production Support for Data warehousing applications.
• Experience in all aspects of project development life cycle in the areas of business analysis, development, testing, deployment and documentation.
• Over 6 years experience in Informatica Power Center (versions 8.6/8.5/8.1/7.1/6.2), client tools like Designer, WorkflowManager, and WorkflowMonitor.
• Involved in Installation & upgrade of Informatica Power center from version 6.x. to 7.x and also from 7.x to 8.x.
• Extensively worked on dataintegration from enterpriseapplications like financials, Human Resources, Customer and Sales Management Systems.
• Strongdatabase experience in Oracle 9i/8.x/7.x, MS Sql server 2000, Teradata V2R6/V2R5, DB2 and Mysql.
• Extensive experience with Data Extraction, Transformation, and Loading (ETL) from disparate Data sources like Multiple RelationalDatabases. Worked on integrating data from flat files, CSV files, and XML files into a common reporting and analytical Data Model.
• Expertise in Performance Tuning using best practices of avoiding network connections, distributing session load by using multiple servers, optimizing overall session performance.
• Expertise in handling high volumesof data on daily basis and loading millions of data into data warehouse in a given load window.
• Expertise in PL/SQL development and SQL Query tuning for better performance.
• Expertise in development of stored procedures and functions to develop business rules.
• Good grounding on the OLAP, DSS tools like Business Objects, Cognos and MicroStrategy.
• Extensively worked on scheduling and DWH batch processing of workflows.
• Experience in development, architecture and migration of ETL environment, Informatica, Database objects.
• Involved in jobs scheduling, monitoring and production support in a 24/7 environment.
• Excellent communication skills and Ability to work in-groups as well as independently.
• TECHNICAL SKILLS

Data Warehousing
Informatica Power Center 8.x/7.x/6.2/, Power Connect 7.x
Databases
Teradata V2R6/V2R5, Oracle 10g, 9i/8.0/7.x, MS SQL Server 2000/2005, MS Access 7.0, DB2 iSeries
Data Modeling
CA Erwin 4.0/3.5.5/3.5.2, Microsoft Visio.
Business Intelligence
MicroStrategy 8.0.1/8.1.1, Business Objects 6.x/5.x and Cognos
Programming
SQL, PL/SQL, UNIX Shell Scripting, Perl scripting, Java, J2EE, JSP, HTML and XML
Environment
UNIX flavors HP-UX and Sun OS, Linux (RHEL 4.1/3.1) Windows 2000/2003/XP
Scheduling tools
Autosys, Informatica Scheduler and CTRL-M.

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville, FL Mar 2011 - Till Date
ETL Production Support

Confidential, expands the use of its Teradata(R) data warehouse in order to address new business initiatives requiring analysis of enterprise information.
Informatica enables Bank of America to improve visibility into compliance activities across the business, while reducing risk with timely and trusted data. BOA has already standardized on the Informatica Platform to successfully support multiple business objectives, including improved decision-making, attracting and retaining customers, and M & A activity. The logical step was to use Informatica technology again to connect these disparate and fragmented sources of information and create an automated, comprehensive, and consistent AML system across all business lines.
Responsibilities

• Interacted with Business System Analyst and end users on a regular basis for analyzing business process and capturing accuratebusinessrequirements.
• Extensively used Informatica Power center providing the integration platform to allow more efficient detection, investigation, and reporting of suspected money laundering activity
• Worked effectively in Business solutions enabling the bank to source new data 50% more quickly using the Informatica platform from Oracle Source Systems.
• Reduced amount of false hits and time spent on false hits, freeing up more time to review the quality alerts
• Saved time, reduced staff costs, and efficiently managed risk by isolating unusual behaviors and reducing false positive alerts
• Created several Informatica mapping to populate data from 17 source system banking interface points to Target Oracle Mantas Anti Money Laundering solution
• Involved in performance tuning and fixed most of the bottlenecks for the processes which are already running and got better performance.
• Worked on Parameterize of all variables, connections at all levels.
• Developed Informatica mappings, enabling the ETL process for large volumes of data into target tables.
• ETL process identified the datadiscrepancies in source systems and significantly reduced annual commodity costs.
• Used Informatica designer for designingmappings and mapplets to extract data from Oracle sources.
• Used Various Transformations like Expression, Filter, Router, Joiner, Look Up, and Update strategy, Source Qualifier in many mappings.
• Invoked Perl scripts through windows or Unix scripting from Informatica command task for achieving file manipulations
• Extensively worked on scheduling and DWH batch processing of workflows through AutoSys.
• Supported the overall production system, by being available across 24/7 supporting over 30 bank applications and providing quick abend resolutions making the production readily available without any downtime.

Environment
Informatica Power Center 8.6, ETL, Oracle 9i, DB2, AS400, Business Objects, Oracle 10g/9i/8i, HP - Unix, Sun OS, Erwin, PL/SQL, Autosys

Confidential, Jackson, MI Dec 2010 - Feb 2011
ETL Informatica Consultant

Confidential,. supplies a complete line of quality, consistent mixes, bases, icings, glazes, fillings, frozen dough, par-baked and fully baked products and equipment to the food industry, worldwide. Informatica was used to manage global inventory, facilitate and optimize manufacturing processes and control the distribution supply chain.
Responsibilities

• Involved in the full life cycle following waterfall methodology - 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 Business intelligence database.
• Interacted with Business System Analyst and end users on a regular basis for analyzing business process and capturing accuratebusinessrequirements.
• Created numerous Informatica Mappings to populate the data into different star and snowflake schemas.
• Involved in performance tuning and fixed most of the bottle necks for the processes which are already running and got better performance.
• Worked on Parameterize of all variables, connections at all levels.
• Developing code to extract, transform, and load (ETL) data from inbound flat files and various databases into various outbound files using complex business logic.
• Developed Informatica mappings, enabling the ETL process for large volumes of data into target tables.
• ETL process identified the datadiscrepancies in source systems and significantly reduced annual commodity costs.
• Used Informatica designer for designingmappings and mapplets to extract data from Oracle sources.
• Used Various Transformations like Expression, Filter, Router, Joiner, Look Up, and Update strategy, Source Qualifier in many mappings.
• Translation of Business processes into Informatica mappings for building Data marts.
• Extensively used Perl scripting in Informatica Pre-session and Post session scripts.
• Invoked Perl scripts through windows or Unix scripting from Informatica command task for achieving file manipulations
• Extensively worked on scheduling and DWH batch processing of workflows
• Using Informatica Power Center 8.6, the previously refreshed weekly data was refreshed on a daily basis despite a tenfold increase in the users accessing data.

Environment
Informatica Power Center 8.6, ETL, DB2, AS400, Business Objects, Oracle 10g/9i/8i, HP - Unix, Sun OS, Perl scripting, Erwin, PL/SQL, Autosys

Confidential, Madison, WI Mar 2010- Nov 2010
ETL Informatica Consultant

Confidential, is one of the largest and most diversified health maintenance organizations in USA, DHP offers its customers an extensive network of more than 2,000 practitioner, 80 clinics sites, and 26 plan hospitals. DHP originally used informatica technology to help build a data warehouse, using this integration technology, which quickly became the tool of choice whenever a data movement project was needs. Power Center 8.5 supports multiple environments and offers one, single platform for all enterprise data integration needs. DHP currently benefits form one integrated claims administration system that supports everything from membership, pricing management and medical management to customer service correspondence.

Responsibilities

• Involved in understanding and writing ETL specifications from the System Analyst's business explanation of the process.
• Closely worked with Data Architects while designing data models and interpreting the dependencies.
• Created detail design documentation describing code development, ETL logic, Testing, Changes and corrections.
• Extensively involved in the migration of Healthcare data from incumbent mainframe environment to EDS metavance System (based on Oracle).
• Using Power Center 8.5 for conversion of the data, transforming, reconciling the different data types and delivering that data to the New Claims system decreasing the risk and also minimizing the errors associated.
• Designed ETL logic and implemented complex mappings for slowing changing dimensions type 2 target tables and change data capture methodologies.
• Designed and developed processes to handle high volumes of data and high volumes of data loading in a given load interval.
• Developed reusable informatica objects like transformations and global shortcuts for effective ETL environment.
• Extensively used ETL to load data from multiple sources to Staging area (Oracle 9i) using Informatica Power Center Worked with pre and post sessions, and extracted data from Transaction System into Staging Area.
• Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level. Created different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank,Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator.
• Used Debugger to test the data flow and fix the mappings.
• Tuned the workflows and mappings. Executed Workflows and Sessions using Workflow Monitor.
• Used Informatica designer for designing mappings and mapplets to extract data from Oracle sources.
• Used Various Transformations like Expression, Filter, Router, Joiner, Look Up, and Update strategy, Source Qualifier in many mappings.
• Created workflows using Workflow manager for different tasks like sending email notifications, timer that triggers when an event occurs, and sessions to run a mapping.

Environment
Informatica Power Center 8.5, ETL, MicroStrategy, Oracle 10g/9i, MS Sql server 2000, Teradata V2R6 as IDW, HP - Unix, Linux, Erwin, PL/SQL, Autosys for scheduling.

Confidential, Hudson, OH May 2009 - Feb 2010
ETL Developer
Confidential, is a specialty retailer of crafts and fabrics based in Hudson, OH. It operates the retail chains Jo-Ann Fabrics and Jo-Ann Etc. Jo-Ann Fabrics is a leading national specialty retailer of crafting, decorating and sewing products. Informatica is used for reducing the cost of data storage, lowering application total cost of ownership, improving performance, mitigating risk and ensuring regulatory compliance. ETL integrates information from various systems to help buyers, merchandisers, marketers, finance professionals and other corporate personnel conduct price optimization, category management, inventory analysis and markdown analysis.
Responsibilities:-

• Interacted with business user groups through facilitated meetings understanding the business process.
• Extracted data from different sources like flat files, Oracle, DB2, and Teradata and loaded them into DB2 enterprise Data Warehouse.
• Involved in regular log and trace checks of files to make sure that any problems requiring action are not neglected.
• Extensively worked with Source Analyzer, Warehouse Designer, Transformation designer, mapping designer and Workflow Manager.
• Developed data Mappings between source systems and warehouse components
• Created various Transformations like Joiner, Aggregate, Expression, Lookup, Filter, Union, Update Strategy, Stored Procedures, and Router etc. and Fine-tuned the mappings for optimal performance.
• Developed and modified many scripts using Ksh scripting in VI editor.
• Knowledge on UNIX shell command in scripting such as ssh, scp, mailx etc
• Made use of System variables (SYSDATE), Mapping parameters and variables in the transformations within a mapping. Employed variable functions (like SetMaxVariable) to manipulate mapping variables and parameter files to initialize mapping parameters.
• Coordinating with the DBA's for managing the databases in different environments for UAT and system testing, also involving with DBA's during the release nights and troubleshooting with any of the production problems.
• Worked with testing team in trouble shooting the defects in application.
• Used informatica as a tool for the test data preparation in various environments
• Involved in performance tuning of SQL Queries adding indexes, mapping, having files locally avoiding network connections and avoiding/correcting transformation errors in a mapping.
• Providedon-call supportfor thenightly loadprocess that execute from midnight to early morning 6 a.m.

Environment: Informatica Power Center 7.1.1, Oracle 10g, 9i/8i, Teradata V2R6, Micro Strategy, MS Sql server 2000, Trillium, HP Unix, Perl scripting and Windows 2000, Erwin 4.2, PL/SQL.

Confidential, CA July 2008- Feb 2009
Data Analyst/ Jr ETL Developer

Adverb Media acquired by Confidential, is the world-class email communication solutions provider of enterprise market information solutions for the clients like Sony Pictures, Cars Direct, America West Airlines, US airways, Time Inc and Venetian. The initiatives are focused on improving the marketplace information to provide faster, more accurate, and more actionable market information to its customers globally.

Responsibilities

• Based on the requirements created Functional design documents and Technical design specification documents for Extraction, Transformation and Loading.
• Design and development of ETLsolutions in Informatica Power Center 7.1
• Understanding various source systems in FSP SAP R/3, JD Edwards AS400 and Oracle Financials data.
• Saved time, reduced staff costs, and efficiently managed risk by isolating unusual behaviors and reducing false positive alerts
• Reduced amount of false hits and time spent on false hits, freeing up more time to review the quality alerts
• Developed mapping based on Functionalmodules developed by ABAPdevelopers and closely co-coordinated with them in migrating the data to staging tables using Informatica Power connect adaptor.
• Extensively worked on BAPImappings and RFC enabled functional modules using Informatica Power connect adaptor.
• Developed Informatica mappings, enabling the ETL of the data into target tables.
• Created Workflow to schedule the loads at required frequency using Workflow Manager.
• Associated with Productionsupport team in various performancesrelatedissues.

Environment:
Informatica Power Center 7.1.1, ETL, Business Objects 6.x, Oracle 9i/8i, Linux (RHEL 4.0), Windows 2000, Erwin 4.2, PL/SQL, UNIX Shell scripting.

Confidential, Fenton, MO Jan 2007 - June 2008
Data Warehouse Developer

Claims Management System
Confidential, is a global insurance organization serving businesses and individuals with a wide range of insurance products and insurance-related services. It has wide range of Insurance Products. Claims Management System provides the technology that assists claim professionals in administering claim practices in a timely and effective manner. This application involves in designing and development of the Data Warehouse. Claims Data Warehouse built on Oracle using Informatica.

Responsibilities:

• Involved in Analysis, Requirements Gathering and documenting Functional & Technical specifications
• Analyzed and created Facts and Dimension tables.
• DesignedERdiagrams, logicalmodel (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning and object creation) for Oracle as per business requirements using Erwin
• Used DB2, legacy systems, Oracle, and Sybase sources and Oracle as target.
• Developed InformaticaPowerCentermappings for data loads and data cleansing.
• Wrote stored procedures in PL/SQL and Unix Shell Scripts for automated execution of jobs
• Wrote Shell Scripting for Informatica Pre-Session, Post-Session Scripts.

Environment:
Informatica, Oracle, PL/SQL, Cognos Impromptu 6.0, Cognos Power Play 6.6, Oracle 9i, Erwin 4.0, UNIX, Windows NT.

Confidential, Kansas City, KS Jan 2005 - Dec 2006
Jr Data Analyst

The project was to design, develop and maintain a data warehouse to understand the client needs, undertake trend analysis, provide better customer service and assess current and future profitability, Cross-sell products to increase revenue generation from the most profitable customers.

Responsibilities:

• Understanding the Businesssystems to answer old business questions.
• Analyzing and data profiling the SourceData that causes problems in the downstream.
• Uncovering simpler ways of performing operations.
• Discovering datapatterns by going through large datasets and huge volumes of data
• Build new reports that provide end-user business questions answered.
• Modify existing report to correct longstanding problems
• Quick understanding of the business requirements and ability to convert into data fields for appropriate usage.
• Design SQL Queries for different legacydatabases using multipleBIpackages
• Presentation of reports to customers and clarify any questions that they may have.

Environment:
Oracle 8i, Oracle XML publisher, PL/SQL, TOAD

EDUCATIONAL SUMMARY

• Diploma of Advanced Computing
• Bachelors of Microbiology (Life Sciences)

References: Available on request.