System Analyst Resume
SUMMARY OF EXPERIENCE
- Over 10+ years of experience in developing web based B to B & B to C applications in the client/server environment. Having sound knowledge of web standards for developing Web application. Most recent experience includes 7 years of extensive development using .NET Framework 1.0/1.1/2.0/3.0 technologies (C#, VB.net).
- Development and Maintenance of large-scale n-tier object oriented Internet/Intranet and WinForms client/server applications and Business Intelligence projects.
- Extensively Involved in the Company CMM3 Process. Having full knowledge of Software Life Cycle (Software Development Life Cycle & Software Maintenance Life Cycle), Requirement Analysis, and Preparing System Design Document.
- Having experience as a member of SEPG (Software Engineering Process Group) & SCCB (Software Change Control Board)
- Strong relational modeling skills and C# coding skills with Object Oriented Programming (OOD/OOP), and middle-tier business layer components using design patterns.
- Almost 2 years of experience in Project management, involving project plan development, resource allocation and management and proactive identification of issues with a focus on the ends and not on the means and Involved in the Project Estimation by using Function Point/COCOMO Model Techniques and SPDB.
- Experience in designing, developing and maintaining Web based applications using Active Server Pages, ASP.NET,OOP, Ajax, C #, VB.net, ADO.NET, SQL Server 2000 and SQL Server 2005.
- Strong experience with building web applications using AJAX Control Toolkit, AJAX Client Library and deploying the AJAX applications.
- Solid SQL Server T-SQL Set Statements, Procedure, functions, expert in writing complex and logical multiple joins without temp tables and cursors.
- 3 years experience in developing and deploying applications using Classic ASP and SQL Server.
- Excellent communication and inter-personal skills.
- Having working experience of SCRUM-Agile Software Development environment.
Education
- Master of Computer Application
- Post Graduate Diploma in Computer Application
- M.A. (Public Administration.)
Certifications:
- Bain bench certified ASP.net, C#, SQL server professional.
- MCP Exam Number (70-228) Installing, Configuring and administering SQL Sever2000
- Exam Number (70-229) Designing and Implementing Database SQL server 2000
- Brain bench Certified ASP Programmer
O S : Windows 95/2000/2K3/NT 4.0.
Database : SQL Server 2000, SQL Server 2005 & DB2.
Programming Languages : COBOL, VB.NET
Internet Tools : ASP2.0, ASP.NET 1.1/2.0/3.x, ADO.net 2.0, IIS, XML, XSLT, Microsoft SharePoint Server/Services, JavaScript, HTML/DHTML/XHTML, VBScript.
Protocols : SOAP, LDAP, TCP / IP, HTTP, HTTPS, WAP & RPC
Web servers : IIS 5.0/5.5.
Mainframe Skills : MVS, VSAM, JCL, CICIS, DB2, IMS, COBOL
GUI tools : Visual Studio 2005, VS 2008, Dream weaver and Front page
Middle Ware : Remoting, Web Services, WCF
Other Tools & Technologies : ASP.NET, Web Services, ASP,C#, XML, XSD, XSL, IIS4.0/5.0, ADO, DAO, PWS,VB, Visual InterDev, MS Source Safe, .Net Remoting, VSS, Query Analyzer, Windows NT Authentication, Microsoft Application Blocks, WCF, SSRS, SSIS, SSAS, Ajax.
Domain : Finance, Retail, Health Care
Data Access Objects : ActiveX Data Objects ADO.NET/ADO/ RDO / DAO /ODBC /OLEDB
Database Skills : Microsoft SQL Server 2008/2005/2000, Oracle, SSIS, Informaix, MS-Access, DB2.
Client: Confidential,Princeton, NJ- Oct 19 2009 to Dec 31st 2009
Title: System Analyst
Project: Confidential,
PMG is involved in the Merck engage program for patients, in which patients can register to this program and they can maintain all their records online. PMG is not only limited to patient record maintenance but also providing the Caregiver and assistance calls to their registered patient. PMG has two online interfaces one is used by the patients and other is used by the Call center agents. I am involved in developing the patient interface.
Responsibilities:
- Involved in the Requirements gathering with the business team.
- Preparing the functional requirement documents and making database changes to achieve the requirements.
- Involved in the coding of Caregiver/Eating well/Getting fit/Condition tracking and Create a new Meal modules.
- Involved in creating and designing the Database tables according to the new requirements.
- Writing the stored procedures, inline queries.
- Involved in the preparing and presenting the demo.
- Used ASP.NET AJAX to improve page response and provide greater user experience.
Environment: : C# 2.0, ASP.NET, ADO.NET, SOAP, XML, XSLT, XPATH, HTML, VBScript, Winforms, JavaScript, AJAX, IIS, Source Safe Control, WCF, Microsoft Enterprise Library, SQL Server 2005, Oracle, Visual Studio 2005.
Client: Confidential,- 19 Oct 2007 to 16 Oct 2009Plymouth, MI Title: Technical Lead (Team Lead/Solution Architect)
Project: CALNET 2 & SINGLE BILL
ACUS is specializing in custom billing solutions for large enterprise and government clients. Most recently we have focused our efforts on providing consolidated billing solutions for large government clients. The State of California (CALNET), County of LA (CoLA), State of Ohio, State of Alabama and State of Tennessee are some of our current clients.
The purpose of this project is to provide single consolidated invoice to state government agencies for their telecommunication services received from AT&T. This project was initially developed for state of California under CALNET 2(California Network) contract and later customized for Alabama, Tennessee and county of Los Angels. Under this solution, ACUS (AT&T Custom User Solutions) consolidates all BTN (Billing Telephone Number) level invoices from different billers and generates Bill Payer (state agency) level consolidated invoices. Customers and Service reps access these invoices over web with Single Bill web site. Single bill site provides regular billing services like account hierarchy maintenance, disputing charges, manual payments, general adjustments, write offs, refunds, reports and referrals
Responsibilities
- Participated in database and web site design meetings and delivered High level and Detail design documents.
- Developed the UI screens in C#, ASP.NET, HTML and JavaScript.
- Used ASP.NET AJAX to improve page response and provide greater user experience.
- Developed data access layer using ADO.NET and IBM Informix CSDK.
- Used XSLT and XPATH in invoice presentation over web.
- Created WSDL document as per AT&T web service standards and interface definition between ACUS and MAALD.
- Developed Security Provisioning intranet site to manage user accounts and security groups.
- Created Provisioning tools intranet site to manage look up tables’ data.
- Used GemBox third party tool to generate reports in excel format.
- Provided maintenance support and code delivery to ST, UAT and Production systems.
- Worked as Coordinator between all the responsible teams involved in the development process.
- Involved in the conversion of legacy ACUS voice tone (using the ASP, COM and COM+) application into the asp.net 2.0.
- Implemented AT&T wide Global Login for all the legacy applications running in the ACUS and using their own login credentials, after this change all the application started using the one login AT&T wide Login Credentials.
- Involved in preparing the Requirement Traceability Matrix (RTM) and Assembly and Unit test plan.
- Involved in the Review process of the design document.
- Worked as Project coordinator and interact with the other remotely located teams.
- Involved in the maintenance and enhancement of the DAL and BLL layers of the application.
Maintenance Responsibilities: Parallel to new development I was involved in the maintenance as well new enhancements of all the legacy applications developed in ASP, VB, COM, COM+ object.
Conversion Project: Worked on the conversion of the two projects from ASP, VB 6.0, COM and COM+, to VB.Net using asp.net framework 2.0 and ADO.net 2.0.
Title: Architect
Responsibility: I was the only person involved in the conversion of the application. My responsibilities in this conversion project includes following
- Involved in the creating the development environment for the application needs to be concerted.
- Once the development setup was done then I was involved in the generating the flow chart of the applications.
- Involved in the process of requirements gathering as there was some enhancements pending in the application.
- Involved in the conversion and development of the existing applications from ASP, COM, COM+ and VB to ASP.net
- Involved in the testing the converted application.
- Involved in the end user training of the converted application.
Environment: : C#, ASP.NET, ADO.NET, WSE 3.0, Web Forms, SOAP, XML, XSLT, XPATH, HTML, JavaScript, AJAX, IIS, Source Safe Control, IBM Informix, Windows 2003, GemBox, ASP, COM, COM+, VB 6.0, Oracle, VBScript, Winform.
Architecture: N-tier (Presentation layer, Business Logic layer and Data Access Layer)
Confidential,is an Equal Opportunity Lender. NSL authorized by the Department of Education under the Federal Family Education Loan Program and in the process of preparing their own product to facilitate the user. NSL has multiple product to facilitate it\'s users and this project was subdivided into the multiple modules. User can apply online and can apply by phone. For this kind of functionality this project was divided into the Internal and External modules and one standard credit module.
Responsibilities
- Worked as Developer using C# with the team of 3 including one team lead and one QC.
- Involved in the coding of the credit modules, fetching the report from the Trans Union and Experian servers and in the manipulation of the reports.
- Prepared the asynchronous page using C# for sending httpwebrequest request to the Transunion and Experian Servers.
- I prepared the Judgment Screens for the Credit assessors just to evaluate the Application submitted by the User the code was done using C#.
- Judgment assessors are involved in making their decision on the application by using the JD screens.
- I was involved in the coding of the Managemyloans modules which was exposed to the users and user can view and manage all his application he applied for.
- I was involved in the requirement gathering of some of the sub modules of credit modules.
- Involved in the sending emails to all types of application decision status to the users and their cosigners.
- XML report request generation and adding the parameters on the fly for Experian server and report response manipulation using XpathNavigator, XPath, Xquery and presenting the report in user readable format for JD assessor.
Environment: : ASP.net 2.0, C# , HTML, XML, ADO, SQL Server 2005, Dot net framework 2.0, IIS Visual Studio Team System, Ajax 2.0, SCRUM-Agile Software Development .
Architecture: N-tier (Presentation layer, Business Logic layer and Data Access Layer)
Confidential,
Client: Confidential,Gurgaon, Delhi Sep 2006 to 15 Mar 2007
Title: Project Leader
Project Name: Qresolve
Application is designed and developed for US market to facilitate the users by providing them the online Technical Support. User Interface is web based ASP.net portal, fetching the data from the CRM (Microsoft Dynamic CRM3.0) by using web services running on the CRM application server and display all the service plans. Using the Portal customer can buy any plan and avail the services. This application provides the Email, Chat, and voice facility to the users seeking technical support using AIC-ACD (Avaya).
Responsibilities
- Work with the Business Users to define, specify and review new business/end-user requirements, define technical requirements plus help define and review technical requirements for other engineers and write functional specifications, including technical implementation details. Also review functional specification created by other engineers
- Writing Software Requirement Specification (SRS), HLD & LLD’s
- Designed & developed 3-tier layered architecture (UI, Business layer, Database layer)
- Designed & developed Unit Test cases and Worked closely with QA team during QA audits.
- Design, develop and debug UI and server code for multiple components.
- Review across components for clarity, lack of ambiguity, completeness, self-consistency, feasibility, ease of use, magnitude of effort and functional tradeoffs
- Memory leaks detection, Code coverage & Performance analysis
- Designing of various database objects that include Tables, Stored procedures, Triggers etc and optimize database objects like stored procedure & inline SQL queries.
- Review code, using C# and SQL Server 2000, developed by peers and less-experienced engineers
- Integration of various modules that includes UI integration, business components, remote components, payment gateway components and responsible for designing the master module for handling the portal and implemented the Window NT Authentication for the local agents to login to the application and interact with the Customers.
- Managing team of 15+ persons
- Work estimations, Allocation, Resource planning and Project tracking
- Worked as configuration manager for managing the versions of all the SDLC related documents.
Environment: : ASP.net, C#, Microsoft CRM3.0 dynamics, HTML, XML, ADO, Win2000, SQL Server 2000, AIC-ACD (Avaya), Dot net framework 1.1 and IIS 6 .
Confidential,Dec 2001 to Sep 2006
Responsibilities:
- Started Job as Programmer analyst in Acrotechnologies.
- Developed Reports and Master Modules
- MIS Reports Generation
- Developed the facility to download the Reports contents on the client machine in the excel format.
- Developed Dynamic Main Menu page of the application which will show the links according to the logged in user access rights.
- Developed Payroll Services Request Page – this page is used for creating new assignments.
- Developed all the stored procedures, triggers and Inline SQL statements.
- Unit testing, Integration testing of the Modules.
- Developed Web based Query Analyzer.
- Performance tuning and deployment of the Modules created.
- Worked as SCCB team member for following the SMLC (Software Maintenance Life Cycle) Process, Prepared the IAS (Impact Analysis Report) for the entire change requests submitted by clients.
- Interaction with end user for discussing the change request and new request submitted by the end user.
- Review process:
- Code review, SQL query review, Review of SRS/SDD document.
- Worked as QA for conducting the Process/Product Audit.
- Prepared the Traceability matrix.
- Involved in the requirements gathering and making the function requirements document.
Client: Confidential,India
Title: Team Lead (Senior Developer)
Project Name: Vintage
This is web based application developed for the M/S Vintage Collections India for their operation in all over world mainly in US. This application facilitates the users to visit the site and view the products uploaded online by using the master module. User can view the categories and by clicking on the categories user can view the thumbnail snaps of the products with the checkbox to make the selection and the link for viewing the details of the products.
Environment: ASP.net, C#, VB, SQL Server2000, HTML, XML, ADO, Win2000, .net framework and IIS.
Client: Confidential,New Delhi, India
Title: Team Lead (Senior Developer)
Project Name: Vintage
This is web based application developed for the Accuralabs a Clinical Laboratory. This application facilitates the patients to login to the site and view their reports online.
Environment: ASP.net, C#, SQL Server2000, HTML, XML, ADO, Win2000, .net framework and IIS.
Client: Confidential,New Delhi, India
Title: Team Lead (Senior Developer)
Project Name: boitechnews
This is web based application developed for the Department of Biotechnology (Govt. Of India). This application is an online release of news from the Department of biotechnology. Some of the Professors of Researchers can upload their research document; they want to share with the user, online on this site. User can make search on the bases of the Title and Author on the site online.
Environment: ASP.net, C#, SQL Server2000, HTML, XML, ADO, Win2000, .net framework and IIS.
Client: Confidential,Delhi, India
Title: Senior Developer
Project Name: hertz
This is web based application developed for the Hertz Car rental for their operation in India. This application facilitates the users to book the cars online. Users can find the cars they like and they can ask for the preferences like they want car with Driver or Not. User can find the history of the driver driving their car they hired for their visit.
Environment: ASP.net, C#, SQL Server 2000, HTML, XML, ADO, Win2000, .net framework and IIS.
Client: Confidential,US
Title: Senior Developer
Project Name: XRMNGv2
Acroxrm is the Part of XRM (External Resource Management) services provided by Acro Service Corporation to their clients in US. Working as a Technical lead on the project, Main activities include the preparation of Design document and working with the implementation team to implement the design.
Environment: ASP.net, VB.net, SQL Server 2000, HTML, XML, ADO, Win2000, .net framework and IIS.
Client: Confidential,Michigan
Title: Senior Developer
Project Name: IRM (Internal Resource Management)
Internal Resource Management (IRM) web based application developed for the Acro service corporation. This application is a replica of the working of Acro Service Corporation in to a web based application. Acro Service Corporation is involved in the business of providing the IT and manpower support to their clients in US and this application is used as a bridge between the Acro and rest of their vendors. All the requirements from the clients is converted in to the JO and uploaded on this site and the JO is assigned to the registered vendors of the Acro. Now vendors can submit the candidates resume by using this application. This application keeps history of the complete life cycle of the candidate/employee.
Environment: ASP.net, SQL Server 2000, HTML, XML, ADO, Win2000, .net framework and IIS.
Client: Confidential,
Title: Senior Developer (Team Lead)
Project Name: LASON
This application developed for LASON US. This application facilitates the Lason users to keep track all their external employee life cycle. By using this application Lason users can generate the different MIS reports. This application facilitates the external employees to submit their daily time sheet online and get it approved by their supervisor of Lason. Once the Time sheet is approved by the managers then Lason user can generate report containing the billing details of the external employee working with them and on the basis of this report they can pay the amount to their different consultants.
Environment: ASP.net, VB, SQL Server 2000, HTML, JavaScript, ADO, Win2000, .net framework and IIS.
Client: Confidential,Michigan
Title: Senior Developer
Project Name: LASON
This application developed for MACI US. MACI is involved in the business of making the automotive parts and always in the requirement for resources. This application facilitates the MACI users to submit their requirements online and keep a control on the external resources. This application provides the facility to the external resources to submit their daily time sheet/expenses online for approval. Once the expenses approved they user can generate the report and can pay then the salary or expenses they incurred. MACI users can manage this whole application by using the master module online. They can create users assign the access rights to the users; they can submit the online announcements/notices on the application dashboard etc.
Environment: ASP.net, VB.net, SQL Server 2000, HTML, ADO, Win2000, .net framework 1.1 and IIS.
Client: Confidential,Michigan
Title: Senior Developer
Project Name: CRtrack
CRTrack is web based application developed for the different clients for submitting their change request about the application they are using. Crtrack using the web services for fetching the module details from the applications and showing those on the form where user wants to submit the change requests. Once the user submits the change request an email is fired to the responsible person related to the application containing the details of the change request.
Environment: ASP.net, VB.net, SQL Server 2000, HTML, JavaScript, ADO, Win2000, .net framework and IIS.
Client: Confidential,Michigan
Title: Programmer analyst
Project Name: CMS
This project developed for the CMS Energy US; this project contains the wages information of the employee of the CMS energy. Employees of CMS can submit their working hour’s details online in the system with restricted access given to them. Once the entries done by the employee and submitted to the respective approvers and once the entries approved by the approvers their billing done and salary given to them. This system will contain complete history of the employees billing.
Environment: HTML, XML, ASP, Win NT, JavaScript, SQL Server and IIS.
Confidential, Feb 2001 – Dec 2001
Client: Confidential,Chandigarh (India)
Title: Developer
Project Name: Ebidding Deltron India
This is a web based application developed for Deltron India. Deltron was into the process making
the TV screens and some TV electronic parts. Deltron requires lots of RAW material for their
product development for this purpose they have lots of suppliers. This project facilitate the users
to submit their requirements to the suppliers. Suppliers can bid online for their quotes and
quotes accept/rejection is done online by the users of the Deltron.
Responsibilities
- Worked as Developer on this Online Bidding application.
- Developed Bidding and Supplier Modules
- Developed all the Inline SQL Scripts.
- Unit and Integration testing of the Modules.
Environment: ASP, IIS, JavaScript, HTML, SQL Server 6.5, Window NT
Confidential, May 2000-Feb 2001
Client: Confidential,San Jose California
Title: Developer
Project Name: Flippi D.I.B.S (Desktop Integrated Browser System) This product was prepared for
the US market. This is a Browser which will appear on the user screen, and display the news and
data as per his setting. User has to register himself on the site first and then user can download
the DIBS to his own machine. At the time of downloading user has to chose the categories he
Interested in DIBS is providing the categories like (News, Sports, Fashion, Share market etc).
Once the selection is done and DIBS downloaded to the machine then as soon as anything new
occured then DIBS popped up on the user screen. User can tuck in and tuck out the DIBS to any
corner of his machine.
Responsibilities
- Worked as Developer on Flippi.
- Developed the user registration form.
- Developed the module for sending mails to the registered users.
- Developed the referral program on the Flippi site.
- Developed the master modules for creating/editing/deleting the categories from the site.
Environment: ASP, IIS, JavaScript, HTML, SQL Server 6.5, Window NT
Rizvi Software Consultancy Feb 1997 to May 2000
Client: Confidential,New Delhi (India)
Title: Developer
Project Name: Modeling Career
This is web based application facilitate the user for adding their portfolios to the site online. Once
the candidate uploads their photos online then these photos will be reviewed by modeling
agencies or the clients looking for the models for their products advertisement.
Once the candidate is selected by any clients then admin of the site will communicate the
message to the candidate and arrange the future meetings of candidate with the client.
Mainframe projects
Title: Developer
Project Name: Manufacturing resource planning System
This is the Software system that synchronizes the activity of production and the other function areas of the business. It coordinates sales purchase, manufacturing finance excise and administration by adopting a focal production plan.
The special features of this system include the following.
1. Creation of daily production plan based on marketing information.
2. Integration of daily production scheduling process with production planning and control.
3. Tight integration of purchase and inventory function with material forecast feasibility.
The development system maintains a competitive edge by maximizing its efficiency in the manufacturing process.
It also fulfills the following objectives:
1. Inventory reduction.
2. Reduction in production and delivery lead-times.
3. Realistic commitments.
Environnent: COBOL, CICIS, DB2
Client: Confidential,Iran
Title: Developer
Project Name: Health Care Organization System
This is software system for computerization of Centralized Health Care services. This system automates the following process:
- Health Book Issue/Renewal.
- Expiration of Health book.
- Issue of Duplicate Health Book.
- Cancellation of Health Book.
- Premium Collection of Both the Employee and dependents from the employer.
- Marketing information report:
1. Duplicate Health Book Issue.
2. Cancelled health Book.
3. Expired Health Book.
4. List of employers who haven\'t paid premium.
5. List of all the employee and dependents whose premium is not paid.
Environnent: COBOL, CICIS, DB2