GREGORY LONG

Business Intelligence Developer

Memphis, TN 38141

adevqi@r.postjobfree.com

901-***-****

Willing to relocate to: Nashville, TN

Mainframe Programmer

ECS Federal LLC - Memphis, TN

August 2018 to May 2020

As a contractor, developed, enhanced, and maintained all legacy mainframe systems and applications that support United States Postal Service Change Of Address processes. Also as shared resource, developed Oracle Database back-end stored procedures and functions to support web-based Internet Change Of Address Extended Forwarding application. Senior Business Intelligence Analyst

FedEx Express - Memphis, TN

May 2015 to May 2018

I provided business intelligence support for Global Planning and Engineering various systems servicing the Express 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 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

TEK Systems - Nashville, TN

June 2014 to February 2015

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.

WORK EXPERIENCE

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 Memphis City Schools - Memphis, TN

August 1999 to March 2014

Lead development, implementation, and management of custom databases and reporting tools for school district of over 115,000 students and 16,000 teachers and administrative staff. Construct custom Business Intelligence database reporting and extraction tools as well as data loading and integration applications utilizing SSIS, SSRS and Crystal Reports. Design, test, and implement new data management systems; customize vendor student management database according to district needs. Mentored peers in system development life cycle (SLDC) and best practices of software development.

• 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 certifications, 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.

Bachelor of Arts in Computer Science in Computer Science University of Mississippi - Oxford, MS

EDUCATION

Business Intelligence (10+ years)

CICS (10+ years)

database (10+ years)

Microsoft SSRS. (10+ years)

SSRS. (10+ years)

BI

SSRS

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 2008R2/2008/2012/2017 T-SQL • Data Transformation Services (DTS) • SQL Server Integration Services (SSIS) SQL Server Reporting Services (SSRS) • 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 SKILLS

•

•

•

•

•

•

•

ADDITIONAL INFORMATION

Contact this candidate