Data Analyst Senior

PRAVEEN SOLLETI

Ph: 703-***-****

*************@*****.***

Professional Summary:

Over 14+ years of IT Professional experience.

Extensive experience in the Healthcare domains as a Senior Data Analyst, with strong technical, analytical, and management skills to drive data-driven decisions and strategic initiatives

Very Strong SQL/PLSQL knowledge, with variety of Databases like Oracle, Teradata, DB2, Netezza, SQL server, PostGres

Hands on Experience in various ETL Tools like Ab initio, Informatica

Experience in working on Agile and Waterfall environment.

Experience in using XML, JSON, FHIR data formats

Proficient with Tools/Utilities such as TOAD, Win SQL, AQT, DB Visualizer SQL Tools.

Specific Areas of expertise in Business Intelligence & OLAP Technology include rich experience in providing ELT solutions using Teradata, Oracle, and Netezza

Good knowledge in Modules, Test Cases, Execution, Test Case Design Sections in TOSCA

Extensive experience in Testing, Manual and Automated using tools Win Runner, Quick Test Professional, Test Director, Quality Center, Rational Tools, Web and Client/Server Applications. Extensively used version control and defect tracking tools Clear Case and Clear Quest.

Expertise in Running the test and analyzing Test results, Synchronizing the test, Checking GUI and Bitmaps etc with Win Runner, checking Database with QTP

Involved in developing and maintaining Test Matrix and Trace-ability Matrix and performing Gap Analysis

Extensive experience in leading/working with teams (offshore and onsite) to guide them with their requirement gathering and manage that team providing support and periodic project status updates.

Extensive knowledge in entire Software Development Life Cycle (SDLC) - Business requirements analysis, Design, Development and testing.

Extensive experience in Analyzing Software Requirement Specifications and involved in development of Test Plans, Test Cases and executing them.

Excellent logic skills for understanding and developing system workflows and well suited for communicating with both technical and non-technical professionals.

Expertise in Manual Testing for Web and Client/Server applications on Windows.

Proficient in Testing, System Testing, GUI Testing, Backend Testing, Black box Testing, Regression Testing and Functionality Testing.

Expertise in software management tools: Test Director for Defect tracking and reporting.

Up to date technical proficiency in organization assessment.

Good analytical and communication skills and ability to work independently and perform as part of a team.

Performed Configuration Management, Change Management, Release Management and Defects Management.

Experience in manual testing of client-server and Web-based applications.

Skill Set:

Programming Languages C, SQL, PL/SQL, Java, python

Databases Oracle 9x, 10x, 11x, Teradata, MS-Access, DB2, SQL Server, Netezza, PostGre

Internet Technologies HTML, DHTML, Java Script, Applets, XML

Web Servers Web logic 4.5.1/ 5.0.1, J2EE, Java web server 2.0, Tomcat

Operating Systems MS-DOS, WINDOWS, UNIX, LINUX.

ETL/OLAP Tools Ab Initio, Informatica Power center, Business Objects XI

Tools Win Runner 7.6, Quick Test Pro, Mercury Quality Center 9.0 and Load Runner 7.6, TOAD, DB Visualizer, DOORS 8.1, Rational Clear Case, Clear Quest, Hyperion 5.0, Rapid SQL 7.4.0

EDUCATION:

Bachelor of Science in Engineering.

Postgraduate Diploma in Computer Applications, India.

Certifications:

MicroStrategy ANALYST

Tricentis Tosca Product Consultant Certification

PROFESSIONAL EXPERIENCE

Premier Inc, NC Feb’11 – Till Date

Senior Engineer (Quality, Data Analysis, ETL Automation Testing)

During my 14-year tenure at Premier Inc., a leading supply chain company serving over 1600 health systems, I took on multiple roles, including Data Analysis, Quality Assurance Automation. Below are some of my key responsibilities

Responsibilities:

Worked On Databricks Migration Projects.

Created Test plan for migration to Databricks.

Create Automation scripts using python and spark in data bricks for migration projects from Teradata to Databricks.

Have knowledge on running workflows in Databricks.

Worked as Business Analysist and gather/understanding the requirements and develop the ETL code in Ab initio and ELT code using Teradata, Netezza and DB2

Contributed to a migration project, facilitating the transition of databases from Netezza to Teradata, ensuring smooth data migration, performance optimization, and system integration

Did various data analysis using Excel, Python for data aquation team

Experience with JIRA, Zephyr/X-Ray tools

Proficiency in Power BI, Business Objects, Crystal Reports, Tableau reporting tools

Fine-tuned ETL code using Teradata SQL and Identified statistics to long running queries

Automation ETL Validation using Cucumber and Selenium

Automation of Provisioning using Katalon studio 9.3.2.

Proficient in TOSCA, Query surge and Postman Automation tools

Understanding of ETL, Snowflake, and data modeling concepts

Worked on developing Testcase in Premier Inhouse framework (PQA) developed on selenium base.

Worked on HL7 data processing for ECR (Electronic Case Reporting)

Worked with postman for validating HL7 messaging

Extensively worked on Testing PHI data for De-Identification of data.

Tested AWS PHI removal service and compared data for large volumes of samples.

Created sample data using open source for PHI removal tool testing.

Extensively Worked on data validation in MicroStrategy reporting tool.

Creating Deployment Plan to the team during the code release and lead the QA team to identify any bugs in the release

Served as a liaison between business team and the user team by assisting the users in identifying, understanding, and documenting their business needs.

Worked throughout SDLC, which included requirements, specifications, design, analysis and testing utilizing iterative methodology.

Developed User Requirement Specifications and Functional Requirement Specifications using Rational RequisitePro and also created Traceability Matrix.

Performed research and analysis to identify downstream impacts for implementation.

Involved in development of business and technical requirements in preparation of design and functional specifications for business needs and processes.

Assisted in defining project milestones, schedules, monitored progress and updated plans using MS Project.

Experience in working with offshore on-site co-ordination with testing teams.

Utilized Impala SQL to query and analyze data within Hadoop, ensuring efficient data retrieval and processing for analytics and reporting

Knowledge on using JIRA creating stories, walking through JIRA tickets in Grooming sessions for DEV, Testing, User teams.

Proficiency in Business Objects reporting tool

Communicating to upstream and down steam products on ETL related issues and resolving them in a timely manner

Developed and implemented automated test scripts to validate ETL processes

Performed root cause analysis and impact analysis for downstream systems

Used multiple Database packages in the ELT process to fine tune the process

Prepare Test data, Design System Test cases/ Test Scenarios, Review test cases and scenarios designed by the team and base line the deliverables.

Write complex SQLs joining data across multiple Databases/tables to pull and analyze data.

Worked on various platforms like databricks, hadoop impala, hive,postgres, Google Cloud Platform (GCP)

Projects:

Quality Advisor

Premier Analytical data warehouse

Physician focus

ECR (Electronic Case Reporting)

ADVDA (advisory exchange)

Insights (Migration Project)

Environment: Ab Initio, Teradata, Databricks, Netezza,AQT,DB Visualizer, Azure,Hadoop Impala, Hive, Oracle, MS Excel, SQL, Unix, Putty, Micro Strategy, Tableau, Rally, Microsoft Visio, ADO, Jira, X-rays, Zephyr, TestRail, MS SQL server, Informatica Power Center, Confluence and Bitbucket.

Contact this candidate