Data Analyst Power Bi

Siva Sai Keerthi Pathivada

Data Analyst

ABOUT ME

Results-driven and detail-oriented Data Analyst with 5+ years of experience in interpreting and analyzing data to drive successful business solutions. Proficient in statistical analysis, data mining, and data visualization using tools such as SQL, Python, R, and Tableau.

PROFILE SUMMARY

5+ years of industry experience, I possess a solid understanding of Data Analysis, Data Engineering, and Full Stack Development. Proven expertise in developing large-scale data pipelines, collaborating across teams to implement high-volume data warehouses, and delivering data-driven insights. Skilled in cloud platforms such as AWS, GCP, and Azure, as well as tools like Power BI, Tableau, DBT, and Matillion ETL. Proficient in Excel and Google Sheets, including formulas, data entry, and cleaning data, along with intermediate experience in Pivot Tables. Experienced in SQL for running queries, extracting insights, and modifying queries with basic functions. Adept at making quick decisions in fast-paced environments, with strong project management, organizational skills, and effective written and verbal communication.

Experience in different Project Management Methodologies like Traditional waterfall and Agile with expertise in Enterprise Project Management (EPM).

Very good experience and knowledge on Amazon Web Services, AWS Redshift.

Proficient in ETL processes, using SSIS, Matillion, DBT, and OLTP/OLAP system development.

Experience in using Python for data analysis, automation, and ETL processes. Familiar with SAS for statistical analysis.

Experience in designing Star Schema, Snowflake schema for Data Warehouse, by using tools like Erwin data modeler, Power Designer and Embarcadero E - R Studio.

Knowledge of Anti-Money Laundering (AML), Fraud Detection, KYC Verification, Cyber Insurance, and Risk Modeling processes and methodologies.

Knowledge in writing, testing, and implementation of the triggers, procedures, functions at database level and form level using PL/SQL. Familiar with Power BI Dataflows, Power Apps, Data modeling, Power automates, Row Level Security.

Good Knowledge in designing the Data Mart using Ralph Kimball's and Bill Immon Dimensional DataMart Modeling techniques. Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.

Experience in modeling with both OLTP/OLAP systems and Kimball and Immon Data warehousing environments. Extensive experience in development of T-SQL, DML, DDL, DTS, Stored Procedures, Triggers, Sequences, Functions and Packages.

Experience working with Alteryx data processing and automation.Managed large datasets in various formats including CSV, SQL databases, and NoSQL.

Conducted exploratory data analysis (EDA) to identify patterns, trends, and anomalies in data.

Experience in Data Profiling, Analysis by following and applying appropriate database standards and processes, in definition and design of enterprise business data hierarchies.

Experience in extracting, transforming and loading (ETL) data from spreadsheets, database tables and other sources using Microsoft SSIS. Excellent knowledge in designing and developing dashboards using QlikView by extracting the data from multiple sources.

Experience in Data Transformation and Data Mapping from source to target database schemas and also data cleansing. Strong understanding of Data Modeling (Relational, dimensional, Data analysis, implementations of Data warehousing using Windows and UNIX.

Developed key performance indicators (KPIs) to measure business performance.

Expert-level knowledge of MS Excel, including VLOOKUP, Pivot tables, VBA, and macro creation, as well as strong skills in MS Office Suite.

Proven ability to analyze complex datasets and maintain high data quality. Strong communication skills for working across teams

Managed development and testing teams to keep deliverables on track and reported to stakeholders.

TECHNICAL SKILLS

Operating Systems: Windows, Mac OS, Ubuntu

Data Tools: Tableau, Qlik, SQL, Looker, Epic Systems

BI & Reporting Tools: Extensive use of Power BI, Tableau, SSRS, ArcGIS, and Excel for data visualization, reporting, and mining.

Programming languages: Java, Python, C, HTML, JavaScript

Database: MS Access, SQL, Oracle, DB2, Teradata, Big Data, NoSQL, MySQL

Statistical Analysis: Practical experience in statistical analysis using tools like Excel, SPSS, and SAS for data evaluation and segmentation techniques.

Data Visualization: DAX, Power BI, Report Builder, Paginated Reports

Project Management Tools: Jira

Business Acumen: Business Requirements, Business Rules, Key Performance Indicators (KPIs), Marketing Mix Modeling

Cloud Platforms: Google Cloud Platform, Azure, AWS

Chatbot Technologies: Google Dialog Flow, Amazon LEX

WORK EXPERIENCE

Client: Comerica Bank, Frisco, Texas, USA Sep 2023 - Present

Role: Sr. Data Analyst

Description: Comerica Bank offers banking and financial services for individuals and businesses. Designed and implemented data analysis solutions and interactive dashboards to provide insights, enhance decision-making, and support predictive modeling and customer interaction through various platforms.

Responsibilities:

Analyzed data for insights on US traffic, accident patterns, and vehicle safety with advanced drilldowns.

Managed datasets on Google BigQuery and implemented Data Actions in Power BI, enabling authorized users to write back data.

Filtered duplicate/un-authorized write requests using Google Cloud Functions (Python).

Built dashboards for business users using Power BI and Tableau; worked with Azure Data Factory (ADF) for orchestrating Azure services.

Wrote Python scripts to parse XML and load data into databases.

Created Derived Tables in Power BI with SQL queries to optimize read costs and analytics time.

Guided end users in using Power BI and Tableau, sharing and embedding dashboards.

Developed custom visualizations with R.

Worked with DW architectures like Google BigQuery, Redshift, and Snowflake; implemented Hadoop solutions.

Collaborated with business and analytics teams to gather system requirements.

Loaded and transformed large data sets; performed data cleaning using R and Python.

Coded machine learning solutions in Python to predict customer behavior.

Built chatbots with Google Dialog Flow and AWS LEX for customer support and messaging.

Developed a chatbot for real-time database interaction using Firebase.

Environment: Python, Hive, Azure, ADF, HBase, MapReduce, Chatbots, Google Dialog Flow, GCP, R, Impala, Sqoop, Tableau, SQL, Google BigQuery

Client: American Airlines, Dallas, Texas, USA Nov 2022 – Aug 2023

Role: Sr. Data Analyst

Description: American Airlines is a major global airline offering passenger and cargo services across a vast network of destinations. Developed comprehensive dashboards and reports to analyze and visualize data, optimizing data processes and enhancing business insights through various analytical tools.

Responsibilities:

Created a multi-page report dashboard in Google Looker (Data Studio) using Google BigQuery data.

Built BigQuery SQL queries and views for Google Looker.

Extracted data from Airtable using Google Apps Script for review and cleanup.

This data was ultimately moved into Google BigQuery.

Understand the business requirements and develop data models accordingly by taking care of the resources.

Created DAX Queries to generate computed columns in Power BI.

Created Row level security with power BI and integration with power BI service portal.

Work with Azure Data explorer and use Kusto Query Language (KQL) for querying

Created reports using dynamic column selection, conditional formatting, sorting, and grouping

Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send mail task etc.

Worked on all types of transformations that are available in Power BI Query editor.

Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps, Power Apps

Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports

Used Dataflows, Power Automate features to work efficiently for further dashboards

Involved in creating new stored procedures and optimizing existing queries and stored procedures.

Environment: Google Looker, Power BI, Lookup, dashboards, DAX Queries, SQL, Google Big Query.

Client: SUN Pharma, Mumbai, India Jul 2020 - Jul 2022

Role: Data Analyst

Description: SUN Pharma is a global pharmaceutical company specializing in manufacturing and marketing a wide range of pharmaceutical products. Managed data cleanup and infrastructure projects, coordinated development and testing teams, and facilitated effective communication and issue resolution to ensure successful project outcomes.

Responsibilities:

Created data cleanup routines using Google App Script and advanced Google Sheets formulas for Google Data Studio.

Developed custom Google Sheet utilities for HTML email formatting and a basic Google Docs creator to convert Sheets data to PDF.

Assisted clients in understanding spreadsheet formulas.

Served as the owner and Subject Matter Expert (SME) for all RFCs and FTPs across projects.

Deployed and monitored scalable AWS infrastructure.

Managed the development team and coordinated with testing and ETL development teams for project success.

Reported to the Platform Manager and identified entities and relationships to develop a Conceptual Model using Erwin.

Utilized Agile methodology for daily scrums.

Designed and enhanced cloud-based applications using AWS.

Executed data extraction and transformation to generate CSV files using Python and SQL.

Employed AWS Glue to crawl the S3 data lake and populate the Data Catalog.

Created SQL queries and PL/SQL procedures for data extraction from various sources.

Developed SSIS packages for incremental loading and slowly changing dimensions.

Produced Tableau ad-hoc reports using Excel, flat files, and CSVs.

Assisted in requirement gathering and mobile application testing.

Environment: Tableau, AWS Glue, crawl, Google Data Studio, ETL, SQL queries, PL/SQL, Erwin, HTML, Agile

Client: Kotak Life, Mumbai, India Apr 2019 - Jun 2020

Role: Programmer Analyst

Description: Kotak Life Insurance is a leading provider of life insurance solutions, offering a range of policies and investment products to secure financial futures. Contributed to data migration and modeling projects by analyzing legacy systems, designing data structures, and developing comprehensive reports and ETL processes for efficient data management.

Responsibilities:

Worked on a migration project which required gap analysis between legacy systems and new systems.

Involved in various projects related to Data Modeling, Data Analysis, Design and Development for both OLTP and Data warehousing environments. Created data cleanup routines using Google App Script and advanced Google Sheets formulas for Google Data Studio.

Developed custom Google Sheet utilities for HTML email formatting and a basic Google Docs creator to convert Sheets data to PDF.

Assisted clients in understanding spreadsheet formulas.

Served as the owner and Subject Matter Expert (SME) for all RFCs and FTPs across projects.

Deployed and monitored scalable AWS infrastructure.

Managed the development team and coordinated with testing and ETL development teams for project success.

Reported to the Platform Manager and identified entities and relationships to develop a Conceptual Model using Erwin.

Utilized Agile methodology for daily scrums.

Designed and enhanced cloud-based applications using AWS.

Executed data extraction and transformation to generate CSV files using Python and SQL.

Employed AWS Glue to crawl the S3 data lake and populate the Data Catalog.

Created SQL queries and PL/SQL procedures for data extraction from various sources.

Developed SSIS packages for incremental loading and slowly changing dimensions.

Produced Tableau ad-hoc reports using Excel, flat files, and CSVs.

Assisted in requirement gathering and mobile application testing.

Environment: AWS, OLTP, SQL, ETL, JRD, PL/SQL, Power BI, SSIS, Lookup

EDUCATION

Masters in Information Technology from Webster University, USA

Bachelors in Computer Science and Engineering from SRKR Engineering College, INDIA

Phone No:726-***-**** Email ID:******************@*****.***

Contact this candidate