Description
menu option Build DataMart using Oracle SQL Developer to be consumed by MS Power BI financial reports and Sales dashboards. Created automated finance reports to replace the time consuming monthly finance reports that were being done in Excel. These reports were delivered in the format required by the auditors for Proconex and included Balance Sheet, Order to Cash, Parent Company Trial Balance, Ledger to Sales Reconciliation, Consolidated (Orders, Gross Sales, Commissions, Total Revenue, Total Cost, Gross Profit Plus Commissions, Total SG&A, Operating Profit). Also, Summary by Profit Center, Total by SBU, Buy-Resell Analysis, Project Analysis, Sales Support, Engineering, Market Analysis). Created report that sends an email to the sales managers when the customer credit has exceeded 90% of their line of approved credit. This reduced overstocking, lead times, and other inventory KPI's. Built highly interactive reports with row level security so the salesman could drill down and across to identify strengths and weakness. They also used the reports to confirm accurate individual sales commissions for profit sharing incentives. Configured data gateway and set up security roles for entire project users using row level security. Worked closely with Director of Business Operations to gather and refine the requirements. Trained IT staff on the administration piece of MS Power Bi including group and row level security, and system administration. Created variants of the dashboards for C-Level and mid-level management and salesman dashboards and reports. Quickly added value to existing reporting capabilities. Worked on Sales, Project Tracking, Employee Utilization, and Cycle time data. IT Professional with more than 6 years of experience working on designing and developing database applications with strong background in Database Architecture, Design, Development and Administration. Experience in working for various vertical markets such as Process Automation Health Care, Retail, Financial, Nuclear, and Pharmaceutical. Experienced in Developing Power BI Reports and Dashboards from multiple data sources using Data Blending. Creating and deploying parameterized reports using power BI and Tableau. Created hierarchies in Power BI reports using Data visualizations like Bar chart, Line chart, pie charts, forecast charts and created custom visualizations using R-Script Visualization etc. Experienced in Creating DAX Expressions, create Date to yearly columns and implement partitions in Tabular Models for power BI. Created dynamic report titles in Power BI. Experience on publishing Power BI reports of dashboards in Power BI server and Scheduling the dataset to refresh for upcoming data in power BI server. sorting the data and defining subtotals in Power BI. Responsible for creating and changing the visualizations in Power BI reports and Dashboards per the client Requirements. Experienced on Microsoft Business Intelligence Suite (Power Pivot Power View Power Query Power Maps Power BI Desktop Power BI Service Power BI Mobile App) Experience in creating Tabular Reports Matrix Reports Parameterized Reports Sub Reports Global map reports in both Power BI Desktop and Power BI Cloud service. Robust MS Access and excel skills with Power pivot PivotTable PivotChart Power view VLOOKUP with many other functions and formulas. Client was using SAP BW 3.5 and wanted to simplify financial pro forma reporting and business analysis by using Web Intelligence Universes and Reports. Developed many financial reports based on BEx queries.