CAREER PROFILE:

A skilled, talented and dedicated IT professional with over 20 years of diverse experience in ETL, with emphasis on IBM DataStage design, architecture and administration, Mainframe technologies, data warehousing, database design, data modeling, system design, coding, performance tuning and testing.

SUMMARY:

• Possess outstanding technical knowledge, including comprehensive understanding of Datawarehousing, ETL design and architecture, database design, logical and physical data modeling, data analysis, system analysis and quality assurance.
• Exceptional experience in analysis, design, development, optimization, implementation and testing of software applications and products.
• Strong background managing DataStage and Unix administrative tasks.
• In - depth knowledge of Mainframe technologies, tools, and best practices.
• Strong leader able to organize, train and lead team members as well as prioritize tasks in fast-paced, deadline-oriented environments.
• Team player with excellent communication and problem solving skills.
• Strong planning, organizational, and documentation skills.

TECHNICAL SKILLS:

ETL: DataStage PX and Server editions, including versions 7.5, 8.1, 8.5

OS : Unix AIX / Solaris 10 / HP-UX, Linux SUSE, z/OS, MVS

Software and Languages: SQL, SQL Plus, Unix Shell scripting, Cobol, JCL, SPUFI, QMF, FTP, XML, Mainframe Utilities , SyncSort, ERwin, Toad, PowerDesigner, MS Access, VSAM, MS Office Suite, SQL Developer, Expediter, Eztrive, File-Aid, Confidential, BusinessObjects, Autosys, CA-7.

Databases/RDBMS: DB2/LUW, DB2/zOS, Oracle 10g/11g, IMS DB.

PROFESSIONAL EXPERIENCE:

Confidential, Detroit, MI

Sr. DataStage Developer

Responsibilities:

• Develop code for Data Warehouse in support of business intelligence projects using DataStage tool as well as Unix scripts.
• Integrate data from multiple source systems into Data Warehouse and Data Marts
• Participate in architectural decisions for data transitions from source to staging to ODS to EDW
• Develop SQL code to create Oracle objects such as tables and views, and retrieve / update data in Oracle tables.
• Perform technical reviews, performance tuning and implementation of best practices.
• Schedule and implement processes in production in collaboration with Sustain team.

Technical Environment: HP-UX, IBM DataStage 8.1, Oracle 10g, SQL Developer, Autosys, MS Office tools.

Confidential, Southfield, MI

DataStage Analyst / Data Management

Responsibilities:

• Analyze data and determine necessary processes and procedures for populating data into project's DataMart from various sources.
• Design and develop necessary ETL procedures, mostly based on DataStage, as well as Unix scripts, for loading data into DataMart, and creating necessary documentation for turning processes to production support team.
• Perform quality analysis on complicated data sources

Technical Environment: Solaris 10, IBM DataStage 7.5.3, Oracle 11g, Toad 9.5, SQL Developer, MS Office tools, Cognos 8 / 10.

Confidential

DataStage Analytical Specialist/Administrator

Responsibilities:

• Implement modifications to the existing DataStage architecture to reflect changes in the application environment, such as addition of new projects, increased data volumes, new data sources.
• Assess technical and corporate requirements for new projects and installations.
• Administer, upgrade, and migrate ETL/DataStage environments, including new installations.
• Resolve DataStage issues either internally or by interfacing with IBM support team.
• Serve as SME to developers and support teams on DataStage job design and optimization.
• Effective project planning and migration of all projects in DataStage 7.5 to DataStage 8.1 /8.5
• Monitor ETL performance and storage usage, perform analysis of capacity.
• Provide on-call support to production systems to resolve any issues.

Technical Environment: SUSE Linux 10.1 and 11.0, IBM DataStage 7.5/ 8.1/ 8.5, Oracle 10g / 11g, DB2 9.1, SQL Developer

Confidential, Troy, MI

Senior Datawarehouse ETL Designer

Responsibilities:

• Maintained and enhanced existing ETL process to provide uninterrupted flow of data to the Daimler Financial Datawarehouse.
• Analyzed and modified ETL procedures to accommodate customers' requests.
• Designed JCL procedures, UNIX shell scripts, complex SQL statements and Optiload scripts.

Technical Environment: UNIX AIX, IBM Mainframe, JCL, Cobol, IBM DataStage 7.5, Optiload, Autosys, Embarcadero Rapid SQL, DB2/UDB.

Confidential, Detroit, MI

Responsibilities:

• Paricipated in projects evaluation and writing proposals

Confidential

Lead ETL Designer/ Architect

Responsibilities:

• Participated in database design of UDB based Datawarehouse and Datamarts.
• Applied advanced design principles such as star schema, snowflake, de-normalization.
• Created and maintained logical and physical data models using ERwin and PowerDesigner.
• Designed and developed DataStage parallel and server jobs, Unix shell scripts, UDB SQL procedures and load scripts.
• Designed JCL mainframe procedures, Cobol programs, and SQL scripts to extract and transform data from multiple sources, including DB2, IMS DB, and sequential files into ETL staging area.
• Planned and executed data migration between UDB databases during servers de-commissioning.
• Managed and trained ETL developers and advised them on ETL development best practices in DataStage and Mainframe as well as conducted design and code reviews.
• Responsible for creating and maintaining ETL documentation.
• Supervised unit and system tests and assisted users with acceptance testing.
• Designed complex ad-hoc SQL queries to satisfy unique data requests from senior level end users.
• Developed procedures to populate historical and missing data into Datawarehouse and DataMarts.
• Met with department heads on regular basis to review and interpret data, assure accuracy of transformation process, and gather additional requirements.
• Responsible for addressing all data quality issues and concerns raised by end users.
• Secondary support for BusinessObjects.

Technical Environment: UNIX AIX, IBM DataStage 7.5, IBM Mainframe, DB2/UDB, Cobol, JCL, FTP, SyncSort, MS Access, MS Office Suite, IMS DB, ERwin, PowerDesigner, XML, BusinessObjects.

Confidential

Senior System Analyst / Team Lead

Responsibilities:

• Lead a team of 3 to 5 developers, developed work plans, managed assignments, and ensured timely and accurate completion of tasks assigned to the team.
• Performed comprehensive analysis of existing data and helped developing requirements for additional data sources.
• Wrote specifications for Confidential and Cobol batch programs, and JCL procedures.
• Developed Confidential and Cobol DB2 batch programs and Stored procedures, JCL procedures, DB2 SQL scripts, SynSort and other Mainframe utilities scripts.
• Assisted team members in optimizing DB2 queries and coordinated DB2 development, such as creating and removing indexes, scheduling reorgs, partitioning, and constraints, with DBA.
• Designed reusable and scalable Cobol DB2 stored procedures to be used by other team members.
• Reviewed documentation, code and conducted code walkthroughs.
• Conducted prove of concept for high visibility task of auto parts supercedence.
• Met with end-users and conducted interviews to gather requirements.
• Developed and supervised unit and system tests.

Technical Environment: IBM Mainframe, DB2, Cobol, Confidential, JCL, IMS DB, SynsSort, File-Aid, Xpeditor, Panvalet, CA-7, MS Access.

Confidential

Senior Programmer Analyst

Responsibilities:

• Designed on-line Monthly Balancing report system of General Ledger accounts.
• Coded Cobol Confidential /DB2, Cobol DB2 batch programs, and JCL procedures.
• Performed technical analysis and evaluations of in-line printing using Confidential .
• Conducted unit, system, and user acceptance tests.
• Took part in creating several user manuals and guides for business customers.
• Participated in conversion from Panvalet system to ChangeMan.

Technical Environment: IBM Mainframe, DB2, Cobol, Confidential, JCL, VSAM, SynsSort, File-Aid, Xpeditor, Panvalet, ChangeMan.

Confidential

Responsibilities:

• Leading Analyst for System testing of the Inventory Cost Accounting system.

Technical Environment: IBM Mainframe, COBOL II, Confidential, JCL, VSAM, Datacomm, TSO/ISPF, Xpeditor, Librarian

Confidential, Chicago, IL

Sr. Programmer/ Analyst

Responsibilities:

• Enhanced the existing on-line system, allowing Confidential to change and adjust hiring and effective dates of sales personnel, which led to more accurate commission payment.

Technical Environment: IBM Mainframe, COBOL II, Confidential, JCL, DB2, VSAM, TSO/ISPF, Panvalet.

Confidential, Southfield, MI

Lead Programmer Analyst

Responsibilities:

• Worked on the new release of the Patient Care Scheduling system.
• Significantly improved the accuracy and efficiency of the scheduling system by moving the major scheduling process from PC based spreadsheets to Mainframe.
• Lead project to develop a system, designed to monitor unattended background transactions.
• Completed pilot project to allow end users, inquire data from Mainframe files and analyze them n individual PC.

Technical Environment: IBM Mainframe, Cobol, Confidential, IMS DB, VSAM, JCL, File-Aid, Xpeditor, Panvalet, Windows PC, MS Access, MS Excel

Confidential

Programmer Analyst

Responsibilities:

• Developed a system to produce customized reports for Customer Service and Billing departments.
• Designed and wrote a number of Cobol batch and Confidential programs and JCL procedures

Technical Environment: IBM Mainframe, Cobol, Confidential, VSAM, JCL, File-Aid, Xpeditor, Librarian.

Confidential, Livonia, MI

Programmer Analyst

Responsibilities:

• Designed and wrote Cobol batch and Confidential programs and JCL procedures for various lines of individual life and health insurance business.
• Regularly met with customers to gather requirements, discuss completed assignments, and propose new improvements to the existing systems.
• Took part in developing IT coding standards.
• Developed project plans and coordinated data exchange between various systems

Technical Environment: IBM Mainframe, Cobol, Confidential, VSAM, JCL, Xpeditor, Panvalet.