SUMMARY:

• SQL Business Intelligence Consultant with 10+ years’ experience utilizing Microsoft technologies including SQL Server 2016, Azure, SSRS, SSAS, SSIS, Mobile Reporting and Power BI. Technical proficiency in full lifecycle projects designing and implementing ETL and Reporting projects, Data Migrations, and SharePoint projects with a special flare for implementing Dashboards. Specializing in translating and documenting the business needs into technical requirements to ensure the timely production and dissemination of accurate data into financial systems, dashboards and management reporting.
• Analyzing, designing, coding, testing, deploying, troubleshooting, and debugging SQL Server Business Intelligence projects
• Experienced as a financial functional and technical consultant for 10+ years with 50+ full life cycle implementations
• Vast experience in MS SQL 2005 - 2016 (Stored procedures, TSQL queries and fine tuning)
• Light experience Azure Cloud
• Extensive technical database migration experience
• Lightly experienced in SharePoint databases
• Heavy experience building custom dashboard layouts - Over 30 Dashboard projects.
• Heavy Client Training experience in Reporting and ETL Tools
• Heavy experience in designing Dashboards
• Heavy experience in ETL projects
• Data Analyst for over 20 projects
• Medium experience as SQL Server 2016 and Azure Administrator
• Heavy experience training junior colleagues
• Light experience as Cube Analyst (Translating requirements into Design for Cube/SSAS)
• Very Light experience in Cube build and deploy using SSAS (technical aspect of SSAS)
• Light experience in Data modeling

TECHNOLOGIES:

• MS SQL Server 6.5/7.0/2000/2005/2008/2012/2014/2016/2017 AZURE - 15+ years (Last Microsoft Cert in SQL SERVER 2000)
• DTS/SSIS - 10+ years
• SSRS (SQL/Mobile/Power BI Reporting) (SQL2005 through SQL2016) - 15+ years
• TFS + 5 years -
• Agile - 2+ years
• SharePoint (Data/Reporting Analyst) - LIGHT
• Visual Studio (BI and Reporting projects only)

EXPERIENCE:

Confidential

Sr SQL BI Consultant

Responsibilities:

• Design, Create, Test and Implement the Migration process along side several dozen programmers while the app design team implemented a new application for internal and external payments.

Confidential

Sr SQL BI Consultant

Responsibilities:

• Technical Analyst/Consultant for Client-based SQL Programming and Sybase Health Checks
• SSIS / SSRS / SSAS / SQL - advanced SQL coding and ETL processes
• Gather detailed information about SQL Servers (document and create a baseline of data for future comparison)
• Compare collected data to an established set of best practices to identify potential changes to the SQL Servers so that they meet the SQL best practice standards.
• SSRS Reporting (SSRS versions 2000/2005/2012/2014/2016 )
• Create custom reports for Billing and Time Card solutions
• Data driven subscription design
• Over 500 reports built for various clients
• Report Migrations for SSRS for 10+ clients
• Large SSIS projects - Data Migrations from disparate software systems into Confidential Forensic Analysis Software
• Multiple client migrations from large scale systems utilizing Visual Studio 2010 / SQL SSIS
• Data mapping
• Data Restructuring
• Data Cleansing
• Data Testing Phases including Client UAT processes
• Production Rollout
• Coaching on SQL/SSRS/SSIS software to new Confidential consultants
• Large Reporting Applications for various clients.
• Large SSAS Cube Project for clients such as VCU / MCV

Confidential

Sr. SSRS Report Writer / SharePoint Administrator

Responsibilities:

• Lead ETL Administrator, SharePoint administrator and lead SQL/SSRS developer for vast array of SQL servers including, SQL2000, SQL2005, and SQL2008
• Creating custom ad-hoc reports against Microsoft Dynamics AX datamarts, production and reporting databases utilizing T-SQL queries and stored procedures.
• Designing, coding, testing, deploying, troubleshooting, and debugging SharePoint Web Parts for use on the company web site.
• Create custom and ad-hoc reports and data extracts on SQL Server databases using SQL Server Reporting Services (SSRS). Extreme profiling and tuning for large databases / tables.
• Custom Excel Tools created to create ad-hoc reporting from excel spreadsheets.
• Custom stored procedures and T-SQL queries to obtain data needed from several different SQL servers for reporting.
• Start of SharePoint implementation - Full implementation for 2500 users.
• SharePoint custom web parts and branding.
• Custom site pages
• ODBC/SOAP setup

Confidential

Sr. SSRS Report Writer

Responsibilities:

• SSRS / SSIS / SQL2008 ETL and Reporting Specialist
• Served as a Sr. SSIS/SSRS Specialist creating SSRS reports, dashboards and ad-hoc reports.
• Create complex MS SQL Server queries for SSRS reports and data extraction, modeling, and analysis
• Performed data conversion (ETL) from several sources.
• Create reports and data extracts on SQL Server databases using SQL Server Reporting Services (SSRS)
• Plan, develop and produce SQL Server database reports
• Quickly and accurately produce ad hoc reports
• Meet with internal customers to define technical solutions for business use
• Develop report writing policies

Confidential

Sr. Data Consultant

Responsibilities:

• Costpoint data migrations/conversions and Accounting restructurings utilizing MS SQL 2005 / 2008
• Large scale implementations included data conversions of GL, Project, Accounts Receivable, Accounts Payable and most other sub-ledger data.
• Various other duties include creating custom stored procedures, designing and deploying minor interfaces for various 3rd party vendors such as PAYCHEX, ADP and Organization Charting software, and light estimating for the sales organization

Confidential

Business Analyst / SharePoint Consultant

Responsibilities:

• Document and gather business requirements, needs analysis, gap analysis, project charters and project schedules and budgets.
• Full installation of Great Plains for new customers and upgrade existing customers to Microsoft Great Plains 7.5 and 8.0
• Directed, lead, or participated in various successful implementations for companies up to $100M+ (annual sales) and 200+ payroll employees.
• Leveraged Microsoft Great Plains with other Microsoft technologies such as MS Office (Word, Excel) and reporting tools such as FRx, Crystal Reports, and SQL Reporting Services to create seamless, robust, and efficient accounting information systems.
• Proficient in Dynamics Report Writer and FRx.
• Extensive experience turning around failed/poor implementations
• Performed several Microsoft Great Plains database migrations/upgrades from Pervasive.SQL, C-Tree, B-Trieve, and SQL Server 6.x-7.x to SQL Server 2000/2005.
• Functioned as internal/external Project Manager, directed implementation teams, acted as an implementation team member, and trained several junior consultants.
• Created and modified reports on Dynamics report writer, SQL Reporting Services, Crystal reports.
• Trained users successfully for all implemented modules.
• Converted client accounting systems from manual ledger, MAS 90, Peachtree, Quickbooks, AccPac, in-house legacy systems, etc. to Microsoft Great Plains

Confidential

Sr. Lead Consultant

Responsibilities:

• Develop client business requirements, as well as coordinate and manage projects for client firms
• Pre-sales meetings, overseeing and implementing software installations, modifications, and integration to existing systems
• Post-sales tasks included interfacing with all client internal departments, training, follow-up support
• Lead consultant: analyzed, designed and implemented accounting/human resource/project systems utilizing Great Plains Modules and MS SQL technologies.
• Analyze and implement CRM systems utilizing Saleslogix and Onyx.
• Analyze and implement SOP & Detailed billing systems utilizing several different software packages to accomplish client needs
• Work closely with clients to establish business procedures, problem specification, system design, reporting requirements, business procedural specifications, data entry time constraints
• Project management
• Train onsite and in large classroom setting
• Supervise and mentor several junior consultants