Profile Summary

• Designed and developed System Interface using PowerBuilder Objects, both Visual and non-visual: Windows, Tree-views, User Object, Data Window, Dropdown Data Window, data store, etc.
• Proven ability to guide a complex development project throughout the entire project lifecycle SDLC from initial opportunity identification through product implementation and into support mode.
• Proven experience with structural development methodologies, such as SDLC Software Development Life Cycle , Software prototyping and RAD Rapid application Development .
• 5 years experience with level 4.5 expertise on a scale of 1 to 5 in PowerBuilder versions 6.5/9/11 of Graphic User Interface GUI and presentable reports as well as business logic programming.
• Over 6 years of experience in Analysis, Design, Development, Implementation, Testing and Maintenance of Software MIS Applications using PowerBuilder and Oracle with sybase.
• Proficient in TSQL programming Stored Procedures, Functions and Packages, SQL tuning, and creation of Sybase Objects Tables, Views, Materialized Views, Triggers, Synonyms, Database Links, User Defined Data Types, Nested Tables and Collections. Used Temporary tables extensively.
• Experience in using SQL tools like SQL Navigator, TOAD and SQL Plus.
• Experience in Data Analysis, Normalization and Entity relationship modeling in simple and complex data structure.
• Good experience with Windows, UNIX and Linux operating systems.
• Good knowledge of Web based technologies HTML, Java Script and XML .
• Experience in various Project Management related activities involving complete software development lifecycle of embedded application development and implementation, including designing, implementing, integration, testing, debugging and maintenance.
• Strong analytical problem solving skills, leadership qualities, Quick learner and Good team member.

Technical Skills:

• Programming/Databases: C, C , Assembly, Java, VC , HTML, JavaScript, PL/SQL, MySQL, Oracle 8i / 9i /10g, Sybase 7/11, PHP
• Microcontrollers: 8085/86, 8051 series micro-controllers, Microchip
• Modeling Tools: MS Visio, ERWIN
• Querying Tools: SQL plus, Oracle with Sybase developer, TOAD, TSQL developer
• ETL Tools SQL Loader
• Operating systems: Windows XP/2000/2003/Vista, Mac OS, UNIX, LINUX, Adtran
• Softwares: POWERBUILDER, VB.Net, MiPower, PSPICE, CVIP tools, Keil MicroVision 3, Matlab
• Mentor Graphics EDA tools Design Architect, Quicksim , Unreal Editor

Professional Experience:

• First Data processes transaction data of all kinds, harnesses the power of that data, and delivers innovations in secure infrastructure, intelligence and insight for its customers. From large financial institutions to the merchant around the corner, First Data supports its customers by helping them process and understand the intelligence behind every transaction.
• As an application developer I primarily involved in maintaining and developing of two systems. One is Client-Server system called PAR Participant Application Repository , developed using PowerBuilder and Oracle with Sybase. Some performance critical modules were developed using C/C .

Role/Responsibility:

• Gathering initial requirements and problem analysis in cooperation with business clients.
• Preliminary system and data model design.
• Responsibilities included PowerBuilder screens design, development.
• Mapping application information requirements into database.
• Performance tuning of Sybase TSQLs queries, indexes, constraints.
• Creating relational database model and performing database normalization.
• Writing complex queries using Oracle inline views, sub queries, dynamic sqls etc. Using complex TSQL programs using REF Cursors, collections, TSQL tables, variable cursors etc...
• Developing objects such as tables, indexes, views, sequences, stored procedures, functions, Database triggers and packages in T-SQL to enforce complex business rules.
• Designing and developing business logic in PowerBuilder utilizing advance Object Oriented techniques and entities like Non Visual Objects, User Objects, functions, events, exceptions.
• Using Data Window Services, Window Services, and Menu Services, to create robust and effective GUI.
• Created .net winforms using PowerBuilder 11.5.
• Implemented .net functionality.
• Designing and creating complex reports, data grids and views using different types of PowerBuilder Data Windows.
• Designing and developing performance critical services in C/C .
• Conduct Peer Reviews Code reviews.
• Impact analysis in existing system and implementing the enhancement logic.
• Conducting meetings to consolidate requirements from the business partner and the end user.
• Creating high level design documentation to depict the functional requirement.
• Preparing the test case plan, setting up the test environment and testing.

Environment: H/w: Intel Pentium O/s: LINUX, Windows XP, S/W: Power Builder 6/9/11, C/C , Oracle 9i/10g, Sybase 7/11, TSQL, Test director defect tracking systems , Help desk system system to keep track of production support tickets , Clear case version control system

Confidential

Title: Oracle with Sybase Developer

I worked for the COMPAS Comprehensive Policy Administration System .Gathered the requirement from the client and translated the business details into Technical design. Worked closely with the Database Developers to ensure adherence of the database guidelines, standards and procedures and generated system test plans.

Responsibilities:

• Involved in analysis, database design, coding, and implementing
• Designed and Developed data entry screens using PowerBuilder.
• Generated custom reports, used data windows, user objects and tab pages in PowerBuilder extensively.
• Used PFC PowerBuilder Foundation Classes Libraries and its services.
• Fine Tuned the SQL queries using hints for maximum efficiency and performance
• Created database triggers
• Written Korn Shell scripts for mounting database to recover data
• Used different joins, sub-query and nested query in SQL query
• Used extensively TSQL, to develop packages, stored procedure, functions and database triggers
• Loaded data into multiple tables using SQL Loader
• Worked closely with the Administrator for proper backup and recovery plans
• Interacted with end user for problems faced and providing necessary technical support by fixing the bugs

Environment: Powerbuilder 8, Sybase 7, TSQL, TOAD, HTML, Java, Unix Shell scripts, Windows 2000.

Confidential

Software Developer

The project work included development in Oracle PL/SQL programming and Report Generation. Developed front-end windows using Powerbuilder custom framework. The system was a financial customer servicing reporting structure designed using Oracle PL/SQL and PowerBuilder. Designing and creating complex reports, data grids and views using different types of PowerBuilder Data Windows. I have Developed and maintained business logic using Oracle PL/SQL. Performed fine-tuning of the stored procedures, functions, views and triggers.

Environment: Oracle 8, PL / SQL, PowerBuilder 6.5, HTML, Java, XML, Java Script, Windows NT.