SUMMARY:

• MSBI Senior Analyst and Developer with 8 years of Microsoft Business Intelligence development experience and 15+ years overall software development experience.
• Have successfully designed and implemented new systems and applications using Business Intelligence solutions, have reengineered and converted older legacy systems to new Business Intelligence systems and applications, and have crafted custom applications and solutions with MSBI for new or changing business requirements or system requirements.
• Experienced in all phases of the software development life cycle.Have comprehensive experience utilizing T - SQL for ETL processes and complex transformation logic.
• Use SQL Server Management Studio (SSMS) and Toad extensively to develop complicated T-SQL scripts, Stored Procedures, DDL, and DML.
• Have successfully implemented SQL Server Integration Services (SSIS) packages and jobs for nightly data loads and ETL processes.
• Use SQL Server Reporting Services (SSRS) and Microsoft Report Builder to produce reports for Report Server Web services, and reports that are deployed to Sharepoint.

SKILLS:

• Project experience working on company mergers.
• Project experience on system rewrites and conversions.
• Project experience retiring older legacy systems.
• Extensive experience interfacing with the client or end user at all levels.
• Extensive experience collaborating with DBA’s and BA’s and PM’s throughout the development process.
• Familiar with Data Warehouse concepts and methodologies
• Excel at learning and implementing new technology.
• Work effectively in an Agile environment.

TECHNOLOGIES USED:

Microsoft Visual Studio 2012, 2010, 2008

Microsoft SQL Server Data Tools for Visual Studio 2012, 2010

Microsoft SQL Server Management Studio 2014, 2012, 2008, 2005

Transact-SQL (T-SQL), SQL, DDL, DML

MS Business Intelligence Development Studio (BIDS) 2008

Microsoft SQL Server Integration Services (SSIS) 2010, 2008

Oracle, Toad, TortoiseSVN / Subversion, Jenkins, Autosys

SSIS Projects, SSIS Packages, SQL Agent Jobs

Microsoft SQL Server Reporting Services (SSRS) 2008

Microsoft Report Builder, Report Server, roles and profiles

CA:Gen / Allfusion:Gen / Advantage:Gen / Cool:Gen

SQL, DB2, Visual Age for Java, Visual Age for Smalltalk

Windows, MS Office Suite, Webex, Jira, Agile

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Microsoft Business Intelligence Developer / Analyst

Responsibilities:

• Develop applications for Confidential GWIM CRT project using Microsoft Visual Studio 2012 / SQL Server Data Tools, SQL Server Integration Services (SSIS), Toad for Data Analysts, and Microsoft SQL Server Management Studio (SSMS) 2012 in an Agile environment.
• Develop complex DDL and DML for creating and modifying Stored Procedures and database objects.
• Develop Stored Procedures and dynamic SQL for loading and extracting data for exception criteria to be presented in Microstrategy.
• Develop SSIS Packages, Autosys Jobs, and ETL to process US Trust exception data.
• Develop T-SQL scripts used for validating and verifying data loads.

Environment: Toad for Data Analysts 3.0, T-SQL, MS SQL Server 2012, SSIS Packages, TortoiseSVN, Jenkins, Autosys, ETL, Stored Procedures, DDL, DML

Confidential, Suwanee, GA

Microsoft Business Intelligence Developer / Analyst

Responsibilities:

• Design, develop, implement, and maintain applications for the Assessment Applications group using Microsoft SQL Server Management Studio (SSMS), T-SQL, Microsoft Visual Studio 2008 / Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS).
• Developed complex T-SQL scripts for transformation logic for student data loads.
• Developed SSIS Packages, SQL Agent Jobs, and ETL to process local, county, state, and National data and student demographic data.
• Developed reports for the Go Gwinnett portal with SSRS and Microsoft Report Builder.
• Developed multiple Survey systems that produced Usage and Effectiveness statistics reports and analytics reports that scored the data. (all using T-SQL, SSMS, SSIS, and SSRS).
• Performed testing and data validation processes using SSMS and T-SQL.
• Developed T-SQL scripts used for creating key forms for answer sheets and scoring algorithms based on test subjects and strand levels for scoring Local and County tests and exams.
• Converted old Legacy DB2 data load applications to SQL Server ETL processes utilizing SSIS packages and SQL Agent jobs
• Created ACCESS applications for the GCPS Transportation department that processed route and/or rider changes for Special Education students,
• Created ACCESS applications for the GCPS Transportation department that were used for bus route drop-off / pick-up location changes.
• Set up servers and Oracle databases (Oracle PL/SQL) for web based routing application.

Environment: T-SQL, SSMS, SSIS Packages, SSRS reports, SQL Server Agent Jobs, ETL, VB .Net, Stored Procedures, Access, Oracle

Confidential, Raleigh, NC

Analyst / Developer

Responsibilities:

• Developed and maintained all Vocational Rehabilitation systems written in Visual Age for Java.
• Provided mentoring for Junior team members
• Resolved program and system changes and modifications initiated by the client and business/admin offices.
• Worked with client / end user on requests through to completion and user signoff for the different systems.

Environment: Visual Age for Java, DB2

Confidential, Research Triangle Park, NC

Analyst / Developer

Responsibilities:

• Developed and maintained online CSP DB2 applications that were used for inventory allocation and shipment tracking data for the CSS Distribution and Order Management division.
• Provided maintenance and support of batch CSP DB2 programs used to track ordering, inventory allocation, distribution and shipping of promo, sample, and trade products.
• Developed all online Child Welfare information systems written in CA:Gen.
• Consolidated a Child Placement and Payment legacy DB2 application, a Central Registry legacy DB2 application, and a Foster Care Licensing legacy DB2 application all into a Child Welfare information system developed.
• Provided analysis and support for business rules and decisions including verification of data and edits. Provided support for batch DB2 applications as needed.
• Modified batch inventory system to meet the needs of company merger
• Modified job streams, programs, files, and tables to in corporate new warehouse processing.
• Converted existing code to COBOL/MVS standards.

Environment: COBOL, CICS, DB2

Confidential, Raleigh, NC

Programmer Analyst

Responsibilities:

• Developed and maintained online applications for the Confidential .
• Developed the “Dead Beat Dad” project for the state of NC.
• Developed online application that provided a link between the DOT applications and the Administrative Office of the Courts (AOC) applications to allow for the tracking of delinquent child support activity on the DOT side.
• Provided maintenance and enhancements for changing business rules and current needs.

Environment: CICS, COBOL, DB2, QMF, SPUFI

Confidential, Winston Salem, NC

System Analyst

Responsibilities:

• Provided analysis and development of Accounts Acquisition Lead Management project.
• Designed and developed DB2 relational database on host side of Client-Server system.
• Defined database, tables, attributes and relationships.
• Generated DDL using the BACHMAN data modeling tool.

Environment: BACHMAN, DB2, QMF, SPUFI

Confidential, Charlotte, NC

System Analyst

Responsibilities:

• Provided analysis and development on the project to consolidate the 4 different reconciliation systems into 1 system,
• Improved nightly run-time performance by implementing SMS modifications to all job streams., and improving system efficiency,
• Provided support and analysis for client or end-user in Charlotte, and client end-user in Jacksonville, Fl.

Environment: CICS and batch COBOL DB2