SUMMARY

• Over all 13+ years of IT experience mainly in software analysis, design, development, application maintenance, team handling and Project management.
• Currently working as Application Programmer (Sr Confidential Developer) with Diversant for Confidential .
• Prior to that working as a Technology Lead (PLSQL) with Infosys Limited for Ralph Lauren Confidential, New York. ed as Most Valuable Player’2016 CROWN for Technology Lead level at Infosys.
• ‘Best of Confidential (BRAVO)’ for 2 consecutive years (2011 and 2012).
• Expertise in Retail technical and functional domain.
• Expertise in Project Management Skills like Resourcing, team handling, handling CMMi Audit process, project task creation, Business Continuity Management Plan and DP analysis etc.
• Extensive experience in Application Development using Confidential tools (SQL, PL\SQL, Forms 6i, Reports 6i and Confidential APPS).
• Excellent expertise in Interacting with clients to elicit architectural and non - functional requirements like performance, scalability, reliability, availability, maintainability.
• Sound Technical knowledge in developing PL\SQL, Forms and Reports, Confidential APPS.
• Excellent leadership qualities, positive attitude, adhere to strict deadlines, flexible personality.
• Strong communication, interpersonal, learning and organizing skills matched with the ability to manage stress time and people effectively.
• Design applications based on identified architecture and support implementation of design by resolving complex technical issues faced by the IT project team during development, deployment and support.

TECHNICAL SKILLS

Confidential Tools: SQL*PLUS, TOAD,SQL Developer

Front End Tools: Confidential Developer (Forms & Reports), Confidential Apps 11i, HUE, AutoSys, Confluent Kafka

Languages: HIVE, Cassandra, SQL, PL/SQL

Database: Confidential 9i, 10g, 11g, SQL Server

Project Management Tools: IPM+ Tool (Infosys Project Management Tool)

Other Tools: Service NOW, JIRA, Issue Trak, SOXHUB

PROFESSIONAL EXPERIENCE

Confidential, Delaware, USA

Environment: HIVE, Cassandra, Confidential PL/SQL 11g/12C

Sr. Confidential PLSQL Developer

Responsibilities:

• Writing complex PLSQL programs for machine learning model.
• Involved with Line of Business for requirement gathering.
• Providing database programming support (writing complex HQL queries) to Machine Learning QA team for SIT.
• Involved in Bug fixing, Peer testing activities and preparing unit test scenarios.
• Developing complex HQLs scripts for Fraud detection application.

Environment: Confidential PL/SQL 11g, SQL Server

Confidential

Responsibilities:

• Leading the team for PMC Application Production Support (L2)
• Proof of concept (POC) development to validate proposed solution and reduce technical risk. Issue triage, analysis and resolution
• Involved in Production code deployment activities
• Problem management for recurring issues
• Involved in EY audit for critical Database servers and its data.
• Coordinating the work of support team and monitoring their performance; following up any outstanding open test risks / issues.
• Conducting root cause analysis of the showstopper defects.
• Working towards automating the manual job efforts.
• Interact with clients to elicit architectural and non-functional requirements like performance, scalability, reliability, availability, maintainability. Reviewing project deliverables to ensure high quality output
• Stakeholder management and Client interfacing activities
• Implementing project quality processes to drive higher productivity and efficiency

Environment: Confidential PL/SQL 11g

PLSQL Technology Lead

Responsibilities:

• Involved in BDM Re-Engineering Process.(Identifying and understanding the upstream and downstream systems - both Business and Technical)
• Developed Technical Design/Functional Design document.
• Leading the team for BDM Production Support.

Environment: Confidential PL/SQL 11g, UNIX, RMS 9 Functional

Confidential

PLSQL Technology Lead

Responsibilities:

• Developed multiple Batch Jobs using advanced concepts of PLSQL for loading and extracting data with multiple validations.
• Involved in Code Review, Test Results review and mentoring the team.
• Involved in preparing Technical Design document.

Confidential

Environment: Confidential PL/SQL 11g, APEX

Confidential Technical Lead

Responsibilities:

• Involved in Bug fixing, Peer testing activities and preparing unit test case for that bug.
• Involved in streamlining the coding standards and to improve the quality of the deliverables in uRenew.
• Developed multiple complex interfaces using advanced concepts of PLSQL for loading data from interface tables to Base tables.

Confidential

Environment: Confidential PL/SQL

Confidential

Responsibilities:

• Managing delivery in liaison with Analysts, Client Lead Developers, Offshore developers
• I am involved in full software development cycle including resource planning, requirements analysis, Initial estimation for each task and acceptance testing.
• Providing Functional Support & Handling developers queries/doubts.
• Reviewing estimate, test plans and the code delivered by the developers.

Confidential

Environment: Confidential Applications 11.5.10, Confidential 10g, PL/SQL, SQL*Loader, TOAD

PLSQL Offshore Team Lead

Responsibilities:

• I will be designing technical solutions to the functional requirements in the areas of Confidential Applications SCM modules custom developments.
• In general, I will be responsible in quality of all our deliverables in involving code reviews, system testing and UAT to analyze the adequacy and applicability of the system output
• As a part of the role I will be responsible for client expectations, deliverables, and production support to ensure smooth interactions between onshore and offshore team members.

Confidential

Environment: Confidential PL/SQL, Confidential 10g Forms & Reports

Sr. PLSQL Developer

Responsibilities:

• Maintenance of existing forms, reports, batch jobs, procedures, functions and stand-alone codes according to the changing business logics and functional requirements.
• Working closely with customers in understanding the requirements

Environment: Confidential PL/SQL, Report-6i, Confidential 8i

Sr. PLSQL Developer

Responsibilities:

• Developed EOB (Explanation of Benefits ) Report.
• Developed EOP (Explanation of Payments ) Report.

Confidential

Environment: MediaWiki, Confidential 8i

Team Member (PLSQL Developer)

Responsibilities:

• Involved on design and analyzing the database.

Confidential

Environment: Report-6i, Confidential 8i

Team Member (PLSQL Developer)

Responsibilities:

• Developed new reports like
• Monthly WWHO broker detailed quotes and sales .
• Monthly WWHO broker regional sales report .
• Monthly WWHO regional broked migrated sales .

Confidential

Environment: Crystal Report, Report-6i

Team Member

Responsibilities:

• Giving support to the team regarding Confidential coding and concepts of Confidential reports (6i).

Confidential

Environment: Confidential Developer 2000(Forms 9i, Reports 9i) and Confidential 9i

Developer

Responsibilities:

• Involved on design and analyzing the database.
• Coding to various forms using PL/SQL Editor in Form Builder.
• Worked in various modules related to Customer Mgmt, Sales and Stock Mgmt.
• Involved in the development of various forms like Raw Material Form, Customer Master, Sales Master, Item Master, Inventory Details Form and Receipt Form.
• Developed new reports like
• List of Suppliers and their details.
• List of supplier raw material wise.
• Types of new material.