Manikanta Kedarisetti

To seek and maintain full-time position that offers professional challenges utilizing interpersonal skills, excellent time management and problem-solving skills.

• Microsoft Azure Fundamentals
• Microsoft Azure Data Fundamentals

• 1, Data Science Accelerator, Azure, ADLS, Data Bricks, SAS EG, SAS Macro, System Analyst, Central Provident Fund is a statutory board which is responsible for investing contributions. Understanding and managing cost and quality issues in their organization. Processed large amounts of data from CPF and other external agencies through a complex grouping and data manipulation process., Data Analytics, Statistical report generations using the data from Data stores and Data Warehouse, System analysis and Design., Technology transformation: Extract data from Mainframe files and Teradata, process and ingest to ADLS. To automate the process to ensure smooth transformation of data from traditional sources to cloud. Processing of files includes, listing, downloading and decrypting and finally ingestion., Run powerful queries/Pyspark programs to process huge data from azure databricks and generate the data as per user requirements., Extraction and analysis of the data from various data stores and Data warehouse which includes text files, CSV files, Mainframe CART files, disk files and Teradata., Analysis, Estimation, Design, Development, testing and Implementation for various data requests from internal user teams and external agencies., To work closely with BA for requirement gathering., Extensive preparation of documentation for each request which includes Impact assessment report, Data Requirement specification, Visio Run charts, Operating schedule, Report and File Layouts, Unit test records, System test Records, Pre and Post implementation documents etc., To generate monthly, annually, Half yearly and adhoc Statical report using SAS to share with the stake holders for better understanding of the business., To develop and to perform unit testing, SIT, UAT and finally to deploy the code in production., To prepare actual cost charge for external agencies after the successful delivery of reports or datasets., Supporting adhoc requests to generate various SAS reports., Investigation of productions issues by running investigation jobs and business analysis., Encryption/decryption of data in the files to be sent to external agencies., Data manipulation by merging, appending and sorting datasets., Extensive use of PROC SQL to create subsets of data for further analysis., Optimization of SAS code using Macros
• 2, Resident Database Application, SAS, SAS Enterprise Guide, Teradata, JCL, Mainframe, DB2, Application Programmer, Housing Development Board is a Singapore Government Client. This will provide the wide range of e services to the Singaporean Citizens to sell or Buy the HDB Flats. Also, it will store all the necessary information which includes all the Lessee's and the information will be secured. All the HDB customers will have their own Id to log in and amend the details using sing pass and can be done the payments via sing pass account, Accountable for designing, coding, development, testing, documentation and debugging of applications to fulfil the requirements of one or more user areas, To Generate multiple residential reposts using SAS which includes various summary and statistical reports on resident's data and to automate all periodical reports using mainframe batch, Have upgraded a new reliable centralized security system to online mainframe application, Performing a key role in transforming some of mainframe applications to java applications which includes handing over a pseudo code with complete analysis, preparation of test cases which make sure to verify the correctness of transformed application., Cutover vsam to replace with DB2 in mainframe batch, Have developed modules from scratch which includes COBOL, DB2, CICS, SAS, JCL, To prepare and run adhoc jobs to correct production data and to load user data into db2
• 3, Global Account and Management Application (GAM & ASM), Northern Trust Bank, USA, SAS, COBOL, CICS, DB2, VSAM, JCL, Associate, Global account management is a core banking and financial services application which is extensively used by over five thousand bank employees with huge number of services., Developed modules from scratch to implement account creation and account management functionalities which includes COBOL, DB2, CICS, JCL, VSAM, Enhanced modules to implement the new functionalities proposed by client and as well as team, Prepared multiple application design documents from functional specification documents, Prepared multiple component design documents to code modules, Debugging tool used was XPEDITOR, Prepared test cases to test each functionality, Prepared test JCL’s and input data using file-aid, Performed Unit testing, integration testing, volume testing and user acceptance testing, Raised change management requests to deploy the code, Prepared SOE’s for implementations, Performed lead role during implementations
• 4, Formation of Williams & Glynn bank, Royal Bank of Scotland (RBS), UK, COBOL, CICS, DB2, VSAM, JCL, Senior System Engineer, The project is to divest millions of customers from existing RBS bank to form a new bank Williams & Glynn with more new functionalities, Extensively worked in payment portfolio, Prepared multiple application design documents from functional specification documents, Prepared multiple component design documents to code modules, Developed modules from scratch which includes COBOL, DB2, CICS, JCL, VSAM, Debugging tool used was XPEDITOR, Prepared test cases to test each functionality, Prepared test JCL’s and input data using file-aid, Performed Unit testing, integration testing, volume testing and user acceptance testing, Raised change management requests to deploy the code, Prepared SOE’s for implementations, Performed lead role during implementations
• 5, SEPA implementation for RBS Bank, Royal Bank of Scotland (RBS), UK, COBOL, CICS, DB2, VSAM, JCL, System Engineer, The Project is to implement SEPA functionalities for RBS bank. The single Euro payments area (SEPA) is a payment integration initiative of the European Union for simplification of bank transfers denominated in Euro., Prepared multiple component design documents to code modules, Developed modules from scratch which includes COBOL, DB2, CICS, JCL, VSAM, Enhanced many modules to amend SEPA functionalities, Prepared test cases to test each functionality, Prepared test JCL’s and input data using file-aid, Performed Unit testing, integration testing, volume testing and user acceptance testing, Raised change management requests to deploy the code

• Citizenship: INDIAN
• Date of Birth: 06/12/1990
• Gender: M
• Marital Status: Married