Erp Implementation Bi Reporting

Ashwini Kumar Dube

E: **********@*******.*** T: 571-***-****

PROFESSIONAL SUMMARY

Experience – BI, CRM, ERP and ETL lifecycle implementations in Healthcare, Retail, Supply Chain Management, Insurance, Transport, and Finance domain

Worked as a Systems/Data Consultant on various CRM/ERP implementation projects

Handled data consolidation/reporting tasks using different BI tools such as Oracle BI (OBIEE/Publisher), Power BI, Actuate BIRT and Discoverer

Interact with SME and Business users through regular workshops/meetings on requirements and POC

Paticipate in Internal and External Audits of current business processes

SKILL SETS

BI/Reporting: MS Power BI, Oracle BI Publisher/OBIEE, Cognos, Tableau, Qlik, Actuate BIRT, Discoverer

Database/Warehouse: SQL Server, Oracle, Teradata, MS Access

ETL: Informatica, SAS, SSIS

ERP: SAP, Oracle E-Business Suite 12.1, D365 Finance 7 Operations

CRM: D365 CE (Sales/Service/Marketing/SCM), Siebel 8.x, Salesforce

Cloud: MS Azure, AWS, Google

Programming Languages: R (RStudio), Python, JavaScript, PL/SQL

Others: GitHub, SharePoint, Smartsheet, MS-Project, Oracle APEX, Erwin, Jira, GIS, SDLC-Agile/Waterfall, 508 compliance tools, Visual SourceSafe, Mercury tool, HIPPA Compliance, CMMI- L3/ISO 9001:2015/27001:2013 QMS standards

WORK EXPERIENCE

Powersolv, VA

BI Systems Analyst

Project: CRM-BI Implementation Support Jun 14-Present

Set up Dynamics 365 Apps for healthcare solutions – D365 Customer Service for Patient Care/Access Management, D365 for Home Health, D365 Marketing for Patient Outreach, Power BI for Patient Reports and Population Dashboard view

For upgrades and enhancements engage with business managers to gather requirements and map existing processes for gap analysis in Dynamics 365 Healthcare applications

Collaborate with business users on understanding and documenting the requirements for data extractions and subsequent reporting for analytical purposes

Work with Marketing team on customer data analysis for promoting new services via campaigns

Set up integration/connectivity for Power BI to access datasets created in SAS

Integrate Smartsheet with Excel and Teams for sharing live record updates on sheets/views

Work with team on gathering requirements and sharing BI reporting features for design and delivery of reports on dashboard with customized visualizations

Develop Power BI training and presentation materials based on use case scenarios using MS Office applications

Create a POC - prototype for showing both D365-CRM/ERP features and available functionality

Understand legacy report structures/data items in Cognos Content Store and plan migrations using Migration Assistant to Power BI with current data sources

Effectively used OLAP cubes to leverage aggregations by dimensions for detailed analysis

Create analytics reports on Dashboard based on responses from customers on offers and promotional program

Manage customer requests by defining ad-hoc and recurring tasks, assigning resources and tracking progress

Use SAS programs and SQL scripts to connect to Oracle and Teradata sources for extracting customer emails and running campaigns on Salesforce marketing platform

Utilize DAX functions and formulas with M-Power Query Editor for custom calculations and data transformation, merging, filtering and searching data

Deploy Python scripts with Pandas module functions when defining data frames to slice tables with useful data items for Power BI reports

With R scripts create custom visuals for projecting customer survey and responses by regions

Use RStudio for downloading/importing/transforming customer data for analytics to help improve service

Ensure all the designs meet required criteria by reviewing code before releasing them to production for users

Connecting to Business Objects BI Universe from Power Query and Power BI create presentation reports and charts on Dashboards

Define member roles with row-level and page level security for data protection

Research other reporting such as Tableau and Qlik for comparing with Power BI features

Build custom data models and reports in Power BI with data derived from ServiceNow

Create Rich dashboards using Tableau Desktop and prepared user stories to create compelling dashboards to deliver actionable insights

Build/publish customized interactive reports and dashboards, report scheduling using Tableau server

Create tickets in ServiceNow and resolve user issues on application modules with different levels of access

Generate reports in ServiceNow for analyzing trends and forecasting

Develop Oracle BI (OBIEE) Analysis interface for individual department user

Analyze Oracle BI Publisher report queries for migration to Power BI

Perform QA and UAT tasks on solutions developed

Design Dashboards and visuals with KPI for various department users using Power BI

Generate Dashboard Views based on private and public GitHub Repositories

Involved in configuring Sales/Field Service/Business Central modules per functional requirements

Make a data migration plan and set up ETL tasks for importing accounts and contacts data into Dynamics CRM 365 using SSIS package

Using Power Automate to customize business processes and schedule/notify/export/share reports

Use multiple data sources – Excel, SharePoint Lists, SQL server, Oracle, Teradata, AWS, SAP HANA Database, and Azure SQL data warehouse with Stored Procedures/Functions for Power BI Data Sets/Flows/Reports

Work with team on installation and subscription plans for Azure cloud and Power Platform components

Using MS 365 Admin Center manage Users/Groups and Power BI Admin portal for viewing usage metrics

Troubleshoot technical issues and provide user support as needed

Select right PowerApps environment for creating custom friendly views from various Office 365 data sources including SharePoint Online List

Help set up Development/Test/Production environment for migrating changes

Follow ITIL framework for Change Management processes and ServiceNow for working on Incident Logs

Identify key process areas with projects for improvements and participate in ISO/CMMI audits

National Archives, DC

Data/Reporting Consultant

Project: National Archive Reporting Nov 13-Feb 14

Gather information on customizations made to Siebel CRM modules – Sales/Customer Service

Understand use cases for new reporting scenarios within Siebel framework

Work with report developers to improve the quality of reports derived from different business units

Develop BI Publisher reports from various data sources including external XML data sets

Center for Medicare & Medicaid Services, MD

Oracle BI Data Analyst

Project: Hospital BI Reporting Sep 11- Sep 13

Collaborate with business areas to implement BI enterprise reporting platform

Configure OBIA to meet customer needs for Dashboard analytical reporting in OBIEE

Migrate external data sources to healthcare applications using SSIS and Informatica

With Cognos Report/Query/Analysis Studio create reports and perform analysis using healthcare providers, operations, insurance and claims data by regions/services for deploying on Dashboards

Build a migration plan to convert existing reports from Cognos and PowerBuilder to BIP

Design BIP reports based on RTF, PDF, Excel templates and those derived from government forms

Extract healthcare data from external sources to load into the reporting database using Informatica

CERTIFICATIONS

MCSE - MS Dynamics (Sales/Field Service) 365, Fairfax, VA

Siebel CRM, Burlington, MA

Systems Analysis, National Computing Center, London

Applications Programming, City & Guilds of London Institute, London

Contact this candidate