Business Intelligence Sql Server

Karen S. Bustamante

317-***-****- ************@*****.***

Columbus, IN

Professional Summary

Experienced business intelligence professional adept at extracting and analyzing data to offer valuable insights for strategic decision-making. Collaborative by nature, excels at working with cross-functional teams to deliver impactful results. Recognized for adaptability and reliability in dynamic environments, leverages advanced analytical skills and meticulous attention to detail to drive success.

Skills

Python, R, SAS, JMP, Power BI, Data Bricks, SQL Server, Management Studio, Toad, SQL Server Analysis Services, SQL Server Integration Services, SQL Server Reporting Services, Master Data Services MDS-SQL DB, Power Automate, Git, Azure DevOps

Data modeling

Data analysis

Data integration

Advanced analytics

Machine learning

Time series

Statistical modeling

Business intelligence

ETL processes

Dashboard design

Automations

DevOps integration

Testing and debugging

Version control systems

Continuous integration

Continuous deployment

Project Management

Agile Methodology

Client relationship management

Six Sigma Green Belt trained

Professional Experience

Multiple Roles Cummins, Inc., Columbus, IN January 2012 to Present

SC & Ops Analytics Senior Analyst Global Finance Systems April 2023 to Present

Building self-service end to end, from framework design, data engineering activities to BI solutions that meet our internal customers – Finance their reporting/ dashboards needs.

Project Management - Establishes and maintains the balance of scope, schedule, and resources for a temporary effort.

Data Analytics - Discovers, interprets, and communicates qualitative and quantitative data; determines conclusions relying on knowledge of business or functional frameworks; simultaneously applies statistics, data validity, data visualization, and problem-solving approaches to effectively extract meaningful patterns and business insights; presents conclusions and outcomes that enable data driven business decisions.

Senior Data Scientist August 2020- April 2023

Participates in projects to support key objectives and business goals using data science methodology.

Leverages data science methodology to solve complex business problems.

Creates multiple algorithms using complex statistical methodologies using statistical programming languages and tools.

Partners with domain experts to verify model capabilities.

Partners with Solution Architect to enable appropriate data flow/data model, development using appropriate tools/technology, rapid prototyping and informs the design of analytical products.

EBU VPI Product Coverage Specialist December 2018- August 2020

Applies specialized knowledge of statistical tools and warranty databases to analyze existing component or system reliability, report the reliability per the customers reporting requirements, and provide interpretation of the results.

Applies specialized knowledge across various areas and products to provide reliability comparisons and assessments across the Cummins product range and identify and report adverse or favorable trends in current product reliability.

Applies specialized knowledge of statistical and life data analysis techniques to statistically quantify the reliability impact of design change.

Develops related tools and methods to quantify and improve product reliability.

Works with current product problem solving teams as well as finance and marketing functions

Business Intelligence Senior Data Analyst April 2017-December 2018

Leads multiple self-service projects from inception to completion.

B&L Detect Fast- Led the design and development of a Power BI data model, report, and visualization a Universal View of one of the Cummins legacy products. Agile Methodology in collaboration with Mckinsey Consultants.

Data Dictionary Project- Lead the design and development of a SQL Server Analysis Service semantic model, successfully deployed to a tabular server, schedule refresh on the data with partitions.

Connect to the tabular model or cube using Power BI to create the reports and dashboard. Share the result across with the end users. Collect back feedback on the development and start all over the cycle.

Help the customers to identify the data sources they need to accomplish their work

Collect all the business analytical needs, identifying and mapping the data sources. Identifying the business rules.

Gathered business requirements to build a MDS Master Data Service solution

Develop SSIS packages to make easy the data load to a SQL DB.

Training and coaching business user to use entire MS suite, SQL Server Data Tools (SSAS, SSIS and SSRS), and Power BI.

Developed DAX expressions on both SSAS and Power BI to meet business need.

Regular user of the Microsoft suite for training purposes and for internal reporting- auditing reasons. Auditing who is using the MSBI environments in Cummins, what are they doing with the data model and or report.

Implemented static and dynamic role level security on both SSAS and Power BI, to meet the business need.

Product Coverage- Financial Analyst November 2013-April 2017

Responsible for the preparation of analyses and reports for department managers. Supports the annual budget process, expense and/or staffing forecasts or statistical reporting.

Prepares statistical reporting, including financial performance, variance explanations, and cost analysis.

Executes special projects as assigned.

Statistical Analysis Engineer January 2012-November 2013

Application basic knowledge of statistical tools and warranty databases to analyze existing component or system reliability.

Reporting reliability analyses including Failure Modes, Effects, and Engine Failure Rate, and RPH Repair

Maintaining cycle time project quality committee (PQC) and maintaining Cost of Coverage Analyses.

Maintaining Six Sigma Metrics Analysis and supporting Six Sigma initiative participating in multiple projects.

Supporting service engineers with specials requests that are driven by market or customer needs.

Ensuring that product problems solved by one platform do not get repeated in another, by institutionalize lesson learned – Drive local solutions globally. Global Problem Recurrence Prevention Process (GPRP) submission owner.

Monitoring data changes including funding and Analysis rate fluctuations.

Instructor Experience

Statistics / Algebra / Trigonometry and Calculus Instructor Ivy Tech Community College, Columbus Indiana, 4475 Central Avenue, Columbus IN 47203, 812-***-****. 01/2008- 01/2016

STAT301 Elementary Statistical Methods I, IUPUC Indiana University- Purdue University Columbus, 4601 Central Avenue, Columbus IN 47203, 08/2013 – 12/2013

MATH 00100 Introductory Algebra, IUPUI Indiana University- Purdue University at Indianapolis, 420 University Blvd. Indianapolis IN 46202, 317-***-****. 08/2011-12/2011

Statistics and Math Teacher, Technological Institute ITSA, Barranquilla, Colombia. 03/2006-06/2006

Math Instructor, Colon High School, Barranquilla, Colombia. 02/2006-04/2006

Education

Master, Applied Statistics Purdue (IUPUI) December 2011

Specialist in Statistics North University, Columbia, South America September 2006

Bachelor, Math and Physics Atlántico University, Colombia, South America July 2005

Contact this candidate