Priyanka K

Contact No: 615-***-****

Email ID: adyc42@r.postjobfree.com

PROFFESIONAL SUMMARY

* ***** ** ********** ** Data Analysis, Design, Implementation, Administration and Support of Business Intelligence (BI) applications.

Experience in Tableau Desktop, Tableau Server, Power BI, Power BI Pro, Power BI Mobile.

Experience implementing data visualizations, dash boarding and analytics using Tableau desktop and Server.

Experience in creating Views, Constraints, Triggers, Joins, Cursors, Temp Table, Table Variable, Functions, Batch Scripts, and numerous Stored Procedure consumed at various stages of migration/cleansing process, reports, or data validation.

Experience in developing Dashboard Report, Parameterized Reports, Linked Reports, Sub Reports by Region, Year, Quarter, Month and Week.

Experience in optimizing Dashboards and Reports with a focus on usability, performance, flexibility, testability, and standardization.

Experience working with dataset ingestion, data model creation, reports, dashboards, KPIs, Power BI Pro features, workspaces, security.

Experience in creating Tableau scorecards, Dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts functionality.

Experience in configuration and maintaining report manager and report server for SSRS, Deployed and Scheduled the reports in Report Manager.

Experience in Ad-hoc reports, data driven subscription reports by using Report Builder.

Proficient in writing complex T-SQL (DDL, DML), CTE, Ranking Functions, TOP(n), PIVOT, XML PATH, SQL, and Performance tuning.

Experience in Microsoft BI suite of products such as SQL Server, SSIS, SSAS, SSRS and Power BI SDLC from prototyping to deployment.

Experience in implementing Power BI gateway different source to match analysis criteria and further modeling for Power Pivot and Power View.

Experience in developing scripts in SSIS and automate the tasks using C#, maintain the Log and Audit information in SQL tables, Error Handling by using Event Handler for SSIS Packages.

Experience in requirement gathering and estimating the hours of work based on the requirement from the client and maintaining the quality documents for all the work done till the end of the cycle.

Proven ability to identify business needs and develop valuable solutions to drive accuracy and process efficiency.

Expertise in Object Oriented Programming involved in Analysis and Design and Development of web-based applications using technologies: HTML, DHTML, CSS, XML, JavaScript, VB.net and C#.

Knowledge in integrating Power BI reports with other applications by applying embedded analytics, such as API automation or (SaaS) Power BI service.

Experience in SDLC methodologies such as Scrum/Agile for project execution using Jira/Story Board tools for user story handling.

Excellent problem solving, communication, analytical, interpersonal skills, and ability to perform independently or as part of a team.

Maintain strong and positive working relationships with all customers, providers, vendors, and team members.

TECHNICAL SKILLS

Development

Tableau, Power BI, T-SQL, PL/SQL, SSIS/SSRS

Tools/Methodologies:

SQL Prompt & Profiler, TFS 2010, Agile, Jira, Waterfall, Lucid Chart, SharePoint, Tableau, MS Excel, MS Access.

Languages:

C#, VB.net

Web Technologies:

HTML, CSS, JavaScript, jQuery, AJAX, XML.

Database:

MS SQL Server (2008/2010/2014/2017, R2/2012), MS-Access, SQL Server Integration Services (SSIS), Data Transformation Services (DTS), SQL Server Reporting Services (SSRS).

Experiences:

Microsoft

Feb 2023 – June 2023

Responsibilities:

Design and implement reporting solutions using Reporting Services, Power Bi, or other data visualization tools.

Design and create innovative and valuable visualizations to identify patterns, trends and exceptions which enable the business requirements.

Understand, take ownership of, and support operational dashboards and business performance dashboards; assess outcomes; summarize areas for improvement; and offer suggestions.

Assist in planning and managing changes to dashboards because of new or improved business processes.

Provide support to end users on Power BI dashboards and other business intelligence needs.

Skilled in creating and developing Power BI Dashboards into rich look for better understanding.

Involved in publishing Power BI Desktop reports to Power Bi Services.

Involved in fetching the data from different sources like SharePoint, Excel, Flat Files, XML, Azure and various other databases.

Created complex dashboard using parameters, sets, groups and calculations and drill down and drill up in worksheets and customizations using filters and actions.

Creating Row Level security with Power Bi desktop and integration with Power BI Service portal.

Reviewed project requirements to identify customer expectations and resources needed to meet goals.

Scheduled data refresh on Power BI Server for weekly and monthly increments based on business changes display accurately.

Involved in the configuration of Power BI Gateway to keep dashboards and reports up to-date with on premise data sources.

Participated in weekly requirements meetings with Business Users to get feedback and opportunities.

Developed complex SQL queries using stored procedures, CTE, temporary table to support reports.

Developed complex calculated measures using Data Analysis Expression Language (DAX).

Provided continued maintenance and development of bug fixes of existing reports and dashboards.

Troubleshoot and support reports in Power BI workspaces whenever there are issues in production.

Passion to understand the unknown. A willingness and desire to embrace unfamiliar process with an open-minded approach and a team player.

Environment: Azure Data Studio, Azure DevOps, T-SQL, Power BI, Windows 7, MS Word, MS Excel, MS Access

Freelancer Developer

Sept 2022 – Jan 2023

Responsibilities:

Developed business logic components for required systems.

Automated the process of generation reports for the consultants as required.

Developed graphical icons and images for the unique reports.

Developed an efficient user-friendly portal integrated datasets from different sources and the data used to create the power bi reports for analyzation.

Developed dashboards, visual reports and KPI scorecards.

Extract, connect, import, and transform data for business intelligence.

Developed data analysis expression queries for business requirement.

Environment: Power BI, Tableau, SQL Server 2022, SSMS, SSRS, Adobe, Snagit editor

Microsoft

Mar 2021 – June 2022

Responsibilities:

Reviewed project requirements to identify customer expectations and resources needed to meet goals.

Participated in weekly requirements meetings with FastTrack Partner Managers (FPMs) to understand the FastTrack Business and their needs.

Provided continued maintenance and development of bug fixes of existing FRP reports and dashboards.

Troubleshoot and support reports in Power BI workspaces whenever there are issues in production.

Developed complex SQL queries using functions, including Common Table expression (CTE) to support Power BI reports.

Implemented Row level security, restricted sharing and publishing, restricted export, and printing as per requirement.

Deployed and maintained different versions of the reports as per the release cycles.

Created Power BI visualization of dashboards and scorecards for different business users.

Developed reports based on the requirements and reviewed deliverables with them to ensure it satisfies their needs.

Integrated custom visuals and quickly integrated change requests requested by FRPs based on requirements.

Experience in transforming data into user friendly visualization to give business users a complete view of their business using Power BI.

Developed different KPI to show the difference between actual and forecast data.

Developed Power BI reports by using joins in multiple tables from multiple databases using complex SQL queries.

Experience in scheduling refresh of power BI reports, daily and on-demand.

Involved in creating several user roles and groups to the end-user with row level security.

Developed various solution driven view and dashboards by developing different chart types including Pie Charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area charts, Scatter Plots in Power BI.

Designed and implemented multiple dashboards using power bi- power pivot and power query tools for different metrics to be used in the report.

Implemented query optimization and performance tuning on the reports for user friendly.

Created page, report, and visual level filters according to the requirements.

Managed Power BI reports refreshes data and gateway refreshes.

Implemented Power BI functions including views, interactive dashboards, action filters, parameters, and calculated fields for KPI reports.

Deployed the reports to required environments after confirming the accuracy of contents, formats, and coloring from designated users.

Developed a report from importing, direct query and live data from several data sources.

Worked closely with the team in meeting the deadlines pertaining to design and development deliverables.

Involved in daily discussion with teammates and managers to discuss requirements, implementation, and difficulties on achieving the requirements.

Worked closely on identifying the risk, addressed, recorded, and communicated to managers followed by key stakeholders.

Collaborated with data integration team for reports deployment process.

Involved in backlog tracking and status reporting to key stakeholders using Azure DevOps.

Environment: SQL Server 2014/2017, T-SQL, Power BI, Windows 7, MS Word, MS Excel, MS Access, Azure DevOps

State of Tennessee

Oct 2017 – Feb 2021

Responsibilities:

Collaboratively worked with the team from requirements gathering to project development, deployment, and production support.

Involved in developing and deploying dashboards, visualizations, and dynamic reporting interfaces to be distributed to stakeholders via the Tableau reporting platform, web portal, mobile, tablet devices, widgets and emails.

Utilized Tableau to create various analytical Dashboards that depict critical KPIs such as financial matter, billing hours and case proceedings along with slicers enabling end-user to make filters.

Involved in building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

Wrote calculated columns, measures in Tableau desktop to show good data analysis techniques.

Developed scripts to pull data from various sources into Tableau such as Sql Server, MS Excel, MS Access.

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 and QA support to Tableau users and implemented custom SQL to support business requirements.

Involved in designing and documenting the best practices, documentation standards, processes and procedures for Tableau Dashboard design and publishing.

Weekly presentation to the business users about the reports and their changes as required on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.

Consistently complete tasks within agreed upon target dates.

Developed all types of transformations that are available in Tableau.

Created stored procedures and SQL queries to pull data into Tableau model.

Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.

Database creation (DDL, DML, DCL), database tuning, SQL tuning, performance planning.

Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.

Developed tabular queries for efficient analysis of report using Pivot/Un pivot in T-SQL.

Created or modified Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.

Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.

Developed jobs performance report that queries system tables to track the duration of each job and weekly-average duration using Tableau.

Designed and created data extracts, supporting SSRS, POWER BI, Tableau or other visualization tools reporting applications.

Created reports using Charts, Gauges, Tables, matrix and exported in different formats like PDF, XML, HTML, Excel, and CSV.

Created Parameterized Report, Dashboard Report, linked report, Drill Down Reports, Drill Through Report by Region and Sub Report by Year, Quarter, Month, and Week.

Environment: Tableau, SQL Server 2014/2017, SSMS, SSRS, T-SQL, Power BI, Windows 7, MS Word, MS Excel, MS Access, Share Point Jira, SQL Profiler, SQL Prompt

HFMA (Healthcare Financial Management Association)

April 2017 – Sept 2017

Responsibilities:

Actively participated in gathering Business Requirements that are focused on providing a user-friendly system usage or ambience.

Developed Power BI model used for financial reporting of P & L and Headcount.

Designed, deployed, and maintained various Reports in Power BI. Used Power BI Desktop for developing dashboards, visual reports, and key performance indicator (KPI) scorecards.

Implementing row-level security on data.

Created Data Analysis Expression (DAX) queries in Power BI Desktop.

Implemented some advanced-level calculations on datasets for telling a story on dashboard.

Expertise in extracting various data sources and connecting, importing, and transforming data for Business Intelligence.

Maintained a Sub-Reports, ad-hoc reports, Drilldown-Reports, Summary reports, and Cross Tab reports in SSRS.

Created ETL metadata reports using SSRS, reports include execution times for the SSIS packages, failure reports with error description.

Designed and developed a SSIS packages, store procedures, configuration files, tables, views, and functions and implemented best practices to maintain optimal performance.

Developed a good knowledge of secondary tools, such as SQL Data Warehouse, Azure, Visual Studio.

Used different Control Flow Tasks and Data Flow Task for creating SSIS Packages.

Used different types of Transformations for Data Conversion, Sorting and cleaning the data from different Sources into Company Format.

Created SSIS packages to download data from FTP sites and populate into different databases and tables such as MS Access, Excel to SQL 2008R2.

Expertise in scheduling reports to end-users and give access to the report server.

Created subscriptions such as standard and data driven in Report Manager SSRS to generate email notifications.

Developed and scheduled the cached reports in SSRS.

Optimized the query performance with modification in T-SQL queries, remove unnecessary columns, eliminating redundant and inconsistent data.

Developed and created the new database objects including tables, views, indexes, stored procedures and functions, advanced queries and updated statistics using Query Analyzer.

Involved in a meeting with the Business Analyst and data modelling team to understand requirements and suggest best possibility based on requirement.

Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.

Data conversion from text file into SQL Server table and database recovery and database maintenance plan

Involved in designing and implementing database logical and physical schemas and document the testing and maintenance of system corrections.

Designed the Functional Requirements and Mapping Technical Specifications based on Functional Requirements.

Designed dashboards, including scorecards, and reporting with the Dashboard Designer delivered via MOSS (Confidential Office SharePoint Server).

Involved in Agile development following Scrum process and daily stand-up meetings.

Environment: SQL Server 2012, MS Access, SSIS, SSRS, MS Word, MS Excel, Power BI, MS SQL Reporting Services 2008R2, SharePoint.

Tata Consultancy Services Dec 2014 – Mar 2016

Responsibilities:

Involved in gathering requirements and understanding the business flow.

Developed a complex SQL query, stored procedures, functions, triggers, joins and SSIS packages.

Developed custom reports and deployed them on server using SSRS.

Created Index, Views, Complex Stored Procedures, Triggers, Cursors, and appropriate User defined functions to implement the business logic.

Created audit database tables and automated stored procedures to update and clean the old data as business needs.

Transferred data from flat files, Excel spreadsheets, and XML Source data to SQL Server using SSIS and used BCP and Bulk Insert.

Involved in data modeling for the application and created ER diagram using Lucid chart.

Created, maintained & scheduled various reports in SSRS like Ad-hoc Reports, Canned Reports, Master Reports & Parameterized Reports, Drill Down Report, Drill Through Report using SQL Server Reporting Services SSIS.

Uploaded reports on to the report manager and organized them into folders.

Involved in Performance tuning of SQL queries and stored procedures using SQL Profiler.

Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.

Created document for Self-Service Deployment and Execution process for SSIS packages.

Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, triggers and problems related to the privileges.

Responsible to tune ETL procedures and schemas to optimize load and query Performance.

Assisted in application development, debugging, configuration, and optimization from a database perspective.

Performed tuning of databases by normalizing databases, establishing necessary joins, creating useful clustered index and non-clustered indexes.

Effectively created and used views in SQL Server to prevent unauthorized access.

Used all types of container tasks such as for loop, for each loop and sequence container in SSIS.

Developed Business logic layer by implementing Object Oriented Programming languages (OOPS) concepts abstraction, encapsulation, inheritance, polymorphism in C#.

Environment: MS SQL Server 2008, SSRS 2008, SSIS 2008, T-SQL, Visual studio 2008, C#, MS Access, Word, Excel, SQL Profiler, Lucid chart.

CERTIFICATION

Microsoft Certified: Azure Fundamentals - https://www.youracclaim.com/badges/05e308c1-192c-4b24-9c68-912bc2ea8489/linked_in_profile

EDUCATION

Master of Science in Computer Science

Middle Tennessee State University – TN

Bachelor of Technology in Electronics and Communication

Vignan University, India

Contact this candidate