Objective To work in a globally competitive environment on challenging assignments that utilizes my experience on projects from conception through implementation and maintenance.

Professional Summary

• 8 years of IT experience in Financial and Welfare domains with exposure to complete SDLC.
• Expert in PowerBuilder, PFC, TSQL, PL/SQL, UNIX shell & Perl scripting, JAVA, J2EE, C++, C, Data Structures, COBOL.
• Experienced in designing, developing, and maintaining applications under Windows, UNIX and Mainframe environments.
• Skilled in writing business and technical requirements, test plans for unit and regression testing.
• Sound working knowledge of Relational Databases - Sybase, Oracle, SQL server, and DB2.
• Played key role in product go-live implementation while working on site.
• Appreciation mails from clients for meeting deadlines of the project with good quality
• Excellent record of success in meeting project milestones and developing good relationships with clients.
• Hands-on experience in Object Oriented Programming, Software Quality Assurance and Testing.
• Demonstrated proficiency in leading and mentoring team to maximize levels of the productivity.
• Ability to troubleshoot technical problems.
• Good interpersonal and communication skills, fast learner, multi tasking, and consistent performer.
• Highly adaptable in quickly changing technical environments with very strong organizational and analytical skills.

Education Bachelor's Degree in Computer Science Engineering .

Technical Skills Languages : PowerBuilder 7.0-12, JAVA, TSQL, PL/SQL, COBOL, C, and C++. E-Commerce : J2EE, JDBC, EJB, JavaBeans, Struts, Servlets, JSP. Scripting Languages : Shell, PERL, HTML, XML Operating Systems : Windows, UNIX RDBMS : SYBASE ASE 12.5, ORACLE 10g, SQL Server 2005 Job Schedulers : Autosys IDE : Eclipse, Accessory manager (IPF) Application Server : BEA Web Logic Server 8.1 Tools : Rapid SQL, IBM Lotus Notes, Perforce (source control), IBM Clear Case / Clear Quest, Remedy, SQL Advantage, Mercury Quality Center, TOAD, SQL*LOADER, WIKI, Putty, Exceed (Hummingbird connectivity). Modeling tools : MS-Visio

Work Experience

• Confidential, CA Mar 09 - Present

Domain: Welfare Title: PowerBuilder Consultant Project: LEADER (Los Angeles Eligibility Automated Determination Evaluation and Reporting System)

This project has interfaces to various Federal and State Agencies. LEADER application is designed to determine eligibility, disburse aid and maintain all social-welfare activities of the county. This project involved complex real time data processing using four Unisys Mainframes and database amounted in terabytes of data.

Responsibilities:

• Strong interaction with the client through all phases of requirements gathering, impact analysis, design and development of the LEADER welfare system.
• Developed several PowerBuilder applications using RPC functionality.
• Designed, architected, and implemented the system enhancements which utilized PowerBuilder for dynamic front end user interface. Design includes services that encapsulate all database interaction from the front end screens.
• Designed various utilities, front end screens with PowerBuilder to serve the user needs and ease the work.
• Created design documents and performed design and code walkthrough reviews with end users.
• Developed SQL stored procedures, cursors, triggers and views to support the LEADER system back end processing.
• Trained/Mentored new employees.
• Used IBM Clear Case to Check-In, Check-Out and to maintain source version control.
• Assisted the team in following the efficient coding methodologies.
• Provided assistance to QA team while testing the builds.
• Production support of welfare system.

Environment: PowerBuilder, DB2, SQLServer2005, COBOL, ClearCase (version control system)

• Confidential, CA Jan 08 - Feb 09

Domain: Investment Banking. Title: PowerBuilder/JAVA developer Project: Asset Setup and Maintenance The Asset Setup and Maintenance (ASM) application is the Book of Record for asset and pricing information. The primary functions are: asset creation, modification and pricing. ASM users are located in London and the US

Responsibilities:

• Involved in impact analysis, design, and development phases for maintaining the ASM application.
• Developed Front end windows using PowerBuilder v10.5 and PFC services with Sybase and Oracle as backend.
• Developed data flow diagrams for modules and derived use-cases from requirement analysis.
• Participated in the client review meetings.
• Created technical design documents and performed design reviews.
• Implemented OLE capabilities on PowerBuilder applications to import/export/view data in excel send mails to users.
• Developed end user reports in C and Perl.
• Developed batch jobs using Autosys to support the Day/Nightly batch cycle.
• Automated the process of pricing the securities manually by developing new Java modules with EJB.
• Developed reusable components using Java Beans.
• Implemented the Mail API service in Java and Perl code to alert the users in case of any batch job failures.
• Implemented Log4J for Application logging.
• Created Perl and UNIX scripts to launch the java modules on Web Logic application server and to generate the user reports.
• Created stored procedures, cursors, triggers, and views in TSQL and PL/SQL and modified existing ones so that the old and new functionality is supported.
• Involved in performance tuning of database queries.
• Involved in Bug fixing and enhancements of the application.
• Provided 24/7 on call production support.
• Participated in code reviews.
• Performed the defect reporting and tracking using Quality Center.
• Followed the source code check in/checkout procedures in Perforce.
• Facilitated periodic access review and participated in change review meetings.
• Created test cases and performed Unit Testing.
• Provided assistance to QA team while testing.
• Trained new members.

Environment: Sybase ASE 12.5, Oracle 10g, UNIX, Eclipse, PowerBuilder 11, JAVA, J2EE, JDBC, XML, Perforce, Mercury Quality Center, IBM Lotus Notes, Windows, Exceed.

• Confidential. Oct 04- Dec 07

Confidential specializes in providing transaction processing systems to the financial services industry worldwide. Domain: Investment Banking. Product: GLOSS (Global Settlement System) - an international real-time system which automates the trade processing lifecycle from trade capture through confirmation, clearing agency reporting and settlement.

Asia Pacific Clients: Confidential US clients: Confidential. UK clients: Confidential

Title: Senior Member Technical/ Business Analyst Project: Gloss Enhancement and Production Support Description: Project focuses on maintaining the existing settlement system “GLOSS” to support the trade processing of new securities and take up the bespoke enhancements as per client requirements. Responsibilities:

• Involved in analysis, design, data modeling, and development and support activities.
• Developed data flow diagrams for modules and derived use-cases from requirement analysis.
• Developed front end GUI screens using Power Builder for populating trade details.
• Developed Reporting GUI screens using JAVA Swing technology to display end status of trades to clients.
• Modified the server code written in C, Data structures and JAVA to support the new functionality.
• Developed Java servers to poll database and process the data using collection framework, JDBC, XML technologies.
• Developed reusable Java components using Java Beans.
• Developed shell scripts to extract data from the files received from data vendors.
• Developed PL/SQL procedures, Functions.
• Provided back end support by writing stored procedures, Cursors, Triggers, and Views in TSQL.
• Involved in optimization and performance tuning of database queries.
• Performed code reviews and mentored the team to use best methods.
• Delivered project training to the team members.
• Performed unit testing and bug fixing.
• Debugged and resolved the memory leaks issues.
• Created Integrated Test plans and performed Quality Assurance testing.
• Participated in regression and user acceptance testing at client location in Tokyo, Japan.
• Facilitated 24/7 production support after project go-live.
• Documented the functional/technical requirements.
• Defect Reporting and Tracking using WIKI

Environment: Power Builder 9, Oracle 9i, Sybase ASE 12.5, UNIX, Eclipse, JAVA, J2EE, JDBC, Swing, XML, IBM Rational® Purify, Windows.

Achievements

• Honored with ARP (Associate Research Program) award by ADP during Ippan Sai Project
• Honored with E-Recognition certificates during Ippan Sai and Clearing Project.
• Onsite experience helped me in enriching my business perspective and client interaction.