We provide IT Staff Augmentation Services!

Pl/sql Resume

Scottsdale, AZ

Data Specialist

OBJECTIVE

To thrive as an accomplished data specialist in an organization that desires concise, accessible, timely, economical, and reliable data in order to lead in its industry.

SUMMARY

Dedicated
Resourceful and creative
Serves the business and its customers
Passionate about data and its relationship to people
Creates solid direction, data, and applications to match
Expert at making sense of conflicting or ambiguous information
Communicates well with people in a wide variety of business roles
Dedicated to answering business questions with efficient and effective solutions
Over 10 years of experience in many complex and high profile development projects

PROFESSIONAL COMPETENCIES

  • Exceptional SQL and data analysis skills
  • Proven experience with very large and complex databases
  • Accomplished in writing PL/SQL for batch and online applications
  • Utilizes data modeling concepts, indexing, triggers, views, and data normalization
  • Derives meaning from abstract data
  • Performs data extraction, mapping and migration
  • Translates business entities into efficient data repositories
  • Follows System Development Life Cycle methodologies
  • Abides by proven project management practices to produce successful projects
  • Gathers requirements in JAD sessions with internal and external business partners to derive and document business requirements
  • Writes/reviews data mapping, data model, business rules and functional specifications
  • Flexibly fills various roles during design, construction, testing and implementation
  • Discerns scope, objectives and initiates design of new projects within complex systems
  • Extensive success performing gap analyses and providing accurate project estimates and timelines, as well as recommending and mentoring project team members
  • Enjoys promoting the success and growth of every member of the team
TECHNICAL SKILLS

Requirements Mgmt: Microsoft Office, Visio, PowerPoint
Databases: Oracle 7, Oracle 8i, Oracle 10g, Oracle 11g
MS SQL Server
Data Modeling: ER Studio Data Architect
Data Quality: SAP Business Objects Data Services
Data Warehouse: Microsoft SSIS
Reporting/SQL: Oracle Discoverer, Crystal Reports, Toad,
SQL Navigator, SQL Developer, Embarcadero Rapid/SQL
Programming Languages: PL/SQL, Visual FoxPro, PowerBuilder
Operating Systems: Windows, UNIX
Version Control Tools: PVCS, Visual Source Safe, Subversion, Harvest

EXPERIENCE

Confidential
Scottsdale, AZ
Oct 2010 to Present
Manager REMS Data Services

Hired to remediate data issues during a major initiative under very tight deadlines. Successfully identified high impact data issues, implemented data cleansing processes, created processes to utilize operations personnel to perform outreach and to feed automated data corrections. Project went into production with minimal data issues resulting in major client savings.

Put in charge of a major data conversion to merge data from four separate systems into one simultaneously being developed. Created project assumptions and high level tasks to estimate effort. Assembled a project team of five including Business Analyst, PL/SQL Developer, Report Analyst, Quality Analyst, and ETL Developer. Led data conversion and reconciliation reporting design. Project results include less than .1% data exceptions.

Data Services Manager responsibilities include leading a team of eight diverse team members with roles including Data Architecture, Data Warehouse Developers, Reporting Analysts and Data Management Analysts.

Confidential, Phoenix, AZ

Sep 2009 to Oct 2010
Data Architect Lead
Mar 2008 to September 2009
PL/SQL Developer

As Data Architect Lead primary responsibility is as a lead in designing database changes and leading reporting projects. Led a data team of three in implementing report enhancements, performing functional design reviews, and in data analysis.

As PL/SQL Developer wrote database application code to enable custom workflow for new and existing customers. Worked on special development projects for high profile customers. Responsibilities: Create business rules for use in developing new customer workflows. Design and develop data structures, PL/SQL functions, PL/SQL procedures, and views for enhancements and new applications. Provide direction to other developers in the database design for new applications. Standardize and consolidate existing PL/SQL code. Produce ad hoc reports, analyze and resolve data integrity issues. Create and maintain Crystal Reports and Active Reports for application use.

Confidential, Phoenix, AZ April 2004 to March 2008

Confidential, Milwaukee, WI

Feb 1999 to April 2004
Programmer Analyst/Specialist - Team Lead

Performed gap analyses between the company's existing bill payment processing engine and newly acquired systems. The goal was to seamlessly integrate the customer base of both of the acquired companies into Metavante's pre-existing bill payment system.

Primary role was to quickly understand and integrate customer data and any functionality belonging to the two acquired legacy systems that would need to be integrated into the existing system. Performed interviews with business executives and users of legacy systems to identify gaps and gather functional requirements. Analyzed and estimated the time and cost to integrate each major functional gap. Provided primary direction for migrating customer data from the two acquired systems into the existing system. Responsibilities: Provide analysis of functional gaps, initial design, and estimate cost for each project. Work with project stakeholders to determine viability and priority of each project. Provide direction to data migration team members. Enhance data model and work with DBA to integrate new data elements. Review requirements, functional design, technical designs, and PL/SQL code. Due to the large increase in both organic growth and new customer additions, there was a need to dramatically increase the capacity of the transaction processing system. The goal was to provide enough capacity for projected growth over the next year. Primary role was to develop and lead projects to increase transaction processing capacity by 25 times its current volume. The enhancements included, migrating from a Windows NT operating system to UNIX; upgrading from Oracle 7 to 8i; multi-threading batch processing; using PL/SQL tables in memory to process transactions; redesigning payments processing to incorporate more tightly coupled data inputs and outputs to reduce database access; moving business logic from C++ code to PL/SQL packages; and automating manual daily reports to run after the completion of processing to reduce contention. The projects resulted in capacity in excess of the initial goal and with no adverse impacts to system functionality. Responsibilities: Initiate, lead, and document results of brainstorming meetings. Document high level design of each capacity enhancement. Estimate project cost, prioritize project order, recommend project team members. Oversee benchmark tests, document results, & project capacity improvements. Review documentation to ensure the preservation of existing business rules. Develop and execute test cases and queries to ensure proper functionality.

Confidential, Minneapolis, MN

May 1995 to Oct 1998
Senior Technical Analyst

Hired on as a consultant and then as an employee to develop Visual FoxPro database and data entry screens for an acquired bill payment processing system. The company changed its development processes and migrated from Visual FoxPro to Oracle and PowerBuilder. Due the process change and the inadequacy of the acquired legacy bill payment processing system, the entire system was re-engineered. Primary role was designing new data entry screens and creating new bill payment transaction processing interfaces and batch programs. Chosen as one of a team of nine to work on the high profile re-engineering project. The team completed the project successfully on time and within an extremely tight budget. After the system was implemented, the product line was purchased by Metavante and the product grew dramatically on the new system. Responsibilities: Facilitated JAD sessions, provided screen mock ups, created business process flow diagrams, captured and documented data elements and business rules. Developed customer service data entry screens using an iterative screen design. Developed PL/SQL procedures for batch processes. Created and executed test cases for data entry screens and complex billing system. Worked with data analyst to create normalized data model for the new database. Mapped all data elements of the old system to the new. Solely responsible for writing, testing, and executing the scripts to import the legacy data into the new Oracle database.

EDUCATION

  • B.A. in Social and Cultural Anthropology
  • Certificate in Business Intelligence and Data Warehousing

Hire Now