SUMMARY

• Over 8+ years of experience in developing business related applications in the Client/Server, Unix/Windows using PowerBuilder, PFC, Sybase ASE, Oracle, SQL - Server, ASP, MS-Access, SQL, T-SQL, PL/SQL, Unix shell script, Web Datawindow, Object Oriented Programming, GUI, Windows API, Crystal Reporting, System Development Life Cycle(SDLC), Multimedia.
• Expertise in design and development of application in relational database and client server environment using PowerBuilder 7.0/8.0/9.0/10.0 , 11.5,12,12.5.
• Strong experience in programming skills with PowerBuilder and its advanced features such as PowerBuilder Foundation Class Library (PFC) with corporate level, XML Export/import datawindow using template, Dynamic, Data Windows, Inheritance, Encapsulation, Polymorphism, MDI, User Objects, visual/Non-visual user object and Menus.
• Experience in design of databases using Erwin. Database Model and RDBMS development using Oracle, PL/SQL, MS SQL, MS Access and other database technologies.
• Experienced in writing, debugging and enhancing stored procedures and functions using T-SQL and PL-SQL (using TOAD/SQL Developer for Oracle).
• Hands on experience in PowerBuilder application migration.
• Strong knowledge of Object-Oriented software engineering methodologies, Object-Oriented Analysis and Design, Design Contract, UML, Use-Case-driven development, the Unified Software Development Process, the full Software Development Life Cycle (SDLC), and extreme Programming.
• Knowledge of programming and Design methodologies related to RDBMS Applications.
• Good knowledge of processes & methodologies for developing large-scale mission critical applications.
• Used UML tools to create in-depth design flow for developers and application blue print for clients (End users) to communicate with the product design and infrastructure design ideas.
• Implemented business logic as .NET Framework assemblies (C#, VB.NET).
• Performed Database developer role - Responsible for database developer tasks such as business analysis, design and implementation. Written stored procedures, packages, functions, triggers, fine tuning queries & stored procedures, debugging programs, writing Transact SQL and reports.
• Good knowledge in Database analysis, design, normalization, and data manipulation processes.
• Involved in Configuration Management and Quality Management activities - Assist the database administrator and coordinate with other consultants
• Knowledge in Tuning SQL statements and procedures for enhancing the load performance in various schemas across databases.
• Knowledge in working with databases and in designing robust, complex databases, Server architecture.
• Experience on creating flow charts for the technical specifications and process documentation using Microsoft Visio
• Good knowledge of Agile Methodology, test driven development approach (SCRUM, sprint and Extreme Programming and Unifies Process)
• Implemented business logic as .NET Framework assemblies (C#, VB.NET).
• Strong working knowledge in creating reports using SQL Server Reporting Services (SSRS), Crystal Reports.
• Experience in developing and deploying applications for Freight Services, Manufacturing, Sales/Marketing, Financial & Banking, Education/Student Management and Purchases.
• Excellent experience in Object Oriented Analysis, Design and Development. Very good communication / interpersonal skills & ability to work under tight schedules.
• Working knowledge on Test Director and Rational Clear Case.

TECHNICAL SKILLS

Operating Systems: Solaris 8, 9, 10, Windows … Unix - AIX, Red Hat Linux.

Development Tools: PowerBuilder 12.0/10.5/9.0/8.0/6.5 , PowerBuilder Foundation Classes (PFC), Power Designer, Infomaker, Knowledge in EAServer.

BI/ OLAP Tools: Cognos 8, ReportNet 1.1, Cognos Planning, Cognos EP Series 7, Impromptu Administrator, Power Play, Cognos Query, IWR, Powerplay Web reports, Upfront, Visualizer.

Languages: C#.Net, PHP, Python, JavaScript, HTML, VB.Net, VB6.0, ASP, ASP.Net, XML, C

RDBMS: Oracle 9i/8i, 7.x, Sybase 12.5/15, MS SQLServer 2000/2005

Design Tools: OOAD, Erwin, Power (S) Designer, UML, Rational Rose

Reporting Tools: PowerBuilderReporting(DataWindows), Crystal reports, 6/7, Oracle Reports 2.5, SSRS

Database Tools: DB2, Teradata, Sybase, MSAccess, Toad8.0.

Version Control: SVN, Clear Case, TFS, CVS

Others: SQL Query Analyzer, SQL Navigator, SQL Loader, TOAD Suite7.x, Crystal Reports, MS Office, ODBC, Rational Clear Case, Visio, Api, Solaris, Installsheild, Cold Fusion, SQL BuilderJSP, PVCS, Object Cycle, Sybase EA Server, MS Office Suite, EDI diagrams, SSIS, SSRS

PROFESSIONAL EXPERIENCE

Confidential, Santa FE, NM

Sr.PowerBuilderDeveloper

Responsibilities:

• Collected Business requirements, Upstream& Downstream Impact analysis on Applications with schema changes, Created Functional specification and technical design document. Preparation of detail design, development and production support for the assigned modules.
• Preparation of validation scripts for the Database modifications for the projects. Co-coordinating with Offshore team developing the system. Conducted and participated in Peer reviews and Code review.
• Design includes services that encapsulate all database interaction from the front-end screens.
• Involved in converting distributed PowerBuilder components to.NET components deployed on a COM server, and running against an Oracle 9i database.
• Used Sybase DataWindow.NET to leverage business rules embedded in legacy code.
• Involved in migrating code from PowerBuilder 11.5 to PowerBuilder 12.5
• Developed objects related to PowerBuilder such as Windows, DataWindows, User Objects and Database Objects such as Stored procedures, packages, functions, types, Tables, Views using Oracle PL/SQL.
• Developed related PowerBuilder objects like (windows, datawindows, User Objects) and Database Objects like (Stored Procedures, packages, functions, types, Tables, views etc) using Oracle PL/SQL.
• Developed Front end windows using PowerBuilder v12.5 and PFC services and Sybase ASE 15.5 as backend.
• Created/Modified DataWindows, Windows, User Objects, Menus in PowerBuilder.
• Examining the user interfaces, scripting the Database functions and procedures according to the requirement.
• Designed and Developed Windows, Datawindows & User Objects in PowerBuilder.
• Developed and distributed PowerBuilder interface to consume Java WebServices using SOAP/WSDL/XML.
• Implemented the Mail API service in Java and Perl code to alert the users in case of any batch job failures.
• Created Use Cases to describe the System needs program functions to develop or modify the system and programs.
• Create Store Procedures, DDL statements, DML statements, Trigger, functions in Sybase database
• Played key role in product go-live implementation while working on site.
• Written unique PowerScript to handle the actions created by various components of the application.
• Develop & debug PL/SQL, Create Execute and Optimize queries while providing an interactive community to support the user experience by using TOAD.
• Involved in installing and configuring of EAServer and conversion of PowerScript code that is compatible for EAServer.
• Involved in designing Microsoft Visio diagrams to create flow charts for the Technical specification and process documentations.
• Extensively involved in various phases of testing the products before migrating Production, from Unit testing through regression, UAT and performance testing.
• Administrated Oracle server with Linux, indexes, tables, views, users, profiles, synonyms, tables space, data files, backup, restore, performance, tuning.

Environment: PowerBuilder11/12.5, PFC, UNIX, java/j2EE, Linux, Sybase ASE 15.5, T-SQL, Oracle9i/10g, Perl, PowerScript, Testing, TOAD, PL/SQL, EA Server 6.1, Quality center, XML, shell scripting, Visual studio .NET

Confidential, Hamilton, NJ

PowerBuilder Developer

Responsibilities:

• Responsible for guiding other developer on analysis, debugging, code review and maintaining PowerBuilder based application.
• Requirement Gathering and Analysis.
• Involved in the development of the application based on Sybase ASE PowerBuilder.
• Built and maintained application based on PowerBuilder 10.5
• Prepared Technical Design Documents based on Business Requirements.
• Succeed in testing strategies using unit test plans, integration test plans and system test plans.
• Maintain Defects of the PowerBuilder Application along with resolution steps, change request of the PowerBuilder Application and issues with the application.
• Develop Deploy guide and lead the development efforts in the Development, Testing, Stage and Production environments.
• Created/Modified DataWindows, Windows, User Objects, Menus in PowerBuilder
• Debugging existing software to correct malfunctioning applications
• Responsible for converting user requirements into software solutions
• Expertise in User objects of PowerBuilder.
• Expertise in creating functions of PowerBuilder.
• Developed and deploy components developed as a Non-visual object and datawindows in PowerBuilder.
• Involved in writing PowerScript for different DataWindows.
• Created/Updated some Triggers and Stored Procedures using Dynamic SQL statements.
• Developed SQL code based on requests raised by changes in business logic, norms and standards using check in and checkout process while coding the objects.
• Debugged Functions, Triggers and Stored Procedures in Sybase ASE 15.5.
• Developed complex SQL queries for data retrieval from various database objects including tables, indexes and views
• Involved in writing SQL Loader control file for flat file data from other departments and scheduled them in UNIX to load every night in Production Environment.
• Performed SQL and PL/SQL tuning using various techniques like analyzing, indexing, providing hints, executing stats and explain Plan.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Programming using PowerBuilder Standards.
• Involved in installing and configuring of EAServer and conversion of PowerScript code that is compatible for EAServer.
• Used Just in Time debugging skills to resolve complex and show stopper issues.
• Provide required support to team members to solve production issues
• Analyze, designed and programmed different warehouse modules according to business requirements.
• Adding and Managing Source code to the Version Control Team Foundation Server and Serena Dimensions.
• Debugged.Net related applications.

Environment: PowerBuilder 9, 10.5, 12.5, SQL, PLSQL,JIRA, Sybase Server, Windows2007, SAP Unit Testing, Toad, Sql Developer, Visual studio.NET, SIT,PFC, Oracle 11g

Confidential, Port Washington, NY

Sr PowerBuilder Developer

Responsibilities:

• Collected user requirements, analysis, design (GUI & Database) and developed the system. Interacted with the users to discuss business logic and workflow of the all the system. Created Functional specification, technical design document, Integration and unit test cases.
• Extensively used Object Oriented Techniques of PowerBuilder like Inheritance, Polymorphism and Encapsulation.
• Create and change Business objects, windows, datawindows, functions and menus to encompass enhancements and migration.
• Involved in Frame work design using PFC. and Created User Objects, windows, datawindows and functions.
• Designed several Sequential Workflow Libraries (WWF) for business logic by analyzing business requirement.
• Created Standard & Custom Visual User objects. Used Non Visual User Objects for implementing business rules.
• Developed and deploy components developed as a Non-visual objects and datawindows in PowerBuilder.
• Developed the user interface in ASP.NET using C#.NET as code behind language.
• The application programs are developed using C++ and designed using object oriented methodology.
• Three-tiered architecture, with the business processing separated from the user interface and the database interface.
• Involved extensively in development of Stored procedures, Triggers, and fine-tuning them for performance.
• Developed Complex database objects like Stored Procedures, Functions, and Triggers using SQL.
• Created, customized, and managed stored procedures, functions and to triggers for database's using PL/SQL
• Implementation of business rules and implemented database conversion.
• Used ADO.NET extensively for data retrieving, querying, storage and manipulation.
• Requirement analysis, use case preparation, and developing UML Model.
• Created SQL Server integration service (SSIS) Packages using SSIS Designer for export heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server.
• Develop Deploy guide and lead the development efforts in the Development, Testing, Stage and Production environments.

Environment: PowerBuilder 9.0/10.5, PowerBuilder Foundation Class (PFC), Sybase, ASP.Net, ADO.Net, PL/SQL, MS SQL server, SQL Server Integration Services, SQL Server Reporting Services, Windows XP

Confidential, Pittsburg, PA

PowerBuilder Consultant

Responsibilities:

• Involved in requirement gathering and actively involving in discussions with Business users.
• Worked on EA Server 5.2 Migration to EA Server 6.0. Assisted in developing the migration plan and was responsible for the migration and testing of the Jaguar Components.
• Working on a complex processing system that has multiple interfaces to other systems as well as multiple interactions with both internal and external customers.
• Expertise in User objects of PowerBuilder. Created Stored Procedures responsible for generating Reports using Oracle.
• Involved in updating of the existing PFC's according to client's requirement. Involved in writing Power Script for different Data Windows.
• Created/Modified Data Windows, Windows, User Objects, Menus in PowerBuilder
• Analyze the user requirements and create Use Case documents for each module, technical specifications about the module including the screen design, business process involved and the various ways of implementing the business rules including all the validations, SQL to be written and pseudo code wherever applicable.
• Responsible for setting up and maintaining Ms-SQL Server development and production environments. Helped Database Administrator for 3 productions and 2 developments Ms-SQLServers.
• Technologies and were founded on a complete Service Oriented Application (SOA) architecture.
• Experience with developing distributed applications (with Jaguar/EA Server, J2EE or equivalent technology)
• Involved extensively in development of PL/SQL Packages, Stored procedures, Triggers, and fine-tuning them for performance.
• Implemented the use of standard templates to create up-to-date SDLC documents. Migrated the applications from PB 7.0 to 10.5
• Involved in development of NVO and base classes which are used across multiple applications.
• Coding, testing, debugging of Windows, complex data windows, User objects, functions, events using Power Builder per company standards and techniques.
• Creating and altering Tables, procedures, functions, triggers and packages. Making Builds and deploying executables (Implementation). Wrote auditing triggers, complex procedures & functions using PL/SQL to incorporate business rules and constraints.
• Involved in writing design, technical, enhancements documentation and test plans.
• Creating and changing Business objects (Visual and Non-visual), windows, data windows, functions and menus using Power Builder.
• Developed new classes in PowerBuilder(TM) 8.0 utilizing ActiveX technology, for deployment in COM / ASP or Sybase EA Server (web target) environment.
• Developed several PowerBuilder applications using RPC functionality.

Environment: PowerBuilder 8.03/10.5, PFC, PL/SQL, Oracle 9i/10g, PVCS, SDLC, Shell Scripting, Windows XP, MS-Office, Jaguar, Microsoft Visual Studio 2008, .NET Framework 2.0, Unix.

Confidential, Chicago, IL

PowerBuilder Consultant

Responsibilities:

• Prepared design/development specification documents from requirement document.
• Participated in Gap analysis with business analysts and users.
• Worked on several maintenance calls that involved PowerBuilder code changes.
• Involved in Unit Testing.
• Assisting solutions to problems related to software design.
• Supporting Loss Prevention and Incident Management System using PowerBuilder 9.0 and SQL Server 2005.
• Recommended solutions to problems related to software design.
• Normally received general instruction on routine work, detailed instructions on new assignements.
• Did Power scripting using PFC.
• Generation of reports in PowerBuilder and save in different format.
• Assisted the client manager with preparation of Reports for review.
• Expertise in User objects of PowerBuilder.
• Creating tables and Writing SQL Quires.
• Design Test Plan, Test Scenario, approving Test cases, Test data & Test results, Issue LogSetting up the Database, GUI and Coding standards for the Project.

Environment: PowerBuilder 9.0, SQL Server 2005, PVCS, Clear Quest, PFC, Windows XP, PowerBrowser, Regression Testing, PowerDelta

Confidential

Java Developer

Responsibilities:

• Gathered specifications from the requirements.
• Developed use cases, sequence and activity diagrams in UML using Visio.
• Implemented asynchronous multi-thread processing of files (Java Message Service, Message Driven Beans, PL/SQL, and Triggers).
• CORBA server was used for communication with client.
• Used Java Connector Architecture for reading files.
• Developed entity beans for storing the persistence data.
• JBuilder was used as the IDE.
• Used JSP and HTML to design the web pages to verify information on accounts loaded for testing purpose.
• Used Harvest for configuration management.
• Used database development environments like TOAD to access and modify the local database.
• Participated in Unit, Integration, System, Stress testing. Wrote JUnit test cases for testing the functionality of the code.

Environment: Java (JDK 1.4), EJB 2.0, JDBC, Servlet, JSP, MQSeries, JBuilder, JNDI, JMS, Java, Unix, BEA Weblogic 8.1, Oracle 9i, UML, TOAD,HTML, XML, SQL, PL/SQL, CA Harvest 5 Client, JUnit