SUMMARY:

• Skilled software developer, bringing more than 25 years in software design development and system programming to the table.
• Knowledgeable Data Warehouse Developer skilled in ETL, SQL, and data analysis.
• Professional with advance knowledge of mainframe programming languages COBOL, CICS and DB2.
• Dedicated business analyst communicating and transferring information from business users to IT department.

TECHNICAL SKILLS:

• SQL Server 2008
• T - SQL
• ETL
• SAP Business Objects Data Services.
• Data integration
• SQL Assistants Teradata

PROFESSIONAL EXPERIENCE:

Software Engineer

Confidential, Baltimore, MD

Responsibilities:

• Designed and created BODS 4.2 job to migrate data from source to target data marts.
• Constructed ETL solutions.
• Developed and tested tables using SQL Server 2012 for source, lookup and tables.
• Utilized mapping documents to transform and push data to fact and dimensional tables.
• Advised project managers and coworkers to resolve mapping and data issues.
• Communicated with the team daily to keep abreast of status of project.
• Collaborated with coworkers to resolve problems and come up with better solutions.

IT Consultant

Confidential, Clearwater, FL

Responsibilities:

• Developed ETL jobs using SAP Business Objects Data Services 4.2 to populate fact tables.
• Wrote scripts using Teradata database within Data Services jobs.
• Ran and tested scripts using SQL Assistants.
• Prepared documentation and Data Services projects for promotion to QA and production.
• Communicated with team members to find viable solution to problems.
• Communicated in close collaboration with QA analysts, data owners and data architects.

Data Warehouse Developer

Confidential, Columbia, SC

Responsibilities:

• Designed and developed ETL solutions using SAP Business Objects Data Services 4.2.
• Modified and maintained ETL programs for the data warehouse and reporting.
• Developed queries (T-SQL) using SQL Server 2008 to test data warehouse tables.
• Wrote flat files using COBOL programs to be used as data source.
• Communicated and collaborated with Attunity to configure change data capture (CDC).
• Monitored and troubleshoot production support issues.
• Prepared documentation for the ETL process.
• Communicated with other users and managers to gather information to prepare reports.
• Trained and mentored other team members as Tech Lead.
• Worked with SDLC process.
• Maintained and administered SAP Business Object environment.
• Installed and configured Information Steward 4.2.
• Installed, upgraded and configured SAP Data Services 4.2 and SAP Crystal Reports.
• Installed and configured SAP BI Platform 4.0 SP7 and promoted reports using Promotion Management.
• Scheduled reports in BI Launch Pad.
• Granted security access to users as administrator.
• Supported on-call production.

System Programmer

Confidential, Columbia, SC

Responsibilities:

• Used SMP/E for third party software migration and maintenance.
• Worked with programmers to test new release of software products.
• Prepared documentation for testing and back-out plans.
• Updated license keys for third party software.
• Communicated with software vendors to obtain information and resolve issues.
• Granted security access to users using RACF.
• Assisted application programmers and staff members using software products.
• Supported on-call production.

Application Systems Analysis

Confidential, Columbia, SC

Responsibilities:

• Modified programs using CICS and COBOL APS programs.
• Created and modified JCL and procedures for production.
• Wrote Easytrieve programs using flat files and SQL in order to create reports.
• Facilitated work sessions to gather requirements from clients.
• Prepared scope/design documents for system changes.
• Performed code walkthrough review.
• Communicated with client to resolve problematic log issues.
• Ran and tested queries using QMF.
• Supported on-call production.

Information System Consultant

Confidential, Columbia, SC

Responsibilities:

• Wrote Easytrieve programs using flat files and SQL in order to create reports.
• Ran and tested queries using QMF.
• Modified programs using APS.
• Created and modified JCL and procedures for production.
• Supported on-call production.

Information System Consultant

Confidential, Columbia, SC

Responsibilities:

• Queried the data warehouse by writing DB2 programs thereby creating load files.
• Loaded data warehouse tables with flat files using FILE-AID for DB2.
• Wrote data quality programs to insure data integrity among the data warehouse.
• Ran and test queries using SPUFI

Account Manager

Confidential, Columbia, SC

Responsibilities:

• Assigned tasks and ensure successful completion.
• Contacted other managers to convey customers’ requirements.
• Interviewed potential candidates for employment and made selection recommendation for hiring.
• Estimated projected profits for the next quarter.
• Modified programs using Centura or SqlWindows.
• Modified Microfocus COBOL programs.

Programmer/Analyst

Confidential, Columbia, SC

Responsibilities:

• Wrote and tested CICS/DB2 interface programs.
• Created GUI for internet system using Visual Basic 5.0.
• Created physical and logical object in the data dictionary.
• Generated DDL and modified tables, views and indexes.
• Wrote program specifications for smalltalk claim system.
• Researched mainframe systems to write technical specification for VB programs.
• Traveled in order to obtain information necessary to write specification.

Engineering Analyst II

Confidential, Greenville, SC

Responsibilities:

• Developed, maintained and tested PC applications utilizing Microfocus Workbench.
• Modified and tested COBOL and CICS programs.
• Provided on-call support for night jobs and help-desk problems.
• Presented software demonstration and participate in quality review.

Programmer/Analyst I

Confidential, Greenville, SC

Responsibilities:

• Developed and tested CICS programs utilizing Microfocus CICS workbench.
• Maintained CICS program and tested on mainframe.
• Updated procedures and submitted JCL for users.
• Interacted with programmers and users to provide program changes and enhancements.

Programmer/Analyst I

Confidential, Columbia, SC

Responsibilities:

• Developed, enhanced and tested command-level CICS programs according to user needs.
• Developed and maintained batch COBOL programs.
• Created and designed CICS screens utilizing SDF.
• Created and submitted JCL to provide test runs for COBOL programs.
• Provided documentation for COBOL programs.

Programmer/Analyst

Confidential, Columbia, SC

Responsibilities:

• Maintained, tested and enhanced COBOL programs.
• Created and updated multiple step procedures according to clients’ specifications.
• Monitored and ran system test cycles for clients.
• Provided client on-site support and .