Goutham KV
Business Intelligence Analyst
Ann Arbor,MI
Overview
9
9
years of professional experience
Work History
Sr. Business Intelligence Analyst (Power BI/ Tableau)
Pfizer
Raleigh/Rocky Mount, NC
09.2023 - Current
- Designed, and developed various Power BI and Tableau visualizations for dashboard and ad-hoc reporting solutions by connecting from different data sources and databases
- As a Power BI and Tableau SME responsible for design, development and production support of interactive data visualizations used across the GMP operations
- Maintained business operations continuity during the migrations of the reports from the Tableau, and Qlik to Power BI
- Tested the reports which are migrated to Power BI for the data accuracy and functionality and to validated the visualizations and insights match the user expectations
- Conducted POV and prepared the Power BI reports based on the existing reports and provided business solutions which minimizes the budget and operations by using the Microsoft Power BI
- Trained the users on the usage of the Power BI reports and provided easy integration of the SharePoint Online and their respective Business sites
- Utilized Power BI to design multiple scorecards and dashboards to display information required by different departments and upper-level management
- Embedded the dashboards into the Share Point Online where users can view the daily production and supply chain of Vaccine and drugs at the sites at NC, NJ, and MI
- Created detail level summary report and Dashboard using KPI’s to monitor the distribution and trail runs of the drug across various regions
- Improved report quality by identifying and integrating over 45 Data Sources, APIs and Excel tables to existing tableau reports
- Manage Power BI portal – data refreshers / user management and set up gateway data refresh
- Provide reports based on Time Series Forecasting and Predictive analysis: This involves understanding the data and work on Time Series Forecasting by providing reports on Historical data, forecasted values and Confidence level components visually using Holt’s Linear Trend and Holt Winter method in Power BI service
- Performed exploratory Data Analysis, trying to find trends and clusters
- Environment: Power BI, Tableau, Oracle SQL, Microsoft Excel, Jira, and Azure, Share Point Online, Power Automate, AWS S3, GitHub
Sr. Business Intelligence Analyst
Regeneron Pharmaceuticals
Tarrytown, NY
01.2023 - 09.2023
- Developed a self-service dashboard for the sales team resulting in a 40 % increase in data-driven decision making
- Developed and developed reports and dashboards using Power BI platform, by gathering data from the SAP, SAP Hana, SharePoint, Excel and Mongo DB
- Collaborated with the IT Team and Share Point team to implement the Power BI application for the reports which are being developed in Tableau
- Migrated over 50 reports from Tableau to the Power BI which increased the operation efficiency by 30%
- Collaborated with cross-functional teams to identify data sources and streamline data collection resulting in rapid report development
- Constructed and edited DAX functions and queries for various accounts
- Gathered requirements from users and Analytical thinking for translating data into informative reports and visuals: This involves understanding the business requirements and objectives, identifying the key performance indicators (KPIs) and metrics, analyzing the data using DAX functions or expressions, and presenting the insights in a clear and concise manner
- Environment: Power BI, Tableau, Oracle SQL, Microsoft Excel, SAP, SAP Hana, Mongo DB, Share Point Online, Power Automate
Business Intelligence Analyst
Bristol-Meyers-Squibb (Celgene Corp)
Summit, NJ
01.2021 - 12.2022
- Designed and managed the marketing data warehouse project, within-budget and on schedule (Oracle 10g)
- Transitioned the entire BI project from Tableau to Power BI and performed POC using STAR (Simulate, Task, Action, Result) method and projected the demo of working model of Power BI to users
- Incorporated Power BI with Share Point Online by embedding the dashboards and publishing interactive dashboards on the Share Point pages
- Worked on different source data like Excel, SQL, Azure Blob and ELN notes data to generate reports for the lab driven analysis
- Works directly with senior management to conduct special projects related to the operations of the business
- Advised leadership on effective use of resources, as well as interpretation of underlying budgets
- Transitioned the ECQ team from an intuition based to a fact-driven decision-making culture
- Implemented and worked on the JIRA implementation for agile based projects to track the project development, requirements, and defects
- Analytical thinking for translating data into informative reports and visuals: This involves understanding the business requirements and objectives, identifying the key performance indicators (KPIs) and metrics, analyzing the data using DAX functions or expressions, and presenting the insights in a clear and concise manner
- Generate reports by using AutoML feature with Power BI Dataflows: Generated Model performance, Accuracy report and Training Data by using AutoML feature by training and testing the data sets using Power BI service
- Managed Scrum calls and worked on the Agile and Hybrid agile model
- Directed data mining projects addressing customer behavior insight, cost efficiency and profitability: churn prediction combined with customer valuation and segmentation resulting in 21% higher retention rates in course of a year
- Worked on predictive analytics, Scientific data analysis to show case project requirements more efficiently to the scientists working with lab data
- Environment: Power BI, Python, Oracle SQL, Azure Blob, Microsoft Excel, Jira, and Azure, Share Point Online, Power Automate, AWS S3, GitHub
Data Analyst
Gilead Sciences
Foster City, CA
01.2019 - 12.2020
- Implemented Power BI along with Power Automate in full-scale execution by Migrating the legacy reports from OBIEE to Power BI
- Develop reports and dashboards in Power BI and publish them in SharePoint
- Analyze the raw datasets, transform, and cleanse the data for the reports on the SharePoint analysis
- Develop the estimation reports using predictive analysis for the SharePoint (PDM) department site
- Specialized in transforming data into user-friendly visualization to give business users a complete view of using Power BI
- Created different Power BI reports utilizing the desktop and the online service and scheduled data refresh to exempt manual intervention
- Generate reports using Share Gate and publish dashboards with visualizations for the reports and implement data exploration to analyze patterns and to select features using Python SciPy
- Built factor analysis and cluster Analysis models using Python SciPy to classify customers into different target groups
- Developed various solution driven views and dashboards by developing different chart types including Pie Charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, Scatter Plots in Power BI
- Created the KPI to show the difference between actual and forecast data
- Working with import and direct query, creating custom table in the Power BI and developed Complex calculated measures using Data Analysis Expression language (DAX)
- Embedded Power BI reports on Salesforce portal page and managed access of reports and data for individual users using roles
- Extensively performed large data read/writes to and from csv and excel files using pandas
- Run reports using Sharegate for the SharePoint data analysis and provide SWOT analysis on product data using Power BI charts
- Collaborate with scientists or researchers to understand the data context and domain knowledge
- Environment: Power BI, Python, Oracle SQL, SharePoint 2013, Power Apps Shell Scripting, SharePoint Online, Share Gate, OBIEE, Tableau
Business Intelligence Developer
Merck & Co
Branchburg, NJ
01.2016 - 12.2018
- Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer and worked with various Passive transformations in Informatica Power center like Expression Transformation, Sequence Generator, and Lookup Transformation
- Worked closely with Business Analyst in understanding the BI and reporting requirements and created the business model for generating reports as per requirement
- Worked closely with the data modeler in designing the logical data model in star schema in BMM layer
- Developed calculated measures and assigned aggregation levels based on dimension hierarchies
- Developed intuitive and user-friendly dashboards by appropriately including guided navigational links, prompts and drill downs
- Worked with various active transformations in Informatica Power Center like Filter Transformation, Aggregator Transformation, Joiner Transformation, Rank Transformation, Router Transformation, Sorter Transformation, Source Qualifier, and Update Strategy Transformation
- Created different parameter files and changed Session parameters, mapping parameters, and variables at run time
- Extracted data from SAP system to Staging Area and loaded the data to the target database by ETL process includes creating the sessions and scheduling the sessions using Informatica Power Center
- Performed the performance and tuning at source, Target levels using Indexes, Hints and Partitioning in DB2, Oracle and Informatica
- Designed and developed various PL/SQL stored procedures to perform various calculations related to fact measures
- Designed and developed an Informatica cloud PoC for a leading retail company to migrate their legacy data warehouse to a cloud-based data lake using Informatica Cloud Data Integration and Informatica Cloud Data Quality
- Reduced data loading time by 50%, improved data accuracy by 90%, and enabled faster and easier data analysis and reporting for business users
- Performed Unit testing and maintained test logs and test cases for all the mappings
- Worked on different source systems like SAP source systems (HANA), Tibco, and SQL server source systems
- Manage, collaborate, and coordinate the Work of an offshore development team
- Environment: Informatica 9.x, OBIEE, Informatica Cloud, AWS, SAP, SQL, MYSQL, AWS R3 and RDS, ABAP
Timeline
Sr. Business Intelligence Analyst (Power BI/ Tableau)
Pfizer
09.2023 - Current
Sr. Business Intelligence Analyst
Regeneron Pharmaceuticals
01.2023 - 09.2023
Business Intelligence Analyst
Bristol-Meyers-Squibb (Celgene Corp)
01.2021 - 12.2022
Data Analyst
Gilead Sciences
01.2019 - 12.2020
Business Intelligence Developer
Merck & Co
01.2016 - 12.2018
Similar Profiles
Amanuel NegasaAmanuel Negasa
Gene Therapy Operations Specialist II at PfizerGene Therapy Operations Specialist II at Pfizer
Stephen RenkenStephen Renken
Downstream Technical Operator IV at PfizerDownstream Technical Operator IV at Pfizer
Saeed Al-QarniSaeed Al-Qarni
National Sales Manager at PfizerNational Sales Manager at Pfizer
David PhillipsDavid Phillips
Senior Facility Manager/ WorkPlace Experience at PfizerSenior Facility Manager/ WorkPlace Experience at Pfizer
Ian CooperIan Cooper
FedEx Delievery Driver at K&D 24/7FedEx Delievery Driver at K&D 24/7