Lead Programmer/analyst Resume
New York, NY
SUMMARY
- 11+ years of hands-on experience in System Analysis, design, development and deployment of applications using Microsoft technologies, including .NET Frame work 2.0/3.5, VS2005/VS2008, VB.NET, C#, ASP.NET, IIS 6.0, AJAX, Web Service, WCF, XML/XSL, SQL-Server 2005/2008.
- In-depth experience in System Analysis & Design, Coding, Testing and support of multi-tier / Enterprise applications.
- 9 years of experience in developing web applications using .NET framework 2.0/3.5 with C#,VB.Net, ASP.Net, Web User Interface Design, HTML, Java Script, AJAX, ASP and VS2008/VS2005 IDE.
- Extensive experience with RDBMS (MS-SQL Server 2008/2005 & Oracle 9.x).
- Experience in database design using Normalization rule and creating database schemas.
- Extensive experience in writing stored procedures, triggers, functions on SQL Server 2005/2008.
- Extensive experience in implementation of full SDLC using methodology like Agile, RAD, Waterfall & Spiral Model.
- Worked on various domains: Finance, Telecom, Government, and Retail.
- Superior record of delivering large-scale, mission critical projects on time and budget.
- Strong analytical, trouble shooting, performance tuning and decision making skills.
- Ability to quickly grasp business processes and conceptualize development modules for implementation.
- Mentored & supervised development teams.
Web Technology: .NET Framework 2.0/3.5, C#, ASP.NET, VB.NET, ADO.NET, Web Services, WCF, AJAX Toolkit 2.0 /3.5, OOPS, OOD, HTML, JavaScript, CSS, Themes and VBScript.
Application Servers: IIS 5/6
Operating Systems: Windows 2000/NT/2003/XP
RDBMS: SQL Server 2008 / 2005, T-SQL (DDL, DML), Database design, Functions, Stored Procedure, Triggers, SSRS, Data migration, Oracle 8i/9i, PL-SQL.
Reporting Tools: Microsoft Reporting Services (SSRS)
Version Control: Visual Source Safe, CSV, VSVN, Subversion
Testing: Prepare UTP, ITP & UAT test cases.
Tools/Others: MS Visio 2003, SDLC, Use Case, Sequence Diagram, Payment Gateway Integration, Infragistics web controls, Software AG EntireX 7.3, Component One WebGrid 1.1/2.0, Active Directory.
EDUCATION:
BS in Computer Science and Mathematics
CERTIFICATION: Microsoft Certified Solution Developer (MCSD)
PROFESSIONAL EXPERIENCE
Confidential, City of New York, NY
Lead Programmer/Analyst Apr 09 - present
Projects:
- DSNY Common Platform
- Complaint System
- Operator Detach System.
Responsibilities:
- Analyzed business requirement
- Designed the enterprise framework and web application architecture for DSNY Common Platform.
- Developed class library, Proxy, Service & Data Access layers using OOPS and .NETFramework 3.5
- Developed web service for Security & Email.
- Implemented Authentication & Authorization using forms authentication in web applications.
- Designed Web User Interface using C#,ASP.NET, JavaScript, AJAX, HTML and CSS.
- Developed Dashboard using data grid with paging, sorting & search functionality.
- Conversion of legacy systems into web based enterprise application.
- Designed SQL Server 2008 database for the system\'s backend data processing
- Developed Stored Procedure, User Defined Function & triggers
- Implement workflow for the application.
- Developed User Controls.
- Developed reports using SSRS and integrated with ASP.NET page to view reports.
- Participated in Data migration from Mainframe, Data ease and other legacy systems.
- Generated PDF outputs for various forms and send as email.
- Developed maintenance portal for User Profile & applications maintenance.
- Unit testing and Integration testing of application and data migration.
- Generated scripts and documentation for deployment.
Environment: OOPS, .NET framework 3.5, ASP.NET, C#, Web Service, JavaScript, AJAX, SQL Server 2008, SVN.
Confidential, City of New York, NY
Lead Programmer/Analyst Jan 07 - Apr 09
Projects:
- Online Application System
- HRA Resume Automation
Responsibilities:
- Interacted with business users to gather and analyze functional requirements
- Developed Use Cases, Proof Of Concept & Prototype.
- Built flowcharts, Sequence diagrams, data flow diagrams (DFDs) in the requirements gathering and design stage of the Software Development Life Cycle (SDLC) for project implementation using Visio.
- Designed n-tier distributed architecture using Object Oriented Design
- Developed the portal using RAD/Agile methodology. The portal was implemented in 4 phases with several smaller iterations.
- Developed one-way hashing to encrypt user password using SHA256 with salt. The encrypted password and the salt were stored in database to meet the security policy.
- Developed web service to communicate between presentation layer and the business layer to support the web farm environment were Web servers were on DMZ and App servers behind firewall on local LAN.
- Integrated payment service provider 'Skipjack' to the portal for payments using credit and debit cards.
- Developed an automated daily reconciliation process to reconcile all the missing credit card transaction.
- Using Software AG's EntireX Broker, developed data access layer to access/modify data from Mainframe database (CA Datacom DB).
- Developed web user interface using VB.NET,C#,ASP.NET and JavaScript using VS2005
- Implemented AJAX toolkit extender controls to enhance user interface.
- Designed database using SQL Server.
- Developed Functions, Stored Procedure and triggers in SQL Server 2005
- Developed Unit Test Plan and Integrated Test Plan and assisted QA team in load testing of the portal.
- Assisted App scan team to scan the portal for security vulnerability and implemented the recommendations.
- Developed Health monitoring service to check availability of service on all servers and send information via email if any of the service is down.
- Developed Alert & escalation mechanism for the portal to send out alert via email for critical errors.
- Pro actively anticipated and addressed project obstacles during design & development phase
- User support, Code review and ongoing code maintenance.
Environment: OOPS, .NET framework 3.5, ASP.NET, VB.NET, C#, EntireX, Web Service JavaScript, AJAX, SQL Server 2005, CA Datacom DB and distributed architecture in web farm environment using load balancing switch between web servers and app servers and state management using windows services.
Confidential, Newark, NJ
Lead Programmer/Analyst Oct 06 - Dec 06
Project:
- Broker Dealer - Compliance Performance Measurement (BDCPM)
Responsibilities
- Developed Prototype.
- Designed 3-tier architecture using OOD.
- Developed class library, Business & Data Access layers using OOPS and .NET
- Used Microsoft Enterprise Data Access Application Block to access data from SQL Server.
- Developed web interface using C#/ASP.NET in VS2003 IDE.
- Design and Developed with object oriented approach.
- JavaScript programming & XMLHTTP Request for AJAX.
- Designed SQL Server database using normalization rules.
- Written Functions, Stored Procedure for data access using T-SQL in SQL Server 2000
- Writing triggers for data audit trails using T-SQL in SQL Server 2000
- Tested different Modules and their functionality before and after bug fixes for regression testing.
- Version control using Visual Source Safe (VSS)
- Prepared Release scripts documentation.
Environment: OOPS, .NET framework 1.1, ASP.NET, VB.NET, SQL Server 2000, JavaScript & AJAX
Confidential, NYC
Lad Programmer/Analyst Apr 06 - Sept 06
Projects:
- Retail Finance Forecasting Tool (RFFT)
- Ultimate Time & Attendance (UTA)
Responsibilities
- Developed Prototype.
- Prepared System Design Documents.
- Developed class library, Business & Data Access layers using OOPS and .NET
- Developed web interface using C#/ASP.NET in VS2005 IDE.
- Designed SQL Server database using normalization rule.
- Used Microsoft Enterprise Data Access Application Block to access data from SQL Server.
- Written Stored Procedure for data access using T-SQL in SQL Server 2005
- Written triggers for data audit trails using T-SQL in SQL Server 2005
- Used Component One Web Grid 2.0 for display of data in tabular format.
- Developed and Integrated Active Directory Security module for authentication and authorization of user.
- Developed GUI interface for Search/Add/Update/Delete user from Active Directory
- Successfully completed the migration of code from 1.1 to 2.0 and fixing of bugs and changes.
- Uploading data from excel sheet into DB.
- Displaying the data from SQL Server into excel sheet using web query.
- Developed Health monitoring and alert mechanism to check the status of application and generating alerts for the missing file or rejected file via email for UTA.
- Tested different Modules and their functionality before and after bug fixes for regression testing.
- Pro actively anticipated and addressed project obstacles during development phase
- Version control using Visual Source Safe (VSS)
- Prepared release scripts documentation.
Environment: OOPS, .NET framework 2.0, ASP.NET 2.0, VB.NET, C#, SQL Server 2005. Oracle 9.2, Component One Grid 2.0
Confidential
Team Lead Oct 03 - Feb 06
Projects:
- Bill Payment via SMS
- BatelcoXchange
- 3D Security for Payment Gateway using VbV program
- E-Government Portal
Responsibilities:
- Interacted with business users to gather and analyze functional requirements
- Developed Use Cases, POC & Prototype.
- Built algorithms, flowcharts, Sequence diagrams, data flow diagrams (DFDs)
- Developed Web Service using VB.NET to interface with the prepaid Gateway Server for Prepaid top up & payment gateway
- Developed web interface using ASP.NET for registration of the service and storing the credit Card information.
- Developed TCP/IP listener using VB.NET to receive.
- Designed front-end Graphical User Interface (GUI) in Windows & Web forms and screens using VB.NET controls instances and Visual Studio.NET developer interface, Microsoft Development Environment (MDE) for data entry and validation, Functions (function procedures), sub-routines (sub-procedures) and methods
- Created XSD file for SELECT, INSERT, UPDATE to send XML requests, process XML requests and then retrieve data over a connection via MQ Client (using control instance, its classes, methods, properties) from the CA Datacom DB making it available to the solution
- Oversee project test planning and execution. Tested different Modules and their functionality before and after bug fixes for regression testing. Performed Unit, Integration, System, Regression and UAT testing
- Managed and allocated resources to ensure timely delivery of results
- Anticipated and addressed project obstacles and issue resolution and escalation
- Version control using Visual Source Safe (VSS)
Environment: .NET framework, ASP.NET, VB.NET, ADO.NET, SQL Server2000, Oracle 9.2, XML, Microsoft Visio, Microsoft Project, DB2, PHP, XML
Confidential
Sr. Programmer Analyst/Team Lead Oct 02 - Sept 03
Projects:
- Mobile Payment Gateway (MPG)
- Smart Retail Solution
- PetroSmart
Responsibilities:
- Interacted with business users to gather and analyze functional requirements
- Prepare SOW, URS, and System Design Documents.
- Developed Web Based Backend Application to interact with Smart Card and Vending Machines.
- Integrating the application with Payment Gateway, facilitating payments by Credit/Debit Card.
- Developed protocols for interaction with Mobile Commerce hub for SMSC Connectivity
- Oversee project test planning and execution. Tested different Modules and their functionality before and after bug fixes for regression testing. Performed Unit, Integration, System, Regression and UAT testing
Environment: ASP, COM, VB, Oracle 9.2, Smart Card Reader, Palm, Serial Communication, MSCOM controls, Winsock control, POS
Confidential
Sr. Programmer Analyst Jan 01 - Sept 02
- Designed and developed various web applications using Visual Basic 6, asp & SQL Server. Developed database schemas & created stored Procedures / Views / User defined functions
Environment: ASP, COM, VB, Oracle 9.2, SQL Server 7, JavaScript and VBScript and IIS.
Confidential
Programmer Analyst May 98-Dec 00
- Worked on various client/Server program using Oracle 8.0 and VB 6.0 as Front-end in multi-user application.
