| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
E: EMAIL AVAILABLE T: PHONE NUMBER AVAILABLEPROFESSIONAL SUMMARYExperience BI, CRM, ERP and ETL lifecycle implementations in Healthcare, Retail, Supply Chain Management, Insurance, Transport, and Finance domainWorked as a Systems/Data Consultant on various CRM/ERP implementation projectsHandled data consolidation/reporting tasks using different BI tools such as Oracle BI (OBIEE/Publisher), Power BI, Actuate BIRT and DiscovererInteract with SME and Business users through regular workshops/meetings on requirements and POCPaticipate in Internal and External Audits of current business processesSKILL SETSBI/Reporting: MS Power BI, Oracle BI Publisher/OBIEE, Cognos, Tableau, Qlik, Actuate BIRT, DiscovererDatabase/Warehouse: SQL Server, Oracle, Teradata, MS AccessETL: Informatica, SAS, SSISERP: SAP, Oracle E-Business Suite 12.1, D365 Finance 7 OperationsCRM: D365 CE (Sales/Service/Marketing/SCM), Siebel 8.x, SalesforceCloud: MS Azure, AWS, GoogleProgramming Languages: R (RStudio), Python, JavaScript, PL/SQLOthers: 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 standardsWORK EXPERIENCEPowersolv, VABI Systems AnalystProject: CRM-BI Implementation Support Jun 14-PresentSet 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 viewFor upgrades and enhancements engage with business managers to gather requirements and map existing processes for gap analysis in Dynamics 365 Healthcare applicationsCollaborate with business users on understanding and documenting the requirements for data extractions and subsequent reporting for analytical purposesWork with Marketing team on customer data analysis for promoting new services via campaignsSet up integration/connectivity for Power BI to access datasets created in SASIntegrate Smartsheet with Excel and Teams for sharing live record updates on sheets/viewsWork with team on gathering requirements and sharing BI reporting features for design and delivery of reports on dashboard with customized visualizationsDevelop Power BI training and presentation materials based on use case scenarios using MS Office applicationsCreate a POC - prototype for showing both D365-CRM/ERP features and available functionalityUnderstand legacy report structures/data items in Cognos Content Store and plan migrations using Migration Assistant to Power BI with current data sourcesEffectively used OLAP cubes to leverage aggregations by dimensions for detailed analysisCreate analytics reports on Dashboard based on responses from customers on offers and promotional programManage customer requests by defining ad-hoc and recurring tasks, assigning resources and tracking progressUse SAS programs and SQL scripts to connect to Oracle and Teradata sources for extracting customer emails and running campaigns on Salesforce marketing platformUtilize DAX functions and formulas with M-Power Query Editor for custom calculations and data transformation, merging, filtering and searching dataDeploy Python scripts with Pandas module functions when defining data frames to slice tables with useful data items for Power BI reportsWith R scripts create custom visuals for projecting customer survey and responses by regionsUse RStudio for downloading/importing/transforming customer data for analytics to help improve serviceEnsure all the designs meet required criteria by reviewing code before releasing them to production for usersConnecting to Business Objects BI Universe from Power Query and Power BI create presentation reports and charts on DashboardsDefine member roles with row-level and page level security for data protectionResearch other reporting such as Tableau and Qlik for comparing with Power BI featuresBuild custom data models and reports in Power BI with data derived from ServiceNowCreate Rich dashboards using Tableau Desktop and prepared user stories to create compelling dashboards to deliver actionable insightsBuild/publish customized interactive reports and dashboards, report scheduling using Tableau serverCreate tickets in ServiceNow and resolve user issues on application modules with different levels of accessGenerate reports in ServiceNow for analyzing trends and forecastingDevelop Oracle BI (OBIEE) Analysis interface for individual department userAnalyze Oracle BI Publisher report queries for migration to Power BIPerform QA and UAT tasks on solutions developedDesign Dashboards and visuals with KPI for various department users using Power BIGenerate Dashboard Views based on private and public GitHub RepositoriesInvolved in configuring Sales/Field Service/Business Central modules per functional requirementsMake a data migration plan and set up ETL tasks for importing accounts and contacts data into Dynamics CRM 365 using SSIS packageUsing Power Automate to customize business processes and schedule/notify/export/share reportsUse 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/ReportsWork with team on installation and subscription plans for Azure cloud and Power Platform componentsUsing MS 365 Admin Center manage Users/Groups and Power BI Admin portal for viewing usage metricsTroubleshoot technical issues and provide user support as neededSelect right PowerApps environment for creating custom friendly views from various Office 365 data sources including SharePoint Online ListHelp set up Development/Test/Production environment for migrating changesFollow ITIL framework for Change Management processes and ServiceNow for working on Incident LogsIdentify key process areas with projects for improvements and participate in ISO/CMMI auditsNational Archives, DCData/Reporting ConsultantProject: National Archive Reporting Nov 13-Feb 14Gather information on customizations made to Siebel CRM modules Sales/Customer ServiceUnderstand use cases for new reporting scenarios within Siebel frameworkWork with report developers to improve the quality of reports derived from different business unitsDevelop BI Publisher reports from various data sources including external XML data setsCenter for Medicare & Medicaid Services, MDOracle BI Data AnalystProject: Hospital BI Reporting Sep 11- Sep 13Collaborate with business areas to implement BI enterprise reporting platformConfigure OBIA to meet customer needs for Dashboard analytical reporting in OBIEEMigrate external data sources to healthcare applications using SSIS and InformaticaWith Cognos Report/Query/Analysis Studio create reports and perform analysis using healthcare providers, operations, insurance and claims data by regions/services for deploying on DashboardsBuild a migration plan to convert existing reports from Cognos and PowerBuilder to BIPDesign BIP reports based on RTF, PDF, Excel templates and those derived from government formsExtract healthcare data from external sources to load into the reporting database using InformaticaCERTIFICATIONSMCSE - MS Dynamics (Sales/Field Service) 365, Fairfax, VASiebel CRM, Burlington, MASystems Analysis, National Computing Center, LondonApplications Programming, City & Guilds of London Institute, London |
