SUMMARY:

• I have more than 15 years of experience in business intelligence using the Microsoft BI stack of technologies. Over the long arc of my career, I have focused on the analysis of data and predictive analytics - often called data science. I have worked with data from several OEMs, service-oriented and project-oriented businesses, and hospital/healthcare data. In addition, I have worked with data from companies that were heavily regulated by several federal agencies; such data requires a special level of attention to detail and an ability to understand regulations as they are written by the regulatory body.
• SQL Server programming; time-series prediction; multivariate predictive analysis and regression; extract, transform, and load (ETL), SSRS, Crystal Reports, QlikView, Power BI, T-SQL, SSIS, SSAS Tabular Modeling, SQL Server Administration, LaTeX, HTML5, CSS3
• 17+ years of experience in the Microsoft BI stack.
• 2+ years of Power BI, Power Query, Power Pivot, Power View, the M language, and the DAX query language.
• Technically strong in SQL Server Analysis Services development, including building tabular models, handling performance issues, and the ability to write DAX queries against Analysis Services databases and DAX queries for Power BI Desktop, Power BI service, and MS Excel Power Pivot.
• Extensive knowledge of the DAX querying language and the M data transformation language (data mashups in the Power Query Formula Language)
• Strong familiarity with Data Warehousing concepts, tools, and techniques.
• Project Management with Agile and Team Foundation Services (TFS).
• 15+ years of experience in C# and VBA/VB6.
• 20+ years of master-level experience in using and automating MS Excel, Access, Word, PowerPoint, and Outlook with VBA.
• Capable of handling multiple assignments simultaneously

PROFESSIONAL EXPERIENCE:

Consultant/Power BI and TSQL Developer

Confidential

Responsibilities:

• Performance-tune a set of T-SQL views and stored procedures for the finance department to reduce execution duration. Required expert-level knowledge of DTA, SS Profiler, SQL Server Internals, and advanced T-SQL.
• Establish a Power BI IT governance set of policies
• Develop a Power BI proof-of-concept
• Get data from multiple data sources, import the data into Power BI, and use the M language to perform data transformations and combinations to deliver the data to the Power BI model in a star schema.
• Build Power BI dashboards and reports
• Design row-level security using AD groups

Power BI Developer

Confidential

Responsibilities:

• Implement dimensional modeling concepts using the Kimball methodology.
• Design and implement SSAS tabular models.
• Develop reports using SSRS and other industry tools. Strong knowledge of best practices for dashboard design to optimally communicate actionable information and insights from data.
• Process database change requests, including the creation and modification of databases, tables, views, stored procedures, triggers, jobs, etc. in accordance with change control policies.
• Stay abreast with the functionality of the Office 365 suite and Power BI tools, and their integration with Microsoft’s Business Intelligence platform.
• Maintain the reliability of all databases by developing and implementing standards and/or processes for database maintenance, documentation and configuration.
• Build and maintain documentation related to the company’s database environment.
• Build Power BI Tabular models using dimensional design concepts.
• Build and maintain Power BI reports, charts, dashboards, mobile applications, and content packs.
• Establish and build roles in Power BI for security purposes and use filter criteria to filter datasets by role at the row-level.
• Design and develop on-demand reporting solutions to support end-users.
• Manage and support the reporting environment; serving as the key contributor when assessing and evaluating future reporting solutions.
• Establish and document reporting standards and best practices, including a focus on data quality within reporting.
• Coordinate the assistance and of business users in creating ad hoc reports, Power BI dashboards, and visualizations.
• Develop ETL with M, SSMS, SSIS and PowerShell scripts.

Consultant: Business Intelligence Developer

Confidential

Responsibilities:

• Code construction/T-SQL programming in agile sprints.
• Performs and oversees basic to complex BI solution design and development, as well as the data analysis, for the clients of Confidential and for the various projects and application technologies across the enterprise.
• Plays a key role as an individual contributor on complex reporting and analytical projects.
• Maintains an excellent functional understanding of the supported Business Intelligence applications; both for the internal and customer applications.
• Works with other development staff, Operations staff, and IT staff in developing systems, ranging from technical analysis to user acceptance testing.
• Prepares and reviews test data and executes detailed test plans.
• Provides highly analytical internal consulting and leadership in identifying and implementing new uses of BI technologies to assist the business units in meeting strategic objectives.
• Actively participates as an analytics advocate and expert (BI evangelist) to help promote the development of a BI culture.
• Software development using the Agile methodology.
• Recommends new technology, policies, and processes to benefit the organization and improve inefficiencies.
• Leads technical evaluations of vendor software.
• Plays a leading role in cost/benefit analyses.
• Develops and promotes the use of BI standards.
• Maintains an excellent understanding of the business being supported and its functions, processes, operations, and strategic direction.

SSRS Report Developer

Confidential

Responsibilities:

• Code Construction in agile sprints.
• Lead all aspects of Business Intelligence, including the architecture, design, and implementation of projects, while adhering to, and applying, best practices for BI development.
• Provide technical direction and mentoring to subordinates.
• Manages team members in the department of Business Intelligence.
• Identify and apply best practices for the development and deployment of all applications and tools.
• Identify ways of improving information delivery to all stakeholders and implement those methods.
• Detailed project planning
• Create and manage project tasks and schedules
• Requirements gathering
• Manage project scope and change control
• Facilitate the initiation of Information Technology projects with business sponsors.
• Document project objectives, scope boundaries, high-level requirements, cost/benefit analyses, project prioritization, project approach and proposal, and, when required, a high-level project plan.
• Lead business users in the review of business requirements
• Obtain business approval for the documented requirements
• Work with the users to develop user acceptance test objectives, test plans, and test scripts to verify and accept that business requirements have been satisfied.
• Perform system and user acceptance testing of system changes as agreed to by the business staff and Data Warehouse users.
• Participate in quality reviews of subordinates’ work product; reviews technical analysis, documents, technical designs, test scripts, and test results to verify that the requirements of business and data warehouse users are understood and addressed completely, correctly, and consistently.

Business Intelligence Analyst

Confidential

Responsibilities:

• Responsible for performing data analysis, T-SQL programming, report writing, querying the SSAS tabular model, and supporting multiple ERP systems. Also responsible for data migration during the ERP system upgrade to Infor’s SX.e environment. The position used SQL Server 2005, 2008 R2, and 2012, as well as SSMS, SSAS, SSIS, and SSRS. Agile methodology used for project management.

BI Developer

Confidential

Responsibilities:

• Responsible for analyzing the EMR health data derived from Confidential ’s Quality Alliance program. Confidential is in the process of a multi-year project in which they are implementing a data warehouse and business intelligence tools. The goal of the project is to produce a physician’s portal that will track Confidential t healthcare across practitioners in the Quality Alliance, discover trends in diagnostic errors, and provide physician feedback as to the overall quality and continuity of care delivered to each Confidential t.

Quantitative Analyst

Confidential

Responsibilities:

• Applies technical knowledge and expertise by leading or participating in the reviews of supervised institutions that employ statistically-based, predictive risk analytics and modeling, concerning their financial, risk identification and measurement, and capital adequacy assessment processes.
• Maintain an advanced level of understanding of the Federal Reserve’s expectations for risk measurement and modeling, capital planning and stress testing. This includes Basel II requirements, as well as an understanding of current industry practices across large institutions.
• Promotes the advancement of knowledge and awareness of advanced statistical and analytical methods and demonstrates active engagement and knowledge transfer to team members.
• Acts as project lead, or a member of local or system research projects and other strategic initiatives to advance policy, risk analytics and modeling.
• Serves as a subject matter expert resource for the bank, department management, and senior staff by monitoring and evaluating trends in quantitative risk analysis models. Quantitatively models risk management with a focus on Basel II advanced risk measurement requirements, stress testing, economic capital and internal capital adequacy assessment activities and developments.
• Leads supervisory reviews and projects; works independently or as a member of an examination team; meets on a regular basis with management and technical experts at major banking organizations, both to evaluate bank practices and to keep appraised of current developments and latest techniques.

Sr. Business Intelligence Developer

Confidential

Responsibilities:

• Code construction using agile sprints.
• Requirements gathering
• Identified timeliness of data, requisite granularity, and targeted business questions
• Performed dimensional analysis
• Extensive Data Modeling
• Research, design, and implement predictive analytics algorithms for predicting demand, production volumes, shipment costs, and, most importantly, EBITDA.
• Research and development of resource scheduling algorithms
• Management dashboards in Microsoft Access and Excel

Project Manager

Confidential

Responsibilities:

• Designed and implemented an ABC Cost application system using VB.NET 2005
• Agile project management.

Data Mining Specialist

Confidential

Responsibilities:

• Implemented database security on all MS SQL Server instances
• Performed ETL using SSIS
• Report design and implementation

ETL Specialist

Confidential

Responsibilities:

• Performed Extract, Transform and Load functions from multiple OLTP systems into a single data mart

Database Administrator

Confidential

Responsibilities:

• SQL Server Administration
• Decision Support
• Market Basket Analysis
• Statistical Analysis
• Exploratory Data Analysis
• Research and develop predictive analytics algorithms to predict each of the following business variables: demand inventory production profit sales shipments