SUMMARY OF SKILLS
¯ Over 10 years experience on Oracle in various roles: Data Architect, Data Modeler, Developer and Administrator in designing Data Models using data modeling tools (Erwin/ER Studio and Symantic Data Architect) with extensive knowledge in managing complex IT projects with a cross-functional team of engineers, program managers, and software developers
¯ Extensive domain knowledge and work experience in the Financial Industry.
¯ Experience in Conducting Rapid Application Development sessions with users and stakeholders.
¯ Expertise in Software Development Life Cycle (SDLC), Post Test Analysis, Object Oriented Design and Execution of Software Systems employing Industry proven software engineering best practices & support processes.
¯ Experience designing data models which optimize online real time applications as well as performance considerations for data warehouse applications.
¯ Strong and extensive experience in SQL for Oracle databases.
¯ Experience in building data warehouse staging tables optimized for ETL and building dimensional data models / data marts optimized for OLAP tools.
¯ Extensive experience in building relational data models that have logical models adhering to the right business view and the right physical data models that are required for application development, leveraging a rich experience in application design and development.
¯ Forward engineering new database models into physical database DDL Scripts/direct database schema creation, Reverse engineering existing databases into Physical Models and continuous model/database synchronization (through modeling tool compare/synchronization feature) for change management (maintenance), documentation, Re-engineering and other such purposes.
¯ Sound understanding of normalization principles and extensive experience in the judicious use of normalization principles.
¯ Experience in documenting, designing and implementing custom quality improvements using requirments definitions and change control processes.
¯ Proficient in authoring Business Requirement, Functional Design and System Requirement Documents and identifying interface and business process specifications.
¯ Experience working on large Oracle database for both commercial and federal systems.
¯ Well experienced in writing strong SQL and PL/SQL code for Data Analysis and defect identification.
¯ Involved in UAT, Functionality Testing, Regression testing, System Testing, Unit Testing, Integration Testing, Black Box Testing, Performance Testing, Stress Testing, Front-end Testing, Back-end Testing & Regression Testing of Client/Server & Web based applications.
¯ Strong experience in managing a diverse project portfolio using MS Project, MS Visio, MS Word, MS Access, MS Excel and MS PowerPoint.
¯ Self-motivated, team oriented with the ability to handle multiple tasks.
¯ Outstanding interpersonal communication and documentation skills. Proven ability to translate business requirements into IT solutions. Effective interaction with all levels of management, developers, analysts, and peers.
TECHNICAL SKILLS
|
Languages |
Java, HTML, PL/SQL, SQL, some PHP and XML, and unix shell scripting. |
|
Modeling Tools |
Erwin 3.5.2, Erwin 4.1.4, 7.0, ERStudio 7.5/6.5, Data Architect 7,8, & 9 |
|
Database |
Oracle 7.x / 8.x / 9.x / 10.x Enterprise Manager, InDepth, Toad, SqlPlus Imp/Exp, Datapump, and database backup and restore, Oracle HTMLDB or Application Express |
|
Data Warehousing |
ETL using SQL Loader, PL/SQL, and written specs for Informatica and Ab Initio |
|
Reporting Tools |
Actuate Reports |
|
Workflow Tools |
MS Office Suite, MS-Visio, MS-Project |
|
OS Platforms |
Windows NT/ 2000 / XP, UNIX (Solaris, and HP-UX), Linux, IBM Mainframe, Unisys Large Systems, Mac OS |
EDUCATION
Bachelor of Science in Information Systems, Virginia Commonwealth University
PROFESSIONAL EXPERIENCE
Wachovia Securities December 07 Ð August 09
Data Base Developer
Contracted to improve performance for the service request application. While leading the database activity development and deployments, worked with the application teams and identified queries to fix, structural problems to re-architect, and wrote the requirements documents as needed for both .net and database changes. Reduced the In Oracle time for the application user by a factor of 25 to 1. This measurement is remarkable in that the application is an OLTP, but has a usage footprint more like a data mart. Part of the change to the architecture included the reduction of enablement keys from over 1,000,000 rows to about 250, and the restructure of the work item table to look and respond like a fact table. These major changes took place over the 18 months, and in addition with each release, more and more queries were tuned for the environment which yielded the indicated performance.
Responsibilities
¯ Attend weekly application team meetings to identify and review requirements from the business users the application team.
¯ Author requirements documents to be submitted to change control for approval and assignment to release schedule.
¯ Document existing database components using ERwin, Toad, and MS Visio, this included documentation of all stored functions, procedures, and packages.
¯ Designed and implemented an automated process to reconcile the data warehouse in DB2 to the OLTP system in oracle, which allowed missing data to be loaded into the data warehouse before it was purged from the OLTP
¯ Designed a logical and physical data model for all enhancements to the application, and did data model reviews for other teams for compliance with standards and guidelines.
¯ Client data modeling standards in place were reviewed and applied on both the logical and physical data model
¯ Redesigned and deployed all unix shell scripts to meet corporate standards for securing passwords and meeting the data retention requirements for log files.
¯ Implemented standard processes to put all environment variables for dev, test, qa, pre-prod, and production into .profiles for each environment, so that no changes of scripts were required between environments for releases.
¯ Redeveloped the Archival Process stored procedure to improve performance from daily runs over 2 hours to daily processes of 20 minutes.
¯ Developed a purge process to remove rows from the segmented tables after 13 months.
¯ Worked with partners in the data warehouse team to resolve and identify missing data, and made corrections to processes as needed thru the change control process.
¯ Monitored the production, pre-prod, and qa databases for performance and produced reports for each application for each release.
¯ Provided testing scripts for the test team, provided test data when needed.
¯ Facilitated the reload of the pre-prod database schema by coordination with several teams, unix, dba, change management, and space management.
¯ Hosted the database change reviews for each release with the architects responsible for the application.
¯ Maintained all database scripts for each release, and worked with the production dba during each implementation.
¯ Designed for the production support team, and automated tool for real time alerts from the application log tables.
Environment: ERWin, SQL and PL/SQL, Oracle 10g, Win XP, TOAD, MS Visio, MS SharePoint, Clear Case, HPUX and Microsoft .net.
Capital One Financial January 06 - December 07
Sr. Oracle Developer
The goal of the project was to support the Helix project which converted the legacy credit card billing sysgem from Unisys to the third party processor, Total Systems, or TSYS. The project was designed to provide interface mapping for each requirement in requisite pro to test case or cases in clearcase. The Requisite Pro requirements were hierarchical in nature, with Scope requirements, being broken down into various functional, system, and other requirement types. At the lowest level were the identifiable deliverables which could be tested. The Brio toolset was used to present and drill down from the requirements to the test cases to identify any requirment which did not have a test case, and provide reporting to the responsible team for the requirement.
Responsibilities:
¯ Design and implement a data mart for the requirement and test case data.
¯ Used ERwin to design and develop the data mart.
¯ Designed, developed and deployed PL/SQL packages and database links to extract and transform the data and load into the data mart.
¯ Provided sample queries for the dashboard developer to use in reporting the traceability matrix.
¯ Maintained development databases and data models in sync. with continuously evolving data model, using complete compare and reverse engineering features of Erwin.
¯ Create and maintained the traceability matrix of the requirements.
¯ Involved in the full lifecycle of the project from Project initiation and approval to business analysis phase through deployment and then to provide and post deployment issue resolution.
Environment: ERStudio 6.5, PL/SQL, Oracle 10g, Win XP, TOAD, MS Visio, IBM Rational Requisite Pro, IBM Rational Clear Case, MS Office.
Senior Oracle Developer
Project involved the development of a data mart for the presentation and discovery of performance issues using performance data captured from Site Scope and other performance monitoring tools. The project involved data extraction, transformation, and loading into an oracle based datamart. The domain of the data related to all e-commerce websites, servers, networks, and databases.
Responsibilities:
¯ Worked with the stakeholder and other users to identify the requirements.
¯ Involved in requirements/data analysis and data modeling (using Erwin 4.1), adhering to organizational naming standards and generation of DDL using forward engineering feature of Erwin.
¯ Designed data models for data warehouse staging tables, source transactional data stores, summary tables and data mart.
¯ Designed generic model for storing various measurement types, counts, response times, percentages, averages, etc across various components, both hardware and application.
¯ Normalized relational data models up to the 3rd Normal form.
¯ Involved in source system data analysis and documenting source to target mapping and ETL transformation rules.
¯ Involved in testing and correcting DDL scripts.
¯ Effectively interfaced with users to extract implicit requirements through modeling sessions.
¯ Wrote the requirement documents, and then developed the technical specs for coding.
¯ Designed and coded the entire ETL process to load or extract from flat files and remote databases.
¯ Created and installed the development database and maintained scripts to be pushed to the qa environment.
¯ Used sqlplus and auto trace to perform data analysis using complicated JOINS and NESTED queries.
¯ Wrote UNIX Shell scripts to automate the batch execution of the data scrub scripts on a nightly basis
¯ Developed and implemented solutions for process defects which turned up due to data abnormalities.
Environment: ERWin 4.1.4/3.5.2, Oracle 10g, UNIX (Solaris), SQL and PL/SQL , TOAD, Brio Hyperion
WWW.CHEAPONLINEPARTS.COM January 2003 - Present
Lead Oracle and Application Developer
Several phases developed over several years, began with a simple ecommerce site, and because a parts mall consisting of multiple domains each having unique SEO for the specific market. see http://www.cheamonlineparts.com or http://www.cheapmowerparts.com.
Responsibilities:
¯ Hosting and managing the operational environment using remote server farm.
¯ Designed the site architecture using open source and Oracle database.
¯ Designed and deployed all tables, functions, and stored procedures.
¯ Performed the technical lead role coordinating the designers, developers, and testing team.
¯ Developed critical credit card interface, and batch interfaces for shipping.
¯ Developed the back office support system for data management.
¯ Directed all defect resolution and implementations.
¯ Developed upload and batch product update capabilities.
¯ Developed the struts config files, installed the web servers, java, and apache software.
¯ Updated the apache config files, the tomcat config files and the application parameter files.
¯ developed the Oracle Java Beans for each table, the Java forms, logic, action, and servlet packages.
¯ Designed and implemented the logic and converted the designer html pages into jsp pages.
¯ Developed the timeline and development schedule.
¯ Delivered the website on time and under budget for each phase.
Environment: Linux, Apache, Tomcat, Java, Struts, JSP, Dreamweaver, Oracle 10g, Sql Loader, Sqlplus, Application Express, Velocity Engine.
WWW.SHARPERLEATHER.COM
Lead Oracle and Application Developer
Small ecommerce site using Oracle Tomcat Apache, and Java, jsp technology.
Responsibilities:
¯ Hosting and managing the operational environment using remote server farm.
¯ Designed the site architecture using open source Apache, Tomcat, Java, and Oracle database.
¯ Developed the backoffice support system using the Oracle Application Express (HTMLDB).
Martha's Mixture Antiques August 85 - May 05 (part time)
Point of Sale System developer and consultant
Multi-million dollar antique store needed point of sale solution and inventory control. Designed, developed, deployed and supported the Omnis client server solution from 1985 until the business closed in 2005.
Responsibilities:
¯ Created the inventory system, sales system, consignment system, accounts receivable system.
¯ Designed the architecture to use Oracle and Omnis 7 in a client server environment.
¯ Website used the database as the product source.
¯ Created the network, established the hubs, routers, and all wiring, connected to multiple dsl suppliers.
¯ Maintained the system for 20 years.
Capital One Financial September 00 - December 04
Sr. Oracle DBA / Developer
I designed and developed the data models and database for the GT8 recruiting system which automated the process of recruiting tier 8 associates for the call centers and other positions. The system consisted of a website workflow system that managed the applicant from the first login to eventual hire. The process managed the presentation of testing, and process management. The test results, interview results, the comments, and other results of the process were evaluated and the end result was that a candidate would know before the end of the day if they were to receive a job offer.
Responsibilities:
¯ Design and build all database requirements for the system.
¯ Conduct end user data gathering sessions to identify data needed
¯ Model the data into the database, and review with the data analysts for usability.
¯ Keep the development, test and qa databases on the current release with the java developers.
¯ Provide scripts for the production deployment for the production dba's.
¯ Develop the tables, functions, and packages to conform to corporate db standards and guidlines.
Sr. Oracle DBA / Developer
I designed and developed the data models and database for the corporate information factory for thes recruiting systems which included the HireOne client server system for execuitve recruiting and the new GT8 recruiting system.
Responsibilities:
¯ Design and build all database requirements for the system.
¯ Design staging tables for the etl team to land data from the various outside systems.
¯ Design the information factory to hold all of the recruiting data, and included the ability to query current view, as well as point in time for the datamarts.
¯ Develop the scripts to be deployed to each environment, and implement dev, test, and qa. Provide productrion turnover scripts for the production releases.
¯ Develop a rosetta stone technology for matching data from disparate sources.
¯ Develop an integration strategy for merging data from disparate sources to enable future conformity in the information factory.
¯ Develop and deploy the datamarts which were used by the BRIO, Hyperion Business Intelligence tools
Boston Globe April 05 - November 05
Oracle Developer / DBA
Oracle Corporation August 99 - August 00
Sr Principal Consultant / Production DBA
As a member of the contracting group to the Defense Supply Company Richmond, part of Defense Logistics Agency of the Department of Defense, I installed upgrades to production applications, and kept Oracle running with patches. I managed the relationship with Oracle for needed TARS, and attended training once a quarter for Oracle in Backup and Recovery, Performance Tuning, and Administration.
Responsibilities:
¯ Production DBA responsible for production application installs, and Oracle patch releases.
¯ Developed standards and guidelines for developers for automated installs for the test db's.
¯ Created a QA database for the main application.
Circuit City / Divx August 97 - August 99
Database Developer / Modeler
Signet Bank/EDS August 85 - August 97
Lead Programmer Analyst
Responsibilities:
¯ Installed and created Oracle Database for a data warehouse for credit risk analysis.
¯ Built the ETL for loading the multiple sources using oracle utilities.
¯ Wrote SAS programs for reporting on the data, and conforming data for eventual loading.
¯ Wrote Powerbuilder interfaces for reporting and for loading data for analysis.
¯ Worked as Lead Programmer on the DDA and Time Deposit teams
¯ Converted the DDA application from source code controlled to parameter driven software to improve the team ability to offer configurable options to the system.
¯ Lead developer for the bank conversion of Union Trust into the Time Deposit System.
CF Sauer Company November 72 - August 78, and March 81 - August 85
Operator, Programmer, Programming Manager
Pittston Coal Group September 78 - March 80
Sr Programmer Analyst
ITT North Telecom March 80 - March 81
Sr Programmer Analyst
References:
Jack Cox Manager, Circuit City/Divx 804-545-8765
Harrison Williams Manager, Capital One Financial 804-916-9599
Matthew Frame Manager, Wachovia Securities, LLC 804-398-6801
Christopher Corrigan Manager, Capital One Financial 804-381-1058