Manoj Kumar Kamisetty

Key Strengths:

Highly skilled and experienced Cloud Data Engineer and Mainframe to cloud migration specialist with a proven track record of effectively managing, maintaining, and optimizing AWS cloud systems. With excellent communication skills and a collaborative mindset, I excel in working closely with cross-functional teams to analyze requirements, design solutions, and implement changes effectively. Additionally, I stay updated on emerging technologies and industry trends to continuously enhance my skills and contribute to the ongoing success of project.

• Cloud Data Engineering: Expertise in building AWS cloud data pipelines with and exposure to Data Analytics in cloud.
• Cloud Migration: Successfully migrated on-premises mainframe applications to cloud platforms .
• Effective Communication: Skilled at bridging technical and business perspectives to achieve project goals.
• Problem-Solving: Analyze defects, performance issues, and system failures with precision.
• Adaptability: Stay updated on evolving technologies and methodologies.

• Certified Data Engineering Associate from AWS.
• Certification in ITIL V3 Foundation from EXIN.
• Certification in DB2 9 Fundamentals from IBM.
• Certified Scrum Master form SCRUM Alliance.
• German Language B1 certified from Goethe Institute, Hyderabad.
• Trained in AWS solution architect from DigtalLync Institute, Hyderabad.
• IBM Cloud Advocate self-training.

Project #1:

Client : BMW, Munich,Germany

Project Name : MIDA (Migration Vehicle Data ex Factory)

Duration : April 2020 –  till Date

Location : Hyderabad-Offshore

Role : Team lead

Technology : Rest API, DB2 stored procedures. AWS S3, Dynamodb, AWS Glue, AWS Lambda ,Python, Stepfunction, AWS Athena, Jenkins.

Project Description:

The MIDA project is an initiative to migrate and replace over 250 outdated interfaces. It will primarily replace the IGDOM and VDWH systems. MIDA collects vehicle data from various manufacturing plants and stores it centrally. This data, which is organized using the Vehicle Identification Number (VIN) or chassis number, is accessed by various external systems through APIs and Cloud datasets (AWS S3).

Roles & Responsibilities:

• Worked closely with business analysts and stakeholders to gather requirements and translate them into technical specifications.
• Collaborated with cross-functional teams to design and implement efficient data migration strategies during cloud migration projects.
• Analyzed legacy system source code and extracted business logic.
• Developed Data Pipe lines As similar to Legacy systems using out coe of analysis
• Transferred data from the legacy system to the cloud application.
• Collaborated with the migration team to implement the cloud solution.
• Communicated with customers to resolve technical queries and recommend AWS cloud solutions.
• Managed and supported AWS web services operations.
• Mentored junior developers.

Project #2:

Client : BMW, Munich,Germany

Project Name : IGDOM (Identifikation von Gestohlenen Fahrzeugen -Dokumentati- on von Montageobjekten)

Duration : April2020 – till date

Location : Hyderabad-Offshore

Role : team lead

Technology : PL1, DB2, IMSDC, JCL,MQ,REXX, IBM HTTP protocol enabler tool kit in Mainframe, Rest API, DB2 stored procedures. AWS S3, Dynamodb, Python,Stepfunction.

Project Description:

IG_DOM system receives vehicle information data from different manufacturing plants and maintains the data centrally. The IG_DOM database stores data of vehicles produced within the BMW Group (Cars and Motorcy-cles).

IG_DOM system is being used by different systems for the vehicle information documentation (Product Master Data, Order and Distribution Data, Warranty relevant Data). The data stored in DOM is dependent on the Vehicle Identification Number (VIN) or chassis number.

Roles & Responsibilities:

• Resolved complex technical issues and provided timely support to ensure uninterrupted business operations.
• Analyzed existing program flows based on interface system requirements.
• Documented necessary code changes (design updates) in Confluence.
• Prepared user stories for sprints in Jira.
• Refined user stories as needed.
• Ensured code quality through thorough testing.
• Developed code aligned with user stories.
• Created comprehensive test cases and documented results.

Project #3:

Client : Euroclear, Brussels,Belgium

Project Name : CSDR SD Hold and release

Duration : March2019 – April 2020

Location : Hyderabad-Offshore

Role : Team Lead

Technology : PL1, DB2, JCL, REXX,MQ, Python

Project Description:

As part of CSD’s regulation from ESMA(European Securities and Markets Authority) customers can HOLD or RELEASE their orders, These orders comes from various input channels to the settlement process. Make provision to this feature in all the related programs is the project scope.

Roles & Responsibilities:

• Implemented automation scripts using Python and REXX and other scripting languages to streamline routine tasks and improve operational efficiency.
• Prepared High-Level Design (HLD) and Low-Level Design (LLD) documents.
• Create technical specifications, Develop the code and test for business requirements, process improvements and bug fixes.
• Developed, tested, and maintained code for business requirements, process improvements, and bug fixes.
• Prepared comprehensive test cases and documented results.
• Analyzed and debugged defect situations using technical tools and product knowledge

Project #4:

Client : BMW, Munich,Germany

Project Name : AU (Anlaufnlaufunterstützung)

Duration : June2016 – March 2019

Location : Hyderabad-Offshore

Role : Senior team member

Technology : PL1, DB2, IMSDB, JCL, Python

Project Description:

AU System for the start-up support. Support of the parts control and follow-up for new product start-ups, variant start-ups, annual model measures / model reworking and facelift by using the series logic (as far as possible). Is addressed by AU without any additional terms; that is how the entire system is meant with all its components on all platforms

Roles & Responsibilities:

• Conducted analysis of AU programs to identify operational issues and address ad-hoc requests.
• Analyzed PTL reporting programs and provided solutions for user requests.
• Managed Change Management, Release, and Problem Management for project-related Change Requests (CRs).
• Resolved AU order-related issues and communicated with business users.

Project #5:

Client : BMW, Munich,Germany

Project Name : LTERM(Logistisches Terminierungssystem)

Duration : June2016 – March 2019

Location : Hyderabad-Offshore

Role : Senior team member

Technology : PL1, DB2, IMSDB, JCL, Python

Project Description:

LTERM is the system which is responsible for dating of part numbers in the plants i.e. what the run in date of the part number will be. The bill of material (parts list) reaches LTERM every day from the TAIS system (Master data) through change list popularly known as NRCL and stored in LTERM workbaskets called AVO. The change coordinator in the assembly plants in consultation with the people in the launch control records the effective date for the part number. To perform the dating tasks the LTERM user is provided with a number of tools. The dating information is then interfaced to all related systems like MSTAIS, SPAB.

Basically, LTERM takes care of two very important activities NRCL distribution and the logistical dating of parts list. Apart from these Lterm provides several other functionalities related to processing of orders like

Online demand calculation by securing the demand planning on basis of the current parts list available with intranet.

Roles & Responsibilities:

• Analyzed LTERM programs to address user request incidents promptly.
• Resolved NRCL distribution issues and optimized work basket processes for plant users.
• Supported online part calculation and TROJA applications, maintaining system reliability.
• Maintained a relevant knowledge base for application operations (Operations Manuals/Share Point).

Project #6:

Client : BMW, Munich, Germany

Project Name : BFFZ(Vehicle Inventory Management system)

Cluster : Finanzabwicklung

Duration : Sep2015 – June2016

Location : Hyderabad-Offshore

Role : Senior team member

Technology : COBOL , PL1, DB2,IMS, JCL,CICS,CIPS

Project Description:

The system BFFZ is the complete stock management for vehicles at BMW. This system tracks the Production data, stock data and invoice data centrally. It provides stock and invoice data to IVP and GUE confirmation to FW (Fakturensammler).

BFFZ receives the vehicle production data from EINSTEIN and COP on a daily basis and provides Manufacturing and Material costs to all STARD plants on a daily basis. Each and every vehicle in BFFZ gets the cost value from ZHK-DB and price value from TPDB.

Roles & Responsibilities:

• Analyzed BFFZ programs to extract user-required data efficiently.
• Provided effective solutions for ad-hoc requests, ensuring timely support.
• Managed job scheduling and monitored processes to adhere to SLA contracts.
• Ensured smooth execution of critical tasks within specified timeframes.

Client Description:

Danske Bank., Denmark

Headquartered in Copenhagen, it is the largest bank in Denmark and a major retail bank in the northern European region with over 5 million retail customers. Danske Bank was number 454 on the Fortune Global 500 list for 2011.

Project #7:

Client : Danske Bank, Denmark

Project Name : Group Finance System

Duration : March2013 – August 2015

Location : Bangalore-Offshore, Copenhegan -Onsite

Role : Team Member

Technology : COBOL, DB2, PL1,JCL,CICS,SAS

Mainframe SAS developer , Analysis and code changes, Application programming, Testing of code, JCL cards preparation, SAS Sql quries , Data Analysis,JOB scheduling. JOB Monitoring, Project supporting & Maintenance

Project Description:

DANSKE bank is a Denmark based Banking organization providing end to end banking solutions to the customers in Denmark, Norway, Sweden, Finland. The project GFS is primarily responsible for maintaining and development of Danske Bank group accounting systems. Like every other it-department GFS has a corresponding group of users in the Danske Bank Group. These users are in the case of GFS Group Accounts (Koncern Økonomi). This group has the overall responsibility of the quality and reporting of the balance, and are the ones who formally ”order” solutions and corrections at GFS.

Roles & Responsibilities:

• Collaborated with stakeholders to analyze change control requests and clarify requirements.
• Ensured a thorough understanding of business needs and technical specifications.
• Prepared High-Level Design (HLD) and Low-Level Design (LLD) documents for the GFS project.
• Broke down the project into manageable tasks and assigned them to the team, promoting efficient development.
• Understanding Danske Sampo Application, Interfaces and Business involved.
• Engaged in discussions with clients to identify enhancement opportunities and gather feedback.
• Managed Change Requests by overseeing change management, release planning, and problem resolution.

Client Description:

Liberty Mutual Insurance Co., U.S.A

Boston based Liberty Mutual Group offers a wide range of insurance products and services, including personal automobile, homeowners, workers compensation, commercial multiple peril, commercial automobile, general liability, global specialty, group disability, assumed reinsurance, fire and surety. Liberty International operations span a broad array of countries, offering diverse coverage's, ranging from personal automobile to satellite

insurance.

Project #8:

Client : Liberty Mutual Insurance Co., U.S.A

Project Name : OP-65 Finance and CBS.

Duration : January, 2011 – March2013

Location : Chennai-Offshore

Role : Team Member

Technology : PL1, IMS/DB, COBOL, DB2, JCL, CICS

Project Description:

The Operation-65 Finance systems are used to process personal line policies. Policy types include Automobile, Homeowners, Fire and General lines in the United States. The process involves Batch programs, which updates the master files for each division every night. The programs also generate certain entries such as interest, fees, and charge-off of interest, fees and premium.

OP65 Finance system generates the necessary bills and credit notices for collection of premium once the policy premium is posted. If the premium is not paid when due the system automatically generates a cancellation transaction and refers the policy to an attorney for the collection of outstanding premium.

Roles & Responsibilities:

• Analyzed Business Requirement Documents to extract key requirements and dependencies, preparing comprehensive Impact Analysis Documents to assess the scope and implications of proposed changes.
• Collaborated with stakeholders to ensure clarity and alignment of technical solutions with business objectives, facilitating informed decision-making and project planning.
• Prepared Technical Specification Documents detailing system architecture, design considerations, and implementation approaches, guiding development teams in coding and unit testing phases.
• Developed and tested code in accordance with technical specifications, ensuring compliance with quality standards and project requirements.
• Generated Quality Related Documents and Implementation & Change Plan Documents to ensure adherence to quality standards and smooth implementation of system changes.
• Managed holiday schedule activities, ensuring coverage and continuity of operations during holidays and peak periods.

Project #9:

Client : Liberty Mutual Insurance Co., U.S.A

Project Name : CBS

Duration : May, 2011 – December, 2011

Location : Chennai-Offshore

Role : Team Member

Technology : COBOL, DB2, JCL, CICS

Project Description:

Choice billing system is developed to access client’s billing in various methods. This system is used for both accounting as well as billing purposes. The CBS is divided into two categories Daily Support and Testing support. In testing, we mainly take care of running the billing cycles and maintaining different environments data. Also, providing ad-hoc support to client’s request

Roles & Responsibilities:

• Provided technical support during client testing phases, offering expertise and guidance to resolve issues and ensure successful outcomes.
• Offered daily technical support for ad-hoc requests from business users, demonstrating responsiveness and problem-solving skills to address critical issues promptly.
• Implemented best practices for code migration, including version control, documentation, and testing, to maintain system integrity and reliability.
• Managed the migration of production or development code changes to different environments.
• Managed and initiated test cycles for various periods (weekly, monthly, etc.), ensuring timely execution and coordination with stakeholders.

Project #10:

Client : Liberty Mutual Insurance Co., U.S.A

Project Name : PMPRU Archival

Duration : September,2010 – March2013

Location : Chennai-Offshore

Role : Team Member

Technology : COBOL, DB2, JCL, DFSORT,CICS

Project Description:

The objective of this project is to minimize the storage cost of the personal market claims in ACES purge database (DB2 tables). This can be achieved by archiving the purged claims to TAPE media and then deleting them permanently from TAPE.

And also it retrieves claims from tape (archive) When Users Requested their Information for single and bulk conversion requests, finally a report file containing the details of the deleted claims will be produced.

Roles & Responsibilities:

• Designed and prepared JCL PROCs for generating monthly reports, facilitating user requests and tracking deleted claims.
• Ensured accuracy and completeness of the generated reports, providing valuable insights to stakeholders for decision-making.
• Demonstrated proficiency in JCL scripting and procedural coding to automate report generation processes efficiently.
• Collaborated with storage and backup teams to optimize tape utilization and storage efficiency.
• Managed and maintained tape data sets, ensuring data integrity, availability, and compliance with organizational policies and procedures.

German :B1

Listening to Music, Exploring new places

• Best Team Lead Achala IT solutions
• Star Performer from Accenture