Harikrishna Alagampati
Developer
Chennai
Summary
Intend to build a career with leading corporate of hi-tech environment with committed and dedicated people, which will help me to explore myself fully and realize my potential. Willing to work as a key player in challenging & creative environment. Also, to understand the position of organization, role of myself and finishing the task within time...
Overall experience of 14.5 years. 12 years and 2 months of relevant Oracle PLSQL experience Proficient in Oracle PL/SQL Have 4.5 years of Onsite experience for the Westpac Bank project assignment in Perth, Australia. Having proficiency in Tools and Utilities like Toad, PL/SQL Developer, SQL Developer Experience in Oracle PL/SQL programming like Procedures, Packages, Functions, Triggers, Cursors, Bulk collect, External table, SQL loader, Views Expertise and involved in various project phases (i.e.) System study, Requirement gatherings analysis, design, development, testing, implementation and technical support Expertise in Unit testing ensuring defect free delivery Good Communication skills and Business analytical skills Good in preparing technical document and user manuals Quick learner and have ability to analyze to the core of the issue Documented High-level Design and low-level Design documents for projects and implemented most-efficient and accurate interface Designs Have good interpersonal skills and a smart worker
Overview
15
15
years of professional experience
2
2
Certifications
Work History
Technical Lead
Tata Consultancy Services
04.2011 - Current
- Automated Billing Logic Enhancement (ABLE) is a big invest project under which all the Property and Causality Commercial lines billing logics are re-defined for the billing process and Account level billing is been introduced along with TABS Onlines changes, a new front end looks developed on Oracle forms for the ease of customer representative access.
- Analysis of business requirements
- Preparation of Technical Design specification documents.
- Development of code based on the customer requirement
- Preparation of Unit test cases and Unit Testing and Supported testing team during System Testing and UAT phases
- Identifying the bad SQL, poorly coded PLSQL blocks and fine tuning the long running queries
- Extensively involved in Development, Testing, On Site-Offshore coordination
- The project requirement is to add the Risk state information to the payment confirmation emails that are generated on successful payments. Top five Risk states associated with the Account is to be passed and it should be displayed on front end web page. This is to more clarification to the insured about on Risk states where the insurance is being purchased.
- Analysis of business requirements and weekly status and walkthrough to held study discussions on requirements and progress
- Preparation of Impact Analysis and Design document.
- Development of code logics to include top five risk states to get included.
- Performing Unit testing and submitting results for Quality analysis.
- Performing system testing and Integration testing and submitting the results for quality review.
- Raising certain requests to get the code deployed in DEV, QA and PROD environments.
- Insureon is the name of the Insurance Agency in association with The Hartford and the project is about getting the payment information from Insureon and enrolling or unrolling the accounts Insureon Program. The accounts enrolled or unrolled under Insureon program will undergo certain validations and payment confirmation bills are generated accordingly.
- Preparation of Impact Analysis and Design document.
- Development of code based on the customer requirement.
- Performing Unit testing and submitting results for Quality analysis.
- Performing system testing and Integration testing and submitting the results for quality review.
- Raising certain requests to get the code deployed in DEV, QA and PROD environments.
- Direct client interaction at onshore, Perth (Australia) for work activities.
- Conducted many meetings for requirement gatherings
- Analysis of gathering new requirements
- Performing code logic based on the requirement provided by customer
- Performing unit testing
- Performing user acceptance testing done by customer
- Getting sign off from the customer
- Performing good interacting with customer as well as onsite coordinators (when at offshore)
- Updated daily status in Daily Status meeting with team
- Effectively involved in coordinating/communicating with Onsite/Offshore team for all issues/clarification then and there
- Received GEMS-WESTPAC AWARD for Year End Support
- On the Spot award for ABLE Project which was successfully delivered to the Clients
- On the Spot award and Star team award for INSUREON Project which was successfully delivered to the Clients
- Got Client level Appreciations for my projects during the tenure in THE HARTFORD and WESTPAC accounts
Education
Bachelor of Technology - Computer science and Engineering
CR Engineering College
Tirupati01.2010
Board of Intermediate Education - MPC
Ratnam Junior college
01.2006
Higher Secondary School - SSC
SKDR EM High School
01.2004
Skills
PLSQL
UNIX
PRO-IV
Oracle
Oracle 12c
Toad
undefinedCertification
1Z0-051: Oracle 11g SQL Fundamentals
Accomplishments
- Received GEMS-WESTPAC AWARD for Year End Support
- On the Spot award for ABLE Project which was successfully delivered to the Clients
- On the Spot award and Star team award for INSUREON Project which was successfully delivered to the Clients
- Got Client level Appreciations for my projects during the tenure in THE HARTFORD and WESTPAC accounts
- Attended session on Lean Six sigma
Personal Information
- Passport Number: U8442053
- ID Type: Passport
- ID Number: U8442053
- Nationality: Indian
- Marital Status: Married
Profile
10.5 years, 10 years and 2 months, 2.5 years, Oracle PL/SQL, Toad, PL/SQL Developer, SQL Developer, System study, Requirement gatherings analysis, Design, Development, Testing, Implementation, Technical support, Proactive, Self-motivated, Organized, Flexible, Excellent team player
Domain Certification
- INS21 Property and Liability Insurance
- INS22 Personal Insurance
- INS23 Commercial Insurance
- TCS Business Domain Academy: Certificate in Insurance Concepts
Toastmasters
Member of Toastmaster, CC1 to CC3, Toastmaster of the day (TMOD), General Evaluator, Table topics master, Grammarian, Ah-counter, Timer
Training Exposure
- PL Sql 12c
- Lean Six Sigma Concepts
- Introduction to Banking domain concepts
- Expertise in Insurance domain
- Attended Domain Focus Group Sessions
- Our Purpose, Vision, Bold Moves & Values
Personal data processing
I do hereby declare that the particulars of information and facts stated here in above are true, correct and complete to the best of my knowledge and belief.
Cricket
I would like to play cricket at free time and to watch it also.
Timeline
Technical Lead
Tata Consultancy Services
04.2011 - Current
Board of Intermediate Education - MPC
Ratnam Junior college
Higher Secondary School - SSC
SKDR EM High School
Bachelor of Technology - Computer science and Engineering
CR Engineering College