Power Bi Business Intelligence

Pavan Kumar Goud Veluri Email: *.**************@*****.*** Phone: +1-732-***-****

Objective: To utilize my 11+ years of experience as a results-oriented Business Intelligence Developer, proficient in data visualization and ETL, to contribute to the successful delivery of BI projects and drive data-driven decision-making processes.

PROFESSIONAL SUMMARY:

Over 11 years of experience in consulting with business clients, creating reports using BI tools, and collaborating with developer teams.

Proficient in utilizing data visualization tools such as Tableau, Power BI, and Service Now reporting to create insightful and visually appealing business intelligence visualizations.

Skilled in ETL processes using MSSQL and Snowflake, contributing to the successful delivery of development, maintenance, and support projects.

Led an end-to-end integration project that seamlessly connected AWS data lake services with Snowflake data warehousing, enabling efficient data ingestion, transformation, and analytics while ensuring data security and access control

Adept at maintaining strong partner relationships, ensuring high-quality team deliverables, and meeting SLAs.

Experienced in Tableau desktop dashboard development, leveraging Rest API connectors, SharePoint, and Oracle DB for recent projects.

Well-versed in working closely with onshore partners and collaborating with multiple business partners, including anchor program managers.

Possesses expert-level knowledge in ServiceNow Reporting, enabling effective reporting and analysis.

Demonstrated ability to design and solve complex business problems using analytical techniques and tools.

Capable of working with large datasets, both structured and semi structured, from multiple sources.

Involved in the technical build-out and support of databases, query tools, reporting tools, BI tools, and dashboards, facilitating data analysis, visualization, and advanced analytics.

Proficient in maintaining and managing a report and dashboard inventory using Tableau.

Possesses strong business system consulting and business analysis skills.

With over 3+ years of experience as a Scrum Master and being certified as a Professional Scrum Master, I have successfully facilitated Agile project management processes and ensured the smooth execution of projects

TECHNICAL SKILLS:

RDBMS : Oracle 8i/9i/10g/11g/12c, Teradata, SQL Server 2008/2014, Snowflake

GUI Tools : Service Now, Pac2000, Jenkins, UCD (Urban code deployment), TFS, Jira, SharePoint, Power Apps

BI Reporting Tools : MS Power BI, Tableau Desktop & administration, Grafana & Google Data studio

Operating Systems : Windows 2000/ 2003/2010/XP/NT 4.0/98, UNIX, Sun Solaris, Linux.

PROFESSIONAL EXPERIENCE:

Client – Wells Fargo Role: Data Visualization Expert April 2022 to July-2023

Responsibilities:

Led the Centralized Reporting Project Team, overseeing the development and implementation of centralized reporting solutions within the TCOO LOB at Wells Fargo India

Developed and designed interactive data visualizations, dashboards, and reports using Tableau leveraging drag-and-drop functionality to provide actionable insights.

Conducted data cleansing and transformation, connecting to multiple data sources, and creating calculated fields and parameters to ensure accurate and reliable analysis.

Implemented data governance measures, including data source filters, blending, and joining operations, to maintain data integrity and improve data quality.

Worked closely with cross-functional teams, including data analysts, business stakeholders, and IT professionals, to grasp the requirements and objectives of the BI report migration project.

Led the initial stages of a project aimed at configuring Snowflake with AWS for data integration, defining project objectives and aligning them with organizational data analytics and warehousing needs.

Played a key role in setting up and configuring AWS services, including the creation and management of data lakes within Amazon S3. Organized data storage, ensuring structured accessibility.

Spearheaded the integration between Snowflake and AWS services, establishing a seamless connection between the two platforms, facilitating the flow of data from AWS data lakes to Snowflake.

Implemented Snowpipe for automated, continuous data ingestion into Snowflake, ensuring data integrity and quality. Orchestrated data transformation and ETL processes for efficient data utilization.

Assessed the current BI reports across various platforms to pinpoint areas for improvement, standardization, and optimization throughout the migration process.

Administered Tableau Server/Online, managing user access, security, and permissions, and ensuring smooth functioning of Tableau deployments.

Environment: Tableau Desktop/Admin, MS Power BI, MS SQL, Snowflake, Share point, Jira, AWS

Client – Wells Fargo Role: Sr Business Intelligence Developer Apr 2020 to Mar 2022

Responsibilities:

•Worked on ServiceNow reporting, utilizing data from Incident, CTASK, Change Request, and Problem Management to derive insights for prediction analysis.

•Developed Tableau reports and effective dashboards by gathering and translating end-user requirements into visual representations.

•Created visually appealing dashboards, presentations, and graphs to effectively communicate data insights.

•Devised advanced statistical techniques for data description, leveraging elements like grouping, binning, hierarchies, sorting, sets, and filters to create impactful visualizations.

•Produced regular reports based on data analysis across diverse timeframes and divisions, utilizing tools such as Power Pivot, Power Query, and Power View.

•Crafted Power BI solutions for graphical and visualization needs, aligning them with business requirements to build interactive dashboards.

•Led the requirements gathering process, formulating ad-hoc SQL query batches for updating data and metadata for delta and historical loads.

•Expertly employed Power BI and Pivot/View to create comprehensive scorecards and dashboards catering to different departmental and upper management demands.

•Created intricate data marts and multi-dimensional models, including Star and Snowflake schemas, to enhance data representation capabilities.

•Implemented diverse DAX functions for fact calculations, optimizing data visualization within Power BI.

•Demonstrated mastery in Power BI by developing reports with complex SQL joins across multiple tables, contributing to custom visual and group creation efforts.

Environment: Tableau, MS Power BI, MSSQL, SN Reporting, Snowflake, MS Azure, Splunk, Rest API

Client – Wells Fargo Role: Sr. Tableau Developer & Power BI Developer Apr-2018 to Mar-2020

Responsibilities:

Generated and maintained comprehensive documentation for data models, report designs, and data transformation procedures, facilitating knowledge transfer and future enhancements.

Planning out how to use data for reports. Making these reports look nice using Tableau software.

Conducted thorough testing and quality assurance checks on migrated reports to identify and rectify any discrepancies, inconsistencies, or errors.

Collaborated seamlessly with the data team to ensure the integration of data sources, data pipelines, and refresh schedules within the Power BI ecosystem.

Collaborated with various functions including HR, Risk, Admin, and Finance at Wells Fargo to forecast insights for each Line of Business (LOB) and present them to higher management.

Took ownership of the entire project life cycle, from business requirement gathering and analysis to design, implementation, and testing.

Engaged with business users to analyze their requirements and translate them into technical specifications.

Conducted data analysis to generate valuable insights and presented mockup dashboards to business users for finalizing requirements.

Implemented row-level security on required reports and managed permissions accordingly.

Utilized the Agile methodology to effectively manage project tasks and deliverables.

Environment: Tableau, MS Power BI, Oracle 11G, MSSQL, PL/SQL, SharePoint, Autosys

Client – Wells Fargo Role: Tableau & Power BI Developer Apr 2016 to Mar 2018

Responsibilities:

Coordinated daily with the offshore team, assigning tasks and providing guidance to ensure timely and accurate completion of work.

Provided valuable technical guidance and mentorship to junior developers and team members, nurturing a culture of continuous learning and professional growth.

Stayed abreast of the latest trends, features, and best practices in Power BI and data visualization, applying this knowledge to enhance the migration process and the resulting reports.

Created Tableau Data Extracts by leveraging SQL to query data from the Oracle database (data warehouse).

Developed calculated fields in Tableau to manipulate and transform data, enabling advanced analysis.

Designed visually compelling dashboards in Tableau, incorporating graphs and maps to provide statistical and geographic perspectives of the data.

Conducted rigorous testing and validation of data accuracy within Tableau to ensure the reliability of insights.

Published the finalized dashboards on the Tableau Server, making them accessible for widespread use and distribution.

Environment: MS Power BI, Tableau Desktop/ Tableau Server, MS SQL, ETL

Client - Wells Fargo Role: System Support Analyst Dec 2014 to Mar2016

Responsibilities:

I have extensive experience working in an End-to-End Support model using the Pac2000 ticketing system. I effectively managed and resolved various support tickets, ensuring the smooth functioning of the project.

Additionally, I have hands-on experience with TFS (Team Foundation Server), UCD (Urban Code Deploy), Terraform, Jenkins, and GitHub for efficient deployment activities. I utilized these tools to streamline the deployment process and ensure accurate and timely delivery of project artifacts.

I played a pivotal role in the development of complex reports for the entire project using Tableau. By leveraging Tableau's robust features and functionalities, I created insightful and visually appealing reports that provided valuable business insights to stakeholders.

Throughout these responsibilities, I demonstrated strong attention to detail, problem-solving skills, and a commitment to delivering high-quality results.

Environment: TFS, UCD, Terraform, Jenkins, Git Hub.

Client - Wells Fargo Associate Financial Analyst (Financial Services) Sep 2012 to Nov 2014

Responsibilities:

● Played a crucial role in the Mortgage process, diligently validating and organizing loan documents to facilitate smooth approval procedures.

● Took charge of deploying reports across the Wells Fargo home mortgage Line of Business (LOB) by utilizing Excel, ensuring accurate and timely distribution of crucial information to relevant stakeholders.

● Demonstrated my expertise by customizing reports to enhance their functionality. This included incorporating new features such as report alerts, crosstabs, running totals, sub-reports, and drill-down fields, resulting in more comprehensive and insightful reporting capabilities.

Environment: Excel, Access Oracle, SQL.

Certifications:

Tableau Desktop Certified Associate

Microsoft Power BI (PL-300)

Microsoft Azure Fundamentals (AZ-900)

Advance Excel certification sponsored by Skill Nation

Building Interactive Dashboard’s Sponsored by Skill Nation

ITIL Foundation V3 edition

Professional Scrum Master I

Microsoft Power Platform Fundamentals

Education Qualifications:

Masters in Information Technology (2012)

Bachelors in Computer Science (2010)

Contact this candidate