Resume

Sign in

Data Sql Server

Location:
Nashville, Tennessee, United States
Posted:
March 21, 2019

Contact this candidate

Resume:

GREGORY LONG

**** ******** ***** · Memphis, Tennessee 38141

901-***-**** · 901-***-**** · ac8u06@r.postjobfree.com

BUSINESS INTELLIGENCE DEVELOPER

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 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

PROFESSIONAL EXPERIENCE

Business Intelligence Developer:

Robert Half Technology, Memphis, Tennessee; West Clinic July 2018 – September 2018

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:

FedEx Express, Memphis, Tennessee · May 2015 - 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, Tennessee; Cigna Health Spring June 2014 – 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.

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, Tennessee · August 1999- 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.

EDUCATION

Bachelor of Arts in Computer Science: University of Mississippi, Oxford, Mississippi

PROFESSIONAL DEVELOPMENT

Microsoft SQL Server 2008 / 2008R2: SSIS, SSRS · Microsoft SQL Server 2012: SSIS, SSRS, SSAS



Contact this candidate