Manish Dagli

Schaumburg, IL ***** ac1ai9@r.postjobfree.com 630-***-**** Skype ID: manish.dagli1

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

OBJECTIVE

Adaptable Data Analyst skilled in recording, interpreting and analyzing data in a fast-paced environment. Advanced proficiency in all aspects of Excel. Experienced in preparing detailed documents and reports while managing complex internal and external data analysis responsibilities.

SUMMARY

Proficient in business domain and in data and upgraded technology skills at USA

8+ years of experience as a Business Analyst with solid understanding of Business Requirement Gathering, Business Process Flow, Business Process Modeling

Having knowledge on business training and experience, plus knowledge of analysis and design, great understanding of business, excellent communicator

Proficient in simplifying the business process and worked ethically towards the organization’s goals

Produced business and functional requirement specifications documents/artifacts including use cases (impact on customer experience), process flows, and business rules, using clear, concise and unambiguous language

Reviewed all project deliverables related to requirements, solution design and testing to ensure that the business needs are being addressed and requirements are interpreted accurately

Managed requirements traceability information and track requirements changes and status throughout the project

Ensured that all data elements and reporting requirements are also captured in the documentation

Collaborated with training development to ensure alignment with business requirements and solutions

Understands the legal compliances and policies related to the business/industry to ensure that the requirements and solution is in-compliance with these guidelines

Strong knowledge of Software Development Life Cycle (SDLC), Data Analytics Life Cycle, and Project Life Cycle

Proficient in documentation of As-is and To-be business processes

Proficient in MS Office Excel (pivot tables, vlookups, hlookups, macro), Access, PowerPoint, Visio

Written Use cases and have produced Use Case Models, creating Behavioral diagrams (use case diagram, Activity diagrams and Sequence diagrams) based on UML Methodology & Business process flow diagrams

EDUCATION

Northern Illinois University, DeKalb, IL USA

Masters of Science in Management Information Systems Recent Graduate GPA 3.067 2015-2017

CDI College, ON Canada

Honors in Diploma: Paralegal Communication 2007

Gujarat University, Ahmedabad, India

Bachelors of Law: Special, 3 years 1988

Gujarat University, Ahmedabad, India

Bachelors of Commerce/ Business: Accounting, Statistics, Economics, Management 1984

ACHIEVEMENTS: AWARD & CERTIFICATE

Award: SAP Product Portfolio 2017

De Paul University O'Hare Campus, Chicago, IL USA: Business Analyst Certification 2013

TECHNICAL SKILLS

MS Visual Studio

ASP.Net using C#

Wireframe, Mockingbird, and Balsamic

My SQL

OLAP Cube

Cyber Security

SAP Functional

Data Source: OLTP, External, Historical Repository of Data

ETL

Data Warehouse

Data Reporting

Windows Server 2012 Virtual Machines

SAP Configuration

USE Cases

Data Flow

Data Mart

Data Mining

Excel: Functions and Formulas, like, DMAX

SAP NetWeaver BW

Business Rules

Big Data

Statistical tool like R, SAS

MapReduce/

Hadoop

SSIS

Dynamics AX

Zap Business Intelligence, and Power BI

Lucid Chart, BPMN, MS Visio

MS Office Suit

Apache

Data Cleansing, Data Selection, Pattern Evaluation, KDD, User Interface

EXPERIENCE

Business Computing Environment & Networks: (Used WireShark, Apache) Spring 2017

Did project on Wireshark, prepared report on packet sniffing

Another Project made on Virtual Machines

Skillful in Fragments, Frames, Packets, Routers, Route

Proficient in 5 Layers Standard

Big Data Analytics for Business: (Used RStudio, MapReduce/Hadoop, SAS, Putty) Spring 2017

Deployed a structured lifecycle approach to data science and big data analytics projects

Reframed a business challenge as analytics challenge

Applied analytic techniques and tools to analyze big data, created statistical models, and identified insights that can lead to actionable results (did statistics manually, then worked on excel and then worked on R)

Proficient in Statistical and Quantitative Analysis

Skillful in Mean, Median, Mode, Variance, Standard Deviation, Skewness

Talented in Probability, Linear Regression, Logistic Regression, Association Rules, K- means clustering

Business Intelligence (Used Power BI, SQL, SAP NetWeaver BW, Power Pivot) Fall 2016

Dealt with integrating development tools and technologies to design and implement business intelligence applications

Worked with SAP NetWeaver Business Warehouse, SAP Business Object Analysis, Microsoft SQL Server 2014, Microsoft Excel PowerPivot, and Power BI to explore big data issues

Proficiently used dimensions, cubes, and tabular models in analyzing enterprise data. Managerial issues related to planning, design, and application of business intelligence discussed

Integrated systems with Extract, Transform, and Load (ETL) Interfaces and Modified data into the meaningful reports

Used Key performance indicators (KPIs) and Service level agreements (SLAs) on the Vendors billing and shown how to make corrective measures

Data Analyst Consultant Aug 2016 – Oct 2016

UniCarriers Americas Corp, Group of Mitsubishi, Marengo, IL

Designer in ZAP BI

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

Developed Dashboard Report

Made Database Design, Star Schema, Snowflake Schema, Various including complex type of SQL Queries applied for the customized reports

Imported and exported documents in Access 2013 and made Hierarchy of Tables from Raw Data; Cleaned data at excel, Changed Data Type

Exported parts by location report from ERP, Dynamics Ax 2012 to Excel

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)

Business Process Integration with SAP ERP (Used SAP Configuration) Summer 2016

Configured and implemented an entire business process chain including: Financial Accounting, Procurement, Fulfillment, Production and Material Planning

Strategized pricing, production and sales in a competitive commodity market

Analyzed sales data in an ERP to dynamically responded to changing market conditions to maximize profits

Reported on the reasons for the success (or failure) of production and sales strategy

Info Tech Project Management (Used Microsoft Project, .Net, Visio, Proto Type) Spring 2016

Made Decision Tree

Handled Project Design Elements, Quality, and Risk matrix

Web Programming (Used Mockingbird, Balsamic, .Net, Visio, SQL, MS Visual Studio) Spring 2016

Created front end web pages and databases on back end

Prepared on Wireframe

System Analysis and Design (Used Visio) Fall 2015

Planning: Gathered information, prepared USE Case, DFDs, Class Diagram, User Story, State Transition Diagram, structured chart and decision tree tables

Prepared Prototype, touch screen interface

Management Information System (Used SAP Functionality) Fall 2015

Made crucial recommendations on case study

Conducted SAP project on functional side

Enterprise Resource Planning (Used SAP Functionality, Visio) Summer 2015

Used the Swim lane diagram as a tool to increase efficiency

Did project on SAP: Logistics, Bills Payable, Bills receivables, FICO, etc.

Improved the process by diagnosis of gaps analysis

Database Processing (Used My SQL, Visio) Summer 2015

Draw E-R Diagram and decided Maximum Cardinality includes binary and ternary relationships with decision notation

Created Database Flow Diagram on My SQL 2012

Created table through designs, data types, allowing null or not, identity specifications decide, created tables per Boyce-Codd Normal Form (BCNF)

Populated Database: Used different kinds of query, like, functions, created table, alter table, truncate, update, delete, add, merge, view; find query, like, used different conditions, sub query, in, not in, union, count, date, concatenate, etc.

Business Analyst Summer 2013

Made Project of a rental car based on USE CASE: Grade the Stakeholder Requests and soundness check criteria

Prepared Design/Drawings/ Process of Flow on BPMN

Business Analysis Planning and Monitoring: Determined Activities, Identified Stack Holders (Elicitation), Selection of Techniques, Managed Requirements, Assessed the progress of the work

AbbVie / Abbott Laboratories Nov 2012 - Mar 2013

Operation Support III - Financial Compliance Team

Trained on OPPF rule and applied rule, i.e., dollar limit violated, in a real life, i.e., Contractual audit with Physician World, Data Mart, and Cognos (pulled data, researched transactions, entered explanations on why situations occurred)

Worked on UURR File / Recipient Error File and researched medical licenses of Health Care Providers from POL and Expense Manager

Completed Spend Expenses, State Board, Health Grade, Vital, Google and checked distances from Google Maps

Understood and applied complex concepts on OPPF

Actively participated to find resolutions in a complex problem and made suggestions to simplify the Excel worksheet

Facilitated interpretations and understanding of data, and identified risks and made comments on contractual audit

Proposed recommendations and solutions on issues to Expense Manager, and implemented solutions for problem resolutions

Provided operational support to departmental projects or larger scale department / division-wide efforts track information and generate reports, researched and followed through, scheduled coordinated and database management;

Worked with large amounts of data and repetitive tasks while maintaining attention to detail and completing projects in timely manner

Worked with stakeholders and managers in the locations

Interpreted large amounts of data, identified risks, and made corrective recommendations for contractual audit. Generating and analyzing the report.

Worked with the Finance Compliance Team in integrated tasks find resolutions to complex problems while also making suggestions to simplify data usage issues

Rilwala Properties Management L.L.C., Lincolnwood, IL July 2009 - Oct 2012

Business Analyst/Staff Accountant/Paralegal

Accounting Skills: Tenant Pro and Quick Book

Prepared general accounts of various commercial plazas on tenant pro and quick book

Reconciled the accounts with the bank statements and with the tenants

Generated provisional quarterly balance sheets; Passed Journal entries

Maintained the expenses as low as possible; Generated reports

Administrative Skills:

Organized and revised leases, lease related documents (i. e. amendments, extension agreements, termination agreements, letter agreements, lease summary sheets), other documents, SNDA, Tenant Estoppel Certificate, letters and memos on proprietary software working with the outside attorneys

Provided clerical support such as filing, faxing, copying, opening mail, making travel arrangements, ordering supplies and answering phones

Collection & Insurance Claim Skills:

Collected disputed amount from the customers by interpreting the legal contracts

Required to identify, assess, and resolve issues within Collections area of responsibility

Legal & Negotiation Skills:

Participated in client interviews and meetings; Researched legal issues and appropriate case laws on a various laws And Talented in synopsis with citations

Drafted legal memoranda, i.e., Notices, Suit claim, Petition, Appeal, Revision, Review

Actively participated in Mediation Proceedings in a disputed Court case

Successfully negotiated with the Insurance Company on a doubtful claim; Resolved disputed claim of common area maintenances with Tenants; and Finalized balance sheet of 10 commercial properties

Website Administrator

Develop user friendly, functional, fast, and intuitive web content and structure for intranet or extranet sites

Work closely with multi-disciplinary teams including project managers, business analysts, designers, and systems personnel to translate website requests and apply online

Participate in all phases of the software development lifecycle

Support business analyst to deliver business solutions to streamline processes

Database: Microsoft Access

Project manager for design, automation, and solution development of various applications, including integrating existing user-developed Access databases into SQL server back-end and modifying front-end screens

Analyze business models, logical specifications, and user requirements to design and test solutions for application environment

Employ activity and data modeling, transaction/workflow analysis, internal control and risk analysis, and performance-measurement techniques; Defined disaster recovery plan, recommended options, and created user manual. Led tool evaluation

Prepare reports, studies, and documentation. Deliver presentations and lead meetings

Supported development of Access applications for product management group, involving analysis, design, coding, and testing of components; Worked with end users to develop specifications for coding; Assisted outside developers in creating project plans and progress reports

NON-IT (Retail) EXPERIENCE

Various Retail Industries, Like Wal-Mart, Circle K, etc. Aug 2009- Present

Wal-Mart Stores Inc.

Cashier Nov 2016- Present

Wal-Mart Stores Inc.

Customer Manager June 2015- Sept 2016

Successfully Managed retail operation on the front-end area

Contact this candidate