Bhagyashree Sarangi

BI Developer LinkedIn

adlwfj@r.postjobfree.com

702-***-**** Las Vegas, NV – 89138

SUMMARY:

● ~5 years of experienced DW/BI developer with complete Software Development Life Cycle (SDLC) exposure;

requirement analysis, technical design / documentation, development and unit testing.

● Build and publish interactive reports and dashboards, scheduled reports @ Tableau / Power BI /Jasper server.

● Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

● Strong understanding of advanced Tableau features including calculated fields, parameters, table

calculations, joins, data blending, and dashboard

actions.

● Created business reports using Jasper report studio having custom parameters and layouts with exporting option of csv, excel and pdf files.

● Worked with query tools like Toad, SQL Developer, SQL Server Management Studio and Proficient knowledge in HTML, JavaScript and JQuery.

● Experienced in SQL and data validation in Oracle / MS SQL Server

● Worked with different kinds of data sources like Oracle, Json, CSV/Excel and XML data formats for developing the dashboards.

● Used git Bash utility for source code management which includes commit, checkout, push/pull and stash

commands to manage the source code in repository.

TECH. SKILLS:

BI Report tools: Tableau, PowerBI, JasperSoft

Database: Oracle SQL/PLSQL, SQL Server

Software: HP Quality Center, Toad, SQL Server Management Studio, MS Office, Redmine Internet Technology: HTML, Java Script, JQUERY, CSS Source Control: Git

EDUCATIONAL QUALIFICATION:

Bachelor of Technology in “Electronics & Telecommunication” @ BPUT - http://www.bput.ac.in/ Diploma of Technology in “Electronics & Telecommunication” @ http://sctevtodisha.nic.in/ PROFESSIONAL EXPERIENCE:

Organization: Vertisystem Inc. Duration: 4.5 years Responsibility:

Enterprise Data Analytics for Kofile (2 years):

● Worked on SQL Server DW; Designed and deployed reports in Power BI cloud server.

● There were many reports to assess resource performance, job/customer performance and process monitoring etc.

● These reports were used by directors / managers to do some actions based on insights.

● Provided a “What IF” analysis featured reports to predict number of hours needed to process a given new book.

● Developed dashboard having multiple pages with different graphs, matrix tables, filters and drilled down features.

● Tested all the summarized measures against the data using SQLs using aggregated functions.

● Prepared technical documents and unit tested the data and visualization before deploying to production. HR Data Analytics for Operation (2 years):

● Worked on a SQL Server DW and developed / published Tableau reports to do HR data analytics.

● It was mainly needed for analyzing data for the company's fulltime and contract employee’s data for leave management, expense reporting, payroll processing and executive revenue dashboard needs.

● Prepared churn analysis business logic and delivered an interactive tableau report with different parameters to slice / dice.

● Prepared technical documents and unit tested the data and visualization before deploying to production.

● Developed CRUD operation setup pages, status tracking portal using PL SQL procedure, jQuery, HTML, CSS, JS etc.

● Followed SDLC guidelines for completing the task using Redmine.

Contact this candidate