Power Bi Data Analyst
Resume:
Goutham KV
*********@*****.*********:************@*****.***
SUMMARY:
Over 9+ years of BI, Data Analysis and ETL data organization in the engineering in Pharmaceutical and Life Sciences domains.
Experienced Data Analyst, BI/ETL Developer and Python Programmer with a demonstrated history of working in the pharmaceuticals, and research domains. Skilled in Microsoft Power BI, Tableau, Python Program, Extract, Transform, Load (ETL), Linux, and Amazon Web Services (AWS).
Experience in the creative and interactive data visualizations by using the Power BI, Tableau, OBIEE, and Qlik
Certified Tableau Data Analyst in 2021.
Experience in the migration of the reports from the Tableau to Power BI, OBIEE to Power Bi and Qlik to Power BI.
Experienced in Analysing the BI needs, interpreting business user requirements and translating them into reports.
Experience in working with the trending data during the time in Gilead and Pfizer which is presented to the shareholders.
Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Centre.
Created different visualization in the reports using custom visuals like Bar Charts, Pie Charts, Line Charts, Cards, Slicers, etc.., also, using different transformation inside edit query into clean-up the data.
Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
Experienced in developing Power BI and Tableau reports and dashboards from multiple data sources using data blending.
Good interaction with clients, understanding Business Applications, Business Data Flow and Data Releations.
Skilled in extracting, compiling, tracking, and analysing data to generate reports in Excel, Power BI, and Tableau.
Have experience in Jira and Agile methodology, writing user story's and understand backlog of issues.
Strong analytic skills and problem solving with the ability to extract, collect, organize, analyse, and interpret trends or patterns in complex data sets.
Established KPIs to measure the effectiveness of business decisions using graphs, info graphics and other methods for visualization.
Trained and led offshore colleagues on reporting and analytics tools in Power BI, Tableau and Informatica Cloud.
Excellent knowledge of all the phases of Software Development Life Cycle (SDLC).
Excellent written and verbal communication skills and ability to translate technical concepts into business language and business language into technical requirements.
Involved in coordinating meetings with the product committee, project manager and functional management to discuss project impediments, needed resources or issues/delays in completing the task.
Education: Master of Science (M.S) focused on Electrical Communication and Computer Engineering from Gannon University (2015).
PROFESSIONAL EXPERIENCE:
Client: Pfizer, Raleigh/Rocky Mount, NC Sep 2023-Till Date
Role: Sr. Business Intelligence Analyst (Power BI/ Tableau)
Roles and Responsibilities:
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
Client: Regeneron Pharmaceuticals, Tarrytown, NY Jan 2023-Sep 2023
Role: Sr. Business Intelligence Analyst
Roles and Responsibilities:
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.
Client: Bristol-Meyers-Squibb (Celgene Corp), Summit, NJ Jan 2021-Dec 2022
Role: Business Intelligence Analyst
Roles and Responsibilities:
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
Client: Gilead Sciences, Foster City, CA Jan 2019-Dec 2020
Role: Data Analyst
Roles and Responsibilities:
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.
Client: Merck & Co, Branchburg, NJ Jan 2016 - December 2018
Role: Business Intelligence Developer
Roles and Responsibilities:
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.
Contact this candidate