Powerbuilder & Sql Server

Page*

Rekha rani

Technical Lead at HCL Technologies

**************@*****.***

Summary

Over past 12+ years held multiple roles as a Systems Analyst, Technical Lead, Applications Developer, PowerBuilder Consultant, Software Engineer and across variety of business industries. In these roles I have provided client/server and relational database solutions utilizing PowerBuilder, Oracle, Sybase, Db2, SQL Server and UNIX scripts.

Technology Experience

#PowerBuilder 5/6.5/8/9/10.5

#Oracle 8/9/10, Sybase ASA, SQL Server, DB2

#UNIX (AIX & Sun Solaris)

Experience

Technical Lead at HCL Technologies

November 2013 - Present (3 years 3 months)

Working for Parker Hannifin Corporation, currently playing the role of onsite Coordinator. This project is ecommerce implementation project, Parker is in the process of implementing end to end ecommerce solutions for all its divisions. So major CR and enhancement are coming in this, they are customizing IBM WebSphere commerce as per their business requirement. As a part of this ecommerce implementation, they are also consolidating the catalog information of all its division under one centralized database. So that they can sell the products of all their divisions globally. Responsibilities:

• Gatharing business requirement and design effective IT solution. .

• Helping team members in understanding the requirements.

• Guiding development team technically and functionally for new functionalities and project.

• Creation and execution of work plans for projects & CR.

• Management of overall integration testing and UAT bugs and tracking them to closure.

• Mentoring of team members and arranging internal training in the team.

• Development of many backend processes for consolidation of data in centralized database. Technical Lead at HCL Technologies

Page2

November 2012 - October 2013 (1 year)

EMI is the world's leading independent music company. As an owner of digital music content, EMI is extremely well positioned to capitalize on the rapid growth of Digital Music. EMI project is all about developing, maintaining and supporting various applications for smooth Running of EMI Music. This project compromises of 145 Applications. I was leading PARS Track. There are 8 applications under the PARS (Product, Assets and Rights systems) track. These applications are categories in platinum, gold, silver and bronze. Technologies uses in PARS application are PowerBuilder, SQL Server 2005, BizTalk 2010 etc. Mainly we are managing maintenance and support work of these applications. Responsibilities:

• To gather business requirements from client.

• Analyze the requirements of business and prepare WBS.

• Prepare High level design, Unit test script and Integration testing script.

• Take business sign-off on requirements.

• Prepare low level design for team and help the team in development. Technologies Used :

Operating Software : Windows

Tool / Languages : PowerBuilder 9/10.5, SQL Server Reporting Services, Crystal Reports, InstallShield Ticket Tracking : Remedy

Databases : Sql Server 2005

Team Lead at HCL Technologies

May 2008 - November 2012 (4 years 7 months)

This project is maintenance and support project of DPSG. DPSG is a large beverage company of USA. Large number of enhancement also come in this project, as they are using legacy systems so lot many changes are required from time to time.

This company is a leading global provider of beverage products. With approximately $6 billion in annual revenue, Its world’s third largest beverage company Responsibilities:

• To gather business requirements by meeting with the concerned users.

• Analyze the requirements of business and prepare WBS.

• Prepare High level design, Unit test script and Integration testing script.

• Take business sign-off on requirements.

Page3

• Prepare low level design for team and help the team in development.

• Review and testing of the changes.

• Working on tickets raised by business user, it may include data setup or analyses or break fix. Technologies Used :

Operating Software : Windows and UNIX

Tool / Languages : Toad, PL/Sql Developer, WinScp, Putty, Power builder, Shell Scripting Databases : Oracle 8i/9i/10g

Senior Software Engineer at HCL Technologies

September 2007 - April 2008 (8 months)

The project is to support the separation of company by cloning several non ERP NCR applications and associated databases for the new company.

This involved many sub-tasks including reconstruction of production executable for which there were no baselines or identified production code, cleansing of numerous databases, migration of production code to latest versions and consolidation of databases.

It also includes the migration of PB application from PB6.5/8.0 to PB11.0 and migration of database from Oracle 8i to oracle 10g.

Post production roll out support is also a part of this project. Responsibilities:

• To study the applications which need to be cloned for new company i.e. Teradata.

• Interact with business users to gather information about the applications.

• Compilation and reconstruction of executables for applications.

• Cleaning of their database, so they will be ready for use by new company.

• Migration of Power builder application from PowerBuilder 6.5 to PowerBuilder11.0

• Migration of database from Oracle 8i to Oracle 10g. Technologies Used :

Operating Software : Windows and UNIX

Languages/Tool : PowerBuilder 6.5/8.0/11.0, Toad, Pl/Sql Developer Databases : Oracle 8i/10g

Software Engineer at HCL Technologies

September 2006 - August 2007 (1 year)

During this period, i worked on a product name "SSA Exceed - Warehouse Management System". Page4

This project is development cum enhancement project, This is related to the warehouse management system of SSA exceed company. As part of this project i worked on many change requests related to different module with fixed timelines.

Responsibilities:

• Implemented “Close ASN” functionality in Receipt Confirmation.

• Implementation of interface for SKU import.

• Reports had been customized to requirements.

• Worked on the facility of accepting some Special characters.

• Worked on adding print function for key fields in Wave, Sale Order screens. Technology Used :

Operating System : Windows

Languages : PL/SQL, Power Builder 9.0

Databases : Oracle 9i

Tools Used : TOAD, Forte

Software Engineer at MSI Systems India Pvt Ltd.

April 2004 - August 2006 (2 years 5 months)

I worked on development of a product Named TrackCell. The product is developed for windows platform using PowerBuilder and MS Sql server. This Product is being developed for the Distributors and stockiest of Cellular Phones. It manages their chain stores and their Dealer Network through the complete distribution system. It also helps in tracking of their Individual Commissions and shares in the profit and control of the inventory in the Cellular Phone Market. It also help to keep their day to day operations in synchronization. The proper management reporting system is also being provided which includes all the inventory, customers, invoicing, purchase orders, commission tracking, pending commission reports, rebate report, commission due report etc.

Responsibilities were :-

• Preparation of Low Level Design Document

• Preparation of Test Cases & Test scripts.

• Development of Forms, Reports.

• Developed Commission module for Dealer commission and carrier commission. Page5

• Unit Testing

Education

Panjab University

Bachelor’s Degree, Business/Commerce, General, 1994 - 1997 Skills & Expertise

SQL

Requirements Analysis

Java

Microsoft SQL Server

JavaScript

Software Development Life Cycle (SDLC)

Oracle

XML

Agile Methodologies

Software Development

Business Intelligence

Data Warehousing

Solution Architecture

Languages

English

Hindi

Punjabi

Page6

Rekha rani

Technical Lead at HCL Technologies

**************@*****.***

Contact Rekha on LinkedIn

Contact this candidate