Dave Decker Email & Phone Number

Albany, New York

Oracle Reports Business Requirements Analysis, Reports Technical Specifications, Team Mentoring, Back End Automated Data ETL

I am a data integration expert with a passion for solving business and education data challenges. Having worked for a Fortune 50, government agencies, a health insurance company, and large and small education agencies, my experience is broad and diverse. My strengths include expertise in large RDBMS systems, data warehousing, relational database design, application architecture, modeling, development, implementation, and process scheduling and automation.TECHNICAL EXPERIENCEIBM Rational Team Concert, IBM Rational Insight, IBM Cognos 8 BI Data Manager, Framework Manager, Report Studio, EDI, Microsoft SQL Server, TSQL, Oracle PL/SQL, SQL*Plus, SQL*Station, Oracle SQL Developer, Oracle Designer, Oracle Developer, Oracle 7.x, 8.x, 8i, 9i, 10g; Oracle Applications 10.7, PeopleSoft 8, Oracle Forms & Reports, HPUX, AIX, Unix, Korn Shell Scripting, VMS DCL Scripting, Cold Fusion 4.5 Application Server, IIS, Apache, Tomcat, Web Sphere, Active Server Pages, MS Access.

Empire State Plaza, Albany Ny

Lead Process Architect / Developer- Designed, Coded, Tested, and Documented end-to-end data integration process between new SQL Server Electronic Death Registry System and legacy Oracle data stores for statewide death data for New York State Department of Health Vital Records Bureau. - Complete data-integration process design, build, test, and mentor from SQL Server application using TSQL data extracts, functions, and stored procedures with dynamic SQL via linked server to Oracle data repository.- Designed and built completely autonomous batch, transform, and load processes to load new translated death records to Oracle legacy death master file records. Oracle processes included data modeling, creating tables, sequences, triggers, indexes, packages, procedures, functions, all permissions, error and status logging via log4plsql, and mentoring NYS staff on application details and functionality.

Albany, New York Area

System Administrator IBM Jazz Rational Team Concert. Change manager/developer for all RTC and Rational Insight enhancement requests. Designed, Authored, Tested, and Deployed all reports and customized Cognos/Insight ETL from RTC and RQM to data warehouse for enterprise reporting on RTC CLM tool. Product Information System (PIMS) data modeler and database design lead. Authored FACETS shellbuild PIMS modules to stage Oracle load to FACETS environments. Script PIMS data updates to remedy defects and coordinate with FACETS system data. Administrator and reports author for Cognos enterprise reporting platform relating to CLM tools. Working on a project team and implementing complex project in a Microsoft SQL Server environment, including developing database models, application programming, referential integrity constraints, database triggers, database stored TSQL procedures, and coordinating version control migration through DEV, QUAL, PROD application environments.

Albany, New York Area

Consultant to augment State Staff to maintain, enhance, and upgrade enterprise applications, including Rate Setting (RS), Bureau of Community Funding (BF), Community Service Expansion Plan (CSEP), and Capital System (CS) applications. Developing Oracle Forms & Reports using Oracle Developer 2000 for implementation in a character-based environment. Creating and modifying relational database structures for Oracle DBMS versions 8.0, 8i, 9i, 10g. Upgrading enterprise Oracle applications from character-based to web-based applications, version 10g. Working on a project team and implementing large, complex projects in an Oracle Rapid Application Development (RAD) environment, including developing database models, application programming, referential integrity constraints, database triggers, forms resident and database stored PL/SQL procedures, and coordinating version control migration through DEV, TEST, PROD application environments. Developing and executing comprehensive test scripts, fully documenting results for user acceptance and deployment to production environment. Developing technical and end-user documentation, and user training materials. Presenting design reviews, code reviews, and application training to management and other developers. Designing, coding, and testing application processing scripts on VMS using DCL on Digital/HP Alpha servers. Creating and modifying Korn Shell scripts on Unix platforms including AIX, and HP/UX. Oracle application development on Citrix platform. Oracle Pro-COBOL application development, compilation, linking, deployment, and conversion to PL/SQL database stored procedures. Production application data migrations/updates/deletions to retain data integrity or recover from end-user data-entry errors.

Albany, New York Area

Responsible for data analysis and business process improvement projects, enhancements, and troubleshooting in Accounts Payable group of Fortune 40 Insurance and Financial Services Company. Systems and business rules analyst for eInvoicing project: authored requirements specifications for transition of $1.02Billion and 115,000 payables from paper and/or EDI to third party administrator.Developed queries in PeopleSoft Query tool and MSAccess to identify top 2125 (15%) vendors accounting for 77% of spend for targeted conversion to eInvoicing. Generate data analysis reports and author specifications for data integration/archive for mergers, acquisitions & divestitures. PeopleSoft systems analyst. Business requirements documentation for process improvement initiatives. Complete test script development, execution, documentation, coordination with lines of business.PeopleSoft upgrades; PeopleSoft Query tool. EDI Lead Analyst. AP upgrade team PeopleSoft 8.8/Oracle 9i. Participate in Team development process across MetLife Enterprise. Business rules documentation, specification, and QA on large-scale development projects, including PeopleSoft, EDI, & eInvoicing.MetLife System Admin for eInvoicing application at http://www.xign.net responsible for system configuration; security; daily processing volume verification; problem troubleshooting, documentation, and resolution; coordination of vendor setup, verification, and data transmission in web portal.Responsible for enterprise MetLife documentation of eInvoicing processes, guidelines, and procedures, both user and administration. Responsible for enterprise user access and security.Developed end-user training regimen, materials, curriculum, mode of delivery (webinars) for all Metlife enterprise users. Delivered daily training for e-invoicing initiative.

Albany, New York Area

Database application developer and project Technical Lead Developer on system development and enhancement projects. Lead technical development team on legacy-to-web financial account reconciliation initiative for $6 billion New York Control Area power market. Database architecture and application development in Oracle 8i & 9i environments with stored Oracle PL/SQL procedures, coordination of enterprise-wide development projects. Developed 'Business Rules Implementation Plan' (BRIP) Oracle database application for enterprise database applications. As Technical Lead Developer, responsible for translating Business Rules & project Functional Requirements Specifications into complete System Design Specifications, detailing all development phases and activities. Lead development team through project development life-cycle, coordinate Database ERD for multiple databases, Oracle Forms 6 & 6i, Reports 6 & 6i, developer 6i, Web applications, Oracle Stored Procedures, Views, Packages, Triggers, and Functions, for deployment to 24x7 production OLTP environment.Coordinate and present application demonstrations and project status updates. Completed test plans and coordination with Quality Assurance group.Confidential treatment of sensitive market information and data. Project management & process control with MSProject, Rational Rose UML, and RUP.Oracle Server 7.3.4, 8.0.x, 8.1.x, 9i, PL/SQL, SQL*Plus, SQL*Station, Oracle Designer, Oracle Developer 6i, MKS Source Control, Toad; Batch and OLTP Application Development; Performance tuning of Database Objects, SQL Views, PL/SQL stored procedures, and Packages. Training, demonstration, and mentoring on system enhancements and new systems.

Certificate Of Advanced Study (Cas), Education - Etap - Curriculum & Instruction

Activities and Societies: School of Education PhD Program - Curriculum & Instruction Presenter: European Humanities University eLearning.

Ma, Math Education

Bachelor'S Degree, Mathematics And Computer Science

Chemical Engineering

Activities and Societies: Delta Upsilon Fraternity