Power Bi Data Analytics

JAVALI MANNAM

****************@*****.***

+1-316-***-**** LinkedIn: javali-mannam1305

PROFESSIONAL SUMMARY

Experienced Data Analytics Developer with over 3 years of expertise in SQL and SSRS projects, developing and maintaining robust reports and dynamic dashboards.

Proven track record of automating data extraction and transformation processes with Power BI, Python

(Pandas), and Tableau, enhancing efficiency by 30%

Expert in writing and optimizing complex SQL queries to retrieve and manipulate large datasets from Azure Synapse Analytics, MSSQL, Oracle, and PostgreSQL databases

Extensive expertise in Tableau reporting, proficient in handling measures, dimensions, hierarchies, transformations, filters, prompts, calculated fields, sets, groups, and parameters.

Skilled in managing filters, calculated columns, measures, relationships, and transformations within Tableau’s Edit Query section.

Designed interactive dashboards and real-time visualizations with Power BI and Tableau, driving data-informed decision-making

Designed and developed Power Platform applications, supporting data workflows and business intelligence solutions.

Conducted in-depth exploratory data analysis (EDA) using Python and Scikit-Learn to uncover patterns and insights for strategic business decisions.

Utilized advanced data manipulation techniques to enhance data quality, automate workflows, and support BI solutions.

Proven ability to gather and analyze complex business requirements, delivering data-driven solutions that align with business objectives.

Documented data processes and contributed to data governance standards within ERP systems, ensuring compliance with organizational policies.

Collaborated effectively with data scientists, engineers, and business stakeholders to align data insights with business goals and address organizational challenges.

Strong technical background complemented by a deep understanding of public safety and technology systems. TECHNICAL SKILLS

Communication &

Collaboration

Effective liaison between business stakeholders, IT teams, and vendors Methodologies Agile (Scrum), Scaled Agile Framework, Kanban Project Management Tools: JIRA, Microsoft Visio, SharePoint, G Suite, PowerPoint, Azure DevOps, Microsoft Teams, Outlook

Database Management MySQL, SQL Server, PostgreSQL, Oracle, Snowflake Data Governance Data Analysis & Visualization Tools: Excel, Power BI, Looker, AWS Quick Sight, SAP Business Objects, Tableau, Data Bricks, Data mapping, Data flow Languages: Python (pandas, NumPy, matplotlib), SQL, R

Data Processing & Analytics Azure, AWS Redshift

Testing & Quality Assurance Test Case Development, UAT, Regression Testing, Quality Assurance Development & Automation VBA Programming, SQL Queries, System Prototypes, Microsoft Technologies: Power Apps, Power Automate (Power Flows), Visual Studio CRM & ERP Systems Dynamics 365 CRM (Sales and Marketing), ERP Systems Documentation & Training Adobe Acrobat, User Manuals, Training Materials Additional Tools &

Technologies

Git, VLOOKUP, Pivot Tables

Certifications:

SQL Essential Training, Python for Everybody (University of Michigan), Learning Regular Expressions, python for Data Science, AI Development IBM-Coursera, power BI(PWC), Tableau Desktop Specialist, Social Media marketing by meta

Education:

Master’s in data science - USA

Wichita State University

PROFESSIONAL EXPERIENCE

Client: Synovus Bank, Columbus, GA January2024 – Current Role: Data Analyst

Description: As part of Analytical team, Collected and transformed large datasets using AWS Redshift, SQL, PostgreSQL, and MSSQL; automated processes with Tableau, Power BI, Python, and Excel, enhancing efficiency by 30%. Developed predictive models and interactive dashboards, managed databases, and automated reporting task, achieving a 40% reduction in manual work. Responsibilities:

Managed data from diverse sources, including files and RDBMS systems (MSSQL Server, Oracle, AWS Redshift), ensuring seamless integration and efficient data handling to support reporting and analytics in tools like Power BI and Tableau.

Leveraged SQL, AWS Redshift, and Azure Synapse for data preparation and integrated external sources into Snowflake, enhancing reporting capabilities and ensuring robust data flow validation across systems.

Developed advanced Tableau dashboards and Domo-like data visualizations to proactively identify and address business challenges, enhancing user engagement and achieving strategic objectives.

Performed data quality analysis and validation with Excel, SQL, and AWS Redshift, including count validation, dimensional analysis, and comprehensive data quality checks during data migration, ensuring consistency and accuracy.

Automated data processing workflows using Python, Power Automate, and AWS Redshift, reducing manual tasks by 40% and improving data accuracy and operational efficiency.

Developed data processing pipelines with Python (Pandas, NumPy), Azure Data Factory, and AWS Redshift for in-depth data analysis, producing critical insights that support data-driven business strategies.

Reviewed and optimized existing data processes in Power BI, resulting in a 40% reduction in manual data entry and reporting errors, significantly improving reporting accuracy and efficiency.

Conducted in-depth KPI performance analysis using SQL, Power BI, and AWS Redshift, identifying trends and delivering insights that supported both strategic and operational decision-making.

Managed, cleaned, and analyzed large datasets to enhance CXEC reporting, providing key insights to internal stakeholders that informed and improved decision-making. Environment: PostgreSQL, Snowflake Aws Redshift, Tableau, Power BI, Python, Power Platform, JIIRA, Agile Client: Microsoft, Hyderabad January2021 – August 2022 Role: Data Analyst

Description: As a part of Microsoft analytics team, developed advanced tableau data models and semantic BI solutions, implementing Star schemas, designing visualization. Leveraged M Query, DAX, and Python to improve reporting and integrated unstructured data sources Responsibilities:

Collected, cleaned, and transformed large datasets using tools such as Azure Data Factory, SQL, PostgreSQL, and MSSQL, ensuring high-quality and consistent data for analysis.

Automated data extraction and transformation processes using Power BI, Python (Pandas), and Excel, reducing manual effort and increasing efficiency by 30%.

Prepared monthly balance sheet reconciliations, ensuring alignment between financial records and inventory reports.

Collaborated with stakeholders to drive process innovations, reducing manual effort by 30% and improving data accuracy.

Conducted in-depth analysis using Python (Pandas, SciKit Learn) to uncover patterns, trends, and actionable insights that guided business decisions.

Designed interactive dashboards and real-time visualizations using Power BI and Tableau, enhancing data- driven decision-making for stakeholders.

Ensured secure, efficient, and structured access to data by managing MSSQL, PostgreSQL, and Oracle databases.

Automated recurring data analysis and reporting tasks using Azure, Python, and ERP systems, reducing manual work by 40%.

Set up and monitored Key Performance Indicators (KPIs) using Azure Monitor and Power BI, ensuring timely reporting and problem resolution.

Environment: Azure, SQL, PostgreSQL, MSSQL, Power BI, Tableau, Kanban, python and excel

Contact this candidate