Oracle Developer and Specialist

Tarun Mittar

Mobile: +1-901-***-****

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

PROFESSIONAL SUMMARY

** ***** ** ****** *** development experience of SAP HANA Platforms, Business Objects, Business Intelligence, Oracle Database, Microsoft SQL, PL/SQL, Performance Tuning, Oracle Forms & Reports, and Oracle Applications.

Exposure in Oracle CC&B Data Conversions, Progress 4GL development.

Experienced in handling huge databases and sound knowledge of data warehousing concepts.

Very sound financial, banking, insurance and Utilities domain knowledge.

Experience in Onshore Offshore, Global delivery models and with Agile, Scrum methodologies.

Self-motivated, self-starter, rapid adaptability and strong capability in quickly learning new skills and technologies.

Excellent written and verbal communication skills, analytical and problem solving skills, strict attention to detail.

Ability to work on multiple projects simultaneously, ability to work independently and lead/work within a team.

PROFESSIONAL EXPERIENCE

Proserve Consulting INC (JK Technosoft)

Client: Sedgwick CMS, Memphis, USA Aug 2017-Present

Programmer Analyst

Sedgwick is a leading global provider of innovative, technology-enabled claims and productivity management solutions, delivering a world of expert resources to a diverse client globally. Working as a Technical Lead in Enterprise Initiatives team for Disability Operations

Working closely with the Product Owners, Business Analysts, QA Team, and business users for application enhancements, customizations and reporting requirement for disability operations.

Involved in requirement gathering, estimations, code development, unit testing, bug fixing and requirement review and code review.

Manage offshore team and guide and support them by coordinating the business requirement and discussions onsite.

Preparation of testing documents and design specifications based on client’s requirements.

Development of complex reports and other functionalities on SAP HANA platform, Business Objects, Web Intelligence, HANA and Oracle universes, Advanced Analytics, Oracle 12c.

Environment: SAP HANA, Business Objects, Web Intelligence, Information Design Tool, PL/SQL, Oracle 12c Database, UNIX

Proserve Consulting INC (JK Technosoft)

Client: Sedgwick CMS, Memphis, USA Sep 2015-Aug 2017

Programmer Analyst

Worked as a Technical Lead in the Product Development for Policy Repository (same client Sedgwick)

Worked closely with the Business analysts, Team members, QA Team, and DBAs for end to end discussion of the application enhancements.

Involved in requirement gathering, estimations, code development, unit testing, bug fixing and requirement review and code review.

Worked with the team to review the code and to make sure all the coding standards are followed to be compliant and efficient.

Preparation of design specifications based on client’s requirements.

Development of complex functionalities on Oracle PL/SQL, Microsoft SQL, Progress 4GL and Informatica.

Performance tuning of database and PLSQL code.

.Net web services configuration and their integration with Oracle

Preparation and presentation of Sprint reports.

Management of Rally and task flows according to Agile Methodologies.

Environment: PL/SQL, Informatica, Progress 4GL, Oracle 12c, Oracle 11G Database, SAP HANA, Business Objects, Microsoft SQL Server, UNIX

Price Waterhouse Coopers

Client: City of Seattle, USA May 2014-Aug 2015

Technical Lead

Seattle City Light is a public utility company providing electrical power to Seattle, Washington, US, and parts of its metropolitan area. Worked as a lead PL/SQL developer and participated in the end to end discussions with the client in an Oracle CC&B product conversion project.

Extensively worked on the design and the development of Oracle packages to validate and convert data from various legacy systems.

Performance tuning of database and code to ensure performance for conversions.

Development of conversion strategy and detailed conversion plan.

Perform data mappings from source to target system based on the requirements provided by the client onshore.

Defining transformation rules, managing various conversion subsets, full runs including dry and mock runs.

Worked as a consultant to bridge the gap between the onshore and offshore teams. Conducted trainings at Offshore on the product and the requirements to enable the project execution smoothly.

Worked closely with team members, team leaders, project managers, system analysts and project consultants both at onshore and offshore.

Involved in requirement gathering, estimations, code development, unit testing, bug fixing and requirement review and code review.

Environment: Oracle PL/SQL, Java, Oracle 11G Database, UNIX, Oracle CC&B

Price Waterhouse Coopers

Client: Auto Trader Group, USA Apr 2013-May 2014

Senior Software Engineer

Auto Trader Group is the world’s largest digital automotive provider of marketing and software solutions to automotive dealers throughout the U.S. The project involved the development and implementation of Oracle Revenue Management and Billing (RMB) in different phases for their business branches ATC, HMN, VIN and VAUTO. ORMB handles all the billing requirements for their customers.

Design and the development, deployment and maintenance of Java classes and database objects (Packages, triggers, views, indexes etc.).

Worked closely with team members, team leaders, project managers, system analysts and project consultants both at onshore and offshore.

Involved in requirement gathering, estimations, code development, unit testing, bug fixing and requirement review and code review.

Designed and developed various complex UI screens in ORMB, Backend development using Java and PL/SQL.

Environment: PL/SQL, Oracle 11G Database, Unix, Java, Oracle RMB, Oracle EBS

Price Waterhouse Coopers

Client: Apollo Group, Phoenix Oct 2013-Apr 2013

Senior Software Engineer

Apollo Education Group provides educational services, educational support services, consulting services and technical support services to institutions offering post-secondary education. The project included up-gradation of client’s application from Oracle 11i to Oracle R12 and it also included development and enhancement of some new functionalities.

Analyzing the requirements and preparing the plans for Development.

Development, deployment and maintenance of database objects, Concurrent programs, and interfaces.

Designing new screens and modifying existing front end screens in Oracle Forms.

Unit testing and Internal Testing of application.

Environment: PL SQL, Oracle forms & Reports 10G and 6i, Oracle 10G DB, UNIX, Oracle Applications 11i and R12

Ellucian, India Dec 2010 - Oct 2012 Senior Software Engineer

Worked as a PL/SQL developer Banner, a Financial Product of Sungard (later known as Ellucian) that helps the organizations to perform day to day financial transactions and generate financial reports.

The project involved development of new components as well as the customization of the product.

Worked in the design and the development of new components and customization using Oracle PL/SQL, Oracle Forms and Reports

Involved in analyzing the requirements and preparing the functional, technical designs and development plan.

Worked on development, unit testing, bug fixing and requirement review.

Closely worked with team members, team leaders, project manager, system analysts and project consultants both at onshore and offshore.

Environment: Oracle PL/SQL 10G, Oracle forms 10G, Oracle 10G Database, UNIX, Pro C

Oracle Financial Services Software Ltd

Project: First Caribbean International Bank, India Jan 2010 – Dec 2010

Staff Consultant

First Caribbean Bank is a major banking and financial services company and the project involved enhancement of the Oracle Flexcube. The application included Payments and Collection, Leasing, Loans and Deposits, Money marketing and Clearing Modules.

Extensively worked in the design, development and Performance tuning of database objects.

Involved in the development, deployment and design of new screens and modifying existing front end screens in Oracle Forms.

Involved at various levels of the SDLC and handled several responsibilities.

Reviewed business requirement documents to create and present technical design documents.

Participated in code walk through, code review, unit test plans and reviews, unit testing and integration testing.

Collaborated with Business Analysts, Database and Server administrators, QA team to verify accuracy and thorough testing to ensure project time lines are met with high quality deliverables.

Deployment support, defect fixes, defect tracking and production support.

Environment: Oracle PL/SQL 10G, Oracle forms 10G and 6i, Oracle 10G Database, UNIX

Oracle Financial Services Software Ltd

Project: Silicon Valley Bank (SVB), California, USA Sep 2008 – Dec 2010

Associate Consultant

SVB Financial Group is a major banking and financial services company in the US. The project involved enhancement of the Oracle Flexcube. The application included Customer Maintenance, Funds Transfer (payment gateway), Lending, Loans and Deposits modules.

Worked in the design, development and Performance tuning of database objects.

Involved in the development, deployment and design of new screens and modifying existing front end screens using RAD Tool.

Involved at various levels of the SDLC and handled several responsibilities.

Unit Testing as well as Internal testing of the end to end application after code deployment and performed smoke testing.

Reviewed business requirement documents to create and present technical design documents.

Participated in code walk through, code review, unit test plans and reviews, unit testing and integration testing.

Collaborated with Business Analysts, Database and Server administrators, QA team to verify accuracy and thorough testing to ensure project time lines are met with high quality deliverables.

Provided deployment support, defect fixes, defect tracking and production support.

Environment: PL SQL 9i & 10g, JS, Rad Tool, Oracle forms 10G and 6i, UNIX

CERTIFICATIONS

Oracle Certified Specialist for Oracle Customer Care and Billing

OCA (Oracle Certified Associate) from Oracle in Database Track (SQL and Fundamentals part 1)

OCA PL SQL Developer from Oracle University

OCP (Oracle certified Professional) from Oracle in Application database platform (Fundamentals Part 2 and Performance Tuning).

SIGNIFICANT ACHIEVEMENTS

Letter of appreciation from the company CEO and client (Aug 2017)

Great Performer Award (WRGP) in Feb 2014.

Great Faculty Award in June 2011 for successfully providing technical training.

Award of appreciation (i-appreciate) from OFSS in year 2009–10

EDUCATION & CREDENTIALS

Bachelor of Technology- Computer Science Engineering, India, 2004- 2008

Contact this candidate