SUMMARY:

Knowledgeable technical professional with extensive experience developing and deploying custom business intelligence database applications that dramatically improve organizational data analysis and management. Demonstrated skill in translating business requirements into technical specifications governing design and development of business intelligence report generation and data extraction tools. Proven history of success leveraging System Development Lifecycle (SDLC) and relational database design experience to develop custom databases and tools. Advanced expertise in developing, designing, scoping, testing, and implementing client - server and mainframe legacy applications that enhance key business processes.

AREAS OF EXPERTISE:

• Business Intelligence Reports, Dashboards, and Scorecards
• Mainframe Application Development Requirement Analysis Database Management & Reporting
• Software & System Upgrades, Integrations, & Implementations Relational Database Design
• Business Intelligence Applications Data Modeling & Mapping Dynamic Reporting Interfaces
• Process Automation Requirements Mapping Organizational Needs Assessment
• Data Warehouse Mapping & Dimensional Modeling Data Cleansing, Validation, & Loading
• Data Feeds Data Imports Work Flow Implementation Data Analysis

TECHNICAL SKILLS:

• Microsoft SQL Server Database Development SQL Server 2008R 2/2008/2012/2017
• T: SQL Data Transformation Services (DTS) SQL Server Integration Services (SSIS)
• SQL Server Reporting Services (SSRS) Power BI Tableau SQL Server Profiler SQL Server Agent
• Crystal Reports 8 / 9 / 10 DB2 IBM Mainframe z/OS COBOL SQL Programming JCL
• CICS VSAM CA7 Endeavor TFS Extract Transform & Load (ETL) EDW Teradata
• Oracle PLSQL SQL Assist Stored Procedures Functions Views Triggers Query Optimization TCP/IP Technical Writing Advance Trouble Shooting SAS Agile Hadoop

PROFESSIONAL EXPERIENCE:

Business Intelligence Developer

Confidential, Memphis, Tennessee

Responsibilities:

• Developed custom ETL processes using Microsoft SSIS to extract data from vendor EMR application database for migration into client custom database.
• Also, created custom reports using Crystal Reports and SSRS.

Senior Business Intelligence Analyst

Confidential, Memphis, Tennessee

Responsibilities:

• I provided business intelligence support for Global Planning and Engineering various systems servicing the Confidential ramp, hub and station locations.
• Responsible for pulling data from the mainframe and various large database systems, manipulating and organizing the data for ETL into the Field WEB Reporting system, utilizing T-SQL for data acquisition, SSIS for data migration, and a strong understanding and experience working with SQL Server.
• Developed custom Business Intelligence reports using SSRS and Power BI for Air Operations to optimize container weight, pieces, and cube for planning versus actual air operations.
• Also, developed, maintained, and tested legacy mainframe programs using COBOL, CICS, DB2, SQL, VSAM and JCL on an IBM for data acquisition and migration.
• Region of Month/District of Month ETL and Report
• Planning vs Actual Air Operations Flight Data ETL
• Planning vs Actual Courier Route Stops Per Hour ETL and Report

Business Intelligence Developer

Confidential, Nashville, Tennessee

Responsibilities:

• Developed custom ETL processes using Microsoft SSIS to support vendor applications and the integration of data into Clinical Management System.
• Also, developed custom reports to support business community using Microsoft SSRS.
• Designed major systems and their subsystems utilizing a thorough understanding of available technology, tools and existing designs.
• Worked with business unit and IT management and staff on all phases of application programming and design.
• Worked closely with client and IT management and staff to identify application development solutions, new or modified programs, reuse of existing code.
• Coded new or modify programs, reuse existing code via program development software alternatives and/or integrates purchased solutions.
• Worked closely with Business Analyst gathering specifications and requirements, requirements mapping from stakeholders.
• Documented, tested, implemented and provided on-going support for the enterprise's applications.
• Lead design, development, and implementation of custom BI solutions utilizing SSIS and SSRS applications in support of enterprise’s Clinical Management System.
• Health Risk Assessment Monthly Mailing
• Health Risk Assessment Load
• Member Care Plan Generation
• CCMS Refresh Processes

Senior Application Programmer Analyst/Business Intelligence Developer

Confidential, Memphis, Tennessee

Responsibilities:

• Refined and upgraded Pearson Student Management System database and GUI according district needs for custom reporting and usability tools.
• Dramatically reduced time required to track student secondary enrollment, grades and attendance by developing new data capture system integrated with Pearson.
• Enhanced and sharpened truancy monitoring processes by developing custom software enabling district staff to identify and address problem truancy.
• Automated data transfer and integration between internal student data management system and vendor databases, dramatically improving processes.
• Coordinated with front-end partners to implement business logic governing custom reports and extracting tools, improving data analysis and organization.
• Enhanced teacher evaluation procedures by integrating HRS systems tracking teacher s, endorsement, and licensure, allowing easy identification of qualified teachers.
• Legacy mainframe COBOL Programmer/Analyst role resolving Production Support tickets analyzing COBOL CICS/BATCH code with DB2 processing.