adyf4y@r.postjobfree.com Alioune Ndiaye 848-***-****

linkedin.com/in/alioune-ndiaye-a49aa111 Piscataway NJ 08854

Summary:

BI & Analytics professional, experienced in turning data into actionable insights to support decision makers across the matrix Organization Matrix. With combine financial services business acumen with a broad and deep analytical experience leveraging data and technology to formulate strategies, manage PKI and create Economic Value Add. Experienced in partnering across multiple functional teams to lead projects, prioritize and communicate across all stakeholders.

Technical Skills:

Server: SQL Server, DB2, SAP, SAS Business Intelligence

BI Tools: Tableau, Power BI, MicroStrategy, Report Builder, Microsoft Reporting Services (SSRS)

Microsoft office Suite: Ms. Access Programming, Ms. Excel Advance skill (Formula, Macro, Pivot table), VBA, SharePoint

Database: SQL, PL/SQL, T-SQL, Microsoft SQL Server, Teradata, Netezza, Hadoop.

Modeling Tools: SAS, Alteryx

Operating Systems: Window server 2010, UNIX /Linux

Professional Experience:

Boehringer Ingelheim, Duluth GA July 2019 – FEBR 2023

Business Analyst

First line of support for Transaction Data by assuring data flowing through the business via Model N application are accurate and sustainable.

Building and maintaining Power BI dashboards very instrumental in Management decision Making process. They provide proactive actions on potential rebate payment issues.

Responsible for generating Monthly inventory data to update Tableau dashboard.

Extracted data by building robust SQL script to generate weekly reports for customers’ transactions with price discrepancy.

Write SQL queries for data extraction to build and support Power BI Dashboard for New Account Creation.; such Dashboard helps management on workload balance and business projection.

Coca-Cola Bottler’ Sales & Services, Atlanta Ga July 2018 – June 2019

Business Analyst

Managed and maintained complex organizational data for bottlers and distributors to ensure accuracy of information used for payments or reimbursements.

Improved Department accountability and efficiency by cutting in half time used for audit processes.

Managed Alteryx introduction in the team.

Build robust new process flow in Alteryx that maintains audit data accuracy and sustainability.

ASSURANT Inc., Wayne, PA / Atlanta, GA October 2012 - February 2018

Senior Data Analyst

Retrieved all pricing data from international and domestic teams to create a centralized Teradata database in the US. This effort resulted in the standardization of prices across the company and ensured they stayed competitive in the market.

Managed international pricing strategy in partnership with the Analytics COE team and the Global Marketing Sales leadership leveraging data from multiple sources.

Partnered with the VP of Analytics to support the Marketing and Product Development team by developing analytics data insights to drive and monitor performance.

Owned the analytics and reporting function by driving the development of actionable KPIs, web metrics and implementing user-friendly Tableau dashboards.

Implemented pricing requirements and business processes using web scraping, data validation and integrity tools.

Developed analytics reports using SAS, SQL (Oracle/SQL server), SRSS, Tableau or MicroStrategy as report development tools.

Extract large datasets using SQL queries to build Tableau Dashboard or SAS reports to support Leadership team.

Develop SharePoint solutions integrating BI components with the following (e.g., InfoPath forms, MS Office Applications including Outlook, Excel, and PowerPoint.)

COMPUTER GENERATED SOLUTION, Atlanta GA August – 2010 – October - 2012

Data Analyst

Identified lead processing redundancies. Implemented recommendations saved $3,000+ monthly.

Redesigned monthly KPI reporting process slashing time from 7 days to 2 days, and work units from 50+ hours to 12 handled by a single analyst versus team of two analysts and an engineer.

BI migration from AS400 and Manual Oracle queries to MicroStrategy reducing reporting time by 4 hours each run.

Managed KPI reporting process and discovery discussions at meetings with Marketing Senior Management.

Responsible for all web analytics and lead matching reporting.

Designed data warehouse and report automation processes to enable real time reporting from multiple sources.

Audited reporting across 3 vendors and redesigned report series to be actionable, consistent and waterfall to cover all aspects of advertising in response to extensive budget cutbacks.

Validated new BI metrics, and designed new reports to track Search Source traffic, quantifying 15% of incoming traffic.

Provided statistical support of AB testing and test design by mining database for statistical support through Oracle, and SQL queries of SQL and Oracle databases combining results through Access and Excel

IBM, POUGHKEEPSIE, NY July - 2000 – March - 2010

System Support Analyst

Performed DBA function to manage implement database security, and upgrade to SQL Server 2007.

Worked on SQL Server 7.0 for data migration into production environment.

Responsible for running and maintaining in-house and customer SQL Servers (100+ customer sites).

Design, write and implement application database code objects, such as tables, views, functions, store procedures for different applications.

Developed SQL paging system for different issues such as drive space, deadlocks, SQL Job failure, SQL Job Stuck, expensive queries.

Tune existing store procedures by putting indexes and improving complex queries performance by using better logic with less reads and CPU usage.

Write SISS and upgrade DTS packages for data analysis and extraction.

Developed and maintained a backup and recovery strategy for all databases.

Created documentation for DRP (Disaster Recovery Process).

Education:

Master of Science in Information System, Marist College Poughkeepsie NY

Contact this candidate