Developer Oracle

SUNIL UPPAL

*****.*****@*****.***

** ********* ****, 647-***-**** Mobile

Caledon, ON L7C 3Y6 647-***-**** Home

INFORMATION TECHNOLOGY PROFESSIONAL

Expertise in: Oracle Application Development & Support

Highly accomplished, deeply driven, IT professional with a successful 15+ year track record of success in Software Development, Maintenance & Support using Oracle, SQL, PL/SQL, Oracle Forms, Oracle Reports and Unix and have worked extensively in all the phases of Software Development Life Cycle using Waterfall and Agile/Scrum Methodologies. Excellent understanding of Requirement Gathering and Translating Requirements into Specifications. Repeatedly successful in navigating complex technical environments, writing complex SQL queries and possess strong PL/SQL expertise in stored procedures, functions, packages, triggers, tables, views, cursors and performance tuning. Experience in designing and developing ETL code. Experience in development, on-call/production support, data analysis, research, debugging, troubleshooting, deployment and on-site experience at various client locations. Skilled in documenting Test Cases and End-to-End Unit/Integration/Regression/User Acceptance Testing. Experience in team handling, mentoring, doing code reviews and providing technical training. Exceed ongoing and overlapping deadlines in fast-paced environments, handle multiple assignments simultaneously, coordinate deliverables with key stakeholders in cross-functional groups and reporting to management. Possess strong analytical, verbal, documentation and inter-personal skills. Domain knowledge includes Banking, Finance, Mutual Funds, Mortgage, Healthcare, Telecom Billing, Car Rental and Construction Estimation.

Technology Snapshot: SQL, PL/SQL, Oracle 8i/9i/10g/11g, SQL*Plus, Oracle Forms 6i/11g, Oracle Reports 6i, TOAD, Oracle Designer, PL/SQL Developer, Java, T-SQL, SQL Server, Unix, Shell Scripting, DataStage, QlikView, Autosys, Tidal, Remedy, JIRA, Confluence, Slack, SharePoint, Service Now, Geneva, VSS, PVCS VM, Snag It, MS-Office & Windows.

PROFESSIONAL EXPERIENCE

Key career contributions as: System Analyst, End-to-End Senior Developer - Plexxis Software Solution Consultant - IRIS Software Technical Lead - Dell Services Senior Software Engineer - Patni Computers Technical Associate - Tech Mahindra Software Developer - Nucleus Software

PLEXXIS SOFTWARE, Brampton, Ontario, Canada ~ 7/2015 to 7/2019

System Analyst, End-to-End Senior Developer

Plexxis Software creates innovative technology for the wall & ceiling industry. The ERP is based on a powerful single source Oracle DB with purpose driven features for estimating, project management, accounting, mobile & business intelligence.

Participate in the creation of a comprehensive end-to-end solution for the new features to be implemented in the ERP.

Ensure design leverages existing reusable components and has traceability to business requirements.

Assist the Product Manager and Implementation Team by providing effort estimates for new projects and initiatives.

Provide expert knowledge on the technical feasibility of the proposed deliverables and technical leadership during the lifecycle of a project/initiative by working with the developers to ensure that the detailed technical design is fully understood, and the development initiatives are in line with the intended design.

Conduct code reviews to ensure quality, standards compliance, reusability and ease of maintenance.

Plan, track and manage agile and software development tasks in JIRA.

Write SQL queries and Create/Modify Oracle database objects and program units using SQL & PL/SQL.

Develop new forms & reports using Oracle Forms11g and Oracle Reports and integrate them in the existing ERP system.

Enhance the existing screens/reports and database program units by adding or changing functionality and logic.

Investigate, analyze and document the root cause of issues and resolve defects by providing a permanent solution.

Take detailed screenshots and videos of the solution provided and share it with the testing and implementation team.

Document test scenarios and perform end-to-end unit and integration testing.

Design and Develop new screens/features to be displayed in the trade shows, sales demo, etc. to get potential new clients.

Deliver effective and efficient solutions by meeting key project milestones, communicate project status, provide timely escalation and ensure that the project deliverables are on time, within budget, and adhere to the corporate quality standards.

IRIS SOFTWARE, New Jersey USA ~ 4/2013 to 11/2014

Solutions Consultant

Worked at the Lord Abbett, NJ client location on the Sales & Assets System of Records project, a data driven process that comprises of daily Client Financial Transactions and monthly Client Assets data provided by vendors like JP Morgan, Edward Jones, Morgan Stanley etc. and which also had other processes like Proofing, Matching, Tagging, EOD and Reporting.

Worked closely with the SME’s, identified and analyzed the core requirements and key features of the ongoing project.

Created Technical Understanding Document and shared knowledge with the offshore team members.

Wrote ad hoc SQL queries and did Performance Tuning for the jobs running slow.

Created and Modified Data Stage Jobs and Unix Shell Scripts.

Created TIDAL Jobs to automatically execute Perl/Shell scripts and to post flags to define dependencies.

Analyzing and Debugging Core Java Code to fix the issues.

Created CR’s using Service Now tool, updated status and coordinated with respective groups to implement CR’s.

Updated project status with Client Project Manager, Onsite Team Leader and Offshore Project Leader on a regular basis.

DELL SERVICES, Virginia USA, Boston USA, England UK ~ 9/2006 to 9/2012

Technical Lead

Project: ODYSSEY ROPS Duration: 9/2010 to 9/2012 Client: Enterprise Holdings Inc., Virginia, USA

Worked as Senior Programmer Lead. Added several new features and enhancements in the Odyssey product - a complete car rental system supporting all areas of EHI operations such as Reservations, Rental Operations, Billing, Fleet & Revenue Mgmt.

Planned, designed, developed and implemented new features and enhancements in the Odyssey product.

Assisted the Project Manager by providing effort estimates for various new features and enhancements.

Created and modified Oracle database objects and program units using SQL & PL/SQL as per the design specifications.

Developed, enhanced & modified several Oracle Forms and Oracle Reports in Odyssey Rental Application.

Replicated, debugged and documented the issues encountered on the ROPS screen and fixed the reported defects.

Performed file handling commands, FTP files, invoked Oracle Forms & generated FMX files using UNIX.

Documented test cases and performed end-to-end unit and integration testing.

Attended regular meetings/conference calls to update the status, clear doubts & report issues.

Project: STAGING Duration: 9/2008 to 8/2010 Client: Harvard Pilgrim Healthcare, Boston, USA

Staging Area collects, integrates & distributes current information about a specific subset of data associated with customer, member, product/benefit, claim, & provider subject areas. This includes managing the transformation rules & business logic so that cleaned & enriched data can be loaded into downstream applications, data stores and web portals.

Gathered requirements by conducting meetings and brainstorming sessions with the SME's and documented them.

Developed ETL code based on ETL specification using Oracle, SQL and PL/SQL.

Wrote ad hoc SQL queries and prepared PL/SQL & SQL*Loader scripts and executed them in different environments.

Documented test scenarios and performed unit, integration and ETL Testing.

Investigated, analyzed, documented and resolved the reported defects.

Provided production support that included checking Unix log files, data analysis, emails, etc. on a daily basis.

Prepared Release List documents, Created tickets in Remedy and Promoted packages in Harvest.

Prepared knowledge-base documents on various subject areas and gave presentations to offshore team members.

Updated project status with Client Project Manager, Onsite Team Leader and Offshore Project Leader on a regular basis.

Project: INCA Duration: 9/2006 to 8/2008 Client: Daimler Chrysler Services IT, UK

Enhancements related to INCA within Phoenix (proposal & contract management system for leasing & finance companies).

Involved in the SDLC phase of requirement analysis, design, development, testing and implementation of the application.

Created Technical Specifications document and estimated development time and resources for the project.

Worked with the developers to ensure that the detailed technical design is fully understood, and the development initiatives are in line with the intended design.

Managed team & performed tasks like work allocation, tracking progress, reviewing timesheets, performance review, etc.

Conducted technical code reviews to ensure quality, standards compliance, reusability and ease of maintenance.

Wrote test cases/scenarios for unit and system integration testing.

Developed various Oracle SQL & PL/SQL scripts and Forms & Reports using Oracle Forms and Reports.

Communicated project status, provided timely escalation and ensured that the project deliverables are on time.

PATNI COMPUTERS, Michigan USA, England UK ~ 4/2005 to 8/2006

Senior Software Engineer

Worked as a Senior Developer at the ABN AMRO Bank, Michigan (USA) and London (UK) client locations on the MUPIT project - Mortgage Loan Underwriting, Processing & Information Tracking System which processes home mortgage loans for InterFirst wholesale lending business unit from initiation through underwriting, funding and closing processes.

Involved in the SDLC phase of requirement analysis, design, development, testing and implementation of the application.

Created and modified database objects using Oracle SQL, PL/SQL as per the design specifications and requirements.

Incorporated several new features & enhancements in the existing MUPIT system using Oracle Forms 6i and Reports 6i.

Replicated, debugged and documented the issues encountered in the application and fixed the reported defects.

Prepared various documents like Program Specifications, UTC, Code Merge, Traceability Matrix, Code Review, etc.

Documented test cases and performed end-to-end unit and integration testing.

TECH MAHINDRA, England UK ~ 9/2003 to 3/2005

Technical Associate

Worked as a Team Member in the Billing Platform Dev Team at the British Telecommunications, Ipswich client location on the BRECON project, a Billing Application (Geneva) for rating & billing of various products/services offered by BT.

Involved in Geneva Configuration & Design in different modules like System Configuration, Product Configuration, System Monitor, Customer Account Maintenance, Rating Catalogue Maintenance & Billing Catalogue Maintenance.

Wrote ad hoc SQL queries and prepared PL/SQL and UNIX Shell Scripts and applied the same in different environments.

Used Geneva Front End GUIs and APIs for development of code.

Prepared Release Notes and Compressed Tar files.

Performed unit and system testing and fixed defects prior to each implementation.

NUCLEUS SOFTWARE, New Delhi India ~ 11/2002 to 8/2003

Software Developer

Worked as a Team Member for implementing FINNONE product for Arab National Bank, Riyadh, Saudi Arabia. FINNONE is a suite of Financial Software Application developed to meet requirements of Banks & Financial institutions for retail lending, deposits etc. and takes care of automation for loan’s business from origination till closure.

Performed Gap Analysis of the As-Is and To-Be processes to identify and validate requirements.

Customized Security Module to implement Maker/Author functionality & to introduce Audit Trail Reports.

Developed various PL/SQL scripts, Master/Transaction Forms/Audit Trail Reports using Oracle Forms 6i & Reports 6i.

Prepared documents like Impact Analysis Document, Program Specification, Unit Test Plan, Coding Checklists, etc.

Documented test cases and performed end-to-end unit and integration testing.

EDUCATION, CERTIFICATION AND AWARDS

Master of Computer Application, MKU, India (Canadian Equivalent, Evaluation done by WES Canada).

Bachelor of Commerce, Delhi University, India (Canadian Equivalent, Evaluation done by WES Canada).

Oracle Certified Professional (Developer Track) - SQL, PL/SQL, Oracle Forms and Oracle Reports.

Certificate Course in Oracle 8i with Developer 6i, SQL Star International, India.

Diploma Course on QlikView Designer and QlikView Developer.

Certificate Course in Web-Centric Computing, NIIT, India.

Scored an Overall Band Score of 7.5/9.0 in International English Language Testing System (IELTS).

Received Associate Performance Award (Dell Services) and Team Award (Patni Computers).

Contact this candidate