OBJECTIVE:

• Position as Senior ETL Consultant and Solution Architect

SUMMARY:

• More than 18 years of software design, architecture and development
• Last 10 years of intensive work on complex EDW projects
• 7 years of Team Lead experience
• Thorough experience in 1) database modeling: physical and logical database models, SQL queries for reports, and data transformation process; 2) database programming; 3) database administration: ongoing database performance and monitoring, database software installation upgrades, data migration, backup, and recovery
• Strong working knowledge of distributed databases, PL/SQL, scripting, and ETL tools
• Strong analytical, problem solving and decision - making skills
• Excellent verbal and written communication skills
• Hardworking and fast learning with a track record for meeting deadlines
• Demonstrated ability to work in a dynamic, fast-paced team environment.

TECHNICAL SKILLS:

DATABASE MANAGEMENT SYSTEMS: Oracle, Teradata, HANA, Netezza, DB2 UDB, Microsoft SQL Server, Sybase ASE, PostgreSQL

METHODOLOGIES: Informatica 9.0, DataStage 11.5, SAP BODS 4.2, SAP Information Steward, SAS, Erwin, Cognos

OS: HP-UX, Windows, AIX, Slackware, Red Hat Linux, OS/390

PROFESSIONAL EXPERIENCE:

Confidential

ETL Consultant

Responsibilities:

• Mapping Specifications, High Level design and Implementation of monthly aggregates of residential premiums and claims losses in a form of star schema for a dynamic cube
• Performance Tuning of Client’s Existing Jobs. Running time was reduced from 14 hours to 15 minutes

Confidential

ETL BA Consultant

Responsibilities:

• Mapping Specifications reengineering based on existing DataStage code
• High Level Design
• Trillium Regression Testing
• UAT execution plan and test cases

Confidential

SAP BODS Consultant

Responsibilities:

• JMS Real Time Integration with BODS using Apache Active MQ as JMS provider and HANA DB on example of Bloomberg Trade message.
• Access Server, Real Time Services and JMS Adapter JNDI configurations setup
• HANA Stored Procedures Development
• Consult Traders TWF Team on existing BODS functionality

Confidential

SAP BODS Consultant

Responsibilities:

• Conversion of existing BizTalk interfaces into SAP BODS 4.2. SP4 including design and mapping reengineering of consuming Soap Web Services

Confidential

Solution Architect

Responsibilities:

• Created High Level Solution Design and presented it to Information Management Design Committee, provided cost and effort estimates8.1 to 9.1 DataStage Upgrade Project
• Set up DSODB xmeta repository and Operational Console, performance issues, prepared Object Trackers for each project to facilitate migration processIM Foundations Project
• Design of ETL Standards and Templates including routines to run sql statements in DataStage using BCI functions.SLA Audit Framework Project
• Design and Development of Audit Framework using DSODB DB2 Operational Database

Confidential

Grand Maison Project Senior EDW Consultant

Responsibilities:

• Development of Teradata Stored Procedures for Internet and Channel Parts of Grand Maison Project

Confidential

SAP Master and Transactional Data Load Project Senior BODS Consultant

Responsibilities:

• Legacy Master Data Load from JD Edwards, PeopleSoft, Sybase ASE and MS SQL Server into SAP ECC using SAP BODS Best Practices Legacy Data Migration Framework (BPDM) and IDocs. Master Data Objects like Bank, Cost and Profit Centers, Customer, Vendor, Article and AR/AP were loaded into ECC using test data.

Confidential

EDW Projects Senior BODS Consultant

Responsibilities:

• Led a team of 6-7 off-shore developers
• High-Level and Detailed Designs development
• Development of BODS Template interfaces

Confidential

Responsibilities:

• Business requirements gathering by analyzing existing SAS logic
• Architecture and Data Modeling using Erwin
• Development of BODS interfacesMerchandise Space Planning Project for EDW:
• Velocity Codes calculation of products at National, Formats and Distribution Channel levels for assortment optimization and in identifying opportunities to drive sales.

Confidential

Senior ETL Designer Lead

Responsibilities:

• Lead of 6-12 off-shore developers group
• High-Level and Detailed Designs development
• Development of Informatica Template workflows using TPT and PDO
• Development of Unix shell scripts to support the ETL processes

Confidential

Senior ETL Consultant

Responsibilities:

• Created High Level and Detailed Design Documents
• Implemented audit and control frameworks
• Managed the team of one developer
• Design, develop and implement transformation processes using Data Stage that load data into the Data Warehouse from various sources
• Development of BTEQ, MLOAD, TPump scripts to augment the ETL processes
• Develop JCL scripts to support the ETL processes
• Work closely with the business systems analyst to develop the source to target data mappings

Confidential

DataWarehouse projects Senior ETL Consultant

Responsibilities:

• Design, develop and implement Data Extracts from Amdocs Ensemble billing system
• Design, develop and implement SMB Hierarchy Data Extract using recursive view and DataStage job
• Design and implement DataStage job for verification of The Order Tracking System Reports (IPOTS and IPHOTS)
• Consult on SQL Report changes according to the new source file layouts
• Design, develop and implement Data Stage jobs for the manual rerun of current production flow in case of failure
• Develop Unix shell scripts to automate the run of the above-mentioned processes
• ODBC to API changes to comply with current company standards

Confidential

Senior System Analyst

Responsibilities:

• Performance tuning of mapping and ETL processes
• Development of SQL scripts and stored procedures to augment the ETL process
• Develop Unix scripts to support the ETL processes
• Work closely with the business systems analyst to develop the source to target data mappings
• Play a lead role in the development of the ETL design document and transformation rules
• Play a lead role in the development of the design/technical specifications for the DataStage configuration

Confidential

Solutions Delivery Analyst

Responsibilities:

• Assisted with the conversion of data mart databases from the SQL Server to the DB2 environment using Ascential DataStage 6.0 and ER/Studio 7.1.
• Revised and developed databases for data mart projects
• Performed detailed business and data analysis to understand project requirements of the business areas and develop detailed business specifications.
• Coded, tested, and debugged all program modules and installation modules/procedures.
• Created all required system documentation for new, and revised programs and environments. Documented all data attributes and input into corporate repository.
• Trained staff on new or revised applications, systems, environment set-up or procedures as they relate to implementing and operating the solution in production. Provided guidance and cross to other analysts.

Confidential

Software Developer

Responsibilities:

• Designed Fraud detection unit of the Confidential ™ system based on decision tree algorithms.(C4.5, IIS, COM, ASP, VB, C++, Oracle 8i, Microsoft Access, Windows 2000 Server)
• Customized Microsoft Services using Confidential functions to generate request on the client machine in the KeyGen format.(Microsoft Services, Confidential, IIS, COM, ASP, ADO, C++, Windows 2000 Server)
• Created Client-Server Task Scheduler application. Wrote the core of the program in C++ using and wrote the GUI in ASP and Visual Basic.(ACE, C++, Oracle 8i, IIS, COM, ASP, ADO, Windows 2000 Server)
• Developed AllCare™ customer support management tool to monitor activities of site or individual account and to administer them.(ASP, Microsoft Access, PostgreSQL, IIS, COM, VB, VC++, ADO, Windows 2000 Server)
• Created “Online Consultation” ActiveX Control invoking MS NetMeeting functions. The same functionality was implemented using Java Applet and Java Server Application.