Data Analyst
Resume:
VIVEK REDDY KAITHA
***@**************.***
SUMMARY OF SKILLS:
Data Analyst with wide variety experience in Healthcare and Banking domains.
Contributing for the team efforts in Software Development Life Cycle (SDLC) with very good communication and interpersonal skills.
Actively participating in the SafeAgile scrum meetings which includes Epic Breakdown sessions, Story point illustrating sessions, story refinement sessions, daily standup meetings, weekly status meetings, business signoff meetings and production checkout meetings.
Participating in Data Analysis, Database Analysis and by coding the SQL queries in different database applications like TOAD, MS SQL Server, DB2, Oracle Database systems for development, modifications and maintenance of client’s internal applications.
Involving in more data security and data privacy practices while participating in the production critical projects.
Filtering the dashboards and Generating the data visualization reports for the extracted data using reporting/business intelligence tools like Tableau, PowerBI.
Able to work independently and also along with different groups of technical and business teams.
Multi tasking, Time management skills in implementing the project within the time, requirement match and budget.
Leadership and people organization and management qualities in the multiple projects by guiding the off-shore resources on the work management.
Involving in Issue investigation which needs the requirements implementation, investigating the undocumented production and lower environment issues, involving in defect management with Problem Solving skills.
SKILLS:
Languages
C, C++, Java, PHP
Databases
SQL, Oracle, TOAD, SQL server, DB2
Web Designing
HTML, CSS, Java Script, XML
Tools
Tableau, PowerBI, SOAPUI, JIRA, Weka, Microsoft Office Suite, MS SharePoint, MS Visual Studio, Eclipse, Splunk, JDK,
Project Methodologies:
Safe Agile (Scrum).
OS
Windows, Linux, iOS
PROFESSIONAL EXPERIENCE:
Anthem Inc – Wallingford, CT Feb2018-Now (Ongoing)
Data Analyst
I have been working for client: Anthem BCBS, Wallingford, CT in healthcare claims data migration projects. Anthem is migrating its healthcare claims into its own system named Anthem Care Management System which uses 3 internal applications for creating, updating and maintaining the data which is being migrating from the previously contracted vendors. My main responsibities here includes implementing ETL process, Database development, testing and maintenance, Data Analysis, Executing Data Manipulation Languages for different environments from where the code is released every month for production, Verifying the code driven events in implementing the Software Development Life Cycle (SDLC), generating the data visualization reports and dashboards using Tableau and discussing the same with business teams.
Responsibilities:
Performing the Data Base Development, Analysis and maintenance, Data Analysis using different database maintaining applications including TOAD, SQL server, Oracle and DB2.
Generating the dashboards and data visualization reports using the business intelligence tool Tableau for business interaction and development into new projects.
Identifying the KPIs in Tableau and discussing them with the business.
Understanding the concepts of refreshing, migrations and scheduling, taking back ups and restoration of tableau repository.
Performing the data connection activities, visual analytics using tableau.
Reviewing the Technical Requirement Document, Epics, User Stories, Sub Tasks and Defects.
Participating very often in demonstrating the presentation on the business related activities.
Provide database support activities like database backup and restore, performance monitoring and tuning, review data models, analyze database metrics, and assist with capacity planning, executing upgrades and migrations, implement security and integrity controls.
Provide database support in all environments including production, test, development.
Involving in breaking down the epics and distributing the dependency stories to the respective scrum teams, prioritizing and analyzing the user-stories, defects and their level of estimates.
Designing and documenting the UML Use Case diagrams using MS Visio.
Involving in Daily Scrum calls, weekly status meetings,sprint planning, refinements and retrospective meetings, business signoff, production checkout meetings
Participating in change management and implementing the special efforts in adapting to the new challenges based on the direction of work.
Involving in root cause analysis on the undocumented or unknown lower environment and production Issues and explaining them in detail to the business.
Involving in ETL process of copying the multiple source data by staging them into the underlined destination in the data warehouse.
Runs queries to maintain and analyze insurance benefits data for different source systems.
Performing the SQL queries including the Join operations for the extraction from different sources of data.
Extracting, validating, transforming, merging, publishing the data into the destination warehouse.
Performing the data acquisition and data load tests along with providing the support to the Quality Assurance team.
Environment: SafeAgile, JIRA,Splunk, Oracle, DB2, MS Excel, MS Word, MS Powerpoint, ETL, SOAPUI, TOAD, MySQL, Java,xml, html, MS SharePoint, Tableau.
Idol Soft Inc – Irving, TX Oct2017–Feb2018
Database Analyst
Responsibilities:
Participated in database design, monitoring database performance, deployed new releases, and completed maintenance requirements.
Analyzed and reviewed existing systems and program logic to become familiar with the existing database standards
Performing the data analysis, database development, analysis and testing for the client application.
Coding the SQL queries which includes the reading, writing and editing tables using wide variety queries.
Responsible for manipulating, organizing, and understanding the collections of databases.
Making the DML (data manipulation language ) changes on the test/prod environments for each release.
Coding the SQL queries for maintaining and updating the stored procedures.
Involving in Data Modeling and generating the data visualization reports using PowerBI the business intelligence tool.
Using the Query Editor of business intelligence tool MS PowerBI for the data extraction based on the requirements.
Sharing the business intelligence Visualization reports by using the cloud services to the team.
Developing the data warehouse concepts like OLAP and OLTP and using those extracts for PowerBI reports.
Provide support in extracting, reporting, and analyzing data from data retention systems.
Actively involving in scrum meetings to discuss the SDLC plans and their implementation.
Resolving the existing challenges for the data queue and provide data security.
Assisting QA’s by involving in defect management for different lower environment (SIT) and production issues.
Ability to switch to the new challenges when there is a direction change requimrent in place.
Environment: Agile, SQL, MS office, MS Sharepoint, MS Powerpoint, MS PowerBI, MS Excel, JIRA, Java
Asta CRS Inc - Greenbelt, MD Feb2017-Oct2017
Data Analyst
Responsibilities:
Involving in the extract, transform and load (ETL) process of the data analysis.
Participating in Data Cleaning, Data Processing and Data collection of the huge datasets and generating the data visualization reports for the same using Business intelligence tool – PowerBI .
Identifying the Key Performance Indicators (KPIs) as part of data analysis work.
Participating in daily scrum meetings for the agile methodology.
Participating in data acquisition processes of gathering, filtering and cleaning the data.
Multidimensional analysis of business data using PowerBI.
Performing the data modeling in PoweBI by using star/snow flake schema and comparing the relationship between the data.
Using the query editor of PowerBI for data setup by sorting and cleaning the data before visualization.
Performing the DAX operations in PowerBI using the different type of DAX functions in PowerBI.
Gathered and analyzed business requirements, interacted with various business users, project leaders, developers and also took part in identifying different data sources.
Involved with Data Analys is primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.
Participating in issue resolving meetings and providing the data security to the application.
Running the T-SQL queries for generating the extract of the data sources.
Maintaining the data organization by removing the unwanted fields/tables and performing the database alteration.
Environment: Agile, SQL, MS Excel, MS Word, MS Powerpoint, MS Visio,MS PowerBI, MS Project, JIRA.
ICICI Bank- Hyderabad, India April2013-July2015
Business/Data Analyst
Responsibilities:
Participated and assisted in new Requirement (User Stories) gathering sessions.
Assisted the Lead Business Analyst in documenting User Stories, Business Requirement Document, Technical requirements& Non-Functional requirements.
Creating and Documenting the source to target mapping document between the data models.
Provide data analysis using MS Excel and SQL queries and data visualization using Tableau for integrating requirements and reporting needs for future projects.
Generating the data visualization reports and dashboards using Tableau
Performing the Grouping, sorting, filtering, formatting using tableau.
Involving in daily standup meetings and weekly status meetings.
Designed and documented the UML Use-Case diagrams using MS Visio for translating the business requirements into technical flow.
Serve as liaison to the business during User Acceptance Testing (UAT) during signoffs.
Managing the meta data, extracts and visual analytics using tableau.
Assisting the Quality Assurance Testers by discussing for the defect management.
Presenting the business knowledge activities to the newly recruited interns.
Participating the multiple communication and presentation demonstration skills in daily activities.
Environment: Agile, SQL, Tableau, Microsoft Excel, MS Visio, JIRA, MS Powerpoint.
EDUCATIONAL QUALIFICATION:
Master Of Science - Computer Science Dec2016
Kent State University, Kent OH, USA
Key Aspects:
Big Data & Analytics, Data Visualization, Advanced Artificial Intelligence, Internet of Things, Mobile Application Development for iOS, Master’s Seminar and Multiple presentations on the evolving Technologies and their challenges.
Bachelor of Technology - Information Technology May2015
JNTU- Hyderabad, Telangana, India.
Key Aspects:
Software Enginnering, Data Base Management Systems, Object Oriented Programming (Java), Human Computer Interaction, Software Testing Methodologies, C Language, C++ Language, Web technologies.
Contact this candidate