Quality Assurance Data Governance

Manish Dagli

Streamwood, IL ***** *******@*****.*** 630-***-****

Skype ID: manish.dagli1 https://www.linkedin.com/in/manish-dagli-30237988/

Work Authorization: US Citizen

SAP FICO ERP Consultant (Master Data Management SME, Sales Data Specialist, Reporting Analyst, Quality Assurance Analyst, Excel, Power Pivot, Access, VBA, Report Developer/Automation in Excel/Data Governance/Data Services), SQL, Salesforce. S/4 HANA

EXECUTIVE SUMMARY:

10 years of combined professional and academic project experience in business & data analysis including Accounting, Law and Administrative (Property Management Company, Tobacco Wholesalers, Pharma Company, Health Care)

5 years of experience in Retail Industry (Walgreen Co, Wal-Mart Associates, Circle K Gas Station, 7 Eleven Stores, Village Discounts)

Skilled in data services (Integrity, cleansing, validation) and master data governance

Expert in Power BI and Power Pivot

Liaised between data explorers and developers

Managed users and user roles relating to BI and reporting

Assisted in the design and creation of analytical environments

Manage and design the reporting environment, including data sources, security, and metadata developed reports and visualizations

Detail-oriented and results-driven Data Analyst with experience in data analysis, operations, and database management System

Proficient in leveraging SQL for data extraction, manipulation, and reporting, with hands-on experience in Salesforce for CRM analytics and process optimization

Skilled in identifying trends, providing actionable insights, and improving operational efficiency through data-driven decision-makers

Proficient in large datasets, performing data cleaning, and creating reports to support business strategy

Strong analytical, problem-solving, and communication skills, with a proven ability to work collaboratively across teams to meet business objectives

Prepared data cube (datamining and analysis)

Supported data warehouses

Prepared Data models (Used various keys, E-R Diagram, Cardinality, Data Normalization, Schema, etc.)

Evaluated changes and updated to data systems

Trained users on reports, dashboards and BI tools

Provided technical expertise on data storage structures, data mining and data cleansing

Worked as an Assistant Auditor in Chartered Account firm for many years and did financial Audit, Tax Audit, and Management Audit and did GL (General Ledger) Scrutiny and made Balance Sheet and Profit & Loss account (Income Expenditure)

Prepared Balance Sheet and Profit & Loss account (Income Expenditure) and Worked in the different modules of SAP which are part of the SAP FICO

Accounting: Bank Reconciliations, Vendors Account reconciliation, General Ledger Scrutiny, Account Payables, Account Receivables, Passed Journal Entries, Finalization entry, successfully handled cash collection through account reconciliations and lease agreement (Used in Property Management Company), and prepared Accounting on Quick Book & Tenant Pro during 2009-2012

Made Lease Agreements, Collection, Account Reconciliation on Disputed Lease, fees, lease rentals, landlord and tenant responsibilities, etc.

Master Data Management SME in S4 Hana, Data Migration Experienced on SAP ERP ECC TO S4 HANA

Academic experience in Python AND SAP ABAP

EDUCATION:

2017 Master of Science, Management Information Systems - Northern Illinois University, De Kalb, IL

2007 Paralegal - CDI College, Mississauga, Ontario, Canada

1988 Bachelor of Law - Gujarat University, India

1985 Bachelor of Commerce/Business - Gujarat University, India

ACHIEVEMENTS: AWARD & CERTIFICATES:

2017 Microsoft Technology Associate Certified: Database Administration Fundamentals

(USA)

2017 Award: SAP Product Portfolio (USA)

(SAP FICO Functionality, Configuration, and SAP NETWEAVER)

2013 DePaul University Certificate: Business Analyst (USA)

2009 Enrolled as an attorney applicant at California Bar

TECHNICAL SKILLS:

Data Structure: Array, String, Linked list, Stack, Queue, Tree, Graph

Algorithms: Tree and Graph Traversal, Searching, Sorting, Divide and Conquer, Hashing, Greedy, Recursion, Backtracking, Dynamic Programming

Data Warehousing: Meta Data, OLAP, OLTP / ETL, Data Cleaning, Refreshing

Data Modeling/Database Design: Categories of Data Model: Conceptual, Logical, Physical, Normalization ( Key Properties of each entity, relationships among entities, Map attributes, Functional Dependencies, Closure set of attributes), Types of data modeling: E-R, Object-Oriented, Dimensional: Start Schema, Snowflake Schema (OLAP Systems) / Database Management Query, System Analysis and Design, Graph Theory (Dijkstra’s Algorithm), Set theory

Develop Power BI Dashboards & Reports – Create interactive and visually compelling sales performance dashboards that provide insights on quota attainment, revenue trends, and distributor sales

Sales Metrics & Insights – Provide sales leaders with key performance indicators (KPIs) and data-driven recommendations to improve sales strategies

Analysis: Product Profitability Analysis, Variance Analysis, Sales Staff Performance, Trend and Growth Analysis, Industry Market Share Analysis, Promotion Effectiveness / Statistical Analysis, Data Mining, User Interface Design, Data Visualization

Data Mining Techniques: Microsoft Association Mining, Cluster Analysis, Time Series, Naïve-Bayes Algorithm / SAP ERP, Advanced Accounting and Auditing, Business Processes, Python Analytics

Data Profiling: Performed detailed reviews of data to assess its quality, identify inconsistencies, and pinpoint areas for improvement

Data Quality Management: Established data quality rules, conduct validation checks, and recommend targeted solutions to correct data issues

Data Governance: Worked with relevant stakeholders to uphold data governance standards while promoting best practices for data management

Data Migration and Integration: Supported SAP data migration efforts by cleaning and structuring data, assisting in data mapping, and integrating inputs from various sources

Reporting and Analytics: Created and maintained dashboards and reports that showcase KPIs related to data quality and system operations

Collaboration with SAP Functional Teams: Collaborated with functional teams across SAP modules (e.g., MM, SD, FICO) to diagnose and resolve data-related problems

Process Improvement: Discovered opportunities for process and system optimization and lead initiatives for continuous improvement in SAP data management

Documentation and Training: Maintained documentation on methodologies

Accounting: Bank Reconciliations, Vendors Account reconciliation, General Ledger Scrutiny, Account Payables, Account Receivables, Passed Journal Entries, Finalization entry, Balance Sheet, Profit & Loss Account

Auditing: Financial Audit, Tax Audit, Managerial Audit

Legal: Petition, Agreements, Opinions, Affidavit in Reply, Rejoinder, Amendments, Real Estate Closing, etc.

TOOLS:

Excel VBA Developer/ Coder/ Scripting

Microsoft SQL (SSAS (OLAP Cube), Power BI, Excel, Power Pivot, SSMS (SQL Query), SSIS (ETL), SSRS (DAX, MDX), Python and SQL

Microsoft SQL: Advanced Query (Join, Second Highest, etc.), Subquery, Nested Query, Data Model, Various Key, Data Mapping, Constraints, Microsoft Power BI, Machine Learning R, Python

SAP ERP (Functionality, configuration, NetWeaver for BI), SAP ABAP (Advanced Business Application Programming, SAP Mockups, wireframe, SQL Query, Variable Data Types, Program Flow, Internal Tables, prototypes on MS Visio, ASP.NET, USER STORY, Networking Cyber Security

AGIIS: Customer Master Addresses

Promise: pulled invoices, Shipping Point info, etc.

IBM Blue works: Swimlane Diagram

SharePoint Version 9.0: Uploaded files, Changed Meta Data, etc.

SAP ERP ECC TO S/4 Hana SD: Data Migration (SE16N, KNA1, KNB1, KNVV, KNBK, KNVP, VAKPA, etc.)

SAP PP Master Data: Material Master, Bill of Materials (BOM), Work Center, Routing (Operations), Production Version,

SAP PP: Data Center, Variant Configuration (Characteristics in the variant classification, Configuration profile,, Sets of Rules (Precondition, Constrains, Object dependencies), CRP

SAP PP T-Code (CS03(Display BOM), MB51, MB52, CS15, XD03, etc.)

SAP Vendor Master Data: At Client Level (Vendor full name, Address, Email address, Contact numbers, Bank details, Country, Fax Number), at Company Code Level (Previous account number (if any), Default payment terms, Withholding tax information), and at Purchasing Organization Level (Name of important contact person, Indicator specifying Goods Receipt based invoice which is used when you require Invoice to match against Goods Receipts), Account Group is important to control vendor master records

SAP Data Services: Create a project Create a Job Data flow icon Add Script Create datastore Connect to the database Import table metadata from the datastore

HP ALM: Test Lab, Test Case, Attached Screen shots of testing (System, Regression, integration, UAT)

Advanced Excel (Functions, Pivot Table, Data Analysis, etc.), Advanced Access, Power Pivot, Excel VBA, Excel Shortcut Keys and Windows 10 Shortcut Keys

Excel: Formulas and Functions, Format, View, Data Validation, Power Pivot, KPI, Conditional Formatting, Pivot Table, Data Cleansing, Index Match, XLOOKUP, etc.

Data Analytics / SAP ERP Customer Master Data Consultant / Sales Data Specialist/Reporting Analyst/ Quality Assurance Analyst/ UAT/ Data Validation/Data Cleansing/Business Intelligence/Excel Developer/Power Pivot

WORK EXPERIENCES:

07/23-07/24 PHILIPS HEALTH CARE (Manufacturing Company) through Staffing Agency

Remote Master Data Management SME (Contract)

Worked on Project of S/4 HANA / PAPM/Pricing Hierarchy Data Model

Worked on Data Exploration, Data Mapping, and Data Cleansing

Supported business areas of Procurement and Supply Chain, accounts payable, materials, procurement, warehouse, inventory

Led S/4 HANA data migration and system configuration for Profitability and Performance Management (PAPM), supporting pricing hierarchy, cost centers, and profitability reporting.

Used Linked list data structure type and Developed an Analysis Template with functions to validate data with comments

Worked data of Account Index EDI file, Summary Asks file, and worked with IGTD Data

Categorized customers on Bucket 1 to Bucket 4

Transfer data into BPDH Reactivate and BPD Create Template

Did Business Partner (BP) Analysis like Main BP, required to create new BP. Change BP, Marked as Deletion

Checked Linking for SP, SH, and BP for Division with Sales Org. and Distribution Channel and made comments

Checked Vertex website for the tax exemption Certificate

Used SAP Table: SE16N, KNA1, KNVV, VAKPA, KNVP

SAP Transaction Code: XD01, XD02, XD03, XD04

Expert on Advanced Microsoft Excel used various excel functions based on Decision Tree

Used Power Query and Power Pivot for consolidated data analysis of 17 people

Made data validation before and after updates in the SAP System

Consolidated entire data from all files, including IGTD and EDI files, and analyzed data

Combine all data from all worksheets into Master sheet

Created data analyzed form for big data

Used SharePoint

Created Business Rules and converted them into functions in Excel

Through functions prepared BPDH Create Analysis Template, and BPDH Reactivate Template

Prepared SNOW Templates for Train Station, Telephone, and Text and Uploaded on SNOW

Ensured customer data is complete, accurate and follows data governance policies

Interface with external customers as well as multiple business stakeholders, especially with sales, credit, collections, and order management

Managed account cleanups and issue resolution with external customers and internal stakeholders

Served as the End-to-End Master Data knowledge expert from a data and system perspective for SAP, Informatica Business Partner Data Hub (BPDH) and Salesforce.com

Collaborated with functional teams across SAP modules (e.g., MM, SD, FICO) to diagnose and resolve data-related problems

Discovered opportunities for process and system optimization and lead initiatives for continuous improvement in SAP data management

Maintained documentation on methodologies

Supported SAP data migration efforts by cleaning and structuring data, assisting in data mapping, and integrating inputs from various sources

Worked with relevant stakeholders to uphold data governance standards while promoting best practices for data management

Established data quality rules, conduct validation checks, and recommend targeted solutions to correct data issues

Performed detailed reviews of data to assess its quality, identify inconsistencies, and pinpoint areas for improvement

05/22-03/23 ABBVIE, North Chicago, IL (Manufacturing Company) through Staffing Agency

Hybrid Data Analyst/Sales Data Specialist / SAP ERP Master Data Consultant/Reporting Analyst /Excel VBA Developer/Report Developer/Excel Developer/Business Developer/Data Governance (Contract)

Worked on S/4 Hana ERP

Gathered data according to the Business report’s requirements

Made data model according to the report’s requirements

Contributed to S/4 HANA ERP implementation

Made weekly reports for Customers/for market access on Stocks for Sales

Did SAP Data Services (data cleansing and data validation) for monthly and weekly reports

Built Visualizations Charts and create good story on the data tables

Prepared Monthly Report on Supply Chain Management: List of Sales Inquiries, Credit Avoidance, No Charge orders, Order by Source, Sales Report, Returns, Line Items, Open Orders, etc.

Supported data migration from legacy systems to S/4 HANA.

Extracted data from SAP Logistics and Distribution, SAP Order to Cash

Used SAP T-Codes: MMBE (Stocks Overview/Stocks query), MB52 (Warehouse Stock), MB51 (Material Document List), VA05 (Sales Orders List), FD10N (Customer Bal. Display), VA23 (Display Quotations), VA03 (Display Sales Documents), XD03 (Customer Display Initial Screen), ME53N (Display Purchase Requisition), ME23N (Display Purchase Order), MIGO (Goods Receipt Purchase Order), Open Order Documents, Backorder Processing(V.15 (Simple Backorder Report),V_R1 (Display a list of Backorder items)), Short dated Ordered, Bill of Materials, Dunning, etc.

Worked on Different Matrices (KPIs), Manpower Requirement, Service Level, Productivity, Occupancy etc., of Triage, Response, Collaborate

Made suggestions to change visualization charts (Improved Processes)

Weekly and Monthly reports published to the individual and management team including vice-president

Used SAP Data Services and SQL to clean, validate, and migrate customer and sales data from legacy systems to S4 HANA, ensuring consistency and accuracy in the migrated data.

Used Simple Regression, Time Series, Net Growth, Gross profit Margin

Customized Automated daily report by using Excel VBA code for conditional formatting, dynamic range, functions, MsgBox, Pivot table, classic pivot table, search string and Highlight, filter out, add new columns, lookup, Pivot Chart, Constraints, E-mail, etc.

Automated Repots by using Excel VBA Code/Script/Excel Macro and linked with Power Point and Access

Used SharePoint for sharing Various Reports

Used Outlook for Contact Group, Scheduled meetings

Used Microsoft e-chat, and Microsoft notes for daily works

Performed procedures around data governance like data quality and consistency and reliability

Collaborated with functional teams across SAP modules (e.g., MM, SD, FICO) to diagnose and resolve data-related problems

Discovered opportunities for process and system optimization and lead initiatives for continuous improvement in SAP data management

Maintained documentation on methodologies

Created and maintained dashboards and reports that showcase KPIs related to data quality and system operations

Established data quality rules, conduct validation checks, and recommend targeted solutions to correct data issues

Performed detailed reviews of data to assess its quality, identify inconsistencies, and pinpoint areas for improvement

11/21-02/22 CF INDUSTRY, Deerfield, IL (Manufacturing Company) through Staffing Agency

Hybrid Sales Data Specialist / SAP ERP Master Data Consultant (Contract)

Gathered data according to the requirements for the database

Performed SAP DATA SERVICES (data cleansing, data integrity, data validation) for customer master data using excel

Led the data migration efforts for an S/4 HANA system upgrade, focusing on the integration of Profitability and Performance Management (PAPM) within the financial and controlling modules.

Completed data validation from Input to Preload and Preload to Post load in Excel

Tested data validation in S4 Hana SD Module

Collaborated with business teams to ensure proper PAPM configuration to meet reporting and profitability analysis needs, enhancing operational insights.

Responsible for creation and maintenance of SAP Customer Master Data

Maintained AGIIS database to allow CF to keep Ecommerce Customer Master data up to date

Assisted account specialists with daily responsibilities as needed

Performed User Acceptance Test (UAT) on SD S/4Hana ERP Modules

Participated in RPA (Robotics Business Process) Project

Performed Test cases of S/4Hana ERP used HP Application Life Cycle Management (HP ALM) tool

Prepared swim lane diagram for business process model used IBM BLUEWORKS tool

Pulled invoices used PROMISE tool

Pulled data from SAP ECC Table

Improved process by recommending to add quick edit button in menu for updating the properties on a bulk level

Uploaded files in bulk level into SharePoint and changed meta data

Prepared data validation report on Customer Hierarchy, BP Function (Sold-to, Ship-to, Biller, Payer), Pricing Condition, Open Contracts

Validated (Quality) Millions of records and almost 300 plus fields, mapped the fields in excel

Generated Unique key in excel used database knowledge

Used Excel Macro for reporting to the management for sign off

Performed procedures around data governance like data quality and consistency and reliability

Supported SAP data migration efforts by cleaning and structuring data, assisting in data mapping, and integrating inputs from various sources

Worked with relevant stakeholders to uphold data governance standards while promoting best practices for data management

Established data quality rules, conduct validation checks, and recommend targeted solutions to correct data issues

06/21-07/21 CIGNA HEALTH INSURANCE through Staffing Agency

Remote Data Analyst: Presale Support (Contract)

Gathered missing information

Prepared documents of RFPs on salesforce and supported Underwriters

Scrubbed data file using advanced Excel (Pivot tables, Format, Functions) and excel macros

Gathered necessary required information from the stakeholders

Studied documents and writing e-mails to stakeholders

Clean and organized data using advanced Excel

Used Windows & Excel Shortcut Keys

Used Dynamic Data Validation, Offset, XMATCH, XOR, Concatenate, Dynamic Arrays, Percentage, Date, KPI, Conditional Formatting, Group by, Slicer, Drill down, Count, Macro, Number, Match, lookup, VLOOKUP, HLOOKUP, index, if, sumif, sum, Trim, Right, Left, Mid, Text, Sort, Filter, Find, Replace, Pivot Table, Nested Functions

Prepared KPIs, charts, made data analysis

Used Queries (Unions, Joins, Second Highest, etc.), Subquery, Nested Query

Performed procedures around data governance like data quality and consistency and reliability

10/20-01/21 DOVENMUEHLE MORTGAGE (DMI Corporation) through Staffing Agency

Remote Data Analytics (Contract)

Data Preparation (Table), Data cleansing, data verification, data coding, data Validation

Macro, V look up, Look Up, Index, Match, Indirect, Conditional Formatting, Nested Formulas, Pivot table, chart

Windows 10 Shortcut Keys, Excel Shortcut Keys and excel macros

Prepared Dashboard in Power BI, used look up, slicer, drill through

Utilized power query to pivot and un-pivot the data model for data cleansing

Generated monthly data insight reports as needed

Performed Data analysis, extraction, and visualizations using Power BI data flow

Designed different custom data visualization dashboards to show Inspection results around various conditions using Power BI

Concluded procedures around data governance like data quality and consistency and reliability

09/17-10/17 PLIBRICO, Northbrook, IL (Manufacturing Company) through Staffing Agency

Onsite ERP Integration Analyst (Contract)

Performed data validation and cleaned data on excel, used formulas, string, left, mid, right, replace, Large, Row, Indirect, Length, match, if error, v-lookups, Trim, Proper, and used Conditional formatting, count, sort, filter, pivot table, and Macro, etc. and insert data into new ERP System.

Demonstrated proficiency in deep data cleaning, data transforming, and data fixing and made data pattern.

Changed and matched data types before migrating data to Microsoft Dynamics Navision ERP.

Used SQL Query for data validation like Minus, Sum, Count, Join, Union, and Group by

Made procedures around data governance like data quality and consistency and reliability

08/16-10/16 UNICARRIERS AMERICAS CORP, Marengo IL (Manufacturing Company) through Staffing Agency

Onsite Data Analyst Consultant (Contract)

Developed Sales Performance Versus Goal Report by Region, Dealer, Product

Made Database Design, Star Schema, Snowflake Schema, complex SQL Queries applied for the customized reports

Used power pivot, pivot chart for analyzing and visualizing data

Analyzed data and shown discrepancies in the numbers and fixed the errors

Used Advanced Excel for Data Analysis and MIS Reporting along with Zap BI (Power Pivot, HLookup, VLookup, Pivot Table & Pivot Table Chart, Forms, data validation & Scenarios)

Used Microsoft Excel and Access

Finished procedures around data governance like data quality and consistency and reliability

ADDITIONAL EXPERIENCE:

01/20-10/20 WALGREEN CO

Onsite Customer Service Associate (Temporary)

Cash Register, Front End, Floor, Photo, Customer Service, Problem Solving

11/17-01/20 WALGREEN CO

Onsite Shift Lead (Full Time)

Cash Register, Customer Service, Problem Solving, Time Management

Store account maintained including all cash registers of stores

12/24-Current WAL-MART STORE

Onsite Cashier (Temp Part time)

Cash Register, Front End, Floor, Customer Service, Problem Solving

11/16-11/17 WAL-MART STORE

Onsite Cashier (Part time)

Cash Register, Front End, Floor, Customer Service, Problem Solving

06/15-09/16 WAL-MART STORE

Onsite Customer Service Manager (Part time )

Cash Register, Customer Service, Problem Solving, Time Management

Store account maintained including all cash registers of stores

Contact this candidate