Power Bi Data Visualization
Resume:
Saumil Gogri
PROFILE
Accomplished data and analytics professional with over 7 years of experience in database development, data mining, and data visualization, specializing in SQL (T-SQL, PL/SQL), Power BI, Tableau, and advanced MS Excel. Demonstrated expertise in designing and implementing data pipelines, APIs, and automated reporting processes that drive operational efficiency and strategic decision-making across organizations. Skilled in financial modeling, forecasting, and building comprehensive data management systems to support detailed financial analysis and reporting. Proven track record in optimizing workflows and creating interactive dashboards that translate complex data into actionable insights for senior leadership and non-technical stakeholders. Adept at cross-functional collaboration, stakeholder management, and mentoring teams, with a strong focus on innovation and continuous process improvement to achieve measurable business impact. SKILLS AND TECHNOLOGY
• Programming Languages: T-SQL, PL/SQL, No-SQL, Postgres, VBA, M-Query, DAX, Power Query, Python
• Design Tools: MS Visio, MS Project, Rational Requisite Pro, Power Automate
• DBMS: MS SQL Server, MS Access, Sage XR, Oracle
• Reporting: Power BI, Tableau, QlikView, MS Excel (Array functions, Pivots), Smartsheet, JIRA (Stories, Issues)
WORK EXPERIENCE
Asst. Manager / Sodexo, Mumbai, IND Sep 2023 – Present
• Led the integration of Power BI with Dynamics 365, enabling real-time data visualization and reporting, significantly reducing manual reporting efforts by 30%.
• Developed and tested data pipelines and API connections for seamless database management across 15 countries in Asia Pacific, Middle East, and Southeast Asia. Reduced data processing time by 40% through the development of automated ETL processes, optimizing data integration from multiple sources and ensuring data accuracy.
• Created financial models and Power BI dashboards to provide management with insights, comparing forecasts and budgets with actuals, enhancing data-driven decision-making.
• Designed and optimized complex SQL queries and stored procedures for efficient data retrieval and reporting.
• Collaborated with cross-functional teams to define data requirements, establish best practices for data governance and security, and improve customer experience.
• Trained and mentored junior analysts, fostering a culture of continuous learning and improvement.
********.*****@*****.***
https://www.linkedin.com/in/saumilgogri
Sr. Business Analyst / Abhinandan Exim, Mumbai, IND Apr 2021 – Sep 2023
• Redesigned and optimized forecast models using SQL, Pivot Tables, Array functions, and VBA Macros, improving the accuracy of forecasting and the impact of key performance indicators (KPIs) by 30-40%.
• Architected and developed robust database systems, including comprehensive data mapping, the creation of data lakes, and data warehousing solutions, resulting in improved data accessibility, integrity, and overall efficiency.
• Automated critical processes in ERP systems through the implementation of stored procedures and triggers using T-SQL and PL/SQL, managing large datasets, and enhancing the speed and accuracy of data processing and reporting.
• Developed dynamic dashboards and reports to visualize complex datasets, providing stakeholders with actionable insights and driving informed decision-making across departments.
• Led in-depth research initiatives to capture and document stakeholder requirements, standard operating procedures (SOPs), and data access rules, ensuring alignment with organizational goals and compliance standards.
• Advised cross-functional teams on best practices for database management, providing training and guidance on the use of database management tools and query optimization techniques to support the development of scalable and efficient data solutions.
• Collaborated with IT and business teams to implement data governance frameworks, establish data quality controls, and standardize data collection processes, resulting in a 25% reduction in data inconsistencies.
• Streamlined data workflows and processes by integrating advanced analytics tools and technologies, reducing manual data handling by 50% and increasing overall team productivity. Business Process Analyst II - FinOps / Russell Sigler’s Inc., Tempe, AZ – USA Nov 2018 – Feb 2020
• Optimized cross-departmental workflows and processes using MS Project, BPMN, SQL, and Power Query, significantly enhancing data integrity and reducing operating costs by automating manual tasks and eliminating redundancies.
• Designed, managed, and implemented supplementary data reports, integrating multiple data sources, including ERP systems, CRM platforms, and external data feeds, to improve reporting efficiency, accuracy, and transparency across the organization.
• Developed and maintained complex SQL Views, stored procedures, and custom tables for periodic and ad-hoc reports, facilitating effective data management and ensuring timely access to critical business insights for key stakeholders.
• Created and enhanced financial applications for detailed analysis and reporting, leveraging SQL Server, MS Excel (including VBA Macros), and Power BI to produce dynamic dashboards and visualizations, enabling data-driven decision-making for senior management.
• Streamlined data extraction, transformation, and loading (ETL) processes to support robust data pipelines, reducing data processing time by 40% and increasing the reliability and accuracy of financial data.
• Collaborated with business units to gather requirements and refine reporting frameworks, ensuring alignment with strategic objectives and delivering insights that directly contributed to a 15% increase in operational efficiency.
• Conducted training sessions and workshops to upskill teams on the use of Power Query and advanced Excel functions, fostering a culture of data literacy and self-service analytics.
• Led initiatives to standardize data reporting practices and enhance data governance, reducing data discrepancies by 30% and improving compliance with industry standards. Financial Analyst II / First American Title, Scottsdale, AZ - USA Mar 2018 – Nov 2018
• Implemented an automated payroll system for a workforce of 3,000 employees, streamlining the calculation and distribution of salaries, bonuses, and commissions. This initiative led to a reduction in payroll processing time by 50% and identified cost-saving opportunities that decreased payroll expenses by 15%, thereby improving financial models.
• Developed dynamic dashboards and reports using SQL Server, Power BI, and MS Excel to monitor and forecast revenue, expense trends, and financial KPIs, providing real-time insights that supported strategic financial planning and analysis.
• Redesigned and optimized financial database systems by creating custom SQL queries, scripts, and stored procedures, enhancing data integrity and enabling the automation of complex reports. This resulted in a 40% reduction in manual reporting time and improved accuracy in financial data.
• Automated key financial and operational reports through advanced VBA scripting and MySQL, improving data accessibility and enabling faster decision-making processes for the finance and management teams.
• Prepared comprehensive business requirement documents and process workflow diagrams to document financial and operational processes, identifying and implementing areas for process improvement, which led to a 20% increase in operational efficiency.
• Collaborated closely with cross-functional teams including HR, finance, and IT, to ensure seamless integration of the new payroll system with existing ERP systems, enhancing data synchronization and reporting capabilities.
• Led data migration and system testing efforts to transition from legacy payroll systems to the new automated solution, ensuring minimal disruption to payroll cycles and compliance with labor laws and regulations.
• Provided training and support to end-users on the new payroll and reporting systems, improving user adoption rates and reducing system-related queries by 30%.
• Enhanced data governance and security protocols within financial systems to comply with internal audit requirements, ensuring the protection of sensitive employee and financial data. ICT Business Analyst / UNICEF, New York, NY – USA Sep 2017 – Mar 2018
• Analysed business processes using BPMN tools like Visio and MS Project, assessing the impact on users and stakeholders.
• Built process workflow charts and data-flow diagrams for business users, improving process documentation. Co-ordinated project tasks and deliverables, identified and documented project constraints, assumptions, business impacts, risks, and scope EDUCATION
Master of Science (Management Information Systems) University of Illinois, IL, USA - May 2017 Bachelor of Engineering (Information Technology) University of Mumbai, Mumbai, IND - May 2014
Contact this candidate