Summary:

• Nine Plus years of IT experience in Design, Development and Implementation of various applications in Data Warehousing & Decision Support System(DSS) and client server applications.
• Over Six years of experience in ETL methodology for supporting Data Extraction, Transformation and Loading process, in corporate wide ETL Solution using INFORMATICA (Power Center/Power Mart 9.0/8.0/7.1/6.x/).
• Over Six years of experience in Business Objects 5.x/6.x/XI R2 (Supervisor, Designer, Reporter, Desktop Intelligence, Web Intelligence, Info View, Central Management Console& Broadcast Agent).
• Experience in ERwin 7.2/4.0/3.5 as leading data modeling tool for Logical data model (LDM) and physical data model (PDM).
• Experience in Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Schema Modeling, Dimension, Fact and Aggregated tables.
• Experience in complete life cycle (SDLC) of Design, Maintenance of Development, Implementation and Enterprise Data Warehouse (EDW) and Data Marts.
• Extensively used Transformations for heterogeneous data joins, complex Stored Procedures and Lookup transformations. Other transformations that were used include Update Strategy, Expressions and Aggregations Transformations.
• Experience in UNIX Shell Scripting.
• Tuned the Performance of complete environment for PL/SQL development and SQL queries using development tools.
• Extensive experience in Design, Development, Testing and Production Support in Data Warehousing applications using Oracle 7.x/8i/9i/10g/11g, MS SQL Server Teradata and DB2.
• Excellent problem solving, analytical, written and communication skills with ability to work both in team as well as an individual.

Education:

Master in Computer Applications

Informatica Power Center 9.0/8.0/7.1/6.x (Repository Manager, Designer, Workflow Manager).
Business Objects XI r2/r1/6.5/6.1.x/5.1.x (Supervisor, Designer, Reporter, Desktop Intelligence Web Intelligence, Central Management Console, Info View & Broadcast Agent). Erwin
7.2/4.0/3.5, Oracle 11g/10g/9.2/8.x/7.x, SQL Server 2005/2000/7.x, Teradata, DB2, MS-Access
C, C++, Java 2.0, SQL, PL/SQL, UNIX Shell Script, Java Script, VB Script, Visual Basic 6.0
XML, HTML, DHTML, JSP, ASP, Windows 95/98/NT, UNIX, SUN Solaris

Confidential, NC Feb 09 – Present
Sr. ETL Informatica Developer

Confidential has the infrastructure and web-based development expertise to deliver both e-business analysis and strategic consulting, as well as, custom-built e-commerce applications. These e-solutions enable customers to conduct transactions with their customers and vendors over the Internet, and virtual private networks, permitting clients to engage in private communications with their employees, vendors, customers and suppliers, where secure Internet communication capabilities are important. These core competencies serve as the technical backbone upon which business-to-business application solutions are built, solutions that streamline and more seamlessly integrate our customer’s business processes.

Responsibilities:

• I Interacted with Business Analyst to understand the business requirements.
• I Involved in gathering requirements from business users.
• I Created users/groups and folders using Repository Manager.
• I Extensively worked with Source Analyzer, Warehouse Designer, Transformation Designer, Mapping Designer and Mapplet Designer.
• I Extracted Source Data using Informatica tools and Stored procedures from Source Systems.
• I Developed transformation logic and designed various Complex Mappings and Mapplets using the Designer.
• I Designed various mappings using transformations like Look Up, Router, Update Strategy, Filter, Sequence Generator, Joiner, Aggregator, and Expression Transformation.
• I Used Mapplets, Parameters and Variables to implement Object Orientation techniques and facilitate the reusability of code.
• I Developed and executed UNIX scripts as pre/post-session commands to schedule loads, through SQL-loader utility.
• I Configured and ran the Debugger from within the Mapping Designer to troubleshoot predefined mapping.
• I Extensively involved in Fine-tuning the Informatica Code (mapping and sessions),
• Stored Procedures, SQL to obtain optimal performance and throughput.
• Involved in Migration of BO reports and universes from 6.5 to XI R2.
• Extensively used various techniques like Sectioning, Ranking, Filtering, Slice and Dice to develop the reports.

Environment: Informatica Power Center/ Power Mart 8.6, Business Objects 6.0, Oracle 11g/10g/9i, SQL Loader, PL/SQL, DB2, XML, Erwin 7.2/4.0, Unix Shell Programming, Windows NT.

Confidential, GA Jan 08 – Feb 09
Sr. Informatica Consultant

Confidential is one of the fastest growing nationwide wireless service providers offering all digital voice, messaging and high-speed wireless data services to more than 18.2 million customers in the United States. It provides strategic solutions for Ordering, Preordering, Billing, Provisioning, Maintaining and Repairing of Domains. The project dealt with extracting and transforming data from various sources and business types using business rules to Transient, Staging, Warehouse and Mart. The data was then loaded into regional data marts according to geographical, time dimension for various strategic businesses rules.

Responsibilities:

• Analyzed source and target models and the business requirements associated with them and made appropriate changes by translating the requirements into Data Warehouse architectural designs.
• Handled huge tables that consisted of around 128 columns and 20 million records per each table.
• Worked with complex mapping with an average of 15 transformations.
• Designed and maintained logical and physical enterprise Data Warehouse schemas.
• Improved the performance of the mappings to decrease load time and give optimum system performance.
• Created number is workflows that used a group of work lets for loading the data at staging and Data Warehouse stages.
• Used Workflow Manager to create and run batches for different applications.
• Loaded Operational data from Oracle, DB2, SQL Server, Flat Files into Transient Tables and cleaned the data using appropriate business rules.
• Involved in designing Star schema by de-normalizing database tables.
• Used the Debugger in debugging mappings.
• Generated Reusable Transformations, Mapplets and used them extensively in many mappings.
• Involved in Working with Erwin tool in Data Modeling (both Physical and Logical Design).
• Involved in creating new Templates for the Report.
• Unix Scripts were written at various situations like event automation and job scheduling.
• Created test databases to test and tune the queries.

Environment: Informatica Power Center 7.1, Business Objects 6.0, Teradata, DB2, PL/SQL, XML, UNIX Shell Script, Erwin, Windows NT.

South Bell Corporation is one of the major telecommunications company. South bell having its data (Product, Customer and Sales information) in Legacy systems and integrate product customer and sales data across different databases to get a holistic
view of its business. To accomplish this task the company integrated relational and non-relational data across different business units into enterprise Data Warehouse, where managers across the company can access a single repository for customer and sales information and perform ad-hoc analysis and generate analytic reports.

Responsibilities:

• Involved in Business Analysis, requirements gathering and logical & physical data modeling.
• Involved in Analysis, Design and Development of ETL process. Created ETL high level design documents and Informatica mapping specifications.
• Worked on Data Conversion and Data Analysis. Stored data in the Data Warehouse about Customers and Dealers. There were two kinds of data loading processes (Daily and Weekly) depending on the frequency of source data.
• Data architecture using ER and dimensional modeling (ERwin) for the staging, warehouse and associated data marts.
• Extraction, Transformation and Loading of the data Using Informatica Power Center.
• Worked on Informatica tools Source Analyzer, Warehouse designer, Mapping Designer and Transformation Developer.
• Developed Informatica mappings and also tuned them for better performance.
• Extensively used the Expression, Aggregator, Filter, Joiner, Sorter transformations.
• Extensively used Rank transformations to eliminate the duplication of the customers after obtaining their information through LOOKUP transformation.
• Used Update Strategy and Lookup transformations to manipulate the information about the customer.
• Different sessions were run in the Workflow Manager and the log was studied to modify the mappings to obtain correct result from the transformation.
• The mappings were Unit tested to check for the expected results.
• Extensively used ETL to load data from flat files.
• Designed and Deployed UNIX Shell Scripts.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the Workflow processes using Unix Shell Scripts.
• Generated SQL Loader scripts and Shell scripts for automated daily load processes.
• Worked as a team member for design and development of Ad-hoc reports using Business Objects.

Environment: Informatica Power Center 7.1, Business objects 6.0, Oracle 9i/8i, SQL*Loader, Erwin, SQL, PL/SQL, UNIX Shell Script, Sun Solaris 2.6, Windows NT.

MetLife is one of the leading Financial and Insurance Company. The project's main objective is to create a central database for data and to provide a set of standard reports to give better analysis to the financial group. ETL Informatica was used to Extract, Transform data by applying required business logic from source databases and loading data into data warehouse star schema tables.

Responsibilities:

• Primarily responsible to convert business requirements into system design. Further ETL process implemented with Informatica.
• Used ETL to standardize data from various sources and load into Data warehouse which was in Oracle.
• Worked on Informatica Power Center tool Source Analyzer, Warehouse designer, Mapping & Mapplet Designer, Transformations, Informatica Repository Manager and Informatica Workflow Manager.
• Informatica Designer tools were used to design the source definition, target definition and transformations to build mappings.
• Created materialized views to increase the speed of queries.
• Extensively used Informatica Power center for extracting, transforming and loading data into Oracle from various source systems.
• Designed and Developed complex aggregate, join, look up transformation rules (business rules) to generate consolidated (Fact/Summary) data identified by dimensions using Informatica Power Center tool.
• Expertise in developing SQL and PL/SQL codes through various procedures, functions, and packages to implement the business logics of database in Oracle.
• Used shell scripts for automating the execution of maps.
• Used Debugger to test the mappings and fix the bugs.
• Developed Informatica mappings, re-usable transformations, re-usable mappings for data load to data warehouse and database successfully moved the Sessions and Workflows from the Development environment to Production environment.

Environment: Informatica Power Center 6.1, ORACLE 8.1, SQL and PL/SQL, SQL Server, Unix Shell Script, Erwin, Windows NT.

Confidential, CA Jun 04 – Aug 05
DW ETL Developer

The Visa Account Updater (VAU) provides updated Visa account information to merchants who maintain recurring payment credit card list. Issuers provide account change updates to Account Updater. Merchants then match their card lists to this data and receive updated card information such as new expiration date, transfer to a new account number, card account cancelled, etc. This eliminates administrative effort by the merchant and cardholder in the maintenance of billing files.

Responsibilities:

• Extensively used Informatica Power center for extracting, transforming and loading databases into Oracle.
• Worked on Informatica tool Source Analyzer, Data Warehousing designer, Mapping Designer, Transformations, Informatica Repository Manager and Informatica Workflow Manager.
• Extensively used various transformations like Filter, Sorter, Joiner and router transformations.
• Developed Informatica mappings, re-usable transformations, re-usable mappings for data load to data warehouse and data Marts
• Good in Using Debugger wizard to find the bottlenecks in the mapping.
• Involved in the designing of Informatica mappings by translating the business requirements. Scheduling of sessions and workflows.
• Managed software releases after each stage of the testing and defect removal.
• Unix Scripts were written at various situations like event automation and job scheduling.
• Extensively used ETL to load data from different source systems like, Flat files.etc into the Staging table and load the data into the target database ORACLE.
• Executed Pre and Post session commands on Source and Target database.

Environments: Informatica Power center 6.1, Oracle 8i, PL/SQL, Erwin3.5, Unix Shell Script, Windows 2000.

Confidential, PA Mar 03 – Jun 04
Data Warehouse Developer

TEVA Pharmaceuticals is a global pharmaceutical Company. I was involved in the design, development and deployment of operational reports for marketing and sales. This project involved developing a Data Warehouse using Informatica to transform the Sales Force Data that is extracted from the various databases and Flat files. We have generated reports for marketing and sales management. The criterion behind was to get the current status of all the activities on the ground and to get a past history for the projections trends of sales on specific products.

Responsibilities:

• Studied the existing OLTP systems Extraction, Transformation and Load was performed using Informatica to build the data warehouse.
• Extracted data from different systems into Repository using Informatica Power Connect.
• Analyzed and Created Facts and Dimension Tables.
• Extracted data from different systems into Source.
• Created Mappings between Source and Target using Power Center Designer.
• Created and Scheduled Sessions and Batch Process based on demand, run on time, run only once using Informatica Server Manager.
• Installed and configured Informatica Server and Power Center.
• Created Repository and User groups Using Repository Manager.
• Analyzed and Explored reports using Slice and Dice, and Drill Down.

Environment: Informatica 5.1, Business Objects 5.0, ASP, Visual Basic, Erwin 3.5, Oracle 8.0 and Windows NT/2000.

Confidential, GA Jun 02 - Mar 03
Data Warehouse Developer

Atlanta Gas Light Company had to build a customer data warehouse that would house all the customer, product, billing, service, and sales information of its natural gas customers. They have used Informatica to consolidate the large amount of their data from mainframe. Power Center is used to extract data from various sources like mainframe, Microsoft SQL Server and Oracle to load into the Oracle Central data warehouse.

Responsibilities:

• Prepared requirement definitions and analysis documents in support of data warehousing efforts.
• Extensively used Informatica Power center for extracting, transforming and loading databases from Oracle.
• Developed stored procedures, functions and packages using PL/SQL.
• Designed and developed shell scripts for data import/export and data conversions.
• Worked on Informatica tool Source Analyzer, Data Warehousing designer, Mapping Designer, Transformations, Informatica Repository Manager and Informatica Server Manager.
• Created test databases to test and tune the queries.
• Involved in improving performance of the Server Sessions by identifying and eliminating the Performance Bottlenecks.
• Created Reusable Transformations and Mapplets, and used them in Mappings to develop the business logic for transforming source data into target.

Environment: Informatica Power Center 5.1, Oracle 8.0, PL/SQL, UNIX Shell Script, SQL*Loader, Erwin 3.5, Windows NT/2000.