SUMMARY:

• Versatile, high - energy technocrat with the distinction of executing prestigious Information Technology projects of large magnitude within strict time schedules
• Proven competency in suggesting appropriate as well as technology-based solutions for enhancing functional efficiency of the organization and achieving business excellence”
• A result-oriented professional with 13+ years of experience in Logistics, Banking & finance and insurance domain with Waterfall and Agile Development:
• Project Execution Application Development Implementation and Support
• Client Engagement Requirements Gathering and Analysis Technical Support
• Documentation Coding & Testing Team Management
• Currently working in Richmond VA USA .
• Extensive Client engagement and Customer facing experience with more than 7 years at onsite locations.
• Working experience with Confidential 2 Years at Memphis USA Location.
• Extensive experience as Oracle Applications Consultant and Technical Developer in Design, Development and Implementation of Oracle Applications.
• Created Inbound and outbound Interfaces to Store data into the staging table and base table.
• Experience to work on Worked on API/Interface enhancements and development.
• Overall 6 Years Profound working knowledge of Oracle 9i/10g/12c, SQL/PL-SQL, Oracle Forms/Reports and UNIX shell scripting.
• Well acquainted with Integration, System, and Functional, Input domain, Validation, User Interface, Compatibility, User Acceptance Testing, Regression and Re-Testing.
• Extensively developed SQL Performance Tuning/Query Optimization solutions.
• Experience in application development using various advanced features of Oracle like Collections, Bulk Collections, Table Functions, Autonomous Transactions, Object types and Records
• Strong Leadership quality, analytical and problem solving skills, excellent communication, presentation skills and a good team player.
• Expertise in handling the overall enterprise software application development life-cycle involving requirement analysis, system study, designing, testing, coding, de-bugging, project planning, maintenance & documentation.
• Extensive experience in Agile development methodologies and related artifacts like Scrum meetings, User stories, Sprint Planning, Product Backlog, Sprint Backlog, Product owner and scrum team management, Sprint burn down and Release burn up charts, Estimations and Team Velocity.
• Demonstrated abilities in implementing various systems according to business needs (as-is & to-be analysis) and reviewing process flow as per specifications.
• Distinction of:
• Identifying, conceptualizing and documenting appropriate technical solution approaches for various businesses scenarios and challenges
• Managing requirements gathering, collation of project functional and technical requirements; following-up with clients throughout the project lifecycle to ensure full understanding of needs and concerns
• Resourceful in liaising with global clientele with proven expertise in setting up new business practices/ processes
• Proven expertise in spearheading multiple projects from conceptualization & visualization to technology mapping and final execution of projects
• Innovative & creative professional with strong communication, analytical, interpersonal & negotiation skills

• Supervised the design and creation of functional specifications and test plans for use by the team
• Mapped requirements of clients as well as different Service Providers, Senior Management, Vendors / Consultants & other Stakeholders for ensuring effective translation of business needs into technology requirements in adherence with company’s objectives
• Provided various technical suggestions, solutions and troubleshooting assistance during development and deployment of ARS and SLC class application
• Interacted (onsite & offshore) with the client for requirement gathering; evaluated technical and commercial feasibility of solutions
• Implemented appropriate methodology to add value to the consultants’ deliverables; worked with consultants in identifying process improvements in deliverables; developed methods to achieve delivery of desired results; acted as the quality control point for consultant deliverables
• Delivered customized applications for AWACS processes that resulted in savings of up to 6 hours in effort and reduced costs by 40%, due to decreased cycle time and improved quality
• Implemented appropriate methodology to add value to the consultants’ deliverables; worked with consultants in identifying process improvements in deliverables; developed methods to achieve delivery of desired results; acted as the quality control point for consultant deliverables
• Prepared business presentations, evaluated architecture, provided technical direction, undertook effort estimation, tracking, risk management, status reporting and mentoring
• Proficient in providing production support and provide critical and normal patches for technical and business related bugs
• Partnered with the IT Leadership team and led the development of a streamlined and transparent demand management process
• Imparted trainings on Oracle Upgrade versions to the client staff.
• Recipient of awards such as Smart Value Award and Customer Delight for technical coordination for a large program
• Experienced in:
• Developing SQL Performance Tuning/Query Optimization solutions
• Data Modeling and Experience in the ETL process
• Application development using various advanced features of Oracle like Collections, Bulk Collections, Table Functions, Autonomous Transactions, Object types and Records. PL/SQL Tables, Table Partitions, Database links, Views, Synonyms, Sequences, Stored Procedures, Functions, Packages, Triggers, Cursors, and Indexes
• Autonomous Transactions Materialized Views, Bulk Collects and Collections

TECHNICAL SKILLS:

Operating Systems: UNIX, Windows NT/95/98/2000/XP

Languages: SQL, PL/SQL

Databases: Oracle 9i/10g/12c

Application S/W: Oracle Forms 6i/9i/10g

Reporting Tools: Oracle Reports 6i/10g

Tools: SQL Developer, Toad 9.0, Load-Runner

PL/SQL Developer: 6.0, SQL *Plus, WSFtp, Lotus Notes, Putty, Oracle Designer, Serena PVCS

Domain: BNFS, Manufacturing ERP and Insurance

Others: SQL Loader, UNIX Shell Scripts

WORK EXPERIENCE:

Confidential

Software Engineer

Responsibilities:

• Managing the software development including design, development & troubleshooting of applications; conducting gap analysis including validation of needs in conjunction with onsite & offsite teams
• Undertaking development & testing, defect & issue management for enterprise software applications and conducting reviews of codes & test cases; driving vision & lifecycle management for various applications development including value proposition & functionality, strategy elements (domain / business case & build) and training
• Evaluating information gathered from multiple sources, decomposing higher information into details, investigating key business issues behind numbers and providing clear & concise analysis / recommendation
• Steering successful rollout of projects with accountability of defining scope, setting timelines, analyzing requirements, prioritizing tasks; handling project delivery as per functional & non-functional needs / using AIM (Application Implementation Methodology) for various releases
• Monitoring project progress & outstanding issues and ensuring the quality & timeliness of deliverables; extending post-implementation support to the Development Team by defining standard practices and testing & documenting new or amended programs from supplied specifications as per agreed standards
• Providing support in handling escalation from clients to resolve their concerns and addressing their queries (customer advocacy) from other departments for a smooth ride for customer’s diverse issues

Confidential, Troy

Technical Lead

Environment: Oracle 11g, Accounts Receivables (AR), SunOS 5.10, UNIX, SQL Developer, SQL *Plus, Lotus Notes, Putty, SVN

Responsibilities:

• Responsible for gathering Business Requirements, creation of Technical Design Documents and user Documents.
• Developing Inbound and outbound interfaces.
• Interface Designing and Applications development.
• Created Executables and Concurrent Programs and attaching with the respective responsibility.
• Created Requests and Request Set to attach the PL/SQL procedures, SQL*Loader routine and Reports with Application.
• Used Auto Invoice Interface to import Standard Invoices into Oracle Receivables using a control file, PL/SQL Packages/Procedures and Auto Invoice Import program.
• Creating Unit Test Plan, Module Specification, Code review, implementation plan documents.
• Doing Unit testing, development testing and preparing test evidence.
• Doing end to end pre-invoice application screen testing from front end to back end to maintain integrity of the system.
• Test Data preparation and Test Data management
• Used SQL *Loader control file to import the customer information provided in the form of flat files into staging tables
• Developed PL/SQL Packages, Procedures and Functions for validating the invoices and payment information from the legacy system and imported into Oracle Application using the Payables Open Interface Import program and populated the base tables.
• Developed an interface to upload the legacy Journal data into the Oracle Application System, developed a PL/SQL procedure, which transfers data to interface tables after performing necessary business validations.
• Involved in writing Test Planning coverage, Test cases and developing Test scripts using Test Manager.
• Involved in filing bugs and verifying fixes and solved them using Quality center.

Confidential

Technical Lead

Responsibilities:

• Used by Allstate customers and agents. Consists on n-tier J2EE application, the web pages are developed in JSP while oracle 10g is used as application database
• Used by service representatives to assist the customers. It has access to various modules like providers, products, ERS, customers, finance, claims etc. Built using oracle forms
• Used for billing and reporting purposes like generation of reports, retrieving data from other systems, validating data and performing batch jobs

Environment: Oracle 10g, ETL Developer, Toad 9.0, PL/SQL Developer 6.0. SunOS 5.10, Forms 9i, Reports 9i.