SUMMARY:

• I am an Energetic - Motivated - Positive - Friendly and Enthusiastic Person
• Passionate about my work and have solid goals for self-improvement, development and bringing value and dedication to every organization I am partnered with.
• With a proven track record of identifying complex business and data analytics processes by being creative, innovative and simplifying them for efficiency.
• Ability to learn new technologies quickly and adapt existing techniques and practices to new systems to further increase ROI.
• Created, copied and backed up databases. Worked with Agile and Waterfall methodologies.
• Along with extensive data analytics.
• MS SQL Database Developer, Experience with Snowflake and Star Schemas, SQL 2005 - 2014, SSRS, ETL (SSIS), Transact SQL TSQL, SQL Reporting Services (SSRS), Writing Complex SQL queries and stored procedures. Reporting Specialist with 10 + years of current experience using MS Access versions 2000 - 2010, Excel, creating dashboards and function reports with development of advanced Macros using VBA Code and Visual Basic (Limited .NET) JD Edwards One World Oracle Reports Development.

TECHNICAL SUMMARY:

Database: SQL Server 2005-2014,, MS Visual Studio 2012 and SQL Server 2012 data tools, MS Access 2000, 2003, 2007 and current, RDMS, Oracle, Data Modeling, Data Extraction, SQL reports development and data analyses with expert-level development and analysis.

Reporting: Oracle, SQL Server 2014, MS Development Studio 2014, MS Access 2000, 2003, 2007, 2010. SQL Reporting Services SSRS, SSIS Excel, Micro Strategy Reports and Application Development, Crystal Reports Design and Development, and maintenance, PowerPoint, Design Documentation, Process Manuals, Visio, Requirements Gathering and Best Practices. Tableau expert reports developer.

Programming/Development: SQL Management Studio up to 2014, MS Access 2007 to 2010, MS Visual Basic 6.0, VBA, SQL Server 2005-2014, ADO.Net, (some) VB.Net, JavaScript, Visual Basic Script, EDI and XML (SunTrust Bank)

Systems: Windows NT, Windows 2000, Windows XP Professional, Windows Vista, Windows 7, MS Office Suite.

Professional: Process Innovation, Design Analysis, Business Analysis, Statistical Analysis, Data Analysis and Report Writing and Training, Negotiation, Project Planning, Requirements Gathering (BA), and Business Communications with high level managers and executives.

KEY SKILLS:

Data Analysis

Statistical Analysis

SQL Server (SSMS) 2005 - 2014

MS Access

MS Excel / Word / Office

Reporting and Data Analysis

Project Coordinator

MS Access Database Development

Crystal Reports

Developing Complex Macros VBA

Oracle

MS Visual Studio (Including SQL 2012 currently)

SSIS Packages

Tableau

Agile and Waterfall methodologies

Snowflake Schemas and Star Schema

Data analytics and Reporting

EXPERIENCE:

Confidential, Tampa, FL

SQLDeveloper, SSIS Developer, SSRS Reports Developer/Analyst

Responsibilities:

• Developing complex SQL queries and stored procedures using TSQL and ETL SQL 2014.
• Worked with large volumes of encounter data on a daily basis from healthcare providers and clients. This data had to be scrubbed,analyzed and loaded into our database and medical charts and images were loaded to be coded.
• Worked with Snowflake Schemas and Star Schema
• Worked ensuring all medical coding was in compliance with government regulations.
• Developed new reports, created stored procedures, SSIS packages.
• Created database back and restore processes including documentation.
• Performed daily data loads, images for healthcare providers.
• Created process to backup and restore production databases daily with daily jobs and email notifications streamlining the backup processes.
• Created documentation of all processes andprocedures.
• SQL Developer Jr. Database Administrator Data Analyst. Working with large volumes of medical data.
• Created backup and restore processes.
• Staged, scrubbed and loaded medical data.

Confidential, Tampa, FL

SQLDeveloper, SSIS Developer, SSRS Reports Developer/Analyst

Responsibilities:

• TSQL and ETL SQL 2014.
• Enhanced existing SSIS packages, designed new SSIS packages.
• Created documentation and procedures for development using Agile methodologies.
• Created new test database platforms.
• Backed up and restored databases.
• Automated error reports and loaded medical data for health-care providers.
• Worked with large volumes of encounter data on a daily basis and also loaded patient information for specific vendors.
• Worked with Snowflake Schemas.

Confidential, Tampa, FL

Senior SQLDeveloper, SSIS Developer, BI Analyst,SSRS Reports Developer/Anayst

Responsibilities:

• Developing complex SQL queries using TSQL and ETL SQL 2014.
• Developed new reports, created stored procedures, SSIS packages.
• Processed Encounters on a daily basis for the state of Florida as a Medicaid provider.
• Developed and automated the Encounters process using SQL and SSIS and significantly reduced PNV errors by 98% in less than 3 months. On-going project and new innovative development. Working closely with the state of Florida and conducting weekly technical meeting to provide statistics, data analytics and improvements for the medical encounters processes.
• Worked with large volumes of encounter data on a daily basis from healthcare providers and clients and reported on it.
• Provided error free data which was provided weekly to the state of Florida for Medicare claims processing.
• Worked with Snowflake Schemas.
• Provided data analytics for medical claims data and reporting of deliverables.

Confidential, Tampa, FL

Application Systems Analyst, Reports Writer and Developer, Production Support and SQL Developer and Data Analyst

Responsibilities:

• Writing and modifying complex SQL queries using transact SQL, TSQL and ETL. Developed new reports, modified existing reports, modified, maintained stored procedures analyzed stored procedures.
• Worked closely with the web development and SQL interface teams with development of interfaces.
• Maintained database, created documentation of all processes and processed monthly reports.
• Analyzed code and back engineered existing reports and recreated them to meet current specification successfully.
• Provided production support, using SSIS, SQL 2012 development and data analysis on a daily basis.
• Developed processes and documentation while conducting on-going meetings and support. Maintaining and processing monthly invoice process supporting strong relationships with all business units.
• Worked closely with senior level management and the business analyst teams. Created ADHOC reports and new development enhancements. Tested development and wrote technical requirements.
• Worked with Snowflake Schemas.
• Provided data analytics for medical claims data and reporting of deliverables.
• Provided data analytics for benefit administration data and reporting of deliverables.

Confidential, Pittsburgh, PA

Senior Level JD Edwards Programmer/Oracle Developer Reports Developer / Oracle and SQL Reports Developer/Analyst

Responsibilities:

• Developed new reports and enhancements using JDE Edwards version 9.0.
• Created advanced reports and also enhanced existing reports.
• Worked closely with the Allegheny Controller’s Office implementing high-level reports and systems saving the County and City several million dollars in the yearly budgets causing a surplus eliminating budget deficits.
• Developed in the AS400 JD Edwards 9.0 environment.
• Enhanced and developed new reports modified existing reports and developed interfaces and modified existing ones.
• Created reports and interfaces in JD Edwards analyzed code and back engineered existing reports and recreated them to meet current specification successfully.
• Worked closely with senior level county officials and analyst. Created ADHOC reports and new development enhancements. Tested development and wrote technical requirements. Worked closely with HR, Accountants and Analysts.

Confidential, Carrollton, TX

SQL 2008 MS Access Data and Reporting Analyst / Database Programmer DBA

Responsibilities:

• Provided daily sales and inventory reporting statistics on real estate inventory, trends and sales from some of the top mortgage companies.
• Presented the benefits of upgrading to SSRS to high-level upper management and provided demonstrations of it’s reporting capabilities.
• Designed and developed SQL reports using SQL Server 2008, MS Access 2007-2010, Developed Complex Macros and Queries and Tableau.
• Provided necessary documentation and training to end-users during development, testing and deployment.
• Monitored and developed reporting procedures and project management plans.
• Worked closely with SQL server in a assisted DBA role maintaining multiple Access databases connected to a SQL Server back-end database.
• Extracted and analyzed data from internal databases/excel spreadsheet to make informed business decisions and actions.
• Worked closely with colleagues to mine internal data sources for unprecedented insights, and presented findings to all levels of VRM leadership on a frequent basis.
• Generated standard and ad hoc reports on a regular basis.
• Became the group’s internal data warehouse expert by coordinating the migration or SQL data for reporting purposes.
• Translate business questions into precise queries.
• Questioned and validated data.
• Developed critical reports to help determine the level of inventory and helped to significantly reduce errors.

Confidential, Atlanta, GA

SQL MS Access and ASP Reports Writer / Database Programmer DBA/LMS Administrator/Analyst

Responsibilities:

• Designed and developed SQL reports using Pathlore SQL Server MS Access and Crystal Reports.
• Attended weekly status conference calls and provided updates to development of existing and new projects.
• Provided necessary documentation and training to end-users during development, testing and deployment. MS Visual Basic 6.0, VBA.
• Monitored and developed reporting procedures and project management plans.
• Assisted in migration from old LMS to Future State LMS (Learning Management System).
• Worked in a DBA role maintaining multiple Access databases connected to a SQL Server back-end database.
• Developed ASP webpages and modified data using FTP.
• Worked on site and remote.

Confidential - Stone Mountain, GA

Access Developer / Business Data Analyst

Responsibilities:

• Used MS Access, MS Excel and SQL Server for the reporting requirements.
• Performed complex Statistical Analysis data extracts using MS Access/SQL, VBA and SYSPRO ERP System.
• Gathered requirements, reviewed and analyzed data, and performed Quality Assurance of reports. Created reporting tools for customer service department, warehouse and shipping processes which eliminated overall 95% of late shipment issues, improving customer confidence and satisfaction. Responsible for training the staff on the use of Forecast Pro. Created all documentation for the system.
• Responsible for developing several reporting tools created in MS Access and ADHOC reports.
• Worked as the SQL Server DBA and closely with an outside consulting firm to make enhancements to the database and improve performance. Also worked with DTS packages.
• Data reporting and analysis of financial information for the accounting and finance departments.

Confidential, Alpharetta, GA

Access Developer / Data Analyst, Procurement

Responsibilities:

• Used MS Access, MS Excel and SQL for forecast planning procurement database.
• Performed complex Statistical Analysis data extracts analytics using MS Access/SQL, VBA and AS 400/DB2 JD Edwards, Purchasing Systems, Data Warehouse and Internal Resources. Gathered requirements, reviewed and analyzed data. Performed quality assurance of all reports. Reorganized and revamped team to produce an overall 90% process improvement through various means including motivation, instruction on various analytical methodologies (Reports Analysis, Data, Statistical, Business, Design), project ownership, documentation, and service-level geared toward adding value to the business community. Created databases and also worked as the sole DBA for each project.
• Conducted data analysis and initial business analysis with a team of Purchasing Analysts and Sales Managers and then completed a re-design of the JD Edwards sales information, which resulted in a savings of $45 million in inventory costs while increasing logistic support to affiliate stores. Developed an automated reporting system, which enables the company to receive, on average, over $150,000.00 in rebates from vendors monthly. Previously the reporting system was done manually by management and would take several hours. The new system generates the report in approximately ten minutes.
• Responsible for several reporting tools created in MS Access
• Lead Coordinator, Administrator and Trainer for an MS Access database project that is heavily used by Analyst and Buyers to make million dollar decisions daily.
• Contributed to and maintained Backend Rebate/Contra-Rebate Reports throughout 2004. Saved the company a net total of claims for the year in excess of $6,188,908.48.
• Received 3 merit raises and 1 promotion.

Confidential, Atlanta GA

Database Programmer/Analyst

Responsibilities:

• Created requirements documentation, wrote test plans, test cases, and performed QA testing for large scale healthcare reform project.
• Acted as a liaison between the application developers and the other system developers coordinated and conducted meetings and conference calls.
• Designed and developed SQL ADHO reports using SQL Navigator, SQL Developer, Business Objects, MS Access 2007-2010 and Crystal Reports.
• Provided data analysis and customized reports for the business. Created custom documentation for QA Testing,
• Devlopment and Application Enhancement Lifecycle.
• Conducted meetings and requirements gathering with the business units and established on-going relationships.
• Provided continuous support to the Workers Comp Business Unit and all associated groups.

Confidential

SQL ASP Reports Writer / Database Programmer/Analyst

Responsibilities:

• Designed and developed SQL reports using SQL Server 2005, ASP, transferred files and data using FTP and worked within the SQL database in a DBA role assisting the IT director.Modified and created stored procedures. Provided on-site and off-site testing, training, and documentation.
• Met with President and Senior Level Management regarding all aspects of the project during end-user testing, trouble-shooting and release to production environment.
• Worked 100% remotely off-site. Attended weekly status conference calls and provided updates to development of existing and new projects. Advised management on development strategies and efficient ways to streamline processes by system optimizations. Provided necessary documentation and training to end-users during development, testing and deployment. Worked on site and remote.
• Developed and created IT Cost Baseline Financial Database report tool from the ground up using Microsoft Access, Excel, VBA and SQL.
• Designed and developed reports for the purpose of tracking IT Spend from almost 100 separate business units reporting Financial Data for 2007 and 2008. Created Project Plan, Participated in Design and Enhancement Meetings. Provided on-site and off-site testing, training, and documentation. Met with Senior Level Management regarding all aspects of the project during end-user testing, trouble-shooting and release to production environment. In this role I worked as the DBA for an Access database that I built from the ground up and documented the code and SQL. Provided necessary documentation and training to end-users during development, testing and deployment.
• Performed development enhancements to MRPS Volume reporting tool, which was used to forecast Hot or Cold beverages. Report writing using Microsoft Access, Excel, VBA, SQL and Oracle. Worked as a DBA for a very large Access database that was connected to an Oracle back-end database.
• Created procedures to convert bottler data to the correct calendar from Gregorian allowing users to input forecasts and performing the necessary calculations using procedures and subroutines. Worked on site and remote.
• Report writing using Microsoft Access, Crystal Reports, VBA and Oracle. Gathered requirements, reviewed and analyzed data. Coordinated the training and documentation. Worked as the lead DBA for an MS Access database which contained over 6 million records. Improved performance significantly by adding indexing to rows. As a result, the report query speed was improved from taking 15 minutes to 15 seconds.
• Developed daily automated and ADHOC reporting systems, which enables the company to monitor error policy reports on a daily basis and documented the process.
• Responsible for creating automated tools using MS Access to simplify the reporting process enabling users to work locally and remotely from home, which has significantly streamlined their reporting operation more efficiently.