Data Customer Service

SQL Analyst Developer

Cross-functional Leadership and Support Systems and Data Analysis Requirements Gathering and Data Integrity

Customer Service and Retention Change Management Business Development Project Management

Qualifications Profile

Innovative, detail-oriented, and versatile professional, offering extensive experience in information technology management and support in a variety of settings. Equipped with in-depth skills in interface integration, efficiency improvements, systems and data analysis, and application support. Known for outstanding decision-making, problem-solving, and communication skills in dealing with diverse clients and all levels of professionals.

Professional Experience

Computer Science Corp. (CSC) Various Locations

Senior Consultant Feb 2012–Apr 2016

Provided expert consultations to the following companies:

oVerizon : Data Analyst

Maintained active engagement with accountants in providing forensic accounting support of acquired companies

Broadened understanding of current system capacity and acquired business and technical requirements for new standards and reporting requirements in collaboration with business and technical teams

Produced Teradata databases of current systems to provide data analysis and to create statistical models for forensic accuracy as well as SQL queries to mine data and create models

oUS Bank : Reporting/Techincal Analyst

Successfully implemented the Early Resolution (ER) conversion

Thoroughly assessed, mapped, and kept record of 40 sources to target mappings

oThe Berry Corporation : Data/Technical Analyst

Took charge of the ETL of legacy data into Salesforce for installation

Assisted in identifying high-level architecture and the artifact templates for completion to be used in Data Migration Factory (DMF)

Performed in-depth analysis while creating and updating source to target mappings of legacy data onto the new system, DMF specifications for ETL

Evaluated the source system and provided data quality and profiling directives to eliminate potential issues on source data migration

oJM Family : Technical Analyst/Data Modeler

Analyzed data and created data models for integrating multiple applications into single data repository.

Illustrated the reconfiguration of existing and new models of the main data repository to adapt to the new information; developed and designed source to target mappings of new configuration.

oMD Anderson : Interface/Data Analyst

Thoroughly assessed the Invision and IDX interfaces to prepare conversion to Soarian financials and scheduling.

Recorded the interfaces to 30 databases acquired from various departments to provide universal corrective action plan.

Set strategic direction in evaluating, mapping, and recording current state ADT and SIU HL7 interfaces for 12 departments for the conversion to Soarian.

Partnered with colleague in formulating an automated diagramming process for the present state of Cloverleaf Interfaces.

Grady Health System Atlanta, GA

Application Interface Coordinator Jun 2011–Feb 2012

Displayed proficiency in analyzing, documenting, and maintaining Siemens OPENLink and Epic Bridges interfaces.

Worked closely with Application Support teams in identifying and resolving production issues while guaranteeing the timely delivery of patient information; as well as in facilitating test upgrades and the implementation of new functionality or new software.

Performed evaluation of specifications and documentation while ensuring seamless flow of test cases.

Orchestrated documentation and spearheaded training programs to educate all help desk employees.

The Home Depot, Inc. Atlanta, GA (Aug 2004–Jan 2010)

Senior Developer POS Technical Lead Feb 2009–Jan 2010

Expertly identified gaps in the entire Informix code, UNIX Shell scripts, and Optio reports.

Created and maintained a balanced workload for developers with other projects.

Capitalized on technical expertise in streamlining conversion process.

Conducted code reviews and unit testing to regulate consistent code transitions among three developers on more than 400 modules of code.

Key Accomplishments:

Provided expert leadership to a three-person team assigned to re-platform the POS system platform from HP-UX to Linux.

Managed the System Implementation Team in generating new and efficient environment while guaranteeing timely delivery of all changes.

Directed the development and implementation of the first Health Check Monitoring System for POS.

Carried out the incorporation of more than 2000 stores through the replacement of manual validation at each store; thereby reducing the three-hour conversion time to less than one minute, resulting to the decrease of rollout from four months to six weeks.

SAP Canada Support Mar 2008–Feb 2009

Delivered in-depth technical support for IM/MM modules of SAP while working closely on issues in the PO module.

Key Accomplishments:

Assumed full accountability for the stability and clean installation of the Canadian SAP implementation for IM/MM.

Augmented the entire conversion process from 4 hours to just 20 minutes.

SAP Canada Development Lead Sep 2007–Mar 2008

Directed a team of four developers on more than 200 modules of code through code review, unit testing, and QA testing; as well as in interfacing the Tool Rental application with SAP, covering all requirements, design documents, coding, test plans, testing, defect updates, release strategy, and detailed reporting.

Identified partnership with the Environment, Hardware and QA teams in managing the system implementation of the test environment.

Proactively performed systems analysis of SAP system and Tool Rental Application Suite for gap and risk assessments.

Systematically built functional and design specifications.

Ensured efficiency in delivering tool rental code into production.

Tool Rental Support Team Lead/Subject Matter Expert Aug 2004–Sep 2007

Served as point of contact for the Home Depot Tool Rental Application Suite.

Spearheaded numerous cross-functional teams regarding Tool Rental Application Suite.

Trained new associates regarding technical and functional aspects of the Tool Rental Application Suite as well as its related business processes.

Key Accomplishments:

Drove efforts in augmenting efficiency in the following:

oTool Rental queries with increase in return rates of 6-30%; and

oHelp Desk by 14% and increase in resolution time by 8.7%.

Handed back $1.2M to the Tool Rental and $200K year-over-year due to identified errors in the deposit code.

Brought adept leadership to three Production Support Team members responsible for maintenance, system stability, and improvements of Tool Rental Application Suite to be used throughout more than 2,000 locations by over 10,000 associates.

Enforced and maintained balanced workloads between daily trouble tickets and enhancements or bug fixes.

Oversaw the development and application of the release management strategy.

Earlier Positions Held:

Systems Engineer

Associate Systems Engineer

Education and Certifications

Bachelor of Science in Computer Information Systems University of West Florida Pensacola, FL

Epic Bridges 2010, 2012, 2014, and 2015

Cloverleaf Level 2

Technical Acumen

Application Integration/Modernization

HL7 Interface ERP Systems Integration ETL Data Integration

Vendors

Epic SAP Infor Siemens Cloverleaf OPEN Link Teradata

Data Modeling

ERwin Microsoft Visio

Programming

Shell Scripting Informix 4gl HTML SQL T-SQL PL/SQL

Operating Systems

HP-UX Red Hat Linux MVS/zOS

Databases

Oracle SQL Server DB2 Informix MySQL Microsoft Access

Contact this candidate