PROFILE SUMMARY:

• 6 years of total I.T. experience with over 6 years industry experience in application development in multi - tier and client/server environment utilizing relational and object oriented technologies (Object Oriented Design/Programming) using PowerBuilder and SQL with Sybase.
• Proven experience with structural development methodologies, such as SDLC (Software Development Life Cycle), Software prototyping and RAD (Rapid application Development) as well as agile development methodologies especially SCRUM.
• Proven ability to guide a complex development project throughout the project lifecycle (SDLC) from initial Requirement identification to Product Architecture/Design and into implementation, testing, maintenance and support.
• Hands on experience with developing applications with PowerBuilder tool
• Experienced in managing all the backend tasks from Analysis, Design, and Implementation to Maintenance
• Hands-on experience in writing Sybase ASE and SQL Server objects such as Tables, SQL Queries using Joins, Sub queries, views and Sequences, Stored Procedures, Triggers, Indexes, Cursors, User Defined Functions(UDF’s) using T-SQL to encompass complex business logic and error handling
• Skilled in performing Disaster Recovery Planning and implementation by choosing the best Recovery model and Backup/Restore strategies
• Experienced in executing Database Performance Tuning
• Proficiency working with most of the industrial databases, SQL programming Sybase (T-SQL), SQL Server and Oracle(PL-SQL) as well as in utilizing 3 rd party SQL development
• Experienced with ERWIN, Rational Architect, Rational Clear Quest 7.0.1.0 and Power Designer tools
• Experienced in designing applications using UML (Unified Modeling Language) and MS VISIO tool
• Experienced in leading architectural review meetings, design meetings and JAD sessions
• Lead small teams of up to 5 people

TECHNICAL SKILLS:

Operating Systems: Windows NT/2000/2003/XP,UNIX, DOS

Languages: T-SQL, PL/SQL, VB.NET, ASP.NET, C, VB6

Databases: SYBASE, SQL Server 2000/2005/2008 , ORACLE 7.x /8i/9i/10i

Web/Application Servers: EAServer, Tomcat, Microsoft IIS 4.0, ASP.Net

Development Tools: Visual Studio 2003/2005/2008 , PowerBuilder 6.0/8/10/11.5

Framework: .Net Framework 1.1/2.0/3.5, PFC

Office Tools: MS Office, MS Visio, MS Project

Other Tools: ERWIN, Visual Source Safe 6.0, CVS, CLEAR CASE

Defect Tracking tools: Clear Quest

Scripting: VB.NET, ASP.NET, VB script, UNIX Shell Scripts, Java Script, Power Script

PROFESSIONAL EXPERIENCE:

Confidential, Mount Laurel, NJ

Sr. Software Engineer

Responsibilities:

• Responsible for analyzing, detailed designing, developing and maintaining various modules of “Title & Appraisal Ordering System” and “Closing Management System”
• Participated in meetings to consolidate requirements from the business partner and the end user
• Lead effort in preliminary requirement analysis and logical database design and frontend design for both the systems
• Created high-level design document to depict functional and non-functional requirements
• Lead database design review meetings and modeling using ERWIN tool
• Used Data window Services, Window Services, and Menu Services, which are effectively used in the development of the application interface
• Used PFC(PowerBuilder Foundation Class) libraries extensively to develop the application
• Finalized physical database design and implemented database after careful consideration of various Database components(File Groups, Primary & Secondary Data Files and their physical storage), Scalability Planning and Normalization of the Database
• Lead design review meetings and discussed front end architecture and database model
• Developed SQL Queries using Sub Queries, Joins and Views using T-SQL
• Developed Sybase ASE objects such as Stored Procedures, Triggers, Views, Cursors, and UDFs (User Defined Functions) to encompass complex business logic and error handling
• Worked and achieved better performance on large tables using Linked Server and Partitioned Views
• Developed Disaster Recovery Plan to be used in case of unforeseen circumstances
• Responsible for Database Backup/Restore process and Recovery Model selection
• Implemented UNIX Shell scripts for batch processing.
• Accommodated changes in the database based on the requirements and incorporated enhancement logic
• Responsible for managing and maintaining the database

Environment: Intel Pentium, LINUX, Windows XP, PowerBuilder 11.5, Sybase, Transact SQL (T-SQL), Help desk system (To keep track of production support tickets), Borland Star Team (Version Control Sys)

Confidential, Bellingham, WA

Software Engineer

Responsibilities:

• Responsible for analyzing, documenting, designing, implementing and testing the system
• Performed database analysis and design for the application
• Developed the system front end using PowerBuilder, Implemented Standard class Non-Visual Objects such as User Objects, Data Stores etc.
• Encompassed object oriented functionality using functions, events and Custom Class user objects
• Used PFC framework and extended functionality using PFE
• Based on database design, and front end design Implemented database schema objects such as Tables, Indexes, Views, using T-SQL
• Participated in the design review meetings and developed User Interface design
• Created UI for the designed modules using Visual Studio and made modifications to some of the existing screen to meet new requirements
• Wrote and maintained Stored Procedures and packages to enforce business rules, manipulate data and to fetch data into various reports on the front end
• Developed User Defined Functions, DML Triggers and DDL Triggers.
• Performed code walk-through, and performed refactoring to improve code at some places
• Created test cases and performed Unit Testing and System Testing
• Wrote technical documentation (business requirements, Requirement Specification document, technical design documents, user acceptance tests, risk and issue management sheets, minutes meetings)

Environment: Intel Pentium, LINUX, Windows XP, Citrix, Power Builder 10, Microsoft.net, ASP.net, Sybase, T-SQL, Clear Quest (defect tracking systems), HP Service Desk (system to keep track of production support tickets), visual SourceSafe

Confidential, Minneapolis, MN

Developer Analyst

Responsibilities:

• Goal of the system was to meet specific requirements of new large client. System was developed using Sybase database and PowerBuilder.
• Responsible to enhance existing system functionality as well as to migrate to. NET and SQL Server 2000 and in corporate new functionality in the system
• Reviewed and interpreted new business requirements into further detailed technical functional and non-functional requirements.
• Analyzed enhancements required in the existing system and determined how requirements will affect new or existing systems - impact analysis
• Designed how to implement requirements into new or existing systems, design enhancements
• Generated programming specifications for new or existing systems using UML using Object Oriented Approach
• Designed and developed SOA (service oriented architecture) for cross corporate integration with other systems.
• Developed code for new system and made enhancement to existing systems database with T-SQL
• Resolved the errors and bugs in the database
• Fine-tuned Procedures, Functions and Triggers to achieve optimum performance
• Performed Performance Tuning at Database level, T-SQL Query level and Operating System level using MS SQL Server
• Provided back-end support for functional testing and performance testing
• Participated in performing unit tests on new or existing systems department.

Environment: Intel Pentium, Windows XP, Power Builder 6.5/8, Microsoft.net, asp.net, Sybase, SQL Server 2000, T-SQL, Help desk system (system to keep track of production support tickets), Microsoft Team Foundation System (bug tracking tool, source control version). xPression Suite (3rd party Enterprise Printing Solution system).