Resume

Sign in

Data Sql Server

Location:
Morrisville, North Carolina, United States
Posted:
May 31, 2017

Contact this candidate

Mr. Ashok Bhatta

Phone No: +****-***-****

Email: ac0kvz@r.postjobfree.com

LinkedIn: https://www.linkedin.com/in/ashokbhatta

Tableau Public: https://public.tableau.com/profile/ashok.bhatta#!/

Summary

An energetic, versatile and goal oriented professional with around 2 years of experience in SDLC, Requirement gathering, Gap Analysis, Business Intelligence, Data Analytics and visualization.

Excellent analytical, creative, and organizational skills.

Experience in all the phases of Software Development Life Cycle (SDLC).

Advanced knowledge of data analysis, visualization and story-telling.

Experience in all the latest BI data preparation, analysis, and visualization tools and technologies.

Expertise in various reporting objects like Attributes, facts, Transformations, Calculated fields, Filters, Sets, Groups, Parameters, Hierarchies, Highlighters etc.

Experience in best data visualization practices with the use of different chart types such as: Bar chart, Lines chart, Scatter plot, Bubble chart, Histogram, Box and Whisker plot, Bullet chart, Heat maps, Tree maps, Gantt charts, Pareto chart, dual-axis chart, geo-spatial maps etc.

Experience in developing rich interactive/exploratory dashboards and stories by integrating different large data sources.

Expertise in Advanced chart types, advanced calculations, Level of Details (LOD) calculations.

Advanced knowledge on writing complex SQL queries in all the Relational Database Management System.

Hands on experience on Project Management skills including requirement gathering, gap analysis, planning, effective communication, time and resource management.

Strong knowledge of Agile methodology.

Experience and advanced knowledge of Data Warehousing concepts and ETL tools SAP BW/BI 7.3, Alteryx, Trifacta etc.

Interested in learning new & emerging data analytics, visualization technologies.

Technical Skills

Information Technology

Software: Data Mining/Warehouse/SAP BW-BI, Access Database /MS Visio/ MS Project/ MS Project Server

Programming Language: C, C++, JAVA, Pearl

Data Analysis/Management/ Visualization tools: MySQL, SQL Server, Oracle, SSIS, SSRS, SPSS, Tableau Desktop 8.x/9.x/10.x, Tableau Server, Tableau Online, Qlikview, Microsoft Power Pivot, Microsoft Power BI, Microstrategy, Tibco Spotfire, SAP Lumira, R, Alteryx, Cognos Analytics, IBM Watson Health Analytics.

Web development: HTML5, CSS3, JavaScript, Bootstrap

Professional Experience

IBM, IBM Watson Health, Raleigh-Durham, NC Area 2017 Jan – To date

Data Analytics Developer

Involved in all the phases of dashboard creation including requirements gathering, analysis, planning, development, and testing of the dashboards using tableau and Cognos Analytics.

Involved with the UX/UI team for creating JavaScript API to integrate Tableau dashboards in the portal and SIAM implementation for single sign on for the portal.

Generate KPIs for Gain Sharing and financial Win-Loss between Health system, Hospitals, and physicians for bundled payments, customer satisfaction survey results and disease management.

Developed dashboards for different audiences (Health System, Hospitals, Physicians etc.).

Used advanced functionalities to create interactive dashboards with all types of advanced charts.

Involved in data preparation, extraction, transformation, and loading from different data sources.

Worked on the Tableau server as an admin to create sites, projects, users, and groups and grant access to the users, groups.

Provided team leadership to ensure project tasks are completed accurately in time.

Ensured that projects meet all the goals and objectives.

Explored more on Cognos Analytics and IBM Watson Health Analytics.

Accenture Federal Services (AFS), Arlington, VA 2016 Jan – 2017 Jan

Data visualization Analyst (Tableau Developer)

Responsible for interaction with business stakeholders to perform Gap Analysis for business requirements.

Involved in identifying and reviewing business requirements, analyzing impact of tool development, collecting, preparing and analyzing various data sources for analysis, planning, design, development, testing, and production of the rich exploratory dashboards and stories in Tableau Desktop.

Created different visualizations for different audiences (Chief Data Officer, VPs, Directors, Program Managers, Project Managers, Associates) within finance team; Project Management Office; Resource Utilization; HR; Change Management etc.

Created Financial Dashboard to show Actuals, Plan, and Forecasted amounts; its variances, month over month view, Over and Under Plan amount with other KPIs.

Created PMO Dashboard to track the project timeline, progress, completion status, Resource Utilization, Risks and Issues, Ticketing Info, and financial amounts.

Used advanced functionalities such as creating complex calculated field, LOD calculations, data blending, joins, mapping, parameters, sets, groups, hierarchies, drill down, action filters for creating interactive dashboard.

Created SQL queries to import the required data in the Tableau memory to enhance the processing time.

Created all types of charts including Pareto chart, Gantt chart, geo-spatial charts, dual-axis chart, doughnut chart, lollipop chart, heat maps, word clouds etc.

Involved in data preparation, extraction, transformation, and loading directly from various data sources and using Alteryx.

Published the dashboard and data sources in Tableau Server and maintained, author the users, user groups, and set permissions to the users in the Server.

Integrated Project Server 2013 and Share point to the Tableau Server and setup auto refresh for live data feeding.

Created incremental refreshes of the data sources in the Server based on business requirements.

Tested the functionalities and the data of the dashboard to match the business requirement and the data in the data source.

Analyzed user and business requirements and attended periodic meetings for changes/updates in the application requirements.

Involved in the installation, configuration and upgrade of the Tableau Servers versions 9.x & 10.x

Used ‘Tabadmin’ & ‘Tabcmd’ command to create backups & restore Tableau repository backups.

Assisted the users in navigating, creating, and modifying worksheets and dashboards in Tableau Desktop and Server.

Documented the complete Dashboard, and Stories design, planning, and development process.

Helped business & technical users understand data preparation, transformation using Alteryx.

Created many data preparation workflows in Alteryx using various data sources such as flat file, MS excel, SQL Server etc.

University of Kentucky (UK) Healthcare, Lexington, KY 2015 May- 2015 Dec

Intern

Migration of statewide Healthcare data from MS Access database to SQL Server 2012.

Analyzed the space required for MS SQL Server interacting with DBAs and the BI team.

In-depth knowledge on Tableau Desktop, Tableau Reader, Tableau Server, and Tableau Public.

Used different self-service exploratory data analytics tools such as Tableau, Qlikview, MS Power BI, and Alteryx for data preparation and visual analytics.

Developed interactive Reports, Dashboards and Stories in Tableau by extracting, joining, and blending data from different sources.

Created different visualizations like Bars, Geo Maps, Lines, Pie Charts, Scatter plots, Gantt chart, Heat map, Histogram, Bullet graphs, Bubble chart etc.

Calculated provider-patient ratio within the state using third party data sources (population) and comparing national provider-patient ratio to increase or decrease the no of providers and services in a certain region for better business strategies and decision making.

Knowledge of many reporting objects like filters, sets, groups, calculated fields, parameters, hierarchies, attributes, reference lines, forecasts etc. in Tableau.

Worked on Large Datasets like MS SQL Server, Oracle.

Published Workbooks on Server creating user filters to restrict access to limited people

Handled Tableau admin activities such as Installation, configuration; grant and manage access to users and user groups.

Worked with Argus software to extract the Pharmacy claims data for data visualization.

Education

MSc Health Informatics Northern Kentucky University, USA, 2016

Migration of statewide MS Access database to SQL Server 2012 and use of Tableau for visual analytics (Data blending, data mapping, designs, creating reports, dashboards and stories) at strategic planning department, UK Healthcare.

Data Warehouse/Data Mining – SAP BW/BI

Create infoObjects, infocube, Extract, transform, and load data from flat file to Master Data Maintenance (create data flow and load material attributes, create data source, assign data source to data flow, create transformation, create data transfer process and load data)

Database design, and implementation: NIOSH DCAS Claims Tracking System

R programming language for data visualization including ggplot2, ggvis, googlevis etc.

MSc Biotechnology, University of Bedfordshire, UK, 2010 (Commendation)

Research Title: “Study on Sox2 and Sox19a gene expression in Zebra-fish (Danio rerio) embryo by Reverse Transcription Polymerase Chain Reaction (RT-PCR)”.

BSc in Applied Biotechnology College for Professional Studies, Kathmandu (Affiliated with Sikkim Manipal University, Sikkim, India), 2008 (Distinction)

Research Title: “Effect of antioxidant against free radicals during seed germination in Phaseolus vulgaris.”

References: Available upon request



Contact this candidate