Home

Priyatham - Sr. Power BI Developer/Data Analyst

[email protected]

Location: Irving, Texas, USA

Relocation: YES

Visa: H1B

PROFESSIONAL SUMMARY Over 9 years of IT experience focused on Database development, Data warehousing and Business Intelligence applications across various platforms. Extensive experience in developing and implementing MSBI Suite. (SSIS, SSAS, SSRS) Created diverse visualizations using Power BI and Tableau. Experience in optimizing complex SQL queries in Snowflake. Expert in ETL data flows using SSIS. Experience in DTS migration and metadata management. Experience in providing Logging and Error handling. Proficient in integrating data from multiple sources, including SQL databases, APIs, and cloud platforms. Experience in creating various calculated columns and measures using DAX. Expertise in Publishing Power BI Reports in Power BI Server, creating Workspaces, Users and Groups, assigning permissions to End-Users, and Scheduling the reports in Power BI Services. Proficient in Azure services, Python, and advanced data modeling techniques. Proficient in Row Level Security (RLS) implementation. Developed scripts to automate the execution of ETL using shell scripts under Unix environment. Utilized R programming for advanced data analysis and statistical modeling. Wrote complex DAX, Power Query formulas and created KPIs. Developed Paginated Reports and Custom Visuals. Worked with both Direct query and Import data into Power BI. Skilled in integrating Power BI and Power Automate with Azure services. Involved in creating BRD, FRD, FDD and TDDs. Involved in Troubleshooting and Performance tuning of reports within Power BI. Experience working in agile environments. TECHNICAL SKILLS Business Intelligence Power BI, SSIS, SSRS, SSAS, Power Apps, Tableau Data Management Azure Data Factory, Azure Data Lake, Azure SQL Database, T-SQL (DDL, DML, Stored Procedures), MS SQL Server, ORACLE, Teradata V2R6/V2R5 Data Analysis and Visualization DAX, M Query, Python, Power Pivot Data Modeling & Development Tools SSDT, SSAS, OLAP, Snowflake, Power Automate, Multi-dimensional Cubes, Business Intelligence & Development Studio, Visual Studio Data Governance and Security Data Governance Policies, Row-Level Security, Compliance Standards Programming Languages MSSQL, PL/SQL, T-SQL, Teradata SQL, Python, R Scripting Languages HTML, XML, Java Script, MDX, UNIX Shell Scripting Cloud Technologies Azure Cloud Platform, Azure Machine Learning, Azure Databricks, Azure Analysis Services, Azure Logic Apps ETL Tools Data Transformation Services (DTS), SSIS, Informatica Reporting tools SSRS, Power BI Desktop, Business Objects 6.5/XI, MS Excel, Cognos Impromptu Requirements Management Requisite Pro, Microsoft Office Document Management Documentum, Visual Source Safe, SharePoint, Ultra Edit Methodologies Star/Snowflake Schema, ETL, OLAP, Agile, Data Governance EXPERIENCE 7-Eleven, Irving, TX Sr. Power BI Developer/Data Analyst MAY 2021 - PRESENT 7-Eleven, Inc. is an American convenience store chain, headquartered in Irving, Texas where I have worked on 3 major projects: Sales performance, Inventory management analysis and Promotional Campaign effectiveness. Sales Performance Dashboard: Integrated data from multiple sources including POS systems, ERP software, and CRM platforms using Power Query in Power BI to create a unified view of sales data. Implemented dynamic filtering and slicing capabilities using Power BI's interactive visuals, enabling users to drill down into specific product categories, time periods, and geographic regions. Developed interactive visualizations such as trend lines, heat maps, and scatter plots using Power BI's built-in visualization tools to identify sales trends and patterns. Incorporated advanced calculations and measures using DAX in Power BI to analyze year-over-year growth, seasonality, and sales velocity. Collaborated with stakeholders including sales managers, marketing teams, and store operators, using Microsoft Teams and Slack, to gather requirements and refine dashboard functionality. Conducted user training sessions using Microsoft PowerPoint and provided ongoing support to ensure effective adoption of the sales performance dashboard across the organization. Inventory Management Analysis: Designed and optimized data models using SQL Server or Azure SQL Database to efficiently handle large volumes of inventory data while maintaining performance. Automated data refresh schedules and data validation checks using Power Automate to ensure the accuracy and timeliness of inventory reports. Implemented data-driven alerts and notifications using Power Automate and Microsoft Teams to proactively identify potential stockouts and excess inventory situations. Leveraged Power BI's integration with R and Python to perform advanced statistical analysis and forecasting on inventory data, utilizing libraries such as pandas and scikit-learn. Worked closely with inventory managers and procurement teams using Microsoft Teams and SharePoint to identify optimization opportunities and streamline inventory replenishment processes. Promotional Campaign Effectiveness: Integrated data from various sources including sales transactions, marketing campaigns, and customer feedback surveys using Power Query in Power BI to evaluate the impact of promotional activities. Developed custom metrics and KPIs using Power BI to measure campaign performance metrics such as ROI, conversion rates, and customer acquisition cost. Implemented A/B testing methodologies using Google Optimize to compare the effectiveness of different promotional strategies and messaging. Utilized sentiment analysis and text mining techniques using Microsoft Azure Text Analytics to analyze customer feedback and sentiment towards promotional offers. Generated automated reports and dashboards using Power BI's scheduling and distribution capabilities to track campaign performance in real-time and facilitate ongoing optimization efforts. Environments: Power BI, Power Query, DAX, Microsoft Teams, Slack, Microsoft PowerPoint, Microsoft Teams, Slack, Microsoft PowerPoint, SSIS, SSRS, SQL Server, Azure SQL Database, Power Automate, R, Python, pandas, scikit-learn, SharePoint, Google Optimize, Microsoft Azure Text Analytics, Agile. PNC Bank, Irving, TX Power BI Developer AUG 2019 - APR 2021 PNC Bank is one of the largest banks in the United States, offering a wide range of financial services to individuals, businesses, and institutions. They provide services such as retail banking, corporate and institutional banking, asset management, and wealth management. My work here was to analyze Loan Portfolio Management. Designed and implemented the loan portfolio management dashboard using Power BI, leveraging its rich visualization capabilities and interactive features. Utilized Power Query to import, transform, and clean loan data from various sources, including relational databases and Excel spreadsheets. Integrated the dashboard with Azure Machine Learning services to develop and deploy predictive models for credit risk assessment and loan default prediction. Employed Python scripts within Power BI to perform advanced analytics, such as Monte Carlo simulations for stress testing the loan portfolio under different economic scenarios. Utilized Microsoft Excel as a supplementary tool for in-depth analysis and modeling of loan performance metrics, including cash flow projections, net present value (NPV) calculations, and sensitivity analysis. Collaborated with risk management and finance teams to incorporate regulatory compliance requirements, such as Basel III capital adequacy standards and stress testing guidelines, into the loan portfolio analysis. Conducted user training sessions and provided documentation to empower stakeholders to interpret and utilize the loan portfolio management dashboard effectively. Implemented role-based access control (RBAC) and data encryption mechanisms to ensure data security and confidentiality, particularly for sensitive loan information. Environments: Power BI, Power Query, Azure Machine Learning services, Microsoft Azure Services (Azure Data Factory, Azure Data Lake, Azure SQL Database), SSIS, SSAS, SSRS, Python, Microsoft Excel, Row Level Security, DAX, M Query, Agile. AIM Specialty Health, Chicago, IL Power BI Developer FEB 2018 - AUG 2019 AIM Specialty Health is a healthcare management company that specializes in providing solutions to improve the quality and cost-effectiveness of healthcare services. Here I have worked on a Patient Health Analytics Dashboard where I developed a comprehensive dashboard using Power BI to analyze patient health data from electronic health records (EHR), including demographics, medical history, diagnoses, and treatments. Integrated data from various healthcare systems and sources, such as EHR systems, using Power Query in Power BI to create a unified view of patient information. Implemented dynamic filtering and drill-down capabilities using Power BI's interactive visuals, enabling healthcare providers to explore patient cohorts based on diagnoses, treatment outcomes, and demographic factors. Created interactive visualizations, such as trend analysis, risk stratification, and care pathway tracking, using Power BI's built-in visualization tools to identify patterns and insights related to patient health outcomes. Incorporated predictive analytics models using Azure Machine Learning services to forecast patient health risks, readmission probabilities, and treatment response rates. Conducted user training sessions using Microsoft PowerPoint and provided ongoing support to ensure effective adoption of the patient health analytics dashboard across the healthcare organization. Environments: Power BI, Power Query, Azure Machine Learning services, Microsoft PowerPoint, Microsoft Azure Services (Azure Data Factory, Azure Data Lake, Azure SQL Database), DAX, Python, Power Apps, Power Pivot, MSSQL, Agile, Jira, MS Office, Requisite Pro and MS Visio XSilica Software Solutions, Hyderabad, IND - SQL Developer AUG 2013 - OCT 2016 Extensively performed data modeling, data analysis, and reporting tasks, leveraging SQL development skills to extract insights from complex datasets. Developed SQL queries with multi-table joins, group functions, sub queries, and T-SQL stored procedures, enhancing data analysis capabilities. Demonstrated proficiency in index creation and modification to improve SQL stored procedure performance. Played a key role in all stages of the software development life cycle (SDLC) by collaborating with senior business analysts and lead developers. Contributed to the design and documentation of error-handling strategies in ETL load processes using Event handlers. Designed and developed dynamic SSIS Packages to efficiently transfer and load data between servers and databases. Created SQL Server Reports using SSRS, generating matrix reports, tabular reports, drill-down, drill-through, sub reports, chart reports, and multi-parameterized reports. Processed SSAS cubes to store data in OLAP databases, enabling efficient reporting and analysis. Environment: MS SQL Server 2012, 2008 R2/2008, SSIS, SSRS, SSAS, Business Intelligence Development Studio (BIDS), T-SQL, SQL Server Agent, DB2, Tableau, Visual Studio 2008/2005, MS Office, Visual Source Safe, Requisite Pro, TFS, MS Excel, and MS Visio Keywords: business intelligence rlang information technology microsoft procedural language Illinois Texas