AddThis Social Bookmark Button
Ajay Agarwal
NW Dogwwod ST G202Issaquah, WA - 98027 USA
Expertise :
Job Type :
Position :

Resume
 

Summary


Status : US - I am authorized to work in this country for any employer.
Rate : 75000.00 USD Per Year
NET Senior Developer or Analyst
Over 10 years of professional experience and success in Information Systems and Technology. Experienced in system analysis, architecture, design, development and management of successful software applications.
Able to analyze, reverse-engineer, learn, support and enhance systems with limited or non-existent documentation.

Experienced technical lead with excellent project management skills.

Experience in N-Tier Object Oriented Software Development, business analysis, requirements gathering and verification, use-case preparation, project iteration planning, UML modeling, functional analysis and design, prototype design, rapid prototyping, functional specification writing, test case preparation, system and user acceptance testing, presentations, client demos and training.

Excellent system design experience using UML and various design patterns.

Experience working on projects using latest Microsoft technologies Microsoft. NET, Visual studio. NET, C#, ASP. NET, VB. NET, ADO. NET, C#, XML and Web services
Experienced in different phases of System Development Life Cycle from investigation of initial requirements through analysis, design and implementation.

Excellent analytical, communications and mentoring skills prove an asset to any group or organization.
Developed applications for many verticals including Energy, Finance and Biopharmaceuticals.

SOFT SKILLS :
Solution oriented, inventive team player with excellent leadership skills
Able to find weakness in design and provide viable solution.
Accustomed to fast-paced environments and managing projects with independent delivery schedules.
Well-versed in explaining technical issues to non-technical collaborators.

TECHNICAL SKILLS :
C#, ASP. Net or ASP, VB. Net/VB, ADO. Net or ADO, UML, HTML, XML, XSLT, XSD, CSS, Perl, VBScript, JavaScript, PL-SQL, T-SQL

ORACLE 9i/8. x/7 .x, SQL Server MS-Access

Visual Studio. Net, Crystal Report 9.0 NUnit, NDoc, MS Project, TestDirector, WAST, Oracle Enterprise Manager, TOAD, VISIO, Erwin, XMLSPY, IIS 5. x/4.0 Product Studio, Perforce, Source Depot, Visual Source Safe, Source Depot, Microsoft Office 7.0 ACT 3.0

Hardware or Operating Systems
WinXP, Win2K, NT, UNIX


Employment

2004 -  Present
Team Lead/Sr . Developer

Team Lead/Sr . Developer Microsoft Corporation Sammamish , WA
Involved in design of Event Registration Studio for Microsoft Event or Registration Management system that allows to manage events and register new contact for available events. This application is designed and developed to support multiple languages or cultures.
Worked closely with analyst and business team to make sure all business requirements is satisfied.
Designed and developed N-Tier Object Oriented application utilizing the Net Technology and various design patterns.
Lead Offshore or onsite development module for the development of the project and make sure that all defined standard are followed.
Utilized custom controls and user controls to provide high level of performance and reuse of code.
Generated project plan utilizing MS Project and provided higher management report with the milestone.
Organized various code review session to make sure all coding standard are followed and detect any functional issues an early stage of development.
Developed user interface utilizing web-forms, C# Class Library and ADO. NET to connect to backend database.
Used various validation controls to validate data from user and provide necessary feedback to users.
Environment : ASP. NET, C#, ADO. NET, UML, XML or XSD, SQL Server, T-SQL, Visio, Window XP

Team Lead/ Analyst
PGE, Portland, OR
Involved in analysis, design and development of various applications for Enterprise Level solution for transmission group to meet FERC requirements.


2004 -  2004

Coal Management System
The Coal Management System is replacement for Coal Inventory functionality from RS6000 with added functionality and integration with WaveLogger Application.
Analyzed the current process and gathered business requirement by interviewing process owner and end users.
Architected and designed N-Tier application and generated Functional design specification, Software Design Document and Test Plan.
Generated project plan utilizing MS Project and provided to higher management with milestones.
Developed user interface utilizing web-forms, C# Class Library and ADO. NET to connect to backend database.
Developed various Web forms utilizing server controls, user controls and state management.
Used various validation controls to validate data from user and provide necessary feedback to users.
Designed database and developed PL or SQL Stored procedures or Package that manage the data insert or update or delete.
Generate various period and daily report using Crystal Report 9.0 and allowed user to export report in PDF or Word format.
Provided custom form authentication and role-based security and a utility to migrate data from RS6000 to Oracle database.


2004 -  2004

Environment : ASP . NET C# ADO . NET Crystal Report 9.0 TestDirector UML XML or XSD NDOC NUnit Oracle PL or SQL Toad Visio UNIX Win2000 Monitoring FailOver System
Monitoring FailOver System is a component based or distributed N-Tier application designed to Monitor Application Servers through out the company. This system is divided into MFO-Server, MFO-Agent and MFO-Client. MFO-Server is the Server that talks with all MFO-Client and MFO-Agent using MSMQ. All application will talk with MFO-Agent using Observer or Adapter that may be internal or External to the application.

MFO-Server will update all MFO-Client's System Tray Icon for the Status for all the Applications and will allow user to drill down in detail view and history.
Provides user to access formatted Log file from different server.

Created Custom Control to provide color-coded status for an application for period of time by setting configurations.
Implemented message queuing in the application utilizing MSMQ that allows inter-process communication between components of a server-based application.
This system was implemented using Singleton, Object Factory Method, Proxy, Observer and Command design patterns.

Developed Class library that will work across different Databases Oracle and SQL Server.

Used SQL Server Database as local and centralized repository for Detail and summary status.


2003 -  2004

PSS
Migrated VB6 Application to C# using. Net framework that provided user more stable and user-friendly system with required enhancements.
Worked closely with Business Analyst to gather business requirement and designing the application to meet users requirements.
Developing user interface utilizing C# windows form, Data Class and common Class Library. Also developed a database class that is used across different application.
Used FarPoint Spread grid control to produce Excel like behavior with lot of customization easy use.
Using ADO. Net to communicate with Oracle database using Oracle Managed Net client.
Wrote many PL or SQL Stored procedures that manage the data update, account calculations and the interface.
Allowed user to invoke WebService to Transfer/ Receive data using Asynchronous Callback.
Developed a Scheduling Job to Post Energy Offering on ATC-OASIS WebService using Digital Certificate provided by vendor.
Created Setup and Deployment Project for Customized Installation on for Testing and Implementation of the Project.


2002 -  2003
Analyst

Lead developer or Analyst Insightful Corp Seattle , WA
Designed and developed application to analyze and validate data online for Environmental Quality using. Net framework, ASP. Net, C# and ADO. Net utilizing IIS.
Developed user interface utilizing web-forms, C# Class Library and Session management.
Developed various web-forms utilizing Server Controls, User Controls and Session management.

Provided. Net Form based role security to authenticate users and provided user profile management module.
Developed various periodic reports utilizing Crystal Report and allowed to export in PDF format.
Design and developed stored procedure, Triggers, Views and Indexes in SQL Server 2000 to satisfy business requirements.
Use ADO. Net to communicate between Web-forms and SQL Server 2000 database utilizing Data Access Class Library.
User can run different analytics on existing data model. Generated XML or XSL output for user to download.


2002 -  2002
Analyst

Environment : ASP . NET C# VB . NET Crystal Report 9.0 ADO . NET UML NUnit NDOC XML XSLT SQL Server 2000 CSS Microsoft IIS Win2000 Senior Programmer or Analyst Insightful Corp Seattle , WA Lead developer or Analyst Insightful Corp Seattle , WA
Worked on Biopharmaceutical Company's application to provide S-Plus analytics results online by integrating COM object model interface to StatServer 6 analytic engine.
Involved in finalizing database design and Use Cases from requirements.
Developed ASP pages to integrate with COM object model and display analytics results based on input parameters.
Developed ASP pages for using VBScript for displaying user interface and various reports. Used JavaScript for event handling on client-side and form validation.

Developed and Integrated user profile management module.
Implemented Business logic as per the requirements. Used ADO objects to communicate to database and handle data traversing.
Written SQL queries and developed PL or SQL stored procedures to store business rules and tuning SQL scripts for processes and reports using Toad.
Used WAST for Load and stress testing for the application.
Oracle 9i database installation, maintenance transfer, Performance tuning and Backup recovery. Used Transportable Tablespace for data between servers.


2001 -  2002
Analyst

Environment : ASP VBScript Visual Interdev VBScript or JavaScript Oracle Toad PL or SQL WAST CSS Microsoft IIS Win2000 and UNIX Senior Programmer or Analyst GEWind Energy Seattle , WA
Gathered business requirements from existing systems for Supervisory Control and Data Acquisition migration of an existing VB application to a Web solution utilizing ASP technology.
Developed PL or SQL Procedures to store business rules and performance.
Developed ASP pages to integrate with Insightful's COM object model and display analytics results based on input parameters.
Developed and modified ER diagrams with erWin and VISIO to expand data warehouse design.
Integrated custom Java applet with XML and drill down navigation capabilities.
Developed Software Requirements Specifications and Software Design Document.
Used SQL Loader and Transportable Tablespace to load data from client into database.
Preformed unit and system testing to assure data integrity and quality according to use standards.
Done Load testing and application tuning to get better performance.


2000 -  2001
Analyst

Senior Programmer or Analyst Insightful Corp Seattle , WA
Worked on Online Stock Grading system to allow users to run analysis and get some standard pre-analyzed data.
Integrated 2 stock reporting systems from Standards and Poor's Research Insight and Primark's SpeedFeed database and SQL Server database to implement a proprietary stock-grading model to customers.
Developed ASP pages using IIS with VBScript, JavaScript, PerlScript, XML and XSLT for user input and reports.
Utilized 3rd party components to read XML responses from socket stream containing binary graphing information and real-time stock quotes.
Used the ASPSOCKET COM object and XML API interface, to extract live Data and Charts from Text Server and Chart Server which is product of Primark.
Implemented SSL and Https to satisfy client's security requirements.


1999 -  2000
System Analyst

Environment : ASP XML VBScript Visual Interdev COM XML XML Service JavaScript CSS SQL Server 7.0 IIS Win2000 UNIX Senior Programmer or System Analyst HelloNetwork.com Las Vegas , NV
Hello Operator was interactive broadcast and streaming media web application.
Designed and developed Administrator module for Content Management on HelloOperator in ASP using Visual Interdev 6.0 and IIS 4.0 using VB Script on Server side and Java Script on Client side.
Wrote Stored Procedures for accessing/ updating the SQL Server database.
Developed SessionEX COM objects to support for Session Management across multiple web servers using Visual Basic 6.0.
Developed a report generator utility for generating various report based on the parameter passed from Database. Parameters are passed to a Pivot stored procedure and to get the required results.
Developed Software Requirements Specifications and Software Design Document.

Worked as team lead with 3 other developers scheduling task in MS Project, code review and weekly review meetings.


1999 -  1999
System Analyst

Environment : ASP VB XML COM Visual Interdev VBScript JavaScript SQL Server CSS IIS SSL and WinNT Senior Programmer or System Analyst Citibank Singapore Environment : ASP XML VBScript Visual Interdev COM XML XML Service JavaScript CSS SQL Server 7.0 IIS Win2000 UNIX Senior Programmer or System Analyst HelloNetwork.com Las Vegas , NV
Involved in study, design, development and testing of CORES application to integrate multiple country office of Citibank.
Used VB forms to develop front-end GUI and Oracle were used as Database.
Used Windows API to interact with the operating system and stored users setting.
Used some third Party Control eg Sheridan controls, Sidebar, Spread Control, Chart FX, VS FlexGrid, TreeView Control, etc and created ActiveX DLL components to provide ease of use and navigation.
Developed ASP pages and Crystal report for daily and periodic reports, exposure, instrument details and logs using Visual InterDev and VB Script.

Developed a Scheduler that automates the process of importing files from different system, through FTP and consolidation. After consolidation it generates feed file and sends it to NY Server. It also downloads reports generated by the other system.
Integrated this system with CITISAFE module DLL which is used by Citibank for providing unique login ID, Password validation and Country.


1998 -  1999
Project Lead

Environment : VB ASP COM DLL Visual Interdev VBScript JavaScript Oracle PL or SQL CSS IIS Crystal Report WinNT UNIX Project Lead Orange Technologies Inc Gaithersburg , MD
Designed, developed, tested and implemented Class Administration Training and Scheduling.
Developed Software Requirements Specifications.
Used VB Forms to create user-friendly data entry screens to accept information about Programs, Courses and Classes
Used third party controls like Calendar Widgets, TreeView Control and MS FlexGrid for Scheduling the Classes and programs.
Performed database designs using Normalization techniques and was involved in coding, testing and implementation of the system
Used DDE and API for Data Communication between ACT 3.0 and CORES application.
Used ASP and Crystal Report to produce various reports based on the user requirements.

Leading the project, scheduling task and was interacting with client to communicate the project status.


1996 -  1998
System Analyst

Environment : VB ASP HTML ActiveX Third Party COM Visual Interdev VBScript SQL Server CSS IIS Crystal Report Windows 95 Programmer or System Analyst SVAM Software India
Involved in design, development, implementation and maintenance of the software IMS. This was developed to automate the entire working of Purchase or Store Department.
Used VB forms for user-friendly data entry screens and ODBC to make connection to the SQL Server database.
Used third party controls like Calendar Widgets, TreeView Control and MS FlexGrid to design user-friendly forms.
Used Crystal reports to produce various summaries, Cross-Tab and Analysis reports based of Project, Scientist, Item, Vendor and PO.
Used API to interact with the operating system.


1995 -  1996
Programmer

Environment : VB Third Party COM SQL Server 6.5 Crystal Report ODBC API Windows Programmer SVAM Software India
Involved in development, testing and implementation of financial accounting system.
Developed VB form to maintain and manage application by connecting database using ODBC.
Involved in database and implementation on SQL server database using Normalization techniques.
Used Crystal Reports control to produce various reports based on the user requirements.
Developed user manual and provided on site training to end-users.
Environment : VB, Third Party COM, SQL Server, Crystal Report, ODBC, API, Windows 95

Experienced

Years of relevant work experience : 7+ to 10 Years
Date of Availability : Immediately

US - I am authorized to work in this country for any employer.

Active Security Clearance : No

NET Developer or Analyst

Alternate Target Job Title :. NET Lead Developer
Desired Job Type : Employee, Temporary or Contract or Project

Full-Time

Category : Computers, Software/Insurance/Internet/E-Commerce/Banking/Information Technology
Industry : Utilities or Internet or ISPs or Portals or Data Processing/Telecommunications/Wireless/Insurance/IT- Software Systems and Design

Selected Locations : US-OR-Portland, US-WA, US-WA-Seattle, US-WA-Tacoma or Olympia, US-WA-Bellevue or Redmond
Relocate : Yes
Willingness to travel : Up to 25% travel


2004 -  Present
Senior Developer

Microsoft Industry : IT- Software Systems and Design NET Lead or Senior Developer
Involved in design of Event Registration Studio for Microsoft Event or Registration Management system. This application is designed and developed to support multiple languages or cultures. Working as Lead Developer with OnSite or OffShore module to make sure all the requirement are met as per design.




Education

BS - Computer Sc And Engineering 1991 - 1995

BS

Bachelor's Degree



Miscellaneous

ADDITIONAL TRAINING
Oracle Corporation Training : Introduction to Oracle SQL and PL or SQL, Design and Develop Complex Data Models, Oracle Database Architecture and Administration, Oracle Backup and Recovery Workshop, Standby Database and RMAN configuration, Oracle Performance Tuning Workshop, Distributed Database Administration.

Skill Name
Skill Level Last Used Experience
C# Expert Currently used 3 years
ASP. NET Expert Currently used 2 years
ASP Expert Currently used 4 years
SQL Server Expert Currently used 5 years
Oracle Expert Currently used 6 years
Language Proficiency Level
English Fluent - Full Knowledge
Hindi Fluent - Full Knowledge




Quick People Search



People like Ajay

Popular skills