Summary

A data systems computer professional with demonstrated competencies in providing consulting services for architecting, designing, managing and developing complex projects requiring the Appl. of specific technical knowledge utilizing broadly defined work direction and a high level view of systems, data warehouses, business contexts, and organization strategies with an emphasis on the timely completion of projects, controlled budget constraints, quality assurance and internal and external customer satisfaction.

Skill Sets

• A very experienced hands-on Oracle architect, modeler and database and application developer having many years of experience as a consultant to Fortune 500 companies, designing, modeling, building and maintaining Oracle data warehouses, applications and interfaces API, ETL, etc. .
• Very proficient in PLSQL and all its best practices components along with Oracle utilities such as, but not limited to, XML and HTTP functions.
• Project Leader of Oracle to both on and off shore dev. teams requiring knowledge transfer to enhance their programming capabilities and efficiencies.
• Utilize Agile and Scrum methodologies for rapid application development life cycles.
• Author functional and detailed technical programming requirements and specifications for the creation and maintenance of very large Oracle databases, data warehouses, data marts and data store.
• Use Erwin and Toad Data Modeler modeling software to finalize logical and physical data base design and forward engineering of data model into Oracle databases.
• Utilize Master Data Management standards to cleanse and uniquely identify master data elements within database models.
• Author detailed PLSQL technical specifications for dev. teams to create and maintain all objects in Oracle: Complex packages, procedures, functions, triggers, views, indexes, etc.
• Design and build Oracle PLSQL and API interfaces with .Net website applications.
• Tune SQL statements and PLSQL programming logic using best practices. This includes maintaining complex indexing implementations like Inter-Media context searches and data storage partitioning techniques.
• Utilize all Oracle built-in packages for manipulating large objects like Clobs and Blobs graphics and for communicating to/from and updating directory and file structures in UNIX.
• Proficient in Altova tools like XMLSpy for creating and maintaining JSON, XML, XSD and XLS.
• Use Enterprise Manager to execute all back up and recover strategies and performance tuning monitoring of user activity and Oracle internals.
• Write UNIX scripts and job schedules Maestro/Conman/Tidal to perform Oracle maintenance and database ETL/Maintenance calls to PLSQL code/objects for very large OLTP applications.
• Work with Appl.dev. teams to implement the most affective performance attributes and Oracle processing design/access methodology within their applications.
• Experience with interfacing with very large SAP proprietary databases sales, supply chain, forecasting .
• Strong experience with Meta Data driven ETL development by developing PLSQL programs to support automated integration of data using pre-configured metadata to support iterative development of a clinical data hubs.
• Knowledge of Enterprise Data Warehouse principles and practices, data Integration and database technologies experience with metadata driven SQL development.
• Experience working with dynamic SQL using stored procedures to support DDL/DML actions.
• Performance tuning knowledge and good understanding of Query Plan optimization.
• Experience of working in a regulated development environment.
• Excellent analytical, problem-solving and organizational skills.
• Exposure to other technologies.
• Knowledge of data modeling concepts.
• Responsible, team oriented, security focused, well organized individual with excellent communications skills and the ability to handle multiple concurrent projects while adapting quickly to rapidly changing priorities.
• Demonstrated ability to learn new skills quickly.
• Persistent and dependable, especially with meeting deadlines.
• Ability to work in an Agile development environment with short cycles of delivery.
• Experience building very complex client-server RAD GUI applications.
• Experience building very complex client-server Business Objects applications.
• Design and code complex Adobe Dreamweaver CS3, CS4, CS5 and CS6 website applications using HTML, PHP, JAVA and MySQL databases.
• Worked with both off shore and on shore application development consulting teams.
• Currently hold Government Confidential/Public Trust security clearance.
• Provides work direction and technical guidance to team members. Effectively assesses alternate system solutions to business problems to control cost and quality. Personal attributes: Self-motivated takes initiative flexible risk taker fast tracker contributes positive influence and impact through effective communication and high yielding productivity manages project costs and diverse technical staffs consisting of highly skilled employees and/or consultants.

Software

ORACLE v5-11g, PLSQL, Enterprise Manager, SQL Loader, TOAD for Oracle, SQL Optimizer, Data Analyst, Data Modeler , Putty UNIX , SQL Navigator, Performance Tuning Utilities, SQL, ETL, Oracle Inter-media context searches , XML, XSL, XSD, HTML, Business Object v3-5, ERWIN r9, RAD GUI, PFC, Dreamweaver CS3-CS5, PHP, Unix, CICS, COBOLII, TSO, JCL, VSAM, Assembler, IBM Utilities, DB2, MS Word, MS Excel, MS Access, MS Project, FTP, Tidal and Maestro Job scheduling with Conman and Composer, PVCS and TFS source control facilities.

Hardware/Operating Systems

Sun Microsystems, UNIX, Solaris, AIX, HP-UX, IBM30xx Mainframe, RS6000, Amdahl, Windows NT/95/98/2000/XP/Vista/7/8, Novell 3.12, Pyramid 7000

Areas of Business

Financial, Banking and Pharmaceutical industry government compliance, Contracts, Pricing, Claims and Rebate processing, Physician Key Opinion Leaders, Physician Therapeutic Analysis, Marketing Tools, Sales Objectives and Forecasting, Production Planning, Inventory Control and Accounting, Credit Card Administration, Appl. Tuning and Dev., Production Turnover Reviews, Production Library Control, Integrated System Testing and Quality Assurance, Field Sales Force Automation, Corporate System Interfaces, Data Warehousing, Supply Chain Management, Web Dev., Voice Activated Applications, Transportation Decision Support, Contracts, Law firm and attorney information publishing.

Positions held

Oracle DBA , Database and Application Developer and Architect, Batch and Client-Server Appl. Developer, Web Developer, Oracle Web Search Engineer, Data Modeler, Project Manager, Project Leader, Technical Leader, Business and Systems Analyst, GUI Appl. Developer

Corporate Environments

Government Contracting, Financial Industry, Legal Industry, Pharmaceuticals, Retail Food Manufacturing, Veterinary and Agricultural Products, Hospital Services, Tele-Communications, Consumer Products, Lighting Industry, Pipeline Construction, Oil and Gas Industry, Education, Publishing, Sports organizations.

Work Experience

Confidential

Contracted to develop database models and support documentation in order to meet business requirements for reporting and analytic databases and Dodd-Frank government reporting compliance. Analyzed data sources and requirements and business rules, performed logical and physical data modeling, created Oracle DDL scripts, wrote prototype PLSQL to prove data transformations, and wrote source-to-target mapping specs for ETL development, implement and test database design. Coordinate data models across marts and warehouses manage dictionaries and other documentation across multiple data marts and data warehouses. Created data mappings for Oracle exports to Hive/Hadoop/Axiom environments.

Skill sets utilized: Data Analysis, Data Warehousing, Oracle 10g Data Modeling, SQL, PLSQL, Erwin R9, TOAD Data Modeler, and TOADSQL Optimizer.

Confidential

Contracted for international pharmaceutical company. Performed Oracle 10g database development work to reposition Impromptu Excel spreadsheet reports into an Oracle database audit repository. Built new facility using RAD GUI to execute, display, filter and sort data and save reports. Built new discount pricing tier movement evaluation and reporting process for a two new drugs within an SAP customer contracted sales reporting system that analyzed historic sales data and moved contracted customers to new pricing discount tiers based on quarterly sales performance.

Skill sets utilized: Appl. Dev., Data Analysis, Oracle 10g Database administration, design, tuning and architecture, SQL, PLSQL, TOAD for Oracle Data Modeler, SQL Optimizer , RAD GUI, Impromptu.

Confidential

Contracted for SAIC defense contractor .Performed Oracle 11g database development and architecture work for various Federal Air Marshal Service .Net websites and portals. Unable to give more details because of security restrictions. Utilized Master Data Management standards to cleanse and uniquely identify master data elements within database model such as airports, hotels, air marshals, weapons and training classes. Currently hold Government Confidential/Public Trust security clearance.

Skill sets utilized: Appl. Dev., Data Analysis, Oracle 11g Database administration, design, tuning and architecture, Erwin r8, SQL, PLSQL, TOAD for Oracle Data Modeler, Data Analysts, and SQL Optimizer .