Lavanya Shanigaram Email & Phone Number

Austin, Texas, United States

Austin, Texas, United States

Client: Blue Cross Blue Shield of Michigan  Created various reports and dashboards in Power BI with different types of sources like Excel, SharePoint, SQL server, Power BI shared datasets and CSV files. Transformed data by using merge queries/ append queries in the Edit Queries section on Power Bi Desktop. Designed and deployed reports with Drill Down and Dropdown menu option and Parameterized and linked reports using Power BI.  Created Data extracts for better performance and accessing data offline.  Analyzed the requirements and discussed with managers and leads on the functionality.  Extracted data from different kinds of source systems into Power query and then cleansed the data by applying business rules and loading it into Power Pivot.  Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.  Created New Calculated Columns and Measures using DAX Expressions like filters, Aggregate, Mathematical, Time Intelligence Functions, etc. Created visualizations like Tabular, Bar, Card, Funnel, Line, Gauge, Doughnut, Waterfall, Slicers, Pie Charts, Tree Map, and Matrix by using Power BI.  Created Groups and content packs in the power BI services.  Worked on On-Premises Gateway to refresh the data sources/creating a live connection.  Implemented Role Based and Row Level Security as part of security in Power BI.  Shared the Reports & dashboards to end users.  Strongly worked with selection and bookmark panes for hiding and displaying visuals according to the required selections. Created Microsoft Power BI Dashboards in Power BI Service using Reports.  Installed and Configured Data Gateways to Refresh and Schedule Refresh the Dataset.  Managed access of Reports, Dashboards and Data for individual users using roles.  Participated in regular Technical Reviews, Defect review and walkthrough meetings with important project and business stakeholder.

Austin, Texas

Client: SLB SCHLUMBERGER Imported data from different data sources to create Power BI Reports and Dashboards. Involved discussion with business users for gathering the requirements and driving daily call with clients and Translating End- User requirements into Efficient Dashboards. Developed and maintained multiple Power BI dashboards/reports and content packs. Created, developed, and deployed reports and dashboards for large volumes of data in Power BI. Worked on Power Apps and integrating power BI Automation across the Power Apps.  Implemented Row Level Security (RLS) as per requirement. Created different visualizations like Line, Bar, Scatter Plot, Waterfall, Pie, Area, Donut Charts and Tree Maps etc. Designed different types of reports like Drill Down, Drill Through and Sync Slicers. Develop Visual Level Filters, Report Level Filters, and Page Level Filters in Power BI. Created Workspace and content packs for users to view the developed reports. Scheduled Automatic refresh and scheduling refresh in POWER BI service. Installed and configured Enterprise gateway and Personal gateway in POWER BI service. Published reports to Power BI server and providing access to required users. Involved discussion with business users and provided technical guidance for Power BI Desktop and Power BI Service. Created dashboards using Power BI Desktop which includes drillings, sorts etc. Created Filters and applied conditional formatting based on user requirement. Created scheduling reports using Data Gateway. Worked on Aggregation functions like SUM, SUMX, COUNT, MIN, and MAX in DAX.  Worked on time intelligence functions like YTD and MTD in DAX.  Published/shared the reports by Creating a content pack in app.powerbi.com/sharing the Pbix file. Created calculated columns and measures in Power BI Desktop. Assisted with developing business intelligence solutions by creating dashboards in Power BI.

Madison, Wisconsin, United States

Client: CUNA MUTUAL GROUP Worked in Data Analytics and Reporting team to analyze customer data like whether a credit can be issued to the customer or not according to credit scores and provide reports to team according to the business stakeholder requirements.  Provided detailed data/metrics reporting, analysis, and insights like personalizing offerings to customers, finding the target audience. Analyzed and provided quality data and reporting for performance analysis across all areas and leveraged data to help the organization achieve its strategic, financial, and operational goals. Designed and created dashboards and custom reports, using visualization software Power BI with interactive views, analysis, drill Up and drill downs. Monitored performance and optimized queries for maximum efficiency. Worked with subject matter experts (SMEs) and project team to identify, define, collate, document and communicate the data migration requirements.  Implemented fine tuning of database objects and server to ensure efficient data publishing a report to Power BI Services. Implemented several DAX functions Such as SUMX, CALCULATE, ALLEXCEPT, FILTER Functions. for various fact calculations for efficient data visualization in Power BI. Designed a Power BI data model with multiple fact tables and dimensions depending on the business requirements.  Created custom visuals and groups creation in Power BI.  Conducted performance tuning and optimization for Paginated Reports, minimizing loading times and ensuring responsive user experiences. Published reports in Power BI Service and done schedule refresh for the reports. Evaluated large datasets to identify trends and develop actionable insights. Strongly worked on scheduling refresh of Power BI reports, hourly and on-demand.  Applied the Business rules on the data coming from multiple operating companies.

Madison, Wisconsin, United States

Client: PNC Financial group  Developed mappings that performed Extraction, Transformation, and load of source data into Derived master’s schema using various Informatica power center transformations.  Identified data quality issues and worked with IT teams to ensure data accuracy, completeness, and consistency. Created and presented reports and presentations on data findings and recommendations to senior leadership and executives. Designed Various Power BI Dashboards & Reports using Complex DAX Queries. Created various measures and calculated columns using DAX functions. Implemented Row level security on data inside various Power BI reports as per requirements. Created different visualizations like Line, Bar, Scatter Plot, Waterfall, Pie, Area, Donut Charts and Tree Maps etc. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.  Developed and assisted users in creating and modifying worksheets and data visualization dashboards.  Created drill down and navigation reports using the Power BI Desktop in the team. Writing M Codes to customize the Power BI reports and designed complex queries to extract meaningful insights from databases. Developed Financial Statements (P&L reports) Using Power BI. Utilized advanced features of Power BI software like to link data from different connections together on one dashboard and to filter data in multiple views at once. Conducted statistical analysis, hypothesis testing, and predictive modeling to support data-driven decision-making processes. Created and presented reports and presentations on data findings Defined and documented Data Flows and Data pipelines involved in creating various reports. Transformed data between databases and external data sources using various transformations like Data conversion, Row counts, Merge Join, Look up, and Data flow task. Created Paginated reports by using Report builder and published them to power BI service.

Hyderabad, Telangana, India

 Developed and designed Excel-based sales forecasting model using various advanced features such as regression analysis, data validation, and goal seek. Developed multiple worksheets that organize and analyze sales data by products, region, and time period. Coordinated statistical data analysis, design, and predicted sales revenue based on historical sales data and market trends. Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources. Transformed project data requirements into project data models.  Created charts and graphs to visualize sales trends and patterns. Evaluated trends to understand competitive environments and assess current strategies. Analyzed project data by different aspects like invoices, quantity sold, returns and several other dimensions and made recommendations to improve project outcomes and team performance. Synthesized data to produce reports and polished presentations, highlighting findings and recommending changes. Developed and maintained data models to analyze large volumes of customer data. Developed predictive models to forecast future outcomes based on historical data points. Produced monthly reports using advanced Excel spreadsheet functions. Performed day-to-day Database Maintenance tasks including Database Monitoring, Backups, Space, and Resource Utilization Collaborated with cross-functional teams, such as marketing, sales, and product development, to understand their data needs and provide relevant insights and recommendations. Created and presented reports and presentations on data findings and recommendations to senior leadership and executives.

Hyderabad, Telangana, India

 Designed and developed a reporting data module for monthly, quarterly, and annual development churns analysis compared to the previous period.  Analyzed the data and produced a churn prevention prediction report. Produced monthly, quarterly, and annual reports using advanced Excel spreadsheet functions. Coordinated statistical data analysis, design, and information flow and completed all internal and client-driven reporting/analytic requests. Managing large datasets with functions: IF, SUM, INDEX, MATCH, VLOOKUP Created dynamic reports with PivotTables Building charts and graphs. Manipulated date, time, text, arrays and maintained Data recording, Data simulations, Data validation, Cell formatting, Advanced conditional formatting, and Building formulas.  Coordinated with other employees to gather types of data and add the data set to a spreadsheet. Analyzed, collected data for various types of business reports and Created business reports that provide insight into key data points. Analyzed data trends and created visualizations for management review. Managed multiple data projects simultaneously, working with teams, supervisors and clients. Designed business analysis and data recording systems for use throughout the department. Extracted data from primary and secondary sources and maintained databases and data systems in Excel and other data repositories, resulting in the reduction of data retrieval time. Performed data analysis and modeling using Excel for large datasets, resulting in the identification of key trends and patterns that provided strategic insights to management. Strongly used Microsoft Excel to create pivot tables, graphs, and charts. Collaborated with cross-functional teams to provide critical data support and drive business decisions based on data-driven insights. Interpreted data, analyzed results using statistical techniques, and provided ongoing reports to business objectives and key performance indicators.

Master Of Business Administration - Mba, Human Resources Management

Bachelor Of Science - B.Sc, Microbiology, General