Power Bi Data Analyst
Resume:
PROFESSIONAL EXPERIENCE
Client: First Republic Bank Corporation, Dallas, Texas, USA Jan 2023 - Present
Role: Senior Data Analyst
Description: First Republic Bank Corporation is an American bank. Involved in defining data requirements, integrating systems into a unified data warehouse, and creating interactive and analytical dashboards to support advanced analytics and business decision-making.
Responsibilities:
Collaborated with Subject Matter Experts and Product Owners to define data requirements and source-to-target mapping necessary to support advanced analytics initiatives within M&SC (Manufacturing and Supply Chain), including the interfaces between applications, databases and platforms.
Created a Datawarehouse and Integrated different systems data into the Wearhouse (Salesforce and SAP). Worked with multiple teams for combining the different Databases to a single Universe.
Made Power BI reports more interact and activate by using storytelling features such as bookmarks, selection panes, drill through filters also created custom visualizations using "R-Programming Language".
Used Machine learning using "Python-Programming Language" for converting different language text to English for analysis.
Utilized Power BI to create various analytical dashboards that helps business users to get quick insight of the data
Published and maintained workspaces in Power BI Service, allotted the time refresh for the data, maintained the apps and workbooks.
Used DAX functions to create measure and calculated fields to analyze data for logical visualization and used Power Queries to transform the data.
Converted the Boulder Tables from Excel to Power BI with better Graphs and visualizations for the understanding and improvement of business.
Collected the Plants Data in Excel sheets from different Regions around the World and combined them in Power BI to know the Loss and Profit of the Product.
Performed COPQ and DPPM analysis in Power BI and helped Global Quality Leaders to take the Business-driven decisions. 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.
Translated data requirements to produce comprehensive, detailed data maps and canonicals.
Identified supply chain problem areas and opportunities to improve service, reduce cost, and increase inventory turns
Performed ETL on multiple platforms such as SAP HANA and Teradata, familiarized with Confidential Legacy, SAP and other backend environments to pull the data-to-data Wearhouse
Created and maintained Apps and Reports in Salesforce for Customer Issue Resolution and maintained different Process of CRM.
Used SQL queries to create interactive Dashboard in Salesforce Einstein Analytics Studio and analyzed CRM data.
Created and maintained SharePoint page for Lean Six Sigma using Power Queries for Plant Data and Audited the different projects in the company for Discrepancies.
Used BOXI (Business Objects) for creating reports for Legacy Systems.
Environment: Power BI Desktop, Power BI Service Pro, Teradata, Salesforce, Einstein Analytics Studio, Business Objects, SharePoint, SAP HANA, SAP Logon, QlikView, IBM Lotus Notes, SQL, SQL Server, MS Access, Microsoft Office Suite (Word, PowerPoint, Excel)
Client: Westlake Corporation, Houston, Texas, USA Sep 2021 - Dec 2022
Role: Senior Data Analyst
Description: Westlake Corporation is an international manufacturer and supplier of petrochemicals, polymers and fabricated building products. Contributed to data mapping and documentation, facilitated data extraction and reporting from multiple sources, and developed visualizations and interactive dashboards to support business analysis and decision-making.
Responsibilities:
Mapped the data in different systems and documented them, IBM Lotus Notes is mostly used for mapping the Legacy Systems and Customer Feedback Resolution.
Performed Queries, maintained and extracted Data from Teradata, cleaning and maintaining the Production Environment in Teradata for the performance.
Participated in daily scrum meeting with team to discuss on the challenges and development of the project
Involved in requirement gathering from business users and IT teams to understand and express business process and business logic. Create data cleanup routines using Google App Script, Google Sheets Advance Formulas, for use in Google Data Studio.
Wrote custom Google Sheet Utilities to send HTML formatted email based on sheet data.
Created basic Google Docs creator that converted Google Sheets data to a Google Doc then to PDF for email distribution.
Help clients understand spreadsheet formulas as needed.
Extracted data for reporting from multiple data sources like SQL Server, SQL Server Analysis, Service, Azure SQL Database, Azure SQL Data Warehouse, Salesforce, etc.
Extracted data from data warehouse server by developing complex SQL statements using stored-procedures and common table expressions (CTEs) to support report building
Implemented Tableau for visualizations and views including scatter plots, box plots, heatmaps, tree maps, donut charts, highlight tables, word clouds, reference lines, etc.
Generated complex reports in Tableau using multiple functionalities including context filters, hierarchies, parameters, LOD Expressions, time intelligence, etc.
Built interacting and storytelling dashboards in Tableau workbooks using dashboard actions
Published Tableau workbook on Tableau Server and set report refresh
Used Data Analysis Expressions (DAX) to create measures and calculated fields to analyze data and to create time intelligence.
Extensive use of DAX (Data Analysis Expressions) functions for the Reports and for the Tabular Models.
Environment: Power BI Desktop, Power BI Service, Project Online, SQL Server 2016/2017, SSRS, SSIS, SSAS, DAX, Tableau, Microsoft Azure, Python, SharePoint, Visual Studio, Scrum/Agile, BI Development Studio (BIDS), MDX, XML, SQL Profiler, TFS, MS Office, Windows 10/7, Data Analyzer
Client: SelFin India Financial Services Private Limited, Mumbai, India Oct 2018 - Jun 2021
Role: Data Analyst
Description: SelFin India Financial Services Private Limited is a non-banking financial company. It offers loans for micro, small and medium businesses. Created comprehensive reports and dashboards to present findings to stakeholders. Developed visualizations to effectively communicate data insights.
Responsibilities:
Used Data Analysis Expressions DAX to create custom calculations in PowerPivot for Microsoft Excel workbooks and Analysis Services tabular model projects.
Created PowerPivot models and PowerPivot reports, publish reports onto SharePoint, and deploy models into SQL Server SSAS instance.
Assisted in creating SQL database maintenance logs and presenting any issues to the database architects.
Worked on Power BI reports using multiple types of visualizations including line charts, doughnut charts, tables, matrix, KPI, scatter plots, box plots, etc.
Made Power BI reports more interact and activate by using storytelling features such as bookmarks, selection panes, drill through filters, etc.
Created and administrated workspaces for each project on Power BI service and published the reports from Power BI Desktop to Power BI Services workspace
Utilized Power BI to create various analytical dashboards that helps business users to get quick insight of the data
Installed Data Gateway and configured schedule plans for Data Refresh of Power BI reports
Created SSIS packages for ETL processes by using control flow and data flow components
Maintained and tuned performance for slowly running SSIS packages
Responsible for accurately reporting on the financial aspect of the company's operations by rendering reports on daily/ weekly/monthly base
Evaluated returns and risks for various types of investments including stocks, fixed-income assets, hedge fund, real estate and commodities and evaluated risk tolerance for customers
Created ad-hoc reports such as YTD, YOY, MTD, MOM analysis for income statement, cash flow by requests from business units
Implemented report integration among Power BI, Tableau, SSRS and Python reports.
Environment: Power BI, SQL Server 2012/2016, AZURE, Google Big Query, Tableau, Excel, MS SQL Server 2016/2014/2012, Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Management Studio (SSMS) and Oracle 11g.
Client: Abbott, Mumbai, India Aug 2016 – Sep 2018
Role: Programmer Analyst
Description: Abbott is a global healthcare company that provides a range of diagnostic, medical device, and nutrition products to improve health. Played a key role in managing end-to-end project lifecycle, from data warehouse creation and reporting to developing dashboards and handling data movement and application development.
Responsibilities:
Worked with different team's client, analytics, data sources, QA and visualization.
Worked in agile process having expertise in life cycle of a project from start to end.
Created data warehouse and data marts from scratch based on data structures and reporting needs.
Worked on writing ad hoc SQL scripts which are required for reporting purposes. Worked on creating basic dashboards in tableau connected to Azure SQL database for client reporting.
Worked on user management for power bi. Sharing the dashboard access for power bi online.
Worked on Power BI dash boards and ad hoc DAX queries for power bi.
Extensive back-end support for many various reports on Tableau and Power BI.
Created store procedures, functions, triggers, indexes, views based on data processing and data cleansing.
Created various SSIS packages for data movements and transformations. Worked on Python code to load data from Google buckets to big query tables, used data flow for ELT (Extract Load Transform) in Big Query.
Worked on creating POC for data movement in NiFi (Hortonworks), C# programming used in script task for SSIS and in Azure functions to create retrievers for data pull from API.
Hands on experience in working with Applications Migration and App Development in AZURE.
Worked on Web jobs, AZURE data factory, Logic Apps for application and project development in Azure.
Worked on Web Applications in Azure and Azure functions to pull data from API to blob Storage and SQL.
Worked on deploying web sites in Azure and used MVC framework on backend. Experienced in Developing PL/SQL- Procedures, Functions, SQL Scripts and Database Triggers to populate the data applying business logic.
Extensive knowledge in developing PL/SQL codes using Oracle 11g.
Environment: Microsoft Visual Studio2016, SQL Server, Azure, Power BI, Power Pivot, SAS EG, Teradata SQL assistant.
Cover Letter
Dear Hiring Manager,
I am excited to apply for the Data Analyst, position at Global Channel Management INC., as advertised on the Global Channel Management INC Careers Website. With over Six years of experience in data analysis, database management, and business intelligence, I have developed a strong skill set in data visualization, predictive analytics, and process improvement, making me an ideal candidate for this role.
In my current role as a Senior Data Analyst at First Republic Bank Corporation in Dallas, Texas, I have been instrumental in defining data requirements, integrating systems into a unified data warehouse, and creating interactive dashboards to support advanced analytics and business decision-making. My experience includes collaborating with Subject Matter Experts and Product Owners to develop comprehensive data maps, conducting ETL processes on multiple platforms such as SAP HANA and Teradata, and utilizing tools like Power BI, Salesforce Einstein Analytics, and Google Big Query to create impactful visualizations and reports.
At Westlake Corporation in Houston, Texas, I contributed to data mapping, extraction, and reporting from various data sources, including SQL Server, Azure SQL, and Salesforce. I developed interactive dashboards in Tableau and Power BI, leveraging advanced features like DAX expressions and LOD calculations to deliver actionable insights to stakeholders. My efforts in optimizing data extraction and visualization processes improved the quality and efficiency of data-driven decision-making across the organization.
During my tenure at SelFin India Financial Services in Mumbai, India, I developed comprehensive reports and dashboards to communicate data insights to stakeholders, utilizing Power BI, SSIS, and SSRS to streamline financial reporting and improve investment risk assessments. I played a key role in implementing report integration Pany.
At Abbott in Mumbai, India, I gained extensive experience in managing the end-to-end project lifecycle, from data warehouse creation and reporting to dashboard development and data movement. I utilized a variety of technologies, including SQL, Azure, and PL/SQL, to build robust data solutions that supported the organization’s analytical needs.
Throughout my career, I have demonstrated a strong ability to collaborate with cross-functional teams, support data-driven decision-making, and train stakeholders on data tools and processes. My technical expertise, combined with my analytical skills and proactive approach to problem-solving, make me a strong candidate for this position.
I am eager to bring my experience and skills to Global Channel Management INC, and Data and contribute to your team’s success. Thank you for considering my application. I look forward to the possibility of discussing how my background, skills, and certifications align with your needs.
Sincerely,
Ganesh Devarapalli.
Ganesh Devarapalli
Data Analyst
OBJECTIVE
CONTACT
Experienced Data Analyst with 7 years of expertise in data mining, statistical analysis, and data visualization. Adept at utilizing tools such as SQL, Python, R, and Tableau to uncover actionable insights. Proven track record of leveraging advanced analytics to drive strategic decision-making and improve operational efficiency.
******************@*****.***
Master’s from Wichita State University, USA
MBA from Nagarjuna University, India
EDUCATION
Around 7 years of experience in Software Design, Database Design, Development, Integration Implementation and Maintenance of Business Intelligence and the related Database Platforms.
As a Data Analyst responsible for Data Modeling, Enterprise Data Management, Data Presentation, Visualization, Optimization, Risk assessment, predictive analysis, advance Data Analysis, Business Research and Quantitative Analysis.
Experience in SQL 2017/ 2016/2014/2012/2008 R2 with an emphasis on design, development, automation, tuning, optimization, Performance and Security.
Experience in analyzing business user requirements, analysed data and designed software solutions in Tableau Desktop based on the requirements.
Experience in converting Legacy Reports to Tableau dashboards connecting to SQL server. Built and published interactive reports and dashboards using Tableau Desktop and Tableau Server.
Expertise in Microsoft Integration Services like SSIS (Control Flow tasks, Data Flow tasks, Transformations, Database administration tasks).
Proficient in SQL Server Integration Services like Package creation, Check Points Implementation, Dynamic Configuring of package, Logging, Custom script writing, Package deployment using Manifest, Implementing Transactions, and Package encryption.
Explore data in a variety of ways and across multiple visualizations using Power Bl. Experience in Tableau Desktop, Power BI for data visualization, Reporting and Analysis; Cross tab, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart. Developed Python script to for processing large data sets and also to extract data from different files.
Built Python Modules to deliver specific formats of data.
Expertise in creating reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector. Experience in publishing Power BI Desktop reports created in Report view to the Power BI service.
Monitored and Tuned MS SQL Server databases with tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance. Experience in creating Power BI Dashboards (Power View, Power Query, Power Pivot, Power Maps).
Extensive experience in SQL Server 2016/2012/2008 Business Intelligence tools - SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
Experience working on Tableau (Desktop, Server, Reader), creating various Reports and Dashboards using different functionalities.
PROFILE SUMMARY
Framework and methodologies: Data Modeling (ER & Dimensional), Database Design, Requirement Analysis, ETL Design, Object Oriented Design, Development, Testing, Data Mapping, Metadata Management, Master Data Management, Data Profiling, Deployment, Documentation, Project Management, Semantic Layer.
Modeling Tools: Erwin 8.x/9.x, ERStudio 9.x, Power Designer
Big Data: Techs Hadoop, Hive, HDFS, MapReduce, Pig, Kafka.
Reporting Tools: Congo’s 8/10, Oracle Reports, Tableau, Business Objects, IDQ.
Other Tools: SQL Navigator, TOAD, T-SQL, Informatica Power Center, Denodo, Ab Initio, Teradata SQL Assistant
Databases: SQL Sybase, Teradata, DB2.
Languages: C, C++, VB, Java, PHP, Python, R, PL/SQL and SQL, SAS.
Operating Systems: Windows NT, 2000 & XP, Vista, UNIX and Linux.
SKILLS
Contact this candidate