Summry

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 .
• Confidential: Contracted to performed Oracle SQL performance tuning and PLSQL development on a new product - being launched in China and US.
• Skill sets utilized: Appl. Dev., Data Analysis, Oracle 11g Database administration, design, tuning and architecture, SQL, PLSQL, TOAD for Oracle Data Modeler, Data Analysts, and SQL Optimizer .

Confidential

• : Oracle 10g consultant and developer for law firm and lawyer .NET websites and API's that contain Endeca search engines and biographical information in a data warehouse environment. The Client Service Center Appl. provides ratings, articles, peer reviews, profiles, blogs and customized website dev. It provides data services to other Lexis-Nexis websites like. Provided business community enhancement requests to various components within the Appl..Designed and build Oracle backend component for external and internal API calls that produced complex XML outputs using Erwin r7 data modeling tool. Documented all Oracle databases via Erwin r7 for off-shore outsourcing partners. Conducted analysis for multi-lingual database architecture. Performed analysis to validate the business requirements to make this company a truly multi-lingual company. It required me creating a stand-alone database that is multi-lingual compliant AL32UTF8 . It had two different types of data type columns, single byte varchar, clob and double byte nvarchar, nclob so I could test how each of these data types behaved in a universal language set database when data was ETL'd from a non-universal language set database. Created a custom language translation process Oracle function that sent HTTP requests to Google's language translation API. This process took English lawyer and law firm profile data from a production database, sent Oracle-based translation requests to Google to convert the data into foreign languages for both the single byte French, Spanish and double byte Chinese, Korean columns and then loaded it into the AL31UTF8 database table structures. Performed data type comparisons between the English database and the new database columns to determine if any character translation errors had occurred. Built Ubuntu 64 bit server, MongoDB 64 bit database and Oracle XML-to-JSON ETL process to load collections. Utilized Altova tools like XMLSpy for creating and maintaining XML, XSD and XLS.
• Skill sets utilized: Appl.Dev., Data Analysis, Oracle Database 10g administration, design and architecture, Erwin r7, SQL, PLSQL, XML, XSD, TOAD, TOAD Data Modeler, TOAD Data Analysts, Agile/Scrum .NET Appl.dev. life cycle process, Ubuntu, MondgoDB.

Confidential

• Engagement Manager to lead team to maintain and develop upgrades to the Oracle 10g back-end of a Java Appl. that provides the pharmaceutical industry with a user-friendly mechanism for calculating prices and managing claims for their products with government Medicaid and Medicare agencies CMS . Maintained and developed Oracle PLSQL. Used Oracle DBA and Erwin r6 modeling skills to create test and QA platform databases on remote server. Tuned Oracle backend processes. Applied tools, techniques, and methodologies appropriately to increase project efficiency and effectiveness. Led a segment of a large project to a successful outcome. Facilitated workshops and interviews with clients. Identified and escalated issues to appropriate authorities. Gained understanding of services and relevant industry processes. Developed a strong working relationship with Director-level client staff. Participated in client meetings and presentations. Created an ETL process to extract data from multiple clients Oracle RDBMS and reformat the data for loading into iMany proprietary databases. Used all customized Oracle UTL FILE processes to extract, translate and clean the data into flat files for importing into iMany.
• Skill sets utilized: Project management, Data Analysis, Erwin r6, ETL, Data migration, Statements of work, Requirements specifications, project planning, Oracle Database administration, SQL, PLSQL, MS Excel spreadsheets, TOAD.

Confidential

• Senior Oracle applications DBA and database developer responsible for collecting, housing and analyzing worldwide physician survey and key opinion leader information for Merck Co. located in their world headquarters in Whitehouse Station, New Jersey. Physicians nominate key opinion leaders within their therapeutic and specialty areas of expertise. This data warehouse and the related object-oriented applications interact with Merck subsidiaries and the web-based survey management system on a daily basis. They ensure that accurate reporting and analysis capabilities are provided to the worldwide marketing organizations. The data warehouse contains information for over 40 countries having many different languages. Utilizing Master Data Management standards related to physicians, drugs, hospitals, markets and locations, I had to take data from 40 different countries, clean it, remove duplicates, report on data cleansing issues and then load it into two different Oracle databases one here in the US and another in Brussels. There were many unique physician data legal issues to be sensitive to like Safe Harbor protocols. Built an Oracle 9i data warehouse ETL and data cleansing Appl. using Oracle packages, procedures and functions and UNIX scripts for Merck's marketing organization that provides a mechanism for executing various marketing tools like their Buying Process. All Oracle databases were designed using Erwin modeling tool.
• Skill sets utilized: Appl.dev., Data cleansing, Erwin r5, Analytical reporting, ETL, Requirements specifications, project planning, Oracle Database administration, SQL, PLSQL, MS Excel spreadsheets and pivot tables, MS Access databases, SQL Navigator, web site interfaces.

Confidential

• Senior Oracle Appl. DBA, Developer and Project Leader of both domestic and international Data Warehousing Databases using Oracle v9i. Responsible for designing, building and maintaining Oracle data warehouses for: Travel, Expense and Procurement Credit Card Appl., Citibank Interfaces, Payroll and General Ledger Interfaces and Human Resources Expense Approver Hierarchy Applications. Implemented Position Management hierarchy for expense reporting approvals. Created interfaces to Captura Web expense reporting Appl. Did all DBA design, maintenance and support for all related Oracle applications using Oracle packages, procedures, functions and UNIX scripts. Reversed engineered all related Oracle databases via Erwin r5 for SOX compliance documentation.
• Skill sets utilized: Appl.dev., Data analysis, Erwin r5, Accounting interfaces, SQL Loader, ETL, Requirements specifications, project planning, Oracle Database administration, SQL, PLSQL, SQL Navigator, UNIX scripting, Job scheduling.

Confidential

• Oracle 8i developer for back-end support of a Lawyers and Law Firms search engine web Appl. and data warehouse. Maintained data and Inter-Media indexing for search engines that supported various web apps. Created web user statistics repository in Oracle 8i. Created a RAD GUI to create and maintain Lawyer and Law Firm profiles in XML format stored in an Oracle 8i database.
• Skill sets utilized: Appl.dev., Data analysis, web site search engines, XML generation, SQL Loader, ETL, Requirements specifications, project planning, Oracle Database administration, SQL, PLSQL, SQL Navigator, Oracle Job scheduling.

Confidential

• : Project leader for Oracle 7.0 Sales Force automation. Designed objects to search, find and analyze drug sample drop forms that are in error in order to conform to FDA audit requirements. Created FDA audit reports to track drug sample inventory and distribution discrepancies. Created Business Objects Universe v5.0 and reports to analyze and report on drug sample data.
• Skill sets utilized: Appl.dev., Data analysis, Requirements specifications, project planning, RAD GUI, SQL, PLSQL.

Confidential

• Oracle Project leader and DBA for RAD GUI projects. Created and maintained the test, staging and production Oracle v7.23 instances and environments for the following projects: 1 User change management/version control. 2 Create, maintain and analyze company owned and co packer distribution center and manufacturing facility Inventory Replenishment shipments, Production Schedules and Transportation data. Data is synchronized with a SAP R3 Appl. where warehouse shipment maintenance and analysis are done at the local and headquarters levels. 3 Maintain transportation attributes. 4 Created Business Objects 4.0 Universe, Class and Objects in Oracle database to analyze transportation data. 5 Track all project enhancements and bugs. 6 Create DB2 app to maintain field sales representative's Sales/Marketing baseline and final objectives. 7 Designed and maintained all Oracle databases using Erwin/ERX modeling tool. 8 Leader of small team of experts, using Rapid Appl. Dev. RAD, Object Oriented Appl. dev. methodologies, ERWIN modeling tools and Oracle stored procedures, functions, triggers, SQL Plus scripts and DBA skills. Completed all projects on time and under budget. Trained employees.
• Skill sets utilized: Appl. dev., Data analysis, RAD GUI, SQL Loader, ETL, Requirements specifications, project planning, Oracle Database administration, SQL, PLSQL, Oracle Job scheduling.

Confidential

• Consultant. Performed all Oracle DBA and Project Leadership functions for GUI dev. for an Oracle / RAD GUI, Windows NT Appl. dev. environment for multi-developer change management control. Designed and developed an Oracle / RAD GUI Laptop Appl. that maintains Agriculture and Veterinary Industry data maintain Calls, Contacts, Orders and Marketing data gathered by 150 field sales reps. Data is synchronized with a Oracle v6 Repository where Global Sales Organization Marketing Analysis is done and sharing of data is provided. Using Rapid Appl. Dev. RAD methodology, completed project in less than 8 months. Trained all project employees in Oracle / PB 4.0/Client-Server Technology.
• Skill sets utilized: Appl. dev., Data analysis, RAD GUI, Object Oriented Coding, SQL Loader, ETL, Requirements specifications, project planning, Oracle Database administration, SQL, PLSQL, Oracle Job scheduling, FTP, XCOM, PFC.