SUMMARY

• Overall 7+ years experience in software development.
• Proficient in database and component development using Oracle PL/SQL and C/C++/VC++, ATL, COM
• 2+ years experience in Visual Basic 6.0
• 2+ years experience in SQL Server 2005 , SQL Server 2008 and Sybase
• 2+ years experience in SQL Server Integration Services (SSIS)
• 2+ years experience in Unix Shell Scripting.
• Sound knowledge in HTML, XML , JavaScript and Classic ASP.
• Experience with Oracle Database : SQL, PL/SQL 9i/10g, Triggers , Stored Procedures, Functions, Packages, Cursors, SQL Joins, SQL Subquerries, Bulk features, Partitions.
• Extensively worked on Data Modeling, Data Migration and SQL Query performance tuning.
• Developed ETL packages using BIDS as per the business requirement.
• Exposure to all stages of software development life cycle (SDLC) including requirement analysis, design, development, customizations, testing, implementation, post-live and offshore support.
• Sound Business knowledge of Banking and Capital Markets Domain.
• Excellent inter-personal skills.

TECHNICAL SKILLS:

• Languages : PL/SQL, SQL Server 2005,SQL Server 2008, SQL Server

Integration Services, Sybase, C/C++/VC++, COM,
ATL,MFC,
ActiveX, VB 6.0 , COBOL

• Operating Systems : Windows 9x, Windows 2000, Windows XP, Unix
• Servers : Windows 2000 Server, 2003 Server
• Data Bases : Oracle 9i/10g,SQL Server 2005/2008 ,Sybase
• Web : HTML, XML, JavaScript, ASP
• Design : UML, Rational Rose
• Scripting : Crystal Reports, Unix Shell Scripting
• Tools : Toad, SQL * Plus , SQL Developer , ,SQL Analyzer ,

SQL Server Management Studio, Business Development Intelligence Studio (BIDS) , Visual Source Safe.

PROFESSIONAL EXPERIENCE

Confidential, CA Jun 2009 to Sep 2010

Worked as a Senior Developer in the Trade Manager System (TMS) team with the client being
Investment Management Services–West (IMS-WEST), subsidiary of State Street Corporation

• Technology: Oracle PL/SQL, SQL Server 2005, SQL Server 2008, SQL Server Integration Services (SSIS),Sybase, VC++,ATL, COM, C++Classic ASP and XML
• Domain : Capital Markets

Worked on following enhancements for TMS:

• Maintenance Collateral : This enhancement involved adding new feature of collateral and its business rules.
• Multiple Delivery Location and Safekeeping feature for all the products. The biggest challenge was handling the design with the random changes in business rules.
• Multiclient Enhancement: This enhancement involved making code generic to handle multiple clients. Earlier version had supported only one client.

Responsibilities:

• Prepared data mapping documents for data migration and written complex stored procedures for data migration
• Extensive use of joins, sub querries and open querries to read data from Sybase Database into SQL Database
• Developed PL/SQL stored procedures, functions, cursors, triggers and packages to meet the business requirements.
• Developed new COM components and VB components.
• Worked extensively on UNIX shell scripting
• Developed new styling sheets and new screens using Classic ASP.
• Fixing UAT issues and production defect analysis.
• Impact analysis for Change controls and implementation of change requests.
• Task assignment and tracking of tasks to team member, Code review and guidance.
• Provided knowledge transfer to other team members and training to new team members
• about the project, new technology and business.

Confidential, CA Apr 2008 to Mar 2009

• Brilliant Software Solutions Inc. is a Global Systems Development and Integration company .
• Worked as independent consultant as Oracle PL/SQL Developer
• Responsibilities:
• Created Stored Procedures, functions, triggers, packages based on business requirements
• Modified existing code to achieve enhancements and change request.
• SLQ query fine tuning using Explain Plan.
• Involved in debugging and error handling.

Confidential Feb 2005 to Jan 2008

• Oracle Financial Solutions is leading IT company, developing software for Banking and
• financial sector across the globe.
• Worked as a Module Lead on the Flexcube Retail Banking Product FLEXCUBE, , providing and
• supporting state of the art retail banking products to clients all over the world.
• Technology: Oracle 9i – PL/SQL,SQL Server ,SSIS ,VC++, C++, ATL,COM Visual Basic, JavaScript, Crystal
• Reports, Win 2000, Shell Scripting
• Domain : Retail Banking

Projects Undertaken:

1. Confidential (Nov’06- Jan’ 08)

• Project Abstract: SSE is a group, which continuously undertakes release of emergency billable customization for sites that are already LIVE on Flexcube.
• Worked with senior executives to conceptualize, redesign certain Flexcube functionalities like
• Providing Bulk Uploads for Customer Addition , Loan Account Opening Screens.
• Generation of Unique Transaction Number for each transaction and maintaining a
• log of every transaction done with automated reports generation.
• Anywhere Clearing Functionality : Enable clearing functionality for any bank.
• Auto Hold Facility for Credit Cards: This enhancement included introduction of auto hold facility to ensure credit cards dues payment are done on time.
• Responsibilities:
• Design\Documentation: Developed Design Specification documents ,Unit testing plans,
• Quality Assurance for enhancement done during this period.
• Extensively involved in developing and managing PL/SQL stored procedures, functions, cursors, triggers and packages to meet the business requirements and update the existing objects based on change requests.
• Created and maintained database objects like tables, views, materialized views, indexes, synonyms and database triggers to meet the business requirements.
• Extensively worked on Oracle 9i Installation on Client environment and create new table spaces and new users and worked on exporting and importing dump files into databases
• Developed and tuned complex SQL queries for better performance
• Developed new COM components through ATL Wizard.
• Developed new Crystal Reports as per client specification.
• Online Support to YES bank ,Kotak Bank : Providing the bank with the fixes and new
• changes for the issues occurring during online transactions.
• Offshore UAT Support: Provided fixes for the Errors raised in offshore UAT.
• Involved in deployment of new enhancements for YES Bank and Kotak Bank.
• Configuration Management: Synchronization of VSS , Work Area and maintain versions of the code.
• Managed multiple simultaneous enhancements successfully meeting all timeframes. Drove 4 technically complex, large-scale enhancements from conceptual stages to delivery in less than 8 months
• Provided training on Flexcube Architecture to the new joiners.

2. Confidential (Mar’06 – Oct ’06)

• Project Abstract: Banco Austral ,South Africa required currency conversion from Old Metical
• (MT) to new currency (Mtn).
• Responsibilities:
• Defined and analyzed project scope
• Developed automated scripts and data conversion scripts for following data:
• Customer Information File, Current Accounts/Savings Accounts, Time Deposit Accounts The project had a huge impact. Handled all data migration issues

3. Confidential: (Feb’05 – Mar’06)

• Responsibilities:
• Development : Development related to the new requirements from client
• Testing : rollout as well as post rollout support of the application running in production
• Understood Flexcube Architecture, i-flex centric coding, VSS and release area maintenance.

Tricon System Aug 2003 to Jan 2005

Timesoft tracking system

• Technology: Oracle 9i, Visual Basic.
• Domain : Human Resource Management

Project Abstract: Timesoft is based on Client / Server architecture. Timesoft is used to track time of an employee against the activities / projects.

Customized the system to develop :

Automatic e-mail notifications - Team members are notified with the initial and all subsequent issue assignments to facilitate workflow automation.
Provide accurate project estimates with access to historical project reports
Access to billable targets vs. current billable hours on individual time sheets
Track multiple projects with unlimited hierarchy that are easily exportable

• Responsibilities:
• Instrumental in design and development of Timesoft System for storage and analysis of data to track the time of employee against activities
• Developed stored procedures, functions, cursors, triggers and packages to meet the business requirements
• Developed ER Diagrams to model Business Specifications.
• Created the technical specification document
• Involved in Debugging and Error Handling.

EDUCATION:

• B.E. Computer Engineering

ACHEIVEMENTS: