Projects And Certification

Certification Badge logo for Professional Scrum master 1

Professional Scrum Master - PSM 1

    • Certified in Agile and Scrum principles to lead digital product development teams with a LEAN mindset

  • • Theory and principles behind Scrum and empiricism

    • Scrum framework application principles

    • Uncertainty and complexity in product delivery

    • Importance of the Scrum values

    • Definition of Done and why it is crucial to transparency

    • Product Backlog and its importance

    • Skills and mindset required to be a Scrum Master

Database development for a point of sale system

    • Built a robust scalable database application system that runs analytics, handles refunds, and runs on a distributed server.

    • Created an EC2 server using AWS (Amazon Web Services), loaded data, and used advanced data management techniques to complete the development.

    • Finally, deployed the database servers using clusters on AWS to allow the application to scale.

    • As a Business Owner I want to understand the growth of my business so that I can increase the revenue in the upcoming financial year

    • STEP 1 : Created a Linux instance on AWS with the latest version of MariaDB, a MySQL fork and then, created a database

    • STEP 2: Loaded the data files into the database after ETL (Extract, Transform and Load) operations

    • STEP 3: Created database views to access frequently used data to support automated display tools on website

    • STEP 4: Created indexes and transactions to maintain the data quality across the database

    • STEP 5: Created stored procedures to calculate business metrics and operating values to store necessary data for analytics

    • STEP 6: Created triggers to measure data across historical repositories

    • STEP 7: Established a peer to peer replication system to create a cluster of distributed servers in order to allow scaling of the application system

    • Designed and implemented a fully functional and automated database application system using Open Source tools

    • Individual Project

    • System Design

    • System Analysis

    • Data management

    • Database design

    • Distributed System Architecture

Product canvas for an animal shelter application system

    • Designed a new system for an animal shelter organization to manage adoptions, various types of volunteers, employees, donations, scheduling, events, and integrated their accounting system.

    • The need for a system was born from the lack of a inquiry management system to handle the requests from adopters, volunteers, and donors.

    • As an Animal Shelter Administrative Staff I want to track all the volunteer requests so that I can maintain a schedule for volunteers

    • STEP 1: Conducted a stakeholder assessment for the various users of the Animal Shelter including employees, volunteers, and donors

    • STEP 2: Performed a user research to understand user needs; developed a product vision and epic

    • STEP 3: Gathered a list of current system functionalities and contrasted with user needs

    • STEP 4: Created user stories to capture immediate user needs; created user personas to highlight findings

    • STEP 5: Designed system specification by including wireframes and mockups to capture user journey

    • STEP 6: Synthesized first phase of agile implementation and divided the user stories into various sprints for the first phase of system implementation

    • Conceptualized and designed an intuitive product canvas to capture the product requirement for the new animal shelter application system design

    • Individual Project

    • Web design

    • User journey mapping

    • User Persona design

    • Product roadmap creation

    • Sprint Planning

    • Mockup design

    • Wireframe design

    • Mockup design

Strategy Analysis for a smartphone manufacturing MNC

    • Conducted both industry-level and firm-level analyses to identify the downfall faced by a smartphone manufacturing company

    • Primary issue leading to the downfall of the company was a lack of appropriate vision, technology changes and a compelling company strategy

    • Performed a detailed study using corporate strategy fundamentals to provide a recommendation to address the strategic issue

    • The smartphone manufacturing firm which once held a dominant position in the smartphone market, lost its market share to competitors like Apple and Android.

    • The arrival of the iPhone and Android phones/operating systems provided consumers with better hardware and operating system capabilities, making it difficult for the firm to remain relevant

    • The limited technology capabilities of the firm’s devices, which were primarily marketed towards the corporate segment, hindered its growth in the fast-paced smartphone market

    • The smartphone manufacturing firm could have benefited from strategic partnerships or alliances at the onset of their downfall to increase production scale and enhance product capabilities and offerings

    • Improvements to the devices and the OS could have helped compete with the new wave of user-friendly and developer agnostic phones

    • Revolutionary innovation led by heavy investment in innovation and R&D would have provided a solid competitive advantage

    • Team Project

    • Led the project team management

    • Conducted industry analysis

    • Led the documentation design and editing

    • Defined Business-Level and Corporate-Level Strategies within businesses

    • Identified Competitive Dynamics within industries

    • Assessed Strategic Management Process and factors that affect Strategic Competitiveness

Data warehouse design and modeling for a retail company

    • Designed and developed a data warehouse for a retail store chain called Dominick’s Fine Food (DFF)

    • DFF has many branches around Chicago area. The data for this project includes store-level data covering shelf management and pricing from all the branches of DFF

    • Data captured from the years 1989 to 1994 after Chicago Booth and Dominick’s Finer Foods entered into a partnership for store-level research into shelf management and pricing was utilized to build this data warehouse

    • As a Retail Store Owner I want to make an expansion into new cities so that I can grow my business

    • STEP 1: Described the business data by understanding the retail business and its history; designed the Entity-Relationship Diagrams for the metadata

    • STEP 2: Ideated the business need by defining valid business questions to assess the need for the data warehouse

    • STEP3: Performed dimensional modeling to implement Kimball’s data mart design process; devised logical and physical design models for the data warehouse

    • STEP 4: Designed ETL plan to cleanse, model and load the data into the data warehouse; assessed the independent data marts for data quality using granularity for all data files loaded

    • STEP 5: Created data mart schemas and loaded the independent data marts after data cleaning and integration

    • STEP 6: Visualized the data from the data warehouse using reporting techniques such as SSRS, Tableau, PowerBI and ReportBuilder

    • STEP 7: Synthesized data-driven insights from visualizations and reports to answer business questions and needs

    • Designed, modeled , implemented and analyzed a robust data warehouse on MS SQL Server to store 5GB worth of business data for market analysis

    • Team Project

    • Led the project team management

    • Created data marts and ETL procedures to extract business data

    • Led the documentation and creative design efforts

    • Data warehouse Lifecycle

    • Data Modeling

    • Data Ingestion

    • Data Cleaning

    • Data Visualization

    • Data Integration

    • Data Analysis

    • Business Analysis

    • Business Intelligence

    • Data Lake Architecture

Business process optimization for University Administration System

    • Large universities such as Texas A&M have an international student population of over 10K+; maintaining the student records and immigration history of international students is handled by the International Scholar & Student Services (ISSS) at Texas A&M

    • The business process currently being used at the ISSS is a queue-based model which follows a serial process with about 10% of applications being reworked due to changes in the student/applicant needs and some rework occurring due to correction of errors in processing

    • To reduce the impact of time taken to process numerous student records, a single queue system combined with batched applications and a dedicated pull-based process design was devised

    • The current business process involves multiple queues that are not meeting the desired throughput during peak processing times

    • Additionally, the waiting time for international students should be reduced during peak months, and the duration of applications in the process queue for each advisor should also be minimized

    • STEP 1: Conducted a study to map the user needs for the administrative office as well as the student users to capture user research inputs

    • STEP 2: Defined a single process which was causing the bulk of applications during peak processing times as it was a primary application common to all students

    • STEP 3: Identified the user journey and mapped the timeline for each stage of the journey to capture process metrics such as number of users, time taken per application, number of days to receive initial response, etc.

    • STEP 4: Designed a process flow to gather insights on current business process and simulated the process using ExtendSim (a simulation tool)

    • STEP 5: Analyzed the current process through queuing model and process design parameters such as queue length, arrival rate, departure rate, average waiting time and average processing time in ExtendSim

    • STEP 6: Orchestrated and created an implementation plan to refine the process parameters and provide a proposed solution based on comparison metrics for current and improved processes

    • Designed a single queue-based system to handle peak demands for the new application process

    • Proposed a batching system to reduce backlog in processing queues with a reduction of 7 mins per application batch of 5 document processes

    • Team Project

    • Led the project team management

    • Pitched the idea for the project

    • Liaised the project team with the administrative office

    • Led the documentation and creative design efforts

    • Assessed the administrative business processes using key operations characteristics and performance metrics; e.g., efficiency, waiting time, cost,etc.

    • Improved business performance by designing efficient and effective processes