SUMMARY

6 years as a Data Warehouse Developer/Data Architect involving in the life cycle of ETL/BI projects i.e. understand and analyze project requirements/functional specifications by interacting with business and IS/IT Managers Project Planning Design Logical and Physical Development Testing Implementation and Maintenance of various DW/DM s and Client/Server applications under Unix/Windows Environments including effective communication/co-ordination within the team and Product managers/Business and strict Process Adherence.

Highly motivated team player with strong communication organizational and analytical skills and with a passion to work in challenging environment and adaptable to varying circumstances Ability to Capture the Business requirements and translate those into Data Architecture Strategies and Deliverables. Provides ETL specification documentation to the ETL team which defines the data source Target table and necessary transformation rules. Solid work experience with ETL tools Informatica SSIS Sound Knowledge on Dimensional Modeling MOLAP concepts and design of Data warehouse with the elements of STAR and SNOWFLAKE schemas and the related Measures Facts and Dimensions. Exposure to SQL Loader Export Import Utilities SQL PL/SQL and Tuning Oracle SQL Demonstrated ability in understanding and grasping new concepts in Data Warehousing space Both Technical Business and utilize them as needed

EXPERIENCE

confidential

Consultant

Working on proprietary Business Intelligent Products of MedAssets Contract Analytics and AR Analytics. These products are used by Hospital facility to project their Expected Revenue and project revenues are based on their current Contracts.

Responsibilities - Work with the Product Analyst/Product Manager to discuss Business Requirements and the reports requirements. - Build Gap Analysis and data validations to ensure there was enough data to begin development - Work with Data Modelers to create Logical and Physical models using Fact and Dimension tables. - Build Mapping document Source to Target mappings for ETL . - Translate the Business Requirement document to ETL Mapping Document Mapping Documents for MicroStrategy developers and work with QA to develop test cases - Co-ordinated with the Product Management team to ensure the end product met expectations by validating data from backend front end. - Worked hand in hand with the Product Management team to discuss Data Asks with customers for the Analytics Product. - Built Data Dictionary for the Business Users for all attributes built in the reports through Microstrategy and its corresponding Adhoc fields.

confidential

Data/ETL Architect Projects/

Responsibilities

• SALES FORCE MAP Salesforce.com is cloud computing software used for social and mobile cloud technologies. This is used to help GMF stay connected with the various DRMs real time with Dealer and Customer information. Architect Responsibilities Design/Implement data migration from Sales force DB to adhere GMF warehouse denormalized star standards.
• Involve BA and ETL leads to understand the data complexity on both sides and design the data model/architecture accordingly.
• Design logical data models with Erwin and engage ETL.
• Work with ETL team on the complex transformations and migration procedures.
• Closely work with DBAs to define the data structures and the referential integrities.
• Ensure data quality especially dealing with millions of customer record processing each day.
• Implemented RT Lease feeds into warehouse which involved complex nightly reconciliation.

confidential

Customer/Dealer Communication EDW feeds

Architect Responsibilities

• Led Data warehouse/Data Integration efforts in the Corporate Implementation of Thunderhead. This included coordination with the Thunderhead Business team 3rd Party vendor NCP and Thunderhead Build XML Schema definition and design data flow through the warehouse
• Conducts walk-through meetings with business stakeholders architects ETL developers DBAs and
• Quality Analysts to ensure the data model conforms to the business metrics and cover all technical
• Requirements.
• Helped Thunderhead team design a Thunderhead Exception logic allowing them to be able to monitor errors in their process from NCP.
• Worked on the DODD FRANK initiatives for the company which required all customers to be notified about the reason on why their credit application was declined. Provided the design and resolution to implement this in a short span of time.
• Work with Front end to set up the report processing on the number/type of customer letters sent out each day
• Designed and implemented letters to communicate with Customers and Dealers from various source systems through the XML schema to Thunderhead.
• Co-ordinated efforts with various IT group and the Business groups to install Table tool on tables which Business wanted to maintain manually had it tested in QA and Moved to prod. Enabled Audit on records to capture any changes made
• Working on the Feedback/Survey processing.

confidential Financial System for GM. All payments and processing for a loan is done through this system

Architect Responsibilities

• Worked in the new GMF initiative to process refunds through Payment Card processing. Through this initiative worked with the financial group to be able to update all the data in the Warehouse related to Customer Refunds and allow new data to flow through the systems.
• Worked with AIX group to set up Real Time Message Queues Set up directories/folders scheduling file transfer set up Data Archives for various warehouse initiatives.
• Worked with the Business to understand their reporting needs to bring in the XS Wear and Tear data from AAGI to the warehouse.

confidential Provenir is the loan application processing system used by GMF.

Architect Responsibilities

• Helped map the XML application data to denormalized table structures on the warehouse end.
• Worked closely with Business Analysts and reporting teams to design and implement Data Warehouse sources used to automate reports and increase the quality of existing data.
• Worked closely with end users in order to research data related issues the development of new business solutions and the creation of ETL specifications for Data Warehouse enhancement on a day to day basis.
• Worked on the Data Warehouse/ Data Integration Efforts involved in Corporate Implementation of the GM Auto Leasing Program. This included coordination with both Internal IT Systems and 3rd Party Vendors along with design of Data Flows Staging Areas Loading Strategies Target Designs and all supporting Documentation/ Data Models.
• Maintained data model integrity by creating and maintaining Data Model checkout/ modification process using Erwin Model-Mart.

Environment Informatica Power Center 8.X Rapid SQL 8.0 Oracle 11g/10g/9i Altova XML Spy Erwin 8.0

confidential

Sr.Software Engineer/ETL

The fuel reporting system SOLARC contains the fuelling data Invoices from fuel companies like Chevron Conoco etc per each flight from 2009. Since southwest operates over 70 destinations as of 2010 and 3 500 flights a day the fuel numbers can be huge and can get really complex. The data pushed in from various sources is brought into the SQL Server database using SSIS Packages. This data is used to generate invoices by other applications and also used to generate reports using SSRS. Wyatt ERP is a huge warehouse effort for SWA primarily replacing the existing Finance CAS and Tesseract payroll system with SAP. The magnitude of this replacement with SAP is so huge that it impacts the whole organization in day to day activities from fuel consumption to employee worker timesheet/pay data. The idea is to give a robust ERP-enterprise solution where we define more meaningful and efficient processes for a successful/profitable business in the aviation. SAP Rapid marts Finance HR AP etc were purchased from SAP and modeled as per southwest requirements. Data extracted from SAP to Rapid Marts using Data integrator services flows through an in-house ETL layer finally feeding the enterprise data warehouse. The project provided a platform to unveil various data complexities and transformations in the process of delivering effective measures/data to business.

Responsibilities

• Research/implemented source changes to EDW and developed an Impact analysis per each single ETL mapping and target table.
• Involved in data extraction transformation and loading ETL . Used SSIS Packages in conjunction with Informatica to several database. Oracle SQL
• Data structure designs rewrite ETL mappings.
• Developed SSIS packages for moving data from text files to SQL Server.
• Extensively involved with Database tablespace Management Performance.
• Create database objects in SQL Server 2005 including Tables Triggers Views Stored Procedures User Defined Functions UDF and Indexes.
• Written stored procedures to populate final database tables from staging tables and cleanse inaccurate data.
• Extensively involved with the development team in carrying out the Unit testing of the applications used for invoicing and tuning of complex procedures.
• Design web application using java that produced reports from the UI.
• Generate ant build scripts to compile and deploy application to websphere server.
• Extensively involved in knowledge transfer for the documentation team for the development activities carried out by team.
• Used Erwin to draw the logical data models and serve as a prerequisite for ETL Development.

SAP Responsibilities

• Involved in Requirement gathering including meeting with the customers and writing up the Technical requirements.
• Sources from Rapid Marts SAP extract zone where the data gets extracted from SAP modules using EDW Data services.
• Extensively used Informatica Client tools Source Analyzer Warehouse Designer Mapping Designer Mapplet Designer Informatica Repository Manager and Informatica Workflow Manager. Developed unix shells to automate few manual efforts to cleanse the log files data as per EDW requirements.
• Developed various mappings using Mapping Designer and worked with Aggregator Lookup Filter Router Joiner Source Qualifier Expression Stored Procedure Sorter and Sequence Generator transformations.
• Worked in creating Complex Mappings which involved Slowly Changing Dimensions SCD Type1 Type2 Type3 to implement Business Logic and capturing the Historical Present Records in EDW.
• Validated the new data sources for EDW coming from rapidmarts SAP stage
• Developed PL/SQL stored procedures for database updates and to create the necessary indexes in the target tables.
• Created PL/SQL packages and stored procedures to load data from various sources to staging area.
• Expert in identifying and resolving the bottlenecks in Source Target Transformations Mappings and Sessions for better performance
• Involved in tuning the Oracle table scripts and queries by using Indexing techniques Hints and Parallel execution process.
• Optimizing Informatica Mappings and Sessions to improve the performance.
• Experience in performance tuning of sources transformations targets mappings worklets workflows and sessions.
• Extensively worked on Session partitioning techniques using different Informatica Partitioning techniques to optimize the load times.
• Created and scheduled Sessions Jobs based on demand run on time and run only once using Workflow Manager.
• Analyzed the data from various sources such as Peoplesoft AVR etc... to maintain consistency and performed validation tests.
• Identified the facts and dimensions and designed the relevant dim and fact tables.
• Performed Unit testing Integration testing and System testing of Informatica mappings.
• Worked with SQL Loader to load the data into the warehouse and flat files respectively.
• Wrote UNIX shell scripts to work with flat files to define parameter files and to create pre and post session commands.
• Involved in MS SQL Server 2005 configuration Tuning and provided 24 X 7 dedicated support to all development/production servers.
• Configured server for sending automatic mails on the failure and success of the scheduled job.
• Running Index tuning wizard and rebuilding indexes for faster query response.
• Responsible for SSIS activities to move data from text files to SQL Server.
• Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.
• Troubleshooting Database performance issue and implementing necessary Database changes.
• Precise documentation was done for all mappings and workflows.

Environment Informatica Power Center 8.X SQL Loader Linux shell Oracle 11g/10g/9i SQLServer

confidential

Credit Pro Software Development Associate Intern

Job Responsibilities

• Analysis templates and Issue management activities were done using Microsoft .Net technologies C Excel.
• Designed various service and utility layers using C code in multithreaded environment.
• The Data Layer was supported by Microsoft SQL Server 2005
• Participated in designing testing disaster recovery model implementation.
• Used DDL and DML for writing triggers stored procedures and data manipulation.
• Meet department heads and end user to gather requirements design specifications data mapping and develop new reports using SQL Server Reporting Services 2005 .
• Creating model UI screen shots for the application using HTML to ensure that the application s UI is more user friendly.
• Meeting with the end users to understand the use cases for credit rating application and writing the Business requirement documents.
• Created Deployment projects for .NET applications using Microsoft s MSI packages
• Designed and developed a website using C ASP.NET ADO.NET XML Web Services MS SQL 2005 for Hamburg sued one of the key carrier companies in Germany that provides worldwide ocean transportation and other services
• Writing technical specifications for the application with the sequence diagrams for the use cases in the requirements document.
• Built the data layer with Microsoft SQL Server 2005 as the back end database.
• Created/designed reports using SQL Server Reporting Services according to user requirements.
• Created Tables Views Triggers and Stored Procedures in T-SQL.

Environment

C ASP.Net VB.net Visual Studio 2005 SQL Server 2005 Visio 2003