Design Analysist Resume
Warren, NJ
Summary:
- Over 7 years of experience in design, development and deployment of commercial and business application software in web based and distributed environment.
- Experience in user requirement gathering, requirements specifications preparation, analysis, design, coding, testing and implementation of the applications.
- Expertise in ASP.Net, VB.Net, C#, ASP, Visual Basic, IIS, HTML, JavaScript, CSS, XSL, XML and MS SQL Server.
- Hands-on experience in Microsoft tools such as MS Visual Studio 2005, Windows NT/2000/XP, MS-visual source safe, MS-Visio.
- Strong coding experience in SQL stored procedures, queries, views and DTS/ SSIS.
- Worked with COM technologies to create business layer and data access layer.
- Designed and Developed applications for multiple domains with good programming experience in WinForms, WebForms UI designing, User controls and Custom controls, Win Forms using Microsoft technologies (VB.NET, ASP.NET, C#, ADO.NET, XML, XSL, ASP, Visual Basic, HTML, Oracle and SQL Server).
- Have experience in Client interactions by understanding their business requirements and giving solutions, design, development, testing/QA, deployment/implementation, maintenance andProduction support.
Operating Systems
WINDOWS 2003 / 98/ NT / 2K and XP
Languages
C#, ASP.NET, VB.NET, Visual Basic 6.0, C, C++
Front End’s
Visual Studio .NET, Visual Studio
Databases
SQL Server, Oracle
Internet Technologies
ASP, ASP.Net, JSP, HTML, Java Script, VB Script, XML, XSL, CSS, IE, Netscape
Data Access
ADO.NET
Configuration Tool
Visual Source Safe and Concurrent Versions System
Methodologies
UML and OOAD
Others
VISIO, Far Point Grid controls
Reporting Tools
Data Reports
Web Servers
IIS
Education:Master of Computer Application (MCA)
Bachelor of Science in Mathematics (BSC.,)
- Microsoft Certified Professional (MCP) in Developing and Implementing Web applications with Microsoft C# and Microsoft Visual studio. Net
- Microsoft Certified Professional (MCP) in Developing and Implementing Web applications with Microsoft VB.Net and Microsoft Visual studio. Net
- Microsoft Certified Professional (MCP) in Developing and Implementing Database with Microsoft SQL Server 2000 enterprise edition
Professional Experience:
Confidential, Warren, NJ Jun ‘07 to Dec. 09
- BPK (Payments module)
The application facilitates the Customer to pay their Verizon bills using Bill Payment Kiosk(BPK) machines. Customer enters their MTN and PIN, after validated successfully, the customer can make payments such as Cash, CreditCard, Cheque, GiftCards. Finally, after successful processing their transactions the application will print the receipt. We have completed successfully all the AllTel Conversion enhancements and implemented successfully in Production with no errors.
Roles & Responsibilities:As a Team Member, my job roles & responsibilities included:
- Analysis of the client requirements and subsequently documented them.
- Create prototype of the screens and get approval from business team.
- Developed Web Pages using ASP.NET, VB.NET, HTML, CSS, Macromedia Flash, XML, XSL, Javascript and VBScript.
- Created .aspx, .ascx using VB.NET using .NET Framework 2.0
- Creation of business and data layer using VB.NET.
- Intensive usage of ADO.NET for Data Manipulation.
- Used Dataset, Data View, and Data Adapter to manipulate and display data.
- Development of Bill Payment Data Tier, process through XML and transformation using XSL.
- Modification of the transaction modules such as Select Payment methods, display Account Summary, Billing Details, Cash, CreditCard and Receipts.
- Manipulation and validations using Javascript and VB Script.
- Prepared Unit Test Cases and Unit test plans, Integration test plans and testing for correctness and validation of data including all functionalities.
- Production support and bug fixing of the implemented modules.
- Using VSS for configuration management.
Environment: ASP.NET 2.0, VB.NET, ADO.NET, ASP 3.0, Visual Basic 6.0, SQL Server 2005, CSS, VB Script, Java Script, Macromedia Flash, HTML, Visual Studio, IIS, MS-Visual Source Safe, Microsoft Application Blocks
- CreditCardSwipe
The project was developed/enhanced to support/accept the Credit Card and Debit Card payment functionalities using Signature Capture Pad. The screens are designed to accept/validate CreditCard Details like CreditCard Number, Expiration Date and other relevant details. The trackdata\'s are captured/stored using the extended methods provided by SigBox Activex Controls. The user can swipe Credit/Debit Cards or enter manually all the Credit/DebitCard details. For DebitCard, PIN screen is provided for the user to enter 4-digit pin.
Roles & Responsibilities:- To understand the requirements, prepare requirement documents and get approval from project manager.
- Involved in all the SDLC processes.
- Create prototype of the application and get approval.
- Design and Develop User Interface (WinForms) using VB.NET.
- Creation of Components using VB.NET front-end application.
- Creation/ Modification of WinForms for CreditCard/ Payment Selection options using VB.NET.
- Developed various Stored Procedures, Indexes and Views using SQL Server to maintain Business Logic and enforce Data Integrity. (T-SQL).
- Unit testing and Integration testing of the modules.
- Used VSS for configuration management.
- Building the application and implementation.
Environment: Microsoft .NET Framework 2.0, Visual Studio.NET 2005, VB.NET, SQL Server 2005, VSS
- DisplayItems – Phase I
The project was developed to show the scanned items/ accessories/ sku\'s each line onto the Signature Pad. The functionality is legal mandate in California location, and implemented Phase I. I have developed and written the functions using VB.NET and call those functions from ASP.NET. The various methods were written to check whether SigBox is connected to PC, SigBox clear and Disconnect by calling from ASP. This project was implemented with no errors in Production.
Roles & Responsibilities:- Understanding the requirement and co-ordinated with the team and created prototype of applications
- Design of presentation layer for modules .
- Creation of Components using VB.NET and calling those functions from ASP.NET front-end application.
- Usage of Sigbox OCX intensively and calling those methods in the project.
- Unit testing and Integration testing of the modules.
- Used VSS for configuration management.
- Building the application and implementation.
Environment: ASP.NET, VB.NET, SQL Server 2000, CSS, VB Script, Java Script, HTML, Visual Studio, IIS, VSS
- DisplayItems – Phase II
The project was developed to show all the list of items with total item discount & pricing during Checkout. If items/sku\'s are more than 10 items, I have written logic to handle the pagination functionalities by providing Prev/Next buttons in Sigpad, so that customer can view all the items in the Signature Pad.
Roles & Responsibilities:- To understand the requirements, prepare requirement documents and get approval from project manager.
- Involved in all the SDLC processes.
- Create prototype of the application and get approval.
- Design of presentation layer for modules .
- Creation of Components using VB.NET and calling those functions from ASP.NET front-end application.
- Wrote Stored Procedures, Queries in SQL Server 2000.
- Unit testing and Integration testing of the modules.
- Used VSS for configuration management.
- Building the application and implementation.
Environment: ASP.NET, VB.NET, SQL Server 2000, CSS, VB Script, HTML, Visual Studio, IIS, VSS
Confidential, Orlando, FL Oct ‘05 to Feb ‘07- Interlink Healthcare
The website is developed for Interim. They have two core businesses - home health care and facilities (staffing). The goal of this website is to provide the entire gamut of internal work of Interim. In the home care segment, the client calls Interim for requesting of services to be given. Based on the requirement by Client, Interim will check the worker compatibilities, availability and schedule them to the client. Before starting the services, Interim will check with the client whether any Insurance (Payer) coverage is done. Once when the worker completes the services to the client, they will report to the office about their schedule of confirmation. While billing, schedule verification of the worker schedule for the client is checked for correctness. In the facility segment, Interim provides work force to the Facilities based upon the Worker compatibility. Based on the need in the Department/Unit, the worker will be sent to the location and schedules are recorded.
Role & Responsibility:- As a Team Member was responsible for:
- Involved in entire SDLC from analysis, design, coding, testing, bug fixing and implementation.
- Involved in Database design to create Tables and Views for Client Intake, Payer, Facility and Worker modules.
- Developed Web Pages using ASP, ASP.NET, VB.NET, HTML, CSS, VBScript and Javascript
- Wrote stored procedures for the functionalities using SQL Server and did performance tuning for the same.
- Usage of SQL Profiler intensively to trace the stored procedures and retrieve the required manipulating data.
- Creation of the presentation layer in WEB FORMS for the modules Client Intake, Payer, Facility, Department, Worker, Care Manager, Service Types, Payroll and Billing modules based on Worker Schedule verification.
- Wrote the code for the Data Access and Business Layer using VB and presentation layer using ASP and ASP.NET for the application.
- Developed Data Tier components and business logic using Visual Basic and C#.
- Used Dataset, Data View, and Data Adapter to manipulate and display data.
- Creation of User controls in VB for reuse in the project.
- Usage of VB Script and JavaScript functions for the client side validations.
- Prepared Unit Test Cases and Unit test plans, Integration test plans for the Developed functionalities.
- Used VSS for configuration management.
Environment: ASP 3.0, Visual Basic 6.0, ASP.NET 2.0, VB.NET, ADO.NET, SQL Server 2005, CSS, VBScript, Java Script, HTML, Visual Studio. NET, IIS, MS Visio, MS Visual SourceSafe, Microsoft Application Blocks
Confidential, Los Angeles, CA Jul ‘05 – Oct ‘05- Twain
Project TWAIN is a legal rule authoring and publishing tool with accompanying web services to support schedule calculations based on legal rules. Additional web services are included to handle licensing and distribution of rules sets to end-users. The authoring tool on will provide standard maintenance functionality for the creation of Event Codes, holidays, method of services, method of service templates, user accounts, etc. A sub-set of the authoring tool will be available for the end user to create custom rules sets and event templates.
Role & Responsibility:- Created prototype of the modules.
- Creation of DFD using MS–Visio for work flow in the project.
- Job role includes screen designs, code, testing and implementation.
- Developed Web Pages using ASP.NET, C#, HTML and Javascript
- Designed and Coded Procedures, Tables & Views.
- Involved in designing and writing the code for capturing the Demographics information for Event Codes, holidays and method of service modules.
- Developed Data Tier components (Assemblies) using C#.NET
- Used Dataset, Data View, and Data Adapter to manipulate and display data.
- Wrote JavaScript functions for all client side validations.
- Intensive usage of CSS across the application.
- Prepared Unit Test Cases and Unit test plans, Integration test plans for the Developed functionalities.
- Recording the Change request and modification to the screen and stored procedures.
- Bug fixing of the modules.
- Used CVS and VSS for Configuration Management
Environment: C#, ASP.NET 2.0, ADO.NET, SQL Server 2005, Java Script, HTML, Visual Studio. NET, IIS, MS Visual SourceSafe
Confidential, Germany Mar ‘05 to Jul ‘05- E6 - System
Henkel is in the manufacturing and selling of brand name products and system solutions. The project is developed to maintain the stock & inventory control for their Home Care, Personal Care and Adhesives products. To maintain their inventory needs, the E6-System is divided into various segments like brand and division. The enhancement for the modules brand and division is done to process and generation of E6 - reports.
Role & Responsibility:- Responsible for analysis, design changes, coding, testing, implementation and maintenance of the project. Understand the client’s existing application and interact with the client for enhancement of their requirements.
- Understand the existing Stored Procedures and make changes to the stored procedures for enhancement of E6 system.
- Creation of Data Transformation Services (DTS) package for the Client to upload data for computation and storage in the respective tables.
- Performance tuning done to the Stored procedures to make it faster.
- Used Microsoft Application Blocks for data manipulation.
- Involved in writing the code for capturing the Demographics information for enhancement of Brand, Division, SKU and other modules.
- Developing Web Pages using ASP.NET, C#, HTML and Javascript
- Creation of User Controls and business components using C#.
- Implemented role based security for the modules.
- Recording the Change request and modification to the screen and stored procedures.
- Implementation of the application at client location.
Environment: C#, ASP.NET, Visual Studio .Net, Web Forms, ADO.NET, SQL Server 2000, IE, Microsoft Application blocks, Visual Source Safe
Confidential, Netherlands Nov ‘04 – Mar ‘05- Invoice Printing
Dekatel is in the business of selling mobile phones to different customers under various schemes. They do sell mobile phones to the Customer through their dealers. Dekatel and their dealers give various schemes/ discounts to the customers. The goal of this application is to maintain Customer and mobile phone details to keep track of their calls (business/ private/ weekend/ holiday) at various schemes that were offered. The enhancement in the application is done to cater these schemes and to track customer details and print Invoice every month and send it to their customers.
Role & Responsibility:- Responsible for analysis, design changes, coding, testing, bug fixing, implementation and maintenance. To understand the existing application / stored procedures and made changes based on the enhancement of requirements.
- Develop Web Pages using C#, ASP.NET, HTML.
- Create additional tables, stored procedures using SQL Server.
- Creation of Linked Server to split three databases on single machine into multiple machines.
- Creation of Data Transformation Services (DTS), to split multiple tasks and assign Work Flow of tasks and used in front-end applications.
- Code changes for Customer Details and transaction modules.
- Involved in implementing the Login/Role-based security for the module.
- Intensive usage of ADO.NET concepts.
- Unit testing and Stress testing done.
- MySDS Pro
MySDS is a cost-effective solution for automating the distribution of SDS. Chemical users access the latest information on-line and the automated alert service keeps users up to date with any significant changes - ensuring suppliers meet their legal obligations. MySDS can easily be integrated into existing e-commerce solutions to provide chemical hazard information to prospective on-line purchasers at the point of sale and ensures to maintain sales without compromising on safety.
Role & Responsibility:- Involved in making enhancement changes to code and test the system. Understand the existing application to make enhancement changes for the modules.
- Wrote Stored Procedures using SQL Server and involved in making existing SP changes.
- Handling Session and other objects in the Code-behind part.
- Code changes to the modules Master, Company Pages and SDS Index.
- Wrote business logic methods using VB.
- Incorporated some client-side validations using Javascript.
- Intensive usage of CSS across the applicationto make the page look consistent.
- Unit Testing of the modules.
- Project Tracking System
The project is developed for CSS using windows application. The modules covered are project, client, model types and resources. The goal of the application is to maintain the list of projects with tracking facilities like project start date and end dates. The modules resources and clients are linked with projects and model types (Billing / Application / Execution Model) in order to make these integrated under one roof. Upon linking all the modules, it is easy to look up the drill down reports across the projects.
Role & Responsibility:- To understand the requirements, prepare requirement documents and get approval from project manager.
- Involved in all the SDLC processes.
- Create prototype of the application and get approval.
- Design of presentation layer for modules like Project, Client, Model Types and Resources and implementation of the business logic in class libraries using Visual C#.
- Creation of Stored Procedures for the modules and calling the Stored Procedures from front-end application.
- Usage of Microsoft Application Blocks in the projects for data manipulation.
- Developing Data Tier components (Assemblies) using C#.NET
- Unit testing and Integration testing of the modules.
- Used VSS for configuration management.
- Building the application and implementation.
- Automation of Manufacturing Division
The Materials Management sub system is for maintaining the stock and inventory details of Perfect Gears. The functionality developed covers from receipt of Quotations by Suppliers and issue of Purchase Order to Suppliers, issue of Quotations to Client and receipt of Purchase Order from Client, to keep track of materials delivered (GRN) and receipt of damaged materials (return DC). Once when the good are received from Suppliers, the payments are made through Accounts Department. The Payroll Maintenance sub system developed covers from maintaining employee details to generate pay slip.
Role & Responsibility:- Responsible for requirement gathering, analysis, design document, coding, testing, bug fixing, implementation and support. Interact with Business Associates for requirements gathering to perform system development.
- Recorded the changes in the requirements after discussion with the clients and change in the design.
- Creation of prototype using Visual Basic and show demo to the Client and discussed about the project.
- Database design for the entire modules done and get approval from my Project Lead.
- Coding the modules: Quotation, Purchase Order, GRN, DC, BOM and other modules. Intensive usage of User Controls and OCX controls in the applications.
- Usage of COM (DLL), for making all Database related transactions.
- Usage of third-party tool Far Point Grid Control in the modules.
- Recording change request to the designed forms and modules.
- Unit testing and Integration testing of the modules.
- Preparation of the executable application and installation at Client location.
- Easy Coins
EASYCOINS was built to resolve various needs of the construction industry. The purchase module comprises of sub-modules like purchase of materials from suppliers by giving PO and issue DC once good are received in good condition. The utilization of materials stock is tracked in order to make the material and resource usage effectively. These modules are linked with Accounts and Human Resources modules. The list of employees who works in various locations is tracked in order to validate the time sheet entry and give salary to them.
Role & Responsibility:
- Prototype preparation done to show it to the Client.
- Data Flow Diagram for the modules using Visio tools.
- Creation and coding using WIN FORMS for the modules Purchase, Inventory and HRD modules.
- Transaction Modules like Time sheet entries are validated to keep track of the employee work on the days.
- Intensive usage of DLL to make the data-access layer separately and use in the modules.
- Usage of third-party tool Far Point Grid Control in the modules.
- Unit testing and Integration testing of the modules.