SUMMARY:

Business savvy IT professional with over 20 years of systems analysis, design, development, maintenance, and support experience in Microsoft Client Server, web Pocket PC and AS/400 environments. Ability to rapidly gain insight into business problems, develop effective and accurate solutions. Possess strong leadership and communication skills with the ability to lead technical teams and Work closely with senior management is looking for Senior System Analyst/Programmer position.

TECHNICAL SKILLS:

Microsoft .Net

C# - visual studio 2005/2012

SQL Server 2005/2008

SQL Server Integration Services

SQL Server Reporting Services and Crystal Reports

ASP.NET, HTML5, Javascript(VS 2005/2012)

IBM AS400 and ILERPG

VBA

IT Project Management

PROFESSIONAL EXPERIENCE:

Senior Developer /Project Leader

Confidential, Edison, NJ

Technology: .Net, SQL Server 2005/2008, C#, VBA, MS - ACCESS, ASP.NET, Web Services, XMLSQL Server Reporting Services and Integration Services, Crystal Reports, Silverlight and IBM AS/400 ILERPG

Responsibilities:

• Developing Functional Design specifications.
• Preparing the Technical Design.
• Assisting with building a sound business process for the users.
• Monitoring and reporting development effort.
• Manage the whole system development life cycle (SDLC)
• Develop Product Design and reporting Intranet Applications in ASP.NET and C#
• Develop Web services using crystal reports and ASP.NET
• Integration and Automation of distributed systems using SQL server integration tools,C#,VBA and MQ series
• Raymark Retail Enterprise application and GEAC ERP
• Develop effective, performance - driven T-SQL (Transact-SQL) ad-hoc queriesstored procedures, functions, triggers and schemas in a SQL Server 2005 environment
• Develop SQL Server Integration Services Packages
• Design and implement supporting data structures for reporting infrastructure
• Identify, troubleshoot and redevelop existing, poorly performing T-SQL
• Properly identify required supporting indexes
• Assist in the design of data warehouses and reporting requirements
• Develop reports using SQL Server reporting services and crystal reports
• Intranet Application- data driven and Business intelligence front end programs developed in ASP.Net, Silverlight and C#

Software Developer/Project Leader

Confidential

Technology: .Net, SQL Server 2000/2005, C#, VBA, MS-ACCESS, ASP.NET, Web Services, XMLSQL Server Reporting Services and Integration Services, Crystal Reports, Silverlight and IBM AS/400 ILERPG

Responsibilities:

• Develop Customize software solutions in VBA, Access, Crystal Reports, SQL Server and C#.
• Develop Client server Business application using Visual studio, VBA and C#
• Maintain/Modify BPCS ERP system on As/400 with ILERPG Manage Medium size IT software projects.
• Develop Interface to Custom develop EDI system
• Develop effective, performance - driven T-SQL (Transact-SQL) ad-hoc queriesstored procedures, functions, triggers and schemas in a SQL Server 2000/2005 environment
• Develop SQL Server Integration Services Packages
• Develop reports using SQL Server Reporting services
• Intranet Application, data and report Automation programs developed in ASP.Net and VB.NET

Senior Analyst Programmer and Consultant

Confidential

Technology: .Net, SQL Server 2000, C#, VBA, MS-ACCESS, ASP.NET, Web Services, XMLSQL Server Reporting Services and Integration Services, Crystal Reports, Silverlight and IBM AS/400 ILERPG

Responsibilities:

• Developing Functional Design specifications.
• Preparing the Technical Design.
• Assisting with building a sound business process for the users.
• Integration and Automation of distributed systems using SQL server integration tools, C# and VBA
• Maintain/Modify GEAC system 21 ERP system
• Manage Full SDLC of IT projects (Smaller to Medium Size)
• Design and Develop C# and WEB Report rendering front end Web applications
• Develop effective, performance - driven T-SQL (Transact-SQL) ad-hoc queriesstored procedures, functions, triggers and schemas in a SQL Server 2000 environment
• Design and implement supporting data structures for reporting infrastructure
• Identify, troubleshoot and redevelop existing, poorly performing T-SQL
• Properly identify required supporting indexes
• Assist in the design of data warehouses and reporting requirements
• Develop reports Crystal Reports.

Project Leader

Confidential

Technology: .Net, SQL Server 2000, C#, VBA, MS-ACCESS, Integration Services, Crystal Reports, IBM AS/400 ILERPG and COBOL,INFINIUM

Responsibilities:

• Manage Medium size IT software projects.
• Assisting with building a sound business process for the users.
• Developing Functional Design specifications.
• Preparing the Technical Design.
• Assisting with building a sound development process for the users.
• Monitoring and reporting development effort.
• Enhance and maintain Custom build As400 applications written in RPG400, ILERPG and Cobol/400
• Develop turnkey solution in Microsoft .NET client Server environment and IBM AS/400
• Develop reporting application in Crystal reports and VBA
• Develop effective, performance - driven T-SQL (Transact-SQL) ad-hoc queriesstored procedures, functions, triggers and schemas in a SQL Server 2000 environment
• Develop SQL Server Integration Services Packages
• Design and implement supporting data structures for reporting infrastructure
• Identify, troubleshoot and redevelop existing, poorly performing T-SQL
• Properly identify required supporting indexes
• Assist in the design of data warehouses and reporting requirements
• Develop reports using Crystal Reports.

Software Development Consultant

Confidential

Technology: .Net, SQL Server 2000, C#, VBA, MS-ACCESS, Integration Services, Crystal Reports, IBM AS/400 ILERPG and COBOL

Responsibilities:

• Analyze user requirements and Prepare systems and technical specifications
• Develop effective, performance - driven T-SQL (Transact-SQL) ad-hoc queriesstored procedures

Project Manager

Confidential

Technology: VBA, MS-ACCESS, Crystal Reports, IBM AS/400 RPG/400 and COBOL

Responsibilities:

• Led the team of 2 systems analyst, 3 Analyst Programmers and 2 Operators
• Analyze business requirements and prepare technical specifications
• Develop enhancements and modifications to existing ERP system on As/400 and MS - ACCESS.
• Manage the whole SDLC make sure the project done under budget and time
• Liaise with Top Management to deliver best cost effective technology solutions.

Project Leader

Confidential

Technology: VBA, MS-ACCESS, Crystal Reports, IBM AS/400 RPG/400, ILERPG and COBOL

Responsibilities:

• Manage a team of 5 - 7 IT professionals
• Evaluate the business process and propose technical solutions.
• Develop Functional and Design specifications.
• Prepare the Technical Design.
• Assisting in building a sound development process for the users.
• Monitoring and reporting the progress of the project to management.
• Manage the whole SDLC and make sure the project done under budget and time.
• Manage the implementation projects for multi national and local clients
• Programming in RPG/400 and VBA

Senior Analyst Programmer

Confidential

Technology: RPG11, VBA and Access.

Responsibilities:

• Maintain and Develop IBM S/36 and AS/400 ERP applications.
• Develop/modify applications for Clients