EXPERIENCE SUMMARY:

• I possess over 10 Years of experience using Oracle PLSQL development, Database designing as a core development area, Performance Tuning, with working experience in MS SQL, T - SQL, JAVA, JSP and .Net Framework, HTML, CSS, Reporting Tools like Ireport or Jaspersoft Report technologies to create, implement and configuration in large scale software applications and application support as well Application Testing (Unit Testing, SIT, White/ Black box testing).
• I have over 4 years of experience in Service Oriented Customer Facing Support Project with multiple technologies.
• During this tenure I have been in various roles like Developer, Analyst, Team Lead, Scrum Master, Techno functional, Datastage Consultant, Application Support Consultant, and Service Delivery Coordinator. With exposure to various industry segments like Lending Solutions (Loan Origination System, Loan Management System, Exposure Management System), Banking and Finance, Telecommunications, Insurance, Construction Management System and Hospital Management System.
• Self motivated, flexible, results - driven, customer-focused, articulate and analytical skills who can think out of the box .
• Having strong written and verbal communications skills, strong design and integration problem-solving skills and ability to provide competitive solutions.
• I have established a long-standing reputation as an effective and valuable employee with flexibility.
• With a record of success behind me, I am confident that I will be an asset to you as well.

TECHNOLOGIES:

Databases/ Backend: Oracle SQL, Oracle PL/SQL, MS SQL, MYSQL, T-SQL

Front End Technologies: .NET Framework(ASP.NET), C#, Java, Java Script, JSP, AngularJS, jQuery, HTML, CSS,REST, Node.js,

Tools and Utilities: PL SQL Developer, SQL Developer, Toad, Eclipse, Microsoft Office (WORD, EXCEL, POWER POINT, Visio), Visual Studio,

Reporting Tools: I-Report (Jasper Reports), Crystal Report,

Bug Tracking Tools: Mantis, Bugzilla, HPQC,

Project Management Tool: Microsoft Project,

Repository Maintenance Tools: Tortoise SVN, Rational Clear Case, Maven, Sub Version

Front End Frameworks: BRMS, WEO(Web Enabled Objects),

BI Tools/ Dashboard Technologies: Tableau 10, OBIEE 11g , ODI

PROFESSIONAL EXPERIENCE:

Confidential

Senior System Analyst/ consultant

Responsibilities:

• Managing L2 and L3 Support
• Stakeholder Management, Consulting, Customer Facing
• Software Implementation and Configuration
• Gathering system requirement,
• Prepared requirement specifications,
• User documentation,
• Formulate Technical Specifications,
• Impact analysis document.
• Ticket Analysis,
• Classification,
• Prioritization,
• SLA Tracking as per agreed TAT
• Delivering it on time.
• Data Warehousing
• Prepared staging data for Data Warehousing.
• Prepared Business Audit Reports/ Data
• AMC Support
• Solutions Review, testing and support.
• Development/ Review
• Oracle PL/SQL, SQL, Java, JSP, HTML, CSS, Writing queries, stored procedures, functions, packages and triggers, front end changes, Query tuning, Jasper Report (I-Report), BRMS
• SVN management and Release management
• Resource Management/ Reporting to Client:
• Monthly Ticket Analysis reports to client and respective stakeholder
• Reviewing Resource utilization sheet
• Business Requirement
• Discussion with client and business users
• Technical requirement, Business Requirement, feasibility and approaches.
• Internal Project Audit
• Preparing Reports, Documents and updates for monthly Internal audit
• Testing:
• Test case preparation
• Unit Testing
• Regression Testing
• Black Box Testing
• White Box Testing
• Integration Testing
• Enhanced in IRE and Processing Fee module
• New design
• User can add and modify fees dynamically.
• Ease to manage and understand
• Saved cost for maintenance upto 90%
• Testing Utility:
• Created backend Utilities and scripts
• Allows Unit testing and Regression testing of the enhancement or issues with multiple scenarios and impact.
• Effectively saved Testing efforts and Time
• Utility Created to test Amortization engine
• Created Bulk Amortization upload and verification utility.
• Prepared demo Dashboard using Tableau.
• Created Pre-EOD check utility which executed for Data Analysis of the System.

Confidential

Senior Technical Associate/ Consultant

Responsibilities:

• Agile Scrum Master.
• Release Planning.
• Daily Scrum
• Issues analysis
• Status updates
• Publishing it to stakeholders
• Coordinating with ASG team and Development team on production issue resolutions.
• Performance Assessment
• Prepared Data for all the team members for their mid-term Performance Assessment.
• Created Excel to calculate productivity
• Stakeholder Management
• Testing Support.
• Gathering system requirement,
• Prepared requirement specifications,
• User documentation,
• Formulate Technical Specifications,
• Impact analysis document.
• Development/ Review
• Oracle PL/SQL, SQL, Java, JSP, HTML, CSS, Writing queries, stored procedures, functions, packages and triggers, front end changes, Query tuning
• Testing:
• Test case preparation
• Unit Testing
• Regression Testing
• Black Box Testing
• White Box Testing
• Integration Testing
• Developed a Release tracking System using ASP.net, C#. It significantly saved time while for managing updates for Development, Issue Testing, and its status.
• Prepared Excel document to measure productivity of team members based on pre-recorded data for their Performance assessment.
• Prepared excel tracking system to track issues raised on production and its status for preparing daily status report.

Confidential

PL/SQL developer, Java Developer

Responsibilities:

• Development/ Review
• Oracle PL/SQL, SQL, Java, JSP, HTML, CSS, Writing queries, stored procedures, functions, packages and triggers, front end changes, Query tuning
• Gathering system requirement,
• Prepared requirement specifications,
• User documentation,
• Formulate Technical Specifications,
• Impact analysis document.
• Testing:
• Test case preparation
• Unit Testing
• Regression Testing
• Black Box Testing
• White Box Testing
• Integration Testing
• Implementation and Support
• Data Analysis, Prepared data/ Reports for Business and data for auditing and Data Testing/ Sanity
• Stakeholder Management
• SVN management and Release management
• JOB Monitoring System:
• Provided GUI View to DBA Team for Jobs executing on Oracle Database Server.
• Saved time to check the individual Job through command line And get able to kill any executing job from front end itself. It reduced significant time while monitoring jobs executing in database.
• Performance Analysis Tool (Finance Team) module used to measure quantitative performance for finance team. Which has been used throughout the organization for all branches
• Migration Utility of Existing Excel Tracker to Oracle DB.

Confidential

Software Developer/ Consultant

Responsibilities:

• Stakeholder Management
• Discussion with stakeholders.
• Data Analysis, Prepared data/ Reports for Business and data for auditing and Data Testing/ Sanity
• Front End design in VB6.0.
• Oracle PL/SQL Developer.
• Software Implementation and Support
• Gathering system requirement,
• Prepared requirement specifications,
• User documentation,
• Formulate Technical Specifications,
• Impact analysis document.
• Testing:
• Test case preparation
• Unit Testing
• Regression Testing
• Black Box Testing
• White Box Testing
• Integration Testing