Post Job Free

Resume

Sign in

Oracle Data

Location:
Waukee, IA
Posted:
January 29, 2013

Contact this candidate

Resume:

Michael Lake

Email: abqfko@r.postjobfree.com

Address: *** ****** **

City: Waukee

State: IA

Zip: 50263

Country: USA

Phone: 515-***-****

Skill Level: Experienced

Salary Range: $50,000

Primary Skills/Experience:

See Resume

Educational Background:

See Resume

Job History / Details:

Michael J. Lake

abqfko@r.postjobfree.com

515-***-****

QUALIFICATIONS:

Solutions-focused, team oriented Systems Data Analyst with experience and hands-on

skills in successful implementation of PL/SQL procedures and packages. Validation of

complex client insurance renewal and conversion of Legacy HP Unix systems into

an Application based system using Oracle 10g &11G database. Completed the largest Medical and Non-Medical Insurance conversion from Unix to Oracle using PL/SQL & SQL to validate bulk data loads. Validating moving of Data for Wells Fargo from Legacy

Systems to Terradata Platform. Experience with Star Schemas, Snowflake Schemas

and Data Warehousing concepts.

Computer Skills:

Database Administration on Oracle 9i, Oracle 10g,

PL/SQL, SQLPlus, Toad for Oracle, PL/SQL Developer on Oracle 9i, Oracle 10g, Oracle 11g, FoxPro on DB2. Ascend SelectPlus, Terradata SQL Assistant. Sybase Power Designer. Installed Oracle 11g client and database for querying external Oracle System.

SQL on SQL Server.

Experienced on HP-UX, Sun/Solaris Unix. Korn shell scripting on Sun Solaris System.

Microsoft Word, Microsoft Excel, Microsoft Access, Microsoft Outlook.

Macintosh Pages, Macintosh Numbers. Used subversion and sharepoint as version control. IBM Clearcase, Liquid XML. Test Trak Pro, PAC 2000.

Formal training in PeopleSoft HR/Financials/Workflow/People Tools 1 & 2, PeopleCode,

E-Builder, Financials, Payable, Purchasing, General Ledger

Operating Systems:

HP-UX, SUN Solaris, Windows XP Pro, Windows 7 Pro,

Mac OS Tiger, Leopard, Snow Leopard.

Hardware:

IBM, HP, iSeries AS400

Personal Computers:

PCs, Macintosh

Experience:

Robert Gatto Associates (Contract Position at Wells Fargo 7/25/11 to 3/30/12

Data Base Analyst Validation of data migrated from Legacy Systems to Terradata

Database Using Terradata SQL Assistant and Toad for Oracle by verifying Modeling using Sybase Power Designer and mapping document provided by Integration Analysts.

TEK Systems (Contract Position at U of I Foundation 4/25/11 7/11/11

Data Analyst

Maintaining Legacy iSeries AS400 using SelectPlus in Application ASCEND.

queries to create data files for donations, mailings, confirmations of Events,

conferences and other activities.

Creating queries to validate bulk data loads in new client/server based application

to replace the AS400.

TEK Systems (Contract Position at IFMC) 4/12/2010 2/15/2011

QA Engineer III - PL/SQL Developer

Worked in a team environment where good team communication is invaluable.

Validated Bulk Data Loads and test analysis on complex applications.

Created test planning and execution for automated error analysis including test outlines

test cases and test data. Created XML files to use for validation of EHR data loading.

Created complex PL/SQL packages, procedures and functions on Physicians Quality Reporting Initiative in an Oracle 10G environment with billions of rows of data.

Optimized runtimes from hours to minutes. Provided front and back-end analysis on Electronic Health Records for PQRI Initiative, making sure that the doctors/facilities were meeting compliance to federal regulations, created test cases using PL/SQL to automate report and error analysis. Provided Reporting and Feedback (RAV) packages and analysis and Pre Analytic packages and analysis (PAM).

Marsh (MMC) 2/2008 3/2010

PL/SQL Developer/Data Analyst

Proficient experience as a SQL Developer, Data/Systems Analyst with complex SQL

in Oracle 9i & 10g databases.

Assisted in writing, revising and verification of software programs for data conversion

from a HP legacy system to an Oracle Database. Created mapping documents for this

conversion. Optimized SQL reducing load times from over 2 hours to less then 20 minutes. Lead project team member reviewing and discussing PL/SQL code, and proficient in back-end PL/SQL and SQL procedure execution and validation.

Created and managed complex data feeds using both Unix and Windows based systems.

Reviewed and modified data processes, providing documentation to verify functionality

according to user requirements using Clearcase

Validated XML using schema validation using Liquid XML.

Created user reports using PL/SQL developer & Microsoft Access based on

gathering and documenting business process owners to create & resolve data testing.

Created change requests to successfully coordinate testing and signoff/approval.

White Water Consulting 9/2007 1/2008

Client: Wells Fargo

Applications Systems Engineer

Performed in a technical role as designer in major computer applications utilizing a thorough understanding of available technology, tools and existing designs.

Worked on extremely complex problems where analysis of situations or data required

Evaluation of intangible variance factors.

Responsible for providing production data environment incidents and inquiry support in

existing Oracle & SQL Server environments supporting CORE Lending projects.

ADP 2/2006- 9/2007

Systems/Data Analyst

Using a thorough knowledge of Winflex application, developed solutions and recommendations to satisfy client needs through use of Winflex application while understanding impact on scope and timelines.

Provided operational support for clients after the application had gone into production.

Developed and implemented standardized processes, tools, deliverables to provide consistent standards. Provided mapping from client input files to Winflex and from Winflex to external files. Identified and resolved escalated client and production issues by conducting root cause analysis and resolution.

Wrote custom database queries and reports as appropriate.

ADP 10/2002 2/2006

Database Administrator (Oracle)

Performed database monitoring, tuning, backups/restores using R-MAN in a clustered

database environment with automatic failover to backup servers for over 150 Oracle databases using Oracle Enterprise Manager for problem isolation and resolution.

Provided application support for Business Analysts and Programmers on Enterprise

application. (PeopleSoft V8)

ADP 6/2001 10/2002

Applications Specialist

Responsible for customization, patches and upgrades on PeopleSoft on Oracle and

SQL Server platforms. Performed Unit Acceptance Testing for new software releases.

Provided Risk analysis of applying updates and patches.

Independent Consulting, Jun 2000 - Jun 2001.

Experience include installation & maintenance of Computers, Software

firewalls, computer networks. Responsible for installation of Operating Systems, hardware & software firewalls, networking applications and

anti-virus software.

Kansas University Medical Center May 1999 - Jun 2000

Sr. Programmer/Analyst working on implementation of PeopleSoft

HR & Financials.

Fulcrum Consulting Jan 1999 - May 1999

Responsible for Payroll processing using PeopleSoft with COBOL for employees located

both in outside of continental US for Halliburton. HR system was a Mainframe based HR System, corrected & identified issues with interface to

PeopleSoft application, created payroll file and fed this back to mainframe

interface.

Kansas University Medical Center Jul 1996 - Dec 1998

Programmer Analyst working on PeopleSoft HR/Payroll System using COBOL which fed State of Kansas payroll interface, performed payroll processing, SQR creation and modification. wrote SQRs for query reporting.

Promoted to PeopleSoft Administrator Performed upgrades, Operator Security Administration, Tax updates and updates to COBOL for payroll also.



Contact this candidate