Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic
Kalyan Manda

Kalyan Manda

Technical Manager
Hyderabad

Summary

15 Years of experience in the information technology domain, specializing in Snowflake and PL/SQL development.
Experienced in Snowflake, Cosmos DB, DBT, and Azure Cloud for the past 3 Years.
Enhanced coding speed and accuracy by incorporating GitHub Copilot into the development process
Experienced in end-to-end ETL processes with a focus on master data mapping and SQL scripting. Contributed to successful data migration from legacy databases to Snowflake.
Extensive expertise in database design and modeling.
Designed and implemented automated processes to enhance application efficiency
Extensive experience in tuning and enhancing database efficiency
Designed, developed, and enhanced database procedures, functions, triggers, and packages using PL/SQL as part of application development
Have knowledge in UNIX and scheduling jobs.
Knowledge on python scripting (numpy , pandas)
Strong analytical skills, analyzed issues and provided root cause for issues.
Experience in all the phases of Software Development Life Cycle (SDLC)
Domain experience in Banking and finance , Retail, Telecom, Government, Healthcare, Market research

Overview

17
17
years of professional experience
5
5
Certifications

Work History

Technical Manager

State Street
12.2020 - Current
  • Continuously updated skills through training courses, workshops, and self-study—staying current on industry trends and emerging technologies.
  • Debugged complex software issues, leading to a more stable product release.
  • Collaborated with cross-functional teams to ensure seamless integration of new features.
  • Participated in regular code reviews, ensuring high-quality standards were consistently met across all development efforts.
  • Reduced development time by creating reusable code libraries for future projects.
  • Developed suggestions for technical process improvements to optimize resources.
  • Mentored junior staff members, fostering a supportive environment and promoting professional development.

Technical Lead

ValueLabs Solutions
10.2016 - 11.2021
  • Nielsen Data collection team gathers the statistics like Sales, Price, stocks from retail stores with the help of LHHT devices and sends the information (Collected data) to the Back office. Back office work as an interface between factory and the LHHT device, process the data received by LHHT device in the form of SQLite files and send the processed data to the factory in the format of .DATA files. Factory teams make use of the collected data and do the analysis and create the statistics and share the information to the clients who requested it.
  • Responsibilities:
  • New environment data setup. Master, transactional tables creation.
  • Country onboarding to the CDAR application
  • Using ETL’s worked on CIP factory data migration
  • Initiative taken to automate the regular ETL activities (history load)
  • Functional requirement gathering from the factory team on interfaces like SIRPAIR and the data formats.
  • Technical design documents prepared for various user stories like alphanumeric period and product codes
  • Developed procedures for upper and lower control limits for products using various algorithms and developed reports.
  • Developed procedures, functions for user reports
  • Involved in table redesign to improve the performance of reports and saved 30% of storage utilization when compared with earlier design.
  • Involved in performance improvement activities. Identified and tuned various performance bottlenecks from the application.
  • SQLLDR programs to load the data from external sources, expdp and impdp used for back up of the tables
  • Unit testing of components which I developed
  • Daily status update with scrum team
  • Technologies: Agile model, Oracle 11g, PL/SQL, Tibco BW, UNIX, Python

Sr. Developer

ValueLabs Solutions
04.2016 - 09.2016
  • Carewise Health helps organizations improve the personal health of employees and control healthcare costs. Carewise Health and wellness programs help members to build the skills they need to achieve and sustain optimum health. CWH system is a major repository for protected health information (PHI) as defined by the Health Insurance Portability & Accountability Act (HIPAA). Headquartered in Louisville, Ky., Carewise Health employs approximately 600 registered nurses, health coaches, clinicians, medical directors and other committed professionals. Personal Wellness, Health Advocacy, Disease Management, Case Management are Major Services provided
  • Responsibilities:
  • Developed Premera - Accountable Care Organization (ACO) reports, it is a scratch development.
  • Generated and reviewed the URAC, Premera Monthly and Quarterly reports. Performed internal data quality for the reports.
  • Worked on Value Transparency(VT) reports automation using SSRS and dynamic SQL
  • Created the document of understanding of URAC report
  • Provided the technical help to team members.
  • Fixed the issues raised in monthly reports by writing the new subroutines in VBA
  • Daily status update with scrum team
  • Technologies: Agile model, Oracle 10g, PL/SQL, T-SQL, Unix

Sr. Developer

ValueLabs Solutions
11.2015 - 03.2016
  • Carewise Health helps organizations improve the personal health of employees and control healthcare costs. Carewise Health and wellness programs help members to build the skills they need to achieve and sustain optimum health. CWH system is a major repository for protected health information (PHI) as defined by the Health Insurance Portability & Accountability Act (HIPAA). Headquartered in Louisville, Ky., Carewise Health employs approximately 600 registered nurses, health coaches, clinicians, medical directors and other committed professionals. Personal Wellness, Health Advocacy, Disease Management, Case Management are Major Services provided
  • Responsibilities:
  • Analyze requirements and plan the work. Analyzed the existing process of the SDSR system and prepared a document of understanding of the system.
  • Supported production issues such as CW to SDS load issues, EDW, Fulfillment.
  • Worked on enhancements like NL faxing
  • Enhancement works in EDW (Data warehouse).worked on EDW cleanup activities.
  • Provided the technical help to team members.
  • Daily status update with scrum team
  • Technologies: Agile model, Oracle 10g, PL/SQL, T-SQL

Team Lead

Tata Consultancy Services
11.2012 - 07.2015
  • The Crime and Criminal Tracking Network Systems (CCTNS) was conceptualized by the Ministry of Home Affairs (MHA) .CCTNS aims at creating a comprehensive and integrated system for enhancing the efficiency and effectiveness of policing at all levels and especially at the Police Station level. MHA decided to provide Core Application Software (CAS) to the states/UTs which will be customized by system integrators selected by those States/, but some of the States in the country who have already developed their own systems. Andhra Pradesh is one of those having a system called Electronic Computerization of Police Services (eCOPS) which is used extensively across the State at all the Police Stations. Similarly other states have their own applications to maintain the criminal records. These applications are required to be integrated to provide better services to the citizens and Police Department. Functionality of these applications need to be revised in order to meet the objectives, functionality and other requirements as defined under CCTNS project. AP Police has decided to enhance the capabilities of its applications and migrate into “Enterprise eCOPS”.
  • Responsibilities:
  • Requirement Gathering from clients. Communicated with domain SME’s.
  • Analyzed requirements and created database design as per the requirement. Created and reviewed the ER diagrams for EcCOPS database.
  • Supported the legacy applications.
  • Prepared procedures, functions and other PLSQL components for FIR, OMCR application modules in EcCOPS.
  • Involved in master data mapping and prepared ETL scripts from eCOPS to EeCOPS databases.
  • Lead Petition, Online Monthly Crime Review (OMCR) Modules as well as a team of 6 people.
  • Involved in Internal quality assurance activity (IQA), as part of this reviewed the design done by team members and ensured that there won’t be any major deviations in the requirement.
  • Groomed 4 freshers on SQL and PLSQL.
  • Conducted daily status meetings with the team.
  • Created the document of understanding data migration activity.
  • Provided the technical help to team members.
  • Technologies: Waterfall model, Oracle 11g, PL/SQL

Developer

Tata Consultancy Services
10.2009 - 11.2010
  • A Recurring Payment Gateway is responsible for managing the recurring payment processing for customers whose payment method is Continuous Payment Authority (Credit/Debit card payments). CPA enables payments to be taken on a recurring basis from credit/debit cards. Visa, Visa Debit, Master and Amex card is supported. This will enable the organization to collect the billed amount from the customer’s credit card in an automatic and scheduled manner. Thus the customer need not worry about paying bills within the due date every time. As a courtesy, the organization will be notifying the customer in advance every time prior to the collection of the amount. The rules to process these Credit card instructions will vary between the countries based on their policies. Credit card instruction in the UK can be obtained either by a signed mandate or can be obtained over the phone as long as the company follows the rules set out by the sponsoring bank.
  • Responsibilities:
  • Involved in design of technical specification document
  • Involved in Internal quality assurance activity as part of this reviewed the design done by rest of the team members and ensured that there won’t be any major deviations in the requirement.
  • Prepared procedures, functions as per the requirement.
  • Developed Unit test cases.
  • Provided the technical help to other teams.
  • Technologies: Waterfall model, Oracle 10g, SQL, PL/SQL

Developer

Tata Consultancy Services
03.2009 - 09.2009
  • This was one of the critical and highly estimated projects in the retail domain which dealt with replacing all legacy applications which are interfaced with CMS applications with SAP. The outcome of this project is to make the CMS application as SAP understandable.
  • Responsibilities:
  • Involved in the design of technical specification documents.
  • Involved in Internal quality assurance activity as part of this reviewed the design done by rest of the team members and ensured that there won’t be any major deviations in the requirement.
  • Involved in development of procedures and functions.
  • Developed Unit test cases.
  • Technologies: Waterfall model, Oracle 9i, SQL, PL/SQL

Developer

Tata Consultancy Services
05.2008 - 02.2009
  • The intention of this project is to globalize the purchase orders by enhancing the existing CMS (Contracts Management System) system to accommodate the International Purchase orders and construct new Interfaces between CMS to SAP and CMS to SAS applications.
  • Responsibilities:
  • Involved in Internal quality assurance activity as part of this reviewed the design done by rest of the team members and ensured that there won’t be any major deviations in the requirement.
  • Developed Unit test cases.
  • Involved in development of procedures and functions.
  • Provided the technical help to other teams.
  • Technologies: Waterfall model, Oracle 9i, SQL, PL/SQL

Education

Master of Technology (M.Tech) - Computer Science

Jawaharlal Nehru Technological University
Kakinada
10.2012

Bachelor of Technology (B.Tech) - Computer Science

Jawaharlal Nehru Technological University
Hyderabad
01.2007

Skills

PLSQL Programming

Data modeling

Snowflake

Azure

undefined

Certification

Snowpro core certification

Timeline

Technical Manager

State Street
12.2020 - Current

Technical Lead

ValueLabs Solutions
10.2016 - 11.2021

Sr. Developer

ValueLabs Solutions
04.2016 - 09.2016

Sr. Developer

ValueLabs Solutions
11.2015 - 03.2016

Team Lead

Tata Consultancy Services
11.2012 - 07.2015

Developer

Tata Consultancy Services
10.2009 - 11.2010

Developer

Tata Consultancy Services
03.2009 - 09.2009

Developer

Tata Consultancy Services
05.2008 - 02.2009

Master of Technology (M.Tech) - Computer Science

Jawaharlal Nehru Technological University

Bachelor of Technology (B.Tech) - Computer Science

Jawaharlal Nehru Technological University

Similar Profiles

CREATE PROFILE
Kalyan MandaTechnical Manager