Sql Server .Net Project Service Manager Developer
Resume:
SUMMARY:
. Applications Developer/Analyst.
. Over 7 years of software development experience.
. Extensive experience in complete product life cycle.
. Experienced in Visual Studio .Net 2.0/3.5/4.0.
. Proficient in Database design, development and migrations in MS SQL
Server, Oracle.
. Demonstrated high capability of designing and developing web
applications using VB.Net, C#, ASP.Net, AJAX, Visual Basic, PHP,
MySQL, PL/SQL, ASP, JSP, ADO, XML, HTML, VBScript and JavaScript.
. Excellent interpersonal and communication skills. Collaborated
effectively with Customers, Program Management, Quality Management and
Technical Publications.
. Proven for working under pressure, self-taught and a team player.
EDUCATION:
MS Computer Applications
BS Computer Applications
TECHNICAL SKILLS:
Languages: JAVA, C++, C, COBOL, PASCAL
Platforms: Windows 95/98/XP, Windows NT/2000, Linux
RDBMS: SQLServer2005/2000, Oracle, MS-Access, MySQL, PostgreSQL
Reporting: SQL Analysis Server, SQL Reporting Services, Crystal Reports,
Infragistics
GUI's: VB/C#.Net 2.0/3.5/4.0, Visual Basic 6.0, VBA, Developer 2000,
JDeveloper
Packages: MS Office, FoxPro
Scripting Languages: PL/SQL, HTML, JavaScript, VBScript, ASP, JSP, PHP,
AJAX
Web Servers: IIS 6.0, Apache, Tomcat, and Java Web Server, Web logic
Project Management: Primavera Expedition 7.0, sure track 3.0
Collaboration: BEA Weblogic 6.0, Sharepoint 2007/2010
ACCOMPLISHMENTS:
01/2007-Present
TRC
Portal Migration (Bea to SharePoint 2010)
THIS PROJECT ENTITLES THE MIGRATION OF EXISTING PORTAL IN BEA AQUALOGIC 6.0
TO SHAREPOINT 2010. THE CONTENT MIGRATION IS DEPLOYED USING THE TOOL CALLED
TZUNAMI. THE ENTIRE ARCHITECTURE IS BASED ON A VERY LARGE FARM
INSTALLATION.
. INVOLVED IN DEFINING AND DEVELOPING INFORMATION ARCHITECTURE (IA).
. Involved in finalizing the Governance model.
. Content migration of 800 project spaces to relevant sites and subsites
using Tzunami and its rules engine.
. Configured single sign on, external BDC connection, defined content
types, site provisioning etc.
. Involved in complete administration of the entire farm.
. Developed custom applications using Infopath and SharePoint Designer.
. Worked in-depth with all the business units in defining the scope of
migration and the entire site structure.
. Involved in configuring the Development, QA and Production
environments and defining the security groups.
Environment: Bea 6.0, SharePoint 2010, Windows Server 2008, Infopath 2010,
SharePoint Designer 2010, Visual Studio .Net 4.0, ADO.Net, Tzunami.
COMPLIANCE MONITORING SYSTEM
Compliance Monitoring System (CMS) is a web-based application that enables
the monitoring of Environmental cleaning and Hand hygiene of Hancock
regional hospital, Indiana. The data was captured by TRC inspection
personnel who used both Digitalized form with Digital pen as well as using
the front-end web form. The monitoring was covered over a spectrum of
departments from Neonatal ICU to Maternity to Pharmacy to Central Supply to
Post OP. All the staff including the Physicians, Nurses, Phlebotomist,
Surgical Assistant were monitored for their activity. The data that was
captured using a digital form was transmitted by digital Pen on to a blu-
tooth paired phone or a Blackberry device and pumped the data on to a
staging server from Standard Register. The data was ultimately extracted
into a TRC server in the pdf format as well as XML data feed to put the
data into a SQL backend. The hospital had an immense impact on their
insurance coverage by monitoring the compliance ratio thru various trend
charts and corrective action including class to personnel by drilling down
the drop in ratio to a particular department or category of employees.
. Responsible for designing front-end screens in ASP.Net, which
incorporated the maximum capturing the User requirements charting out
the process flows. Database design was developed in SQL server.
. Development of forms in ASP.Net. Used AJAX with Javascript for form
level validations
. Enterprise Database Access Application Blocks was used for database
connectivity.
. Logging Block was used to Log the information thereby providing
extensive knowledge of flow of users navigating.
. Cryptography was used for data encryption over the network.
. Extensively worked with DataSets, DataAdaptors and DataReaders.
. Worked in the configuration, testing and piloting of Digital Pen from
Logitech.
. SQL reporting services was used for developing all the reports for
Compliance Tracking.
Environment: Visual Studio .Net 2.0, ADO.Net, Web services, C#, ASP.Net,
SQL Server 2005, Digital Pen Technology, XML, Infragistics Controls
Applicant Tracking System
Tool & technologies:- Visual Studio .Net 2.0, ADO.Net, Web services,
ASP.Net, SQL Server 2005, Html,CSS,Infragistics Controls.
Applicant Tracking System (ATS) is a web-based application that enables the
electronic handling of TRC's corporate recruitment needs. ATS fully
automates the hiring management process which includes job posting, resume
management and recruiting. From new opening to new hire, ATS leads the way
through all stages of applicant selection and helps you choose the best-
qualified candidates. ATS system was designed to provide a simple yet
effective hiring system that would be easy to use, inexpensive to operate,
and yet still provide the features and tools that helps our businesses
needs. ATS is tied into the internal portal as well as the corporate
website, allowing us to post jobs onto our own website, as a way to attract
candidates. All new positions will now be posted internally on the portal
under "Career" Community for three (3) calendar days. After three days, the
position will automatically be posted to TRC's corporate website and other
Job websites like Career-builder etc. Candidates may apply for specific
jobs that match their skill sets.
. Responsible for designing front-end screens in ASP.Net, which
incorporated the maximum capturing the User requirements charting out
the process flows, that include the Project Charter, High Level
Process flows, Detailed Process flows, and System Design.
. Database Design and Modeling: SQL Server. Created entities, triggers,
stored procedures including the optimization for performance.
. Development of forms in ASP.Net. Used AJAX with Javascript for form
level validations
. Enterprise Database Access Application Blocks was used for database
connectivity.
. Logging Block was used to Log the information thereby providing
extensive knowledge of flow of users navigating.
. Cryptography was used for data encryption over the network.
. Extensively worked with DataSets, DataAdaptors and DataReaders.
. Developed a reporting interface using Infragistics Controls.
Environment: Visual Studio .Net 2.0, ADO.Net, Web services, C#, ASP.Net,
SQL Server 2005, Html, CSS, Infragistics Controls
Procurement Tool
There are 5 major functionalities that can be achieved using the
Procurement Process. We can procure new/upgrade existing hardware of
software based on:-New Hire, New Hardware, Upgrade Hardware, New Software,
and Upgrade Software.
There are slight variations to each process in terms of workflows. Once the
users select the required option and enter the valid values for
Laptop/Desktop; Cell Phone; Black Berry; any additional H/W or S/W; if they
are upgrading the current and the requested models; and Manager, a pop-up
window will appear with the pricing of each item selected with the
quantity (1 as default). The users can change the quantity and it will
display the altered total cost. On submission of this, an email is
generated to the "Procurement Admin" and appended to the Queue (if the list
involves an item "Others" for which the Admin has to enter the pricing and
submit). If the list doesn't include any "Other" items it's routed directly
to the manager's Queue with a notification email suggesting that there is
an item waiting for the approval. If the requested person and Manager
Information is the same( which can happen only if the procurement is for a
New Hire), then the case is considered "Approved" and is placed for the
order, otherwise; it will be routed back to the "Supervisor" notifying him
of such a request and it can be "Approved" or "disapproved". If it's
disapproved, the candidate is notified the reason of disapproving.
. Responsible for designing front-end screens in ASP.Net, which
incorporated the maximum capturing the User requirements charting out
the process flows, that include the Project Charter, High Level
Process flows, Detailed Process flows, and System Design.
. Database Design and Modeling: SQL Server. Created entities, triggers,
stored procedures including the optimization for performance.
. Development of forms in ASP.Net.
. Enterprise Database Access Application Blocks was used for database
connectivity.
. Logging Block was used to Log the information thereby providing
extensive knowledge of flow of users navigating.
. Extensively worked with DataSets, DataAdaptors and DataReaders.
Environment: Visual Studio C#.Net 2.0, ADO.Net, ASP.Net, SQL Server 2005
Other Key Projects: Telecom Project > Active Directory Self-service Module
> Altiris Service Desk > Metrics/KPI > Labor/ODC > Wachovia Bank Module >
POPS Legacy Application
02/2006-12/2006 United
Parcel Service
Cellular Device Management System
Tool & technologies:- Visual Studio .Net 1.1, ADO.Net, Web services,
ASP.Net, SQL Server 2000, Html,CSS, Clear Trust.
CDMS provides device and vendor recommendations to new cellular
subscribers, provides an automated approval process, provides Amex Credit
Card validations, backend reporting, inventory of all UPS domestic cellular
subscribers. Using this website the users can make a device request, which
is then subject to approval from three levels of managers (Immediate,
Region, District). Once the managers approve the request the order will be
placed by the voice co-coordinators, which is protected by Clear-Trust for
proper authentication. This tool also comes with a registration module for
existing users to register their devices. The check status module provides
the users to check the status of their application for any pending
approvals from any higher level managers or if the order is being placed. A
Webservice was invoked to gather the user information based on their
respective ADID's. The reporting section provides an intensive close look
at the data being captured.
. Responsible for designing front-end screens in ASP.Net, which
incorporated the maximum capturing the User requirements charting out
the process flows, that include the Project Charter, High Level
Process flows, Detailed Process flows, and System Design.
. Database Design and Modeling: SQL Server. Created entities, triggers,
stored procedures including the optimization for performance.
. Development of forms in ASP.Net. Used Validation controls along with
Javascript for form level validations
. Enterprise Database Access Application Blocks was used for database
connectivity. Configuration Block was used to plug in the
configuration parameters.
. Logging Block was used to Log the information thereby providing
extensive knowledge of flow of users navigating.
. Extensively worked with DataSets, DataAdaptors and DataReaders.
. Developed a reporting interface using HTML.
Environment: Visual Studio .Net 1.1, ADO.Net, VB.Net, Web services,
ASP.Net, SQL Server 2000, Html, CSS, Clear Trust
Service Order request Process/Rate Plan Tool
Tool & technologies:- Visual Studio .Net 1.1, ADO.Net, Web services,
ASP.Net, SQL Server 2000, Oracle, Html,CSS, Clear Trust.
The Service order request processing tool was developed to aid the
serviceability of the cellular devices ordered thru the CDMS tool. With the
help of this tool users could open a service order request which comes with
all pre-loaded service issues, and could be submitted to the appropriate
Queue of HDFS system.HDFS is the tool what UPS users for all its global
service order requests, which is a product of Peoplesoft. Based on the
successful submission an email with case-id would be send to the user, who
can then Track the progress of the case thru a page. The Rate Plan
selection tool was developed after the launch of CDMS to help the local
voice co-coordinators to determine the appropriate rate-plans for the local
cellular device users. This has all the plans available with the carriers
and the different features, with the rates (both normal and overage). Rate
Plan tool was protected by Clear-Trust for proper authentication.
. Responsible for designing front-end screens in ASP.Net, which
incorporated the maximum capturing the User requirements charting out
the process flows, that include the Project Charter, High Level
Process flows, Detailed Process flows, and System Design.
. Database Design and Modeling: SQL Server. Created entities, triggers,
stored procedures including the optimization for performance.
. Development of forms in ASP.Net. Used Validation controls along with
Javascript for form level validations.
. Used ADO.Net to access the database and establish connectivity.
DataReades were used mainly used to access the one time informations.
. A webservice was implemented to access the user information based on
the Employee-Id's entered.
. A Process was developed and automatically scheduled to retrieve the
data submitted thru the webform into the Oracle Database. The
retrieved data was stored in the department administered local SQl
Server Database.
. A Reporting section was used to determine the total number of Service
Orders placed, processed, Pending, Based on Carriers, Departments and
Device Type.
Environment: Visual Studio .Net 1.1, ADO.Net, VB.Net, Web services,
ASP.Net, SQL Server 2000, Oracle, Html, CSS, Clear Trust
09/2002-12/2005 DJH
Associates Ltd
Programmer/Analyst
Project Tracking System
Tools & Technologies: VB.Net, ASP.Net, VB script, Java script, SQL Server
7.0, MS Access 2000, WinHelp, HTML, Crystal Report.
DJH is a mechanical company specialized in HVAC. PTS is software used for
pre-bid activities in the company. This keeps track of bid-dates, Prices,
Meetings, Attendees, Estimation and provides high level of Management
Reporting. Expedition 7.0 was used for post-bid activities, and Suretrack
was used for developing the schedules. Developed for windows 95/98/2000/NT
professional operating systems. Support both Microsoft Access and ODBC
databases such as SQL Server on stand-alone networks. Microsoft ADO.Net is
used to access the database. Crystal Report 6.0 is used for displaying
reports. The web-based model is built with ASP.Net as GUI and SQL Server as
backend.
. Design and Development of PTS in VB .NET.
. Designed the screens and Tables in most normalized form.
. In depth knowledge of sure track and Expedition 7.0 helped in
designing the system with utmost user friendliness.
. Created a Database backup component to backup the database into a text
file.
. User-level login helps in keep track of changes made by log-in id.
. Writing complicated queries, views, triggers and stored procedures
using T-SQL.
. Testing the application using various test plans.
. Generating Reports using Crystal Report.
. Developing Help files in HTML pages using WinHelp
. Implemented SQL Server database access from ASP.Net in the webmodel.
. Used VB script and Java script for the scripting purposes in the
webmodel.
Environment: VB.Net, ASP.Net, VB script, Java script, SQL Server 7.0, MS
Access 2000, WinHelp, HTML, Crystal Report.
Lead Web designer and developer
Tools & Technologies: Dream weaver, Photoshop, ASP and MS Access 2000,
Visual Basic 6.0, VBA,Vbscript, Javascript.
In the changed scenario of doing business DJH wanted to develop a website
which throws an insight into their 20 years of industry experience and
gives and up-to-date information of project schedules, bidding activities
etc.The bidding results accumulated was worth enough a resource, which
could be used as a statistic in future bidding. Vbscript and Javascript was
used for the scripting purposes. Visual Basic and VBA macros were used
initially to extract the project details from the existing system.
. Developed the GUI front ends using HTML, Dreamviewer, Photoshop.
. Implemented MS Access database access from ASP.
. Used VBA macros to extract data from current databases.
. Tested several modules identifying bugs and worked on debugging of
project.
. Created redirect component in the event of server failure.
. The progress schedule of each project, Progress photos, latest bidding
info could be accessed anywhere anytime.
Environment: Dream weaver, Photoshop, ASP and MS Access 2000, Visual Basic
6.0, VBA, Vbscript, Javascript
Professional References:
Name Company
. Paul Church United Parcel Service
. Randall Sinanan United Parcel Service
Contact this candidate