Business Analyst Data
Resume:
Garrett L. Johnson II
Havertown, PA 19083
Mobile: 678-***-****
*******.*******@****.***
SUMMARY OF QUALIFICATIONS
Highly motivated and dedicated professional with a Twenty-Five-year track record of applying technology to meet business needs
25 Years of working with every version of SQL Server from 6.5 to 2014 as a Developer, a DBA or both
Experience with DTS, SSIS and SSRS
A trained business analyst with the ability to see how small factors affect the larger picture
In-depth understanding of all stages of software development life cycle (SDLC)
An individual that understands the team concept and functions in the role necessary to complete the mission.
Familiar with .NET Framework
PROFESSIONAL EXPERIENCE
May 2015-
Present DATA ANALYST, Amtrak (Philadelphia, PA)
Responsible for updating and maintaining a suite of MS SQL Server 2014 databases and Oracle Spatial databases. Validated, imported and export data as required. Insured data integrity and consistency. Exported data into required formats and create custom reports. Wrote SQL scripts, stored procedures and DTS packages to automate database maintenance tasks.
Oct 2014-
March 2015 BUSINESS ANALYST, Independence BCBS (Contract: Intepros, Philadelphia, PA)
Played a major role in the analysis of the Risk Management Departments data used for
Governmental compliance with The Affordable Care Act. Using a combination of SQL Server, SSIS and Excel several reports were created to identify sources for federal reimbursement and internal savings.
May 2014-
September 2014 PROGRAMMER, USciences (Contract: Robert Half Tech., Philadelphia, PA)
Contributed to the institution by creating and repairing reports using SSRS. Also responsible for SSIS tasks, data loads, transfers and automation with SSIS. Enhanced existing stored procedures in a SQL Server 2008 environment.
February 2014-
May 2014 PROGRAMMER, Grayhair Software (Contract: Robert Half Tech., Mt Laurel, NJ)
Supervised and provided code reviews and enhancements to a group of 3 developers using SQL Server 2000 and 2008, SSIS and SSRS. Designed and developed complex SQL queries and appropriate database code such as stored procedures, triggers, functions to support complex business processes. Developed and delivered extensible/sustainable/quality database solutions based on defined business needs. Developed ad-hoc scripts. Reviewed and updated stored procedures for optimal performance. Identified and corrected performance bottlenecks. Recommended changes to the relational data model to solve performance issues with SQL code. Participated in the resolution of production data issues.
September 2013-
December 2013 PROGRAMMER, Davita (Contract: Brooksource, Malvern, PA)
Assisted with the conversion of Existing Crystal and Access based reports from
Remedy to ServiceNow using SQL Server 2008, Toad and Excel and VBA
October 2011-
August 2013 PROGRAMMER, Heffler, Radetich & Saitta (Philadelphia, PA)
Responsible for implementing new systems within the firm specifically Alfresco and Kofax Scanning. Also responsible for large data manipulations using SSIS, generating reports with SSRS, Web Enhancements with HTML and XML and any DBA related tasks such as backup/recovery routines and database maintenance.
June 2011-
October 2011 SQL SERVER DEVELOPER, Toll Bros. (Contract: The Judge Group, Horsham, PA)
Hired to provide the database resources needed for a web based tool that was being transitioned from SQL Server 2000 to SQL 2008. Tasks included requirements gathering, creating the data model and data structures, data import routines, tables, stored procedures and views using T-SQL and implementing business rules. Also responsible for moving over 100 DTS packages into SSIS 2008.
November 2010-
June 2011 SQL SERVER DEVELOPER, ECG/Contracted through Matrix, (Atlanta, GA)
Worked with project manager to conceptualize, design, implement and automate an existing Excel/VBA based reported process used to forecast and purchasing fuel commodity, operate plants and move related data into SQL Server 2008 for future reporting. This was a full life cycle task which included data modeling, physical and logical design based on project scope, software installation, creation of both the development and production environments, deployment of data into the production environment, creation and application of appropriate permissions and security, Table, view, user-defined function, index and stored procedure development. Coded with T-SQL. Imported and exported files to and from csv and excel. Created and updated SSIS Packages and SSRS Reports and implemented scheduled jobs. Provided a written recommendation to the CEO and management regarded future IT related hardware and software purchases in response to a contract offered by an existed provider; potentially saved the company over 100K per year. Created a technical overview of the application including specifications for future review
April 2010 -
Sept 2010 SQL SERVER DEVELOPER, UPS/Contracted through Synergis, (Roswell, GA)
Review develop and design data models, in conjunction with the application development team. Met with the project manager and department leadership to translate requirements into physical database structures that integrate with existing or proposed database structures using SSIS and SSRS. Work with databases to optimize database performance and resource usage. Managed database integration issues including migration between disparate databases, integration, maintenance/conversion, capacity planning issues, and new applications. Perform database performance monitoring and implements efficiency improvements including capacity planning. Create and maintain test database environment for applications section, including the creation of necessary libraries and procedures and quality audit and promotion of databases from development or test to production. Assist development staff with the application design to facilitate effective use of database languages, methodologies and established standards. Work with development staff in approving database changes. Managed access paths to optimize availability of the databases. Assist management in creating requirements definition and implementation for high availability and disaster recovery. Recommends the procedures necessary to save, retrieve, and recover databases from hardware and software failures within established procedures.
May 2007 -
Dec 2009 SR. SQL SERVER DEVELOPER, Results Technology, (Kennesaw, GA)
Provided leadership and direction to a team of 6 SQL Developers in Hyderabad, India. Met with the client and project manager twice weekly to assess strategy, identify current issues and plan future enhancements. Reviewed, implemented and improved of business logic and rules. Introduced new quality control methods and created documentation for team. Developed change management tools and monitoring systems. Designed, tested, debugged and enhanced code. Created reports with Transact-SQL, Aspose Cells and C# in a multi-server environment. Tasked with creating all relevant data objects such as tables, views, stored procedures, triggers and User Defined Functions. Responsible for data transfers (imports and exports) to and from the client with SSIS. Additional tasks included stored procedure optimization, data mappings, data management, client deliverables and worked on the conversion of all reports from a Visual Basic 6 to C#. Insured compliance with business practices.
September 2006-
April 2007 DEVELOPER, JP Morgan Chase/Contracted through Aetea, (Kennesaw, GA)
Hired to automate existing processes in the credit card services department. Provided VB solutions to convert core reporting to a format that could be used by the newly acquired local division. Identified and resolved numerous data abnormalities within the existing reporting structure. Developed reporting solutions to more effectively forecast expected losses within the division. Created ad-hoc SQL queries and reports. Used Visual Basic for Applications in existing applications to improve efficiency within the division.
November 2005-
September 2006 DEVELOPER, Guidant/Contracted through Sapphire, (Atlanta, GA)
Created an Access/SQL based reporting application to reduce financial loss by penalizing sales representatives that consistently offer products to customers below the established price floor. This tool also automatically sends this report to the applicable management hierarchy. Developed an Access based tool using Visual Basic for Applications to send pricing related data to members of the management hierarchy and reduced a process that previously took two hours every week to 30 seconds.
October 2004-
November 2007 DEVELOPER, BAPCO/Contracted through Sapphire, (Atlanta, GA)
Individually responsible for providing enhancements to an existing application with SQL and Visual Basic. Created over 30 new reports based on requirements provided, management specifications and suggestions based on observations. Created a reporting solution that helped identify an untapped revenue resource. Resolved issues with existing systems. Developed new Visual Basic for Application based process for data migration.
June 2005-
August 2005 DEVELOPER, Quintiles Laboratories/Contracted through Sapphire, (Atlanta, GA)
Responsible for enhancing an existing Excel based Service Proposal System used for with Visual Basic for Applications. Implemented strategies to reduce data input errors, security and improve usability through code. Created Pivot Tables for Data analysis. Oversaw system and unit testing. Used Visual Basic to verify data integrity within spreadsheet cells, populate cells, copy, paste and delete cells based on certain conditions and user notifications. Assisted in negotiating the contract with the client.
October 2004-
February 2005 DEVELOPER, ING/Contracted through Comsys, (Atlanta, GA)
Responsible for developing a new project management system to assist leads with resource allocation using SQL and Visual Basic. Oversaw system and unit testing.
January 2003-
September 2004 BUSINESS ANALYST, SunTrust Bank, (Atlanta, GA)
Served as the primary source for data collection, data analysis, reporting and project support for the HRIS, Payroll and the Legal divisions. Primarily MS Access XP and SQL, PeopleSoft 8 Query and Crystal Reports were the primary tools used. Created Excel pivot tables and cross tables for reporting. Used Crystal Reports to display financial and HR data reflected in PeopleSoft Query. Used Crystal Reports to display Kronos Data. Other responsibilities included maintenance of PeopleSoft 8 tables and administering the Kronos Time Keeper Central database for Hourly employees in Georgia, Tennessee, Florida and Virginia. Selected Milestones include:
Providing leadership and direction for the United Way and United way Good Government Annual Campaigns
Supervised the EEOC and VETS 100 Projects to ensure that the company complied with government regulations
Created a MS Access/VB based solution that reduced a payroll process from 6 hours to 2 minutes
Created an application to track, monitor and report on Legal HR issues
January 2002-
April 2002 VISUAL BASIC DEVELOPER, SunTrust Bank/Contracted through MDI, (Atlanta, GA)
Responsible for completing and extending the functionality of Microsoft Access application used for financial goal setting. Visual Basic 6.0, SQL and Database Replication were the primary tools employed. Accomplishments include:
Individually training over 20 end users on how to best utilize the new enhancements
Assisted the director of human resources with creating a new program for newly acquired and merged branches
September 2001-
January 2002 QUALITY ASSURANCE, Kaiser Permanente/Contracted through MDI, (Atlanta, GA)
Developed, tested and implemented an Access 7.0 based system to verify the accuracy of a newly acquired mainframe system during transition. This goal was met by creating and using SQL and cross tab queries for data analysis, gathering and analyzing business requirements, interpreting data to ensure that the expected technical specification specifications were being achieved.
June 2001-
September 2001 SQL SERVER CONSULTANT, Fresh Solutions/Contracted through Staffing Resources, (Atlanta, GA)
Responsible for providing server maintenance and tuning with SQL Server 2000 including developing routines for back-up and recovery, automating data transfers with DTS, created triggers and jobs to notify users of events, data cleansing and data scrubbing. Additional contributions included:
Generating reports with Crystal Reports to display SQL Server data
Provided ad-hoc Crystal Reporting related solutions
Developed a new Access 2000 based front-end tool to interact with SQL Server that replaced a previously contracted service
Automated several activities with Visual Basic 6.0
May 2000-
May 2001 SQL SERVER PRE-PRODUCTION DBA, Firstdoor.com, (Atlanta, GA)
Insured testing of all new website functionality prior to having those changes applied to the production environment. Responsible for all software installations and configurations that occurred on the test servers. Transferred data from a variety of sources (SQL Server, Access, Excel, text, etc.) between the servers in the pre-production environment using DTS Packages. Performed and developed routines for back-up and recovery with SQL Server 7.0 and SQL Server 2000.Created and tested plan for an upgrade from SQL Server 7.0 to SQL Server 2000. Assigned and managed permissions and security. Created, altered and executed stored procedures, tables, views, constraints, triggers and other database objects. Provided capacity planning and forecasting. Generated reports with the web publishing utility and Crystal Reports. Created alerts to notify Senior DBA of Server errors. Developed and implemented a server maintenance plan for all servers. Generated Schema for all servers. Monitored database sizing. Tested new software and made purchase recommendations. Developed data models using Visio. Provided server and application tuning. Resolved issues between IIS and SQL Server. Implemented data warehouse testing. Created library of template scripts to be stored in MS SourceSafe.
March 2000-
April 2000 DEVELOPER, Starwood Resorts /Contracted through WPPS, (Atlanta, GA)
Created, tested and maintained a MS Access 2000 database to track e-mail addresses. Generated reports, developed tables, SQL queries and forms with MS Access 97
February 2000 DEVELOPER, Don Swann /Contracted through WPPS, (Atlanta, GA)
Added additional functionality to existing systems by using SQL Queries, Macros and VB modules
March 1999-
January 2000 DEVELOPER, Prudential/Aetna US Healthcare/Contracted through MDI, (Atlanta, GA)
Developed and successfully implemented a strategy to integrate the Aetna and Prudential Pharmacy Networks utilizing MS Access 97, MS Access 2000, Paradox, SQL and VB.
Additional functionality was added to existing systems by improving interfaces and insuring data integrity. Created a new database with MS Access 2000 and used forms to generate reports based on queries. Scrubbed data from heterogeneous sources including Paradox and Excel
November 1994-
March 1999 SQL SERVER DBA/SYSTEMS ANALYST, The Gallup Organization, (Atlanta, GA)
Responsible for the full life cycle (creation, development, testing and administration with MS Access 3.0, 95, 97 and SQL Server 6.0 and 6.5) for an HR/Financial Data repository. Created Data Model and gathered requirements. Provided HR/Financial reporting with Access reporting tools. Created and maintained of all of tables, forms (interfaces), queries, macros, reports, VB modules, stored procedures and triggers. Used Visual Basic for Applications to enhance functionality. Collected and integrated data from various sources, including text files and Excel, into the application. Used SAS data to create Cross Tab Queries and pivot tables for analysis. Designed, coded, tested debugged and documented system. Implemented many procedures to automate user tasks. Applications training for groups of end users ranging in size from 6-200 individuals per session. Resolved problems and was responsible for troubleshooting technical issues. Provided project leadership and guidance to 20 staff members, assistance to 60 managers and data for 2000 employees. Milestones include:
Setting two company wide records for productivity and efficiency
Increased efficiency of the division 30% nationwide in the first six months of use
Chairman of the Gallup Atlanta Technology and Development Team
Expanded cabling for physical Ethernet network
Installed software, hardware and supported 100 Wise nodes for interviewing
Provided technical and hardware support to 150 users
January 1991-
October 1993 ASSISTANT ACCOUNTANT, John W. Yopp Publications, (Atlanta, GA)
Assisted with balancing the ledger
Created financial statements and reports for the CPA using Peachtree Accounting Software and MS Money
Resolved Issues with accounts payable and accounts receivable
Created spreadsheets for financial analysis with MS Excel
Responsible for audits of the Bookkeeper
Responsible for accounts receivable
Used Lotus 1-2-3 and Dbase to manage the subscriptions databases for three periodicals
Drafted letters with MS Word
EDUCATION: BS in Applied Physics, MOREHOUSE COLLEGE
Completed Microsoft Approved Course: 832-System Administrator for
Microsoft SQL Server 7.0
Completed PeopleSoft Approved Course: 400-PeopleSoft I for PeopleSoft 8.0
REFERENCES: Provided Upon Request
Contact this candidate