EXPERIENCE SUMMARY

• Years of experience in the field of Information Technologies primarily with application software design, management, and development in Confidential years of finance sector experience with Deutsche Bank, Singapore.
• Around Confidentialdevelopment and support for web based ASP .Net applications.
• Experience in Migrating PowerBuilder applications to .Net.
• Hands-on experience in migrating back-end databases from Sybase to Oracle along with PowerBuilder applications.
• Good exposure to offshore-onsite model.
• Extensive experience in Project management, Business Analysis, gathering requirements from business users, writing requirement specifications, functional specifications, low level design, test plan, impact analysis, estimations, creation of project charters, allocation of tasks to team members, development, code review, demonstration, and user training.
• Excellent Written Verbal Communication Skills.
• Experience in Visio to draw process flows and system diagrams.
• Good experience in Migration PowerBuilder applications to higher versions.
• Hands on experience in working with Appeon to convert PowerBuilder applications to WEB.
• Excellent OOAD/OOPs/SSAD/SDLC skills.
• Hands-on experience in DBA Activities for Oracle NT AIX/UNIX , Sybase Adaptive Server MS SQL Server2k NT/ 2k .

• Defined and administered database/programming standards, controls, procedures and documented the same.
• Good experience of SQL, T-SQL, PL/SQL, UNIX, Shell scripting, Pro C/C , VB, and ASP .Net.
• Hands-on experience creating/maintaining stored procedures, packages, triggers, views, and all database objects.
• Experience in interfacing applications to various other applications using MQ-Series and database links or by ftping the files using MIT Kerberos or SSH Putty.
• Experience in maintaining the source code and Automating Release processes.
• Worked on almost all the finance AR/AP/GL , sales distribution and material management modules in in-house developed ERP System.
• Experience using Agile methodology during SDLC.

TECHNICAL SUMMARY :

Role: eServices Manager, Technical project lead, Sr. Powerbuilder Developer, System/Business Analyst.

Responsibilities:

• Manage eServices
• Agile methodology, project scheduling, and management using PPM.
• Develop Project Plans, create schedules and Gantt charts using PPM.
• Attain Bi-weekly PMO meetings to update on project status to Directors, CTO VP.
• Gather Requirements from Business Users for all the enhancements refinement of business and technical requirements.
• Prepare requirement specs, project charters, functional specs, Low Level Design, and test plans.
• Organize and coordinate weekly reviews of new development requests and their prioritization
• Provide estimates, discuss, and get approved from associated stakeholders/business sponsors.
• Enhancement, Bug Fixes Maintenance to current PB and .Net applications.
• Preliminary research of a technical problem.
• Maintain overall development schedules and coordinate releases and deliveries with other interfacing systems and groups including Operations and Business Development.
• Direct reporting to Director.
• New application development in ASP .Net.
• Migration of PowerBuilder application to ASP .Net.
• Designed and coded COM/COM objects for hiding connection details and business logic.
• Migration of Sybase to Oracle database with front-end changes in PowerBuilder.
• Primary and only contact for all rational Clearquest and RequisitePro applications.

Databases Used:

• Oracle, Sybase, MS SQL Server 2008/2012, and MS Access.

Tools/Technologies Used:

• Powerbuilder, Visual Studio, Rational ClearQuest, PVCS, PPM, Rapid SQL, TFS.

Projects currently working on:

• Confidential
• Timekeeping for Consultants/Contingents TKC Time Management for Consultants/Contingents/Contract employees.
• Timekeeping for SCA Employees TKS Time Management for SCA direct employees.
• Timekeeping OverTime Reports TKOT Reporting application which calculates overtime, unpaid leaves based on timesheets entered in TKS. Its also generates ADP or Ceridian export format files for over time, students and unpaid leaves payment.
• Timekeeping Reports TKReports Application to provide various kinds of reports for SCA employees based on Timesheets entered in TKS.
• Timekeeping System Admin TKSA Application to manage SCA Employee information.
• Labor Law Application used for auditing the contract works done for SCA.
• Summer Internship Program SIP Application to maintain information about all students who are on SCA summer internship.
• Facility Inspection FID / BCC Application to maintain details about all the contracts between SCA and general contractors.
• FleetWin Application for fleets' management developed for Administration department.
• Locator Nightly Nightly job for extracting data from Oracle database and Importing for Sybase based application.
• Civil Services Application to maintain Civil Services details for employees.
• SCA Directory Application to provide SCA Staff information.

Confidential

Cellphone Bill Distribution System CBDS Application developed to get relevant data in MDB file from CD given by NextTell and distribute call activity details to each Cellphone user and corresponding department secretaries through email.

• eFleet Fleet Management Application. Migration from PowerBuilder FleetWin application to .Net
• eTime Reports A reporting application for time tracking developed in ASP .Net
• eTime OverTime Time tracking and overtime system being rewritten in ASP .Net from rational clearquest.
• eHire Contingent/Consultants/Temp staff hiring application from requisition to hire and separation that's being rewritten in ASP .Net from rational clearquest.
• eDigitalSign System that maintains approval workflow for displaying any kind of information on digital boards across SCA building. It's been rewritten in ASP .Net.
• eExpense Expense claiming system for SCA employees being rewritten in ASP .Net

Rational Rose and Clear Quest Enhance, Maintain, and Support :

• Clear Quest User Administration.
• eTime Consultant, temp, and contingent staff Time Tracking System.
• eOverTime - Consultant, temp, and contingent staff OverTime Tracking System.
• eExpense Employee's expenses Management System.
• HR-TAF HR Temporary Action Forms. Requisition to Exit
• Defect Tracking System: Application to track all defects in any system.

Role: Analyze, bug fix, and enhance.

Responsibilities:

• Get list of issues or problems associated with the application from the coordinator.
• Provide estimations, discuss get approved from Director.
• Tele-communicate and discuss with other team members.
• Install new EBFs.
• Enhancements, Bug Fixes Maintenance to current PB 12.5 Classic MS SQL Server 2012 application created for Doctors Office.

Role: Business Analysis, Lead developer, Team Leader, Onsite Coordinator.

Responsibilities:

• Gather Requirements from Business Users for all the enhancements.
• Prepare requirement specs, MPP, functional specs, Low Level Design test plans.
• Provide estimations, discuss get approved from Project Manager.
• Communicate, discuss allocate tasks to team members.
• Enhancements, Bug Fixes Maintenance to current PB .Net applications.
• Migration of PB versions from v6.5 to v11.
• Conversion of current PB application to WEB by using Appeon for PowerBuilder.
• Quarterly Maintenance of application ids for all the applications.
• Maintain Sarbanes-Oxley SOX compliance documents for all the application.
• Directly reporting to Project Manager.
• Onsite coordinator and support for .Net applications and help in move-ups.
• Involved in Migration of PowerBuilder application to .Net.
• Involved in Consolidation of 2 database and functionality to web-based application its database.

Environment : PowerBuilder with PFC, SQL Server 2000 2005, Oracle 9i, Windows 2000/XP, Microsoft Visual Studio 2003/2005, .Net framework 1.1 2.0, connect direct.

Projects worked on:

Confidential.

COU Tracking a .Net 1.1 application is built on Inventory Control System ICS a PowerBuilder application. The ICS/COU Tracking Application is an account, policy, transaction and user work queue function point measurement tool. The application allows for account, policy, transmittal, task, user work logging, reporting, administrative functions bulk import of transmittals by using Excel worksheet to tab delaminated text file in support of ACE Risk Management Workers Compensation Business.

Confidential

FAST/PAT a .Net 2.0 application is built on PAWMS-WC PAWMS-AC a VB Application.

The integrated Premium Audit Application is a web based application that provides its users all the functionality that is presently required by ACE for policy audits. It integrates the functionality currently available in the existing standalone applications: PAWMS, PAWMS Assignment, PAWMS Reports and PAW to give a unified view of the different systems where users can access the appropriate functionality based on their access rights. Users have the ability to assign audits, manage assignments, track audits and view detailed reports. This system also support offline auditor activities

Confidential

Non-Eis Entry System NEES Account Level Productivity System ALPS are PowerBuilder applications. NEES is used for data-entry for Non-EIS transactions for every policy the feeds are sent to different interfacing applications via Attachmate and direct connect whereas ALPS is a pricing tool which helps an underwriter to arrive at a price for a new policy. ALPS maintain set of support tables which contain various pricing factors. These factors are external to ALPS i.e. ALPS cannot modify these factors. However ALPS rely heavily on these factors for pricing a new policy. They have to be updated from time to time to insure that the price ALPS determines for a policy is accurate.

Role: System Analyst

Responsibilities:

• Coordinate and develope asp.net web services to interface with Powerbuilder application.
• Used Web Service Proxy to interface between Powerbuilder applications and web services using SOAP client.
• Used DDE Dynamic Data Exchange to pass data to other applications running like telephony.
• Conduct meetings with Airnet personnel for capturing requirement, synchronizing code and testing.
• Prepare release documents Migration Tasks, Technical Specs, Functional Specs, Test Cases.

Environment : PowerBuilder 11 with PFC, Informix/Oracle 10g, Windows 2000/XP, JAVA, .Net.

Features Used : Web Service Proxy Using SOAP Client

Project: Ontime For Airnet, Columbus, Ohio

Ontime is Powerbuilder based application used by customer service officers in Airnet. This application is used for tracking all the shipments since alerting customers and pickup till the delivery of shipments and generation of invoices. System is integrated with webserver to calculate cost for each shipment based on distance, pickup, line-hauls, recovery and events. At the same time, estimate the cost for each courier while allotting the shipment for dispatch/drop-off or delivery.

Role: System Analyst, Team Leader, Development, Maintenance Support of in-house developed ERP system, Migration DBA Activities.

Responsibilities:

• Worked on all cycles of Software Development Life Cycle SDLC .
• Developed export functionality in PB to export all types of complex PowerBuilder reports to different types of files viz. Excel and PDF.
• Developed a functionality to upload and download any type of file to and from the system.
• Worked on all security related modules in PB including password encryption, password expiry, invalid logins, in-active session to maintain minimum password criticality.
• Used Windows DLLs to create external functions to display icon in System Tray and alert users when something is pending for them.
• Developed dynamic import facility for updating stock master Using Datawindow object hide/show and set position attributes.
• Developed generic Users Objects to make the user interface unique.
• Created scheduler in PowerBuilder to export and then send the mails to users on a scheduled time by them.
• Used PowerBuilder Source Control for version controlling.
• Developed dynamic reports using dynamic datawindow creation based on users specification.
• Fine tuned PowerBuilder code database procedures/views/triggers/functions. Created many backend procedures to make the client thin to improve the performance.
• Done Migration of Data from Oracle to MS-SQL Server. Used extensively Pipeline for migration.
• Worked on finance, sales distribution and material management modules.

Project: In-House Developed ERP System:

• System developed to take care of day to day activities for Excelpoint and Lights Sister Company .
• It includes modules for Finance Accounts Receivable, Accounts Payable, General Ledger, Customer creation , Sales and distribution Quotation, Sales order, Blanket Order, Forecast, FAE, Inventory And Material Management Purchase Request, Purchase Order, Stock Master Modules.
• This system is currently used extensively in Singapore branch and by mangers in all over the world. Process is in progress to implement it in all the branches starting from India branches.

Role: System Analyst, Development, maintenance support, Team Leader Application DBA

Project: DB-Cheque

Db-cheque is a cash management software for payments. It is used for printing cheques, advices, payment details, with-holding tax certificates and related documents. It also reconciles cleared cheques and calculates float. It has online accounting entries, straight through processing and double byte support. It is parameterized to support the different business needs of various branches.

Responsibilities:

• Used DDE Dynamic Data Exchange to pass data to other applications running.
• Used RPC Remote Procedure Call to call Oracle objects from Powerbuilder.
• Migrated PowerBuilder 7 to 8 and then to PowerBuilder 9 version And Oracle 8i to 9i.
• Created oracle procedure using java to send mails and execute OS commands.
• Used data loader to load bulk files in oracle database.
• Used Data Junction utility to create dynamic upload format to db-cheque system.
• Automated release process using shell scripts.
• Maintenance of Control-M for EOD SOD jobs.
• Used MQ-Series to interface with other applications for send/receive messages.
• Meeting with interfacing application teams for regression as well as integration testing.
• Prepare release documents Viz. Release Letter, Change Request, Test Cases, Release Control Form functional as well as technical specifications.
• Maintain PVCS for objects viz. sql, .java, .class, .pbl, .doc, .sh, .ora, .c, .dll and application related objects.
• Conducting interviews.

Environment : PowerBuilder 7/8/9 with PFC, Oracle 8.1.7.4/9.0.2.5, Shell Scripts, Pro C, Windows 2000/NT/XP, AIX 5.1, JAVA, MQ-Series, D2K Forms Reports.

Features Used : Toad, PL/SQL Developer, PVCS, Timbuktu Pro, MIT Kerberos, SSH Putty.

PROJECT: DB-ACCOUNT PLUS

Db-account plus is used for maintaining accounts of DB customers customer. This is value added service provided to DB customers to maintain balances of their customers. Its customer based and was used once at a time for a customer. Their were two instances of this application, one was used by branch users and another was used by customers to download the files from DBI Host and see the balances for all the customers.

Responsibilities:

• Re-written application in PowerBuilder and Oracle. All shell scripts, Pro C/C , procedures and triggers were re-written.
• Migrated PowerBuilder 7 to 8 and then to PowerBuilder 9 version And Oracle 8i to 9i.
• Involved in packaging the application to install on users desktop.
• Taking care of enhancements right from meeting with business users.
• Prepare Technical and Functional Specifications and assign the tasks to team members.
• Meeting with interfacing application teams for regression as well as integration testing.
• Created shell scripts for taking periodic backups Data Non-Data and restore it on demand.
• Involved in Disaster Recovery and high availability tests.

Environment: PowerBuilder 7/8/9 with PFC, Oracle 8.1.7.4/9.0.2.5, Sybase Adaptive Server, Shell Scripts, Pro C, Windows NT/XP, AIX 5.1, MQ-Series.

Features Used : Toad, PL/SQL Developer, PVCS, Timbuktu Pro, PC-DUO, MIT Kerberos, SSH Putty.

PROJECT

BCA is a client-server system, which addresses the business requirements in the customer service department. It is integrated with the financial devices like Cash Dispenser, Validator, Cheque Encoder, and MICR readers, thus reducing the turn around time per transaction resulting in quicker and better service.

Responsibilities:

• Worked on Distributed Powerbuilder.
• Used External DLLs to interface with Power Encoder, Cash Dispenser, MICR Reader and Validator.
• Migrated application from NT box to UNIX box in centralized environment.
• Fine Tuned PowerBuilder application to enhance performance with centralized UNIX server.
• New shell scripts and backend procedures were re-writen to work on UNIX box in centralized environment.
• Prepare Technical and Functional Specifications and assign the tasks to team member.
• Migrated PowerBuilder 7 to 8 and then to PowerBuilder 9 version And Oracle 8i to 9i.

Environment: PowerBuilder 7/8/9 with PFC, Oracle 8.1.7.4/9.0.2.5, Shell Scripts, Windows 2000/NT/XP, AIX 5.1, MQ-Series.

Features Used : Toad, PL/SQL Developer, PVCS, Timbuktu Pro, PC-DUO, MIT Kerberos, SSH Putty.

The APLOCS application is designed on a networking environment to handle and process the stubs and cheques primarily with the use of images and automatic data gathering techniques. The process automates the data collection process from the stubs and the cheques wherever possible minimizing the time taken to key enters data manually by using eflow. In Power Encoding module, APLOCS will encode, endorse and stamp the cheques and send the physical cheques to the clearinghouse for non CTS branches and for CTS branches, it creates CD for ACH or it sends feed to FeCTS which then transmit the images and data via net.

Responsibilities:

• Used External DLLs to interface with imaging software Pegasus, Scanner and Powerencoder.
• Used Window DLLs to get system specific information.
• Maintain and support the application.
• Coordinating with Vendor to get enhancements on time.
• Setup SQL Server for new branches.
• Create/Attach/Backup/Restore MS-SQL Server database.
• Hardware setup for Scanner and Power Encoder.

Environment: PowerBuilder 7/8/9/10.5 with PFC, MS-Sql Server, TiS-eflow, Windows 2000/NT/XP.

Features Used: PVCS, Timbuktu Pro, PC-DUO, SSH Putty.

PROJECT: SIGNET

A regional signature verification system used for archival and retrieval of Signatures. It interfaces with various applications for inward clearing process, running all across Asian branches. The Servers were consolidated and centralized in Singapore and India to cater the regional operations. The Signet data is made centrally available across branches via SQL server replication. Has interface to FeCTS to check signatures of all the customers.

Responsibilities:

• Used Confidentialto restrict users from copying any signatures.
• Used Files, SelectBlob Confidential to retrieve and update Signatures in Confidential.
• Interface with almost all the banking applications in Confidential.
• Maintain and support the application.
• Coordinating with Vendor to get enhancements on time.
• Setup SQL Server for new branches.

Environment: Powerbuilder 9.0/10.5 with PFC, MS-SQL Server, Windows 2000/NT/XP

Features Used: Timbuktu Pro, PC-DUO, SSH Putty.

Project: FeCTS

Vendor application used to cater for all four legs of CTS. Viz. Outward Clearing, Inward Clearing, Outward Return, Inward Return. It gets feed from Aplocs application for Outward Clearing and transmits data and image files to Clearing House by using smart card authentication. Same way it can download Inward Clearing and Inward Return details from Automated Clearing House ACH . Signet is interfaced to verify signatures for Inward Clearing.

Responsibilities:

• Maintain and support the application.
• Coordinating with Vendor to get enhancements on time.

Environment: FeCTS Proprietary database, Windows 2000/NT/XP.

Features UsedConfidential, PC-DUO, SSH Putty.

PROJECT: IBM ONDEMAND, IDM

Its image archival/retrieval system. Application used to archive any kind of images reports. Banks used to archive all kinds of documents viz. Account opening documents, all instruments like cheques/DD etc.

Security Admin: Administrator utility is used to create users, user groups, security groups and folders.

OnDemand Client is used by DB internal users.

Project: db-image

It's a web based application, using the OnDemand Database. This application is used by DB customers over the net by connecting via db-RAS.

Responsibilities:

• Maintain and support the application.
• Coordinating with IBM to get service for their product.
• Prepare release documents Viz. ConfidentialLoading feeds taken from APLOCS by using Perl and VB.
• Scheduling jobs to write images and data to WORM diskettes.
• Grant access to users to connect to their respective branches to see the archived images.

Environment: IBM OnDemand, VB, DB2, Perl, JSP, Windows 2000/NT/XP.

Features Used: Remote Desktop, JukeBox OnDemand Server to store WORMS .

PROJECT: COOL ARCHIVING OF REPORTS/IMAGES/DOCUMENTS

COOL a vendor application is an Archiving solution. Documents are stored in WORM media, which supports long-term archiving and retrieval. COOL is indirectly a part of the branch workflow where documents/reports are archived. Cool is used by branch users to retrieve the archived documents/reports. Some of the documents archived in COOL are Account Statements, Reconciliation reports, Payment Advices, Transaction Reports, End of day reports from various applications, Fax Images, etc

Responsibilities:

• Maintain and support the application.
• Create templates for all new report formats.
• Prepare release documents Viz. Confidential Loading feeds taken from almost all the applications in DB by using Perl and shell scripts.
• Scheduling jobs to write images and data to WORM diskettes.

Environment: Perl, COOL Proprietary Software, Windows 2000/NT/XP, AIX

Features Used: Remote Desktop, JukeBox OnDemand Server to store WORMS .

Role: Associate Consultant/Team Member.

Responsibilities:

• Develop, Maintain and support the application.
• Worked on, corporate level introduced between PFC and PFE called as PFG.
• Accepting inputs from mainframes and then formatting it in a specific format as required by the system.
• Coordinating with onsite coordinator at Chicago to gather requirements and discuss day to day issues.

Environment: DOS Batch Job Scripting, PowerBuilder 6.5, MSSQL Server Ver 6.5,Oracle 8i, Win 98, UNIX Shell Scripting.

Features Used: Toad, PL/SQL Developer, PowerBuilder Source Control.

Project: Apptracker For Household, USA

It consists of multiple applications each having unique entry method that is not related to main application. It registers a loan application into the system and tracks it until it has been boarded or settled. It provides functions to track documents and monies, create an extract file to automatically board loans to CPI via ELI, System security, report generators and some administrative file functions.

Role: Sr. Software Engineer/Project Leader, DBA Activities.

Responsibilities:

• Written external function to use third party Sulipi DLLs to allow enter and view the data in 9 different Indian languages.
• Used Bar Codes to read from the book labels. Bar code labels were generated from the system.
• Generic Coding for Sybase as well as Oracle.
• Develop, Maintain Support the system installed at about 13 clients all over the India.
• Project planning and Allocation of tasks to team members including myself for enhancements.
• Application training and implementation.
• Install Oracle, Create Database and implement the application in new organizations.
• Migration of Data from Sybase Adaptive Server to Oracle 8i. Pipeline was used to import data.
• Conducting interviews.

Environment: Oracle 8.1.4, PowerBuilder 6.0, Sybase Adaptive Server 11.5, Windows NT/95/98

Features Used: Toad, PL/SQL Developer, PowerBuilder Source Control.

Project: Total Library Management System Multilingual System

Application developed for Libraries. It takes care of books Inventory, Circulation, Acquisition, Periodical Transactions, Reports, Masters and have multilingual functionalities.

Role: Sr. Software Engineer/Team Leader, DBA Activities.

Responsibilities:

• Used Pipe Line Object to transfer data from one branch to another through modem.
• Used OLE Control to display documents/images stored in database.
• System Analysis, Design, Coding, testing Implementations.
• Training users and new team members.
• Client Interaction, Requirement Capture and allocation of task to team members and myself.
• Conducting interviews.

Environment: PowerBuilder 5/6.0, Sybase SQL Anywhere 5.0, Oracle 7.x, Windows NT, Windows 3.x/95/98.

Features Used: PowerBuilder Source Control, Install shield.

Project: Safeguard

Application developed for Security Guards Private Detective Agencies. Billing, DA/SA Arrears, Salary Computation, reports generation Inc. PF/ESI returns, Profit Loss Statement , salary billing comparisons using graphs.

Project: Placevel

Application for placement offices.Coding for best matches of candidates, reports generation Resume, covering letter, interview call

Hubs Management System:

Software Developed for Thermax Culligan. Receipt generation, invoice generation, generation of sales order form SOF , tracking of lost/void/unused SOF, reports generation User Defined .