SUMMARY:

Extensive experience in software development. Cognos experience, 10 years. Open systems and relational database experience, 15 years. Experience in ERP Systems development, 5 years.

TECHNICAL SKILLS:

HARDWARE SYSTEMS: SUN SparcStation; Hewlett - Packard HP-9000, HP-3000; DEC Vax; Intel Pentium; Confidential 3090, RS-6000.

SOFTWARE SYSTEMS: SAP ABAP Programmer’s Workbench, Oracle ERP Manufacturing and Financials applications. Oracle8i, Websphere, MQSeries, BMC-Patrol, Developer 2000 Forms and Reports, Mercator, Web FOCUS Desktop, Cognos, Quick, Quiz, QTP, “C”, Fortran, Basic, Cobol; UNIX, Solaris, HP/UX, AIX, Shell Scripts, Perl, Windows 2000, Novell, VAX/VMS, HP-MPE/iX; Pro*C, PL/SQL, SQL*LOADER, SQL/DS, Trim.

EXPERIENCE:

Confidential

Oracle Data Warehouse Developer

Responsibilities:

• Developed Material Number Expansion project on Oracle Data Warehouse.
• Developed PL/SQL packages, procedures and functions. Altered Tables and Materialized Views.
• Performed Debugging and Unit Testing of PL/SQL procedures.
• Developed SQL*Loader control files and Unix shell scripts for loading SAP data.

Confidential

Database Consultant

Responsibilities:

• Provide consulting services for Oracle PL/SQL and SQL Server.
• Design dimensional data models and write ETL functional design documents.
• Interface with Cognos team and provide Oracle database views for reporting.

Confidential

Senior Database Developer

Responsibilities:

• Worked with accounting of Fixed Income Securities.
• Developed enhancement to Veritude Time accounting system for accrued sick leave of hourly workers. Oracle 10g, PL/SQL stored procedures.
• Replaced Informatica procedures for masking of personnel data (PII). Masked private data in SCOUT system using SQL Server 2012 and SSIS packages.
• Developed Business Objects reports for Personnel records and time accounting.

Confidential

Data Quality Engineer

Responsibilities:

• Fined tuned Oracle database queries using views indexes and optimizer hints; improved performance of COGNOS dashboards, Tableau and Web reports.
• Defined process flows for ETL (DataStage) applications based on client requirements.
• Developed specifications for Data Stage ETL to integrate Mainframe DB2 database with Oracle-based Health Care Provider data warehouse.
• Analyzed and designed ETL strategies and processes, wrote Functional Specifications.
• Worked on external data loaders using DataStage ETL, EDI and Oracle SQL Loader.
• Developed procedures for Data Governance, Critical Data Elements (CDE) and Data Certification.
• Exported frequency analysis and format violation reports from Information Analyzer for Cognos reporting.
• Developed, tested and implemented Business Data Rules in Information Analyzer for Biometrics and Eligibility data.

Confidential

Senior Database Developer

Responsibilities:

• Developed marketing data mart applications, using Oracle 11g database and Netezza data warehouse tools. Developed Name Cleansing routine for Agility demographic data input.
• Developed SQL code and Perl scripts on Red Hat Linux platform, for Code Conversion, Change Data Capture, staging tables and data archive.
• Developed User Defined fields and Key Performance Indicators for the Reporting Data Mart.

Confidential

Senior Oracle Developer

Responsibilities:

• Developed Oracle PL/SQL stored procedures, functions and packages using Toad.
• Converted MS Access Debit Balance Report to Oracle PL/SQL stored procedures to simplify and streamline a very complex weekly process.

Confidential

Senior Oracle Developer

Responsibilities:

• Developed project management reports as an enhancement to CA Clarity PPM project portfolio management system.
• Developed Clarity portlets, NSQL and MySQL queries in a Web Services environment with SOAP and XML.
• Developed and system tested hierarchical Crystal Reports for project management system.
• Developed SQL queries for use in Business Objects reports.
• Developed custom data entry screens and user-defined fields to enhance Clarity application.
• Developed Oracle PL/SQL stored procedures, functions, views and triggers for Clarity reporting.
• Reviewed and unit testing GEL code for Clarity Work Flow enhancements.

Confidential

Senior Consultant

Responsibilities:

• Developed Oracle 10g software to load, process and report data for the Webster Marketing Data Mart project. Designed and developed Oracle PL/SQL stored procedures, functions and packages on a Unix platform. Developed reports using Oracle Reports Builder 6i.
• Developed Perl and Unix shell scripts to execute SQL*Loader and PL/SQL procedures. Developed automated data interfaces between Webster and third-party service bureaus.
• Downloaded Marketing Data Mart data to SAS data sets for use in market analysis.

Confidential

Technical Interviewer

Responsibilities:

• Provide oral examination of candidates’ technical skills to hiring consulting firms.
• Summarize and rate candidate’s technical skills (Oracle 11g, PL/SQL, Unix, Cognos, etc.)
• Provide detailed write-up of candidate’s technical strengths and weaknesses.

Confidential

Senior Consultant

Responsibilities:

• Extensive experience with HP OpenVMS platform, developing DCL command scripts.
• Converted CPM monthly premiums and losses application from SQL/Plus scripts to PL/SQL stored procedures, functions, packages and triggers. Used Oracle database on HP OpenVMS platform.
• Designed and developed enhancements to ASP Web pages for Confidential ( Corporate Online Reserving System). Developed Web reports using ASP, Javascript, Toad and Oracle PL/SQL stored procedures.
• (Windows XP, VMS, TSO; Frontpage, ASP, Java Script, Oracle 9i database, PL/SQL, Toad)

Confidential

Senior Consultant

Responsibilities:

• Developed ETL pricing interfaces for the following security types: Equities, Asset-backed, Mortgage-backed, Derivatives, High-Yield Bonds, Derivatives, Credit Default Swaps (CDS), Swaptions, ETFs, Fund of Funds.
• Developed interfaces between Eagle Star and data feeds from Bloomberg, SIRS and Wmdaten.
• Used ETL tools Websphere TX, MQSeries and Confidential Websphere 5.0.
• Developed and enhanced fund accounting applications, including Eagle Star and Eagle Pace.
• Developed PL/SQL stored procedures for the Oracle, 9i databases.
• Developed interfaces for Security Master Data Management (MDM).
• (Eagle Star, Pace; Windows XP, Unix, TSO; Oracle 9i, PL/SQL, Confidential Websphere, MQSeries, Mercator)

Confidential

Senior Consultant

Responsibilities:

• Used the following Oracle Financials core applications: System Administration, Purchasing Super User and Payables Super User.
• Custom applications included Confidential Error Manager Interface and OCI, an interface between Oracle Requisition and Prism Acquisition.
• Confidential is the Federal Financial Information System, based on an Confidential mainframe.
• (Windows XP, Confidential AIX; Oracle Financials 11i, iProcurement, PRISM, PL/SQL, Forms 6i, Toad, Confidential )

Confidential

Senior Technical Consultant

Responsibilities:

• Contributed to the implementation of Oracle iProcurement, a web-enabled interface to Oracle Purchasing 11i. Developed PL/SQL packages to convert legacy purchase orders, vendors and items to Oracle Financials. Developed Unit Test plans. Participated in System Test.

Confidential

Senior Technical Consultant

Responsibilities:

• Upgraded custom interfaces for the conversion from Oracle Financials 11.5.8 to version 11.5.9. Designed, coded and tested Unix shell scripts, PL/SQL stored procedures and SQL*Loader control files. Used Unicenter to trigger data load scripts.
• Registered custom Oracle tables and concurrent requests. Converted custom Oracle Forms and Reports to version 6i and Oracle database 9i.
• Develop enhancements to Oracle iProcurement system.
• Develop PL/SQL packages, which are used by Oracle Workflow to process approvals and generate purchase orders. Implement electronic invoices in cXML and EDI ANSI X12 formats.
• Develop process to load invoices to Oracle Payables (AP). Code HTML help screens for the Biogen Web page.