SUMMARY:

• Extensive Information Technology experience and expertise in Data warehouse solutions in the major financial services industry. Competent in Requirements Analysis, System Design, Project Management, DataMart Development in support of profitability analysis, risk reporting and marketing, ETL Processing, Data Management Practices including meta data repositories, Implementation and Migration, OLAP Processing and Application Software on Legacy and New Technology systems.
• Managed and delivered complex design and pragmatic solutions, managing and leading teams of technical and business specialists.
• Successfully integrated offshore competency model.
• Excellent communication and presentation skills.
• Demonstrated high analytical skills and problem solving capabilities.
• Well versed in SDLC system methodologies.

TECHNICAL SKILLS:

Database: Teradata 13, Oracle 10g/11i/11g, DB2 UDB 6.x, Informix 7.x/8.x, Vsam

Operating systems: Aix, Mvs/Esa, OS/370,OS/390, Unix, Windows - NT

Software: UNIX Shell Scripts, Perl, Pro * C, VS/Cobol - I, II,MF/Cobol, Html, XML

ETL/GUI/Modeling/System Software: Ab Initio GDE 3.1.7, Co>Op 3.0.4, Ab Initio EME, Informatica, Xml, Prism Warehouse Executive, Erwin Model Manager, Brio, Datashopper, Microstrategy, MVS Platinum Repository, Autosys,Tivoli Work Load Scheduler, Net Express 3, Remedy Incident Management 3.x, Peregrine Incident Management, Test Director, Omegamon PM, Harvest, PVCS. DB Designer.

Programming: pl/sql

PROFESSIONAL EXPERIENCE:

Confidential

IT Consultant

Environment: Rail corp, AUS

Responsibilities:

• Overall Solution to the DW/ETL layer and Data Marts and provided effective input for the same. Provided Technical Solution for BI Performance Management in the Rail corp project.
• Goal of the project is to develop Data warehouse/Marts for the South Wales Rail Corporation to support Performance Management system for Electric trains built by Reliance Rail.
• Purpose of the Data Marts is essentially to support Reports generation to the
• Senior/Middle Management team, to track and monitor the efficiency of the Electric Trains.
• Participated in the Application analysis with the User to implement the Business functionalities and requirements.
• Designed and developed complex Ab-Initio graphs use Ab-Initio Parallelism techniquesand MFS Techniques with the Conditional Components, Custom Components and
• Conditional DML for the data load from Legacy System to new Target System.
• Reviewed Source-to-Target Mappings, Design Documents and Business rules.
• Designed and developed batch programs for Payroll processing of employees..
• Enhancement of the existing Application Programs to meet the demands of the customer.
• Ab Initio, EME, Oracle, Target, Unix, Autosys Job Scheduler, MS Power point, Visio

Confidential

Senior Consultant

Environment: Walgreens, Chicago, US

Responsibilities:

• ETL lead for the EJ Reports Migration project. This project involved migration of EJ reporting system and it’s functionality from Mainframe to the open source system.
• Provided Design Approach for Forward engineering and Reverse engineering. Involved in the Project planning, Project management and Resource Management for the project.
• Oversight and support for Reverse engineering analysis, Design, Development and
• Implementation of Ab Initio Process for Successful Delivery of the project.
• Developed, tested and reviewed complex Ab Initio graphs, sub-graphs, dml’s, Pset, xfrsshell scripts DBC files for connectivity with database and create package.
• Contribution to the Ab Initio Center of Excellence, Review of Internal MaterialsEstimation guidelines, Support RFPs, Design Solutions etc. Served as a SPOC for

Confidential, Charlotte, NC

AVP/Senior Systems Analyst

Responsibilities:

• Responsible for Managing three Data Marts - ODS, Sigma and Risk Mart. Managed workload and commitments.Mentored and integrated the development and production support team with Infosys.
• Supported and facilitated the following initiatives and programs: Offshoring
• Internal process improvement, efficient application design and operation, Lower cost solutions for LOB objectives, accurate project estimation, forecasting and financial tracking, application retirement, consolidation and re-engineering to reduce complexity and improve availability,consistency and efficient use of contractor resourcing.
• Build and foster relationships with LOB partners, observe LOB operations and proactively identify areas of improved IT services and Automation.
• Efficiently managed production support and development environments. Production support activities include create/update SLA’s, meet delivery/availability expectationsensure production changes are consistently successful, improve response timeImplementation schedules for production enhancements and projects.
• Development support activities include work assignment, prioritization of deliverablesvendor management, delivering unmatched customer service and balancing many demands of the teams.
• Involved in setting Ab Initio Design/Development standards, input to code review templates, code turnover documents, sizing template for project sizing etc.
• Assigned as a ETL lead for the RDS BASEL project. Responsible for the
• Data Integration Layer (ETL). Manage the blend of IBM and Wachovia resourcesResponsible for the deliverables, work plan etc.

Environment: Ab Initio, Ab Initio EME, Unix, Informix, TeraData, Autosys Job Scheduler, MS projectPower point, Visio, Harvest, Documentum, Demand Management

Systems Analyst

Confidential

Responsibilities:

• Worked as a Technical Lead, leading the analysis, design, and related deliverables for Business Card Web feed, Email and Account relationship data services for l3 conversion.
• Lead the Design of Data Warehouse Star Schema and Table Structures, Design of data marts, Design of common API's, Design and Creation of ETL Plans, Automation of ETL Plans, Management of Structural Changes, Priority Planning.
• Re-architecture of Database design, and related ETL re-engineering using Ab Initio ETL.
• Involved in the Business analysis of various functionalities of a VLDB data warehouse environment. Identify available and desired metrics to resolve process centric issues. Creation of Business Requirements, functional specifications, interface specifications, technical specifications, Source to target mappings and Capacity planning.
• Definition of metadata in data shopper, design and development of scheduling mechanisms, interaction with user community, data mapping and comprehensive documentation for all stages of the project life cycle.
• Periodic creation of large volume datasets for external vendors, integration of external data from multiple sources into the warehouse, validation of data against dynamic business rules, and completion of custom requests from internal data consumers.
• Accurate, quickly accessible static and dynamic data allows marketers to make informed decisions and optimally leverage the available data. Consistently provide dependable and accurate data in a timely manner. Proactive involvement in structural changes made elsewhere in the warehouse allows for analysis and design time to facilitate a seamless integration.

Environment: Ab Initio, Ab Initio EME, Oracle 9i/8i, Aix(K shell), Tivoli work load Scheduler, Autosys, Erwin, DataShopper, Visio,MS project, Power point, Test Director, Harvest, Peregrine.

Programmer Analyst

Confidential, Austin, Texas

Responsibilities:

• Integrated client-resident query tool (BI) with server-based relational database and the OLAP cubes. Created complex criteria sets which allow pinpoint access to required information. Constantly interfaced with the users for their requirements and to make sure if the EIS satisfied their purpose.
• Support for hierarchical consolidation of data, and the ability to drill down into detail as well as rapid query response. Designed Batch processes to feed the data repository which interfaced with the BI tool to enhance the Querying capability.
• The business intelligent system required table and report designs using finely tuned queries. Reports required intuitive presentations and inclusion of the full scope of desired data, provided consistently and with a pristine level of accuracy.
• Involved in the system study and analysis of the migration and merging of the Wausau insurance company warehouse with the Liberty mutual insurance company.
• Designed the new key generation process for relating data in the warehouse and the operational data store as the existing data between both did not have any relationship. Defined the strategy to accomplish discrete data cleansing, consolidation, conversion & migration process activities based upon preliminary application deployment plans.
• Gathered requirements, designed and developed various maps with informatica power center and implemented dynamic business rules and data transformation process. Designed and developed highly skilled in end-user application, Back-end development, ETL and Data Warehouse design of infrastructure and development
• Worked with cross-functional team to identify and eliminate system functionality deficiencies. Developed an implementation plan to integrate the existing system to the remote system.

Environment: Informatica, Oracle 8 and utilities, Unix (K shell),MS Power point, Visio