Developer Project

Chandra Sekhar

Mobile No: +91-973*******

E-mail: *************@*****.***

Areas of exposure

Overall 2 years and 8 Months of work experience in Oracle APEX application development and implementation.

2 years and 8 months of working experience in the Oracle APEX Tool, Toad for Oracle, PLSQL Programming, JavaScript, Windows scripting, Batch files Application development and implementation.

Worked on Oracle APEX 3.2v, 4.0, 4.1, 4.2v versions.

Worked on Analysis, forecasting, decision making and reporting system that will improve the business by enabling the communication channel among different levels of business entities.

Worked on an internal support analysis tool for Global sales of CISCO products, which will identify the issue in different areas of sales chain and its related functions and prompt the user through mails for the desired action.

Experience in different types of Testing done for Applications such as Unit/System/Integration/Performance Testing.

Worked on Applications for different IT Sector like Manufacturing, Health Care Sector

Worked on Enrollment, Claims Modules and UBA Standards.

Gathering requirements from Client, Handling Offshore team and delivered previous Projects with ZERO defects UAT.

Quick learner and a good team player, capable of meeting tight deadlines.

Work experience

Worked as Application Developer for Infosys technologies Ltd, Bangalore, from June 2011 to June,2013

Worked as a System Analyst for Sonata Software Ltd Bangalore from July,2013 to till date

Educational credentials

Passed 10th in Central Board of Higher Secondary Education (CBSE) with approximate 61%.

+2 Science in Council of Higher Secondary Education (CHSE) with approximate 65.54%.

Bachelor Degree in Computer Applications, BCA from Berhampur University with approximate 85.54%.

Technical skills

Platform Windows

Core Technology Oracle PLSQL,Oracle APEX

Web technology JavaScript, JQUERY, HTML,CSS

Scripts Unix, Windows scripting, batch files

Programming Languages C, C++, Java

Database Tools Toad for Oracle, SQL Tools,SQL Developer

Project Details

Project #1

Title Global Customer Engineering Help

Client Cummins

Technologies Oracle APEX Tool, JavaScript, Jquery, Ajax, PLSQL Programming

Duration Aug 2011 – Feb,2012

Description Project deals in providing a GUI for Users to raise incidents when some issue happens in different Forums of Cummins.

This application also integrates with Remedy Application for moving of incidents to respective team in Remedy.

The normal incident raised by this application on a daily basis is around 1000 with many concurrent users and active users.

This application was also undergone Performance Testing due to its usage in large number of users and maintain its performance throughout its usage.

Role Application Developer

Key responsibilities • Coordinating with on site team on tool enhancements

• Integration with Remedy Apps.

• Complex PLSQL Packages,Functions, Procedures,JavaScript

• Performance & Integration Testing.Performance Testing and Integration testing of this application.

Project #2

Title Capacity & Demand Planning Tool

Client CUMMINS

Technologies Oracle APEX Tool, JavaScript, Jquery, Ajax, PLSQL Programming

Duration Mar, 2012 – Aug 2012

Description The Capacity and Demand Planning Tool Application has been built on Oracle Application Express used by the Cummins Filtration plant to track their capacity and demand data. We were required to add additional reports to the tool.

Role Application developer

Key responsibilities • Database design as per the new requirement.

• Detailed Documentation, Impact Analysis and prototypes creation of the new screens to be added.

• Developed the screens with the underlying logic using SQL queries using joins, sub queries to retrieve data from database.

• Creation of database objects tables, functions, procedures, triggers, indexes, views, sequences and constraints as per the requirement.

• Creation of the Unit Test Plans and the Integrated Test Plan.

• Rigorous testing on the modules developed. We received customer appreciation for zero UAT defects.

• Involved in complete cycle of the knowledge transfer.

Achievements • Rigorous testing on the modules developed. We received customer appreciation for zero UAT defects.

Challenges • Understanding of existing Business workflow.

Project #3

Title Lab Manager

Client CUMMINS

Technologies Oracle APEX Tool, JavaScript, Jquery, Ajax, PLSQL Programming

Duration Sept,2012- Mar,2013

Description Lab Manager application is to Manage all three Labs of Cummins,

All three labs functionality was managed in a single web based application and the reporting process to ensure quality, reliability and consistency of data. It involves keeping individual reports of respective Labs and also managing users associated with specific Labs and also involves providing access to users to Labs as and when necessary.

Role Application developer

Key responsibilities • Understanding of Cummins Plants Framework and prepare prototype of the new application.

• Database design of the application.

• Implementation of all 3 labs GUI in a single web based Application.

• Development and integration of various modules in each plant.

Achievements • Provided a common monitoring platform for the users of multiple Labs.

Challenges • Coordinating with multiple plan units members and taking all aspects of implementation.

Project #4

Title Audit Enrollment

Client PHP

Technologies Oracle APEX, JavaScript, Jquery, Ajax, PLSQL Programming

Duration Sept,2013-Feb,2014

Description The purpose of the project is to create an APEX application to track, manage and communicate information on Enrollment audits to all appropriate departments. To transform current Enrollment APEX database to accept audit results and communications from Internal Audit, and to pass back additional information from Enrollment on said audits.

Role Application developer and Lead

Key responsibilities • Database Design,Application Interface.

• Requirement gathering, Coordination with On site for adding some value adds to the user

• Development and integration of various modules of the applications

• Creation of PLSQL Packages, complex java scripts, Apex PLSQL Processes, Authentication

Achievements • Due to subsequent changes in requirement, we provided them an interface with all possibilities required by user.

Challenges • Coordinating with Module Leads from PHP

Project #5

Title ECT Viewer

Client PHP

Technologies Oracle APEX Tool, PLSQL Programming

Duration July,2013-August,2013

Description ECT Viewer application is used to view different reports of claims of PHP organization.

Claims which were having wrong data generated by 837 EDI files are captured in this application. User will search the claim details by providing the Claim_id and will process the claims with correct data and load into FACETS database.

Role Application developer and Lead

Key responsibilities • Creating necessary PLSQL Packages, and understanding the Business from Client.

• Preparing Requirement document and also preparing Initial Application Interface.

• Understanding the target interface and proper Integration between applications.

Achievements • Providing different reports to users based on which user can check the relevant data and filter on user specific values

Challenges • Coordinating with different Module Leads from PHP.

Project #6

Title Claims Module

Client PHP

Technologies PLSQL, Batch Files, Windows Scripting, FTP,

Duration Mar,2014- till date

Description Medical & Pharmacy Claims Extract for a Trading Partner from FACETS database.

Batch Files & Windows Scripting files Creation.

FTP Configuration.

Extract File in Fixed, Pipe-Delimited Format.

Role Developer

Key responsibilities • Windows Scripting & Batch Files Creation.

• FTP Configuration.

• Development and integration of various modules.

Achievements • Timely providing Extract Files to Vendor.

Challenges • Coordinating with multiple teams

Project #7

Title Enrollment Module

Client PHP

Technologies PLSQL, Batch Files, Windows Scripting, FTP,

Duration Mar,2014- till date

Description Extracting Eligible Members for a Trading Partner from FACETS database.

Batch Files & Windows Scripting files Creation.

FTP Configuration.

Extract File in Fixed, Pipe-Delimited Format.

Role Developer

Key responsibilities • Windows Scripting & Batch Files Creation.

• FTP Configuration.

• Development and integration of various modules.

Achievements • Timely providing Extract Files to Vendor.

Challenges • Coordinating with multiple teams

Personal profile

Name: Chandra Sekhar

Address: jayasree Building, Electronic City, Hosur road, Bangalore-560100.

Strengths

Strive to maintain the high level of performance at work.

Exploring the problem in number of ways and find feasible solution.

Hard target will be achieved through cool thinking and hard-strike fashion.

Ability to learn and adapt new technologies quickly

Ability to bring up the team towards organizational goals

Adopt the development methodologies and ensure team should follow an engineering process.

Declaration

All the details specified above are true for best of my knowledge and belief.

Date:

Place: BANGALORE

(Chandra Sekhar)

Contact this candidate