EXPERIENCE SUMMARY:

• Over6+ yearsof experience in system analysis, design, development and implementation of large to medium scale business applications usingOracle and UNIXtechnology in client-server environment.
• Experience with Full Life Cycle Software Development(SDLC)duties as feasibility, planning, implementation, testing, development and close-out.
• Extensive application development usingPERL, PL/SQL, UNIXand Shell scripting
• Extensive experience withPL/SQLin constructing userprocedure, functions and packages.
• Extensive experience withSQLin constructing all Data Objects liketables, views, indexes, views etc.
• Extensive experience in working withSQL Navigator and SQL Developer
• Good knowledge in using theRemedytool for problems/ requests tracking.
• Extensive experience in usingSFTP & FTPtool to ftp the files across various Platforms like Windows, UNIXand Mainframe.
• Strong analytical and problem solving skills with ability to work within a team environment and independently when needed.
• Have knowledge to develop FTP Batch Programs using DOS Programming.
• Worked closely with Corporate Interfaces Group to maintain detailed knowledge of the company’s Corporate Data flows. Managing Production, Test and Development environments.
• Good ability to quickly grasp and master new concepts and technologies.

EDUCATION:

• Bachelor of Electronics and Communication Engineering

TECHNICAL SKILLS:

PERL, K-Shell, SQL, PL/SQL, AWK

Platforms/OS

UNIX (IBM AIX), Windows

Database

Oracle 9i andOracle 10G

SQL Tools

SQL Developer, TOAD, SQL Navigator

Monitoring Tools

Autosys, Qmaster

Connectivity Tool

HummingBird, EXCEED, NetSupport

Version Control

Dimensions

Ticketing Tools

Remedy

Developing Tools

Notepad++, Textpad

PROFESSIONAL EXPERIENCE:

Confidential,Greenville, SC July, 2012 - Present
Senior Oracle and PERL Developer
Project: Store Batch Manager

Store Batch Manager is an interactive menu based application which allows users to view, edit and apply nightly and future maintenance to the IBM ACE POS. SBM is an interface between the POS and DB. Authorization was given to specific users to send maintenance as it is Business critical to have the batches applied in order. We created a shell script to invoke the SFTP transfer for the maintenance file. Wrote many stored procedures to handle nightly maintenance cycle, so when the user logon to the screen, all the data will be populated faster.

Responsibilities:

• Designed and Developed Store Batch Manager (SBM) application.
• Created and managed Stored procedures and packages in PL/SQL.
• Defined efficient advanced SQL queries for complex business requirements.
• Worked closely with User Community in requirements analysis.
• Developed scalable custom control modules for reuse across projects and applications.
• Designed and developed PERL and Shell scripts to automate Oracle DB operations.
• Prepared technical documentation including detailed technical specifications and test cases
• Extensively worked on SFTP protocol for File transfer.
• Have used theNppFTP and Compare plug-in of Notepad++for file transfer and comparison.

Environment:Oracle 10g, AIX (UNIX), PL/SQL, Advanced SQL, PERL, Shell scripting, SQL Developer, SFTP, Notepad++, Textpad

Confidential, Quincy, MA Aug, 2011 Jun, 2012
Senior Oracle and PERL Developer
Project: Batch Create

Manual Batch Create is a user interface screen on UNIX system,where users have the privilege to create batches for any item that is active. This project is very crucial from the Business stand point because any anomaly in prices on the TAGS will cost them revenue, because on promotion day if the price on the TAG and POS differs then the item should be given for free. So, store users should have an interface handy so they can change the price and print the TAG as soon as the situation calls for it. All user need to do is enter the UPC or ITEM number with effective date, the PERL script would fetch all the required data and provide various options to the users like Editing, Printing, Stock Type, even the promotion change types.

Responsibilities:

• Analyzed, Designed and developed Manual Batch Create menu based interactive application.
• Worked closely with business users for gathering requirements and coordinated User Acceptance Testing.
• Developed complex SQL modules for various business requirements.
• Identified points of automation and designed/developed various applications using PERL.
• Developed customization features in the application by means of INI files.
• Performed Data Modeling with SQL Developer Tool.
• Prepared detailed design specs and test cases.
• Extensively used theNppFTP and Compare plug-in of Notepad++.

Environment: Oracle 10g, AIX (UNIX), Advanced SQL, PERL, Shell scripting, SQL Developer

Confidential, Chennai, India Jun, 2010 Aug, 2011
Senior Oracle and PERL Developer
Project: Price Look Up Management [PLUM]

Price Look-up Management is an interface application between the third party vendor developed application called PLUM and the store user. PLUM application has Server-Client architecture where the data and maintenance flow should be maintained by other scripts and stored procedures. This project is about changing the old multi tire architecture which was very complicated for the Business to follow and maintain to a three tire architecture where the data flow can be managed more effectively. Implementation of this project was very challenging because the software upgrade and application migration was done at the same time. Lot of effort was put in coordination various teams to make this project a successful one.

Responsibilities:

• Analyzed, Designed and developed Price Management application.
• Developed advanced stored procedures for Oracle Database for various business needs including automation of nightly maintenance cycles.
• Worked closely with user community and defined detailed functional requirements.
• Worked as a Functional Designer for all the control flows and determined data inbound and outbound for the application.
• Coordinated with other teams in the IT organization in preparing test data and in performing UAT.
• Worked with TIBCO implementation Team to maintain data transfer.
• Worked on data migration and built an automated mechanism for validating data integrity.
• Closely worked with Business users to validate the control flow and user accessibility.
• Prepared necessary supporting documentation

Environment:Oracle 9i, AIX (UNIX), PL/SQL, SQL, PERL, Shell scripting, SQL Navigator, Notepad++

Confidential, Chennai, India May, 2008 - May, 2010
Oracle and PERL Developer
Project: Op-Co Integration

Applications from two different operating companies were merged into one. Two types of UNIX environments were merged to create one base hybrid system on which all the applications were built on. More than 20 applications were re-written to accommodate these changes. Various towers like ITO, Finance, Data Warehousing, Marketing & Merchandising, Data Integrity Group, Retail were involved in this project. Development team had work directly with the Business and BSA team for data migration and UAT. Many incremental changes were done on the base code based on user’s need. Dimensions, versioning control tool, was extensively used in this project.

Responsibilities:

• Worked with Business System Analysts in integrating two Operating Companies.
• Developed advanced PL/SQL Blocks based on the service request.
• Developed shell scripts for automation.
• Worked with BSA in validating the data after migration.
• Developed an efficient module to validate data integrity to manage zoning changes between the two images.
• Extensively worked in identifying and fixing Taint issue we faced in the application.
• Performed detailed analysis and provided suggestions to mitigate Data Tainting Problem.
• Provided implementation assistance to handle issues with migration.
• Worked as a Subject Matter Expert for more than 8 Applications and provided technical information about the changes required.
• Worked with Software Distribution Team and coordinated the software distribution to production nodes.
• Maintained code baselines using Dimensions SCM software.
• Peer reviewed all the changes made by the team to maintain coding standards.

Environment: Oracle 9i, AIX (UNIX), PL/SQL, Advanced SQL, PERL, Shell scripting, Dimensions, SQL Navigator, TOAD, Textpad

Confidential, India April 2006 May 2008
Oracle, PERL and Shell Developer
Project: Distributed Applications
Applications that were distributed to all the stores and maintained one a single image are called Distributed Applications. We had more than 40 such applications including Pharmacy, Ordering, Cash Reporting etc. Changes will be initiated in the form of Service or Change Requests. As a team we will come with design, HLE and Test Cases. After UAT sign off, should work with the Software Distribution team to distributed the applications to the chain and maintain the versions in Dimensions.

Responsibilities:

• Analyze Modify and EnhanceDistributed applications.
• Wrote POSIM application in SHELL Scripting involving SQL.
• Wrote Batch Programs to FTP files from Windows Machine to UNIX boxes using DOS Programming.
• Extensively performed Root Cause Analysis on various issues and proposed fixes with Business impact Analysis.
• Proposed enhancements to existing version of applications and implemented the changes.
• Worked with the Software Distribution Team and coordinated the software distribution to production nodes.
• Maintained code versioning using Dimensions versioning control software.

Environment: AIX(UNIX), Oracle 8i, Dimensions, Windows 2003 Server, DOS Programming, Dimensions.