Application Systems Engineer Resume
San Francisco, CA
SUMMARY:
Confidential is a Client/Server Software professional with over 12 years of experience in various stages of software development cycle. He has experience in analysis, Data Modeling, Development, Integration, Testing, Debugging, Implementation and Maintenance. His expertise includes knowledge and experience on PowerBuilder 4.0/5.0/6.5/8.0.3/9.0/10.0/10.5 , Sybase 10/11.0.3/12.5.3 , C# + Microsoft.NET Framework: 2.0, MS - SQL Server 7.0/2000, Oracle 8i/10g, IBM DB2 UDB 8.2, Erwin 2.1/3.0/4.0, ER/Studio 4.0, PowerDesigner 9.0, Embarcadero Rapid SQL, SQA Team Test and Test Director 7.6. Sudhin is familiar with quality procedures carried out in software industry and has excellent experience of interacting with clients and end users.
TECHNICAL EXPERTISE:
OPERATING SYSTEMS: Windows XP, Windows NT 4.0/2000, IBM AIX 5L UNIX, Novell Netware 4.0
FRONT ENDS: Power Builder 4.0/5.0/6.5/8.0.3/9/10/10.5 , C# + Microsoft.NET Framework 2.0
RDBMS: Watcom SQL 4.0, MS SQL 7.0/2000, Sybase SQL Anywhere 5.0, Sybase System 10.0/11.0.3 , ASA 8.0, Oracle 8i/10g, IBM DB2 UDB 8.2, Sybase Adaptive Server Enterprise 12.5.3
CASE TOOLS: Erwin 2.1/3.0/4.0, ER/Studio 4.0, Power Designer 9.0
OTHER TOOLS: SQA Team Test, Test Director 7.6, Embarcadero Rapid SQL 7.3.4, Perl 5, Rational Clear Quest
PROFESSIONAL EXPERIENCE:
Confidential, San Francisco, CA
Application Systems Engineer
Responsibilities:
- Interacted with Team Lead for business specs clarifications of YOM application enhancements.
- Enhancements to YOM application using Front-End tool PowerBuilder 10.5.
- Used YOM framework for developing List windows, Item windows & Associated List windows.
- Used non-visual user objects for business validation in the YOM framework.
- Used PFC objects like u dw as the ancestor object to make use of datawindow services.
- Back-End coding involved writing stored procedures/triggers
- Wrote Functional Design & Technical Design specifications for the YOM application enhancements.
- Wrote PB Requirements Document in excel format for migration of YOM application to Java.
- Provided technical support on resolving application problems and/or consulting on system enhancement.
Environment: PowerBuilder 10.5 with PFC, Oracle 10.2.04, PL/SQL Developer 7.1.5.1398 , Rational Clear Quest (Defect Tracking System), UNIX, Java, JSF, Windows XP, HP Elite Book
Confidential
Senior Programmer/Analyst
Responsibilities:
- Interacted with Team Lead for business specs clarifications of BOSS-CATS & Dividend Recon application enhancements.
- Enhancements to BOSS-CATS & Dividend Recon application using Front-End tool PowerBuilder 9.
- Back-End coding involved writing stored procedures/triggers for CATS interface & Dividend Recon interface for Sybase ASE 12.5.3 & Oracle 10g
- Used CORE framework for developing List windows, Item windows & Associated List windows.
- Used non-visual user objects for developing wizards in the CORE framework.
- Used privilege tags for CORE security features at window, tabpage, and datawindow control & datawindow column level.
- Used PFC objects like u dw as the ancestor object to make use of datawindow services
- Provided technical support on resolving application problems and/or consulting on system enhancement.
Environment: PowerBuilder 9 with PFC/Power Tool, Sybase Adaptive Server Enterprise 12.5.3, Erwin 4.1.2771, Embarcadero Rapid SQL 7.3.4, PERL 5, C# + Microsoft.NET Framework: 2.0, Oracle 10g, Windows XP
Confidential, Maryland
Developer
Responsibilities:
- Team Lead Interaction for business specs clarifications of MD CHESSIE application enhancements.
- Enhancements to MD CHESSIE application using Front-End tool PowerBuilder 10.
- Back-End coding involved writing stored procedures/triggers for CARES & CSES interfaces. Development of CARES & CSES interface applications.
- Provided technical support on resolving application problems and/or consulting on system enhancement.
Environment: PowerBuilder 10, IBM DB2 UDB 8.2 on IBM AIX 5L UNIX System, EASERVER 5.0, Windows XP, IBM PC
Confidential, Delaware
Developer
Responsibilities:
- Client Interaction for business specs clarifications of GUSS application enhancements.
- Prepared Document of Understanding, Impact Analysis, HLDD & Test Plans.
- Enhancements to GUSS application using Front-End tool PowerBuilder 8.0.3.
- Back-End coding involved writing stored procedures/views for reports/enhancements.
- Developed interface application that interacted with different client server database environments including MS SQL Server 2000/Oracle 8i.
- Provided technical support on resolving application problems and/or consulting on system enhancement.
Environment: PowerBuilder 8.0.3, MS SQL Server 2000, Oracle on UNIX, Windows XP, IBM PC
Confidential, New York
Developer
Responsibilities:
- Designed, developed and customized investment application using PowerBuilder 8.0.
- Applications development for investment database using networking and operating systems Windows 2000.
- Database design, and database stored procedures/functions/triggers, enhancement and administration for use with investment applications using client-server database MS SQL Server 2000.
- Developed interface application that interacted with different client server database environments including MS SQL Server 2000.
- Front-end coding in PowerBuilder involved usage of PFC services like linkage service, string handling service, data window service etc.
- Back-End coding involved writing stored procedures for reports, calling dts packages and for bcp utility.
- BCP to load data into investment database tables for reporting purposes.
- Provided technical support on resolving application problems and/or consulting on system enhancement.
Environment: PowerBuilder 8.0 with PFC, MS SQL Server 2000, Windows NT, Dell PC
Confidential, Cleveland, Ohio
Developer
Responsibilities:
- Designed and developed Point-Of-Sale and other retail applications using PowerBuilder 4.0/5.0/8.0.
- Applications development for retail applications using networking and operating systems Windows NT 4.0 and Windows 2000.
- Database design, and database stored procedures, enhancement and administration for use with retail applications using client-server database SQL Anywhere 5.x. /ASA 8.0
- Development of interface application that interacts with different client server database environments including MS SQL Server and Sybase.
- Implementation of Gift Card Solution for vendors.
- Micros Eclipse Hardware Integration for cash drawer, pole display and msr.
- Visa Cisp Compliance for credit card authorizations.
- Wrote Functional and Technical Specification documents for application.
- Provided technical support on resolving application problems and/or consulting on system enhancement.
Environment: PowerBuilder 8.0, A.S.A 8.0, PowerDesigner 9.0, Windows NT, Dell PC
Confidential, Phoenix, Arizona
Developer
Responsibilities:
- Designed the logical database schema for CServer using ER/Studio 4.0
- Created tables, rules, defaults and constraints using ER/Studio 4.0
- Wrote triggers and stored procedure. Query optimization and transaction management. Debugging and Unit Testing of CServer.
- Checked the integrity of the database using DBCC.
- Wrote SQL statements for database classes using Visual Café.
- Replication of data and schema between two databases
- Wrote test plans for unit testing and made impact analysis for changes done
Environment: Java 1.2, JSP, Jrun 4.0, MS SQL Server 7.0, ER/Studio 4.0, Windows NT, Dell PC
Confidential
Developer
Responsibilities:
- Front End Coding in PowerBuilder involved development and enhancement of UI Screens. Implemented & Installed Press module at the client site.
- Team leader activities for press module involved giving time estimation, resource requirements, briefing and coordinating with team members, interacting with client for change requests, getting approval from the client regarding the same and giving clarification to each member as and when required on the user requirements.
- Updated the Entity-Relationship diagram with Erwin 3.0 for changes due to customization. Migrated Sybase 11.0.3 and PowerBuilder 6.5.
- Created tables, rules, defaults and constraints using Erwin 3.0.
- Developed test cases and made impact analysis for changes done.
- Updated user manual and technical specs for press module.
- Unit testing of core framework and ancestor components for the Press Transactions module.
- Rewrote/Modified existing triggers and stored procedures.
- Provided technical migration information for migrating from PB 4.0 to PB 6.5 with guidelines for code change.
Environment: PowerBuilder 4.0/6.5, Sybase 10.0/11.0.3 , UNIX, Windows 3.11/95/98, Novell Netware 4.0, Erwin 2.1/3.0, IBM PC
