Home

Lakshmi - Power BI

[email protected]

Location: Darrington, Washington, USA

Relocation: Remote

Visa: H1B

Lakshmi K Business Intelligence Engineer/Analyst (Power BI) Email: [email protected] Mobile: 972-945-5806 Phone: 972-784-4133 SUMMARY 11+ years of work experience as BI developer, data analyst and credit analyst with BI technologies in various domains like banking, finance, insurance, marketing and tele-communications. Actively involved in all phases of SDLC including Requirement Gathering, Designing Data Models, Development, Testing, go live and Post Go Live Support. Microsoft Power BI: Creating visualizations, dashboards, reports, data models, calculated columns, and measures with DAX. Experience in Power BI Desktop, Power BI Service, and Power BI Workspaces administration. Microsoft Fabric: Developing One Lake, data flows, and data factory pipelines. Data Integration: Importing data from sources like SharePoint Lists, JIRA, SQL Server, Teradata, Excel, CSV/PSV, Web URLs, OData, Azure Data Lake, Azure Web Contents, Logic Apps, ADX, etc and integrating it through data orchestration pipelines in Microsoft Lens orchestration tool. Cloud Integration: Onboarding sources to the cloud through Gateways and maintaining Power BI Service Gateway. Data Refresh: Setting up automatic data refreshes, incremental refreshes, query folding, and optimizing techniques to speed up report refreshes. Power Apps and Automation Tools: Hands-on experience with Logic Apps, Power Flow, and Power Automate. Data Modeling: Proficient in Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables. Reporting Services: Administering, managing, and troubleshooting reporting services. Highly experienced in documenting the processes to the developing software products. Excellent problem solving, multitasking, business analytical and critical thinking with the ability to work on fast based environment. EDUCATION DETAILS: Degree- Highest Masters Stream Business Administration (Executive MBA) University University of Cumberland s, USA Graduated In 2022 Degree Masters Stream Engineering and Operations Management University University of New Haven, USA Graduated In 2018 Degree Masters Stream Human Resources Management University Acharya Nagarjuna University, India Graduated In 2012 Degree Bachelors Stream Computer Science University Andhra University, India Graduated In 2008 TECHNICAL SKILLS: Modeling Tool MS Visio Methodologies Scrum, Agile methodology BI Tool MS Fabric, Power BI, Power Apps, Logic Apps, Power Automate, Tableau, MSBI Database SQL Server, Oracle, Teradata, HIVE in Hadoop, Azure Data Lake, Azure Blob Storage, Azure Data Explorer-Kusto Project Management & Version Control Tools JIRA, Bit Bucket (Version Control System), Azure DevOps, Azure Repos Ticketing Tool Service NOW Employer: SYGNUSIT, Dallas, TX Aug 2022 Present Projects: Client: Microsoft, Redmond, WA Aug 2022 Present Role: Sr MS Power BI Engineer Project Description Microsoft Corporation is an American multinational technology company. Have been working in various projects under Microsoft Cloud for Sustainability team and Industry Solutions team for developing and maintaining MCfS and BIS telemetry dashboards which track different trends for various cloud solutions usage and performance. These dashboards are extensively designed for the leadership teams for their periodical reviews which help them to track the performances and make funding decisions for solutions enhancements. Responsibilities: Have been working as a Senior Power BI Developer/Lead for this project with Microsoft Cloud for Sustainability team. Gathering the requirements from the client and analyze the data required for report development. Documenting the data, technical and design requirements of the data analytics reporting. Coordinating with cross-functional teams for meeting the expected reporting requirements. Collaborating with the engineering teams for all the queries required for reporting metrics. Work on Lens orchestration tool to integrate data from different data sources, transform and then store in a ADX storage. Scheduling and monitoring the Lens jobs to ensure continuity in sourcing and storing of historical data in our data cold storage in Azure Data Explorer Kusto storage. Work on enhancing the queries to reduce the Lens pipeline run times. Developing the data model inside Power BI with measures, facts and dimensions in a Star Schema model to match to the requirements. Develop the Power BI dashboards and reports for exhibiting the carbon emission KPIs viz., emissions, emission comparisons, emission projections, monthly active tenants, monthly active users, all the month over month and week over week trends to MAT and MAU and many more with the data sliced and diced dynamically on the visuals. Develop dynamic visualizations making use of the best visuals with all the possible latest features and dynamic functionalities. Create measures and KPIs with DAX in Power BI and incorporate the dynamic functionality in filters, slicers and visuals on the report. Work on Microsoft Fabric to integrate all the data sources into One Lake through Data Lake pipelines in Fabric, and create Data flows Gen2 as and when required. Publish the dashboard on the production workspace and apply an automatic refresh by incorporating Incremental Refresh Policy to the data sets. Deploying the BI solutions through development, testing and production environments and automating the deployment processes. Continuous monitoring of the BI solutions and improving the report functionality through advanced performance tuning techniques. Providing production support to the BI solutions in production by trouble shooting the customer issues through root-cause analysis from end-to-end. Communicating with business users, program managers, stakeholders and end users for demo sessions, and the usage of BI solutions. Employer: Cherish Technologies Inc, Fremont, CA May 2021 July-2022 Projects: Client: Microsoft, Redmond, May 2021 July -2022 Role: Sr MS Power BI Engineer / Analyst Project Description Microsoft Corporation is an American multinational technology company. Green SKU M365 project is development of a Power BI template application to provide cloud customers with transparency into their M365 cloud emissions and management capabilities. Emissions are thus calculated and visualized in a Power BI report. This template app Emissions Impact Dashboard for M365 is available in Microsoft AppSource for users to download and instantiate the app with their cloud account. In the application customers can track their company s carbon emissions, projections and analyze the emission reductions with business intelligence admitted in the application. Responsibilities: Worked as a Senior Power BI Developer/Lead for this project. Gather the requirements from the client and analyze the data required for report development. Document the data, technical and design requirements of the data analytics reporting. Coordinate with cross-functional teams for meeting the expected reporting requirements. Working with the engineering team for emissions data. Develop the data model inside Power BI with measures, facts and dimensions in a Star Schema model to match to the requirements. Develop the Power BI dashboards and reports for exhibiting the carbon emission KPIs viz., emissions, emission comparisons, emission projections and many more with the data sliced and diced dynamically on the visuals. Develop dynamic visualizations making use of the best visuals with all the possible latest features and dynamic functionalities. Create measures and KPIs with DAX in Power BI and incorporate the dynamic functionality in filters, slicers and visuals on the report. Worked to create a Power BI App through a template app workspace and then finally have it deployed on the customer s tenant. Deploying the BI solutions through development, testing and production environments and automating the deployment processes. Maintaining BI admin portal and environments and managing the workspaces and user accesses to operate the BI solutions. Continuous monitoring of the BI solutions and improving the report functionality through advanced performance tuning techniques. Providing production support to the BI solutions in production by trouble shooting the customer issues through root-cause analysis from end-to-end. Communicating with business users, program managers, stakeholders and end users for demo sessions, and the usage of BI solutions. Employer: Adam Information Technologies LLC, Madison, WA Jul 2018 April 2021 Projects: Client: Microsoft, Redmond, WA Jul 2020 April 2021 Role: Sr MS Power BI Engineer / Analyst Project Description Microsoft Corporation is an American multinational technology company. Green SKU Azure project is development of a Power BI template application to provide cloud customers with transparency into their Azure cloud emissions and management capabilities. Emissions are thus calculated and visualized in a Power BI report. This template app Emissions Impact Dashboard for Azure is available in Microsoft AppSource for users to download and instantiate the app with their Azure cloud account. In the application customers can track their company s carbon emissions, projections and analyze the emission reductions with business intelligence admitted in the application. Responsibilities: Worked as a Senior Power BI Developer/Admin for this project. Worked in an Agile methodology with onshore-offsite model. Gathered the requirements from the client and analyze the data required for report development. Analyze and get the required transformations applied to the raw data and then finally import it from Azure Data Lake and Azure Logic Apps to Power BI. Develop the data model inside Power BI with measures, facts and dimensions in a Star Schema model to match to the requirements. Develop the Power BI dashboards and reports for exhibiting the carbon emission KPIs viz., emissions, emission comparisons, emission projections and many more with the data sliced and diced dynamically on the visuals. Develop dynamic visualizations making use of the best visuals with all the possible latest features and dynamic functionalities. Create measures and KPIs with DAX in Power BI and incorporate the dynamic functionality in filters, slicers and visuals on the report. Work with Power BI Rest APIs and Azure ARM Rest APIs for programmatically performing the Power BI Report and Embedding Operations. Work on Power Shell scripts to create Azure resources required for Power BI Embedding Setup. Have worked to create a Power BI App through a template app workspace and then finally have it deployed on the customer s tenant. Unit test the report and share it on the Power BI Workspace on Cloud for final UAT. Publish the dashboard on the production workspace and apply an automatic refresh by incorporating Incremental Refresh Policy to the data sets. Embed Power BI reports on to the Green SKU application and monitor the performance of the report and Azure Power BI Embedded Resource on the application regularly. Client: T-Mobile US, Inc., Bellevue, WA Mar 2020 Jun 2020 Role: Sr MS Power BI Developer Project Description T-Mobile is an American wireless network operator providing wireless voice and data services in the US. Quantum Reporting Insights project is a Big Data Team sourcing data from different applications to Hive tables in Hadoop environment and thereby develop business insights through Power BI reporting tool. These Power BI reports are further hosted on Quantum Premium workspace and shared to the business users to analyze different performance KPIs of their applications. Responsibilities: Have worked as a Senior Power BI Developer in Quantum team and developed various performance KPIs to several legacy business applications in T-Mobile. Have worked in an agile methodology and gathered the requirements from the business users and analyzed the data to perform suitable transformations. Played with the data in hive tables by querying it from Teradata Studio Express and Putty to understand the granularity of the data to be achieved to reduce the load on Power BI while pulling the data from source. Developed POCs and Mockups to the dashboards and reports in the initial phases to provide a clear vision to the business user on the future reports. Coordinated with Quantum ETL team offshore to source the required data from applications to hive tables and thereby push that to Teradata database, with data query optimizations. Connected Power BI with different sources like Azure Data Explorer (ADX), Teradata, psv/csv files, excel, and web files to develop most of the reports. Worked in modelling data in Power BI data modelling pane to set/modify the relationships between tables in the model. Developed performance KPI reports to study the Drop Call Rates, Service Rates, Network Errors, Subscriber reports, Network usage reports and Customer experience dashboards with Power BI. Created interactive visualizations like pie charts, donut charts, guage charts, tables, multi cards, combo charts, line charts, and sliced the visuals with slicers and filters. Created measures using DAX to calculate the KPIs, ranks and top valued dimensions. Played with DAX to establish dynamic slicers, dynamically changing x-axis and field formatting through color rules. Participated in weekly business meetings and daily touch bases for user reviews to the developing report and worked on the changes recommended as and when required / suggested by the user. Performed unit testing to the developed report and published to the Power BI Service. Worked on both Power BI Pro and Premium workspaces where the reports are well organized in Dev, QA and Prod workspaces to establish a standard pipeline. Have worked with setting up of auto-refreshes by configuring data sources to the Power BI Gateway. Worked on query folding and have set-up incremental refreshes to the reports as the data is huge with more than 10M of rows. Delivered the reports in time with all the report specifications, automations, and subscriptions to the satisfaction of the business user. Monitor the Power BI Dedicated capacities and scale them up or down as per the requirement and work on improving the performance of reporting processes. Client: Depository Trust & Clearing Corporation, Jersey City, NJ May 2019 Jan 2020 Role: MS Power BI Developer/Business Analyst Project Description DTCC is a financial services company providing clearing and settlement services to the financial markets. Agile Metrics Dashboard project was initiated as a part of Agile hackathon held in the company. This project was intended to create different agile metrics to track the Scope, Quality and Performance of the projects within the organization. MS Power BI tool was chosen to create these Agile Metrics. Responsibilities: Worked as Power BI Developer and an On-Site coordinator to gather business requirements from the stakeholders and the Clients and transform them into technical requirements. Analyzed the requirements and coordinated Off-Shore team for the required ETL operations to be developed for extracting the data. Involved in complete end-to-end SDLC process for the project. Involved in developing ETL packages with SQL Server Integration Services (SSIS)- ETL tool and extracted data from different sources, staged them to the SQL Server and then pushed it to Power BI for report creation. Worked with different sources viz., JIRA Project Management Tool, PPM- Project Portfolio Management Tool, MS SQL Server, Share point and MS Excel. Created Dashboards from Service NOW data and SERENA Business Manager for creating tickets and Incident analytics. Worked on data connectors like Share point folder and Share Point Lists to import JIRA Portfolio data and Performance Point dashboard/reports data into Power BI as part of our Enterprise Agile dashboard. Experienced in importing Share point Performance Point reports, Glint Survey reports into our dashboard for enhancing them with interactive visualizations. Experienced in importing Workspace analytics data though OData connector. Created different visualizations in Power BI viz., Matrix tables, Line Graphs, KPI cards, Bar Charts, Pie Charts, Meter Gauge and Sparkline Charts as per our client s requirements. Implemented all the latest features in Power BI, viz., data colors for matrix values with conditional formatting, drill up, drill down drill through functionalities, page, report and visual level filters, bookmarks, drilling data through a hyperlink, creating buttons and toggles with slicers, as per our Agile Metrics Dashboard requirement. Have created Power BI App Workspaces for collaborating and sharing the development across developers. Also created and managed Power BI Apps for sharing the Power BI reports to the end users and stake holders through different AD Groups. Managed Power BI Gateways for setting and monitoring automatic data refreshes. Worked closely with Product Owner and the Clients to review the developments, pen down the remarks/feedback and any new requirements in weekly & adhoc Client review meetings. Coordinated with Off-shore to work on the Client Feedback and get them accommodated to the next meeting and drive towards the UAT sign-offs. Worked in maintaining a version control system in Bit Bucket through GIT HUB. Worked with Service Now Tool for raising the required tickets for the team. Have given several demos of the dashboard to the end users through XLU sessions. Carried on responsibilities of getting all the required approvals and servers for the project to comply with DTCC policies, by connecting with different teams viz., Server Build Team, Desktop Engineering Team, Firewall Team, DBA, and Technology Risk Management Team. Have also worked as a Virtual Scrum Master to manage & track our project in JIRA tool and have done regular tasks like sprint & backlog planning, creating & managing User Stories, identifying & clearing of impediments, assigning roles & project permissions, conducting daily scrum calls, weekly client review call with a roadmap and offshore calls to track and analyze any negative impacts on the deliverables and team s productivity. Worked in updating and maintaining of technical, user guidelines and disclaimer documents of the project, in parallel to the project s progress. Have actively participated in innovative council meetings across DTCC and maintained a very good relationship with the team. Have built an exceptional Client relationship through regular engagements and responding to every concern of them with our dashboard. Environment: MS Power BI, MS SQL Server 2016, SQL Server Data Tools Visual Studio for BI - 2013, JIRA, Bit Bucket, Service NOW MS Power BI Developer Intern Oct 2018 - Apr 2019 Madison, WI, USA Responsibilities: Worked in in-house projects of Adam in sourcing and analyzing the data from different sources and developing business reports for the business users. Worked in writing complex T-SQL queries to extract user requested data from different on-premises data bases Extensively trained on Microsoft Business Intelligence (MSBI) Stack consisting of SQL Server Integration Services (SSIS), SQL Server Analyzing Services (SSAS) and SQL Server Reporting Services (SSRS). Worked in Microsoft Power BI tool to generate business analytics and dashboards for business analysis. Have worked in-house projects to design and develop tasks involved in extracting, transforming and loading the data packages to different staging and destination databases using SSIS. Designed tabular data models in SSAS to facilitate a more organized data to the reporting platforms. Worked with MS-Visio to reverse engineer the existing data models as per the client s requirements. Designed and developed many business periodical and adhoc reports viz., tabular, matrix, drill-through, parameterized and graphical reports with SSRS tool and deploy them to the end users for business analysis. Worked with MS Power BI tool to generate many interactive business dashboards and reports using different visualizations, Data Analysis Expressions (DAX), calculated measures and calculated columns. Have extensively worked in extracting data from different databases, analyzing the data, reporting the data, monitoring the data through scheduling the data updates and analytics reports to reach the business user for further business analysis and take decisions to improve the Business Key Performance Indicators using the BI tools. Power BI Developer Intern (Unpaid) Jul 2018 to Sept 2018 Madison, WI Responsibilities: Trained and worked in in-house projects of Adam in sourcing and analyzing the data from different sources and developing business reports for the business users. Worked in Microsoft Power BI tool to create reports and business analytics. Trained and worked in extracting, transforming and loading the data packages to different staging and destination databases using SSIS. Designed tabular data models in SSAS to facilitate a more organized data to the reporting platforms. Trained in reverse engineering the data schema in MS-VISIO. Designed and developed many business periodical and adhoc reports viz., tabular, matrix, drill-through, parameterized and graphical reports with SSRS tool and deploy them to the end users for business analysis. Worked with MS Power BI tool to generate many interactive business dashboards and reports using different visualizations, Data Analysis Expressions (DAX), calculated measures and calculated columns. Have extensively trained and worked in extracting data from different databases, analyzing the data, reporting the data, monitoring the data through scheduling the data updates and analytics reports to reach the business user for further business analysis and take decisions to improve the Business Key Performance Indicators using the BI tools. Employer: GO4BIZ.com, CT, USA Jan 2018 to May 2018 Operations BI Developer/Analyst (Power BI) Intern New Haven, CT, USA Responsibilities: Worked as a Power BI Developer to develop Operational and Performance reports which are in turn used by the Client to analyze and track the project operations. Have worked in collecting the requirements from the business user, design and develop the project operations. Worked in planning the project operations, tasks and schedules. Developed the technical requirements and participating in developing them too. Have conducted weekly and by-weekly project status meetings with the business user and IT developing team to monitor the project status, technical aspects and deadlines. Worked with Power BI tool to develop interactive reports through KPIs, line graphs, pie charts and matrix tables. Have developed calculated measures and columns using DAX and have worked with SQL server as a data source along with MS Excel. Have given report demos to the business user and rolled out the metrics to users. Was responsible to maintain a concrete communication and coordination between the teams and the end user to ensure smooth flowing of operations. Have done technical and statistical analysis of the system in the project on a regular basis to avoid uncertainties. Worked and implemented all the operations management skills to manage the IT operations of the project, design & develop the system, optimize the analysis and business reporting services through performance tuning, critical thinking and problem-solving techniques. Employer: Karur Vysya Bank Ltd May 2010 to Aug 2016 Operations / Credit Analyst Andhra Pradesh, India Responsibilities: Have worked as an IT Operations Analyst in both Front-End and Credit Operations. Experienced in managing cash services. Worked extensively in Credit data analysis models and Credit process. Developed financial ratio analysis systems to ensure the Credit Worth of the financial project proposals. Experienced in analyzing the financial balance sheets to process Credit proposals of the bank through BI tools. Have worked in analyzing the borrower s net worth and business capability by analyzing all financial statements, Credit report, CIBIL report and market intelligence report of the borrower s business. Have a very good knowledge in all the Credit Operations principles and procedures viz., KYC and AML. Worked in preparing the legal documentation with all the terms and conditions as per the sanctioned Credit. Have worked in monitoring the branch operations through different periodical performance reports of the borrower accounts. Have got certified as a Junior Associate in Indian Institute of Banking which develops a strong knowledge in principles and procedures of Credit and Operations in financial domain. Experienced in conducting meetings with the bank officials and business customers to collect the financial requirements and plan the branch s business growth accordingly. Keywords: quality analyst business intelligence active directory information technology golang microsoft California Connecticut New Jersey Texas Washington Wisconsin