Data Analyst Reporting

TABASSUM N. RAHMAN

Woodbridge, VA 571-***-**** ads0vu@r.postjobfree.com

Objective:

Highly motivated analyst with over 6 years diversified experience in interpreting, analyzing and reconciliation of data obtained from a variety of sources; skills involve development and enhancement of the existing processes and methods to meet both internal and external analysis requirements; proficient with the prevailing analytical tools, various presentation software and possesses strong and effective communication skills essential in conveying results in analysis and investigations conducted; has great commitment to and affinity to meet deadlines without compromising accuracy and quality of work.

Summary:

Expert in generating on-demand and scheduled reports for business analysis or management decision using SQL Servers Reporting Services (SSRS), Tableau and Power BI.

Proficiency in Tableau functionalities including parameters, calculations, background images, maps, trend lines, statistics, log axis, hierarchies, Blending, Joins, Dual Axis charts, Filters, Sets, Groups, Reference lines and Bins.

Very strong SQL skills, including the use of nested table expressions, unions, multi-table joins, scalar functions, outer joins, and derived columns.

Solid knowledge of Power BI and Tableau Desktop report performance optimization.

Good understanding of Relational Database Design, Data Warehouse/OLAP concepts and methodologies

Worked on Agile Methodologies with good knowledge on different SDLC.

Experience in Analysis for Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/Business Intelligence (BI) applications.

Involved in External and Internal business review meetings and have good knowledge to analyze the business requirements, User stories, FDD, Data flow diagrams, Flow charts, Workflows, System design documents and Mapping documents for different interfaces.

Experience in Business Intelligence testing in various reports Dashboards.

Profound insight into performing BA duties in several phases of UML, Waterfall, Agile and Scrum software development life cycle (SDLC).

Proficient in all phases of Requirement Management, including gathering, analyzing, detailing, and tracking requirements.

Expert on Microsoft Power BI and Tableau reports, dashboards, and publishing to the end users for executive level Business Decision.

Introduced Tableau to Client to produce different views of data visualizations and presenting dashboards on web and desktop platforms to End-user and help them make effective business.

Experienced in Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS) & Informatica Power Center while transferring the data to target destinations from various sources like Excel, CSV, and Oracle, Flat File, Raw file and XML File.

Have in-depth knowledge of Software Development Life Cycle (SDLC) methodologies, assisting and working as Scrum Master on several projects, vast experience working in Agile, Waterfall.

Extensive experience in Extract, Transfer and Load process using ETL tools like Informatica, for Data migration and Data Warehousing projects along with good project management skills.

Highly analytical in developing the methods and measures to meet requirements and solve any issues that arise during the project.

Experienced in tools like HP ALM/Quality Center, JIRA, and Bugzilla.

Proficient in multiplatform (Windows, Linux) and cross browser compatible (IE, Firefox, Chrome, Safari, Opera).

Used HP ALM/Quality Center, JIRA and TFS for bug reporting and communication to developers, Product support and test team members.

Expertise in writing SQL Statements in database to make sure whether the data is populated in Data Mart/Data warehouse according to Business Rules.

Communication skills along with a remarkable ability to gather requirement to bring out quality product.

TECHNICAL SKILLS:

Databases: Oracle, SQL Server, MS Access

BI Tools: Tableau, Power BI

ETL Tools: SSIS, Informatica Power Center

Browsers: Internet Explorer, Mozilla Firefox, Google Chrome.

Operating Systems: UNIX, Linux Windows Server

Defect Management Tools: HP ALM, JIRA, TFS

Software Dev Methods: Waterfall, Agile Scrum

Office Tools: MS-Office, Microsoft Visio.

PROFESSIONAL EXPERIENCES:

HealthMap Solutions, Tampa, FL

Jun 2021– Present

Sr. Reporting Analyst

The HealthMap concentrated on using clinical data resources and high-powered analytics to power complex specialty health management program. As a senior reporting analyst, I am responsible for HealthMap’s sales, product, operational, and performance initiatives through cross-functional collaboration, requirement research, report development, analytics, and address specific plans through report execution. I work with Data Science teammates, business partners and utilize a variety of tools and techniques to produce client and/or operational reports.

Responsibilities:

Developed and manages requirements and execution of reports for client and/or internal end-users.

Created data dashboard, write data stories, and performed data visualization using Tableau by manipulating the data according to the need of the business owners.

Design and development of Tableau Dashboard and Performs functions related to problem definition, data collection, interpretation and analysis, visualization, and communication of results and recommendations.

Developing Custom Report and different types of Reports, Matrix Reports and distributed reports in multiple formats using Tableau Server.

Execute monthly testing (Tableau dashboard), preparation and reporting for the supported in scope accounts

Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.

Creating and verifying Tableau reports by writing complex SQL statements with joins, aggregate functions, and filter &search criteria to verify the integrity and correctness of the report outputs.

Performed Data Analysis and Data Profiling using complex SQL queries on various sources systems including SQL Server.

Generate data through SQL to develop and automate reports/dashboards at a defined cadence of daily, weekly, monthly, quarterly, and annually or a completely automated solution with daily updates on data.

Maintaining a working knowledge of healthcare coding and analytics techniques.

Involving and working with various cross-functional teams including sales, product development, clinical, and care services

Functioning as a facilitator and/or mentor for data reporting projects, teams, and task forces; supply consultative advice to cross-functional analytics teams and business units regarding standard business rules and algorithms.

Trained new users on how to use Tableau software, including best practices for interacting with data.

Managing user permissions to ensure that only authorized individuals have access to sensitive data as a tableau Admin.

Performing regular maintenance on servers to ensure optimal performance

Environment: Tableau, Python, MS SQL Server, HP Quality Center, Informatica Power Center, Data Warehouse, MS SharePoint.

UNC Healthcare - Chapel Hill, NC

July 2019- Jun 2021

Data Analyst

UNC Healthcare is one of the leading healthcare system in US. As Data Analyst, I was involved in various kinds of Requirement Gathering and UAT of the application modules like Membership, Providers, Finance and Claims Data. This was a Data Warehouse project, collected all the financial data from the origination and servicing systems. The second phase of the project involved retirement of legacy databases and redesigning of all reports from single data warehousing platform and develop new reports on a single business intelligence platform.

Responsibilities:

Conducted data analysis using SQL and Excel to create reports in Tableau.

Creating a BI dashboard for doctors and nurses, and upgrade the database from Oracle, inbuilt Data warehouse module for analysis and research on Billing/Payment for the Dashboard.

Creation of multiple highly interactive Power BI and SSRS reports for supervisors and managers, which enables them to see the current status of the work, shift allocation for the next day at location, district and borough level.

Involved in all phases of Software development life cycle (SDLC) using Agile- methodology and participated in sprint planning meeting.

Worked extensively on Business Requirements, Functional Specification, Data-Integration, Data Mapping, Data Modeling and Data Warehouse and Migration access using SQL and Tableau, use cases modeling (UML) using MS Office (Word, Excel, Access, Visio) and dashboards.

Created and executed test cases using SQL queries to validate backend data and end-to-end data flow.

Involved in Data Analysis to provide key information to the higher management with the help of MS Excel, SQL and Tableau.

Created multiple dashboards, custom visuals, inter-connected tiles to demonstrate the key areas of business growth. Developed reports based on the location, product, time and customers in Tableau.

Management of tracking tools: Redmine, Pivotal, JIRA or similar.

Conducted data analysis using SQL and Excel to create reports in Tableau.

Written and executed SQL queries/T SQL and Joins, Group by clause, having clause etc. to validate the data.

Executed automation test scripts using HP Quality Center (ALM).

Filed and tracked the defects using HP Quality Center (ALM).

Responsible for creating SQL datasets for Tableau and Ad-hoc Reports.

Developed Data Flow, Workflow, Process Flow, and Entity Relationship Diagrams in MS Visio, and analyzed them to create “AS IS” and “TO BE” scenarios.

Checked the data flow through the frontend to backend and used SQL Queries to extract the data from the database.

Worked with business team to test the reports developed in OLAP.

Created Test Data for QA and UAT.

Reviewing developed Stored procedure, TSQL queries, reports in BI environment for better understanding of the requirement.

Involved in data warehouse testing by checking ETL procedures/mappings.

Developing Custom Report and different types of Reports, Matrix Reports and distributed reports in multiple formats using Tableau Server.

Design and document Data warehouse (EDW) testing strategy covering the test cases for Validating the data completeness and correctness, system performances of the ETL processes etc.

Worked with providers and Medicare or Medicaid entities to validate EDI transaction sets or Internet portals.

Tested several complex ETL mappings, mapplets and reusable transformations for daily data loads.

Developed Reports and dashboards using Tableau.

Prepared Test plan and Test cases based on the functional specifications.

Developed SQL scripts using Joins, Temp tables Data and OLAP functions

Interacted with the end users to define and document data warehouse business requirements as the foundation for database design, data extraction and analysis.

Executed SQL/T SQL queries for searching, creating and updating test data.

Identified, analyzed, and documented defects, errors, and inconsistencies in the application using JIRA.

Utilizing MS SQL, Tableau, and other dashboard tools for data intelligence and analysis.

Managed, created and altered Databases, Tables, Views, Indexes and Constraints with business rules using SQL.

Participate in various meeting and discussed Enhancement and Modification request.

Environment: Agile Scrum, JIRA, Informatica Power Center, ETL, Data Warehouse, Data Sets,, SQL Server, SQL, HTML, XML, MS Office, Windows.

Sentara Northern Virginia Medical Center, VA

Jan2016– Dec 2018

Data Analyst

The project concentrated on EDI and ICD-10 readiness assessments project with explicit focus on ICD-9 to ICD-10 application passivity, comprising gap analysis, requirement gathering, and testing for procedures and diagnosis coding following the HIPAA rules and regulations. The Project also involved a web portal scheme that Sentara medical center offers for a single point of access and inquiry.

Responsibilities:

Coordinated with SMEs to discuss different scenarios at the time of scripting Test Cases.

Review Test Cases scripted by QA Team, prioritize them and assign them for execution.

Prepare Test Data and share with QA team members including BAs.

Execute Test Cases using JIRA manually and attached test document to the Test Cases.

Import data from multiple data sources and create automated reports in Power BI after cleaning and preprocessing the data.

Design and development of Tableau visualization solutions like Dashboards, Standard Reports, Scorecards, Drill down reports, Drill through reports, charts and Ad - hoc Reports.

Created data dashboard, write data stories and performed data warehouse, data visualization using Tableau and Advance Excel by manipulating the data according to the need of the business owners.

Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.

Log and track Marketplace defects using JIRA to resolve the issues.

Written several complex SQL scripts for validating Reports.

Involved in writing SQL statements to extract data from the relational database.

Deployed SSRS reports and published Tableau dashboards to share them with the appropriate users. Created multiple roles, with appropriate privileges for different users.

Well-defined and produced inclusive, accurate conversions of ICD-9 codes into equivalentICD-10 codes with the option to adjust system application for ICD-10 specificity.

Performed Data Analysis and Data Profiling using complex SQL queries on various sources systems including Oracle and SQL Server.

Performed data mapping to map the ETL process for the creation of data marts.

Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.

Perform root cause analysis on data anomalies and working data stewards to resolve issues.

Has exposure in the Design, development and maintenance of commercial projects using Waterfall Model and Agile Model.

Deployed web embedded tableau dashboards refreshed using gateways by using workspace and data source.

Developed SQL queries for Data Cleaning and Data Mapping. Performed data validation and testing over different databases.

Followed the Waterfall methodology during the entire SDLC.

Created packages using SSIS for data extraction from Flat Files, Excel Files and OLEDB to SQL Server.

Responsible in testing Initial and daily loads of ETL jobs.

Wrote SQL queries for each Test case to validate the data between Source system, Data Warehouse, Data Marts and Reports.

Created Test cases, and test plan from stage to production in MS SQL.

Validate and developed Meta Data for all developed reports in tableau Desktop.

Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.

Verifying the data in target database by ETL process.

Extensively involved with backend testing by writing complex SQL/TSQL scripts.

Performed UAT testing for ICD10 and legacy testing for HIPAA 5010 projects for HIPAA requirements and compliance mandates.

Environment: Java, MS SQL Server, HP Quality Center, Informatica Power Center, Data Warehouse, Tableau, Trello, Windows, MS Office, MS SharePoint.

Education & Training

Professional Certificate Program in Data Analytics Purdue University Online Expected Graduation 2022

Associates Degree in Information Technology NOVA Community College, Manassas, VA 2016 GPA 3.8/4.0

CITIZENSHIP: U.S. Citizen

REFERENCE: Will be furnished upon request.

Contact this candidate