Eshitha Reddy

Sr. BI Developer

443-***-****

ad4qdm@r.postjobfree.com

Summary:

·Solutions-oriented data and Power BI analyst with a proven track record of analyzing large datasets in various fields, such as healthcare, engineering and technology for over 8+years. Highly proficient in SQL, PL/SQL, MySQL, ODBC and DAX languages.

·Experienced in Data warehousing and Business Intelligence technologies developing Reporting and Dashboards using Tableau and PowerBI.

·Extensive knowledge in SQL, SharePoint, Excel databases for building reports.

·Strong hands-on experience implementing dash boarding, data visualizations, and analytics using Power BI desktop and service,Tableau desktop.

·Good experience on in dashboards designing with large data volumes from various data sources (SQL server, SharePoint, Excel databases etc.).

·Developed strategic reports for executive decision-making using advanced data visualization techniques.

·Collaborated with cross-functional teams to identify business requirements and translate them into technical specifications.

·Reduced manual reporting efforts by creating self-service dashboards for various user groups.

·Experienced in working with SQL scripting to validate the reports generated in Power BI and Tableau.

·Experienced in building Power BI, SSRS,Tableau reports visualizing data using charts, tables, and Dashboards for business analytics.

·Experience in using Business Intelligence tools in MS SQL Server 2008, 2012.

·Extensive experience and proficiency on the design, construction and implementation of ETL Process (Data Extraction, Transformation layer) with Power Query, Data mapping, Data Cleansing, MSSQL Databases, Reporting Services (SSRS).

·Designed customized data collection models for specific visualization tasks.

·Excellent working knowledge of the power Query, SQL and DAX funtions.

·Created many Drill through and Drill Down reports using Power BI.

·Prepared and published customized reports/dashboards in Power BI and Tableau servers.

·Created different Action filters, Parameters and calculated fields to create most complicated dashboards.

·Strong analytical and problem-solving skills coupled with excellent written, verbal and interpersonal communication skills.

·Experience on creating Power BI Dashboards and deploying the dashboards on the server.

·Expertise in ETL tools. Expertise in migrating data sources from MS-Access, MS excel and other data sources.

·Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.

·Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameters using Tableau.

·Extensively involved in creating graphs by using measures and dimensions data from various databases by using data blending concept.

·Experience in microsoft technologies, including SharePoint Server 2013/2016/2019 and SharePoint Online, Ofifice 365 components, clinet and server-side custom solutions for SharePoint Online and On-Premises environment.

·Designed and developed intranet, divisional and departmental SharePoint landing Pages.

·Building electronic forms and business process workflow using Power Apps, SharePoint Designer, Power Automate, HTML,CSS, Bootstrap, REST API, JS/JQuery.

·Extensive knowledge in Configuring, Design, developing, Migrating and Maitaining SharePoint-base solutions.

·Deep knowledge and experience on stage of Software Development Life Cycle(SDLC) Waterfall and Agile environmet.

·Strong experience in creating and managing site collections, sites, lists, libraries, views, content types, columns, site columns, pages and webparts.

·Designed and developed a new intranet SharePoint Portal Site to improve collabration among employeees using SharePoint modern communication site.

·Experienced in using and managing Office 365 Components such as Office 365 Group, One Drive, Teams, Planner, Stream, Sway, To-Do,One-Note Yammer and Office Online.

·Experienced in PowerApps and Nintex form in designing, developing and defining data structures of electronic form and integrating within the SharePoint Platform.

·Hands-on experience in designing workflows with SharePoint Designer 2010/2013, Nintex, Microsoft fow - PowerAutomate.

·Experienced in Power Automate working with services, triggers, actions, conditions, parallelism and loop-Run a flow on a schedule,calling custom bussiness services Using Approval options, observing Flows with Power Apps.

·Customize list and build an electronic form using PowerApp, HTML, CSS and JS.

·Set Up permission levels Authorization and Authentication for individual users and groups.

·Creating Technical and Documentation for developed Application.

·Assit with developing materials and End-User as needed.

·Involved in migrating content to SharePoint Online.

·Extremely diligent, strong team player with an ability to take new roles.

Technical skills:

Databases

MS SQL Server 2016/2012/2008,MS-Access, SharePoint 2013/2016, Snowflake

SQL Server Tools

Business Intelligence Development Studio, Enterprise Manager, Query Analyzer, Export & Import (DTS), SQL Profiler,

BI Tools

Tableau Desktop, Tableau Server

Power BI Desktop (2.68), Power BI Service, Power BI Report Server

Operating System

Windows NT, Windows 2000, Windows 2003, Sp3, UNIX, Linux.

Languages

T-SQL, VB.NET,Data query language: SQL, DAX

Other Tools

SQL Loader, MS VISIO, Microsoft Office, Microsoft Office365,PowerApps, Power Automate,Microsoft Visio, MS Visual Studio 2003/2005, Team Foundation Server, JIRA.

Professional Experience:

Inovalon, Maryland, MD

Sep 2021 - Present

Sr. BI Developer

Inovalon is a leading provider for health plans, and provides analytics and insights to improve operational transparency, clinical quality metrics, risk-score accuracy, patient engagement and economic performance for providers, it delivers real-time data and analytics that simplifies the administrative and clinical complexities of healthcare and enables actionable insights to drive improved quality of care and informed decision making at the point of care.

Responsibilities:

·Specifies, analyzes, designs, implements and tests BI solutions to meet business needs.

·Takes ownership of our data and constantly improve its quality and integrity. Proactively identifying issues at every step and coordinating the implementation of required fixes.

·Partners with business stakeholders to understand their requirements and assist in the development of dashboards, visualizations and solutions tailored to their needs.

·Documents existing processes, architectures and code.

·Involved in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema

·Takes ownership of our data and constantly improve its quality and integrity. Proactively identifying issues at every step and coordinating the implementation of required fixes.

·Created and maintained databases, tables, stored procedures DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL

·Worked extensively on creating complex queries including correlated queries and queries with complex joins involving multiple tables and aggregate functions.

·Experience in using Temp tables, CTE’s, Variables, Cursors while creating store procedures

·Experience and query optimizations and performance improvements of stored Procedures .

·Created ETL process using SSIS to transfer data from heterogeneous data sources into data warehouse systems with various steps,

·Used different Control Flow Tasks and Data flow Tasks for creating SSIS Packages. Designed packages using different types of Transformations for Data Conversion, Derived Columns with Multiple Data Flow tasks and Created user variables, property expressions, script tasks to create data flow tasks in SSIS.

·Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.

·Implemented incremental Load for many SSIS packages.

·Worked on Control flow tasks such as Execute SQL task, Send Mail Task, File System Task, Dataflow Task and used different data sources and destination with derived column, lookup transformation within Dataflow Task.

·Worked on Microsoft Office 365 components like SharePoint, OneDrive, Power Apps, Power Automate,Power BI, Teams, Stream, OneNote, Planner.

·Developed lists and libraries using site column and content type and set the appropriate permission level on lists and site

·Customize out of the box features to achieve the desired solution to fulfill customer requirements.

·Created content types for different document libraries with various metadata fields associated with each content type.

·Creating survey using MS Form and connecting to power automate to collect the feedback of the event.

·Creating Hub site to navigation among sites, focus on finding content that resides within the hub site’s associated sites.

·Develop PowerApps form to replace SharePoint InfoPath application.

·Create powerful app and customizing lists using canvas App.

·Set up permission levels and permissions for Users, in Active Directory and SharePoint group to manage access for sites, Pages, Libraries, and lists.

·Implemented a custom email notification mechanism through SharePoint designer.

·Converted existing Nintex workflow and form using PowerApps and Microsoft Power automate (Flow) to improve Business process .

·Implemented PowerApps Role Based Security using SharePoint Group & Flow.

·Developed Power App form and Automated using Microsoft Flow.

·Created workflow to Automate work paper approval system using Microsoft Flow.

·Customized the look and feel of individual sites by adding a collapsible left navigation and unique looks to the master page using Content Editor Web Part and script editor webpart

·Utilized SharePoint Designer to create an external list and BCS application definitions to integrate content from external data sources.

·Create Hub site that helps to organized across site of sites and show case content.

·Built Report from different Data source like SharePoint list using Power BI.

·Collaborated with cross-functional teams to identify data sources and streamline data collection resulting in a 25% reduction in report development time.

·Assists, mentors, and instructs lower-level developers and analysts as needed.

·Develop intercative visuals, KPI scorecards using Power BI desktop application.

·Proficient in writing complex DAX functions to generate reports based on Daily, Monthly and Yearly data.

·Create rich Power BI visualizations, DAX queries and work with Power Query, M code language for data integration and transformation as per the business requirement.

·Created workspace and Apps in Power BI service(SaaS) and giving access to end users to Apps.

·Configure Power BI report Server for SSRS, deployed and scheduled reports in Report Manager.

·Created Paginated reports in Power BI report builder for on-premises and cloud data sources.

·Created Row-Level-Security and integrated with Power BI Service(SaaS) Portal.

·Maintained Different level of data security in Power BI while granting access to data and Assigning Row-Level-Security when needed.

·Skillful in using Power BI features such as bookmarks, selection pane, drill-down and drill-throughs.

·Used Power BI and Power pivot to develop Data Analysis Prototype, and used Power Map to visualize the reports.

·Designed, developed, tested, and maintained Tableau functional reports based on user requirements.

·Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameters using Tableau.

·Extensively involved in creating graphs by using measures and dimensions data from various databases by using data blending concept.

·Created different KPI using calculated key figures and parameters.

·Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.

·Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.

·Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.

·Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.

·Utilized Tableau server to publish and share the reports with the business users.

·Responsible for creating calculated fields, combine field, bins, sets, geo coding and hierarchies using Tableau Desktop.

·Involved in creating a dual-axis bar chart with multiple measures.

·Writing stored procedures and triggers extensively and working very closely with developers, business analyst and end users to generate various audit reports and troubleshoot their query problems and connectivity problems.

·Facilitated simplified access of database for end users using demoralized views and created triggers on them to maintain to database integrity.

·Created Cursors to facilitate the users (credit officers) to scroll through the Queues to perform manual operations on the payment.

·Created ftp connections, database connections for the sources and targets.

·Maintained security and data integrity of the database.

·Used SQL Profiler to trace the slow running queries and optimized query execution with the use of Index Tuning Wizard and Rebuild indexes if necessary.

Environment: Power BI,Tableau,SharePoint,PowerAutomate,PowerApps, MS SQL Server 2012 /2016/, Windows 10, T-SQL, SSIS, TFS 2017, JIRA,7 Agile Environment.

Blue Cross Blue Shield of Michigan

Aug 2018- May 2021

Sr. BI Developer

Responsibilities:

·Extracted data for reporting from multiple data sources like SQL Server, SQL Server Analysis, SharePoint,Excel.

·Extracted data from data warehouse server by developing complex SQL statements using storedprocedures and common table expressions (CTEs) to support report building.

·Implemented Tableau for visualizations and views including scatter plots, box plots, heatmaps, tree maps, donut charts, highlight tables, word clouds, reference lines, etc.

·Generated complex reports in Tableau using multiple functionalities including context filters,hierarchies, parameters, LOD Expressions, time intelligence, etc.

·Built interacting and storytelling dashboards in Tableau workbooks using dashboard actions.

·Published Tableau workbook on Tableau Server and set report refresh

·Used Data Analysis Expressions (DAX) to create measures and calculated fields to analyze data and to create time intelligence.

·Extensive use of DAX (Data Analysis Expressions) functions for the Reports and for the Tabular Models.

·Used Data Analysis Expressions DAX to create custom calculations in PowerPivot for Microsoft Excel workbooks and Analysis Services tabular model projects.

·Created PowerPivot models and PowerPivot reports, publish reports onto SharePoint, and deploy models into SQL Server SSAS instance.

·Assisted in creating SQL database maintenance logs and presenting any issues to the database architects.

·Worked on Power BI reports using multiple types of visualizations including line charts, doughnut charts, tables, matrix, KPI, scatter plots, box plots, etc.

·Made Power BI reports more interact and activate by using storytelling features such as bookmarks,selection panes, drill through filters, etc.

·Created and administrated workspaces for each project on Power BI service and published the reports from Power BI Desktop to Power BI Services workspace.

·Utilized Power BI to create various analytical dashboards that helps business users to get quick insight of the data.

·Created reports on daily / weekly / monthly base for accuracy.

·Implemented report integration among Power BI, Tableau, SSRS reports.

Environment: Power BI,Tableau,SharePoint, MS SQL Server 2012 /2016/, Windows 10, T-SQL, SSIS, TFS 2017, JIRA,7 Agile Environment.

Cyient, Hyderabad, India

Jan 2015 – Jan 2018

SharePoint Developer

Cyient is a global company that offers engineering and technology solutions for various industries, such as smart manufacturing, smart mobility, digital healthcare, and digital energy.

Responsibilities:

·Interact with the Business Analysts for requirement analysis and created Functional Specification Documents based on the business requirements.

·Create Top Level sites and site collections. Maintained a unique look and feel across the portal by using Master Pages, CSS and HTML. Additionally designed and manipulated these pages using SharePoint Designer.

·Create Web Parts using SharePoint Designer to display live feeds by consuming web services.

·Created custom Content Types and Site Columns programmatically for standardizing List and Document Form Libraries using Visual Studio.

·Developed and deployed provider-hosted apps for SharePoint 2013/Office365.

·Developed applications in SharePoint Designer using REST APIs and CRUD operations.

·Creation of an application that was developed using SharePoint 2010 in a medium server farm configuration.

·Created a series of event receivers and workflows to assign tasks to user who can than track and update the tasks.

·Designed and implemented complex workflows using Nintex workflows.

·Developed SSRS and Power BI reports to visualize the data based on requirements.

·Generated reports based on Daily, Monthly and Yearly data using complex DAX functions.

·Create rich Power BI visualizations, DAX queries and work with Power Query, M code language for data integration and transformation as per the business requirement.

·Created workspace and Apps in Power BI service(SaaS) and giving access to end users to Apps.

Environment: Microsoft SharePoint Server 2013/2016.SharePoint Online/Office 365 Power Apps, Power BI, Nintex.

Programming languages: HTML, CSS, JavaScript, jQuery, Json, Knockout JS.

Contact this candidate