SV

SENPAKA PRIYA VENKATSAMY

Power BI Developer · UHG/Optum


Work Experience

Power BI Developer

UHG/Optum

2020 – Present

Technologies Used: PowerBI, SSRS, MS SQL Server, DBeaver, Power Query, Rally, Microsoft Office, and Excel Macros

Key Activities: • Designing and implementing advanced Power BI dashboards, and developing complex SQL code to blend datasets in SSMS and SSAS • Establishing high level interactive Power BI reports for the Executive team highlighting essential KPI's allowing them to make more informed decisions • Being one of the key members in the Power BI CoE, responsible for conducting training, onboarding and mentoring the team on Power BI development • Responsible to demonstrate the potential Power BI solutions for use cases across different LOBs and guide them for seamless onboarding • Developing complex DAX formulae to deliver accurate KPI values on hybrid data sources • Maintaining existing Power BI dashboards and reports and ensure quality

Business Reporting Lead

AT&T

2018 – 2020

Technologies Used: PowerBI, MS SQL Server, Power Query, JIRA, AgileCraft, Microsoft Office and Excel Macros

Key Activities: • Creating a new reporting environment using PowerBI, DAX queries and SQL Server • Building Power Bi report to provide granular analytics and visualization for the RPA pipeline management • Working closely with the VP & Directors of Robotics Process Automation (RPA) team to develop real-time interactive Power BI reports /dashboards for business forecasting and retrospection • Subject Matter Expert (SME) for RPA data and leading a team of 5 focusing RPA data analysis and reporting • Generating ad-hoc reports using Power Pivot and shearing them using Power BI to support strategic planning • Creating and maintaining reports and dashboards based on business needs, using Power query, SQL, to measure and analyze the performance improvement accomplished by implementation of BOTs (Automation Anywhere) • Developing SQL scripts using OLAP, advanced functions like Rank, Pivot, CTEs etc., to derive the data for the business demand • Creating Source-Target mappings, business data glossary to facilitate common data consumption across the board and serve foundational data governance • Providing database support to production systems to aid development sprint releases • Gathering business, data requirements and coordinating with offshore for timely and seamless delivery

CRM BI Analyst

Holliday Fenoglio Fowler (HFF)

2017 – 2018

Technologies Used: Salesforce, CRM Fusion Demand Tools, SQL, Microsoft Office and Excel Macros

Key Activities: • Responsible to profile, analyze, cleanse, scrub data from several sources, and validate the mapping of legacy fields • Responsible to dedupe, normalize data of several objects (Accounts, Contacts etc.) from various sources and load them to Salesforce, using several tools, including the different modules from CRM Fusion Demand tools • Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction • Synthesized Data Quality metrics, reports highlighting the key data issues identified during the profiling • Worked with business users to identify the reporting needs and developed custom reports, dashboards, views in Salesforce to assist the business activities • Involved in business analysis and technical design sessions with business and technical team to develop requirements document, and ETL specifications • Synthesized Data Lineage artifacts to aid troubleshooting and impact analysis

Data Analyst

Capital One

2017 – 2017

Technologies Used: Teradata, JIRA, Business Objects, SQL, Microsoft Office and Excel Macros

Key Activities: • Created Source-Target mappings to complement the design and development of ETL • Being a SME for few key data domains, responsible to perform User Accepting Testing (UAT) for the data migration from Salesforce to AWS • Responsible to write complex queries and generate meaningful data outputs to assist the business needs • Created multi-set tables and volatile tables using existing tables and collected statistics on table to improve the performance • Developed Teradata SQL scripts using OLAP functions to extract data for the complex data demand from business team • Synthesized Data Lineage artifacts to aid troubleshooting and impact analysis • Worked with business users to identify the reporting requirements and developed / fixed reports as per business need • Analyzed the data to find the data anomalies and identified the data objects that need to be addressed • Involved in business analysis and technical design sessions with business and technical team to develop requirements document, and ETL specifications

Data Analyst, QA Analyst

Cognizant Technology Solutions

2013 – 2015

Clients: The Hartford Insurance, Rentokil Initial

Technologies Used: SQL Server, Qlikview, SAP Business Objects, Informatica, JIRA, ALM-QC, Autosys, TOAD, WinSQL, Visual Basic, Microsoft Office and Excel Macros

Key Activities: • Responsible for creating Data Mapping documents between Staging and Integration layer, validation of reports and data profiling • Performed data analysis on legacy systems, documented the lineage, and identified the viability of mapping the legacy fields to the new database, based on the business requirements to aid troubleshooting and impact analysis • Involved in business analysis and technical design sessions with business and technical team to develop requirements document, and ETL specifications • Retrieved data from data warehouse, and generated a series of meaningful business reports using SQL, validated the reports and then published to business users • Generated reports in BO and compared with values in the data warehouse based on the report logic • Analyzed the data to find the data anomalies and identified the data objects that need to be addressed • Successfully led teams of sizes varying from 4-8, managed the work done by the team and submitted daily status report to the stakeholders • Involved during early phases of requirements gathering to complement creation of efficient Test strategy, Test Plan and Test Design to provide optimal testing without defect leakage • Performed System Integration Testing, Regression Testing and Smoke testing with Zero defect leakage and involved in end-to-end QA and was responsible for QA planning and execution • Created Qlikview dashboard according to the test requirements which enabled easy and accurate testing • Logged the defects in Quality Centre and JIRA, triaged them with the team, got them to closure and performed daily onsite co-ordination

Education

Master of Engineering in Computer Science

Bannari Amman Institute of Technology

Master of Engineering in Computer Science

Bachelor of Engineering in Computer Science

PSR College of Engineering

Bachelor of Engineering in Computer Science