
Venkata Siva Prasad Lanka
- Hadoop Developer
- Phoenix, AZ
- Member Since Feb 13, 2023
Venkata Siva Prasad Lanka
Objective
Seeking a responsible and challenging career which will best utilize my knowledge and enhance my professional growth.
q 7.5 years of industry experience in areas ranging from Software Development and Support Activities.
q Knowledge in Insurance, Banking ,Retailing domain and Data ware housing.
q Conversant with Hadoop,Spark ,Pyton,SQL ,PL/SQL, Unix Shell Scripting,Teradata,Mainframes (COBOL, JCL), RDBMS, Progress 4GL on Windows platform.
q Exposure to Software Development Life Cycle(Dev-OPS,Agility & Waterfall Model), Application Management and Support activities and processes.
q Clear understanding of process and methodology followed by global banking and insurance companies.
· Working as Senior Programmer in TCS Limited, an Information Technology Services, Consulting and Outsourcing Company, Phoenix, Arizona. (Mar'17 -Till Date)
· Working as IT Analyst in TCS Limited, an Information Technology Services, Consulting and Outsourcing Company, Hyderabad. (Mar'14 -Feb’17)
· Worked as Senior System Engineer in Infosys Limited, an Information Technology Services, Consulting and Outsourcing Company, Hyderabad. (Nov'09 - Feb'14)
Skill Set:
ERP Tools : TOAD, Harvest CM, Tech Excel ,HP Application Lifecyle Management ,WINSCP ,Control M Scheduler ,SPUFI,File Aid ,Proanalzer, ProDebugger,ProBuddy,Endeavour,JIRA,BMCRemedy,WINSCP,GITHUB,Jenkins,Service Now
Languages : SQL *, UNIX (Shell Scripting), Mainframes (COBOL, JCL), PL/SQL,
Progress 4GL (Open-Edge 10.C with CHUI/GUI, App-Builder Usage, Roundtable Configuration),Teradata,Sybase(basics), Service-Now, Rally.
Databases : Oracle 10g, DB2 9.0, Progress DB 10.1C,HIVE, HDFS
Operating Systems : MS DOS, Windows, UNIX
Automation : Developed a Unix Script to Identify Untranslatable Characters in Source file while converting form EBCDIC to ASCII Format.
Developed a Unix Script to generate a report on daily basis to know the execution of various production jobs.
Project : CR 2020 – ODL Platform (Organized Data Layer)
Role : Technology Lead
Type : Development
Location : Phoenix,Arizona
Team size : 6
Client : American Express
TCS Works with American Express in building its ODL (Organized Data Layer) capability which would consolidate the data from different sources together and then create the Basic & Derived Layer which would be used by Risk Models, Scanners and Analytical Operations.
Role and Responsibilities:
Ø Specification Analysis:
- Involved in analyzing the business specification documents to understand the client data from source database to load into the corresponding Hive Tables.
Ø Design & Enhancement of Custom code module: maintenance & reports based on the customer’s requirements.
- Involved in the preparation of High Level and Design Level Documents based on the
Client requirements during enhancements from Business Requirement Specification
Document.
- Development of custom code modules as per the client business requirement and
Delivered the sample results to the client for their understanding.
- Involved in preparing the PDU (Production Data Usage) Data for performing SIT
phase of testing
Ø Unit and manual testing of customized maintenance code modules.
- Prepared the test cases for the performing Unit Testing from the Business Specification Documents.
- Involved in performing the Unit Testing and Integration Testing for the custom code modules.
Ø Team Coordination and Support Activities.
- Played an active role by maintaining good coordination among the team members and scheduled the team & status meetings on regular basis to share the status to Onsite as well as Offshore team through SCRUM Meetings.
- Flexible in extending my working hours to support the team as and when required.
Project : Amex -GCA (GLOBAL COLLECTIONS AND ACCOUNTS)
Role : IT Analyst
Type : Development
Location : Hyderabad
Team size : 3
Client : American Express
TCS Works with American Express in building the its Warehouse to its store its financial data along with history in its base tables. It is a migration project to migrate historic data from SYBASE to Teradata and also to load the ongoing data into the TERADATA database from various source systems by performing all business validations .The load data would be used by the business analysts for their business growth and introducing new products in AMERCIAN EXPRESS.
Role and Responsibilities:
Ø Specification Analysis:
- Involved in analyzing the business specification documents to extract the client data from source database to load into the corresponding target database.
Ø Design & Enhancement of Custom code module: maintenance & reports based on the customer’s requirements.
- Involved in the preparation of High Level and Design Level Documents based on the
Client requirements during enhancements from Business Requirement Specification
Document.
- Development of custom code modules as per the client business requirement and
delivered the sample results to the client for their understanding.
- Involved in preparing the PDU Data for performing SIT phase of testing
Ø Unit and manual testing of customized maintenance code modules.
- Prepared the test cases for the performing Unit Testing from the Business Specification Documents.
- Involved in performing the Unit Testing and Integration Testing for the custom code modules.
Ø Team Coordination and Support Activities.
- Played a active role by maintaining good coordination among the team members and scheduled the team & status meetings on regular basis to share the status to Onsite as well as Offshore team.
- Flexible in extending my working hours to support the team as and when required.
Project : NAB – Data warehousing (Common Modeling Data Platform)
Role : Senior Software Engineer
Type : Development
Location : Hyderabad (Off-shore)
Team size : 5
Client : National Australia Bank
Infosys works with NAB in developing new banking products and also supports in Data warehousing and application maintenance. The team develops code modules to migrate the historic data from existing IAP system to Flexi Platform by performing all necessary validations and transformations to the historic data present in various source systems.
Role and Responsibilities:
Ø Specification Analysis:
- Involved in analyzing the business specification documents to extract the client data from source database to load into the corresponding target database.
Ø Design & Enhancement of Custom code module: maintenance & reports based on the customer’s requirements.
- Involved in the preparation of High Level and Design Level Documents based on the
Client requirements during enhancements from Business Requirement Specification
Document.
- Development of custom code modules as per the client business requirement and
delivered the sample results to the client for their understanding.
- Involved in preparing the PDU Data for performing SIT phase of testing
Ø Unit and manual testing of customized maintenance code modules.
- Prepared the test cases for the performing Unit Testing from the Business Specification Documents.
- Involved in performing the Unit Testing and Integration Testing for the custom code modules.
Ø Team Coordination and Support Activities.
- Played a active role by maintaining good coordination among the team members and scheduled the team & status meetings on regular basis to share the status to Onsite as well as Offshore team.
- Flexible in extending my working hours to support the team as and when required.
Project : TIAA-CREF – ID3 INForce Conversion
Role : Software Engineer
Type : Development
Location : Hyderabad (Off-shore)
Team size : 6
Client : TIAA-CREF
Implementation of TIAA-CREEF Whole life , Endowments, Term and Decreasing Term Products on McCamish Platform. The project covered up gradation of platform, retrofitting the customizations, implementation of custom functionalities and conversation of policy information
from TIAA-CREFF ID3 system to VPAS® .
Role and Responsibilities:
Ø Product Set up:
- Involved in doing the product set up for various insurance products like (Whole life, Term, Decreasing Term Products, Annuities etc) in VPAS® and issuing policies with various coverage’s using the VPAS® Application.
Ø Design & Development of maintenance & reports based on the customer’s requirements.
-Using Progress Open-edge 10.1c, developed various reports based on the Financial Transactions between the customer and the Client.
-Involved in Roundtable Configuration for the checking In the developed Files of client
Specific.
Ø Unit and manual testing of customized maintenance & report programs.
- Tested the Developed code using the progress Open-edge 10.cVersion Tools like Pro-Analyzer andPro-Buddy.
- Prepared the test cases for the performing Unit Testing from the Business Specification Documents.
Ø Bug Fixing in custom codes.
- Involved in the enhancement of custom code modules as the per the client business requirement and delivered the sample results to the client for their understanding.
Ø Application Development (UI Designing using App- Builder).
- Designed the various Applications, screens and windows using progress Open-edge 10.1c App-Builder.
Ø Tools Development.
- Developed Tools for the client for minimizing the support required from BPO Team like generating the individual reports like for how many customers have pay the pending premium, sending letters relating to their pending and lapse transactions with the client.
Skill Set:
Languages : COBOL
Databases : DB2
Operating Systems : Windows
Project : APL Logistics.
Role : Software Engineer
Type : Support
Location : Chennai-Mcity (Off-shore)
Team size : 4
Client : APL Logistics.
APL is the logistics arm of Singapore-based marine transportation giant Neptune Orient Lines(NOL). Infosys works with APL to support their operation in warehouses which are present all over the world. The support team working 24X7 will resolve the real time issues faced by the users while performing the warehouse operations. The support team also take care of the bug fixes, maintenance and enhancements to the existing code modules by following all the cycles of SDLC while starting from requirement gathering to the deployment. The team has to work by coordinating with other teams based out of various locations.
Role and Responsibilities:
Ø Supporting the team for bug fixing
Ø Bug Fixing in custom codes.
Skill Set:
Languages : COBOL,CICS,JCL
Databases : DB2
Operating Systems : Windows
Project : Online Banking System.
Role : Software Engineer
Type : Trainee
Location : Mysore
Team size : 4
Client : Infosys® (Internal)
Online Banking System(Internal Project):
This is a maintenance project during the post phase of training. This involves various module as some of them deals with batch process also. Among them , my module deals with login and transaction updation. When the user the enters the password wrongly for three times it should be blocked and status should be updated in the database.
In transaction module the credit card has to be valid and if it not valid appropriate error messages as be displayed and if not transaction has to be updated after the transaction completes.
Role and Responsibilities:
Ø Supporting the team for bug fixing
Ø Bug Fixing in custom codes.
Technology:
· Infosys Certified Mainframes 101-Internal
· Infosys Certified Mainframes 201-Internal
· Infosys Certified Oracle 101 - Internal
· Infosys Certified OPEN SYSTEM 101-C
· HDE 100 Apache Hadoop Essentials
· DA 440 – Apache Hive Essentials.
· Dev 301 Developing Hadoop Applications.
Domain:
· Introduction to Retailing.
· Introduction to Software Development Process.
· LOMA 280.
Ø B.Tech from Pydah College of Engineering & Technology, JNTU-Kakinada during the years 2005-2009 with 81.68 %.
Ø Higher Secondary from Dr.V.S.K.Govt Jr College during the years 2003-2005 with 95%.
Ø SSC from State Board in 2003 with 85%.
Ø Patience, Self confident and hard working
Ø Dealing with things effectively even under pressure
Ø Flexible in extending my work hours when required
Ø Taking additional responsibilities when required
Ø Flexible in working with multiple vendors for BAU purpose.
Ø
Date of Birth : 10-11-1986
Father’s Name : L.Gongalayya
Languages Known : English, Telugu and Hindi
Gender : Male
Marital Status : Single
Permanent Address : 44-5-40/1,Ganesh Nagar, Thatichetlapalem, Visakhapatnam -
530016.
(L.V.Siva Prasad)