Harpreet Singh([1]

HARPREET SINGH .Net Client/Server Professional (201) 344 7444 [email protected] Name: Rate: Contact @: Email: Reloc pref: Availability: Resume:

Harpreet Singh ( .NET Client/Server Professional) open (201) 344 – 7444 [email protected] open to anywhere in US Immediate attached

Objective: Seeking a competitive position as a Software Engineer/Developer that utilizes my skills, knowledge and experience in an organization where advancement potential increases with demonstrated capabilities and proficiency. Summary of Qualifications: • Over Five years of experience in the analysis, design, development, implementation, maintenance, migration and support of application systems in Client Server, Intranet, Web Application and Enterprise Application environments • Extensive experience in developing n-tier applications, full life cycle development using Microsoft .Net technologies (Web Forms, Win Forms, ASP.NET, ADO.NET, XML, Web Services) • Experience in C++, Visual C++, C#, SQL Server 2000 • Hands-on experience with database including Oracle, PL/SQL and MS SQL Server involving Stored Procedures, triggers, cursors and indexes • Well versed with data modeling and normalization of database schemas • Strong design/development experience with SDLC including Business modeling, requirements gathering, analysis and design, implementation, testing and deployment • Well versed in UML and OOA/OOD methodologies • Demonstrated ability to work independently and flexibility to adapt in an ever-changing business environment • Strong Technical and analytical background, excellent analytical ability, problem solving, decision-making, good communication skills, team player and goal oriented, with a commitment towards excellence. Technical Skills Operating Systems GUI/IDE Programming Languages Design Tools Design Patterns/Concepts Source Control Web Development Web Server Databases Miscellaneous

: Win 9x, Win NT 4.0, Win 2000/2003, UNIX, Linux, Mac OS 8/9, DOS : Microsoft Visual Studio .NET, Microsoft Visual Studio 6.0, MATLAB 7 : C, C++, C#, Java, VB.NET, VB 6.0, MS - VS.NET (ASP.NET, ADO.NET, Web Services, .NET REMOTING), Basic UNIX Shell Programming : Microsoft Visio 2000 : UML, OOAD, OOP : Microsoft Visual SourceSafe 6.0 : HTML, XHTML, XSD, XSLT, XML, CSS, JavaScript, VBScript : MS Internet Information Server 5.0/6.0 : Oracle 8i/9i, MS Access, MS SQL Server 2000/2005 : Microsoft Share point Server V3, Microsoft FrontPage Editor, Dream Weaver Ultra Dev 4.0, Visual Interdev, Image Composer, AUTOCAD 2000, PCB

1

Designing (ORCAD), VHDL & Electronics Workbench Education & Certifications Bachelor of Technology (Electronics & Communication) GGSIP University, New Delhi, India Certifications in ASP.Net, C# & JAVA (Core) Professional Experience Role: Project: Client:

System Developer Web Front Verizon Wireless, Orangeburg, NY

Sept’ 05 - Present

Description: Verizon Wireless, a major player in wireless/telecomm Industry having relationship with various types of dealers, were in need of an application that can forecast Client’s relationship and accordingly generate profit & redundancy forecast. Web Front is a portal developed to facilitate the accounts managers & service representatives and is like an Online Customer Representative -- a powerful, secure source of information, account management, and problem resolution tool. The application helps sales managers to analyze service usage patterns, spot trends before they become problems and plan for growth and change accordingly. Accounts managers and Service Representatives can manage VERIZON services directly, adding and changing features and can review bills, payment history. As a System Analyst, was involved in the development and deployment of application, which contained statistical data of existing customers and provides forecast on their future usage and relationship strength with VERIZON. Role & Responsibilities: • Involved in analysis, design and development of interactions between View and Controller components of the application • Designed and implemented User Interface Layer using ASP.NET Web Forms • Designed and developed web pages using C# and VS.Net • Designed and implemented Data access layer using ADO.NET to connect and retrieve or manipulate database information • Created ASP.NET User Controls to reduce the complexity of user interface design • Created User input validation for new & existing users • Used data grid sorting and paging features for Item and Service List • Implemented Security and Authorization to secured web pages using Forms based security model and administrative level security in web.config • Provided Session Management to preserve the state of session variables • Involved in database design on SQL Server 2000 and development of different database objects containing functions, triggers, store procedures to manipulate database of the application • Involved in testing and deployment of the application Environment: C#, ASP.NET, ADO.NET, XML, Visual Studio.NET 2005, SQL Server 2000, Windows 2000, IIS 6.0 Role: Project: Client:

System Developer Actiant Commerce Platform (ACP) Actiant Inc, Tarrytown, NY

Oct’ 04 - Aug’05

Description:

2

Actiant Commerce Platform (ACP) is an Enterprise Application Integration Platform that acts as a central hub for disparate systems to communicate with each other. Its internal ERP facilitates the interaction between the suppliers and buyers or procurement systems. The core components of ACP are Catalog Manager, Partner Manager, Data Manager, Transaction Workflow Manager, Order Manager and Buyer Connect. Role & Responsibilities: • Involved in gathering requirements, created functional specification, analyzed and designed the application using UML Methodology • Involved in designing and developing different modules using C#, ASP.Net • Extensively used Validation controls in ASP.NET Web Forms for validation • Designed the application using extensive web controls and style sheets • Maintained user information and user settings in Session State • Used XML & XSL for data transformation • Implemented stored procedures to populate items and services in web pages, inserting and updating Users, Buyers, Sellers, Items and Services • Analyzed application debugging and troubleshooting test cases • Designed a common library to track the application usage, handling errors and warnings, which logs the information in system Event log and sends E-mail message to application administrator Environment: C#, ADO.NET, ASP.NET, XML, VS.NET 2003, Windows 2000, SQL Server 2000

Role: Sept’04 Project: Client:

Software Developer

Feb’ 04 –

My Galaxy Board of Education, New York, NY

Description: ‘My Galaxy’ is a School based budgeting system that significantly increases local flexibility over the use of resources while reducing the technical budget work required at the school level. It is a tool that helps the heads of schools to plan and administer the educational program of their school and initiate city wide teacher recruitment and hiring activities through the DHR Approval and Reports section. ‘My Galaxy‘ is a Web Portal that provides services like Time/Schedule Management, Time & Leave Accrual/Management, Auto-Generate Timesheets, Auto Process Payroll, Track Workflow Activity to the users depending upon they sign in as heads, teachers or staff. Role & Responsibilities: • Provided design recommendations based on usability standards and industry best practices • Designed and Implemented User Interface Layer using ASP.NET Web Forms • Created ASP.NET User Controls to reduce the complexity of user interface design • Performed extensive web page coding in C# • Coded the Design Management, Quote Management modules • Involved in Database Designing in SQL Server 2000 and T-SQL coding. • Contributed to the design databases for several modules and developed stored procedures, triggers to be used by the application • Implemented the required database access using ADO.NET • Implemented the Mailer component, which is used to send mails from an application using any available SMTP server in the network, which keeps record of the mails in various formats like text file and database. Each user is given a particular amount of space depending upon the designation in the organization • Used Microsoft Source Safe 6.0 for version control, change management etc. Environment: C#, ASP.NET, ADO.NET, SQL Server 2000, XML, XSLT, Visual Studio.Net 2003, Windows 2000, IIS 6.0

3

Role: Jan’04 Project: Client:

System Developer

Nov’03 –

American Express Membership Rewards American Express (Maritz Rewards), Fenton, MO

Description: Membership Rewards program provides an incredible variety of rewards of travel, entertainment, and shopping rewards from partners like Delta Air Lines, Saks Fifth Avenue, and COACH. Every time the card member uses his/her Card he/she will be earning points. It's easy to enroll. Card member earn one point for virtually every dollar he/she spend. Points have no expiration date as long as the card member maintains a Membership Rewards account with an eligible, enrolled Card. There's no limit to the number of points the card member can earn. Bonus point opportunities help the card member earn rewards faster. Card member can redeem for travel, entertainment, shopping, and more. Role & Responsibilities: • Analyzed business requirements and designed application using UML Methodology and OOA/OOD structure • Designed the application using extensive web controls and style sheets • Front-end application was developed using ASP.NET Web Forms • Designed database layer in .NET to communicate with database through ADO.NET • Created ASP.NET User Controls to reduce the complexity of user interface design • Created Validation Controls in ASP.NET web forms to capture new order and customers, customer payments for validation • Responsible for developing and creating Tables, Views and Stored Procedures • Wrote Stored procedures to populate customers, shipping, receivables reports, month wise orders chart, inserting and updating users, customers, create orders, customer’s payments Environment: C#, ASP.NET, ADO.NET, XML, Visual Studio.NET 2003, SQL Server 2000, Windows 2000, IIS 6.0 Role: Project: Client:

Software Developer Student Database Management System N.I.I.T. Northern Region Office, New Delhi, India

Feb’ 03 – Sep’03

Description: The Region Office wanted to develop an application to keep a track all the students registered with its local centers. This application kept a record of students enrolled at a particular center along with the course registered. The Database Management System picked up the location of a center just by entering the Center ID. Role & Responsibilities: • Developed a Web Application to maintain student database • Designed user interface, developed database and coding • Created Custom Web Controls in the form of Composite and Derived Controls • Used Data Grids extensively for development of user controls • Used various data control and display elements like Data Grids, Data Sets, Data Views, Data Adaptors to extract data from the backend • Involved in migration of some components in BizTalk to .Net platform. • Various function like addition, deletion of a student & updating student information or grades could be performed • Involved in successful deployment of the application Environment: C#, ASP.NET, ADO.NET, SQL Server 2000,BizTalk 2004, Visual Studio.Net 2003, Windows 2000,

4

IIS 6.0 Role: Software Programmer Project: Company Tracking System (CTS) Client: Static Systems Pvt. Ltd., New Delhi, India

July’ 02 –’Jan’ 03

Description: Static Systems Pvt. Ltd is a company in the field of manufacturing Advanced Security Devices like beepers, metal detectors, security alarms, gates, etc. The company wanted to develop an application to keep a track of their sales/purchases and CTS was the final software product. Role & Responsibilities: • Involved in analysis and designing of the system • Record of all clients and items was maintained • Created front end in JAVA making extensive use of Java Swing components • Implemented controls for addition of a new client or item, updating records, viewing details & deleting records • Implemented event handling & connectivity to company database in Oracle using JDBC Environment: JAVA, JDBC, Oracle 8i, Windows

Role: Software Engineer 02 Project: Subsidy Scheme Processing System Client: Petroleum Planning & Analysis Cell, New Delhi, India

Feb’ 01 – June’

Description: PPAC is a Govt. of India Enterprise - a monitoring cell which takes care of the information about the Subsidy Processing of various petroleum products, their quantity and the subsidies given to various Oil Companies. The software generated reports across the verticals and also consolidated information for every company associated. Role & Responsibilities: • Developed User interface forms using Visual Basic 6.0 • Database designing in MS-Access • Wrote SQL Queries for creating and updating tables, reports • Created MS-Access Forms and Reports • Testing and implementation of the developed module Environment: Windows NT, Visual Basic 6.0, Microsoft Access (References provided upon request)

5