Mike Kemp – ***** ***th Ave North – Largo, FL ****3

cell: 727-***-**** – ada1x4@r.postjobfree.com

Objective

Position as an Oracle Developer in a challenging environment that requires excellent analytical skills, communication skills, documenting ability and focus and devotion to tasks. The position that will be successfully fulfilled will be one that leverages my extensive history of database development, ETL design, complex query creation.

Summary of Qualifications

1) Experience meeting the technical demands of some of the nation’s leading and best-known corporations.

2) Experience with broad range of database technologies (in order of predominant experience, predominant listed first: Oracle PL/SQL & SQL, Oracle DBA, SQL Server, Interbase, Interbase procedure code, SAS, SAS code, and MySQL).

3) Experience with the following client-side development languages (in order of predominant experience, predominant listed first): Javascript, HTML, C#, VBA (MS Access, Excel and Word), Delphi, FoxPro.

4) Experience writing Unix Shell Scripts (Bourne/Korn) to move files and transform data.

5) Experience creating workflows and maintaining existing workflows using job scheduling tool Control-M.

6) Experience with Oracle PL/SQL programming objects such as packages, functions, procedures, and triggers.

7) Experience working in Data Warehousing environments where data normalization was secondary and query performance was primary.

8) Experience working in OLTP environments where data normalization was an important priority.

9) Experience tuning SQL for performance maximization and troubleshooting slow-running PL/SQL code.

10) Excellent communication skills.

11) Excellent writing, documentation skills.

12) Good leadership skills, with strong desire to learn and have opportunities to acquire more through experience, education and practical application.

Professional Experience

08/2016 – 11/2019: Wellcare, Tampa, FL – PL/SQL and C# Sr. Developer

Responsibilities

1.Monitor, maintain and enhance legacy Oracle application that was the centerpiece for this Fortune-200 corporation.

2.C# development in support of ancillary applications that accessed this main database application.

3.Only senior developer for the team that supported the central database application.

Achievements

1.Fulfilled all requirements for the position.

08/2015 – 02/2016: Orange Lake Resorts, Kissimmee, FL – MS SQL/PLSQL Developer – Contractor

Responsibilities

1.SQL Development for massive data transformation project

2.SSRS Report Development

3.Support PL/SQL Development team

Achievements

1.Completed project scheduled to take 9 months in 4 months

2.Aided PL/SQL Development team with critical support/advice

05/2014 – 04/2015: TSP Consulting Services, Marlton, NJ – MS SQL/Access Developer – Contractor

Responsibilities

1. Backend development using SQL Server T-SQL programming language.

2. Create T-SQL procedures to parse and process data for a mortgage processing system.

3. Create front-end systems for various clients in the mortgage banking industry using MS Access.

4. Document all created systems and some existing systems using HTML and Javascript.

5. VBA development for Microsoft Access front-end solutions.

6. VBA development for Excel for data analysis.

Achievements

1. Successfully created many T-SQL procedures and functions to process mortgage data.

2. Successfully created front-end systems using MS Access for mortgage pool processing teams at client sites.

08/2011 – 04/2014: Think Direct Marketing Group, Largo, FL – PLSQL/MS Excel/SQL Server/.NET Developer – Full-Time Perm.

Responsibilities

1. Backend development using Oracle PL/SQL programming language.

2. Backend development using Unix shell scripting (Korn/Bash).

3. PL/SQL Developer for existing OLTP system and new OLTP system requirements.

4. PL/SQL Developer for existing Data Warehouse and new Data Warehousing requirements.

5. Extensive job scheduling created/monitored/managed using Control-M.

6. Interview prospective new software development employment candidates.

7. C# development.

8. Shell scripting.

9. Manage code using Team Foundation Server.

10. Troubleshoot database performance problems.

11. VBA development for Excel for data analysis and interactive presentations.

12. HTML and Javascript development for interactive presentations.

Achievements

1. Created dozens of PL/SQL Packages to support OLTP and OLAP systems.

2. Created C#-based check-processing system for automated electronic check payments for magazine subscription packages.

3. Created both C# programs and PL/SQL procedures that accessed web services and parsed return data for further analysis and processing.

4. Analyzed Oracle database performance issue and accurately isolated library cache lock contention as cause. Recommended solution to be allocating more memory to database instance which successfully resolved the issue.

07/2011 – 09/2011: Serve, American Express subsidiary, St. Petersburg, FL –PLSQL Developer – Contractor

Responsibilities

1. PL/SQL Developer for OLTP peer to peer payment system

Achievements

1. Backend development using Oracle PL/SQL programming language.

2. Created new PL/SQL packages according to specs defined in FRD.

3. Migrated code to Subversion source control system.

4. Collected user requirements, documented requirements and created/modified code according to the collected requirements.

5. Wrote Unit Tests for requirements and documented results to management / users.

6. Created Contact Management system piece for on-line P2P payment system referred to in title of this section.

11/2010 – 11/2013: Suncoast Oracle Users Group, volunteer for Educational Non-Profit – Volunteer

Responsibilities

1. Expert presenter for November meeting, subject Object-Oriented development using PL/SQL

08/2010 – 07/2011: CitiBank, Brandon, FL – Oracle PL/SQL Developer – Contractor

Responsibilities

1. Backend development using Oracle PL/SQL programming language.

2. Translate business logic into PL/SQL code

3. Responsible for Federal Regulatory Reporting for Citibank's international back office operations

4. Data modeling required for new tables

5. Advanced SQL involving analytic functions and subquery factoring

6. Maintain and make periodic changes to legacy VBA (MS Excel) reporting system.

7. Install and maintain IBM Websphere for use with proprietary enterprise grade data analysis tool (Symphony RPM).

8. Install SymphonyRPM data analysis software on server and clients and did initial cube / query design.

9. VBA development with Excel to support and existing Regulatory Reporting financial application.

Achievements

1. Quick mastery of complex business logic

2. Mastery of formal business documents not encountered before: BRD's (Business Requirements Document), FRD's (Functional Requirements Document), TDD's (Technical Design Document)

3. Easy assimilation into a large organization with formal team structure

4. Mastery of legacy VBA system that generated hundreds of preformatted government reports.

5. Successfully installed and confirmed operation of IBM Websphere (single instance version).

6. Successfully installed and confirmed operation of Symphony RPM data analysis tool, server and client packages.

03/2010 – 03/2011: Clearwater Research Group, St. Petersburg, FL – Web/PLSQL Developer, Oracle PL/SQL Developer – Freelance

Responsibilities

1. Using Oracle PL/SQL to auto-generate web pages based on advanced business logic.

2. Developing web pages for Osceola County Sheriff’s Office using HTML, Javascript.

3. Application development using C# in .NET development environment.

4. Reading/referencing Cobalt legacy code for prototyping new designs.

Achievements

1. Creative incorporation of Oracle database technology to automate manual web page development.

2. Quick mastery of complex application flow involving hundreds of search options containing various types of crime data requests (gun, article, vehicle, criminals, missing persons, etc.).

3. Consistent on-time delivery of projects.

10/2009 – 10/2011: SOUG – Suncoast Oracle Users' Group, Tampa, FL – Professional Organization, non-paying volunteer – Volunteer

Responsibilities

1. Locate, schedule and organize speakers for monthly meetings.

2. Locate venues for special events, coordinate speakers for same.

Achievements

1. Elected to board of Suncoast Oracle Users Group

2. Expert Presenter at Suncoast Oracle Users Group: Object-Oriented Development in PL/SQL

08/2008 – 03/2009: FIMC, Sarasota, FL – Web Developer/SQL Server Developer – Contractor

Responsibilities

1. Write SQL statements to extract data from SQL Server database.

2. Modify existing T-SQL procedures to accommodate changing business logic.

3. Create portal web sites for new clients to company based on template using ISAPI DLL's, HTML, and Javascript.

4. Customize existing portals to meet changing business requirements for existing clients.

5. Implement security measures on existing sites to protect from SQL Injection and cross-site scripting attacks.

6. Troubleshoot errors in portal functionality, report causes, suggest repair measures and repair.

7. Research needed security measures, report and implement.

8. Created connections to SQL Server databases, wrote required SQL statements and used return data in web site functionality.

Achievements

1. Quickly and successfully mastered new development language on the job: javascript.

2. Performed all job duties at a high level of performance.

12/2006-05/2008: Verizon, Tampa, FL –PLSQL and Informatica ETL Developer – Contractor

Responsibilities

1. Backend development using Oracle PL/SQL programming language.

2. Analyzed existing PL/SQL code and created new PL/SQL code in procedures, functions and packages. Also created new SQL in client application to be transferred to Oracle for execution: client application was Informatica 7.1.

3. Extensive use of Oracle's analytical functions (SUM with Partitions, Lead/Lag, Rank, First/Last, etc).

4. Extensive experience writing Oracle inline views, which improved performance and created code that was highly readable.

5. Extensive experience creating Oracle subqueries, which improved performance and created code that was highly readable.

6. Extensive experience writing correlated subqueries in Oracle, which improved performance and created code that was highly readable.

7. Extensive use of Oracle SQL for advanced business logic: Queries often exceeded 2,500 lines in length and accessed tables containing hundreds of millions of rows of data.

8. Analyzed existing SQL statements and PL/SQL objects to incorporate new business logic into the process or to troubleshoot performance issues that arose for various reasons. Among these reasons were changing data structures that broke existing code, new business rules that needed to be implemented, new datasets that needed to be incorporated and new functionality that was being required.

9. Performed data modeling tasks so that new ETL's could be developed and implemented, so that existing ETL's could be repaired and upgraded and so that performance on existing processes could be improved.

10. Collaborated successfully with other team members (managers, architects, DBA's, interface developers) so that the end result was of high quality to the end user.

11. All work done in Oracle 10g, 11g.

12. Informatica server administration duties performed as part of rotating on-call pager duty.

13. Managed and edited files in Unix environment. Wrote Unix shell scripts.

14. Contributed to the development of massive Business Intelligence tool used by Verizon executives on a daily basis. The DSS Tool (DSS = Decision Support System) provided an overview of business activity from all Verizon retail centers nationwide, among other things.

15. Provided team management with on-demand reporting on design statistics, content statistics and performance statistics for the data warehouse that contained the data used in the DSS BI system.

16. Troubleshot DSS BI code for reporting anomalies, and fulfilled inquiries from executives for statistics support, background and substantiation.

17. Proposed, designed and implemented changes to the data warehouse metadata for required modifications. Modifications included changes in reporting requirements for certain statistics, new statistics being required, statistics being retired and statistics being archived, recalled or otherwise maintained as a result of regulatory requirements.

Achievements

1. Successfully performed all required assignments.

2. Performed well on the DSS team by being cooperative at all times, willing to lead and follow as the situation deemed each role to be appropriate.

3. Eagerly volunteered for all-night burn sessions preceding major system changes to ensure flawless performance for Verizon executives on the morning of scheduled deployment.

08/2002-12/2006: Mortgage Investors Corporation, St. Petersburg, FL — Oracle/PLSQL/MS Access/Delphi Developer – Full-Time Permanent Employee.

Responsibilities

1. Managed 400-million+ record database of lead contact records, including Oracle DBA responsibilities associated therewith (making sure space is available in tablespaces, adding datafiles to tablespaces, creating and managing indexes, monitoring performance and making adjustments, etc.). Oracle 10g.

2. Wrote hundreds of functions and procedures using Oracle PL/SQL.

3. Created dozens of packages in Oracle PL/SQL.

4. Created data models in Oracle databases for all matter of business: payroll, sales commissions, accounting, marketing, loan processing.

5. Transferred data in/out of Oracle databases using Heterogeneous Services: Borland Interbase, Microsoft Access, flat files, Microsoft FoxPro, Microsoft Excel, SQL Server.

6. Setup and maintained VPN systems for 40+ branch offices all over the country so that daily reporting needs could be met.

7. Created, led and implemented strategy to clean and standardize data (name, addresses, phones) and identify duplicate records. 30 million+ records in Oracle. Oracle 10g.

8. Accessed XML data on websites using PL/SQL using UTL_HTTP package and processed data using XMLDOM package. Oracle 8i.

9. Provided all manner of Business Intelligence reports to executives on all departments of business: marketing, sales, payroll, loan processing, demographics, employee performance.

10. Constant and continuous production of ad-hoc reports for all departments of business.

11. Created client applications in MS FoxPro, MS Access, MS Excel, Delphi (version of Delphi shipped with loan origination software Empower) that used Oracle as back-end. Oracle 8i, 10g.

12. Researched and reported to executives and management new software initiatives, met with vendors, compiled requirements and features and installed and implemented newly acquired systems.

13. Storage and masking of credit card data, submission of credit card data to transaction processing companies for sales.

14. VBA development for Microsoft Access to create new departmental business solutions and to support existing solutions.

Achievements

1. Provided reliable, constant support as the company upsized and downsized in the volatile mortgage business market.

2. Provided all required support to the business during emergency times (mainly hurricanes). Supported transfer of operations to off-site remote co-locations.

3. Streamlined business practices to various departments (marketing, sales, accounting, mortgage commodities) through the use of technology resulting in faster processing cycles, lower staff requirements and greater business reporting/tracking capabilities.

4. Performed complete development life cycle on numerous business applications: gathered user requirements, documented requirements, confirmed requirements with end-users, provided end-users with projected time-line of development, designed application architecture, wrote application, deployed, troubleshot, provided on-going support.

12/2000-05/2002: Goldman Sachs, St. Petersburg, FL Office — SAS/MS Access/MS SQL Server Developer and Data Analyst – Contractor

Responsibilities

1. Provided technical assistance with statistical analysis of mortgage commodities.

2. Developed applications and supported existing applications in MS Access.

3. Wrote code that processed data in SAS database (database of choice for main office in NY).

4. Received formal and on-the-job training for SAS development.

5. Wrote UNIX shell scripts in conjunction with operation of SAS databases. Korn Shell.

Achievements

1. Contract employee. Contract renewed 6 times as a result of excellent attitude and consistently good performance.

2. Successfully supported all legacy systems in place, while simultaneously replacing them with newer, improved solutions.

09/2000-10/2000: Walt Disney World, Orlando, FL – VBA Excel Developer – Contractor

Responsibilities and Achievements

1. Successfully took over and completed a faltering project.

2. Project collected and compiled data used for tracking maintenance upkeep of 19 WDW properties around the country.

03/1998-06/2000: Mortgage Investors Corporation, St. Petersburg, FL – MS Access/FoxPro/Oracle/SQL Server Developer – Full-Time Permanent Employee

Responsibilities and Achievements

1. Handled development needs for marketing division of company using Microsoft Access exclusively.

2. Managed databases ranging in size from 1,000 to 200,000 records (MS Access’s upper practical limit).

3. Report generation.

Professional Organizations

Tampa Bay PL/SQL Users Group, Founder

SOUG (Suncoast Oracle Users' Group), member

Contact this candidate