SUMMARY:

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

SPECIALTIES:

MS SQL Database Developer, Experience with Snowflake and Star Schemas, SQL 2005 - 2014,, SSRS, ETL (SSIS), Transact SQL TSQL, Creating SQL Server Query Execution Plans for Query Tuning, SQL Reporting Services (SSRS), Sales Force Data Mapping and Data Modeling, 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 SKILLS:

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
• MS Access Database Development
• Crystal Reports
• Developing Complex Macros VBA
• Oracle
• MS Visual Studio (Including SQL 2012 currently)
• SSIS Packages

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 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 and procedures.
• 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.
• Developed reports using SSRS and assisted in the migration of reporting services to new server.
• Creating SQL Server Query Execution Plans

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.

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.
• Sales Force Data Mapping and Data Modeling
• Created SSRS reports and data analytics for financial reporting.

Confidential, Tampa, FL

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

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

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

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.