Rakesh Chowdary
Indianapolis
Summary
Having 12+ years of experience in Data Analytics, Defect Analysis, Migration Projects, Internal Audit, Process Management, Quality Operations, Software Engineering, and Testing in various industry domains including Aeronautical, Banking, Financial, Healthcare, Infrastructure, Insurance, Manufacturing, Pharmaceuticals, Supply chain and Telecommunications. In depth hands on knowledge on different phases and Infrastructure Service Management Life Cycle (ITIL), Software Development Life Cycle(SDLC), Medical Quality Management System, Project Management, Configuration Management, Defect Management and Risk Management processes.
Overview
9
9
years of professional experience
Work History
Sr. Quality Assurance Specialist
LifeStance Health
11.2021 - Current
- Successfully implemented Azure to AWS migration project
- Co-ordinated with stakeholders to understand the business cases and incorporated them in test plan
- Gained thorough knowledge on Payroll and Revenue process
- Automated the validation of Databricks tables to get counts of daily runs and count of differences
- Experience in using Jenkins as continuous integration tool to creating new jobs, managing required plugins, configuring the jobs selecting required source code management tool, build trigger, build system, and post build actions, scheduled automatic builds, notifying the build report.
- Co-ordinated the UAT working sessions with business to run the edge cases for successful sign off for migration
- Extensively used Athena Query tool in AWS console to compare the data set between Azure and AWS
- Experience in deploying applications with Cloud Services by creating a simple Cloud Service with Visual Studio, testing it locally, deploying to a live Microsoft Azure Cloud environment and AWS.
- Assisted in designing new data warehouse methodology; data analysis, modelling and design, and ETL testing
- Strong knowledge of Data warehouse and mapping documents
- Played a key role in Data Operations project to test all the user reported incidents
- Create and manage Validation Test Plans including Analysis/Development/Validation Plan and Report Form (ADVP&R)
- Tested a 'server less' architecture using API Gateway, Lambda, and Dynamo DB and deployed AWS Lambda code from Amazon S3 buckets.
- Worked extensively on joining tables, multiple data connections using blending, worked on Data Extracts and managing queries
- Involved in reviewing and approving Pull requests in Azure
- Worked with Project managers to understand different environments in the Project and drafted a Delivery pipeline
- Working knowledge of Azure Services IaaS, PaaS, and SaaS and coming trends in the Cloud space
- Served as a hands-on subject matter expert for DevOps and Automation in an Azure/AWS infrastructure environment.
- Provided regular updates to team leadership on quality metrics by communicating consistency problems or production deficiencies.
- Educated employees on specific QA standards and confirmed maintenance of standards.
- Responsible for creating tagging standards for proper identification and ownership of EC2 instances and other AWS resources.
Quality Engineer
TRIMEDX
03.2017 - 11.2021
- Skills in data warehouse methodology; data analysis, modelling and design; and ETL testing
- Strong knowledge of Data warehouse and mapping documents
- Extensively tested all reporting dashboards in Looker
- Performed extensive system integration testing on our Informatics platform (LifeRay)
- Extensively validated data from our cloud data warehousing tool, Snowflake
- Extensively used ANSI SQL queries against Dimensional and fact tables in Snowflake for Data Validation
- Solid understanding of JavaScript, jQuery, and AngularJS.
- Used Data validation techniques like Data profiling via Informatica Data Explorer, Source to Source verification, count check between sat and hub tables and normalized tables
- Developed and published ServiceNow & Enterprise Data Warehouse Release process
- Tested Informatica integrations (ETL, REST and SOAP) from source system to target system
- Experience of Object relation mapping using ADO.NET, Entity Framework, LINQ to SQL, LINQ to objects, and Lambda Expressions used in LINQ.
- Worked on JIRA for defect/issues logging & tracking and documented all my work using CONFLUENCE
- Practical understanding of the Data modelling Dimensional Relational concepts like Star-Schema Modelling, Snowflake Schema Modelling, Fact and Dimension tables
- Extensively worked in Azure - Creating pipelines, Triggering releases and for Token key management
- Create and manage Validation Test Plans including Analysis/Development/Validation Plan and Report Form (ADVP&R)
- Worked extensively on joining tables, multiple data connections using blending, worked on Data Extracts and managing queries
- Involved in reviewing and approving Pull requests in Azure
- Created and tested SQL Server Integration Services (SSIS) packages, and creating reports using SQL Server Reporting Services (SSRS).
- Worked closely with Enterprise Data Ware house team and Infrastructure team to migrate our warehouse from in house SQL Servers to Snowflake(Cloud)
- Initiating alarms in DataDog service for monitoring the server's performance, CPU Utilization, disk usage etc
- To take recommended actions for better performance
- Mastered in using Filters, sorts, groups and Sets, reference lines, Bands and Boxes in different kinds of charts
- Automated customized ServiceNow application in Tricentis Tosca
- Automated procure to pay application, Coupa, which is COTS based application
- Worked on configuring Tricentis Tosca with Infrastructure team
- Worked closely with infrastructure team to foresee successful SQL Server upgrades and performed post upgrade regression test
- Worked with architectures to understand Continuous Integration and Continuous Delivery (CICD) in TRIMEDX.
Data Quality Engineer
Bridgestone Americas
01.2016 - 02.2017
- Creating and managing schema objects such as Tables, Views, Indexes, and referential integrity and converting them into technical specifications
- Administer, maintain, developing, and recommending policies and procedures for ensuring the security and integrity of the company's databases
- Carried out UAT by developing test plans, test scenarios, test cases, test data to be used in testing based on business and user requirements, technical specifications and/or product knowledge
- Excellent knowledge of source control management concepts such as Branching, Merging, Labelling/Tagging and Integration, with tools like GIT and TFS
- Managing AMI/Snapshots/Volumes, upgrade/downgrade AWS resources (CPU, Memory, EBS)
- Implemented the project using Agile Scrum methodology and analysed the detailed business case to understand the client needs
- Setup databases on Amazon RDS or EC2 instances as per requirement
- Participated in planning, implementation, and growth of our infrastructure on Amazon Web Services
- Profiled/Analysed the source data from files and database tables using Information Analyzer for column analysis, primary key analysis, multi column analysis etc
- Created Data Sources from various external applications, scripts to parse incoming data and transform into ServiceNow
- Experience in Data warehousing and Business Intelligence technologies along with strong experience of data visualization using Tableau
- Built interactive dashboard using techniques like guided analytics and visual best practices provided by Tableau
- Worked on Tableau administration tasks such as publishing workbooks, setting permissions, managing ownerships, working with Sites, providing access to the users and adding them to the specific groups and Projects, Scheduling Refreshes and Subscriptions in Tableau Server
- Designed AWS Cloud Formation templates to create custom sized VPC , subnets , NAT to ensure successful deployment of Web applications and database templates
- Build DataSync job on Windows Azure to synchronize data from SQL 2012 databases to SQL Azure
- Involved in designing and developing Amazon EC2, Amazon S3, Amazon RDS, Amazon Elastic Load Balancing, Amazon SWF, Amazon SQS, and other services of the AWS infrastructure
- Generated many DDL, DML and DRL queries in SQL to retrieve data from target database and in designing schemas, creating databases, and executing queries using SQL
- Collaborated with product owner to build requirements log (product backlog) with cost estimates and priority
- Carried out UAT by developing test plans, test scenarios, test cases, test data to be used in testing based on business and user requirements, technical specifications and/or product knowledge
- Performed Data migration from SQL Server to SQL Server, SharePoint document library to SQL Server, and Excel to SQL Server
- Developed, Deployed, and Maintained many an ETL packages using SSIS
- Working knowledge of Infrastructure as a Service (IaaS), Platform as a Service (PaaS) and Software as a Service (SaaS)
- Developed, Deployed and Maintained many a Reporting packages using SSRS.
Data Quality & Process Analyst
HCL Technologies
06.2011
- Gathered business requirements and understood the goal of data warehouse
- Successfully analysed the functional/non-functional requirements of the data warehouse for generating BI reports and communicated the same to architects and developers
- Extensively interacted with data analysts during the ETL operations in identifying the source files/databases and implementing the transformation logic for achieving data uniformity in operational data store (ODS)
- Established Requirements Traceability Matrix (RTM) using Rational Requisite Pro to trace the completeness of requirements
- Hands on experience in debugging general database SQL code, dynamic SQL, stored-procedures, user-defined functions, SharePoint application and InfoPath forms
- Designed Data Flow Diagrams (DFD), Entity Relationship Diagrams (ERD), and web page mockups using modelling tools
- Experience in Creating and Configuring Records Management Centre in SharePoint 2013, 2010 per business requirements
- Actively managing Data centre migrations across different power grids in USA
- Creating and managing schema objects such as Tables, Views, ERD, Indexes, and referential integrity and converting them into technical specifications
- Executed project in Agile SDLC methodology
- Used Scrum Work Pro and Microsoft Office software to perform required job functions
- Used HP ALM to manage the requirements and Test cases
- Implemented Network Load Balancing between SharePoint Server 2013 and 2010 front end web servers
- Involved in Project Management activities like defining / managing project scope, schedule management, creating project plans, tracking, and communicating project status and deliverables
- Involved in identifying and suggesting the different dimensions like slowly changing dimensions/rapidly changing dimensions etc
- Which are required for generating the reports and OLAP cubes to facilitate the multi-dimensional view of the data to generate slicing/dicing, rollup/drill-down reports
- Performed data profiling to gather and analyze the technical metadata characteristics of the data using Information Analyzer
- Applied UML notations and methodology in developing models that accurately represent the business process reengineering and workflows and clearly communicate them to the stakeholders
- Participated in Planning and strategy meetings, and actively monitored DR planning & DR Testing
- Communicated with project managers, Client support contacts, Firewall Engineers, System Administrator, Account security officers, Implementation teams, and compliance management to achieve required goals
- Effectively implemented Change management procedures and adhered to process
- Collaborated with Data Management and Project management groups in efforts to automate scan process and increase efficiency
- Coordinated with the DW architects and developers to identify appropriate dimensional modelling (identifying dimensions/facts/referential integrity), measures (additive/semi-additive/non-additive) and sizing (in terms of number of columns, records per dimension and fact table)
- Extensively interacted with the designers, developers to ensure functional implementation of business requirements and QA Team in executing Test Plans, Test Scenarios, and Test Cases
- Successfully analysed the functional/non-functional requirements of the data warehouse for generating BI reports and communicated the same to architects and developers
- Inner, Outer, Left, and Right Joins to update the database and retrieve data for data analysis and validation
- Coordinated the execution of Unit Testing, System Integration Testing (SIT), Performance & Service level testing and User Acceptance Testing (UAT)
- Developed the training schedules, user manuals and trained the business/end users.
Education
Master of Science - Computer Science - Information Technology
Loyola University Chicago
Chicago, IL05.2016
Bachelor of Science - Computer Science And Engineering
Anna University
Chennai, India05.2011
Skills
Languages: C#NET, HTML, Java, SQL, T-SQL, PowerShell, VBNET, PL/SQL, PYTHON
Databases: Redshift, Postgres, Snowflake, SQL Server 2012/2014 / 2016, MySQL, MS Access Life Cycles: SAFe(Scaled Agile), Software Development Life cycle(SDLC), ITIL, Kanban
Project Management: Corrective Action and Preventive Action (CAPA), Customer Satisfaction (CSAT), Defect Analysis, Risk Management, Change Management
Tools: Looker, Tableau ,Qlik View, BI 360, SSRS, Azure, AWS, SSAS(cubes), LifeRay, ServiceNow, Informatica, Tricentis Tosca, SSMS, JIRA, Jira Align, Confluence, Minitab, MS Visio, HP ALM, Load Runner, TFS, Selenium, SharePoint, HP Quality Center, Bugzilla
Timeline
Sr. Quality Assurance Specialist
LifeStance Health
11.2021 - Current
Quality Engineer
TRIMEDX
03.2017 - 11.2021
Data Quality Engineer
Bridgestone Americas
01.2016 - 02.2017
Data Quality & Process Analyst
HCL Technologies
06.2011
Master of Science - Computer Science - Information Technology
Loyola University Chicago
Bachelor of Science - Computer Science And Engineering
Anna University
Similar Profiles
Alyssa GomezAlyssa Gomez
Cash Posting Coordinator at Lifestance HealthCash Posting Coordinator at Lifestance Health
Kevin TolerKevin Toler
Psychometrist at LifeStance HealthPsychometrist at LifeStance Health
Daneka BryantDaneka Bryant
Front Office Administrator at LifeStance HealthFront Office Administrator at LifeStance Health