Shreyash Upadhyaya

Senior Data Analyst (2021 to Present)

• Delivered comprehensive reports highlighting key trends, patterns, anomalies, presenting findings to senior management for informed decision-making purposes.
• Analyzed large amounts of data to identify trends and find patterns within data.
• Leveraged text, charts and graphs to communicate findings in understandable format.
• Managed/Lead the data ingestion validation team and assisted with standardizing the validation process from start to end of the project lifecycle in Agile and waterfall methodology. Worked on various applications related to data warehousing and business intelligence/business analytics.
• Project test lead for multiple Corporate Initiative projects at a time. Responsibilities included project planning, estimating timelines in correspondence with other teams within SDLC, allocation of resources per project task, assignment and prioritization of tasks, building test cases, test plans, writing advanced SQL scripts with complex business requirements within both Snowflake, Oracle and SQL Server environments, execution of test queries, SIT data validation and backend testing to validate ETL code, reviewing team’s scripts and test results, logging defects in ALM and communicating all status with the project team twice a week by hosting calls and providing test execution and defect reports.
• Collaborate with cross-functional teams to identify business needs and develop solutions.
• Mentor junior analysts and provide guidance on data analysis best practices
• Facilitated defect review board meetings, source to target mapping review meetings, requirement analysis meetings and status meetings with teams to equip the team with all the tools needed for the project.
• Attended daily standup meetings, scrum calls and retrospective meetings at the end of each sprint.
• Assisted the team to get access to required environments, databases, and tables.
• Worked on Clinical Data for Wellness/disease Management TDS, CVS, Medical, LabCorp, Minute Clinique, Sharecare, and other sources for Immunization, biometric, Pharmacy, Diabetes management, Lab, and other clinical segments for Business Analytics. Performed UAT.
• Worked extensively on both data Ingestion and Data Integration Teams for Data Hub Transformation Project on cloud using Azure.
• Utilized excel macros to compare files for counts and data validations.
• Used python code automation to validate data between different environments like on premise and Snowflake cloud environments.
• Reviewed the teams test results and other test artifacts to provide approval for both ingestion and integration as a project lead.
• Used SQL Server to check the pipeline run status and Meta data tables to confirm data loads and validated the loads in Snowflake Trusted and Conformed tables using SQL queries.

Data Warehouse Engineer (2018-2021)

• Design end execute database tests for backend applications.
• Develop and maintain database test scripts and test cases.
• Collaborate with developers to identify and resolve databased-related defects.
• Perform data quality checks using SQL queries to validate data against predefined rules.
• Wrote queries to check null values, invalid data formats, duplicate values
• Utilized minus queries to identify missing, extra and differing values between datasets.
• Participate in database design and data modeling
• Review STM document and Business rules with B0usiness tyeam/ Data governance team.
• Utilized Agile methodologies to facilitate collaborative and iterative project development, ensuring timely and effective delivery of project.
• Leveraged Jira tool for test cases management defect tracking to ensure comprehensive testing coverage and prompt defect resolution.
• Assisted the team to upload test cases to Jira via Zephyr and created defects on Jira.
• Analyzed, Debugged, and fixed issues within set timelines.
• Collaborate with data architects and business stakeholders to define data model and data governance policies.
• Generated execution reports/defect reports weekly, providing status to the project team via Jira/MS excel and emails.
• Assisted in the diagnosis and resolution of problems and worked with Developers, Business Analysts, Data Architects and Solution Architects to implement solutions.
• Worked on IBM Initiate to resolve incidents and tasks via a ticketing system where a shared ID needed to be unlinked to ensure that proper claims, record, and member details are associated with one record by splitting them or assigning them a new ID once identified as separate entities. (Member life ID).
• Completed training on new Data Governance tools like Informatica AXON, Informatica Data Quality /IDQ and EDC/Enterprise Data Catalog.
• Worked with Subject Matter Experts in interacting with customers, (internal & external including Vendors) on various projects.
• Created SOP documents for the team and uploaded to a central repository for ease of use and knowledge sharing. Uploaded SQL Queries to SVN Repository.
• Took corporate trainings i.e., Python, MicroStrategy, Informatica PowerCenter, Data Modeling and Tableau.
• Performed daily and monthly routine system balancing and approval for subject areas such as Claims, Enrollment, Revenue, Employer Groups, Products and Providers.
• Assisted in ensuring the integrity of data between the various front-end CareFirst production and operational systems and backend operational data stores and warehouses.

Data Warehouse Technician (2016-2018)

• Performed as a test lead for multiple Corporate Initiative projects at a time.
• Developed logic and code to create reports to track defects in our Prod environment once a project is deployed. Coordinated between multiple teams to establish and document a defect logging standard.
• Performed EDI File masking tasks for masking PHI and PII data elements on files and tables.
• Generated synthetic data via mainframes and other portals for setting up Claims, Member Enrollments, Groups, Plans, Products, Rates and Billing Entities etc.
• Worked on various tickets for Data Masking, Synthetic Data requests, and day to day support activities.
• Assisted the team to get access to required environments, databases, and tables.
• Automated a process within Analytixds to automatically create test cases by reading from a Source to Target mapping uploaded in Analytixds.
• Created Project test plan documents, estimated timelines within SDLC, allocated resources per project tasks, created test cases, test scripts using advance SQL incorporating complex business logic within Oracle SQL Developer, MS SQL Server, Hadoop, and Snowflake environments.
• Performed data validations to validate ETL code and executed test cases using HP ALM/CA Rally. Generated execution reports/defect reports, weekly providing status to the project team.
• Logged defects and conducted Project meetings to discuss data anomalies and testing status.
• Ensured resolution of all defects before release of code to production and prior to deployment/closure of all projects. Logged risks and documented reasoning if any defects were to be handled as part of Day to day.
• Obtained approval from the Business teams and Project manager on SIT completion and created a Test Plan summary report prior to code deployment.
• Analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data.
• Partnered with IT teams to ensure seamless integration between databases and analytical tools, maximizing system efficiency across departments.
• Served as a subject matter expert on various projects, sharing valuable insights derived from extensive industry experience as a Senior Data Analyst.
• Reduced manual data entry errors by designing and deploying automated ETL processes to transform raw data into usable formats.

• Provide lifecycle management of manual testing projects on software and large database applications
• Maintain cooperative relationships with developers and communicate with both technical and nontechnical stakeholders
• Reviewed Business requirements documents to understand the process and wrote test plans and test cases
• Able to transform business requirements into high quality use cases that not only solve the business problems but can be understood by both the business and developers
• Performed Requirement Traceability Matrix (RTM) to ensure comprehensive test coverage of requirements identifies all test conditions and test data needs
• Worked on the solution which provides information technology departments with a centralized application management platform for managing and automating within and across application teams and throughout the complete process of developing an application, all within a single workflow using HP ALM/ Quality Center
• Wrote extensive SQL queries during UAT and data validation
• Participated in User Acceptance testing (UAT) and involved in UAT test cases, executed test cases, documenting defects, resolved defects and signed off from application
• Interact with team leads and other QA engineers to address quality problems and ensure test processes and procedures are followed
• Maintain Detailed Test plans
• Reported issues in the bug reporting system and follow up with the development tear until it get resolved
• Highlights of Accomplishments: Recognized for developing excellent test plans/scripts and rapidly discovering defects
• Strong analytical skills with a “test-to-break” approach on testing initiatives and clarified ambiguous requirements to ensure the effectiveness of all test plans
• Improved the documentation of QA testing practices to enhance their repeatability
• Skilled at learning new concepts quickly, can work well under pressure and able to communicate ideas clearly and effectively
• Proven ability to recognize, analyze, and resolve problems.