SUMMARY:

*+ years of IT experience in Data warehousing and Business intelligence with emphasis on Business Requirements Analysis, Application Design, Development, implementation and maintenance of client/server Data Warehouse and Data Mart systems in the Financial, Telecom, Retail, Loyalty and Marketing Industries.

Experience in development and design of ETL (Extract, Transform and Loading data) methodology for supporting data transformations and processing, in a corporate wide ETL Solution using Informatica Power Center (9.x/8.x/7.x).

Excellent understanding of transactional and dimensional data modelling, Data Warehousing concepts, Star Schema modeling, Snow-Flake modeling, Fact and Dimensions Modeling.

Extensively worked on Informatica Power Center Components such as Mapping and Mapplet Designer, Repository Manager, Workflow Manager, Workflow Monitor and Power Center Admin Console.

Experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Union, Sequence Generator, Sorter, Rank, Normalizer etc.

Made use of parameter files, mapping parameters, mapping variables and session variables.

Experience in identifying and resolving the bottlenecks in Source, Target, Transformations, Mappings and Sessions for better performance.

Extensive experience in debugging mappings. Identifies bugs in existing mappings by analyzing the data flow, evaluated transformations and looking at errors in session and workflow logs.

Proficient in using Informatica workflow manager, Workflow monitor, Server manager, pmcmd (Informatica command line utility) to create, schedule and control workflows, tasks, and sessions.

Experience in working with DAC 11g/10g to define the Informatica workflow and sequence and schedule Informatica workflows.

Good Experience in writing UNIX shell scripts, cron jobs for scheduling workflows.

Hands on experience in Installation, Configuration, Server Administration of Informatica Power Center 9.x as well as earlier versions.

Database experience using Oracle 11g/10g/9i, MS SQL Server 2005, External Files, Teradata 14.x/13.x and also used SQL Editors such as TOAD, SQL PLUS and SQL Developer

Proficient in SQL, PL/SQL, Stored Procedures/Functions, Triggers and Packages.

Experience in working on various operating systems like UNIX, LINUX and Windows 8.1/7/XP/NT/95.

Quick learner and adaptive to new and challenging technological environments. Excellent Communication and Inter-personal skills and Strong Documentation skills.

TECHNICAL SKILLS:

Operating systems

Windows 8/7/XP/NT/95, LINUX,UNIX

ETL Tools

Informatica power center 9.x/8.x/7.x, DAC 11g/10g

Databases

Oracle 11g/10g/9i/8x, MS SQL server, MS-Access, Flat Files, DB2, Teradata 13.1/14.1

Languages

SQL, PL/SQL, VB, C, C++, UNIX Scripts

Applications

MS Word, Excel, PowerPoint, Visio

Other tools

TOAD and SQL PLUS, OBIEE,BUSINESS OBJECTS

Web Technologies

HTML and XML

EDUCATION:

Bachelor of Technology in Electronics and Communication Engineering, Jawaharlal Nehru Technological University, Andhra Pradesh, India

PROFESSIONAL EXPERIENCE:

Southwest Airlines, TX January 2013 – Till Date

Role: Informatica Developer

Southwest Loyalty & call center implementation is the conversion of mileage plan from existing legacy loyalty program to rapid rewards 2.0 using Oracle Siebel Loyalty 8.1.1. Along with application developed this projects requires a data warehouse for analyzing the performance of the loyalty program and service requests from call center application. ETL process to build the data warehouse is carried out using Informatica and OBIEE is used for reporting and analysis purposes.

Responsibilities:

Involved in understanding and documenting the requirements of Business analysts and users.

Involved in Implementation of complete life cycle of Business data warehouse for loyalty users with star schemas.

Participated in the entire life cycle of the project, which involved understanding scope of the project, functionality, technical design and complete development.

Created complex mappings involving Filter, Router, Expression, Lookup, Update Strategy, Sequence generator, Normalizer, Union, Joiner and Aggregator transformations.

Configured repository service, nodes and Integration service using browser based Informatica power center administration console and also configured security to assign groups and permissions to the users.

Developed complex mappings and SCD type-I, Type-II and Type III mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Lookup (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router and SQL transformations.

Created metadata queries which help in restart and to find out any missing link conditions or disable tasks in the workflow.

Deployed reusable transformation objects such as mapplets to avoid duplication of metadata, reducing the development time.

Built complex mappings which involve looping of data and computing the trips from the transactions at various levels.

Developed many PL/SQL stored procedures & functions and used the same in mappings, pre and post sessions.

Developed and implemented UNIX shell script to merge the files and archive the files and achieve the files after every load.

Fine tuned Out of box informatica mappings by reducing the number of look up’s for performance optimization.

Tuned the sessions for better performance by implementing the dynamic data partitions.

Built and implemented stored procedure to fix the parallel indexes at the end of the daily loads.

Performance tuning of informatica mappings data warehouse loads, including informatica server manager and PL/SQL procedures.

Created mapping variables and parameters and used them appropriately in mappings. Used session parameters and parameter files to reuse sessions for different relational sources or targets.

Developed incremental and updateable loading through Informatica mappings.

Extensively created SQL stored procedures and triggers during pre and post load of data using T-SQL.

Done Unit testing at various level of ETL and wrote quires in SQL to ensure loading data in to target.

Integrated the Informatica server with DAC and customized the data warehouses in DAC.

Created Execution plans by adding the subject areas and sequencing tasks based on the dependences and scheduled the incremental and full loads using DAC.

Extensively worked on DAC actions to move the out of box and custom table’s, indexes to various tablespace’s.

Configured email tasks as part of reconciliation process to send success and failure emails.

Integrated with Teradata to get PNR related data from EDW.

Scheduled cron jobs to monitor FTP server to check periodically for external vendor files.

Involved in development of OBIEE metadata repository (.RPD) by guiding BI team in identifying the join conditions between dimensions and facts in physical layer using connection pool.

Created standard and Adhoc reports (Formats, Layouts, quality data to carry) using Oracle BI answers.

Created tables, views, indexes, synonyms, sequences in development and test environment. DBA activities also included altering tables, dropping tables, and performance tuning.

Environment: Informatica 9.1/8.6, Oracle 11g/10g, Flat and CSV Files, Microsoft Visio, Toad, Windows XP, UNIX, OBIEE 11 g/10.3.2.

QUALCOMM, TX October 2011 - December 2012

Role: Informatica Developer

Qualcomm Enterprise Services Delivers integrated wireless systems and services that enable businesses around the world to operate at peak performance. The division provides comprehensive wireless solutions and services, including two-way data communications systems. Worked on applications each pertaining to various Business Areas like Marketing and Finance, Managed Order Management. OBIEE was the reporting tool used for analysis and reporting.

Responsibilities:

Analyzed the requirements to identify the necessary tables that need to be populated into the staging database.

Prepared the DDL’s for the staging/work tables and coordinated with DBA for creating the development environment and data models.

Involved in analyzing the source data coming from different Data sources such as XML DB2, flat files etc.

Worked on Informatica Power Center tools – Source Analyzer, Warehouse Designer, Mapping & Mapplet Designer, and Transformation Developer

Created mappings using transformations like Source Qualifier, Aggregator, Expression, lookup, Router, Filter, Update Strategy, Joiner, Normalizer, Union, Stored procedure, and XML transformations.

Converted existing PL/SQL Packages to ETL Mappings using Informatica Power Center.

Used Error handling strategy for trapping errors in a mapping and sending errors to an error table.

Schedule and run Extraction and Load process, monitor task and workflow using the Workflow Manager and Workflow monitor.

Used Workflow Manager for creating workflows, work lets, email and command tasks.

Created various reports to fulfill the marketing needs and customized the views using Oracle BI Answers.

Used Informatica features to implement Type I changes in slowly changing dimension (SCD) tables.

Involved in Performance Tuning at various levels including Target, Source, Mapping, and Session for large data files.

Involved in upgrading the database form 10g to 11g.

Supported the Quality Assurance team in testing and validating the Informatica workflows.

Environment: Informatica Power Center 8.6, Oracle 11g, PL/SQL, SQL*Plus, Erwin 4.0/3.5.2, MS-Excel, XML, Flat files, Windows NT, Shell Scripting, OBIEE 10.3.2.

Equant, Inc. India June 2010 - August 2011

Role : Informatica Developer

The CRM operations of the company involved pitching the offers through various channels. The customer data is collected from various sources into Customer management system (CMD) which is the data warehousing system where information is brought and processed. CMD is used by reporting team and marketing team to collect the relevant customer information and creating the selective offers for the customers. Informatica Power Center was used to load strategic source data into CMD.

Responsibilities:

Created Informatica mappings to populate data into fact tables and dimension tables.

Developed complex mappings using various transformations.

Used Informatica features to implement Type II changes in slowly changing dimension tables (SCDs).

Wrote PL/SQL Stored Procedures, SQL scripts and calling at pre and post session.

Developed PL/SQL codes for pre-processing complex data calculations coming from Oracle tables.

Used various transformations like Unconnected /Connected Lookup, Aggregator, Joiner, Stored Procedure.

Developed mapping parameters and variables to support SQL override.

Performed incremental aggregation to load incremental data into Aggregate tables.

Used PMCMD commands of Informatica in UNIX to schedule sessions and jobs

Created scripts for performing database level query joins, functions, procedures in PL/SQL.

Tuned the session parameters to increase the efficiency of the sessions in workflow manager.

Implemented Aggregate, Filter, Joiner, Expression, Sorter, Lookup and Update Strategy, Normalizes, Sequence generator transformations.

Used Repository Server Administration Console to create and backup Repositories.

Writing UNIX Shell Scripts for processing/cleansing incoming text files.

Fine-tuned Informatica jobs by optimizing all transformations.

Used UNIX Shell scripts for scheduling of workflows.

Environment: Informatica PowerCenter 7.1.2, MS SQL Server 2005, Toad, MS Excel, Flat files, PL/SQL, SQL, SQL Plus.

Contact this candidate