We provide IT Staff Augmentation Services!

Data Analyst, Pl/sql & T-sql Development (consultant) Resume

4.00/5 (Submit Your Rating)

Tallahassee, FL

SUMMARY:

  • Experienced software and hardware engineer with excellent problem solving skills and exceptional track record of accurate and expedient solutions.
  • Proficient at business and data analysis at both design and implementation project phases.
  • Pre and post sales technical support experience including trade show and executive level presentations.
  • IT Professional with expertise with Oracle PL/SQL, SQL.
  • Experienced at requirements gathering, data analysis, data modeling, logical and physical schema design and implementation of relational databases.
  • Experienced at ETL process for importing data from multiple sources into Oracle.
  • Experienced at tuning SQL PL/SQL for efficient extraction of data to multiple file types and/or access from connected or disconnected applications.
  • Experience with Oracle Admin and Oracle Database schema re - engineering to enhance performance.
  • Experience with SQL Server and T-SQL.
  • Hands on experience with all aspects on the SDLC from concept through sign off and then production support and training.

PROFESSIONAL EXPERIENCE:

Confidential, Tallahassee, FL

Data Analyst, PL/SQL & T-SQL Development (Consultant)

Responsibilities:

  • Convert new customer data from existing systems and databases to OTPS ODS database and then load to OLTP system database. Update and rework existing ETL code where corrections and additional functionality required.
  • Convert new customers existing oracle reporting procedures and PL/SQL code to OTPS proprietary reporting engine and sql server database.
  • Create custom reports in sql server utilizing views, functions and stored procedures.
  • Performance tune reporting views, procedures and table functions.

Confidential, Thomasville, GA

Oracle PL/SQL & SQL Server T-SQL Developer (Consultant)

Responsibilities:

  • Pay-By-Scan Oracle database re-engineer project. Eliminate Informatica from PBS ETL and scan determination processes.
  • Designed and implemented new file import process engine for all data required by PBS database. All file operations implemented from within Oracle utilizing java for file operations and external tables for data load using dynamic SQL and configuration tables to enable code reuse for all file types.
  • Collaborate with business on design of new scan determination algorithm.
  • Load reconciled data extracts to new forecasting system and create ETL code to load into Data Warehouse.
  • Hand-Held forecasting system new development SQL Server project. Design and develop various packages for use with scan data consumption within forecasting system.

Confidential, Tallahassee, FL

Programmer Developer

Responsibilities:

  • Team lead on pro*c conversion to java project, to relocate all SQL and appropriate business rules to PL/SQL packages.
  • Assist with new security model design to eliminate identified data access and manipulation vulnerabilities.
  • Re-engineer database schema and existing database objects to remove duplicate data and facilitate fast data access.
  • Design and code complex data retrieval for left navigation search counts for web portal.
  • Develop portal search counts and application logon statistics storage and data retrieval for management reporting.

Confidential, New Orleans, LA

Oracle Developer / Data Analyst

Responsibilities:

  • Refined requirements for user and executive reports for document and covenant risk management system.
  • Developed database documentation and ERD from existing schema and designed de-normalized star schema for data warehouse.
  • Designed and developed high performance PL/SQL packages for system reports, application Dashboard and user work lists.

Confidential, Irving, TX

MTS Systems Engineer

Responsibilities:

  • Responsible for system maintenance on Verizon smart payphone host systems, Confidential ’s Panorama and Nortel’s Millennium Maximizer.
  • Primary system engineer and DBA for Panorama system comprising of Oracle 8 and Oracle 8i databases on Windows NT & 2000 server.
  • Planned and engineered installation of Panorama system. Converted Expressnet system to Panorama using ETL techniques.
  • Maintained non-stop server TACL code for Nortel’s Millennium operational system and move data to Mainframe.
  • Developed automated configuration management program that eliminated user errors and significantly reduced day-to-day operational costs.
  • Designed and coded all customized reports with PL/SQL.
  • Twice Winners by Choice award and Outstanding Performance award recipient.

Confidential, Lakeland, FL

Technical Support / Sales Engineer

Responsibilities:

  • Worked closely with sales and engineering to provide easy adaptation of Confidential smart payphones by new customers.
  • Analyzed and evaluated potential customers’ business needs and recommended effective solutions for decision support systems.
  • Provided systems integration solutions to improve site performance and customer satisfaction
  • Installed, trained users, and supported smart payphone host OEM database systems Expressnet and Panorama.

Confidential

Technical Sales Support / Service Engineer

Responsibilities:

  • Trained overseas customers and distributors on PT3000 bar-coding system.
  • Supervised several complete system installations throughout Europe and the USA.
  • Worked with sales and marketing to maximize sales opportunities. Provided marketing support at domestic and international trade shows.
  • Evaluated technical and business needs of customers and prospects and managed technical phase of the sales cycle.
  • Developed and delivered product presentations and demonstrations at customer locations and trade shows.

We'd love your feedback!