PROFESSIONAL SUMMARY:

• 8 years of experience in requirement gathering, design, development, testing, implementation and maintenance. Progressive experience in all phases of the iterative Software Development Life Cycle (SDLC).
• Experience in PowerBuilder 8.0, PowerBuilder 11.0 and PowerBuilder 12.5
• Experience in Sybase 12.5 such as writing business logic in stored procedure, creating trigger, views, temporary tables, joins etc.
• Extensive Hands on experience in creating Oracle PL/SQL blocks such as Packages, Triggers, Procedures, Functions, RefCursors, Collections. Proficient in writing Complex SQL queries.
• Extensive experience with analysis, design, development, customizations and implementation in ERP applications.
• Proficient in analyzing and translating business requirements to technical requirements and architecture.
• Good communication skills, interpersonal skills, self - motivated, quick learner, team player.
• Experience in designing and coding the application components in an Agile environment utilizing a test-driven development approach. I have been part of team where we provided programming estimates, identified potential problems and recommended alternative solutions.
• Excellent analytical and troubleshooting ability and code testing skills.
• Experience in wiring complex SQLs using Inner and Outer Joins and Sub Queries
• Experience in designing and developing data processing stored programs like Procedures, Functions, Triggers and Packages.
• Solid experience in debugging PowerBuilder as well as database objects
• Experience in Performance Tuning and Optimization of SQL Statements.
• Capable of rapidly learning new technologies and excellent team player with strong Analytical, Organization and Communication Skills
• Worked on On-Line Analytical Processing (OLAP), On-Line Transaction Processing (OLTP) and System Study, Analysis.

TECHNICAL SKILLS:

Operating Systems: MS Windows 2000, MS Windows XP professional, HP UNIX

Environment: Client/Server

Version & Source Control: Star Team

RDBMS: Sybase - 11.5, 12.5, Oracle 10g/11g

Languages: PowerBuilder 6.5 to 12.5, VB 6.0, Shell Scripting, Oracle PL/SQL, PFC

Other: MS-Office, TOAD, PL/SQL Developer

PROFESSIONAL EXPERIENCE:

Confidential, Wooster, OH

Senior Application developer

Responsibilities:

• Prepared Functional Specification Document and Technical Specification Document for the requirements.
• Expertise in data modelling, designed and developed conceptual, logical and physical design, ER diagram and Normalized the tables structures for the new applications.
• Co-ordinated with various stakeholders and developed Accounts management system using PowerBuilder, Oracle that were running in UNIX servers
• Used PowerBuilder, Oracle and Unix in Common data and instrument data systems that loads data from Bloomberg, Reuters, S&P and various external systems and centralize critical trading data
• Created COM/COM++ components from Non-visual user objects from PB and deploy on IIS server
• Worked on .Net projects to enable calling PB user objects
• Basic exposure to Sybase EAS Server 6.3.1 on deployment of use of Jaguar to deploy components (with admins) that are created using PowerBuilder and ActiveX
• Expertise in using various Power builder foundation classes and standards
• Used various types of data windows such as freeform, tabular, grid, Label and Crosstab to capture data in various screens and generate reports
• Used multiple transaction objects to connect with various data sources to pull the data and used it in enterprise system
• Led the Oracle migration of IB core systems and ensured the seamless migration of more than 20 applications and 100+ sub-systems that involved multiple teams and 500+ users
• Developed the local database using Power builder data pipe object to transfer data to downstream systems located in Hong Kong, Latin America
• Expertise in using data windows, Windows, User objects and transaction objects and developed applications in PowerBuilder.
• Monitor, resolve, and manage Autosys and IBM user and environment/ Netcool requests and alerts, including server issues, failures, and alerts.
• Developing Autosys jobs using JIL Scripting, working with several different Line of Business to develop and automate manual month-end and daily jobs to run in Autosys.
• Developed test plans, and various test cases for the applications developed
• Performed Unit, Integration and System testing for all the application deliverables and delivered high quality products
• Co-ordinated User Acceptance testing for the applications and ensured successful delivery
• Writing Stored procedures, Packages, Views, Cursors, Functions and triggers using SQL & PL/SQL
• Designed table structure and coded scripts to create tables, indexes, views, sequence, synonyms and database triggers.
• Maintained the version and source control for various applications using VSS
• Improved IT systems stability to 100% by collaborating with operations and business users to identify root cause for recurring issues and providing effective solutions
• Coordinated with stakeholders across businesses and analyzed and optimized production release process and that improved release efficiency by 25%
• Co-ordinated with clients for the onsite implementation for the applications and trained the users on the new system.

Environment: PowerBuilder 9.0/10.0/11/12.5, Oracle 10g, 11.2, Sybase, UNIX.

Confidential, Troy, MI

Responsibilities:

• Developed related PowerBuilder objects like (windows, data windows, User Objects) and Database Objects like (Stored Procedures, packages, functions, types, Tables, views etc.) using Oracle PLSQL.
• Designed, architected, and implemented the system enhancements which utilized PowerBuilder for dynamic front end user interface. Design includes services that encapsulate all database interaction from the front-end screens.
• Researched and analyzed complex product design activities. Performed, designed, implemented and maintained complex, multiple product modules and sub-systems. Participated in design meetings.
• Conducted unit testing and integration testing for functionality and limits.
• Played key role in product go-live implementation while working on site.
• Appreciation mails from clients for meeting deadlines of the project with good quality
• Created design documents and performed design and code walkthrough reviews with end users
• Used Star Team to Check-In, Check-Out and to maintain source version control.
• Assisted the team in following the efficient coding methodologies.
• Provided assistance to QA team while testing the builds.
• Developed Front end windows using PowerBuilder v10.5 and PFC services and Sybase as backend.
• Developed data flow diagrams for modules and derived use-cases from requirement analysis.

Environment: Power Builder 11.5, 12.5 Sybase ASE 12.5

Confidential, Burbank, CA

Sr. PowerBuilder/Oracle/ Sybase Consultant

Responsibilities:

• Communicating with the CRM to refine the requirements and prioritizing the requests.
• Delegating the change requirements to the offshore team and coordinating the implementation.
• Develop and implement new or enhanced utility components for the data warehouse
• Design and develop new or enhanced ETL (Extract, Transform and Load) process between different applications between Warner Brothers and CBS.
• Actively involved with team members to design and developed extract, transformation and data load designs based on well managed and integrated company’s data warehouse infrastructure.
• Handling the emergency bug resolution with the onsite team members.
• Strong SQL query, SQL DML and relational database design skills.
• Perform and coordinate data warehouse administration for development and maintenance activities, including performance testing, tuning, and troubleshooting of data warehouse processes.
• Implementing change management procedures & practices in the project and support related activities.
• Coordinating with different teams to setup and testing the interfaces with all integrated applications.

Environment: Oracle 10g, Sybase 15, PowerBuilder 11.5, SAP Business Objects Data Services, SQL Server Integration Services, SQL Server Reporting Services, DB Artisan, Windows XP.

Confidential

Sr. PowerBuilder/Sybase, Oracle Consultant

Responsibilities:

• Providing support for production and test environments to ensure that it’s fully functional.
• Involving with the users for new enhancements and provide Functional specifications, Technical specifications.
• Coordinates with offshore team to provide business requirements and review all changes.
• Interacting with the members of the system infrastructure, quality team, middle tier team and database team.
• Working on different projects simultaneously and provides solutions within time limit.
• Maintain a strong understanding of the business cycles, transaction timing, and service level requirements of the enterprise.
• Strong problem solving and communication skills.
• Decisive in difficult situations and under pressure.

Environment: PowerBuilder 9.0, Oracle, Sybase, Borland Stat Team, Toad 9.0, Windows XP.

Confidential

Software Developer

Responsibilities:

• Application development using Power Builder 10.5 and 12.5
• Analyze requirements, design, develop, debug, deploy and document software components.
• Performed Database functionalities (Sybase): Writing SQL Queries, Store Procedures, Triggers, and Functions, Views etc.
• Develop code based on functional specifications to support new modules, enhancements in existing modules as per user requirements
• Work closely with other software engineers, QA and Support groups
• Prepared Initial Approach document to be discussed in Architectural Review Meeting.
• Preparation of the High-Level Design Document which included designing of Proposed Process Flow.
• Coordinating between development and testing team to deliver a quality product.
• Developed front end GUI screens using Power Builder for populating trade details.
• Writing/modifying shell scripts for monitoring replication environment and automating them.
• Identified and optimized SQL statements in stored procedures/reports, which were pain points. There was significant improvement in the critical path stored procedures.

Environment: Power Builder 10.5, Sybase ASE 12.5