Data Analysis Power Bi

Shylaja Kumaresan

******************@*****.***/+1-551-***-****

https://www.linkedin.com/in/shylaja-kumaresan-998937222/

PROFESSIONAL SUMMARY:

Over 7 years of experience in Data Analysis, Data Visualization and creating reports/dashboards/graphs to provide actionable insight for decision-making.

Experience in developing Business Intelligence assets using tools like Informatica PowerCenter, Informatica Data Quality OBIEE, Tableau, Oracle and others.

Involved in IT Business Analytics, Data Analytics and Data Profiling tasks with business to make data more accurate and result oriented.

Proficient in Medicare and Confidential billing

Interact with clients for requirement gathering and prepare Functional Specifications

SQL Experience working with Data Analysis of tables, views, synonyms, functions using Oracle 11g, Postgresql and Sysbase.

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

Act as a liaison between client and technical solutions/support groups, using advanced communication skills to elicit, document, analyze and validate client requirements.

Proficient in Software Development Life Cycle (SDLC) using Waterfall and Agile methodologies.

Good knowledge of data analysis, visualization using Power BI and SQL.

Working knowledge of different relational databases (MS SQL server and PostgreSQL).

Experienced in Data Analysis, Data Validation, Data cleaning, Data Verification and Data Mismatch identification.

Experience in gathering business requirements from business users, creating application design including database table design.

Experience in writing SQL queries, Stored Procedures and Triggers using PostgreSQL, and SQL Server

Expertise in data visualization, developing Dashboards, Charts, Graphs and reports using Power BI and Tableau.

Expertise in developing reporting based on structured and unstructured data.

Extensively used Erwin data modeler to design Logical/Physical Data Models, relational database design

Experience in uploading dashboards to Power BI Service, granting permissions to users as admin and helped in integration.

Expertise in transforming business requirements into analytical models and designs.

Knowledge on Python Basics

Strong analytical and problem resolution skills with ability to plan, prioritize, and work efficiently in a multi-tasking environment.

Provide support on production issues including troubleshooting, coordination with IT, and end user communication related to data issues.

Excellent Analytical, Communication skills, working in a team and ability to communicate effectively.

Strategic Planning for improving the organization’s efficiency.

Self-starter and able to handle multiple tasks based on priorities.

EDUCATION:

Bachelor of Engineer in Computer Science from Arunai Engineering College, India, June 2015.

TECHNICAL SKILLS:

Languages:

SQL, C#, Python basics Analytical

Tools & Data Visualization:

Power BI, Excel, Tableau

ETL Tools:

Informatica Power Centre, SSIS chema design: Visual Studio

IDE:

PyCharm, Microsoft SQL Server Management Studio

Databases and Tools:

SQL Server, PostgreSQL, TOAD

Operating Systems:

Windows, Mac, UNIX, LINUX

Dev Methodologies:

Waterfall and Agile (Scrum)

PROFESSIONAL EXPERIENCE:

TD Bank, West Falmouth, ME Data Analyst, Aug 2022- Present

Project: Money In Data Governance

Part of a Data Governance team performing analysis on all failed rules for each month and analyze the reason for the failure and report to manager on timely basis.

Visualized certain in- house reports to make effective using tableau and excel graphs & tables.

Automated reports using VLOOKUP and formulas in excel to reduce the time to filter for resources under a manager’s umbrella.

Analyzed the complex data for reporting and performance analysis.

Performed in-depth analysis for all business queries against databased and suggested solutions to Data Governance team.

Worked with project team representatives to ensure that logical and physical data models were developed in line with corporate standards and guidelines.

Developed Power BI reports using Power Query from SharePoint & different Data sources.

Used Data Analysis Expressions DAX to create custom calculations in PowerPivot for Microsoft Excel workbooks and Analysis Services tabular model projects.

Created PowerPivot models and PowerPivot reports, publish reports onto SharePoint, and deploy models into SQL Server

Embedded Power BI reports on SharePoint portal page and managed access of reports and data for individual users using roles.

Extracted data for reporting from multiple data sources like SQL Server, SQL Server Analysis, Service, Azure SQL Database, Azure SQL Data Warehouse, Salesforce, etc.

Extracted data from data warehouse server by developing complex SQL statements using stored-procedures and common table expressions (CTEs) to support report building.

Implemented Tableau for visualizations and views including scatter plots, box plots, heatmaps, tree maps, donut charts, highlight tables, word clouds, reference lines, etc.

Provided technical expertise and support in data analysis and data reporting.

Performed count validation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration.

Participated in various meetings and discussed Enhancement and Modification Requests

Environment: Share Point, MS Excel, MS Word, MS Access, MS Office Suite, Tableau, Oracle SQL Developer.

Morgan Stanley Inc, New York Data Analyst, May 2021 – Aug 2022

Project: E-Trading and Order Management Systems

Conducting requirements gathering meetings to elicit requirements.

Coordinated with the stakeholders and project key personnel to gather functional and non-functional requirements during JAD sessions.

Created data warehouse and data marts from scratch based on data structures and reporting needs.

Worked on writing ad hoc SQL scripts which are required for reporting purposes. Worked on creating basic dashboards in tableau connected to Azure SQL database for client reporting.

Writing BRD (Business Requirement Document) from gathered requirements.

Prepare policy briefs, reports, public hearing testimonies, presentations, and petitions.

Prepare and publish periodic management reports.

Created the Reporting requirements documents and deriving Use Cases from developed matrix where necessary.

Creating relevant supporting documentation for requirements i.e., Excel spreadsheets, graphs etc.

Hands on exposure on SharePoint for Tracking Requirement Documents, Status Reports,

Implementation Guide and Support Documentation and involved in Policy management, Issue management, Change Management

Analyzed the complex data for reporting and Performance Analysis and validated the External data to ensure accurate reporting.

Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services ( SSIS)

Worked with project team representatives to ensure that logical and physical data models were developed in line with corporate standards and guidelines.

Provided technical expertise and support in data analysis and data reporting.

Created Test Strategy Planning (TSP) and assisted testing team to implement test plans during UAT kickoff.

Performed Count Validation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration.

Communicating with development and QA teams regularly to ensure accurate understanding and interpretation of requirements.

Performed extensive testing in Facets subscriber/member, tested groups, eligibility and enrollment and validated outbound 834 Extracts to the different vendors.

Assisted project delivery lead in the creation and maintenance of project related documents (project status sheets, project plans, timelines, etc.)

Created presentations and demos to help train internal teams: Sales, Marketing, and Services on new functionality.

Environment: Share Point, MS Excel, Agile, MS Word, MS Access, HP Quality Center, UML, ETL, Informatica Power Center 9.X, Oracle 11g, Erwin, OBIEE 11g, MS Office Suite, MS Video, Oracle SQL Developer.

Arch MI, Greensboro, NC Data Analyst, July 2018 to Apr 2021

Participated in scrum meeting and sprint meeting to coordinate with software development life cycle process; involved in Confidential global team environment.

Gathered requirement from team lead and prepared for technical documentation.

Created and maintained SQL database object such as tables, views, indexes and store procedures with SQL Server Management Studio (SSMS) 2012.

Developed Store Procedure in T-SQL to replace existing SSIS packages in ETL process and gained better Performance.

Built interacting and storytelling dashboards in Tableau workbooks using dashboard actions.

Published Tableau workbook on Tableau Server and set report refresh.

Used Data Analysis Expressions (DAX) to create measures and calculated fields to analyze data and to create time intelligence.

Extensive use of DAX (Data Analysis Expressions) functions for the Reports and for the Tabular Models.

Cleaned data source in SQL Server and prepared data source in Tableau metadata using complex joins, Custom SQL, split and data blending.

Designed, developed, and maintained daily, weekly, monthly and year-end summary, trending and benchmark reports repository in Tableau Desktop.

Environment: Tableau Desktop 7.0, Tableau Server 7.0, MS SQL Server 2012, GitHub.

Xpressdocs, Fort Worth, TX Business Data Analyst, Feb 2017 to Apr 2018

Authored the Business Requirement (BRD), User Requirements, Functional Requirements (FRD)

Gathered requirements by working with the relationship managers, wealth managers and field agents.

Worked on Use Case diagrams in gathering requirements.

Worked with development team to implement technical solutions for the client.

Used SQL to analyze data on databases.

Performed Backend Testing by executing SQL queries.

Involved in developing test plan for the entire application. Developed test cases after analysis of the Business requirements and Business Use cases.

Participated in various meetings and discussed Enhancement and Modification Requests.

Interacted with all the developers to report defects and also to get the build status of the application.

Analyzed system Specifications and design document and developed test plan in Test Director.

Prepared the test environment including setup of facilities, hardware and software.

Executed and wrote Test Cases on increments based on functionality added on each increment of web application.

Participated in Use case Reviews, Test case Reviews, Test scenario Reviews and created synchronization points for validation and verification.

Preparation of Test Plan which specifies testing overview, testing approach, testing strategy, roles and responsibilities and scope of testing.

Executed different scenarios like compatibility, scalability, and load test to identify bottlenecks on every component of the system.

Environment: HP Quality Center, ETL, Informatica Power Center 9.X, Oracle 11g, Erwin, OBIEE 11g, TOAD, Oracle SQL Developer.

Datamatics Global Service LTD, India. Data Analyst, Aug 2015 – Sep 2016

Gathered user requirements, analysed and designed software solution based on the requirements.

Created database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.

Designed and implemented data profiling and data quality improvement solution to analyse, match, cleanse, and consolidate data before loading into data warehouse.

Created data stories, reports and visualizations using Tableau and Power BI.

Created ad-hoc, weekly and monthly reports in compliance with the client requirement with Excel.

Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS) and T-SQL.

Developed different types of Tabular Reports, Matrix Reports (Cross Tab or Pivot), Chart and Graphs reports using the SSRS reporting as per the user's requirements and deployed in report server.

Used Unix Shell Scripting for automating logs, for user created table backups and for checking daily log.

Created pivot tables in Excel by getting data from Teradata and Oracle.

Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).

Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects.

Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.

Performed unit testing against the developed packages and scheduling, creating snapshots and subscriptions for the reports using SSRS.

Involved in troubleshooting production issues and providing production support.

Environment: Power BI, Tableau, Excel, SSRS, SQL Server, Tableau, Oracle, T-SQL, Teradata, Shell Scripting

Contact this candidate