Mohit Mangal

Project 1: Warehouse Management System (WMS) for Staples

Staples is a leading retail chain offering a wide variety of office supplies, tech products, furniture, and services, with a significant presence in the US and other countries, operating both online and in physical stores.

Responsibilities:

• Worked closely with the client to understand their needs and requirements.
• Involved in Reverse Engineering from Python Panda Script to Snowflake, enhancing the efficiency and effectiveness of data management.
• Actively participated in the Migration from SQL to Snowflake as a Snowflake developer, ensuring seamless transition and minimal disruption to business operations.
• Utilized Atlassian Jira for task management, effectively tracking and managing project tasks.
• Implemented Agile Methodology for project management, ensuring timely delivery of project milestones.
• Leveraged Power BI for data visualization and mapping, providing insightful data analysis and reporting.

Project 2: Proof of Concept (POC) for Product Development

Conducted a Proof of Concept (POC) for future product development, providing valuable insights and direction for the project.

Responsibilities:

• Mentored junior developers to improve their coding skills and understanding of best practices, leading to increased overall code quality within the team.
• Gained hands-on experience with Oracle PL/SQL and stored procedures etc.
• Continuously refined project management methodologies within the team through iterative process improvements, achieving increased efficiency in project delivery timeframes.

Project: Vocalink Pay by Bank App (PbBa):

I played a pivotal role in the development and successful delivery of this innovative solution that integrates mobile banking into online shopping. This project revolutionized the consumer buying experience by providing a seamless and secure payment method directly from the user’s bank account, placing mobile banking at the forefront of online transactions. My responsibilities spanned across various aspects of the project, including providing technical leadership to teammates through coaching and mentorship, gaining hands-on experience with Oracle PL/SQL and stored procedures, and using agile methodology to plan and track projects using JIRA/ALM tool. I showcased proficiency with SVN and GIT for version control, actively participated in deployment activities using Bitbucket and Jenkins, and utilized SonarQube to analyze and improve code quality. I also configured Flyway to create databases and handle version migrations for specific project requirements.

Project: Scorecard Engine
A system designed to compute LTE RTB Scorecards. This innovative project involved selecting data from raw PM interface tables and inserting it into aggregate tables at hourly, daily, and weekly intervals. The Scorecard Engine, while primarily used for scorecard data, is a general-purpose SQL execution engine compatible with any JDBC 7 supported database, including Oracle, Vertica, Teradata, MS-SQL, and Postgres. My role encompassed a wide range of responsibilities, including daily job monitoring, attending operation and client calls, managing Itrack Tickets within given timelines, handling code changes and deployments, and participating in the migration from Vertica to Snowflake. I also managed and mentored team members, fostering a collaborative and productive work environment. My leadership skills were demonstrated through effective communication, problem-solving, technical expertise, and client management. This experience has equipped me with a diverse skill set and comprehensive understanding of project management in a technical environment.

Project: Avaya Enterprise Solution Development

I was instrumental in the development of a new store for the EMEA location. This project, related to Store Front, involved the flow of quote creation, promotion, adding to cart, and processing for users who might be sellers or distributors falling under Tier1 or Tier1N2. My responsibilities were multifaceted and included understanding business requirements for change, conducting impact analysis of functional changes required in existing systems, and interacting with clients on change-related matters. I was hands-on with PL/SQL’s various kinds of objects, developing the requirements, and testing them. I was available with the client during deployment and looked into defects in production. As a Tech Lead, I also led and mentored team members, fostering a collaborative and productive work environment.

Project: Team Formation and support to team technically:

During this period, I was not assigned to a specific project due to the organization’s focus on recruiting more relevant candidates. However, this time was productively utilized in several key areas. I was involved in a PoC with the team, providing technical support and sharing my expertise. This allowed me to contribute to the team’s learning and growth, and also helped in validating new ideas and solutions. Additionally, I served as a panelist in technical drives aimed at team formation. This role enabled me to leverage my technical knowledge and understanding of the team’s needs to help identify and onboard suitable candidates. This experience has further honed my technical and leadership skills, preparing me for future challenges in a dynamic work environment.

Project 1: DTI

I involved designing and developing solutions for receiving batch and near real-time data feeds from a variety of data sources. The goal was to provide real-time, low latency, high-quality transformed and integrated data to the data fabric layers of the enterprise. My responsibilities included understanding business requirements for change, conducting impact analysis of functional changes, developing new and modifying existing components, and handling unit test cases and testing. I was also involved in QC deployment, release coordination, and production implementation activities. As a leader, I guided my team through these processes, fostering a collaborative environment and ensuring successful project delivery.

Project2: K2view Migration

I played a significant role in migrating key Services APIs of the CCR Database to the k2view platform. This project involved transforming the CCR stored procedures into Web Services and Micro services, which were tightly integrated into the CDP platform of AT&T. The data was organized by the logical unit of the Business, with each Logical instance treated as a micro-database. The data was migrated from the Oracle database to a Distributed Database (Cassandra) using various parsers and scheduled jobs. My responsibilities included understanding business requirements for change, conducting impact analysis of functional changes, developing micro services and web services in the k2fabric studio tool, and deploying on the Cassandra server. I was also responsible for loading data into Cassandra, creating DB templates and Graphite to display responses, handling Unit Test Cases, comparator tool testing, xsd comparison, and looking into defects during QC deployment. As a Tech Lead, I led and mentored team members, fostering a collaborative and productive work environment.

Project: Dialler

As a key contributor to the Dialler project at Capita (Ventura), a UK-based BPO and product company, I worked on the development and support of Dialler and Aida products. The project involved providing services to Capita’s clients in the UK, SA, and other regions. I was introduced to a new tool, ‘Syntelate’, used for campaigns, which enables agents to call their customers and provide relevant customer details. My responsibilities included analyzing change control provided in Lotus Note, providing impact analysis, making changes to the code or creating scripts, and coding in SQL/PLSQL. I also provided changes to the DBA in the UK for execution on production. In addition to these responsibilities, I took on the role of grooming junior resources, sharing product knowledge, and cultivating a collaborative learning environment.

Project 1: E-Stores (Dec 2010 - Aug 2013):

In this supply chain management and business-to-business project, I worked on E-stores for order processing. My responsibilities included analyzing client’s requirements, implementing PLSQL blocks, procedures and functions, coding, testing, and application support.

Project 2: Kotak (Loan Origination System) (Aug 2013 - Sep 2013):

I worked on a web-based application used for loan origination. My role involved application enhancements and support activities, implementing the designing and development of PLSQL blocks, procedures and functions, and coding and testing.

Project 3: GE-Money Bank (Oct 2013 - Jan 2014):

In this project, I was involved in generating reports for GE’s various business lines. My responsibilities included analyzing given matrices sheets, understanding French terms related to the database, reporting to the reporting manager for related issues in the mapping sheet, coding in SQL, and preparing technical specifications.

Project 4: Tata Motor Finance (Collection) (Jan 2014 - Jul 2014):

As a System Analyst, I worked on a project for Tata Motor Finance, focusing on auto loan delinquent accounts. My role involved analyzing functional specifications, coding in SQL/PLSQL, developing CSV reports in Comq framework, and resolving PA issues.

Project: IRS (Integrated Reporting System)

I was involved in generating daily, weekly, and monthly regulatory reports for RBI reporting. The system was used to support end users from both Finance and Operation teams for regulatory purposes. My role was to provide satisfactory onsite support, make necessary modifications or changes in the system and reports, and develop new features as advised by the users. My responsibilities included writing stored procedures and SQL queries, updating and modifying old SQL queries based on user requests, and updating and modifying Crystal Reports as per user requirements. I also utilized PL/SQL code in addition to SQL for complex database operations, enhancing the functionality and efficiency of the system.