SUMMARY

• Strong Data Warehousing and ETL experience of over 8 years using Informatica 9.5/9.1/8.6.1/8.5 PowerCenter tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Manager
• Extensively worked with Informatica transformations including Source Qualifier, Router, Lookup, Update Strategy, Expression, Joiner, Procedure and others
• Extensive experience in creating attractive views of OBIEE reports including Pie, Scatter Diagram, Radar, Bar, Pivot Table, Time Series Line, etc.
• Experience in installation and configuration of Oracle BI Apps (right from 7.9.x to 11.1.x) that include Financial, Sales & Marketing domains
• Specialist in OBIEE Upgrade and Patching from previous versions to 11g (11.1.1.7.0 +)
• Proficient in upgrading Informatica / DAC from previous versions (8.x/10.x) to latest versions (9.x / 11.x)
• Designed, implemented and tested Informatica mappings, workflows & sessions from scratch to load datawarehouse with required data according to business requirements
• Configured Informatica mappings to run in full load mode as well as incremental mode
• Expert at root cause analysis of ETL errors using Informatica Session Logs and at resolving performance as well as data issues
• Comfortable working in teams onsite or offshore as well as an individual contributor
• Experience with migrating Informatica repository and setting up multiple environments (QA, STAGE, TEST, DEV, PROD) as per client requirements
• Expert at installing and setting up Databases, Informatica and DAC client and server machines in Windows as well as Linux & Unix enterprise deployments
• Proficient in upgrading Informatica / DAC from previous versions (8.x/10.x) to latest versions (9.x / 11.x)
• Experience in installation and configuration of Oracle BI Apps (right from 7.9.x to 11.1.x) that include Financial, Sales & Marketing domains
• Proficient in performance tuning for Informatica by optimizing the sources targets mappings and sessions
• Substantial experience with Oracle Business Intelligence Enterpise Edition (OBIEE) in addition to Informatica

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.5.1, 9.5.0, 9.1.0, 9.0.1 HF2, 8.6.1, 8.6.0

OLAP Tools: OBIEE 11g, 10g, Oracle BI Apps

RDMS/Databases: Oracle 11g & 10g, SQL Server 2008 & 2012, DB2 9.5

Scripting Languages: SQL, PL/SQL, UNIX Shell Script

Data Base Development Tools: Toad, SQL Developer

Operating Systems: Windows, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential, Emeryville, CA

ETL Architect

Responsibilities:

• Currently single handedly managing entire organization’s ETL Loads to log failures, resolve load fails and ensure data for each day is captured in the required database table partition (24x7 role)
• Hands-on experience in patching OBIEE 11.1.1.7.131017 to 11.1.1.7.141014 and tested the resulting BI System. Extremely confident in patching OBIEE older versions to latest releases using OPatch
• Create complete logic to capture data from Flat Files generated every minute via Web Services into STAGE and then OLAP datawarehouse
• Maintain contact with Oracle for design issues, especially pushing Oracle to provide one-off patches for OBIEE design bugs that would normally be set aside as enhancement requests and dealt with in future versions
• Identified missing constraints on tables (not null, primary keys, unique constraints, etc.) and added the same where required
• Developed reusable Mapplets and Transformations to improve re-usability of Informatica code
• Convert some Informatica logic to database logic to improve performance of ETL Loads (e.g. convert IIF function to DECODE, add stored procedures where more data is involved and so on)
• Analyze performance of Informatica logic against stored procedures performing the same task and decide on the best method to load data into warehouse
• Responsible for extensive analysis of Informatica session logs, identifying performance bottlenecks and tuning ETL mappings, workflows to improve overall ETL performance
• Designed Command Tasks to run commands on Linux where OS level steps were required (e.g. - create flat file name lists, move processed files to archive directory, etc.)
• Extensively used Event Wait tasks to ensure dependent ETL jobs run in sequence
• Ensuring each day’s flat files are processed before the next day’s files start getting processed into datawarehouse
• Responsible for complete scheduling of Informatica jobs 24x7 and maintaining the order of jobs and their dependencies
• Triggered Informatica loads to capture stats of queries made on different music apps
• Monitored loads continuously to log failures, resolve load fails and ensure data for each day is captured in the required database table partition
• Responsible for end-to-end support of ETL environment bringing in 60 GB of new data everyday into the datawarehouse
• Responsible for bringing Informatica loads back to normal after scheduled organization wide outages
• Setup email functionality in Informatica 9.5.0 to send out notifications to users in case of job failures

Confidential, Seattle, WA

Sr. Informatica Consultant

Responsibilities:

• Creatied Informatica users, folders representing subject areas and setup repository permissions for user groups
• Developed Stored Procedures in Oracle
• Imported scattered raw data from flat files and Excel sheets into datawarehouse using Informatica 9.1.0
• Gathered requirements for custom aging algorithms and implemented the same using complex mappings, multiple workflows and sessions with Informatica 9.0.1 HF2 on Oracle database 11g without DAC support
• Customized reconciliation reports for Accounts Payables (AP), Receivables (AR), General Ledger (GL), AP and AR Aging using BI Apps (Financial Analytics) 7.9.6.3 from raw data in Oracle database based on MS Excel versions of the same
• Involved with business users to gather the requirements, had brainstorming sessions with clients to propose ETL model to implement aging calculations into Informatica

Confidential, Plano, TX

Informatica and DAC Upgrade Consultant

Responsibilities:

• Upgraded Informatica Server and Client from 8.6.1 to 9.0.1 HotFix 2
• Involved in the loading and scheduling ETL jobs to be run in the batch loads
• Involved in extensive tuning of Informatica mappings such as increasing DTM Buffer size, allowing more memory for voluminous mappings, dropping and recreating indexes on database tables before and after loads respectively, allowing more memory for lookup caches, eliminating dynamic lookups and so on
• Coordinated with client’s ETL Team and DBAs in finding the sources and targets for data loads into warehouse
• Involved in the preparation of documentation for ETL standards, procedures and naming conventions
• Training client ETL team on standards and best practices as part of project handover
• Create presentation for High Availability configuration in Informatica with Veritas Cluster Server
• Prepared extensive documentation for deploying Informatica 9.0.1 HF2 over Informatica 8.6.1
• Upgraded DAC 10.1.3.4.1 to DAC 11.1.1.6.4 with latest patch
• Part of team during deployment (called to client location)
• Part of testing team for all new releases
• Problem management - Designed SOPs for standard tasks to hand over maintenance to client’s internal Tech team
• Prepared extensive documentation for OBIEE Upgrade using learnings from this assignment

Confidential, Rochester, NY

Informatica Developer

Responsibilities:

• Installed, configured and setup Informatica 9.0.1 HF2 Server repository for BI Apps Sales Analytics 7.9.6.4
• Extensively used Informatica Client Tools - PowerCenter Designer, Workflow Monitor, Workflow Manager and Repository Manager to develop, configure and run mappings, workflows and session tasks between source systems and Warehouse components.
• Extensively used almost all transformations in mappings to take advantage of Informatica functionality
• Created stored procedures to transfer processing of data-heavy tasks to the database, hence prevent back-and-forth with Informatica Server
• Responsible for designing incremental load strategy for client that will load each day’s data every night
• Installed and configured DAC 11.1.1.6.4 with BI Apps Sales Analytics 7.9.6.4
• Applied latest patch to DAC 11g update it to latest binaries
• Worked on customizing out-of-the-box Informatica mappings provided with BI Apps to ensure database table names match with client database, important fields from source database are captured in ETL and loaded into OLAP
• Design, create and tune physical database objects (tables, views) to support logical and dimensional models

Confidential

Datawarehouse Designer

Responsibilities:

• Interacted with various managers and super-users in order to understand the requirements, identify the different modules and different entities in Sales, Revenue and Leads modules
• Generate direct links to OBIEE reports in order to access on a mobile device
• Apply required parameters to each report based on user credentials, position and responsibility
• Designed, implemented and tested Informatica mappings as a part of new approach to load datawarehouse with required data
• Adapted the system to ensure that that the same mappings can be used to load all data from the source system (full) as well as only incremental load that will fetch only update data from source system.
• Identified reusable parts of code inside Informatica mappings and created reusable mapplets, sessions, transformations that can be used in multiple areas.
• Involved in installation and configuring of Informatica, DAC and OBIEE in environments like Development, QA and Production
• Maintained dependencies between data load tasks to ensure that tasks run in the order required (fetch source data first, do the required transformations and then finally load into warehouse)
• Created aggregator mappings in order to sum up data based on different entities such as Agency, Broker, Sales Rep, etc and stored in aggregated tables.
• Triggered workflows using Workflow Manager and monitored performance of ETL tasks using Workflow Monitor along with session logs
• Closely worked with OBIEE reporting team to ensure that correct data is presented in the reports

Confidential

Production Support Lead

Responsibilities:

• Level 3 and 4 Production Support for Sales Analytics Production environment involving Informatica 8.6.1, OBIEE and DAC
• Worked on major Informatica transformations, maintaining and fixing ETL load failures, resolving issues with mappings and workflows and ensuring data loads complete successfully
• Maintained Oracle BI Apps 7.9.5.1 for OBIEE 10.3.1.4.2 and customized template reports to display KPIs such as COGS, Revenue Forecasting for next 5 years, prediction of baseline, incremental & actual sales, sales margin gap, etc.
• Added alerts via iBots for job failures as well as for reports that users require at regular intervals
• Exposed columns in database to presentation layer via OBIEE repository for reports
• Provided KT to junior team members
• Part of team during deployments (called to client location)
• Part of testing team for all new releases
• Problem management - Designed SOPs for standard tasks and shared with team