Experience Summary

Having **+ years of IT Experience in the areas of Software Development, Evaluation, Testing, Implementation, User Training and Documentation with a skill set of PowerBuilder, Oracle, Sybase, Sql Server, and Crystal Report.

Have experience in all the phases of SDLC, including requirements gathering, system design, Development, Unit testing, Integration testing, implementation and production support.

Proficient in datawindows, datawindow buffers, PowerBuilder events, Dynamic Datawindows, windows types and window events.

Proficient in Developing and maintenance of database objects like PLSQL blocks, Stored Procedures, Packages, Functions, Types, views, Triggers etc.

Analytical skills to solve complex, cross-functional and technical issues – acquired from working in different projects.

Expertise in client – server, N-Tier distributed business applications using Power Builder as front end, EAServer as Middle-tier and Oracle/SQL Server/Sybase as back end.

Experience with the version control tools like Clear Case, Star Team 2005, Plastic and SVN.

Good knowledge of UNIX and shell scripting.

Good knowledge of Oracle 8i Database Administration.

Worked onsite at client side in Oslo, Norway from June 2012 to August 2015.

Having H1-B visa valid till Jan 2019.

Having US – B1 visa valid till May 2026.

Skills Summary

Domain

Financial, Trade Tax, Healthcare, Insurance, Education

Programming Languages

Powerbuilder 5.0 to 12.0, Power script, VB Script, PLSQL, T-SQL, EAServer 5.5/6.3

Operating System / ERP Version

Windows 7, Windows XP, Windows Vista, UNIX

Tools / DB / Packages / Framework / ERP Components

Power Builder(Datawindows),

ORACLE 8i/9i/10g/11g, Sybase12.5/15.5, SQL Server 2000/2005/2008, Crystal reports (BI Publisher), Clear Case, StarTeam, VSS, SVN, Plastic

Hardware Platforms

Intel Series

Professional Certifications/ Trainings

Oracle certified Associate, DBA track (Oracle – 9i)

Brain Bench certification for Oracle PL/SQL Fundamentals (Oracle – 11g)

Work Experience

Project 1

Project Name

KMD-DANS

Team Size

18

Start Date

Nov 2015

End Date

Till Date

Project Description

DANS portal is used by university of Denmark for their education system. DANS portal is divided in two parts: One is used by student of Denmark to apply various courses at various universities in Denmark and Second Case worker portal is used by Administrator of university to administrate admission process.

Role & Contribution

Role: Project Lead

Responsible for s/w development/enhancement activities, bug fixing, build creation.

Responsible for Analysis and estimation for the enhancement proposed.

Responsible for coordination among team members and status updates to higher management.

Designing and coding database tables to store the application’s data

Data modeling to visualize database structure

Working with application developers to create optimized queries

Creating indexes to improve database performance

Programming packages, views, stored procedures, Triggers and functions

Reviewing query performance and optimizing code

Technology & Tools

Oracle ADF, ORACLE (VPD), PL/SQL, SVN

Project 2

Project Name

Nets –BFS (Baxbis)

Team Size

8

Start Date

May 2012

End Date

Oct 2015

Project Description

Nets is among the largest companies in Northern Europe in the market for payment cards, payment solutions and the exchange of payment information.

Baxbis is used for registration and activation of new merchants. It is also used for administration and maintenance of existing merchants. Baxbis maintains all terminals related information. Application is on 3-Tier architecture.

Role & Contribution

Role: Project Lead

Responsible for coordination among team members and status updates to higher management.

Responsible for s/w development/enhancement activities, bug fixing, build creation.

Responsible for Analysis and estimation for the enhancement proposed.

Developed related PowerBuilder objects like (windows, datawindows, UserObjects) and Database Objects like (Stored Procedures, triggers, functions, cursor, types, Tables, views etc.) using Sybase.

Responsible for testing and user acceptance for the changes and enhancement proposed.

Wrote complex SQL queries using joins, sub queries and inline views to retrieve data from the database.

Worked on tasks which requires to work on Batch scripts, SFTP implementation, UNIX scripts.

Technology & Tools

Power Builder 10.5, Sybase 15.5, EAServer 6.3, Unix, SFTP, Red-mine, SVN

Key Achievements

Successfully implemented application towards 3-tier architecture by removing lot of 2-tier architecture related code.

Project 3

Project Name

iWORKS - Reinsurance

Team Size

11

Start Date

April 2010

End Date

May 2012

Project Description

ProCede and ProSume are two existing products for the reinsurance domain. SunGard’s iWORKS solution enables insurance and reinsurance companies to manage all facets of their ceded reinsurance process.

Reinsurance is a contract of insurance whereby one insurer (called the reinsurer or assuming company) agrees, for a portion of the premium, to indemnify another insurer (called the reinsured or ceding company) for losses paid by the latter under insurance policies issued to its policyholders.

Role & Contribution

Role: Technical Lead – Product Development

Responsible for s/w development/enhancement activities.

Responsible for project planning and resource management.

Client interaction and team interaction

Responsible for Analysis and estimation for the enhancement proposed.

Responsible for testing and user acceptance for the changes and enhancement proposed.

Wrote extensive SQL and PL/SQL Procedures, Functions

Responsible for mentoring Team members.

Created documentation. Gathered requirements, wrote technical specifications, workflow diagrams.

Testing: Created and executed test cases. Ensured bugs are logged and tracked through closure.

Used Star Team and Plastic to check-in code and baseline progress for code changes.

Technology & Tools

Oracle 10g/11g, SQL Server 2005/2008, Power Builder 11.0/12.0, Star Team 2005, Plastic (source control), OnTime (Manage defects and tasks)

Key Achievements

Successfully implemented functionalities which involves visual and non-visual user objects, complex windows and writing new procedures using bulk collect etc.

Project 4

Project Name

Order Management System

Team Size

15

Start Date

Sep 2007

End Date

Mar 2010

Project Description

OMS (Order Management System - FLASH) is an application which is used for the order management of funds and supports the EIS (European Securities Services) business activity for BP2S.

An investor approaches a distributor (network) directly or through an agent to buy or sell funds and places an order accordingly. The distributor sends the orders electronically, in the form of swift messages or through fax to the LTA (Paribas branches at different location).

The LTA enters the orders (dispositions) into the Flash application and depending on the setting at the UCITS level and the Fund level, the NAV, tax, fees etc is calculated for the dispositions.

Role & Contribution

Role: Information Analyst

Responsible for s/w development/enhancement activities.

Responsible for Analysis and estimation for the enhancement proposed.

Responsible for testing and user acceptance for the changes and enhancement proposed.

Responsible for writing Queries, Procedures, Functions and Triggers as required.

Used Materialized views to reduce network load and improve performance.

Optimized and Tuned SQL statement through Indexes.

Responsible for mentoring Team members.

Responsible for Unix and shell scripting part also.

Technology & Tools

Oracle 10g, Sybase12.5, UNIX, Power Builder 9, Shell scripting, Star Team 2005

Key Achievements

Worked on reports using materialized view as a base and that involves writing procedures, functions etc.

Project 5

Project Name

Generic Origination Engine

Team Size

12

Start Date

Mar 2006

End Date

Sep 2007

Project Description

GOE (Generic Origination Engine) was developed by EDS to replace OS (Origination System) for all EDSCS users. Note that OS is still used in Westpac Branches to create new loan applications. Although OS and GOE are different applications they basically have the same functionality.

GOE is used to progress loan applications for a specific EDS Tenant (eg Westpac) from the initial customer application through to Settlement. This is managed by progressing though different status levels for each application (3 Tier Architecture)

Role & Contribution

Role: Information Analyst

Responsible for testing and user acceptance for the changes and enhancement proposed by EDSCS.

Responsible as Team Leader of Development for leading a team of 12.

Created/Altered/Dropped Tables, Views and Indexes as per business requirement.

Performance tuning of SQL queries using Indexes.

Responsible for writing Queries, Procedures, Functions and Triggers as required.

Responsible for mentoring Team members.

Technology & Tools

ORACLE 9i, SQL, PL/SQL, Power Builder 8, EAServer 5.5, UNIX

Key Achievements

Implement lot of functionality using 3-tier architecture.

Project 6

Project Name

Enterprise - Real Time System (COMFIN – GE)

Team Size

10

Start Date

Nov 2005

End Date

Mar 2006

Project Description

GE Commercial Finance offers an array of financial services and products worldwide. With a particular expertise in the mid-market segment, GE Commercial Finance provides loans, operating leases, financing programs and other services.

Enterprise ensure the provision of substantially enhanced services to clients, major improvements in productivity and enhanced risk management. This will provide GE with a powerful and comprehensive platform on which to base its business as it moves into the twenty-first century.

Enterprise’s Risk Management functionality aids GE to collect and maintain information about clients, debtors and facilities in order that all risks arising from an GE investment may be understood and evaluated

Role & Contribution

Role: Senior Software Engineer

Application support (Tickets) and Development of new modules and new Change requests.

Mainly involved in Backend development using SQL Server.

Developed the Test scripts for the new functionality added.

Testing the new business logic.

Responsible for Database Administration.

Responsible for mentoring Team members.

Technology & Tools

SQL Server 2000, SQL, PL/SQL, Power Builder 7.0

Key Achievements

Worked on complex windows that comprises of complex Powerbuilder scripting, windows using procedures and writing procedures.

Project 7

Project Name

Surgery (AdvantX) for Source Medical

Team Size

5

Start Date

Feb 2005

End Date

Nov 2005

Project Description

Source Medical is the world's leading provider of outpatient information solutions used in more than 3,200 healthcare facilities in USA. As an application outsourcing partner TechSpan would be engaged in providing enhancements & maintenance support for Source Medical applications.

AdvantX® is a fully integrated package of information management tools pertaining to the various areas of healthcare organization developed by Source Medical Solutions, Inc. It enables healthcare providers to quickly and easily collect information about their patients using the latest computer technologies, dramatically reducing paperwork and errors associated with more traditional methods of medical documentation.

The package is meant for small and medium industry and looks into the following areas of the healthcare organization:

* Practice Management

* Surgery Center

* Surgical Hospital.

Role & Contribution

Role: Consultant

Application support (Tickets) and Development of new modules and new Change requests.

Developed related PowerBuilder objects like (windows, data windows, User Objects) and Database Objects like (Stored Procedures, Tables, views etc. ) using Sybase Transact-SQL.

Developed the Test scripts for the new functionality added.

Testing the new business logic.

Object integration and deployment of code in QA environment ( PBD, PBR, DLL, and EXEC).

Responsible for Database Administration.

Technology & Tools

Power Builder 6.5, SQL, PL/SQL, SQL Server 2000

Key Achievements

Develop functionality to register patient which involves many procedures, functions and triggers.

Project 8

Project Name

COMITRAX (COMputerized Information system for TRAde taX) Phase 1 and Phase 2

Team Size

10

Start Date

Oct 2003

End Date

Jan 2005

Project Description

UP Trade Tax (UPTT) Department is responsible for collection of Trade Tax on sale or purchase of goods for the state of Uttar Pradesh. These are required for internal and external agencies (such as Dealers, Transporters) related to tax assessment, collection. Also the transfers, amendments and cancellation of dealer registration and monitoring of unregistered dealers are required.

Role & Contribution

Role: Module leader

Responsible for Development & Testing of sub-systems of COMITRAX.

Participated in requirement collection, analysis, designing a new module.

Developed related PowerBuilder objects and GUI for the new module.

Developed the business functionality using Power script, and Oracle PLSQL.

Support to the team in various activities during, Development and Implementation of project.

Client support during acceptance testing and Implementation.

Used import, export utility to transfer data.

Responsible for Backups and Recovery of database.

Responsible for Database Administration.

Involved in User training and developed user manuals, help files.

Project monitoring and control throughout the development and implementation phase.

Technology & Tools

PowerBuilder 5.0, Oracle 8i, Oracle 9i, Jdeveloper, Windows NT.

Key Achievements

Handled some of the modules as Registration, Assessment and Payroll independently.

Educational Qualification

Education & Credentials

Master of Business Administration with specialization in Information Systems.

Bachelor of Engineering with specialization in Electronics.

Three years diploma in Russian language.

Contact this candidate