SWATHI V

adfw02@r.postjobfree.com

609-***-****

Professional Summary

Result oriented professional having 9+ years of versatile experience as a BI Analyst with Cognos &Tableau Report Developer in the areas Telecom, Health Care, Insurance & Logistics domains to monitor their Sales growth, Operational activities, and numbers in Finance.

Hands on experience in Requirements Gathering using effective Elicitation Techniques

Analyzed department technology usage and performed research to assist in development of project scope, define requirements and propose changes.

Experienced in analyzing Stake holders by organizing Brainstorming Sessions between concerned team members

Experienced in documentation of end user requirements for data capture, data analysis, understanding internal functionality of the system

Analyzing and mining business data to identify patterns and correlations among the various data points,

Hands on experience in various BI tools and Good Knowledge of Relational Database Management Systems, & Database Design and Development

Proficient in Data Modeling/Data Analysis

Well versed in generating multiple Enterprise reports using Cognos/Tableau/SSRS from SQL Server Database, Oracle Database

Hands on experience in building ad hoc reporting and relevant KPIs

Involved in developing database objects like tables, views, stored procedures, and functions using T-SQL

Developed SSIS Packages to Load Data from various sources

Knowledge on OLAP, Star and Snowflake Schema

Involved in creating various reporting features such as group by drill through, Quick filters, sub-reports, parameterized reports

Created Tableau Dashboards with stack bars, bar graphs, scattered plots, Maps, Gantt Charts

Proficient in Tuning SQL queries to improve the database performance

Knowledge on meta data analysis

Thorough understanding on the SDLC phases

Extensive knowledge of software quality assurance methodologies, and hands-on experience in database/data warehouse testing

Coordinated and facilitated User Acceptance Testing (UAT) and prepared User Manuals

Technical Summary:

Reporting Tools : Cognos 10.2, Tableau Desktop 10.4/9.1.2/9.2, Tableau Server

10/9.1.2/9.2, SSRS 2012/14, SSRS Server 2012/14

Data Bases : MS-Access, SQL Server 2012/2014, MySQL, Oracle10g/11g

ETL Tools : Knowledge on SSIS (SQL Server Integration Services)

Web Technologies : Knowledge on HTML, CSS

Operating Systems : Windows 2000/2003/XP/Win 7/ Win 8/Win10

Documentation Tools : MS Office Suite

Modeling tools : MS-Visio 2007

Education Credentials:

Master’s in Business Administration

P.G. Diploma in Computer Applications

Bachelor of Science

Professional Experience:

Client: Verizon, Dallas, TX Feb 2019 - Apr 2020

Role: Technology Lead

Description:

XO was acquired by Verizon & XO Billing Application Project objective is to provide centralized analytical platform catering to critical reporting needs of Verizon - XO Market. Application usage is offered to different business units like Marketing Campaign, Customer Care, Corporate Inventory Accounting & Performance Assurance Retail Markets.

Responsibilities:

Direct interaction with the Business users to gather requirements and analyze the needs of the Verizon – XO Business and Enterprise Applications & reporting

Providing Data analysis of reporting services related to business intelligence, data warehousing and data integration using Informatica9.6, Cognos 10.2 & Tableau10.4

Development of Congo’s & Tableau reports pertaining to various applications related to Provisioning, Billing, Sales, Order Management & CDR

Creation of Tableau Dashboards & demonstrating them to the end users

Acquire data from primary & secondary data sources & identify and interpret trends or patterns in complex data sets frequently assessing project management areas like Risk Management, Scope Management & Integration

Handling Tableau Server activities related to defining the user security & deployments

Worked Closely with ETL teams explaining the business requirement and business benefits for the new change and requirements for reporting

Participated in Business & System requirements sessions for issue clarifications, perform feasibility analysis for business requirement and estimate the effort required

Executed Test Protocols for System Integration Testing (SIT) and User Acceptance Testing (UAT)

Scheduled frequency and time to refresh data for when sources are published or extracted to server

Training end users on new reports and dashboards

Environment: Oracle, SQL Developer, Toad, Tableau10.4, Cognos 10.2, Informatica 9.6

Client: DART, Dallas, TX March 2018- Nov 2018

Role: Sr Tableau Developer

Description:

Dallas Area Rapid Transit (DART) is a public transit service. It Operates Light Rail, Trinity Railway Express commuter rail, bus routes and paratransit services & moves more than 220,000

Passengers per day. Developed Finance, Human Capital, Payroll system, Driver Analysis, Ridership assessment, TVM assessment dashboards.

Responsibilities:

Involved in Requirements Gathering from end users & data mapping from various sources

Managing and designing the reporting environment, including data sources, security and metadata

Work with management team to create a prioritized list of needs for each business segment

Involved in developing ETL mappings to load data from Flat files into the target Oracle database for inserting and updating records when loaded.

Analyzed data to assess quality issues & utilizing data to fulfill business metrics

Experienced in new KPI generation based on business line & Dashboard Design

Worked on Proof of Concepts POC presentation & review with project lead along with Tableau Dashboards

Created reports utilizing features like hierarchy, calculated fields, line graphs, bar graphs, Geographical graphs, Bubble graph

Generated Dashboard with Quick Filters & Parameters to handle views more efficiently

Created Dashboards with Drill-down feature for detailed reports

Prepared Tableau Reports for Finance, HR, Payroll, IT & Operations, BUS OTP that provide clear visualizations for effective decision making

Tested the Dashboards against database tables by running custom SQL & monitored the performance of the reports before publishing to server

Executed Test Protocols for System Integration Testing (SIT) and User Acceptance Testing (UAT)

Scheduled frequency and time to refresh data for when sources are published or extracted to server

Training end users on new reports and dashboards

Environment: Oracle, SQL, Toad, Tableau10.4

Client: Buyers Barricades, San Antonio, TX July 2016 –Feb 2018

Role: Reporting Analyst / SSIS / SSRS

Description:

Buyer’s Barricades are Texas Expert in Traffic & Construction Safety. They are involved in creating a traffic control plan, determining what traffic safety equipment is needed, setting it up, maintaining it and also include flagging operations, lane closures, road closures, detours, highway closures etc. It involves the monthly Finance, Sales and Operation Planning (S&OP) process, Claims, Payroll system, Weekly communications of updates & forecast changes, Distribution Replenishment Planning processes, Capacity Planning, and Inventory Management.

Responsibilities:

Involved in Requirements Gathering from end users, experience in data modeling process and data mapping

Creating promotional campaigns and developed Prototype flowcharts to send email and mail campaigns. Worked with strategy managers in discussing the campaign approach

Mapping and tracing data from system in order to solve a given business or system problem

Provide quality assurance of imported data, working with quality assurance analyst if necessary

Managing and designing the reporting environment, including data sources, security and metadata

Work with management team to create a prioritized list of needs for each business segment

Validated the data loaded to staging tables

Inbound & Outbound data testing

Involved in new KPI generation

Worked on Proof of Concepts POC presentation & review with project lead along with SSRS Dashboards

Created reports utilizing features like calculated fields, line graphs, bar graphs, stack bar graphs, pyramid graphs, Score Cards

Generated Dashboard with Filters & Parameters to handle views more efficiently

Created Dashboards with Drill-down feature for detailed reports

Prepared Tableau Reports for Finance, HR and Sales Departments that provide clear visualizations for effective decision making

Tested the Dashboards against database tables by running custom SQL & monitored the performance of the reports before publishing to server

Interacted with QA team to evaluate improvements of the existing system

Executed Test Protocols for System Integration Testing (SIT) and User Acceptance Testing (UAT)

Scheduled frequency and time to refresh data for when sources are published or extracted to server

Ensure daily that all data is loaded in a timely manner (partner with ETL Team)

Training end users on new reports and dashboards

Weekly Status reports to Internal and Customer Managers

Environment: SSIS, SQL Server, SQL, SSRS (SQL Server Reporting Services)

Client: MMS Hospitals Feb 2015 - Jun 2016

Role: Tableau Developer

Description:

Developed BI Solution for maintenance of health records in hospitals, ACO’s, physician's office, health departments data, health insurance data and other facilities that provide health care & maintenance of health records, Finance, Payroll, Claims, Provider & Enrollment Details, Revenue Cycle Management (RCM), medical management capabilities and health care management services for Medicaid & Medicare plans. The project is about Medicode Strategic Data Warehouse. Analyze Hospital metrics and data to support operation teams. This is used to identify current and future information needs, in addition they may apply the science of informatics to the collection, storage, use and transmission of information to meet the legal and administrative records-keeping requirements of health care delivery.

Responsibilities:

Involved in requirements gathering for new projects and enhancements of application in Web and BI Platforms

Collaborated with users in performing data analysis and help users interpreting data as well as helping users to understand backend data

Performed in-depth analysis of workflow and data, research and resolve operational inquiries pertaining to the reports and EMR applications

Consulted clinical and senior leadership to understand their reporting needs and provide recommendation how they can use the reports for their daily engagement system (DES) to promote process improvement

Developed reports in the form of Line Graphs, Bar graphs, Scattered plots, Pie charts & Line graphs for Finance, HR & Executive Departments & Doctors Score Card

Development of packages according to the ETL specifications for the staging area & Warehouse data loading using SQL Server Integration Services

Good Knowledge on Data Transformations like Derived Columns, Merge, Conditional Split, Sort, Data Conversion, Union All and Execute SQL Task to load data into Data Warehouse

Designed and modified the data for building KPI’s

Created action filters, parameters, and calculated fields for preparing dashboards and worksheets in Tableau

Developed different KPI’s like Payroll, Employee Hours, Avg. wait time by Physician, Readmission by Diagnosis, Readmission by Gender, Charged Hours, Charged Amount, Patient Load by Physician etc. to name a few including drill through with filters and necessary tool tips Development of reports

Responsible for developing different types of reports i.e. drilldown reports, sub reports

Prepared Traceability Matrix documents and Defect Incident Reporting documents

Provided defects tracking and testing protocols status report to higher management

Responsible for ensuring that production procedures are maintained and properly executed, including development, change requests, and enterprise integration projects

Coordinated with developers and end users on issues found in testing phases

Proactively working on process improvements and initiations to make system more reliable and stable to users to meet their business goals

Environment: SSRS (SQL Server Reporting Services), SQL, SQL Server, SSIS, Tableau9.0,9.1

Client: Empire Truck Lines Aug 2014 – Jan 2015

Role: Tableau Developer

Description:

Empire Truck Lines provides Transportation Services including Container Yard Services, Domestic & International Services. I involved in developing enterprise BI solution for Empire Truck Lines Management. I involved in creating reports for Finance and Operations Departments with different visualizations.

Responsibilities:

Interacted with business users to understand the business

Documenting the types and structure of the business data

Developing and implementing data analyses, data collection systems and other strategies that optimize efficiency and quality

Acquiring data from primary or secondary data sources and maintaining databases

Created filters, parameters, and calculated sets for preparing dashboards and worksheets

Created Detail level summary report and Dashboard using KPI's

Effectively used Data blending feature

Developed reports in the form of Line Graphs, Stacked Bar graphs, Bubble Graphs, Trend Lines

Published Workbooks by creating user filters specific to appropriate teams

Analyzed the SQL Data base, written queries and retrieved data with respect to required KPI’s

Created Drilldown reports with respective filters and tool tips

Training end users on new reports and dashboards

Scheduling the data refreshes in the Tableau Server with respect to ETL’s timing in the Database

Environment: SQL, Oracle, Tableau8.0, Toad

Client: OIPA Implementation June 2011 – July 2014

Role - Report Developer/Analyst

Description:

OIPA is core insurance product. This project is OIPA implementation, OIPA is a highly configurable, rules-based system that helps insurers adapt, transform and grow their business by accelerating speed-to-market for products, enhancing service to customers and distribution through real time access to policy information and reducing risk while optimizing performance.

Responsibilities:

Requirement discussions with client team which includes setting up the conference calls with different business units

Analyze the requirements shared from client team, consolidated them by functional grouping

Collaborated with users in performing data analysis and interpreting data

Worked on Proof of Concepts POC presentation & review with project lead along with SSRS Dashboards

Created reports utilizing features like calculated fields, line graphs, bar graphs, stack bar graphs, pyramid graphs, Score Cards

Generated Dashboard with Filters & Parameters, Cascading Parameters to handle views more efficiently

Created Dashboards with Drill-down feature for detailed reports

Performed the Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements

Involved in extensive DATA validation using SQL queries and back-end testing

Validated business reporting requirements with internal and external customer

Validated the reports to make sure all the data is populated as per requirements

Responsible for supporting the business in User Acceptance Testing (UAT)

Environment: SSRS, SSIS, SQL, SSMS, Crystal Reports

Contact this candidate