Summary
Overview
Work History
Education
Skills
Timeline
Generic
Venkat Chintalpati

Venkat Chintalpati

Power BI Developer
Princeton,NJ

Summary

Experienced Sr. Power BI Developer with 18 years of experience creating advanced dashboards and reports on Power BI, SSRS, Cognos, and Tableau. Specialized in data visualization and analytics for on-premises and cloud environments. Skilled in collaborating with teams to solve problems, troubleshoot issues, and refine technical deliverables.

Overview

18
18
years of professional experience

Work History

Sr. Power BI Developer

Associated Press
NYC, NY
06.2024 - Current
  • Led the automation of financial reporting from Excel to Power BI across multiple sources, including SharePoint and SAP, resulting in a 30% reduction in reporting time and enhanced data visualization for improved financial decision-making.
  • Enhanced the Power BI Premium per user Capacity service account by optimizing user permissions and streamlining report performance, resulting in faster data insights for over 200 users.
  • Collaborated with stakeholders to gather user requirements, designed a Power BI solution that streamlined reporting by 30%, and provided actionable insights to enhance decision-making.
  • Created a structured Aging Buckets Table with calculated metrics for effective aging analysis, enhancing visibility into accounts receivable trends and supporting timely decision-making.
  • Spearheaded projects that enhanced workflows, resulting in a 20% increase in team efficiency by implementing hierarchical scope levels and dynamic aging buckets across three departments.
  • Created interactive reports and dashboards using Power BI that streamlined analysis of receivables, collections, and sales representative performance for global customer data, enhancing strategic decision-making.
  • Transformed existing SAP BI reports into dynamic Power BI Analytics, enhancing data visualization and accessibility for improved decision-making.
  • Enhanced reporting capabilities by transforming data using M queries in Power BI Service & Desktop, and strategically built Customer, Sales Rep, and GL Account hierarchies that streamlined data access and improved insights for end-users.
  • Spearheaded version control for Power BI Desktop files using Azure Repos, boosting team collaboration and minimizing errors in data reporting.
  • Leveraged Direct Query, Import, and Live Connection modes to create impactful reports and dashboards, improving data accessibility and enhancing decision-making across teams.
  • Engineered a star schema for data modeling within Power BI, integrating 5+ data sources to enhance reporting speed and deliver actionable insights for strategic decision-making.
  • Developed innovative calculated columns and measures using DAX expressions, enhancing reporting accuracy and streamlining data analysis processes.
  • Enhanced user experience by optimizing DAX expressions and tuning dashboard performance, leading to a 30% reduction in load times and improved responsiveness for end users.
  • Implemented Row-Level Security on Power BI dashboards and Power Apps, enhancing data security for over 200 users and empowering tailored insights for informed decision-making.
  • Executed administration tasks, including creating dynamic workspaces and establishing deployment pipelines, enhancing user access for a team of 50+ users, while collaborating with the Microsoft Support team to swiftly resolve environmental issues.
  • Developed and optimized T-SQL scripts to streamline data workflows and improve query performance by 30%.
  • Transformed and prepared large datasets using Databricks, enabling insightful visualizations that drove data-driven decision-making and improved analytical reporting.

Sr. Power BI Developer

Hudson Insurance (Odyssey Group)
01.2024 - 05.2024
  • Spearheaded the Financial Report Modernization project, streamlining General Ledger account reporting by automating Excel processes into Power BI, integrating data from SharePoint, Excel, and SAP, resulting in faster reporting cycles and enhanced data accuracy.
  • Enhanced the Power BI Premium per user Capacity service account by optimizing user permissions and streamlining report performance, resulting in faster data insights for over 200 users.
  • Developed dynamic reports and dashboards on GL account workbooks, boosting decision-making efficiency by 30% across diverse product lines.
  • Developed effective risk assessment strategies and determined competitive premiums for property and casualty insurance, leading to a 15% increase in policy uptake, while designing Aging Buckets in Power BI to uncover actionable insights for enhanced decision-making.
  • Led Daily Scrums and Bi-Weekly Sprint Planning, enhancing workflows by 20% and boosting team collaboration.
  • Collaborated with 2+ stakeholders to gather user requirements, analyze needs, and design a Power BI solution that streamlined reporting processes and enhanced data visualization for informed decision-making.
  • Enhanced data accessibility and reporting efficiency by building hierarchies through stored procedures and creating user-friendly views for PBI Live connection, empowering teams with faster insights.
  • Spearheaded version control for Power BI Desktop files using Azure Repos, boosting team collaboration and minimizing errors in data reporting.
  • Proactively resolved version errors using Visual Studio, enhancing the data modeling and report design in Power BI, which improved report accuracy and user satisfaction.
  • Developed innovative calculated columns and measures using DAX expressions, enhancing reporting accuracy and streamlining data analysis processes.
  • Enhanced user experience by optimizing DAX expressions and tuning dashboard performance, leading to a 50% reduction in load times and improved responsiveness for end users.
  • Designed and implemented seamless data integration pipelines between Azure Data Lake and Power BI, enabling efficient data analysis and visualization.
  • Enhanced data security and user experience by implementing Row-Level Security (RLS) on 10+ Power BI dashboards, allowing tailored access for over 300 users.
  • Executed administration tasks, including creating dynamic workspaces and establishing deployment pipelines, enhancing user access for a team of 20+ users, while collaborating with the Microsoft Support team to swiftly resolve environmental issues.
  • Optimized parameters in DEV, UAT, and Production environments in Power Query, enhancing data handling efficiency by 30%.
  • Optimized data transformation processes in Power Query and Advanced Editor, enhancing reporting efficiency by 50% and ensuring accuracy in data analysis.
  • Proactively led weekly status reviews and daily sync meetings with Business Relationship Managers and Directors, fostering collaboration and enhancing project visibility to drive successful outcomes.

Sr. Power BI Developer

CBRE
10.2020 - 12.2023
  • Collaborated on global projects, including Ethics & Compliance, PeopleSoft, Talent Coach, and Data Quality initiatives, enhancing data integrity across NA, LATAM, APAC, and EMEA, while supporting streamlined operational efficiencies.
  • Leveraged data from Talent Coach and NAVEX to enhance employee contributions by 15%, aligning with key organizational goals.
  • Enabled HR & Compliance teams to streamline reporting processes by automating 15+ legacy system reports using Power BI, significantly reducing report generation time and increasing data accuracy.
  • Transformed and automated a suite of Tableau reports into dynamic Power BI dashboards and visualizations, enhancing reporting efficiency and user engagement.
  • Developed a dynamic Power BI proof of concept to seamlessly connect with a Snowflake database, enabling insightful data consumption that enhanced analytics and informed strategic business decisions.
  • Created automated workflows that seamlessly connected Databricks with Power BI, slashing data processing time by 50% and boosting overall data analytics efficiency.
  • Crafted impactful reports and dashboards, such as Executive Summary and Talent Health Scorecard, that empowered stakeholders to drive data-informed decisions and enhance organizational effectiveness.
  • Pioneered innovative end-to-end solutions using Power Platform tools, driving a 20% increase in operational efficiency through streamlined processes and improved user workflows.
  • Enhanced data quality by implementing Alteryx-based cleansing and validation processes, achieving a 30% reduction in errors and ensuring more reliable analytics.
  • Led an offshore team by providing comprehensive technical support and mentorship, resulting in a 20% increase in project delivery speed and team confidence.
  • Enhanced data security for over 1100 users by implementing Row-Level Security (RLS) on Power BI dashboards, ensuring tailored access to sensitive information.
  • Crafted engaging complex dashboards utilizing advanced features like Bookmarks, aligning with company branding standards to enhance user experience and elevate data-driven decision-making.

Sr. BI Developer

Department of Social Services(HRA)
Brooklyn, NY
09.2016 - 09.2020
  • Contributed to the Work Tracking System Phase 3 project for the Commissioner Office’s POS team, automating sales budget allocation reports through Power BI, resulting in improved sales performance analysis and streamlined reporting processes for field officers across assigned boroughs.
  • Transformed and automated over 20 Management Console reports using IBM Power Builder and Power BI, enhancing data visualization and streamlining decision-making processes.
  • Partnered with business users to identify and refine 20+ POS application requirements, boosting system functionality by 30% and enhancing user satisfaction.
  • Spearheaded the transition from Cognos Analytics to Power BI, enhancing data visualization capabilities and streamlining reporting processes for improved business decision-making.
  • Spearheaded user requirement gathering and designed a software solution that improved system efficiency by 25% and boosted user satisfaction ratings.
  • Streamlined data extraction from OLTP and OLAP systems and orchestrated scheduled jobs to trigger packages and stored procedures, enhancing reporting accuracy and efficiency.
  • Streamlined data integration by transferring over 1 million records from diverse sources like Oracle and MS Excel into SQL Server 2012, enhancing accessibility and reporting efficiency for users.
  • Developed and enhanced over 50 Power BI reports and dashboards using SQL Server and Tabular SSAS, delivering compelling insights that informed strategic business decisions.
  • Designed and implemented Table, Matrix, Bar, and Gauge visualizations in reports, enhancing data clarity and driving informed decision-making for project stakeholders.
  • Transformed user experience by creating custom visualizations, boosting data analysis efficiency by 25% with multi and hierarchy slicers.
  • Developed and optimized DAX expressions, including filters and mathematical functions, to streamline reporting processes, resulting in a 20% increase in data retrieval efficiency.
  • Engineered a DAX-calculated column that reduced data analysis time by 30%, enhancing reporting insights for informed business decisions.
  • Designed and developed SQL Server Integration Services (SSIS) packages that optimized data processing, utilizing key control flow tasks and data flow transformations to enhance data accuracy and streamline workflows.
  • Streamlined data processing by implementing Event Handlers and robust Error Handling in SSIS packages, enhancing user communication by effectively notifying targeted communities about process results.
  • Created and launched 10+ interactive matrix and tabular reports using SSRS, incorporating drill down and drop- down features to enhance data accessibility, empowering stakeholders to make informed decisions more efficiently.

Sr. BI Report Developer

JP Morgan Chase
Newport, NJ
10.2015 - 09.2016
  • Spearheaded automation of reports for GCRM, CATTS, ELA, and the Sales team using Power BI, streamlining processes and reducing report generation time by 30%.
  • Transitioned reports from QlikView to Power BI, enhancing data accessibility and visualization while streamlining reporting processes for improved decision-making.
  • Led the migration of legacy QlikView reports to Power BI for capital markets teams, enhancing data accessibility and visualization capabilities.
  • Led the development lifecycle, from gathering requirements to designing and deploying solutions, successfully delivering projects that enhanced system efficiency and met user needs.
  • Contributed to the creation of 10+ data dashboards by extracting and integrating insights from multiple sources, enhancing data-driven decision-making across the team.
  • Designed and developed Power BI dashboards focused on key Capital Markets metrics such as trade volumes, client profitability, sales performance, and liquidity trends.
  • Designed and implemented dynamic dashboards to track sales performance metrics, leading to a 20% increase in sales quota achievement for the Commissioner Office.
  • Delivered real-time KPI dashboards to senior management, enabling data-driven decisions in sales strategy, client segmentation, and market penetration.
  • Designed and presented insightful visualizations on market trends, demographics, and pricing strategies, effectively driving a 15% increase in marketing campaign engagement and supporting informed sales strategy adjustments.
  • Developed advanced visualizations for sales quota data using Power BI to identify trends, enabling strategic decision-making and boosting sales performance.

Sr. BI Developer

Johnson & Johnson
Raritan, NJ
09.2014 - 09.2015
  • Led the successful retirement of LIMS & GLIMS at multiple sites in Malvern, Vacaville, Raritan, and Brazil, enhancing operational efficiency and minimizing disruption during the transition.
  • Converted 20+ reports from Crystal Reports into engaging Power BI visualizations, enhancing data accessibility and decision-making for stakeholders.
  • Boosted Power BI performance by 30% through the creation of user-friendly reports and quick resolution of data issues, ensuring timely report delivery.
  • Boosted user satisfaction by 20% through strategic ticket resolution management and implementing process enhancements that streamlined workflows.
  • Enhanced Power BI Report development by analyzing key datasets through the Crystal Reports Application, resulting in more accurate and actionable insights for stakeholders.
  • Designed and implemented Power BI data models, reports, and dashboards that streamlined reporting processes and provided actionable insights, facilitating data-driven decision-making for stakeholders.
  • Managed user access in Power BI, optimizing 20+ report instances to improve accessibility by 30% and boost stakeholder visibility.
  • Enhanced data security for over 200 users by implementing row-level security on Power BI dashboards, ensuring tailored access to sensitive information.
  • Created interactive dashboards for Clinical Trial data, enhancing collaboration and communication between marketing and supply chain units, resulting in improved project alignment and efficiency.

Reporting Specialist

Avaya
Basking Ridge, NJ
04.2011 - 09.2014
  • Collaborated with business customers to design and implement Business Layers, Portals, and comprehensive reports and dashboards using the COGNOS BI authoring suite, resulting in enhanced data insights and decision-making.
  • Leveraged expertise in relational and dimensional databases to enhance data retrieval efficiency and improve overall data integrity.
  • Collaborated with the Distribution channel to automate weekly and monthly partner credential status updates in Salesforce, streamlining processes and reducing manual effort by 30%.
  • Created dynamic visualizations for the Regional Marketing and Sales Team, leading to a 20% improvement in campaign analysis and enabling data-driven decision-making.
  • Developed and published a Segmentation and DMR Model through Framework Manager, enabling the HR team to streamline talent acquisition strategies and enhance data-driven decision-making.
  • Implemented Data Level and Object Level Security in Framework Manager through macros, enhancing data protection for over 100 users and ensuring compliance with industry standards.
  • Developed and refined PL/SQL code to optimize data loading processes, enhancing overall system efficiency and ensuring accuracy in the metadata model.

Sr.BI Report Developer

Verizon Wireless
Orangeburg, NY
06.2008 - 03.2011
  • Drove the creation of engaging Learning Modules for HRDW, boosting employee training effectiveness and significantly increasing knowledge retention rates.
  • Led the seamless transition of 100+ Cognos packages, reports, and cubes from Report Net to Version 8, boosting system efficiency by 30% and elevating user satisfaction scores based on positive feedback.
  • Developed impactful analysis reports in Metric Studio and standard reports in Report Studio, while streamlining the migration process across various environments, leading to improved accessibility and enhanced performance for users.

Sr.BI Developer

Pfizer
01.2007 - 05.2008
  • Crafted a DMR Framework model to streamline the HR Hierarchy, enhancing organizational efficiency and communication pathways across departments.
  • Analyzed and synthesized data sources for diverse packages, empowering the team with clear documentation that improved project efficiency by 25%.
  • Developed detailed functional requirements documentation and comprehensive test cases, enhancing project clarity and ensuring quality assurance for successful software deployment.
  • Engaged with over 50 users to analyze requirements, boosting project success by 30% and increasing user satisfaction scores by 25%.
  • Engineered insightful drill-through reports from Analysis Studio data to streamline decision-making processes and enhance analytical capabilities.
  • Managed user sign-on information for over 200+ users, streamlining access privileges for data sources, which reduced access issues and enhanced data security.
  • Enhanced Cognos 8 report performance by reducing loading times by 30%, resulting in faster access to insights for end-users and improving overall reporting efficiency.
  • Developed comprehensive standard reports in Report Studio for financial analysis, enhancing visibility into key metrics and supporting data-driven decision-making.
  • Streamlined the migration of over 50 reports across various environments, enhancing data accessibility and reporting efficiency for cross-departmental teams.
  • Delivered engaging face-to-face and online training sessions to empower 30+ Adhoc users in crafting impactful reports using Report Studio and Query Studio, enhancing their analytical skills and efficiency.

Programmer Analyst

CIGNITI
01.2006 - 06.2006
  • Transformed business needs into tailored report specifications, enhancing decision-making processes and driving strategic initiatives.
  • Developed detailed functional requirements documentation and comprehensive test cases, enhancing project clarity and ensuring quality assurance for successful software deployment.
  • Conducted a thorough analysis of source data, successfully identifying and resolving critical issues that enhanced data accuracy and improved overall operations.
  • Collaborated with Database Architects to engineer a Dimensional Framework, improving data accessibility by 30% and boosting analytical capabilities.
  • Designed and implemented comprehensive dashboard reports for the sales team, resulting in a 20% increase in reporting efficiency and enhanced decision-making capabilities.
  • Configured web and app servers to optimize performance and installed the Content Store, resulting in a 20% increase in system efficiency and improved user accessibility.

System Analyst

HDFC Standard Life Insurance
08.2004 - 12.2005
  • Facilitated the generation of ad-hoc reports for 200+ users, reducing reporting time by 30% using a new reporting framework.
  • Spearheaded the retirement of outdated reporting applications, delivering innovative reports through Report Net that enhanced data accessibility and streamlined decision-making for users.
  • Managed user sign-on information for over 200+ users, streamlining access privileges for data sources, which reduced access issues and enhanced data security.
  • Resolved 15+ functional issues that improved user experience by 30%, achieving project requirements through targeted problem-solving.
  • Led collaboration with a Database Team to develop framework models, boosting data processing efficiency by 30% and reducing project workflow time by 20%.

Education

Masters in business administration, MBA -

IME
01.2000

Post Gradate Diploma - Computer Science

DataPro
01.1999

Bachelor's degree - commerce

Andhra University
01.1998

Skills

  • BI platforms: Power BI, SSRS, SSIS, MS Fabric, Tableau, Cognos, SSIS, Azure Databricks, Azure Data Lake, Alteryx
  • Databases : Oracle, Netezza, Snowflake, SQL Server, SAP BW, MS Access, Teradata
  • Snowflake, Microsoft Azure
  • Languages : SQL, PL/SQL, Python(working knowledge)
  • Agile, Service Now, JIRA
  • Windows (All Versions), UNIX
  • SQL Server Management studio, SQL Developer
  • DAX Studio
  • Tabular Editor
  • Power Apps
  • Power Automate
  • DAX (Data Analysis Expressions)
  • Version Control (Git)

Timeline

Sr. Power BI Developer

Associated Press
06.2024 - Current

Sr. Power BI Developer

Hudson Insurance (Odyssey Group)
01.2024 - 05.2024

Sr. Power BI Developer

CBRE
10.2020 - 12.2023

Sr. BI Developer

Department of Social Services(HRA)
09.2016 - 09.2020

Sr. BI Report Developer

JP Morgan Chase
10.2015 - 09.2016

Sr. BI Developer

Johnson & Johnson
09.2014 - 09.2015

Reporting Specialist

Avaya
04.2011 - 09.2014

Sr.BI Report Developer

Verizon Wireless
06.2008 - 03.2011

Sr.BI Developer

Pfizer
01.2007 - 05.2008

Programmer Analyst

CIGNITI
01.2006 - 06.2006

System Analyst

HDFC Standard Life Insurance
08.2004 - 12.2005

Post Gradate Diploma - Computer Science

DataPro

Bachelor's degree - commerce

Andhra University

Masters in business administration, MBA -

IME

Similar Profiles

CREATE PROFILE