SUMMARY:

• Proficient in Source - to-Target data mapping.
• Experienced with Physical data modeling using ERWin modeling toolset.
• Proficient in the use of DataStage for ETL processes.
• Expert in tuning SQL queries to significantly improve application performance.
• Proficient at developing ad hoc queries requested by the SQL user community.
• Performed DBA, data analysis, data mining, and data modeler duties.
• Analyzed, designed, and maintained elements for data dictionaries.
• Significantly reduced the volume of data converted from a legacy system to an Oracle Data Warehouse using data mining, STAR, and 3NF modeling techniques.
• Worked closely with Oracle’s Data Warehouse consultants to design and implement a STAR schema data warehouse.
• Unloaded legacy data and staged it into a STAR schema warehouse using PL/SQL as ETL, also using DataStage as ETL tool.
• Mentored junior team members in the use of DataStage for ETL and Data Warehouse operations.
• Interacted with management and data analysts to define requirements for and to implement an executive management system.
• Consulted with 20+ JAVA developers to provide DB2 SQL database support.
• Communicated extensively with tech support of third-party vendors to customize their software.
• Facilitated multiple JAD sessions with end users and senior technical leads.
• Supervised, directed, and aided multiple analysts in troubleshooting. Worked closely with Teradata Data Warehouse consultants and instructors to learn the nuances of Teradata’s internal database structure.

TECHNICAL SKILLS:

SOFTWARE SKILLS: COBOL CVS DataStage 8.x and 9.x DB Visualizer DB2 DDL DML DOS batch files Eclipse Endeavor ERWin JIRA Librarian MS Office 365 Oracle 11G Oracle Designer Oracle Discoverer OWB OS/390 PL/SQL SCRUM SQL Developer SQL Server Teradata Teradata Studio Teradata SQL Administrator Teradata SQL Assistant TOAD for DB2 TOAD for Oracle Unix Scripts Windows 7/95/NT/XP/Server 2000

WORK EXPERIENCE:

Confidential, Charlotte, NC

Sr. ETL Developer

Responsibilities:

• Used DataStage 11.3 to create and modify processes for Bank of America.
• Gathered, documented and communicated with Business Analyst technical details of existing DataStage parallel jobs.
• Used AutoSys to run existing DataStage jobs. Monitored and assessed job completeness.

Confidential, Charlotte, NC

Sr. ETL Developer

Responsibilities:

• Used DataStage 11.2 to create and modify processes to aid TIAA-CREF in preparing their MDM system interface for larger volumes of data.
• Optimized the nightly batch cycle to handle 10 times the input volume utilizing Oracle Indexes and redesigning DataStage jobs in addition to implementing an archive process for very old data.
• Worked with Sr. management to create a new Child Support lien process to feed downstream deduction systems.
• Worked with the HR department to produce a preferred toll-free number for TIAA Advisors based on ZIP codes, office location and the frequency of calls to any particular phone number.

Confidential, Albany, NY

Database Developer

Responsibilities:

• Used SQL to create complex views of the NY Health Care system to aid State employees in finding fraudulent claims.
• Monitored SQL queries for performance issues and bottlenecks.
• Worked with Sr. management interpreting and analyzing their concerns and requirements.

Confidential

Datastage Developer

Responsibilities:

• Utilized Source-to-Target mapping.
• Converted OWB ETL processes to DataStage 9.1 with Oracle 11g database.
• Loaded data into Oracle Data Warehouse using DataStage 9.1 to replace PL/SQL packages and OWB processes.
• Created Unix and SQL Loader scripts for processes not being converted to DataStage.
• Created Oracle tables and indexes to support the ETL effort.

Confidential

Sr. Data Warehouse Analyst

Responsibilities:

• Utilized Source-to-Target mapping.
• Maintained Data Dictionary and Physical data mappings using ERWin toolset.
• Designed and implemented Teradata physical, access, and semantic database layers for use in new Teradata Data Warehouse
• Loaded data into Teradata and Oracle Data Warehouse using DataStage 8.7 to replace SSIS packages, PL/SQL packages and SQL Loader processes.
• Used DataStage 8.7 to port Oracle Data Warehouse to Teradata Data Warehouse.
• Worked with Unicode and Latin character sets within DataStage, Oracle, and Teradata to support multiple languages and alphabets.
• Mentored analysts in the use of DataStage to perform Data Warehousing functions.
• Wrote UNIX scripts to run DataStage from a command line and Control-M.
• Used DataStage Scheduler to aid in unit and QA testing.
• Improved performance of nightly batch with query tuning.
• Developed Data Models and system documentation to support Data Warehouse.
• Worked with Unicode and Latin character sets within DataStage, Oracle, and Teradata to support multiple languages and alphabets.
• Unloaded legacy data and staged it into a STAR schema warehouse using PL/SQL as ETL, also using DataStage as ETL tool.

Confidential

Data Analyst

Responsibilities:

• Subcontracted to the state of Tennessee as a project DBA and data analyst with emphasis on SQL tuning.
• Played key role in design and development of the internal software security philosophy and implantation.
• Gathered, documented, and communicated user requirements for Crystal Report writers.
• Transformed Excel spreadsheets into usable Rexx load files.

Confidential

Data Modeler/Project DBA

Responsibilities:

• As a subcontractor to the state of Tennessee, analyzed and designed relational database model including all data items and tables.
• Gathered requirements for and documented a data dictionary.
• Maintained physical data models using ERWin.
• Mentored JAVA development staff in using DB2.
• Tested and verified data transformations (ETL) for data warehouse.

Confidential

Senior Systems Analyst

Responsibilities:

• Progressed from a senior level COBOL/DB2 programmer to a senior systems analyst.
• Converted and upgraded mainframe DOS/Assembler application to COBOL/CICS/DB2 processes.
• Provided data analyst support in the design and creation of a data warehouse.
• Created test plans, as well as use cases.
• Developed Enterprise Data Warehouse using STAR schema, Oracle DB and Oracle tools.
• Tested and verified data transformations (ETL) for data warehouse.
• Maintained a data model and a data dictionary.
• Gathered, analyzed, and documented requirements.