PROFESSIONAL SUMMARY:

• 7 yrs of IT experience in developing and maintenance of applications using SQL Server, PowerBuilder and Sybase technologies.
• Experience in ETL process. Worked extensively in data extraction, cleansing, data integration and loading from different data sources using SSIS.
• Proficient in implementing all transformations available in SSIS tool box.
• In depth knowledge on Transact SQL. DDL, DML, creating indexes Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions CTEs and Triggers t facilitate efficient data manipulation and data consistency.
• Successfully completed Four Full Life cycle implementations using PowerBuilder versions 12.5/11.1/9.0/8.0.
• Have good working experience in administering the DemandTec tool for Advertising and Marketing Execution.
• Experienced using PowerBuilder features such as PFC, Dynamic data windows, MDI, User Objects.
• Experienced in development of key Digital Media enterprise solutions and creating work orders, managing media assets using xytech mediacentre.
• Expertise in writing complex PL/SQL Stored procedures, Functions, Triggers, Query optimization and Performance Tuning.
• Experienced in using OOPS Inheritance, Encapsulation, and Polymorphism with PFC PowerBuilder Foundation Classes .
• Have a wide Business knowledge on EDI industry.
• Extensively worked GUI applications and screens, designed the GUI and coded the GUI. Als involved in project GUI specs, design and prototype.
• Generated PowerBuilder Reports 12.5/11.1/9.0/8.0
• Wrote Technical Documents on Reports developed.
• Extensively used QUEST Tools TOAD, Navigator , and SQL PLUS.
• Strong Knowledge on Software Models, Software Analysis, Design, Requirements and networks.
• Ability t interact effectively with clients, Understanding their requirements and providing optimum solution and support.
• Excellent Analytical, interpersonal and communication skills.
• Quick learner with ability t develop proficiency and adapt t new technologies and methods in a short period of time.
• Experienced in working in a team environment. . I especially enjoy mentoring other programmers wh use PowerBuilder.
• Extensively used, very strong experience, highly skilled in using the PowerBuilder object: the Data Window control. Experience in Databases MS SQL Server and Sybase.
• Experience in Windows NT, Windows 2000, Windows 2003, Windows XP and Windows Vista.
• Experience in Version Control Tool like VSS, Clear Case and TFS
• Good Experience in using Database tools for Sybase like Vision explorer, Interactive SQL and Query analyzer and Management studi for SQL server.
• Have a very good knowledge in development and supporting UNIX Shell scripting.
• Excellent Analytical, Problem solving, written and verbal communication Skills.

TECHNICAL SKILLS

• Operating Systems:- Windows, Unix
• Databases :- SQL Server 2000/2005/2008, Sybase
• Languages and Standards:- C, .net, SQL
• Development/Productivity Tools:- PowerBuilder
• Tools :- Rational Clear Case, Visual Source Safe, , BMC Remedy, Install Shield , Vision Explorer and Interactive SQL.
• Frame works- PowerBuilder Foundation Classes

EXPERIENCE SUMMARY:

Confidential

Responsibility:

• Responsible for developing of new enhancements made t the AME application, which involves changes t be done in t the SSIS packages and SSRS reports.
• Responsible for Development and Testing of New Enhancements and Problem Reports on a monthly Basis.
• Responsible for 24X7 on call Production Support Maintenance of the application.
• Responsible for on call basis user support in case of any user queries / problems.
• Have profiled and tuned servers on a monthly basis t ensure fast queries and reports
• Responsible for backups/restores, monitoring SQL uptime, designing and maintaining DTS packages.
• Made enhancements Power builder for a downstream application t AME.
• Participated in various testing activities including Unit, Integration System Testing.
• Reviewing Functional/Design specifications and Test Case Documents
• Have enforced version control for the application for monthly release.
• Involved in Unit Testing and Integration Testing of different framework Modules

Environment: SQL server 2000, 2005 and 2008, Demand Tec AME, Visual Source safe, SQL server integration services, reporting services, PowerBuilder.

Confidential

Responsibility:

• Responsible for design of new enhancements made t the application.
• Responsible for Development and Testing of New Enhancements and Problem Reports on Quarterly Basis.
• Responsible for 24X7 on call Production Support Maintenance of the application.
• Responsible for on call basis user support in case of any user queries / problems.
• Prioritize implement various enhancement requests as part of maintenance releases.
• Participating in business meetings t identify the user requirements.
• Participated in various testing activities including Unit, Integration System Testing.
• Reviewing Functional/Design specifications and Test Case Documents
• R D t achieve the required functionality
• Have enforced version control for the application for every quarter release.
• Have updated packages with each build generated and worked with Software Central Team for Quality approvals.
• Extensively used HP reflection sessions for building server side packages and then distributing the package int Production as well as Test/Dev servers.
• Have made significant changes in the login screen t validate the user's version.
• Involved in training and mentoring of new hires
• Involved in Unit Testing and Integration Testing of different framework Modules

Environment: Power Builder 8.0, 9.0 ,11.1 and 12.5, SQL server 2000 2005, Sybase , C , UNIX , Reflection for UNIX, Clear Case Explorer, BMC Remedy User, Install shield, Interactive SQL, Vision Explorer.

Confidential

Responsibility:

• Responsible for Development and Testing of enhancements as part of Quarterly Releases
• Prioritize implement various enhancement requests as part of maintenance releases.
• Analysis and fixing of technical issues in PMCS NT related applications.
• Participating in business meetings t identify the user requirements
• Involved in application deployment activities in Development and QA environments at Offshore
• Participated in reviews and various testing activities including Unit, Integration Testing.
• Lead the UI team Estimation of task, technically help .
• Developed DTS Packages in SQL server 2000.
• Implemented Drag and Drop Functionality for the PMCS application using PowerBuilder.
• Worked extensively on controls like Data windows along with Implementation of Select record Printing Functionality using data stores.
• Worked in Improvement of process by documenting the Test Cases, Test results and Documenting existing bugs in the system.

Involved in Unit Testing and Integration Testing of different framework Modules

Environment: Power Builder 8.0, 9.0, 11.1 and 12.5 SQL server 2000, VSS, BMC Remedy User, Install shield, Interactive SQL, Vision Explorer.

Confidential

Responsibility:

• Responsible for Development and Testing of New Enhancements and Features
• Involved in preparing Functional Specs
• Prioritize implement various enhancement requests as part of maintenance releases
• Participating in business meetings, user forums t identify the user requirements
• Involved in application deployment activities in Development, QA Production environments by coordinating with operations team.
• Participated in various testing activities including Unit, Integration System Testing.
• Analysis and fixing of technical issues in LOQS related applications / batch jobs.
• Involved in Unit Testing and Integration Testing

Environment: Power Builder 8.0, 9.0 and 11.1, SQL server 2000, Sybase, Clear Case Explorer, BMC Remedy User, Install shield, Interactive SQL, Vision Explorer.

Confidential

Responsibility:

• Testing the enhancements made on the procurement tool.
• Performing black box testing, unit testing, Incremental Integration testing, Integration testing, system testing.
• Testing the flow of the purchase orders, their control and the validations.

Environment: Power Builder 8.0, 9.0 and 11.1, SQL server 2000, Sybase, Clear Case Explorer, BMC Remedy User, Install shield, Interactive SQL, Vision Explorer.