Rohit Puri

About Rohit Puri

Rohit is a seasoned data analytics professional with extensive experience in analyzing, designing, developing, and implementing successful enterprise BI solutions. He is dedicated to delivering actionable, accurate, and data-driven insights that empower business leaders to achieve their strategic objectives. With a solid background in analytics, Rohit excels at querying and transforming large data sets for analysis and creating clear visualizations that convey compelling business narratives. He is also an effective communicator, skilled at managing relationships among strategic leaders, cross-functional teams, and external stakeholders. Areas of Expertise: • Expertise in enterprise Business Intelligence and Data Science concepts. • Strong experience in building large-scale business intelligence & analytical solutions. • Finance, Sales, and Marketing Operational Dashboards, Scorecards, and KPIs. • Advanced Analytics (Tableau, Power BI, Chartio, SQL, Python, PostgreSQL, Redshift) • Business Processes and Data Modeling • Business Operations and Improving Customer Experience • BI Project Management • Advance MS Excel Skills (Index, Match, VBA’s, Macros) • Strategy, Problem Solving, and Leadership Skills. Technical Stack: • Programming: SQL, Python, DAX • Databases: MySQL, Data Verse, PostgreSQL, Redshift, Azure, SQL Server • ETL Platforms: Tableau Prep Builder, Power Platform Data Flows, Power BI Data Flows • Business Intelligence & Reporting: Tableau, Power BI, Chartio, Business Objects, MS Excel (Index/Match/VBA)• CRM Tools: NetSuite, HubSpot • Data Science tools: Python (Pandas, NumPy, Seaborn, Matplotlib, Scikit-Learn) • Algorithms/Analytical Techniques: Regression Analysis, Correlation, Classification, Clustering, Decision Trees, Random Forest, A/B testing, Statistical Analysis, User Segmentation, and Funnel Analysis. • Other Platforms: Smart Sheets, Google Sheets (GSheets) • Certifications: Tableau, Advance DAX, Google Analytics

Experience

1. Sr Analyst Iii Team Lead, Business Intelligence

   E2 Consulting Engineers, Inc.

   Apr 2022 — Present · San Diego, CA, US

   Designed architectures and developed self-service analytics platforms that integrated data from disparate sources enabling faster and seamless data access.• Lead reporting migration to Power BI Services and successfully moved ~ 10+ reports, transformed and consolidated dashboards resulted to be more efficient.• Developed front end interface using Power Apps for the business users that enabled them to seamlessly interact with the backend (Data Verse Platform).• Created ETL processes focusing on advance data mapping and data blending from cross functional platforms using Power Platform / Power BI data flows.• Implemented deployment pipelines that enabled faster cross environment data migration.• Built business application that leveraged Power Apps and Power Automate flows for executing any business data flows / datasets in the ecosystem.• Customized reports that enabled business users to refresh the reports by both on-demand / automated refresh schedules.

Education

• PES University

  Bachelor of Engineering (B.E.), Information Technology

  2007 — 2011

• Naveen Jindal School of Management, UT Dallas

  Masters of Science, Information Technology and Managment

  2015

Skills

• Tableau
• R
• R-Studio
• Murex 2.11
• Html
• Front Office
• Sdlc
• Sql
• Software Development Life Cycle (Sdlc)
• Windows
• User Acceptance Testing
• Microsoft Office
• Xml
• Testing
• Jira
• Murex
• Data Warehousing
• Information Technology
• Java
• Etl
• C
• Data Visualization
• Business Objects
• Unix
• Data Modeling
• Business Intelligence
• Microsoft Sql Server
• Rattle
• Teamwork
• Data Mining
• Google Analytics
• Regression Testing
• C++
• Data Analysis
• Erwin
• Web Analytics