Highlights:

Skills:Oracle PL/SQL, Unix shell scripting

Software Engineer 08/2006 - 12/2006
Nucleus Software Export Ltd., Noida, UP India
Industry: IT
As Software Engineer from August 2006 to December 2006 for Emirate Bank International, Duba
• Successfully implemented FinnOne, a banking application of Nucleus Software for retail banking solution.Gather requirements from customer and accordingly preparing action plan i.e deciding which forms and reports will need to be used, what new forms and reports need to be developed, what backend code need to be developed, what shell script need to be written etc • Design the solution and develop new forms and reports Customize existing forms and reports according to client requirement. Writing SQL queries, stored procedure, Functions, Packages and database triggers are the key activities. Writing korn shell scripts to call sql scripts to generate ad-hoc reports. • Creation of program specs. Creation of Unit test plan. • Code Walk through (Standards set by Nucleus) execution--
Sr Software Engineer 12/2006 - current
Skytech Solution Pvt Ltd, Kolkata, India
Industry: IT
As Developer/Analysts/Project Lead from Dec. 2006 to Present for United Airlines USA
As Developer/Analysts/Project Lead from Dec. 2006 to Present for United Airlines USA • During the tenure in Skytech, successfully implemented the specialized knowledgebase and design methodology and quality management skill of Skytech in the projects of Schedule Design Optimization(SDO), Project and Portfolio Management(PPM), and Operation Data Store(ODS), enhanced its customer focus; sold the idea to management and delivered value to customer. • Preparation of Maintenance Request Analysis Document, Estimation, Design, Coding in SQL, PL/SQL, C, Pro*C, Unix Shell scripting, Preparation of the Unit Test Plan, Testing, Preparation of the Unit Test Result, Test case review, Peer Testing, Code review, Bug fixing, Configuration of HP PPM tool, PPM workflow and request types, Developing PPM reports and portlets. • Effective day-to-day Tracking, Reporting and Escalation to Project Manager On Time. • Tracking of Project Related Issues and Close them. • Coordinating with Client and business users to understand requirements. • Planning, Tracking and Delivery of the Project with 100% adherence to SkyTECH’s Quality Management System. • Meeting Deadlines and to ensure that 100% of delivery is with 0 Fatal and 0 Major defects and Minor within limits as specified in the Metrics Baseline Report. And to Ensure Customer Satisfaction for at least 90 – 95 % of the Deliveries • Facing Internal Quality Audit of Skytech.--
Oracle developer 10/2005 - 06/2005
Pecon Software Ltd, 08/2006, Kolkata India
Industry: IT
As developer for Damodar Valley Corporation, Eastern Railway Employees Co-operative bank, South Eastern Coalfield Ltd as client from July 2004 to October 2004 and again June 2005 to August 2006.
• Having full responsibility in developing Payroll module in DVC head quarter at Kolkata. Various ERP module of ERECBL headquarter in Kolkata and SECL in Bilaspore. Involved with full life cycle development of Payroll module. • To meet the concerned officer, understanding their requirements, designing database, developing new forms and reports, customize existing forms and reports according to client requirement. • Writing SQL queries, Stored procedure, Functions, Packages and database triggers, Data migration from flat file system data into Oracle RDBMS using SQL*Loader, Application tuning were the key activities. Involved in user acceptance testing and getting the client approval, providing user training and making the system on-line • Real achievement of this project was to make the system on-line within a notice period of one month. During this one month period the full system was coded, reports were developed and given final touch and three months parallel run was done with their legacy payroll system and old system data was migrated to new system and system was moved to production. Within a short span of time it was possible to generate pay slip through new system without running the legacy system with minimum bug and issues--
Oracle developer 07/2004 - 10/2004
Pecon Software Ltd, Kolkata, WB India
Industry: IT
Worked as developer from july 2004 to october 2004
• To meet the concerned officer, understanding their requirements, designing database, developing new forms and reports, customize existing forms and reports according to client requirement. • Writing SQL queries, Stored procedure, Functions, Packages and database triggers, Data migration from flat file system data into Oracle RDBMS using SQL*Loader, Application tuning were the key activities. Involved in user acceptance testing and getting the client approval, providing user training and making the system on-line • Real achievement of this project was to make the system on-line within a notice period of one month. During this one month period the full system was coded, reports were developed and given final touch and three months parallel run was done with their legacy payroll system and old system data was migrated to new system and system was moved to production. Within a short span of time it was possible to generate pay slip through new system without running the legacy system with minimum bug and issues--
Solutrion Analyst and Implementer 10/2004 - 06/2005
UTSO, Kolkata, WB India
Industry: IT
As solution analysts and implementer from October 2004 to June 2005
• Managed analysis, design, construction, testing, and installation of nine real-time and batch interfaces associated with ERP. • Identifying different entities of a system.and identifying attributes of the entities.and establishing relation among the entities.Creating database and maintaining the database in Mysql. • Making front-end design using HTML, java script, JSP.--

Institution of Engineers(India) 06/2000 - 12/2003
Kolkata, , India
Degree: Bachelor's Degree
Major:Mechanical Engineering
I have first completed Diploma in Mechanical engineering from WBSCTE.It took 3 yrs to complete from 1997 to 2000. Then passed Sec A and Sec B from Institution of Engineers(India)which is equivalent degree of Bachelor of Engineering in India.

PL/SQL Developer