Summary

Over 20 years experience in the IT industry as systems analyst, data architect and application developer in numerous industries and platforms. More than 20 years of solid ORACLE experience in the complete System Development Life Cycle SDLC and on Conversion, Integration and Migration projects. Excellent skills in problem solving, data modeling and database design. Experience includes mentoring and coaching less experienced associates.

Technical Skills

• Operating Systems: UNIX Sun Solaris, HP-UX, Linux, Ultrix , MS Windows, MVS/ESA
• Database Management Systems: Oracle RDBMS Versions 5.x/6.x/7.x/8.x/9i/10g/11g, SQL Server 2008/2012
• Programming Languages: SQL, T-SQL, PL/SQL Procedures, Functions, Packages, Database Triggers , Oracle Forms, Oracle Reports, Oracle Graphics, Cobol, PRO Cobol, PRO C, C, HTML, JavaScript, Bourne/Korn Shell
• Software Packages and Tools: Oracle Designer 2K/6i, Oracle Developer 2K/6i, ETL Informatica v8.6/9.1, Data Mirror Constellar Hub v3.6.1 , DataFlux v8.2, TRUcompare v2.2, Bourne/Korn Shell, AppWorx v4.5.4, Autosys, SQL LIMS, LIMSLINK, Citrix MetaFrame, VERITAS Cluster Manager, CONNECT: Direct, TSO, ISPF/PDF, CMS, JCL, XEDIT, REXX, TOAD, PL/SQL Developer, BRIO, UML, PVCS, Subversion Tortoise SVN , HP Quality Center 10.00, SSRS

Professional Experience

Confidential

Oracle Developer/ETL Developer

• Architected solutions for the migration of data from legacy systems Contracts, Chargebacks, Government Commercial Pricing and Medicaid Claims to Model N's Global Contracts and Pricing System GCPS software
• Currently responsible for the analysis and cleanup of legacy data and the creation of ETL mappings for the migration to GCPS
• Writes SQL and PL/SQL code, creates ETL Informatica 9.1 mappings, writes Test scripts and builds DataFlux QA jobs - architect, profile and match jobs
• Creates documentation for business requirements, technical design, implementation and test plan

Environment:

• ORACLE RDBMS v11g
• Informatica v8.6/v9.1
• SQL, PL/SQL Stored Procedures, Functions Packages, Database Triggers , TOAD, DataFlux v8.2, TRUcompare v2.2, Subversion Tortoise SVN , HP Quality Center 10.00
• Linux, Windows 2003, Sun Solaris 10, HP ProLiant DL580 G5

Data Integration Architect/Oracle

• Worked closely with the Technical Manager, Business Analyst and Subject Matter Experts to determine their data integration needs and help integrate their systems with the Callidus suite of products
• Architected solutions for Payments of Compensations commissions, bonuses, etc to Directv dealers
• Coded SQL, PL/SQL and Shell scripts
• Created process flow and technical design documents

Environment:

• ORACLE RDBMS v9i
• Oracle PL/SQL Stored Procedures, Functions Packages , SQL, TOAD, Visio, Autosys
• Windows XP, HP-UX

Oracle Developer/Analyst

• Was responsible for the migration of the Show Lighting and Integrated Manufacturing Management Model Inventory, Tooling Inventory and Item Tracking applications from Unix to Windows
• Converted Oracle Forms from a Character based to GUI and Pro C to PL/SQL
• Conducted presentations and trainings to users

Environment:

• ORACLE RDBMS v10g
• Oracle Developer 6i, PL/SQL Stored Procedures, Functions Packages , SQL, TOAD
• Windows NT/2000, PC Pentium

Analyst/Oracle Developer

• Worked with the Business Owner and System Owner to architect solutions for the implementation of the Deficit Reduction Act of 2005 DRA Final Rule calculation for the Government Best Price Initial
• Created documentation for business requirements, technical design, implementation and test plan
• Coded Oracle Forms, Oracle Reports, PL/SQL and Shell scripts
• Designed, developed and deployed the system
• Gathered and documented business requirements
• Conducted presentations and trainings to users

Environment:

• ORACLE RDBMS v9i
• Oracle Developer 6i Oracle Forms, Oracle Reports , PL/SQL Stored Procedures, Functions Packages, Database Triggers , SQL, UTL FILE, TOAD, BRIO
• Sun SPARC/Ultra Enterprise, PC Pentium, Windows NT/2000, Sun Solaris 2.6

Oracle Developer/Analyst

• Worked closely with the Project Manager, Business Analyst and Subject Matter Experts to gather and analyze information and to architect solutions to business problems
• Was responsible for the customization and enhancements of the validated Global LIMS Laboratory Information Management System application SQL LIMS software by Applied Biosystems
• Enhanced and/or customized the Global LIMS Lot QC, Stability and EM Water applications
• Coded PL/SQL, SQL, Oracle Forms, Oracle Reports

Environment:

• SQL, PL/SQL, Oracle Developer 6i, TOAD, SQL LIMS, LIMSLINK, Citrix MetaFrame, VERITAS Cluster Manager
• ORACLE RDBMS v8i
• Sun SPARC/Ultra Enterprise, PC Pentium, Windows NT/2000 Server, Sun Solaris 8

Integration Architect/ETL Developer

• Was responsible for the design, development, deployment and enhancement of interface systems for Purchase Order, Accounts Payable, General Ledger and Inventory Tracking and Valuation systems
• Worked closely with the Technical Project Lead Business Analyst to gather and analyze information
• Architected solutions for the data integration between the WMG's System ESS Applications, Oracle Financial Applications and External Applications Data Feeds from Manufacturing Plant and Vendors
• Coded ETL Constellar TDL , PL/SQL, Shell scripts, AppWorx module/chains and SQL Loader scripts
• Created functional and technical design documents

Environment:

• SQL, PL/SQL, SQL Loader, TOAD, Data Mirror Consterllar Hub ETL , AppWorx, Visio, SmarTerm Office, System ESS Software Development and Configuration Manager SDCM , Citrix MetaFrame
• ORACLE RDBMS v8.x
• Sun SPARC/Ultra Enterprise, PC Pentium, Windows NT/2000, Sun Solaris 2.6

Oracle Developer/Analyst

• Functioned as technical lead to Incentive Rebate Payments, Check Management, Government Pricing and Industrial Funding Fee application systems
• Administered the Oracle Designer 2000 Repository - keep data model and data dictionary up-to-date
• Responded with quick turn-around solutions to ad-hoc analysis and reporting needs of end users
• Worked with business users and analysts to architect solutions to their business requirements
• Designed Data Modeling with Oracle Designer 2000 logical and physical design
• Designed, developed, deployed and supported the Incentive Rebate Payments, Check Management, Government Pricing, Business Review and Chargeback systems
• Coded PL/SQL, Oracle Forms, Oracle Reports, Oracle Graphics, SQL Loader, Shell scripts and ETL mappings
• Created business requirements, functional and technical documentations and conducted presentations and trainings to users

Environment:

• ORACLE RDBMS v8.x/v9i
• Oracle Designer 6i, Oracle Developer 6i SQL Forms, SQL Reports, SQL Graphics , PL/SQL Stored Procedures, Functions, Packages DB Triggers , SQL Loader, UTL FILE, TOAD, BRIO, INFORMATICA v7.x
• Sun SPARC/Ultra Enterprise, PC Pentium, Windows NT/2000, Sun Solaris 2.6

Oracle Developer/Designer2000

• Designed Data Modeling with Oracle Designer 2000 logical and physical design, in implementing the Interfaces and Reports System
• Was responsible for the design, development, deployment and production support of UI Employees Overtime, Work Order Project, Information Resource Invoicing and General Circuit Interrupt Systems
• Coded PL/SQL database triggers, stored packages, procedures and functions , Oracle Forms, Oracle Report, SQL Loader and shell scripts, Connect Direct Scripts -- transfers files from IBM Mainframe MVS to RS6000 UNIX

Environment:

• Oracle Designer 2000 v2, Oracle Developer 2000 Rel2.1 SQL Forms v5, SQL Reports v3 , SQL, PL/SQL Stored Procedures, Functions, Packages, DB Triggers , SQL Loader
• ORACLE RDBMS v7.2/7.3.4
• IBM RS6000, PC Pentium, IBM Mainframe 3090, Windows NT, AIX V4.2, MVS/ESA
• Novell for windows NT v4.30.410,Telnet v1.0, Microsoft Telnet v4.0, CONNECT:Direct

Confidential

Position/s: Project Supervisor Business/Systems Analyst Programmer

• Lead a Core Group that designed a New Enterprise ERD Model for the SSS
• Member of various Committee's - Change Management, Problem Management, Bid and Awards Procurement of Hardware and Software
• Technical representative to the Intra-Gov Agencies Nat'l Database Project - attend to meetings/conferences and provide inputs for the design of the National Database
• Member for Oracle Case Tool V5.1 Pilot Project for the Cash Collection Bank Remittance System
• Project Supervisor Business/Systems Analyst Programmer for Registration and Coverage System
• Responsible for the re-engineering of the Registration and Coverage System

Duties and Responsibilities:

• Coded programs using Oracle tools Developer 2000, Cobol, Pro Cobol and Pro C in Mainframe and Unix environments for various application systems -- Registration and Coverage, Loans Granting Repayments, Employee Employer Contributions and Cash Collection Systems
• Created Technical Benchmark Criteria and conduct Benchmark of servers, workstations and printers
• Worked on the conversion of Oracle Forms from V2.3 to V3.0 to V4.5

Environment:

• Oracle Designer 2000 v1.3, Oracle Developer 2000 SQL Forms v4.5, SQL Reports v2.5 , PL/SQL Package, Procedure, Function Triggers , SQL, SQL Forms v2.3/3.0, C, Pro C, Cobol, Pro Cobol, Oracle Case Tools v5.1.
• IBM 4381/3090/9121, IBM RS6000, IBM RT/PC, DEC 5100/5500, PC
• MVS/ESA, ULTRIX, XENIX/UNIX, AIX, TCP/IP, LINKUP, IRMA, CLEO, TELNET
• Oracle RDBMS v5.x/6.x/7.x