SUMMARY:

• Over 9 years of experience in the IT industry with extensive Domain knowledge of Government, Educational and Insurance including experience in using Informatica power center/power mart, Business Objects (Designer, DESKI, WEBI, CMC).
• Over 8+ years of extensive database experience and highly skilled in databases like Oracle (12c,11g, 10g), MS SQL Server (2005), Teradata (v2r6.0), Flat Files, XML Files, MS Access.
• Extensive Knowledge in system analysis, Design, Developing Implementation and testing of ETL solutions using Informatica Power Center.
• Expertise in Data Warehousing concepts like Bill Inmon methodology and Ralph Kimball methodology, fact tables, dimension tables.
• Extensively used Informatica, directly responsible for the Extraction, Transformation & Loading of data from multiple sources into Data Warehouse.
• Highly Proficient in Informatica Designer Components like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation Developer (Re - usable Transformations), Workflow Manager and Workflow Monitor.
• Expertise in gathering the business requirements and building Universes in the Designer, retrieving data using Universes, Personal data files, Stored procedures, Free hand SQL methods and creating complex Reports using data access and report design using Web Intelligence modules.
• Worked on Business Objects functionalities like Queries, Slice and Dice, Drill Down, Custom sorts, Cross Tab, Master Detail and Formulae.
• Skilled in SQL, PL/SQL, SQL*Plus, TOAD, UNIX, Shell Scripting on UNIX systems.
• Sound knowledge in Performance Tuning of Data warehouse bottlenecks.
• Experience in setting up Autosys job scheduler for automation of UNIX Shell Scripts.
• Hands on experience in Production Support and Maintenance.
• Excellent Interpersonal Skills with the ability to work independently and with the Team.

TECHNICAL SKILLS:

Languages: C, SQL, PL/SQL, T-SQL.

Database: Oracle 12c/11g/10g MS SQL Server 2014/2008/2005/2000.

ETL Tools: Informatica Power Center 10.1.0/9.1.0/9.0.1/ 8.6.1/8.1.1 /7.1.2

BI Tools: Business Objects XI 4.1/4.0/3.1/R3/R3.1/R2 (UDT/IDT, Web Intelligence, Info View, CMC, Designer, and Desktop Intelligence).

Operating Systems: Windows 2000/ NT/ XP/Vista, UNIX.

Data Modeling Tools: Erwin 3.5.2/4.0/4.1 , Microsoft Visio.

Utilities: Microsoft SQL Server Management Studio, Oracle SQL Developer, TOAD, Rapid SQL, SQL*LOADER

Development Tools: Visual Studio 2008/2005.

Job Scheduling: Informatica Scheduler, Control M, CA Autosys.

PROFESSIONAL EXPERIENCE:

Confidential, Omaha, NE

Sr. Data warehouse Developer

Responsibilities:

• Gathered Requirements from users, translated user inputs into ETL design documents.
• Worked with users closely to understand, Analyze and Estimate the effort that needs to go into the project.
• Analyzed data to convert from old system (Core Link) to new system (Health Edge).
• Communicated with End Users, Vendors and Business Teams to help them understand the transformation of data from old system to new system.
• Worked with multiple teams to address any data issues.
• Created STT documents to convert old requirements work per new system.
• Analyzed and worked with data delivery team closely to get it right.
• Developed mappings and reusable Transformations for ETL using Informatica Power Center.
• Performed Unit testing of Informatica ETL process to ensure ETL logic.
• Monitor and communicate the availability of Informatica Environment.
• Follow-up on tickets and fixing the issues.
• Provided end user support and problem resolution for various issues related to ETL.

Environment: ETL-Informatica - 10.1.0/9.1.0. Power Center (Metadata Repository, Designer, and Workflow Manager), SQL Server 2008, SQL, PL/SQL, Microsoft SQL Server Management Studio, Erwin, Microsoft Tools (excel, Visio etc.).

Confidential, Madison, WI

Sr. Data warehouse & Reporting Analyst

Responsibilities:

• Gathered Requirements from users, translated user inputs into ETL design documents.
• Worked with users closely to understand, Analyze and Estimate the effort that needs to go into the project.
• Developed mappings and reusable Transformations for ETL using Informatica Power Center.
• Performed Unit testing of Informatica ETL process to ensure ETL logic.
• Monitor and communicate the availability of Informatica Environment.
• Creating Cherwell tickets for moving the code to production and to schedule the jobs using Control-M as per the calendar.
• Follow-up on tickets and fixing the issues.
• Creating Business Objects Universe and reports as per user requirements.
• Created Predefined conditions, Prompts and Custom Hierarchies in the process of building the universes.
• Several simple, complex and Ad-hoc reports were created having Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae.
• Developed and scheduled WebI reports.
• Manually scheduling the recurring reports.
• Deployed Business Objects Universes and Reports in a Secure Environment from One Server to Other Servers using Import Wizard.
• Managing Users, Groups and their access privileges on the documents.
• Involved in migration of reports from testing environment to production environment using Import Wizard.
• Resolving tickets opened by users for BO Production issues as well as access related issues.
• Started using Tableau and explored different functionalities to create dashboards for better visualization.
• Provided end user support and problem resolution for various issues related to ETL and BO.

Environment: ETL-Informatica - 10.1.0/9.1.0. Power Center (Metadata Repository, Designer, and Workflow Manager), Business Objects 4.1/4.0, Tableau, Control-M (7.0.00), Cherwell, Oracle 12g/11g, SQL, PL/SQL, Data Studio, SQL Developer, Erwin, Microsoft Tools (excel, Visio etc.).

Confidential, Madison, WI

Sr. Data warehouse & Reporting Analyst

Responsibilities:

• Gathered Requirements from users, translated user inputs into ETL design documents.
• Developed mappings and reusable Transformations for ETL using Informatica Power Center.
• Worked extensively on different types of Informatica transformations like expression, filter, router, aggregator, update strategy, lookup, sequence generator and joiner.
• Used Informatica features to implement Type II changes in slowly changing dimension tables.
• Performed Unit testing of Informatica ETL process to ensure ETL logic.
• Created command files and used Control-M for running the jobs to make sure all dependencies (mappings) are in good shape before moving the code to production.
• Performance tuning of the Informatica mappings using various components like Parameter files and Variables
• Monitor and communicate the availability of Informatica Environment.
• Creating Tivoli tickets for moving the code to production and to schedule the jobs using Control-M as per the calendar.
• Follow-up on tickets and fixing the issues.
• Created Predefined conditions, Prompts and Custom Hierarchies in the process of building the universes.
• Manually scheduling the recurring reports.
• Deployed Business Objects Universes and Reports in a Secure Environment from One Server to Other Servers using Import Wizard.
• Managing Users, Groups and their access privileges on the documents.
• Involved in migration of reports from testing environment to production environment using Import Wizard.
• Resolving tickets opened by users for BO Production issues as well as access related issues.
• Experiences with creating reports include formatting options such as Charting, Mapping, Grouping, Sorting, Alerting and Field highlighting.
• Production Support as required both during and after normal business hours.

Environment: ETL-Informatica - 9.1.0/9.0.1. Power Center (Metadata Repository, Designer, and Workflow Manager), Business Objects, Control-M (7.0.00), Tivoli, Oracle 11g, SQL, PL/SQL, Erwin, Microsoft Tools (excel, Visio etc.).

Confidential, Phoenix, AZ

Sr. ETL Developer

Responsibilities:

• Gathered Requirements from users, translated user inputs into ETL design documents.
• Developed mappings and reusable Transformations for ETL using Informatica Power Center.
• Reviewed source systems and proposed data acquisition strategy.
• Designed, Developed, Tested and Implemented Informatica mappings, sessions and Workflows for extracting the data from the multiple legacy systems and to load EDM tables.
• Extensively used PL/SQL programming in procedures to implement business rules.
• Created complex mappings using expression, Unconnected Lookup, Sorter, Normalizer, Union, Aggregator, Dynamic Lookup and Router transformations for populating target table in efficient manner.
• Involved in performance tuning of SQL Queries, Sources, Targets and sessions.
• Configured workflows with Email task, Control task, Event-Raise task, Event-Wait task, Timer task, Command task, Assignment task and decision tasks.
• Created complex mappings to load data from various sources into Oracle and XML files.
• Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.
• Monitor and communicate the availability of Informatica Environment. Follow-up on tickets and fixing the issues.
• Interacted with Business Users (SME’s) to gather and analyze the Business Requirements to build the reporting applications.
• Designed, Developed and Maintained Universes by defining joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies.
• Drill filters, report level filters, sections, breaks, crosstabs and merged dimensions have been implemented on the Web intelligence reports.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation of the daily loads and process flow of the mappings and development of Ad hoc Reports.

Environment: ETL-Informatica - 9.0.1/8.6. Power Center (Metadata Repository, Designer, and Workflow Manager), Business Objects, Oracle 11g, SQL, PL/SQL developer, Tivoli, Erwin, Microsoft Tools (excel, Visio etc.).

Confidential

Data Warehouse Consultant

Responsibilities:

• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Developed complex mappings using multiple sources and targets in different databases, flat files.
• Used Informatica 8.1.1 to extract, transform and load data from different input sources like flat files and XML files into Oracle 10g database.
• Worked on Informatica Power Center components- Source Analyzer, Data warehousing designer, Mapping Designer and Transformations.
• Used various transformations like unconnected lookup, connected lookup, aggregator, rank, joiner, stored procedure.
• Performed Unit testing of Informatica ETL process to ensure ETL logic.
• Worked with the Production Support team to create reusable ETL solutions to achieve enormous improvements.
• Assisted in the process of preparation of documenting Informatica transformation Development Standards.
• Promoted Informatica mappings from development to test to production environment.
• Experience in setting up Autosys job scheduler for automation of UNIX Shell Scripts.
• Involved in discussions with BO developer to find and reduce the complexities in building the BO reports.
• Several simple, complex and Ad-hoc reports were created having Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae.
• Developed and scheduled Full client reports as well as Web I report.
• Provided end user support and problem resolution for various issues related to BO

Environment: Informatica Power Center 8.6.1/8.1.1 , Business Objects XI R2, IDQ, Erwin 4.1, PL/SQL, Oracle 10g, TOAD, UNIX, Microsoft Visual Studio, Autosys, Windows XP.