SUMMARY:

• BUSINESS INTELLIGENCE & ANALYTICS PROFESSIONAL with expertise in data visualization, data modeling, business analysis and process automation. Manage financial modeling, predictive analysis and analytics projects with strong technical, analytical and quantitative skills. Specialize in internal and external client relationships with deep knowledge of requirements gathering and business processing. Attain valuable insights by delivering full - cycle BI solutions.
• Established sales opportunities by demonstrating capability of analytics management services through Power BI and automation.
• Delivered ETL, data warehouse and data visualization solutions for Confidential . Eradicated manual process of managing multiple data sources and summarized data into appealing dashboard.
• Implemented SSRS reporting platform to provide clarity for client with live data stream. Eliminated manual process from previous reporting tools with estimate annualized labor saving of 750 hours.
• Automated inserting process of business details into CRM system. Reduced potential processing time from an average of 45 minutes to 2 minutes per transaction.
• Developed VBA and .NET automation tools to streamline licensing process and eliminated human error with estimated 75% efficiency increase through detail coding and user-friendly UI design.
• Created personal website using HTML, CSS and JavaScript. Leveraged .NET framework to build web application that display and update data in a database for a class project.
• Developed time standards on new store functions by employing time study, statistical modeling and analysis methodologies.
• Established new composting stream for Eastern WA, ID and MT retail locations resulting in a 25% decrease in disposal expense.
• Supported Overtime and Over 40 reduction and control at over 190 locations. Contributed up to 40% reduction YOY.
• Devised and deployed a cost saving floor care supply management system with reduction of $100K+ in excess inventory while enhancing ordering and tracking process.
• Collaborated with Starbucks in a class project on retail workflow and throughput management using statistical modeling technique.

TECHNICAL SKILLS:

• Regression Analysis
• Statistical Modeling
• Data Warehousing
• SSAS/SSIS/SSRS
• Excel
• Access
• DAX
• SQL Server
• MDX
• Power BI
• Data Modeling
• Teradata
• Data Mining
• T-SQL
• ETL
• Essbase
• VBA
• PowerPivot
• R
• .Net
• HTML
• CSS
• JavaScript
• C#
• Tableau

PROFESSIONAL EXPERIENCE:

Senior Consultant

Confidential, Redmond, WA

Responsibilities:

• Oversee data analytics services of Confidential Volume Licensing using Excel, PowerPivot, Power BI, SSIS, SSAS, SSRS, MS Sales and T-SQL.
• Support sales pursuit by demonstrating technical aspect of MS BI stack to the client.
• Manage Power BI projects via understanding of business initiative, extraction of business data, data model and transformation development and creation of DAX measures to drive valuable story-telling insights.
• Develop friendly front-end environment in SSRS and VBA/.NET automation tools to improve effectiveness of team operation.
• Transform unstructured data using VBA scripts to reduce processing time and build sales-orientated workbooks.
• Deliver BI solutions by leveraging SSIS, Excel and Visual Basic in ETL; SQL Server in data warehousing; and PowerPivot, Power BI and SSRS in reporting and data visualization.
• Sogeti USA Top 20% Consultant .

Business Intelligence & Analytics Consultant

Confidential, Bellevue, WA

Responsibilities:

• Create databases and data warehouses in Azure SQL and Access for data storage and reporting needs.
• Develop VBA scripts to automate business process and transform data into consumable financial reports.
• Utilize Excel spreadsheet to develop financial template with advance formulas and functions to drive data accuracy and remove manual process.
• Provide financial breakdown based on organization hierarchy by leveraging PowerPivot, Power BI, SQL, and data modeling/transformation techniques.
• Develop forecasting model supported by the creation of full-cycle BI solution and regression analysis technique. Leverage Power BI to visually track progress of projection and actual values over time.

Industrial Engineer

Confidential, Bellevue, WA

Responsibilities:

• Analyzed complex data by creating financial models and leveraging automated reports using advance calculations, VBA and SQL to facilitate business decisions.
• Extracted business data using T-SQL in Teradata environment and spearheaded the creation of reports and databases intended for KPI calculations.
• Oversaw internal labor management systems to create and update budget formulas and tables to reflect labor-hour requirements for over 190 retail locations based on corporate metrics.
• Utilized spreadsheets and regressions to forecast salary, benefit and utility expenses.
• Conducted time and labor studies to establish and implement time standards on store labor requirements. Assisted in training and supervised technicians to perform per method of study.
• Managed floor care and composting programs that are instrumental in cost saving. Evaluated each program through diligent vendor identification, contracting and bidding. Established standard operation procedures and instruction to advise retails during program rollout and updates.

Industrial Engineer

Confidential, Marysville, WA

Responsibilities:

• Performed time and motion studies and implemented time standards on manufacturing operations using regression analysis.