SUMMARY:

• Over 7 years of IT experience as a BI consultant working on SAP Business Objects, Tableau and Microsoft Power BI
• IT professional with industry expertise in Health Care, Pharma, Airline and Supply chain.
• Experience in Business Objects, Business Intelligence, Data Analysis profiles with strong knowledge of Software Development Lifecycle (SDLC) using waterfall, Agile Scrum and Kanban
• Strong experience in SQL skills to build complex views, stored procedures and performance tuning
• Highly motivated team player with excellent decision making, leadership qualities, interpersonal and customer relational skills
• Ability to work in groups and independently with minimum supervision and initiative to learn new technologies and tools

TECHNICAL SKILLS:

Data Analytics tools:: Power BI, Tableau, Gephi, IBM Watson Analysis, SAP Business Objects

Management tools:: Clear quest, JIRA, Confluence, Visual Studio

Languages:: SQL, UML

Databases: Teradata, Oracle, Microsoft SQL Server, SAP HANA

Microsoft office programs:: MS Access, MS Word, MS PowerPoint, MS Excel, Microsoft Visio

PROFESSIONAL EXPERIENCE:

Confidential

Power BI Developer

• Understanding the KPIs and Requirements Documents, Designing, Developing and testing reports in Tableau
• Develop SQL query based on the requirements and import/direct query the data into Power BI desktop
• Build dashboards in Power BI by extracting data from SAP HANA, SharePoint using SQL queries
• Implemented Data Blending concepts and performed other operations such as, appending in Power BI
• Modified the SQL query to perform calculations of the Metrics for each KPI and derive MTD and YTD values corresponding to each KPI
• Set relationships for various datasets in the Power BI desktop
• Calculate measures and columns as per the requirement using DAX functions and M Query
• Created customized tooltips for the visuals in the dashboards
• Migrated existing KPI’s and Dashboards from Tableau to MS Power BI keeping the same functionality
• Configured row level security for the users in Power BI desktop
• Published the reports and provided access to the end - users including the schedule refresh of the report server
• Created tiles for navigation between the existing dashboards in Power BI service
• Performed knowledge transfer to the offshore team working in offshore-onsite model

Confidential

Tableau/Power BI Developer

• Understanding the KPIs and Requirements Documents, Designing, Developing and testing reports in Tableau
• Build Dashboards using calculations, parameters in Power BI
• Designing the Reports using Tableau and Power BI from Oracle database, Created Actions to achieve desired functionality
• Worked with Drill Down, Drill Through on Reports
• Implemented Data Blending concepts in Tableau Reports, worked on Dual Axis & Blended Axis
• Used Sets, Parameters, Aggregate Functions, Filters, Measure name and Measure Value fields to create visualizations with multiple measures and dimensions
• Develop, organize, manage and maintain graph, table, slide and templates that will allow for efficient creation of reports
• Involved in supporting Tableau applications which includes creation and cosmetic changes of different charts
• Ability to work with various types and stages of Software Development Life Cycle (SDLC) processes including Analysis, Design, Development, Testing and Implementation
• Expertise in scheduling reports to end-users and provide access to the report server
• Optimize query performance by modifying, removing unnecessary columns, eliminating redundant and inconsistent data
• Worked on complex data loading (implemented the batch data cleansing and data loading)
• Gathered requirements for the project from Business Analysts and data modelling team
• Presented different types of metrics and key performance indicators (KPIs), such as financial, operational, and customer-focused measures in a single list

Confidential

Tableau Developer

• Performing quality check on data, identifying outliers, normality and standardizing the data
• Generating Risk stratification reports using tableau to manage the higher cost treatment plans and improve the quality of care by highlighting the risk summary and impact ability by chronic conditions
• Developed linear regression predictive risk and impact ability models to predict the members with high risk and helps care-providers to quantify the care-gaps prioritization for each member
• Established platform to process 837 medical data and convert them to datasets
• Created dashboards by extracting data from different sources
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard
• Involved in creating calculated fields, mapping and hierarchies
• Created drill through reports in dashboard
• Involved in creating data blending in case of merging different sources and in creating a dual-axis bar chart with multiple measures
• Working on generating various dashboards in Tableau Server using different data sources such as Oracle, Microsoft SQL Server and Files
• Performed Tableau type conversion functions when connected to relational data sources
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports
• Involved in supporting other Tableau applications which includes creation and cosmetic changes of different charts
• Created ARM, MOM Document and Maintain the root cause analysis & issues tracker sheet and maintain a log files, screenshot
• Participating in the daily call status updates to discuss progress, issues and any new requirements

Confidential

Programmer Analyst

• Worked in Agile environment with frequently changing requirements, handling offshore teams effectively as a lead while working with onsite-offshore model
• Handled client knowledge transfer calls and communicated requirements to the team
• Gathered the requirements from Business users and understanding the functionality and business rules
• Analyzed the systems and source databases
• Prepared the test data in the paper claims, mainframes, EDI, CSV, XML formats and tested the database using SQL queries in Microsoft SQL server
• Prepared Gap analysis on ICD9 and ICD10 codes and documented the process
• Developed data model to create reports and dashboards in Tableau
• Developed worksheets with different styles like bar, pie, tree map, dual axis, filled maps
• Combined data sources by joining multiple tables and using data blending
• Prepared deployment documents and involved in production deployments
• Published the dashboards to Tableau server and managing the security for users
• Checked if all the environments are working as expected, if not working inform to support team
• Proactively involved in project management activities including status reports, kick off and sign off activities
• Managed and supported the team in completing the deliverables on time to meet the deadlines