Resume

Sign in

Powerbuilder Developer with SQL Server and Sybase

Location:
Chennai, Tamil Nadu, India
Salary:
Negotiable
Posted:
November 25, 2018

Contact this candidate

Resume:

** ***** ********** ** ******** design, Application Development/ Project/ IT and Database Management.

CAREER OBJECTIVE

Seeking Powerbuilder/SQL Developer position in IT Sector for long term/short term projects work.

SUMMARY

5+ Years - Working onsite(Cambodia) as a Senior Programmer / DB Admin / IT Mananger.

Presently working in Textile/Payroll/Accounting/Imports/Exports/Costing/Budgeting/Inventory/Supply Chain Management/ Merchandising software development in a Leading Textile company/ a Software Company.

2 Months onsite Requirement Analysis/ Implementation/Software Development experience at Indonesia.

Adept in end-to-end development of software products from requirement analysis to system study, designing, coding testing, de-bugging, documentation and implementation

Experience in mapping business requirements, designing customized solutions with strong analytical skills and ability to analyse business practices and define optimal procedures

Conversant with Power Builder, MS SQL Server, Sybase, Stored Procedure, Functions & Triggers.

Possess excellent interpersonal skills with abilities in resolving complex software issues

CORE COMPETENCIES

Project Management Application / Software Design Requirement Gathering Client Interactions

Business / System Analysis SDLC Planning & Management Technical Architecture Software Quality & Testing

ORGANIZATIONAL EXPERIENCE

Jul'13-Nov'18: Volumecocomo Apparel Cambodia Inc., Cambodia. Senior Software Programmer/DB Admin

Sep’11-Jul’13: ISGN Technologies LTD., Chennai. Software Programmer

Oct’09-Aug’11: Arvind Limited., Bangalore. Executive Systems

Nov’07-Sep’09: ECOTECH Software Pvt. Ltd., Chennai. Software Programmer

Key Result Areas

Framing architectural decisions, providing leadership & direction in the areas of technology and product development to facilitate and enable growth and business agility

Ensuring implementation of the best coding standards/practices in the project by reviewing the technical architecture

Interacting with the onsite team for requirement gathering, system study & analysis

Drafting functional requirements for computer systems using models and diagrams to represent the processes and functions involved

Working out the new system's requirements & specifications and test strategies and assisting in functional testing of the new system, ensuring that it meets the user specifications

Understanding the technical & functional specifications, designing, developing, testing, troubleshooting and debugging of the applications

Managing smooth implementation and testing of the application at client location, providing post-implementation, enhancement and maintenance support to client for application.

IT SKILLS

Front-End: Power Builder 6.5, 8.0, 10.5, 11.5, 12.5

Database: Sybase ASE 7 and 9, SQL Server 2008 R2 and SSRS.

Source Control: Start Team, Tortoise SVN with PBSCC Proxy, PB Native

Languages: C, C++

Other Tools: MS- Office 2007(Including MS Visio), Outlook 2007

Functional: US Mortgage Banking/ Textile (EDI, Order, Costing, Budgeting,

Purchase, Inventory, Imports, Exports, Report, Shipping), Payroll Processing, Accounting, Project Management

EDUCATION

2007 Electronics and Communication Engg., Mepco Schlenk Engg. College - 74%

PERSONAL DETAILS

Date of Birth: 08.04.1985

Nationality: Indian

Passport No.: R9989232 Date of Expiry 20th August 2027

Visa Status: Cambodia Employment Visa

Languages Known: English, Tamil

Total Experience: 11 Years

Relevant Exp(PB): 11 Years(Powerbuilder)

Relevant Exp(SQL): 6+ Years (SQL Server 2008 R2)

Relevant Exp(Sybase): 3 Year and 8 Months

Expected Salary: As per Company Standards

Please refer to annexure for projects

ANNEXURE

PROJECTS HANDLED

Company: VolumeCocomo Apparel, Inc. (Cambodia)

volumecocomo.com

Project 1: Winfashion – Software for Order Booking till Shipping

Project name:

Winfashion

Industry:

Textile

Position:

Software Programmer

Responsibilities:

Project Analysis, Designing, Development

Tools & technologies used:

Platforms: MS Windows XP, 7

Tools: Microsoft SQL Server Management Studio,

Environment: Powerbuilder 8.0, SQL Server 2008 R2

Duration:

2013 JUL –2018 NOV

Project 2: PROZIA – Software for Asset Management/ Payroll/ Accounting - Cambodia

Project name:

PROZIA

Industry:

Payroll/ Accounting/ Inventory - Assets

Position:

Software Programmer

Responsibilities:

Project Analysis, Designing, Development

Tools & technologies used:

Platforms: MS Windows XP, 7

Tools: Microsoft SQL Server Management Studio,

Environment: Powerbuilder 8.0/12.5, SQL Server 2008 R2

Duration:

2013 JUL – 2018 NOV

Project 3: SQL REPORT SERVER – SSRS

Project name:

Winfashion - SQL Report Server

Industry:

Textile/ Payroll/ Accounting/ Inventory - Assets

Position:

Programmer

Responsibilities:

Project Analysis, Designing, Development

Tools & technologies used:

Platforms: MS Windows XP, 7

Tools: Microsoft SQL Server Management Studio-SSRS

Duration:

2013 JUL – 2018 NOV

Project 4: EDI - (810/856)

Project name:

EDI - (810 - PO PROCESSING / 856 - ASN GENERATION)

Industry:

Textile - EDI - Order to Shipment processing

Position:

Software Programmer

Responsibilities:

Project Analysis, Designing, Development

Tools & technologies used:

Platforms: MS Windows XP, 7

Tools: Microsoft SQL Server Management Studio,

Environment: Powerbuilder 8.0, SQL Server 2008 R2

Duration:

2013 JUL – 2018 NOV

Role and Responsibilities as Software Programmer/ Project Lead/ IT Manager/ DBA:

Discussing requirements with Management Team, Department Heads and End Users and analyzing the feasibility of requirements.

Preparing Flow diagram in MS Visio with Business Specification Documents based on the business needs, and discussing the same with top management for approval.

Support all departments for the smooth transactions and developed many new requirements during the business expansion.

Setup report server for the production, payroll and asset maintenance. Created email subscriptions to the management / production and marketing team to understand the present situation based on the data available.

Setup SQL Encryption for the salary master and user master so that anyone can't see the salary information or the password of users and misuse(using SQL Server hashbytes / SHA1 algorithm)

Setup a Planning Dashboard for sewing lines based on the orders and change the plan graphically at run time.

Review the code and ensure the standards are followed after each task completed.

Testing the requirement in all aspects whether it is working properly as per the standards.

Preparing build and releasing the end users at Terminal Server and documentation.

Company: ISGN Technologies Ltd., Chennai

http://www.isgn.com/

Project 1: GATORS (General American Tracking Order and Reporting System)

Project name:

GATORS

Industry:

Mortgage

Positio0n:

Software Engineer

Responsibilities:

Project Analysis, Designing, Development

Tools & technologies used:

Platforms: MS Windows XP, 7

Tools: Microsoft SQL Server Management Studio, STAR TEAM

Environment: Powerbuilder 11.5, SQL Server 2008

Duration:

2011 SEP – To 2013 JUL

Project 2: Migrating the package from PB11.5 to PB12.5

Project name:

GATORS

Industry:

Mortgage

Position:

Software Engineer

Responsibilities:

Project Analysis, Designing, Development

Tools & technologies used:

Platforms: MS Windows XP, 7

Tools: Microsoft SQL Server Management Studio, STAR TEAM

Environment: Powerbuilder 12.5, SQL Server 2012

Duration:

2012 DEC – To 2013 JUL

Product: GATORS (General American Tracking Order and Reporting System)

Gators is an end-to-end settlement services and vendor management system that automates and streamlines the entire settlement process from order entry to and product fulfillment via the web. Gators application is highly configurable with title and closing solution is one of the only platforms that can manage every product including Appraisals, Title Insurance and Closing services.

Role and Responsibilities as Software Developer:

Planning the work as per the requirements from the Global Delivery Managers.

Understanding the client requirement based on the details provided by the business analyst (i.e Specification Document) and preparing the Design Documents (Technical Document).

Sending the Design Documents (Technical Document) for approval and getting feedback on the same and incorporating changes if required.

Correcting the errors if any as it works properly without affecting work flow.

Changing the codes as per the coding standards and get it verified from the Project Lead.

Testing (Pbl Testing, Unit Testing) the requirement in all aspects whether it is working properly as per the standards and preparing the Unit Test Document.

Preparing build and releasing the same to the Testing team for testing and documentation.

Company: Arvind Limited., Bangalore

www.arvind.com

Project 1: MIGRATING STAGE TO NOW

Project name:

Migration of STAGE TO Network Oriented World

Industry:

Textiles

Position:

Executive Systems

Responsibilities:

Project Analysis, Data Support, Design Support, ERP Admin

Tools & technologies used:

Platforms: MS Windows XP, 7

Tools: Sybase Central

Environment: Powerbuilder 10.5, Sybase ASA 9

Duration:

From 2009 OCT – To 2011 AUG

Role and Responsibilities as a Executive Systems:

From OCT 2009 to AUG 2011

Collecting system requirements from the users and incorporating the same in STAGE.

Correcting the errors as it works properly without affecting work flow.

Maintaining files and backup of the same so that their work flow will not be affected if any changes in the software.

Customization of reports as per company standards.

Modification of screens for more user friendliness.

Customization of the ERP Flow as per the company Flow of work.

Taking the product, inventory stock files from STAGE and importing the same into NOW.

Getting customized reports for Arvind Limited from STAGE and making the specifications for the same and sending as a requirement in NOW.

Supporting report design same as Existing system(Stage)

ERP Server Maintenance and Administration.

Scheduling periodic backup for the database.

Replication Server Maintenance and Administration between locations in bangalore.

Database archiving if the size of the database it too high.

Updating the new files in the server and keep it monitored whether it is copying in the client systems.

User ID creation and setting module wise privileges as per their authority level.

Restricting the access to the data in ERP System.

Train the new users in different modules.

Company: Ecotech Software Pvt Ltd., Chennai

http://www.stageindia.net/

Project 1: STAGE - Software for Textile And Garment Exporter

Project name:

STAGE

Industry:

Textiles

Position:

Software Engineer

Responsibilities:

Project Analysis, Designing, Development

Tools & technologies used:

Platforms: MS Windows XP

Tools: Sybase Central

Environment: Powerbuilder 6.5, Sybase ASA 7

Duration:

From 2007 NOV – To 2009 SEP

Project 2: Migrating the product from PB6.5 to PB10.5

Project name:

STAGE

Industry:

Textiles

Position:

Software Engineer

Responsibilities:

Project Analysis, Designing, Development

Tools & technologies used:

Platforms: MS Windows XP

Tools: Sybase Central

Environment: Powerbuilder 10.5, Sybase ASA 9

Duration:

From 2009 JUL – To 2009 SEP

PRODUCT DETAIL

STAGE - Software for Textile And Garment Exporter, an ERP Product Giving Integrity Solutions to Garment Exporter. This business application package developed in Client / Server Architecture by using Power Builder and Sybase. Stage handles entire operations through 23 different modules included Security, Address, Order Processing, Process Planning, Production Planning, Costing, Time & Action, Purchase, Inventory, Exports & Imports Documentation, Accounts and Payroll.

Role and Responsibilities as Software Developer:

Understanding the client requirement and preparing the understanding documents.

Sending the Understanding Document and getting feedback on the same and incorporating corrections if required.

Correcting the errors as it works properly without affecting work flow.

Working for the project set files and if any updation are there in the feature of the software, same will be incorporated into the Project set.

Testing (Pbl Testing, Link Testing) the corrections in all aspects whether it is working properly as per the Software standards.

Build files and sending the same to the testing department before sending the same for client updation.

Documenting user manual if any new feature is added in to the software.

PERATCHI SELVAM BALASUBRAMANIAN

: +91-637*******, +91-978*******

: ac7scf@r.postjobfree.com, ac7scf@r.postjobfree.com

: RKB Mansion, Arumbakkam, Chennai 600106, India

Skype: cocomomgr-it



Contact this candidate