SUMMARY:

• Confidential is a senior ETL developer and data architect. With more than fifteen years of experience with managing, designing and developing distributed database systems in the Medical claims/Invoicing, Pharmaceutical drug ordering processes, HR, Finance, Telecommunication, Material Handling, Fare Collection, Rapid Transit, Health Care and Shipping industries.
• He has performed database server administration (RAC/OPS environments), Oracle Applications installation/maintenance, Oracle E - Business Suite Balanced Scorecard design/implementation, performance and tuning, replication, application/server programming, ETL, data translation, automation of backup/recovery process, training, installation, technical writing, function/process modeling and Logical/Physical database design (MDM) of OLTP and Data warehouse systems.
• He has managed full life cycle database projects consisting of developers, report writers, data modelers and administrators. In addition to database experience, he has successfully led training seminars and mentored business application groups in database access and theory. As a member of various consulting organizations, Confidential . Confidential has developed effective leadership, communication, presentation, technical writing and client management skills.

TECHNICAL SKILLS:

Databases: Oracle 12c Exadata, Teradata 14, SQL Server 14, MemSQL/SingleStore 7, DB2, Sybase 11, Access

Tools: Oracle Data Integrator (ODI) 12.2, Informatica 10.2, IBM Infosphere Datastage 8.7, Oracle Warehouse Builder (OWB) 11.2, Microsoft DTS, Oracle Business Intelligence Enterprise (OBIEE 10.1.3)/Siebel Analytics, MicroStrategy 8.1.1, Hyperion (Brio), CA Erwin, Oracle Balanced Scorecard 11.5.2, Oracle BI Discoverer Admin 10g, Oracle Designer 2000, Oracle Developer (Reports 9i), Business Objects (Crystal XI Enterprise Server/Developer), RMAN, Quest SQL Navigator, TOAD, SQL Developer, SQL Server Management Studio (SSMS), S-Designer, Oracle Enterprise Manager, System Architect, Rational Rose.

Software: Oracle 12c database server, Oracle Workflow Server (10.6.2), Oracle Applications (ERP) 11i (GL,HR,AP,AR,PO/INV),MAXIMUS FA Suite, CUBIC Nextfare, Oracle Application Server 9ias, Portal, J2EE, Apache Tomcat, JCL, Quest Shareplex, PeopleSoft, Transarc Encina Transaction Monitor (utilizing DCE), Documentum, Starteam, Visual Source Safe, GIT and PVCS configuration management.

Hardware: HP (9000), SUN (1000, 10000), EMC 5460 disk array, IBM mainframe

OS: Solaris 2.6 - 2.9, HP UX, LINUX Redhat and Ubunto, IBM MVS, DEC (VAX, Alpha), Windows NT, 2000, XP

Languages: PL/SQL, T-SQL, SQL, HTML, XML, Python, Perl/C/Korn shell, Sybperl, Ada, FORTRAN

Design: Kimball, Yourdon, Booch, OMT, UML, Spiral, Waterfall, JAD and RAD

Tuning: Database architecture, Memory, I/O, PL/SQL and Kernel parameters

PROFESSIONAL EXPERIENCE:

Confidential

Senior ETL Architect/Developer

Responsibilities:

• ETL processes designed, implemented, scheduled and maintained with ODI, Informatica and custom packages (PL/SQL and MS Transact SQL). Design and implement Data marts. Performance tuning ETL and DataMarts using techniques such as Partition Exchange, parallel processing, stage tables, temp tables, With clauses and Window functions. Source and target databases: Oracle, SQL Server and MemSQL/SingleStore.
• Built interfaces from OLTP systems (Hospital and Pharmacy Claims, Invoices, Drug Dispensations and Drug Utilization) to Datamarts (340B, Analytics, Drug) that are utilized by reporting systems (Tableau, Oracle Applications Cloud (OAC) and custom reports). Built ODI and Informatica interfaces to Salesforce for Account information and Salesforce case. Datamarts designed and hosted in Oracle, SQL Server and MemSQL/SingleStore databases.
• Built interfaces to standard medical systems: Centers for Medicare & Medicaid Services (CMS) and American Medical Association (AMA) to load reference data: (ICD10 diagnosis and procedure codes, Current Procedural Terminology (CPT4), Healthcare Common Procedural Coding System (HCPCS), Medicare Severity Diagnosis Related Groups (MS-DRG).
• Production support of Oracle and Informatica ETL processes.
• Utilized GIT for source control, Jira for issue tracking and Confluence for documentation. Daily collaboration using Microsoft Teams.

Confidential, Atlanta, GA

ETL Architect/Developer

Responsibilities:

• ETL processes designed, implemented, scheduled and maintained with Oracle Warehouse Builder (OWB) 11gR2 and custom PL/SQL packages. Design and implement Data marts. Performance tuning ETL and DataMarts.
• Built HL7 interfaces from Data Warehouse (Hospital and Community data marts) to private hospitals and community physician offices utilizing the Georgia Health Information Network.
• Production support of Oracle ETL processes in areas supporting State hospitals, long term care and private Medical service providers.
• Performed complete migration from OWB 11 to ODI 12.2 (model, mapping, process flows, procedures and scheduling). Utilized oracle migration utility to convert mappings. 90 Dimensions and 27 fact table migration completed in two months. Trained team members in OWB and ODI.
• Designed and implemented ROLAP (Kimball star schema) datamarts in Teradata data warehouse for Transportation Performance and Safety Systems. Data sources were Oracle, DB2, Teradata, Access, SQL Server databases and mainframe applications. Master Data Management (MDM) methods employed to consolidate/aggregate and provide consistency across reference data of business units within company.
• All Metadata for OLAP, ODS and OLTP systems designed and maintained in Erwin repositories. Star Schemas used both type I and II (SCD) dimensions.
• ETL processes designed with IBM Infosphere Datastage, stored procedures and JCL programs. Mainframe and Datastage jobs scheduled via mainframe Zeke scheduling tool. Error handling notification via mail/phone managed by sending failed job results to Automation Point notification system.
• Brio, IR and OBIEE reporting utilized ROLAP (star schemas) and OLAP cubes to fulfill all new business reporting requirements.
• Designed BI Applications:
• Dashboards using OBIEE/Siebel Analytics: Designed DW subject areas, imported objects (tables, views, queries) into physical layer, built business layer for facts and dimensions, designed answer requests/reports using existing report models and new requirements and integrated reports into Dashboards.
• Reports were based on existing Hyperion (Brio) reports and new system requirements.
• Data Warehouse Architecture/DBA tasks:
• Manage Backup and Recovery operations (Data pump exports and RMAN backups). Database Performance monitoring and tuning utilizing Oracle AWR and custom database scripts.
• ETL processes designed with Warehouse Builder (OWB) 10gR2, Informatica and custom PL/SQL packages. Design and implement Data marts
• Production support of Oracle databases and ETL processes for Retail Distribution, Sales and Warehouse Management systems.

Confidential, Atlanta, GA

Responsibilities:

• Designed/implemented reports/services and dashboards in MicroStrategy. Subject areas consisted of Emergency Room availability/utilization, Physician metrics for different types of specialty and Medicine metrics for lab testing.
• Designed/implemented ETL processes utilizing IBM Infosphere Datastage.
• Architected the Microstrategy components to support the reports: Tables, views, Facts, Attributes, Metrics, Filters, Prompts and Custom Groups. OLAP services were facilitated for movement of report objects and flexibility with derived metrics.
• Reports and Dashboards supported middle/upper management as well as operational data via drill down and standalone reports. Administered Narrowcast Server for report distribution.
• Designed and implemented ROLAP datamarts with Metadata stored in OWB and Erwin repositories. Master Data Management (MDM) methods employed to consolidate/aggregate and provide consistency across reference data of business units and 10 merged companies. Subject areas consisted of Payroll, Timekeeping, Retail (Deliveries/Returns/Pricing) and Customer Sales Activity (AR). Each datamart utilized Kimball (star schema) design methodology with type I and II (SCD) dimensions and fact tables. Data was verified, cleansed and updated within ETL processes using OWB Data Profiler component. Data source was Oracle 12g ERP system.
• ETL processes designed with Warehouse Builder (OWB) 10gR2, Microsoft DTS, Informatica and PL/SQL. Administered Discoverer business areas in BI admin. ETL scheduled with Oracle concurrent manager jobs.
• Designed OBIEE dashboards, answer requests and supporting physical, business (fact and dimensions) and presentation layers. Tuning involved sizing the BI server cache, Aggregation on measurements for dimension levels and creating materialized views on database source to reduce report refresh times.
• Performance tasks:
• Implemented custom PL/SQL ETL packages utilizing following performance techniques: Partition exchange, bulk processing, Merge, Aggregate functions, bitmap and function based indexes, parallel query, Materialized views (Query rewrite) and table partitioning.
• Configured Oracle 10g database for high performance: 32k db block size, GB db cache size, >10 log destinations, GB pga aggregate target, query rewrite enabled, GB SGA, GB shared pool size, auto workarea size policy, parallel max servers > 100.
• Provided client with Software design documents of all OWB ETL processes, ERD data dictionary of all business areas and systems configuration (Operating systems, hardware and database specifications).

Confidential - Atlanta, GA

Responsibilities:

• Designed and implemented ROLAP (Kimball star schema) and MOLAP (cubes) datamarts in data warehouse for HR, Financial, Payroll, Maintenance (Tracking Product maintenance), Training, Attendance and Safety Systems. Data sources were Oracle databases (10g) ERP, Sybase (11) databases and mainframe applications. Master Data Management (MDM) methods employed to consolidate/aggregate and provide consistency across reference data of business units within company.
• All Metadata for OLAP, ODS and OLTP systems designed and maintained in OWB and Erwin repositories. Star Schemas used both type I and II (SCD) dimensions.
• ETL processes designed with Warehouse Builder (OWB) 10gR2, Microsoft DTS, PL/SQL and Perl scripts. Process flows (via Workflow server) were scheduled via Oracle Enterprise Manager (OEM) and error handling notification via mail with error records captured in database tables.
• Discoverer, Crystal and Portal reports utilized ROLAP (star schemas) and OLAP cubes to fulfill all new business reporting requirements.
• DBA Activities: Administered and installed Oracle 10g database, maintained backups using RMAN and designed configurations for high performance levels.
• Designed BI Applications:
• Dashboards using OBIEE/Siebel Analytics: Designed DW subject areas, imported objects (tables, views, queries) into physical layer, built business layer for facts and dimensions, designed answer requests/reports using existing report models and new requirements and integrated reports into Dashboards.
• Dashboards with 150 KPIs (BSC and PL/SQL with secured access) for company Strategic Business Plan. Custom ETL processes developed against following systems: Oracle GL, AR, AP, PO/INV, MAXIMUS, CUBIC NextFare collection, Seimens Automated Vehicle Locator, Train Control systems, Employee Training system and several maintenance tracking systems. Row level Database Security has been designed into all KPIs with filtering based on Company Cost Center.
• Captured and documented data requirements for existing stove pipe systems for use in a data warehouse to build relationships among the systems for complex reporting and drill down capability.
• Designed Logical and Physical model of Fare Collection system for Major public transportation systems (New Jersey Transit Public transportation and Los Angeles Metrolink rail system) using Erwin case tool. Both OLTP and Data Warehouse systems implemented for real-time processing and reporting. Wrote database design and maintenance manuals. Maintained transportation tariff and configuration for all Rail and Bus products.
• Installed, configured and maintained Oracle 9.2 databases, Oracle Client Networking software and 9ias (rel 2) Application Servers in development, test and production environments on Solaris 8 and 9. Upgraded databases from 8.0.6. Designed and implemented maintenance and backup/recovery processes using RMAN and custom shell scripts. 9ias Application Servers provided the J2EE environment and Report Server. Struts classes installed and evaluated for development projects.
• Redesigned reporting modules in Oracle Reports 9i and Crystal reports improving the performance, growth and maintenance using object techniques, clustering and partitioning. Quest TOAD used for database code development. Deployed reports on Crystal Enterprise for scheduling and client access via browser. All source code administered and stored in Starteam. All database access developed via stored procedures and packages.
• Procured software and hardware for Oracle databases and report servers. Established VAR with Oracle.
• Mentored junior Database administrators (administration and backup/recovery) and PL/SQL developers (new database object techniques enhancing performance).

Confidential

Oracle Database Consultant

Responsibilities:

• Administered Production, QA and development Oracle Databases 9i in Oracle Applications 11.0.3 environment on HP 11 UNIX and SUN Solaris. Oracle Application utilized Apache and Oracle Web Servers, Forms and Report Server. Tomcat 4.0 servlet container evaluated for custom development outside of Oracle Financials code base.
• Maintained database growth utilizing Oracle Application Purge process on modules PO, OE, INV, AR, AP, FA and GL and PL/SQL programs.
• Migrated (cloned) Oracle application environments (Forms Server/Web Server/Concurrent Mgr. and databases)
• Administered Quest Shareplex Replication servers for Oracle databases (log-based replication software).
• Mentor developers in PL/SQL code and Korn shell programs.
• Performed Source control promotion in Oracle databases for Oracle CRM and Vantive shipping application (Peoplesoft). All source code administered in PVCS.

Oracle Corporation

Confidential, Atlanta, GA

Responsibilities:

• Performed installations and upgrades of Oracle Applications to version 11i and database to version 9i.
• Developed task management system using Oracle 9iAs I-Portal.
• Performed AppsDBA tasks: Installation of Oracle technology stack and Application modules, patch application and recompilation of forms, reports, objects and schema.
• Cloned Oracle applications system to new servers.
• Managed the design and Implementation of a package sortation application (>30 modules) utilizing PL/SQL 8I features (Object types and Memory structures) on SUN Solaris 10K server. Team managed included three developers and two QA personnel. Co-wrote functional specification, function/process model and database design documents. Development and debugging of PL/SQL modules in Quest SQL Navigator. GUI utilized javascript, HTML and JSPs to separate complex algorithms from PL/SQL.
• Analysis and design of function/process and data models in Oracle Designer 2000 case tool.
• Architected physical database system based on business requirements (OLTP, DSS, ETL, performance, failover and business cycles).
• Database design (logical/physical) of package sortation system for OLTP and Data Warehouse. Data migrated to warehouse utilized Oracle advanced queuing, stored procedures and database links.
• Data Warehouse system fed daily from OLTP system for reporting financial, sortation rates and trends within the largest US sortation system.
• Maintained Oracle 8i productions servers (RAC/OPS environments) for Human Resource and Airline Maintenance systems (database creation, backup/recovery operations, DB2 gateway, application performance analysis and Documentum front end) (SUN Solaris, NCR and VAX/VMS)
• Set up two-way replication using Oracle gateway product.
• Designed and implemented a User Management system (Dynamic PL/SQL and Korn shell)
• Delivered a week long Database Administration and SQL class for Oracle internal DBA bootcamp.
• Performed evaluation and complete analysis of INFORMIX to Oracle conversion of an Inventory Application. Delivered proposal to perform the migration effort detailing the scope of work and level of complexity for conversion of the database and application components.

COMSYS Consulting Inc. - Senior Database Consultant Atlanta, GA

Client: Confidential Communications

Responsibilities:

• Designed/implemented database maintenance processes (Korn and Perl shell) for Phone Billing Systems which utilized a distributed and replicated server environment on SYBASE database (HPUX). Automated database archival and Backup/Recovery processes (Korn and Perl Shell).
• Performed benchmarks for Sybase backup/recovery procedures for Enterprise databases on HP UNIX servers.
• Converted Sybase (T-SQL) transact stored procedures to Oracle PL/SQL procedures in a conversion project for a major Telecommunications Company client of Confidential Communications. Data Migrated and transformed using Oracle migration tool kit.
• Evaluated ERD Case tools for internal billing system (Erwin and S-Designer were best in league).
• Managed DBA and development team implementing new insurance billing system (MARS project).
• Transformed UML Use Cases into Logical Data model utilizing Rational Rose to Capture and maintain Metadata. Architected physical database layout. EasyCase for ERD metadata and Business Objects utilized for enterprise reporting.
• Designed/implemented distributed database on three Sybase/SQL Servers (200GB).
• Automated the generation of stored procedures (T-SQL) using Perl and SybPerl.
• Implemented Backup/Recovery Plan for system deployed at seven U.S. sites.
• Optimized database server procedures and SQL Server configuration

Confidential, Atlanta, GA

Senior Consultant

Responsibilities:

• Designed logical/physical databases utilized CASE tools (Erwin, EasyCase).
• Taught SQL Server administration, Performance tuning, SQL and Open-Client programming.
• Implemented backup/recovery procedures for 24/7 system.
• Optimized SQL Server, stored procedures and triggers.
• Upgraded Sybase and SQL Server systems to current versions.
• Performed system recovery on database servers with corruption.
• Performed DBA tasks on development and production Sybase/SQL Server systems (Backup/recovery scripting, tuning of server, stored procedures, indexes and triggers)
• Install and configure SQL Server and Gupta Sqlbase on multiple platforms (Novell, NT and UNIX).
• Implemented data interface systems for Airforce Command and control system in C, Ada and Sybase open client software.
• Supported relational database design, wrote stored procedures and managed unit testing of all database access code.
• Migrated SQL server databases from 4.0 up to 10.0.
• Tested low observable missile system components in the open lab and using finite pattern analysis software.
• Supported projects Tomahawk and Harpoon with live radar testing.
• Benchmarked finite pattern analysis software for Missiles systems division and Aircraft division.