SUMMARY:

• Accomplished detail - oriented IT professional with extensive years of experience in the financial, retail and healthcare industry working with Confidential companies in the fast paced environment
• Has a solid background as Technical Lead, Deliver Manager, Business Systems Analyst and Client Liaison managing all aspects of software design life cycles, including requirements gathering, functional analysis and design, technical enhancements, application delivery, and user-acceptance coordination.
• Handled UAT and Release management and support including co-ordination with offshore teams.
• Comfortable working in crisis-driven environments
• Extensive experience managing onsite and offshore teams, responsible for work allocations and meeting the project defined timeliness.
• Responsible for collating, analyzing and reporting the project metrics to the senior management.
• Excellent communication and presentation skills

TECHNICAL SKILLS:

Operating Systems: Windows, UNIX, LINUX

Programming Languages: C, T-SQL, PL/SQL, PowerBuilder 12.5, JAVA

Scripting Languages: PERL, UNIX Shell (KSH, CSH, BASH)

Databases: Sybase 15, MS SQL Server 2008, ORACLE, MySQL

Development Tools: DBArtisan 9.x, Sybase Central

Data Modeling: Erwin, TOAD, PowerDesigner

Internet Technologies: ASP.NET, Sybase EAS 5.5, Apache TomCat

Version Control: Perforce, GIT, SVN

Other Applications: 24 x 7 scheduler, FTP, ISQL, BCP, AutoTester, SYBASE Open-Client,, SharePoint, DTS, ETL, SQL Delta, JIRA, Mercator, SSIS, HP QC, Control-M, Eclipse

PROFESSIONAL EXPERIENCE:

Confidential,NYC

Technical Lead/Senior Systems Analyst

Responsibilities:

• UAT and Release management and support including co-ordination with offshore teams.
• Supervised and managed month-end, quarter-end and year-end processes.
• Conducted Disaster Recovery tests
• Led daily Scrum sessions
• Interfaced with end users and business analysts to help develop functional and technical requirements
• Interfaced with QA team and track defects ( using HP QC )
• Managed batch scheduling using CRON and Control-M
• Responsible for developing and supporting various PERL and BASH scripts.
• Managed the system analysis and design using documents such as HLD, LLD, Sequence diagrams, Flow charts etc.
• Created and scheduled various batch jobs using Control-M
• Sybase ASE 15 design, development, support including coding stored procedures and DDL scripts
• Created various BCP scripts to assist in data transfers.
• Handled performance tuning of Sybase stored procedures for optimal performance using advanced query optimization techniques.
• Enhanced the database design for performance (partitioning, normalization, memory allocations etc.)
• Fulfilled ad-hoc requests for Sybase and Shell development and support

Confidential, Lanham,MD

Technical Lead/Senior Systems Analyst

• Managed all software development life-cycle stages and supported client-server applications built on SQL Server 2005 and PowerBuilder version 11 on a Windows XP Platform.
• Managed the application migration from POWERBUILDER ver. 9 to POWERBUILDER ver.11.
• Increased system performance, reducing response time in some cases to seconds from minutes
• Worked with SSIS Export/Import Wizard and DTS to load data from text files
• Wrote and modified several stored procedures and triggers in SQL Server 2005.
• Responsible for source code integrity and release management using Harvest.
• Assisted with the generation of various reports using Crystal Reports
• Used tool SQL Delta to assist with various releases.
• Key point of contact for users for troubleshooting.
• Key point of contact for an outside vendor (AppLabs) for Stress-testing.

Confidential, Woodbridge,NJ

Technical Lead / Senior Systems Analyst

• Successfully managed the software development life-cycle of a complex three-tier application using ASP.NET, PowerBuilder 9.0 and SYBASE EAS 5.5 (Jaguar) for deployment of all middle-tier components.
• Served as the Lead developer for all PowerBuilder development.
• Acted as the lead troubleshooter of all application issues.
• Scheduled jobs using the 24 x 7 scheduler
• Set up various .BAT files for scheduling
• Developed on SYBASE ver. 12.5 . Sybase Central was the tool used.
• Performed data maintenance using BCP.
• Integrated a system developed by an outside vendor with minimum support/documentation.
• Increased system performance so users could finish tasks timely and comply with various regulations.

Confidential, New York, NY

Senior Systems Analyst

• Analyzed and designed functional specs based on minimum user requirements.
• Served as the primary support contact for all technical and non-technical issues.
• Oversaw life cycle management, including user acceptance testing, systems analysis and design.
• Wrote several stored procedures and triggers using DBArtisan tool.

Confidential, Hazlet,NJ

Senior Systems Analyst

• Utilized PowerBuilder 9.0 (non-PFC) for enhancements.
• Established functional requirements through constant interaction with users.
• Developed stored procedures/triggers using SYBASE ver. 12.5 and DBArtisan.
• Designed a internal system for generated weekly performance tracking reports using SYBASE, DBArtisan
• Integrated a system developed by outside vendors with minimum documentation and no support.
• Made system performance acceptable by tuning the data model. Erwin tool was used.
• Constructed EDI maps using Mercator
• Managed all aspects of a software lifecycle using the Linear Sequential method including systems analysis and design.
• Worked closely with Operations for all deployments and releases.