Skills : Oracle 10g/ 11g, PLSQL, Perl/Unix ShellScripting,Unix,Pro*c

PROFESSIONAL SUMMARY

Having 6.4 years of experience in IT industry encompassing a wide range of skill set, 
Roles and industry verticals.

Having good exposures in Banking, Financial Services and Retail domain.

• Seasoned IT professional with comprehensive business/technical skill set and expertise in requirements analysis, business process automation, systems integration, software development, UAT/IT testing.
• Responsible to develop new modules, Change Requests i.e. Business solutions and related modifications to develop effective tools to multiply business opportunities.
• Involved in PL/SQL subprograms creation ..like Procedures, Functions, Triggers,Cursors,Ref cursors,Collections.. Varray,nested tables,plsql tables,Handling of XMLs and many more.
• Creation of Shell/Perl scripts as per requirements.
• Good understanding of Oracle internal architecture (Buffer cache,shared pool,Redolog-buffers,Cursorpool,Large-pool, PGA, SGA, Pmon, Smon, DBWR, LGWR etc).
• Responsible for Performance tuning on sql queries and plsql programs.. generating tracefiles, using tkprof on sqltracefiles, creating oracle hints, Analyzing the tables, creating indexes.
• Good exposure on Sqlloader, External tables and knowledge on EXPORT/IMPORT utility to maintain data.
• Having exposure on creating Materialized views, indexes, synonyms, sequences, tablespaces, partitioning of large tables, Clusters.
• Enthusiastic learner who quickly grasps new concepts and technical skills.
• Good communication skills, interpersonal skills, self-motivated and team player.

EDUCATION

• Bachelor of Technology (B-Tech)
• H.S.C (Science)
• S.S.C (Science)

TECHNICAL SKILLS

Operating Systems: Solaris, HP-UX, AIX, Windows XP/03/07
Databases: Oracle 10g/11g
Languages: PL/SQL, Pro*C, C, Shell Scripting, Perl, XML, Core Java
Middle Software: TUXEDO 9.1, MQ messages
Tools: SQL*Plus, Toad8.0, PlSql developer, Autosys, Oracle forms 10g, Reports 10g, Tivoli work  Scheduler, BI Publisher, HPQC , HPSM
Domains: BFS (Banking, Financial Services), Retail

PROFESSIONAL EXPERIENCE

• Working with Confidential.as a Sr. Software Engineer from 13-Jan- 2011 to till now.
• Worked with Confidential as a Sr. Software Engineer from 17-May 2010 to 05-jan-2011.
• Worked with Confidential as an IT Engineer from 27-April 2006 to 28-Apr 2010.

Company Profile

Confidential is subsidiary of Confidential Corporation (NASDAQ:IGTE) which is the first fully integrated and operations firm with a Global Services Model. Confidential caters to different geographies through its subsidiary Confidential Global Solutions Ltd with its Global Delivery Centers in India and offices across North America, Europe and Asia Pacific. Confidential enables clients to optimize their business through a combination of process investment strategies, technology leverage and business process outsourcing and provisioning. 
It has major clients like General Electrical and Confidential group.

Currently working on Confidential which is centralized customer file management system which maintains/exchanges the customer’s details, Credit and Invoice details from the various distributed systems through interfaces to make data available in sync to other systems for Confidential.

#Project Confidential-CFM Client: Confidential

Period Dec-11 to till now
Team size 7
Role: Application developer

Environment: PLSQL, Oracle 10g/11g, UNIX, Shell scripting , XML, Forms10g BI-Publishers Reports.  Project Responsibilities

Responsible to develop new modules for projects and handling of maintenance activities as per requirement.
Below are the lists of handled development/maintenance projects in CFM for client Confidential:

Development Requests:

• Demand for MRC risk check for the Credit limit updation in CFM 3.9 version from MRC system to reduce business / credit management risk in case if the harmonized credit management is activated in the country

OR the parts of the credit management are in use and country requests the connection.
My Role: PL/SQL Developer
Involved in : Analysis of Functional Specification documents.
Requirement analysis.
Preparation of Technical Specification documents .
Preparation of detail level test plan.
Coding and unit testing.
Integration testing.
Team size 1
Environment PL/SQL, Oracle 10g/11g, Forms 10g,Shell Scripting.

• Demand for introducing customers deletion details in Local II export interface towards French local applications without any impact for other local applications.

My Role: PL/SQL Developer
Involved in: Analysis of Functional Specification documents.
Requirement analysis.
Preparation of Technical Specification documents.
Preparation of detail level test plan.
Coding and unit testing.
Integration testing.
Team size 1
Environment PL/SQL, Oracle 11g, Shell Scripting

• Demand for enable Webshop Order Tracking file for reducing booking complexities since some payment types might require the WebShop order number for payment identification or possibility of Customer in satisfaction if any request is delayed because of this.

My Role: PL/SQL Developer
Involved in: Analysis of Functional Specification documents.
Requirement analysis.
Preparation of Technical Specification documents.
Preparation of detail level test plan.
Coding and unit testing.
Integration testing.
Team size 1
Environment PL/SQL, Oracle 11g, Forms 10g, Shell Scripting.

Maintenance Requests:

• Activity for maintaining errors into error log table for HO stores for all countries.
• Activity for maintaining for customer deletion process :
• Customers with general blocking code were currently excluded  from customer deletion process. To meet French legal requirements, these customers have been included in the customer deletion process.
• Maintenance for removing the EMAIL validations other than the validations that were introduced as part of Rel 9.2 Development Topic 09 Data Quality for all countries.
• Performance tuning for month end turnover calculation process for country PL and RU.

Worked with Confidential which is a credit card application processing system. The system does the processing for the BRC and the Commercial clients. Consumer client is not in the scope of the system.

#Project Master Strategy Client: GE Money-Confidential

Period May-11 to Nov-11
Team size 6
Role: Application Developer

Environment: PLSQL, Oracle 10g, Form 10g, Shell scripting, HP-UX.

Project description & Responsibilities
Currently after the Bureau call, Rule Engine takes care of the SEM3 call where it calculate scores along with credit decision followed by fraud checks.
With this project, Confidential would build a separate module called Master Strategy where the MS tables will be maintained at Confidential to make Strategy changes.

Master Strategy hook would be called to read the values from these MS tables in order to process an application and pass the scores and MS decision flag back to Rule Engine.

• Here my responsibilities were to analysis of Functional specification, preparation of Technical documents and building the construction like making tables, uploading of decision making data to setup tables, making Pro*c, plsql codes to interact with database and making auto jobs for SEM-1 call.
• Was responsible for unit testing and integration testing for the same, UAT handled by onsite.

#Project HPA & Securities Client: Confidential

Period Aug-11 to Nov-11
Team size 2 
Role: PL/SQL Developer

Environment: PL/SQL, Oracle 10g, Shell scripting, HP-UX.

Project description & Responsibilities
This project is related to access revision on servers to restrict access on Prod. Below was my responsibilities:

• Creation of new roles for Run team and QA team.
• UNIX team will make logging that captures the HPA ids activities for HPA ids contained in Confidential application.
• Service ID\'s will be administered by Key custodians.
• Separate role for test if the role name is same as production.
• Production access of non-HPA users has to be revoked.
• Confidential will list of commands for which HPOV should alert Confidential team.
• Documented the entire process including access mechanism, Key Custodian responsibilities, Access log communication mechanism, Key Custodian Handover process, Quarterly ID clean up process and QA process.

#Project Mason DR (Disaster Recovery/Backup) Client: Confidential

Period Mar-11 to Oct-11
Team size 2
Role: PL/SQL Developer

Environment: PL/SQL, Oracle 10g, Shell scripting,HP-UX

Project description & Responsibilities
Currently Confidential has no backup server so in this project we are creating the same replica of Confidential server Alpharetta at Mason which would be used as a Backup in case of any disaster.

My responsibilities:

• Making replica of Alpharetta Confidential servers on Mason that would be used as a Backup in case of any disaster in Alpharetta.
• All codes movement on Mason UNIX boxes using rsync utilities through shell script.
• Installation of Oracle client, Oracle server, autosys, MQ, Glassfish, third party software (transact) on Mason UNIX boxes.
• Follow up with the UNIX team for all users and roles creation on Mason UNIX boxes as like Confidential Alpharetta. Responsible to provide query list for creation of users/schema, roles, query of grant/revoke privileges to DBA.
• Involved in data backup activities (hot/cold and RMAN utility) in team meetings with DBA and Client.
• Involved in creating new jobs to make sync Mason database with Alpharetta database using db links.
• Responsible to check of init.ora files parameter values, db filesize, control files on Mason UNIX servers.
• Follow up with Network team for installation of all necessary software’s/utilities on Mason UNIX boxes.
• Setup of all configuration files with Mason UNIX server ips/hostname.
• Creation of all autosys jobs on Mason autosys server as like Confidential Alpharetta.
• Using the rsync utility we’ll make the data synchronization on both Alpharetta and Mason Confidential UNIX servers.

#Project Tandem upgrade Client: Confidential

Period Feb-11 to Apr-11
Team size 2
Role: Application developer

Environment: Pro*C, C, Plsql, Oracle 10g, UNIX shell scripting.

Project description & Responsibilities 
Tandem and Mason Servers (RCF HP Non-Stop Servers) are getting upgraded from the legacy S-Series to the current Integrity Blade technology. Respective Confidential interfaces need to upgrade with new Tandem/Mason server’s IP address in place of Old Server’s IP address on both Prod and QA servers for real time packets scenario. 
Below were my responsibilities:

• For Real time packets scenario of Confidential environment,upgraded only new Tandem server’s IP address (because Port is same) in place of Old Tandem Server’s IP address for both Prod and QA servers.
• For Tandem/Mason related Inbound/Outbound files scenario of Confidential environment, NDM feeds will be sent on both old and new servers of Tandem/Mason.

For this task ,created new batch jobs ( As old Batch jobs is already running for old Tandem server in current scenario) through which we send feeds to New Tandem Server as like Old batch jobs sends feeds to old Tandem Servers.

• Involved in unit and integration testing.

Change Requests Implemented

• Made an autosys job for Purging of online data on daily basis using Perl Scripts(used tracefiles , used tkprof logs,utl files using changes on init.ora file parameter.
• Optimization of servers Restart script.
• Made an autosys job for Purging of user data on monthly basis as well as sending mail with attached list of purged users to other interface using Perl scripts (Used the utl files using changes on init.ora file parameter.

Previous Company

Confidential provides software services for many clients. One of the major client is Polaris software lab ltd.

Polaris software is one of the leading software firm in India who’s providing services of software development, Enhancements & support for one of it’s major client Confidential.

#Project TBMS Development Client: Confidential

Period Sep-10 to dec-10
Role: PL/SQL Developer

Environment: PL/SQL Developer, Oracle 11g, Shell scripting, Solaris

Responsibilities

• Involved in development of TBMS Release 5.
• Enhance the existing reports with adding of new fields.
• Program to generate a report showing the bills discounted.
• Bills Maturity Profile report for all the active bills that mature in the date range input by the user.
• Bills Liquidation Debit Advice report which is discounted on each of the dates in the given period based on current liquidation.
• New code written to generate handoff records for rtgs transactions.

#Project TRIMS UAT Client: Confidential

Period 24-Jul-10 to Aug-10
Role: PL/SQL Developer

Environment: PL/SQL Developer, Oracle 11g, Shell scripting, Solaris

Responsibilities

• Resoving TRIMS UAT issues as per quering with user NA/EMEA region.
• Monitoring of servers and responsible for doing shutdown and starting the servers.
• Responsible for generating reports as per requirement of user NA/EMEA region.

#Project EPMS DEVELOPMENT Client: Confidential

Period May-10 to 24-Jul-10
Role: PL/SQL Developer

Environment: PL/SQL, Pro*c, Oracle 11g, Shell scripting, Solaris

Responsibilities

• Enhance the services of EPMS module on the basis of particular country & City wise so that it will modify EOD output files with more feeds as per country & city level.
• Enhance the services of EPMS module that will modify EOD output files with event code and event description for every transaction.
• Performance tuning of Bill pre-shipment module programs.

Previous Company

#ANB provides software development, Enhancement for client Confidential. 
Confidential is the pioneer in Online Share trading which has a portal Confidential.com through which customers can place requests to Exchange NSE & BSE.

#Project ICICI DIRECT DEVELOPMENT Client: Confidential

Period Apr-06 to 30-Apr-10
Role: Pro*C Developer

Environment: Pro*c, PL/SQL, Oracle 9i/10g, Shell/Perl scripting, AIX

Responsibilities:

• Automation of reconciliation process for Equity segment which otherwise used to take whole night-out of support officers in manual Missing Trade Handling using Perl Scripts.
• To get the cash settlement balance details for a given match account. Updating match with the latest debit and credit entries.
• Involved in database migration from Oracle 9i to 10g database.
• Changes to make revaluation batch process runnable during market hours, calculations based on Last Traded Price. This service validates the transaction depending upon the transaction type and stored into database tables.
• New batch program to automatically block shares in DP. To carry out ISIN transfer in EBA.
• To calculate the commission to be given to a BP for a given period. To allow BP customers to access the site of equity.
• Display of closeout notes for exchange initiated trades on the FNO expiry date using Perl Scripts.
• Inclusion of Brokerage and other charges under the Derivatives Portfolio Details page.
• Batch program for uploading index values and printfile generation for IPO. Payin program for IPO & GOIs.
• Optimization of EBA services which is called by DL services for better performance .