Programmer Analyst Resume Profile
NJ
SUMMARY
- 10 years of experience in the field of Information Technology with responsibilities including Analysis, Design, Development, Testing and Implementation of Software Systems and Web Application development.
- Strong understanding of the Microsoft .NET Framework. Experience in developing applications using C , ASP.Net, VB.Net, ADO.NET, .Net Framework 1.1/2.0/3.5, Microsoft Enterprise Library, IIS, AJAX, JavaScript, SQL Server 2000/2005/2008, LINQ, VSS, TFS, SQL Server Reporting services SSRS , SQL Server Integration Services SSIS , Crystal Reports.
- Well versed with Visual Studio IDE 2003/2005/2008 .
- Team lead experience. Used tools for project planning, resources estimation, work allocation, budget estimation. Experience in various stages of Software Development Life cycle SDLC from Project Initiation to Project closure. Exposure to Software design tools like Microsoft Visio and project management tool Microsoft Project.
- Exposure to Object-oriented analysis and design OOAD , Design Patterns. Possess a good understanding of Object Oriented concepts and its inherent implementations.
- Knowledge of agile development methodology Scrum
- Good experience in creating and consuming web services, WCF services.
- Experience in data modeling relational database and Entity-Relationship ER modeling.
- Good knowledge of writing Stored Procedures, Functions, Views, Triggers using SQL Server.
- Knowledge of MultiThreaded programming.
- Experience of onsite-offshore coordination model.
- Proficient in defining user needs and developing project requirements and converting them into functional specifications to meet those needs.
- Excellent team player and execute tasks under less supervision.
- Highly motivated and adaptive with the ability to grasp things quickly and possess excellent interpersonal, technical and communication skills.
Technical Skills
| Microsoft .Net | Visual Studio 2008/ 2005/2003, .Net Architecture, .Net Framework 3.5/2.0/1.1/1.0, Microsoft Enterprise Library, IIS, ASP.NET, ADO.NET, C , VB.NET, LINQ, AJAX, WCF |
| Web Development | Web Services, ASP.NET, XML, XSLT, HTML, VB Script, Java Script, Cascading Style Sheets CSS |
| Database | RDBMS, MS-SQL Server 2000/2005/2008, Oracle 10g, PL/SQL, DTS |
| Software Tools | Visual Source Safe VSS , Team Foundation Server TFS , SQL Server Reporting Services SSRS , SQL Server Integration Services SSIS , Crystal Reports, Rational Robot, TOAD |
PROFESSIONAL EXPERIENCE
Confidential
Role: Programmer Analyst
Worked on the LTC Web project for the client. It is a web based system built by HRA MIS which replaces multiple systems with one software application. It is used by all HRA home care services workers as well as vendors, contractors and sister agencies such as HASA, ACS, and APS. LTC web interfaces with WMS HRA client information repository to ensure consistent client Medicaid data and it also interfaces with NYS eMedNY to request and modify Prior Authorization on line. It has reduced time for the processing of PA numbers which has also reduced billing issues. It provides electronic documentation of each encounter and has made information more accessible for audit and fair hearing purposes.
Responsibilities: -
- Developed high-volume web application and addressed performance and scalability concerns. Consistent and reusable GUI was developed.
- Follow Object-oriented analysis and design concepts in development.
- Prepared Unit and Integration Test Plans. Also responsible to document the changes and coordinate with the testing group to get the signoff to deploy the code to production.
- Follow the Software Development Life cycle SDLC for project development.
- Implement new modules using AGILE methodology.
- Implemented proper Database logging and Exception Handling.
- Worked on development and enhancements of many different modules of the web application as part of business enhancements.
- Completed ad hoc maintenance requests sent by business users.
- Wrote Transact-SQL queries. Implemented business functionality through Stored Procedures and Functions in SQL Server 2008.
- Responsible for bug fixing and change requests.
- Involvement in database design, creation of database objects like Database Tables, Stored Procedures, Functions, Views, Triggers, indexes in SQL Server 2008.
Environment: Windows Server 2003, IIS6, Visual Studio 2005/2008, ASP.Net, VB.NET, .Net Framework 2.0/3.5, WCF, PL/SQL, TSQL, SQL Server 2005/2008, HTML, DHTML, CSS, AJAX Control Toolkit, XML, JavaScript, Visual SourceSafe, Crystal Reports.
Confidential
Role: Sr. .Net Consultant
Food Stamps Employment System
The HRA agency provides food stamps to the New York City residents if they meet certain criteria. This project determines the population of eligible residents and assigns them to different vendors who provide employment services to these people. The FSES is a mandatory program for certain eligible New York City Food Stamp recipients to enroll in employment activities.
Responsibilities: -
- Also responsible for bug fixing reported during Unit Testing and UAT User Acceptance Testing for the above mentioned modules in FSES. This involves troubleshooting the Presentation, Business and Data Layers and interacting with other groups including the Oracle DBAs and System Administrators. Oracle database was used for data storage.
- Implement new functionality like Car Fare, Voluntary enrollment as separate modules. These new modules are developed using AGILE methodology to follow the existing FSES SOA architecture.
- Follow the Software Development Life cycle SDLC for project development. Assist to gather business requirements and create prototype for the business users to get the signoff for development. After receiving the signoff on the requirements from the business sponsors, start the development of the application.
- Also responsible to document the changes and coordinate with the testing group to get the signoff to deploy the code to production.
- Follow Object-oriented analysis and design concepts in development based on HRA standards.
- As a senior developer, also involved in converting existing proprietary JQuery code to a more generic Open source JavaScript technology to adhere to the SOA Service Oriented Architecture standards.
- Developed high-volume web application and addressed performance and scalability concerns. Consistent and reusable UI was developed as per HRA standards. Also implemented cross browser compatibility.
- Mentor junior Dot Net Developers in the team. Provide them with technical guidance and motivation as a Team Lead.
- For a Data Warehousing module, designed and developed SSIS package to import and extract data from a flat file, transform the data using lookup transformations, parse and load data into a SQL Server table.
- Used Microsoft Enterprise Library for implementing standard error handling, logging and exception handling. Application Infrastructure Security was maintained by a health monitoring system which tracked all security related error events.
- Follow the HRA change management process to deploy the code from UAT environment to the FSES production environment.
Environment: IIS 6, Visual Studio 2005, ASP.NET, VB.NET, .Net Framework 2.0, HTML, CSS, JavaScript, JQuery, WebForms, SSIS, Oracle 10g, SQL Server 2005.
Confidential
Role: Sr. .Net Developer
ZBI Tickets
ZBI offers events tickets to employees. The ZBI Tickets application lets employees set their event, specific event session and number of tickets preferences. The ZBI Tickets content management web application is available to the admin who approves requests and grants tickets based on a ranking system which is governed by several business rules.
Responsibilities: -
- Worked directly with the client to gather the requirements. Prepared business requirements document BRD .
- Designed the relationship diagram based on the requirements. Also designed the complete web application.
- Developed parts of the Content Management application.
- Used Visual Studio .NET 2008, Framework 3.5 class library, C language for development.
- Implemented error logging and exception handling. Application Infrastructure Security was maintained by tracking all security related error events like unsuccessful login attempts.
- Unit and integration testing of both applications.
- ZBIWeb Training and ZBIWeb Content Management
- ZBIWeb is the intranet web application of ZBI. ZBI provides growth opportunities, both professional and personal, for all members of the ZBI community. Training both internal and external classes are organized. The training application has two components one is a part of ZBIWeb ZBIWeb Training and the other is accessible only to the training administrators ZBIWeb Content Management . The ZBI employees can view available classes and session schedules and can register for those classes. The training administrators manage classes and session schedules through the ZBIWeb Content Management web application. They can also generate reports.
Responsibilities: -
- Worked directly with the clients to gather the requirements on various enhancements to the applications. Mentored junior developers in the team while leading a team of 6 developers.
- Designed and developed functionalities like Course registrations, Auto-approval batch process, Notifications, Evaluation, External Courses etc.
- Used Strategy and Factory Design Patterns.
- Designed Reporting framework. This framework generates reports based on the user's filter criteria. All controls for filter criteria are generated at runtime depending upon the report selected.
- Used Visual Studio .NET 2005, Framework 2.0 class library, C language for development.
- Involvement in specification preparation like functional specification and technical specification documents.
- Application security was implemented as a separate module which logged all threats to infrastructure security.
- Developed the relational database diagram using SQL Server data modeling interface. SQL Server was used for application data storage.
- Developed Dot Net WebForms using C . Cascading Style Sheets CSS were used in order to ease the client side web development process.
- Designed and developed data access layer class libraries and helper libraries in C .
- Involvement in database design, creation of database objects like Database Tables, Stored Procedures, Functions, Views, Triggers, indexes in SQL Server 2005.
- Used many Ajax controls from the ASP.NET AJAX Control Toolkit. Implemented active search functionality using Auto-complete extender and a webservice which fetches employee data based on Name.
- Implemented certain client-side functions in JavaScript.
- Unit and integration testing of both applications.
- Preparation of implementation plan and release document.
- Deployment to Development, Staging and Production servers.
Environment: IIS6, Visual Studio 2005/2008, ASP.Net, C , .Net Framework 2.0/3.5, TSQL, SQL Server 2005, Oracle 10g, HTML, DHTML, CSS, AJAX Control Toolkit, JavaScript, WebForms, Visual SourceSafe, Crystal Reports.
Confidential
Role: Sr. .Net Developer
No Child Left Behind NCLB
- The No Child Left Behind Act, is a Confidential federal law that reauthorized a number of federal programs aiming to improve the performance of U.S. primary and secondary schools by increasing the standards of accountability for states, school districts, and schools, as well as providing parents more flexibility in choosing which schools their children will attend.
- The NCLB application is used by the vendors to enroll their students, upload their attendances and generate invoices. It facilitates the DOE admin to view and approve the data entered by the vendors.
Responsibilities: -
- Worked for the financial operations division of the Department of Education.
- Used Visual Studio .NET 2008 for development. Used VB.Net framework 3.5 class library.
- Developed user interaction models and flow diagrams
- Developed the relational database diagram using SQL Server data modeling interface.
- Used LINQ Language-Integrated Query for database access. Used DBML file for adding database tables, stored procedures and functions.
- Implemented ASP.NET 3.5 Master Pages. Used TreeView control for displaying navigation menu. Used contents of Sitemap file to specify the navigation structure of the website.
- Used Web controls, DropDownList controls, GridViews with custom controls and Validation controls. Developed user controls for common functionality in different WebForms.
- Implemented Ajax using UpdatePanel, UpdateProgress, ScriptManager.
- Used many Ajax controls from the ASP.NET AJAX Control Toolkit like Calendar, ConfirmButton, HoverMenu, MaskedEdit and extender controls.
- Used ADO.NET 3.5 DataSet for data access and DataTable as DataSource for data binding many GridView controls throughout the application.
- Implemented proper Database logging and Exception Handling.
- Created and consumed Web Services to fetch student data.
- Developed reports using SQL Server Reporting services SSRS .
- Responsible for bug fixing and change requests.
- Tested application for cross-browser compatibility. Application was tested for MS Internet Explorer, Safari, Mozilla Firefox and Google Chrome.
- Unit and integration testing of system. Assisted in independent testing, final deployment of the application and sign-off from client.
Confidential
Worked on multiple SIS - Student Information Systems applications.
Responsibilities: -
- Used Visual Studio 2003 and .Net 1.1 framework class libraries for development.
- Used SQL Server 2000 for database operations.
- Understood business functionality of few SIS applications.
- Worked on a Windows application to generate data based on user requirements. Also implemented Export to Excel and Export to csv format functionality.
- Wrote Transact-SQL queries and Stored Procedures to implement the business functionality. Worked on the performance optimization using Query Optimizer to retrieve large number of records in lesser time.
- Worked on changing In-Proc state management to Out-of-Proc for 4 web applications. This included changing the state in web.config file and full testing of the application and make changes if needed for state management.
- Consumed Web Services to fetch student data.
- Used Visual SourceSafe for version control.
Environment: IIS6, Visual Studio 2008/2003, VB.Net, ASP.Net, C , LINQ, DBML, .Net Framework 3.5/1.1, TSQL, SQL Server 2005/2000, Oracle, MOSS, HTML, DHTML, CSS, XML, XSL, AJAX, JavaScript, WebForms, Team Foundation Server, Visual SourceSafe, SQL Server Reporting services SSRS .
Confidential
Role: Sr. .Net Developer
ConEdison provides electric service to the various boroughs of NYC and the Westchester County. In some of these boroughs some incidents were reported which were caused due to the presence of stray voltage near the manholes on the streets. This intranet web application was developed to give an overview about the inspections of different electric structures, stray voltage testing and positive readings in the different networks.
Responsibilities: -
- Requirement gathering, Analysis and preparation of design documents.
- Prototype development and finalization of user requirements.
- Involved in user interaction.
- Used Object Oriented concepts. Thorough understanding of Entire SDLC Process.
- Used Visual Studio .Net 2005 for development. Used .Net framework 2.0 class library.
- Developed Dot Net WebForms using VB.Net 2.0.
- Used Web controls, DropDownList controls, DataGrids with custom controls and Validation controls
- Implemented web sitemap with navigation control using ASP.Net.
- Implemented excel style multi row update using Data Grid Control.
- Implemented SQL bulk copy for uploading data from excels into SQL Server 2005.
- Wrote TSQL queries and Stored Procedures to implement the business functionality.
- Created DTS packages for data download from mainframe file to SQL Server 2005 database tables.
- Responsible for the setting up Development, QA and production environments.
- Unit and integration testing of system. Assisted in Regression testing.
- Used Visual SourceSafe for version control.
Environment: IIS6, Visual Studio 2005, VB.Net, ASP.Net, .Net Framework 2.0, TSQL, SQL Server 2005, JavaScript, VBScript, HTML, CSS, XML, XSL, Visual SourceSafe 6.0.
Confidential
Role: Sr. Software Developer
eProjectLink system provides a central place to track the status, target, date, manager and resources associated with each ongoing project. At a basic level, eProjectLink is a web site and project database, but more importantly it is a management and communication tool that supports enterprise project management and oversight of the entire portfolio of projects.
Responsibilities: -
- Worked directly with the clients to gather the requirements, for improving the client's business process.
- Object oriented Analysis, designing of the system based on system requirements.
- Was involved from the transition phase of this application. Did knowledge transfer during application development phase to gain complete functional and technical understanding.
- Worked as a team lead for about 6 months. Did resource estimation and work allocation. Worked in the onsite-offshore model and had responsibility of offshore team. Also provided technical guidance to freshers in the team.
- Did design, coding, code review in C , ASP.Net, SQL Server. Developed Dot Net WebForms using C .
- Used Web controls, DropDownList controls, DataGrids with custom controls and Validation controls RegularExpression, Range, Compare, Required and Custom validators .
- Used ADO.Net for data binding and data interaction between the web application and the Database.
- Implemented Master Pages. Used TreeView control for displaying navigation menu. Used contents of Sitemap file to specify the navigation structure of the website.
- Used ComponentArt Web.UI toolkit Calendar and TreeView controls.
- Involved with writing TSQL queries and stored procedures in SQL Server 2005 for implementing various functionalities.
- Created DTS packages for data download from mainframe file to SQL Server 2005 database tables. This included writing ActiveX scripting code. Implemented data transformation and scheduled nightly jobs.
- Responsible for bug fixing and change requests.
- Conducted unit testing, independent testing, regression testing, system testing, final deployment of the application and PVT sign-off from client.
- Used Visual SourceSafe for version control.
Environment: IIS6, Visual Studio 2005, C , ASP.Net, .Net Framework 2.0, HTML, CSS, ComponentArt Web.UI 2006.2, TSQL, SQL Server 2005, JavaScript, VBScript, MWAST Microsoft Web Application Stress Tool , Visual SourceSafe 6.0.
Role: Senior Dot Net Developer
Confidential
Responsibilities: -
- Was responsible for gaining complete system knowledge of 56 applications of the Fastpath cluster. Attended class room sessions and workshops and worked cohesively with Telstra support staff to gain information about the applications.
- Role of onsite-offshore coordinator. Transitioned all knowledge gained from Telstra staff to the offshore team.
- Developed System Appreciation document, and other required support documents.
- Involved in the migration of all applications from desktop machines to controlled environment.
- Changed certain existing Dot Net WebForms and WinForms as per client's requirements.
- Interacted directly with the client and end-users and fixed bugs in the applications. These applications were mainly in VB, VB.Net and ASP.Net with SQL Server 2000 database.
- Implemented various team processes to streamline various functions for faster response.
- Implemented structured Un-Structured exception handling. Implemented appropriate Error Handling and Logging in C .
- Optimized TSQL queries in SQL Server 2000 database.
- Added all applications to version controlled environment. All these applications were earlier installed on Telstra employees desktops. Used Visual SourceSafe and Clearcase for version control.
Environment: IIS6, Visual Basic, VB.Net, C , ASP.Net, HTML, CSS, Dot Net Framework 1.1, TSQL, SQL Server 2000, Oracle, Clearcase.
Confidential
Role: Dot Net Developer
Responsibilities:
- Worked as a developer, working directly with the onsite team.
- Involved in Design and Coding using VB.Net.
- Involved in complete prototype design and class design. Prepared design documents, Class-level diagrams, sequence diagrams and activity diagrams to depict the business flow. Implemented Fa ade Design pattern.
- Design and coding of two modules Prepared Class-level diagrams, sequence diagrams and activity diagrams to depict the over-all business flows for the modules
- Used DataGrid control throughout the applications. Used DataReader for data access.
- Wrote classes, functions and procedures. Implemented Error Handlers and validations.
- Used ADO.Net for data interaction between the web application and the Database using Data Reader, Datasets and Data Adapters.
- Wrote SQL queries and stored procedures for SQL Server. Worked on improving performance of existing reports by optimizing Stored Procedure queries.
- Report-generation using Crystal Reports.
- Used FxCop static code analysis tools.
- Extensively involved in Code inspections, Design and Test Plan reviews, to deliver the bug free product, without any post release defects.
- Analyzed requirements documents and understood project lifecycle and complex technology while working as a fresher in the team.
- Worked in the File Transfer Process FTP module developed as a replacement for merge replication process because of un-stability and known bugs in merge-replication technology XML data files were created and compressed. Then these files were exchanged between counters and back office, using FTP protocol. I worked on the Conflict Resolution and Purging components. Involved in Writing Unit / Integration / System Test Cases.
- Developed certain application pages on .Net Compact framework for the NEC handheld devices.
- Used Visual SourceSafe for version control.
Environment: VB.Net, .Net Framework 1.1, .Net Compact Framework 1.1, SQL Server 2000, Visual SourceSafe 6.0, Rational Robot, Crystal Reports
