Summary
Result oriented IT professional offering over 15 years experience with 8+ years in Data Warehouse covering all phases of software development lifecycle (SDLC) - requirements gathering, business analysis, design, development, testing and implementation of software solutions. Proven ability to learn and adapt quickly and put into practice the knowledge gained in MBA program.

Skills/Technology

Microstrategy

Windows (NT, 2000, XP)

Informatica

Maestro,

UNIX

Project Management

ASP .NET

IBM Rational Doors, ClearCase, ClearQuest

MS Visio 2003

Java, Grails & J2EE

Lotus Notes Domino

Confidential, OH Feb 2010 – Current
Responsible for Design, Development, enhancements and maintenance if various applications in Galaxy, a Data Warehouse team.

• Responsible for design and development of Commercial Clue Extracts report using Teradata 13 and Informatica 9.x. Commercial CLUE is a LexisNexis product which supplies claims history to carriers for use in the risk quoting process. CLUE is a participatory product which requires all carriers to contribute claims information to enable access to the reports.
• Created complex BTEQs to load data from Nationwide and Allied Insurance databases into CLUE database in Teradata 13 and created various workflows using ETL tool informatica to load and transform the data to External vendor, LexisNexis.
• Responsible in all the enhancements and Maintenance of Nationwide Billing Application in Data warehouse. Billing receive 52 mainframe data files every week and they are loaded to Teradata using Mainframe Jobs. Finally uses Microstrategy application ASTRO to view the Billing reports.
• Responsible for maintenance of Billing Mainframe monthly jobs that load data to Teradata. Complex ETL process are involved and requires thorough business and technical skills to maintain this application.
• Responsible for successful enhancement of Claims AIS application. This application uses Mainframe jobs to extract and load data into Teradata.
• Responsible for creating numerous Business request DDG Extracts reports. Using SQL to retrieve data from various databases and sending to Business users on a daily, weekly or monthly basis depending on the request.
• Involved with architect to design data warehouse architecture
• Create FastExport scripts to export data from Teradata natively
• Create unix shell scripts to start Informatica jobs, archive/move files, ftp files, etc

Confidential,VA Oct 2009 – Jan 2010
ETL Developer - Consultant
Responsible for Designing and developing ETL workflow for Troubled Debt Restructuring (TDR) Accounting System and FAS140 SFLS MSTR SFTA Reporting System project.

• Responsible for designing and developing End to End workflow for TDR abd FAS140 SFLS MSTR SFTA using Informatica 8.x.
• Design and develop ETL jobs which extract information from Mainframe DB2 tables, flat files and load them into an Oracle data warehouse. Coordinate of development work with team members, review ETL jobs, and create scripts for scheduling jobs and implementation.
• Used various transformations like Source Qualifier, Lookup, Sequence Generator, Router, Filter, Aggregator, Joiner, Expression
• Reporting System project Acted as a liaison between Microstartegy Architects and ETL Team for TDR and FAS140 SFLS MSTR SFTA Reporting System, these are reports developed using Microstrategy 8.
• Conducted JAD sessions between users and development team to make them understand the project scope and project deliverables.
• Identify data elements from the source systems, performed data analysis to come up with data cleansing and integration rules for the ETL process .
• Responsible for gathering requirements for FAS140 SFLS MSTR SFTA Reporting System project. This project is to build and test the reports which will support business area with accounting, analytics and disclosure resulting from the issuance of the FAS 140 / FIN 46(R) amendment accounting policies and support the ability to maintain Generally Accepted Accounting Principals (“GAAP”) compliance through manual and / or automated processes
• Involved in Data analysis and used RapidSQL to write queries to help test the reports, document the defects Identified in Clear Quest

IT Specialist /Lead
Responsible for analysis, design, development and testing of various applications spanning across multiple business areas with varying platforms and technologies

• Expertise in building Data warehouses, Data marts, Data Integration and developing Business Intelligence solutions for Decision Support Systems and OLAP applications. Experienced in database analysis, Database design, Data Quality and data cleansing.
• Played significant role as a liaison between business and the technical team, gathered business requirements and created technical documentation for Sales Reporting team, Agency Premium DWP Report.
• Extensively used ETL methodologies for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using tools such as Informatica power exchange/Power Center 8.6/8.5/7.1/6.1/5.1
• Extensive hands on working experience of relational database architecture, data warehousing stages from conceptual to logical and physical design, with proficiency in data definition and data manipulation languages. Knowledge of Star-Schema, Snowflake Schema, Fact and Dimension tables.
• Tested new and existing Matrix, Forms, Prompts and reports using MicroStrategy 8.1.1 for financial analysis, Customer analysis, Suppliers/Vendors analysis, Products Analysis, Sales analysis and distribution analysis for Sales Reporting.
• Developed comprehensive project plan and monitored the progress against delivery dates and milestones. Led the team in the analysis, design and developing Agency Premium Growth Report application
• Designed and developed the Sales Reporting Application and changed the application that was developed using .NET ASP to Data warehouse reporting application using Teradata, Informatica and Microstrategy
• Used MS Visio to carry out the Business modeling. Produced Business and System Context diagrams, Data Flow diagrams and System Interfaces Catalog to assist in impact assessment. Extensively used PowerPoint to present the results to Data warehouse team
• Led team which was responsible for generating various reports for Agency Technology Solutions on a daily, weekly, monthly and yearly basis with great customer satisfaction and 95% success rate.
• Analyzed and designed workflow applications in Domino 5.x/6.x/7.x using its strengths - scheduling, email and workflow
• Created a Domino report which Auto, Homeowners and Class Plan M used Nationwide. Originally, this was intended for only one state. Wide acceptance required this is be a 2500 hour project
• Solved Encryption Keys problems by fixing complex bugs which made the Executive database unusable. Took initiative to work on this problem, what would have been a 1000 hour project required only 40 hour effort
• Interacted regularly with Agents from all over the country to understand their problems/issues and come up with solutions
• Experienced in Nationwide developed methodology ESDm (Enterprise Solution Delivery Methodology), Agile and Waterfall.

Confidential,Washington D. C. Mar 1999 – Aug 1999
IT Consultant
Responsible for workflow automating of Directors Committee translation application in translating documents used by various translation units to translate into different languages and sent back to Directors Committee after Translation.

• Involved in designing the reports, workflow and developing Forms, Views, Navigators and Subforms.

Confidential,NC Oct 1998 – Feb 1999 IT Consultant

• Interacted with a business analyst on a weekly basis to gather requirements and design and develop policy letters application to get data from DB2 database and print the Notice letter using Lotus Notes as front end.

Andhra Pradesh Dairy Development Co-operative Federation Sep 1997 – Sep 1998
Programmer Analyst

• Involved in the study and analysis of User Requirements and documentation of the system designed to track production and procurement of milk in the remote areas of the state.

Nagarjuna Fertilizers and Chemicals Limited Apr 1996 – Aug 1997

• Worked as a Programmer and was part of a 4 member team which developed Customer Information System using Lotus Notes.

Andhra Pradesh Agriculture University Oct 1995 – Mar 1996

• Participated in the developing and testing Payroll application using Oracle 7.1.

Apollo Hospitals Mar 1995 – Sep 1995

• Participated in the development (Programming) of the system using features of Oracle 7.0.

Confidential, Oct 1994 – Feb 1995
Intern/Programmer

• Was part of a team which programmed and documented Purchase order system using COBOL.

Education
MBA (Finance) – Confidential,Ohio, 2007
Bachelor of Engineering – India
Certifications

Training Received

Introduction to Teradata 12 and SQL
Informatica PowerCenter Bootcamp for Developers 9.x

ESDm – Enterprise Solution Delivery Methodology (Trained in Initiate, Solution Scope, Design & Development, Requirements and Testing phases)
Foundation for Solution Analysis
Essential J2EE
Developing Web application using the Struts & Tiles Framework
Java Programming
Java Architecture & Components
Introduction to XML
Active Server Pages 1 & 2
ESI International - Project Leadership, Management and Communications