Shivam Yadav

Project Manager / Quality Analyst with over nine years of expertise in the Retail, E-Commerce, and Logistics sectors within
the Supply Chain field. Proficient in inventory management, order management, omnichannel strategy, customer relationship
management, digital marketing, and business process enhancement. Demonstrated ability to streamline and optimize business
processes. Skilled in facilitating User Acceptance Testing, Behavior Driven Testing, and Defect Management.
Summary
 Expertise in Leveraging design thinking, lean thinking, and cross-functional collaboration to enhance key areas, including vendor
analysis, inventory management, order management and operations management, SKU rationalization, and demand forecasting.
Proficient in E-commerce platforms of Retail, Payments, Supply Chain, Payment Gateways, Marketplace Diversification and
transforming change, delivering valuable solutions by implementing business enhancement ideas and strategies.
 Expertise in advanced quality assurance methodologies and tools, including proficient use of test automation frameworks,
continuous integration systems, and defect tracking platforms. Demonstrated mastery in designing and executing comprehensive
test strategies across diverse software applications and environments.
 Proficient in a wide range of programming languages and testing tools, including Java, Python, Selenium, JUnit, and TestNG.
Highly skilled in both manual and automated testing techniques, with a proven track record of improving test coverage, reducing
testing cycles, and enhancing overall software quality.
 Excelled as a liaison, fostering effective collaboration and communication between onshore and offshore teams, optimizing
project efficiency and alignment with organizational objectives.
 Skilled in dynamic pricing, promotional pricing, pricing optimization strategies, CMS, and product content optimization by using
advanced personalization techniques applied in merchandising and creating a user-centric customized experience.
 Adept at E-commerce user experience design, usability principles, and implementing customer journey mapping. Proficient in
ERP and CRM (Salesforce and Dynamics 365) software within B2B and B2C E-commerce environments.
 Experience in Implementing Industry-specific regulations, such as financial services regulations, that impact payment processing.
 Comprehensive knowledge of the SDLC and proficiency in methodologies like Design Thinking, Empiricism, Lean Thinking,
and cross-functional collaboration, Waterfall, Scrum, Waterfall-Scrum hybrid, LESS, and Scaled Agile Framework (SAFe).
 Proficient in orchestrating business ceremonies encompassing Project Management, Release Management, Requirement and
Change Management, Risk Management, Plan Management, Defect Management using JIRA, Confluence and MS Project.
 Proficient in Collaborating with legal and compliance teams to validate that the solution complies with state-specific procurement
and data security regulations. understanding the precise requirements by clearly communicating with business & stake owners.
 Skilled in Effective communication abilities for precise requirement definition through techniques like Stakeholder Analysis,
Market Analysis, GAP Analysis, AS-IS and TO-BE Analysis, SWOT Analysis, Root Cause Analysis, Cost Benefit Analysis,
Feasibility study, Impact analysis, documented BRD, FRD, SRS in alignment with the Requirements, Scope, and time.
 Proficient in developing various Unified Modeling Language (UML) diagrams, including Sequence, Activity, Use Case, and Data
Flow diagrams. Adept at creating prototypes such as Wireframes, Mockups, UI designs, and Business Process Model and
Notation (BPMN). Skilled in designing process flows and workflows using tools like MS Visio, Figma, and Lucid Chart.
 Adept at Collaborating with technical teams of architects & developers to assess the technical feasibility of proposed features and
user stories. Creating UML, Wireframes, Mockups, Activity, Sequence diagrams and Prototypes using LucidChart.
 Experienced in Collaborating with SME during various stages of the development cycle, creating project deliverables such as
Project Charters, Risk Documents, EVM reports, WBS, and Critical Path Analyses, documented systems for managing
interactions and sharing Architectural information with third-party vendors or solution providers, taking of validation sign offs.
 Experienced in implementing different SAFe configurations, alignment and defining Capabilities and Enabler stories and
participated as part of an Agile Release Train (ART), PI Planning, Scrum of Scrums, PO Sync, and System Demos.
 Proficient in Being actively involved in Scrum ceremonies, like High Level Grooming, Product Backlog Refinement, Sprint
Planning, Daily Stand-Up, Sprint Review meeting and Sprint Retrospective meeting, provide valuable assistance to Product
Owners in shaping the vision and scope of the projects, including the MVP, MRF, MMF, and sprint planning activities.
 Extensive knowledge in breaking epics into user stories according to SMART and INVEST criteria by vertical or horizontal
slicing technique, prioritized and estimated the product backlog items using prioritization techniques such as MoSCow, KANO,
Value-based prioritization, and estimation techniques such as Planning poker, Relative mass valuation, and T-shirt sizing.
 Experienced in Assisting to establish Test cases, Breakdown of test stories and test criteria. Knowledge of the best methods for
agile testing, like Behavior Driven Development (BDD), Acceptance Test Driven Development (ATDD), Test Driven
Development (TDD), Continuous Integration of the shippable product, Automated testing, and built-in quality.
 Knowledgeable in working on topics like Layered pattern, SOA, Monolithic and Microservices architectures, VPC-based
architectures, client-server pattern, Amazon Web Services microservices, Event-Driven pattern, and Microkernel pattern.
 Expertise in validating API endpoints using Postman and SoapUI, documentation using Swagger to capture the Headers, Query
Parameters, Resources, POST/PUT response body and received different error codes. Mapped the designed URLs for the
RESTful APIs to the business requirements and operations by using Three tier architecture and Service Oriented Architecture.
 Skilled in Generating and interpreting agile metric reports, encompassing velocity reports, Burnup charts, cycle time reports,
facilitating data-driven decision-making and continuous improvement, issue tracking along with using various addons Timesheets
for time tracking using JIRA, GitLab for Continuous Integration, Cucumber for automation testing.
 Experienced in Working to define the technical specifications for stored procedures. includes writing detailed requirements for
each stored procedure, specifying the SQL queries, input parameters, validating and verification by sign off on the expected
results.
 Proficient in Collaborating closely with business team members to gain a deep understanding of their data objectives, Partnering
with ETL engineers to envision data approach workflows, formulate transformation logics, and align with business needs and
requirements effectively. Taken charge of implementing sequences and establishing robust data quality standards, complete
verification checks to ensure data integrity, maintain a comprehensive data dictionary to guarantee data consistency, enhance
understanding of data elements, maintain clear documents, and facilitate seamless data mapping, efficiently and accurately.
 Demonstrated expertise in agile metric reporting, Velocity Reports, Burnup Charts, Cycle Time reports, and other data-driven
insights. Commanding a deep knowledge of various databases, such as Oracle, SQL, MySQL, MS Access, DB2, AWS S3, and
AWS Dynamo DB, to facilitate effective data handling, creating data views and documenting data details to ensure transparency.
 Skilled in Enterprise Data Warehousing concepts, Data Modeling, Data Integration (ETL/ELT), and Business Intelligence,
exhibiting mastery in Dimensional Data Modeling, Data Quality, Data Mapping, Data Profiling, and comprehensive evaluations
of data completeness, by ensuring data cleansing, labelling, pseudonymization and removing redundancies in the datasets.
 Accomplished in working with cloud-based environments and applications such as AWS (Kinesis, EKS, API Gateway, IAM,
Cognito, SNS, MSK, Redshift, DynamoDB) and Microsoft Azure (Synapse, Data Factory, Cosmos DB, Databricks, Key Vault,
SQL Server, Event Hubs), Salesforce, SAP, Google Cloud Platform (BigQuery, Cloud Functions, Pub/Sub).
 Expertise in managing and conducting various user acceptance tests, including User Acceptance Tests (UAT) and Operational
Acceptance Tests (OAT), collaborating with cross-functional teams, documenting feedback, bugs, and changes using MS Word.
 Adept at data visualization tools, including Tableau, Power BI, and AWS QuickSight, to create compelling analytical and visual
reports, that align business requirements in terms of Key Performance Indicator (KPI) dashboards.

Technical Skills
Business Skills SWOT Analysis, Change Management, Impact Analysis, Risk Analysis, Cost-Benefit
Analysis, JAD Sessions, ROI Analysis, Pricing Strategies, Demand Forecasting,
Competitive Analysis, Order Fulfillment, Supply Chain Management
Cloud Platform Salesforce Sales Cloud, Service Cloud, Message Cloud, Azure SQL Database, Azure
Synapse Analytics, Azure Kubernetes Service), AWS, SAP, GCP (Cloud Functions, Big
Query, Dataflow, GKE, AI Platform)
SDLC Methodologies Agile-Scrum, Waterfall, Waterfall-Scrum hybrid, SAFe
Project Management Tools JIRA, Confluence, Slack, Rally, MS Project, MS Office Suite (MS Word, Excel,
PowerPoint, Access), Outlook, SharePoint, Office 365
Modeling Tools MS Visio, Lucid Chart, Balsamiq, Enterprise Architect, Draw.io
ETL Tools Informatica Power Center, AWS Glue, SSIS
Databases SQL Server 2019, My SQL, Oracle 12c, Informatica Power Center, and AWS glue
Data Warehousing Data Marts, OLTP, OLAP, Multidimensional Analysis, Snowflake, Data Marts
Testing and defect tracking Tools HP ALM, Cucumber, Jenkins, Bamboo, Postman, Swagger, Mezmo, Dynatrace, ADO,
Lens
BI & Reporting tools Tableau, Power BI, MS Excel, Amazon Quick Sight
Programming languages Java, Python, PHP, HTML5, CSS3, Bootstrap, JavaScript, XML, JSON, PL/SQL
Other Tools Apache Kafka, Docker, Kubernetes, Git, GitHub, Jenkins, Swagger

ULTA Beauty, Bolingbrook, IL JAN 2022 to Till

Date
Project Manager / Quality Assurance Analyst
 Conducted thorough feasibility studies and cost-benefit analyses using JIRA, supporting ROI substantiation and go/no-go
decision-making processes. Performed detailed GAP Analysis by comparing AS-IS and TO-BE business process flows, using
fishbone diagrams to identify pain points and optimization and workflow automation opportunities.
 Led Program Increment (PI) Objective sessions with Product Owners, Business stakeholders, and development teams to define
and prioritize committed and uncommitted PI objectives. Facilitated PI planning sessions to refine features, identify
dependencies, and create ROAM (Resolved, Owned, Accepted, Mitigated) boards.
 Orchestrated the Agile Release Train (ART) by developing and maintaining a strategic backlog, implementing Kanban boards
with WIP limits to optimize flow, and leveraging solution dependency boards for cross-team coordination. Facilitated System
Demos and Product Owner sync meetings to foster consensus and transparency across ART teams.
 Integrated Lean Portfolio Management (LPM) processes to align delivery with organizational strategy. Drove continuous
improvement through regular Inspect and Adapt workshops and relentless improvement practices.

Technical Skills
 Employed diverse elicitation techniques, including stakeholder interviews, JAD sessions, document analysis, and user story
workshops, to gather comprehensive functional and non-functional requirements. Documented detailed Business Requirements
Documents (BRD), Functional Requirements Documents (FRD), and System Requirements Specifications (SRS), ensuring
alignment with business needs and stakeholder expectations using the MOSCOW method.
 Established and maintained a Requirements Traceability Matrix (RTM) to ensure the alignment with Project vision, business
processes and high-level business objectives, which was initially discussed during the impact analysis.
 Envisioned product and project visions with accurate BPMN diagrams, creating clear Project scope statements. Formulated
Project Management Plan (PMP) and managed triple constraints using JIRA Dashboards and information radiators such as
velocity charts, Sprint burn-up/ burn-down charts etc. to prevent scope creep.
 Demonstrated strong collaboration skills in cross-functional teams, leveraging problem-solving abilities and a detail-oriented
approach to consistently meet client expectations and project goals throughout the SDLC.
 Crafted system design documents and UI mockups with BPMN wireframes and prototypes using Figma, focusing on user-centric
interfaces. Designed Use Case diagrams, Activity flowchart, and detailed process flows with MS Visio, depicting end-to-end
workflows, customer interactions. Utilized vertical slicing and happy/unhappy flow analysis for user journey optimization.
 Collaborated with cross-functional teams (marketing, IT, operations, development) teams, and Regulatory affairs department to
translate business requirements into feasible designs. Utilized SharePoint for requirement logging for internal stakeholders.
 Performed risk assessments, documenting potential threats and mitigation strategies in RMP (risk management Plan) Document.
Created contingency plans for high-impact risks, ensuring proactive management in SDLC using confluence.

 Developed a comprehensive Data Requirement Document (DRD) using structured analysis techniques, detailing data entities,
attributes, relationships, and business rules for the integrated MDM and data warehouse solution. Utilized stakeholder interviews,
workshops, and surveys for requirement elicitation.
 Developed and optimized data models for performance and scalability, ensuring alignment with best practices. Created and
maintained comprehensive data dictionaries. Designed and documented ETL workflows and mappings, incorporating
transformation logic, data cleansing rules, and load sequences to improve data accuracy. Implemented data archiving strategies
and optimized database performance, with documented policies and procedures for maintaining data accessibility.
 Facilitated and led Scrum ceremonies including daily stand-ups, sprint planning, sprint reviews, and sprint retrospectives,
ensuring clear communication and alignment between development teams and stakeholders throughout the SDLC.
 Managed product backlog using INVEST criteria (Independent, Negotiable, Valuable, Estimable, Small, Testable) to create high-
quality user stories. Implemented Gherkin format (Given-When-Then) for acceptance criteria, enhancing clarity and testability.
Collaborated with development teams to estimate effort, for consistent sprint goal achievement and improved product quality.

 Developed and maintained Scrum artifacts, including product and sprint backlogs, burndown charts, definition of done (DoD) and
Definition of Ready (DoR), while also creating functional specifications, user acceptance criteria, and release plans, ensuring
transparency and traceability throughout the SDLC process.
 Established a data governance framework using NIST Framework, implementing data stewardship roles, quality metrics.
Implemented security measures using SQL Server security features and AWS security groups, ensuring GDPR and CCPA.
 Designed ETL workflows and mappings using AWS Glue and Oracle Data Integrator. Established data governance frameworks
and implemented security measures. Facilitated continuous integration and deployment with CI/CD pipelines using Jenkins and
maintained documentation for system architecture, data flows, and interface specifications using MS Visio.
 Created conceptual data models with entity-relationship diagrams (ERDs) using Oracle Data Modeler for logical data models.
 Constructed physical data models for AWS Redshift and Oracle MDM, optimizing for performance and scalability while adhering
to AWS and Oracle best practices. Maintained data dictionaries using AWS Glue Data Catalog.
 Designed ETL workflows and mappings using AWS Glue and Oracle Data Integrator, documenting transformation logic, data
cleansing rules, and load sequences. Implemented data quality rules in ETL processes, improving data accuracy.
 Implemented data archiving strategies using AWS S3, optimizing Oracle database performance. Documented archiving policies
and retrieval procedures in Confluence to maintain data accessibility.
 As a QA Analyst, executed comprehensive API testing with Postman, validating JSON-based RESTful services using CRUD
methods to ensure functionality across endpoints, including user authentication, data retrieval, and transaction processing.
Documented endpoints using Swagger for efficient and secure data exchange. Queried MongoDB databases to extract and analyze
data for testing purposes.
 Developed detailed Test plans and Test cases for ETL processes to ensure data integrity and transformation accuracy. Created
detailed data mapping documents, tracing data lineage from source systems to target MDM & data warehouse (DWH) tables.
Tested complex workflows and identified areas for improvement.
 Developed comprehensive test plans, cases, and scripts for functional, non-functional, integration, and regression testing scenarios
using tools like Selenium for swift and precise automated testing and Cucumber for Behavior Driven Development (BDD)
practices, leveraging the RTM for thorough test coverage and requirement validation. Created detailed mockups and wireframes
to communicate design concepts effectively.
 Engaged with business users for solution sign-off, providing training and assistance during UAT, SIT, and other testing phases,
including Sanity, acceptance, integration, and regression testing. Documented test plans, cases, scenarios, reports, and the
Requirements Traceability Matrix (RTM) to ensure solutions met business requirements. Executed manual testing and utilized
 Selenium for UAT, identifying and tracking defects in Jira, and contributing to defect management documentation in SDLC.
Reviewed and executed automation tests, collaborating with QA engineers to ensure quality.
 Developed clear, detailed, and precise user stories with well-defined acceptance criteria. Asked questions and sought
clarifications to fully understand complex business rules and processes. Monitored and analyzed system performance by reading
logs using tools such as Mezmo, Dynatrace, ADO, and Lens.
 Utilized MongoDB query language and aggregation pipeline to perform complex data analysis, including filtering, grouping, and
sorting large datasets efficiently. Leveraged MongoDB's flexible schema to adapt queries to evolving data structures and
requirements.
 Implemented indexing strategies to optimize query performance and wrote efficient queries to handle large-scale data operations.
Used MongoDB Atlas tools for data visualization and performance monitoring, ensuring optimal database performance during
testing and analysis phases.
 Utilized Tableau to define and visualize key performance indicators (KPIs), metrics, and dimensions, providing actionable
insights into sales performance, inventory health, risks, and opportunities for online and physical stores.
 Developed Ad-Hoc reports, standard static reports, and business intelligence (BI) reports, utilizing Tableau to create interactive
dashboards and storyboards that provided valuable insights and key performance indicators (KPIs) for metrics like lead time,
cycle time, and work-in-progress (WIP).
 Designed visualizations such as pie charts, scatter charts, histograms, waterfall charts, bar charts, pivot charts, and combo charts
to effectively communicate metrics like cumulative flow diagrams, control charts, and burndown charts, enabling data-driven
decision-making and process improvement.
 Conducted Generated various reports to support business operations and analytics, including Ad-Hoc reports for data-driven
insights, Cycle Count reports for inventory management, High and Low Inventory Store reports to address overstocking and
understocking, Store Sales Rolling reports to track sales trends, and Flexible Period reports for customizable reporting options.
Environment: SAFe , JIRA 9.0, Confluence 8.0, MS Visio 2021, Figma (web-based), Visual Studio Code 1.74, AWS Glue 3.0,
AWS Redshift 1.0.37000, AWS S3 (latest), Oracle Data Integrator 12.2.1.4, Oracle Data Modeler 22.2, Oracle Database 21c,
Postman 10.x, Swagger (OpenAPI 3.0), Selenium 4.7.0, Cucumber 7.x, Jenkins 2.375.x, Tableau 2022.4, Git 2.38.x, and Docker
20.10.x.

Expedia.com, Seattle, WA NOV 2019 to JUL 2021

Project Manager / Quality Assurance Analyst
Responsibilities:
 Executed comprehensive project viability assessments and ROI analyses using JIRA, supporting strategic decision-making
processes. Conducted in-depth GAP analysis, contrasting AS-IS and TO-BE workflows, and employed fishbone diagrams to
identify optimization opportunities and streamline business processes.
 Implemented diverse requirement gathering techniques, including stakeholder interviews, JAD sessions, Brainstorming and user
story workshops. Produced comprehensive BRDs, FRDs, and SRS documents, leveraging MOSCOW method to ensure alignment
with business objectives and stakeholder expectations.
 Developed and maintained Requirements Traceability Matrix (RTM), ensuring coherence between project vision, business
processes, and high-level objectives identified during initial impact analysis.
 Created product and project visions using BPMN diagrams and precise scope statements. Formulated Project Management Plan
(PMP) and managed triple constraints via JIRA Dashboards and information radiators to prevent scope creep.
 Designed system documentation and UI mockups utilizing BPMN wireframes and Figma prototypes. Crafted Use Case diagrams
and Activity flowcharts, swim-lane diagrams in MS Visio, employing vertical slicing and happy/unhappy flow analysis for user
journey optimization.

 Excelled in cross-functional team environments, combining analytical problem-solving with meticulous attention to detail.
Consistently delivered high-quality results that surpassed client expectations and project objectives across various stages of the
software development lifecycle SDLC.
 Orchestrated collaboration with cross-functional teams and regulatory affairs department to transform business requirements into
feasible designs. Utilized SharePoint for efficient requirement logging and tracking for internal stakeholders.
 Executed comprehensive risk assessments, documenting potential threats and mitigation strategies in Risk Management Plan
(RMP). Developed contingency plans for high-impact risks, ensuring proactive management throughout SDLC using Confluence.
 Led Scrum ceremonies including daily stand-ups, sprint planning, reviews, and retrospectives, fostering clear communication
between development teams and stakeholders throughout the SDLC.
 Optimized product backlog using INVEST criteria, implementing Gherkin format for user stories, defined acceptance criteria.
Collaborated on effort estimation, ensuring consistent sprint goal achievement and improved product quality.
 Established and maintained critical Scrum artifacts, including product and sprint backlogs, burndown charts, and Definition of
Done (DoD), Definition of Ready (DoR). Generated functional specifications, user acceptance criteria, and release plans, ensuring
development process transparency throughout SDLC.
 As a QA Analyst, executed comprehensive black-box and white-box testing throughout the SDLC, including FIT (Functional
Integration Testing) and regression testing. Leveraged TestRail for robust test management and Jira for efficient defect tracking,
ensuring optimal test coverage.
 Conducted thorough RESTful API testing using Postman, meticulously validating JSON-based services. Designed and
implemented automated UI testing frameworks utilizing Selenium WebDriver, significantly enhancing efficiency for smoke,
sanity, and exploratory testing across all SDLC phases.
 Orchestrated comprehensive performance, security, and accessibility testing in parallel with functional testing. Utilized MySQL
Workbench for rigorous data validation, supporting thorough QA processes from unit testing through to user acceptance testing.
 Spearheaded the implementation of continuous integration testing practices, integrating automated test suites with Jenkins for
early defect detection. Collaborated with development teams to establish robust code quality metrics and testing standards.

 Pioneered the adoption of behavior-driven development (BDD) methodologies, utilizing Cucumber to create executable
specifications that bridged communication gaps between technical and non-technical stakeholders.
 Developed comprehensive test strategies encompassing functional, non-functional, integration, and regression scenarios. Utilized
Cucumber for Behavior Driven Development (BDD) practices, leveraging the RTM for comprehensive test coverage and
requirement validation.
 Facilitated user acceptance by coordinating with business stakeholders during User Acceptance Testing (UAT), System
Integration Testing (SIT), and various testing phases including sanity, integration, and regression testing. Created detailed test
documentation including plans, cases, and RTM to verify alignment with business requirements. Performed manual and
automated testing using Selenium, managing defects in Jira and contributing to quality assurance documentation.
 Utilized Confluence for collaborative information and file sharing, improving visibility b team members.
 Developed Tableau dashboards by leveraging Tableau features such as parameters, sets, calculated fields, table b, user filters, and
action filters, applying advanced technical charts to display reports meeting corporate needs.
Environments: Agile Environment - SAFe 4.6, JIRA 8.5, Confluence 7.0, MS Visio 2019, Figma (web-based), SharePoint 2019,
Visual Studio Code 1.40, Postman 7.x, Swagger (OpenAPI 3.0), Selenium 3.141.59, Cucumber 4.x, Tableau 2019.4, Windows 10,
macOS Catalina, Git 2.24.x, SQL Server 2019

State of Oregon MAY 2018 to OCT

2019
Business Analyst/ Quality Assurance Analyst
Responsibilities:
 Developed comprehensive business requirements, user stories, and use cases for the "Honored Rider" program, Fare Capping
functionality, and Passenger Information Display Systems (PIDS), compiling them into a Business Requirements Document
(BRD), User Stories, and Use Case Diagrams.
 Established a centralized repository for all project-related documentation, including system architecture diagrams, integration
blueprints, user requirements, and implementation guides, utilizing ProjectWise ECM to ensure consistency and reduce errors.
 Defined the project scope, encompassing features, functionalities, and milestones of the " Honored Rider " initiative and Fare
Capping functionality, through a Scope Statement, Project Plan, and Work Breakdown Structure (WBS) for comprehensive
management and clarity throughout the project lifecycle.

 Leveraged strong problem-solving abilities and collaborative skills to excel in cross-functional teams. Applied a detail-oriented
approach to overcome complex challenges, consistently delivering solutions that surpassed client expectations and project goals
throughout the software development lifecycle SDLC.
 Integrated ProjectWise ECM with other project management and system integration tools to ensure a smooth data flow between
different platforms, crucial for tracking Fare Capping and ensuring seamless operation within the digital ticketing ecosystem.
 Translated requirements into technical specifications and system design documents, ensuring the seamless integration of the Fare
Capping functionality, including System Requirements Specification (SRS), Solution Design Document, and ER Diagram
 Evaluated user interface designs and prototypes to ensure optimal usability and alignment with user expectations, leveraging
Wireframes, Mockups, and UX Design Review Reports using Adobe XD for comprehensive evaluation.

 Implemented an Oracle 12c database as the centralized repository to store and manage real-time transit data, fare information, and
passenger details, enabling seamless integration of Portland's "Honored Rider" initiative with TriMet's existing systems.
 Utilized Oracle 12c's in-memory capabilities and columnar compression to optimize performance for real-time transit tracking
and fare capping calculations, ensuring low latency and high throughput for time-sensitive operations.
 Leveraged Oracle 12c's advanced replication and sharding features to distribute data across multiple nodes, ensuring high
availability and scalability to handle the increasing volume of transit and passenger data.
 Employed Oracle 12c's advanced security features, such as transparent data encryption and data redaction, to protect sensitive
passenger information and comply with data privacy regulations.
 Integrated Oracle 12c's spatial and graph data capabilities to efficiently manage and analyze transit route information, enabling
optimized route planning and real-time passenger information display on PIDS.
 Ensured traceability between business requirements, design specifications, and implemented features, including Requirement
Traceability Matrix (RTM), Test Cases, and User Acceptance Testing (UAT) Reports, and contributed to the creation of a
comprehensive Test Plan with the testing team.

 As a QA Analyst, I created test plans using TestRail for Unit, System, and UAT phases. I used MySQL Workbench for data
validation, Jira for defect tracking, and Selenium for UI automation. This approach improved test efficiency throughout the
SDLC, enhancing software reliability.
 Conducted post-implementation reviews to assess project success, identify lessons learned, and gather feedback, documenting
findings in Post-Implementation Review Report, Lessons Learned Document, and Training Materials.
Environments: Waterfall, MySQL, JIRA (v7.0), Jerkins, Figma, Tableau, Java Spring Framework, UAT, Selenium, Docker,
Kubernetes, Adobe XD, JavaScript, ProjectWise, Oracle 12c

Paytm E-Cinema, Noida, India FEB 2017 to APR 2018

Business Analyst/ Quality Assurance Analyst
Responsibilities:
 Led requirements gathering sessions with stakeholders from diverse departments and user groups to thoroughly understand
intricate nuances of business objectives and user needs for the e-cinema booking feature in Paytm application development.
 Analysed extensive user feedback, meticulously examined market trends, and conducted in-depth research to identify lucrative
opportunities to enhance movie booking experience and implementing dynamic seat selection functionality.
 Collaborated closely with application development teams to effectively translate business requirements into the precise technical
specifications, ensuring seamless alignment with project goals, and meticulous adherence to the established timelines.
 Developed comprehensive test cases and scenarios, incorporating positive and negative test data. Utilized TestRail for test
management, Selenium for automation, and Jira for defect tracking. Executed various testing types including functional,
regression, and UAT across the SDLC, ensuring robust software quality.
 Facilitated comprehensive user acceptance testing (UAT) sessions to rigorously validate the functionality and usability of the e-
cinema feature, iteratively incorporating feedback for the continuous enhancement and improvement.

 Designed and implemented a normalized database schema in MySQL RDBMS to store and manage movie theater information,
showtime schedules, seat layouts, and user booking data. This ensured data integrity, reduced redundancy, and facilitated efficient
querying and updating operations for the dynamic seat selection and booking process.
 Demonstrated exceptional problem-solving skills in QA processes, efficiently identifying and resolving complex software issues.
Applied analytical thinking and innovative approaches to overcome testing challenges, significantly improving product quality
and reliability throughout the SDLC.
 Utilized MySQL's transactional capabilities to guarantee data consistency and reliability during the ticket booking process.
Implemented robust transactions to handle concurrent seat selections, reservations, and payments, ensuring that seat availability
and booking statuses remained accurate and up-to-date, even in the face of high user traffic and concurrent operations.
 Worked closely and collaboratively with the UI/UX designers to ensure intuitive and aesthetically pleasing interface designs,
facilitating seamless integration of the e-cinema booking feature within the Paytm application ecosystem.
 Conducted regular stakeholder meetings and progress updates, actively fostering open communication channels to ensure project
milestones were met, and any potential issues or roadblocks were identified and addressed promptly.
 Contributed significantly to post-implementation reviews and analysis, meticulously capturing lessons learned and identifying key
areas for enhancement of the e-cinema booking feature and overall user experience in the Paytm app.
Environment: Agile, MySQL, MS Visio (v14.0), MS Access, Oracle, UAT, Figma, MS Project, Tableau, JIRA, React
Native

Impetus Technologies, Indore, MP JUL 2015 to JAN 2017

Junior Software Developer/ Quality Assurance Analyst
Responsibilities:
 Actively participated in the development of Python-based websites and web applications using the Django framework,
collaborating with the team to implement coding solutions and ensuring adherence to project specifications with precision.
 Provided valuable support in integrating APIs into various Python web projects, applying best practices for smooth and
efficient data exchange across diverse systems and platforms, enhancing overall functionality and performance.
 Played a pivotal role in customizing homepage, category page, and product page layouts based on detailed client mock-ups,
honing skills in creating visually appealing designs that boost user engagement and satisfaction.
 Contributed significantly to the development of Django-based extensions and modules, focusing on enhancing features such
as homepage improvements, category banners, and attribute management.
 Implemented a MySQL database as the backend RDBMS to store and manage the e-commerce platform's data, including product
catalogs, user accounts, orders, and content. Leveraged Django's Object-Relational Mapping (ORM) to seamlessly interact with
the MySQL database, simplifying database operations and promoting code reusability.
 Optimized the MySQL database schema and indexing strategies to ensure efficient querying and retrieval of product information,
enabling fast and responsive catalog browsing and search functionality. Employed MySQL's full-text search capabilities to
provide advanced search features for users to discover products based on descriptions, reviews, or other textual content.
 Implemented comprehensive automated testing for Python-based websites using Selenium and pytest, ensuring robust quality
assurance for Django applications. Developed test cases for API integration, database operations, and user interface functionality.

 Designed comprehensive test cases for functional and non-functional requirements, creating Python automation scripts for end-to-
end testing. Executed functional, integration, regression, Black Box, and White Box testing, alongside Performance, Scalability,
and Load tests.
 Conducted Smoke Testing on new builds after Jenkins deployments and performed Sanity Tests on builds with defect retests.
Ensured thorough coverage of system functionalities through diverse testing methodologies across the SDLC.

 Utilized Jenkins for continuous integration and deployment, integrating with Git for version control. Employed SonarQube for
code quality analysis, focusing on Python and Django best practices, security vulnerabilities, and performance optimization.
 Provided adept support in content management tasks, managing homepage, category, and product content in Django to
ensure a cohesive and responsive user experience that aligns with client specifications.
 Proficient in version control systems like Git, facilitating efficient collaboration and code management across Python
development teams. Adheres to branching strategies and code review processes to maintain code quality and project
coherence.
Environment: Agile, PostgreSQL, Python, Django, HTML, CSS, Tailwind CSS, JavaScript, React, WebSockets, Slack,
GitHub for version control, MySQL

University
Education of Georgia, Athens GA May 2023
Master of Science, Computer Science

Rajiv Gandhi Proudyogiki Vishwavidyalaya (RGPV), India May 2015

Bachelor of Engineering, Information Technology