SUMMARY

• Database Administrator and Microsoft Certified IT Professional with over 12 years of experience in Information Technology spanning all of the stages of the software development life cycle including Analysis, Design, Development and implementation of Client/Server and web Applications in various industries including Government, Healthcare, Retail, Services and Manufacturing. I have been supporting the SQL 2008 Administration, SharePoint 2010, infrastructure and maintaining the server farm at Empyra for its customers for the last 6 years. Hands-on experience in managing a small to medium size team.

SKILL STRENGTHS INCLUDE:

• Extensive experience in setting up windows servers, SQL Server, Domain controller, Exchange server, web servers, SQL Server, web metrics, Load balancer, Virtual server and application infrastructure.
• Implemented MS SQL Cluster (Active/Passive & Active/Active), Multi Node Cluster.
• Implemented MS SQL 2008 mirroring with automatic failover for high availability.
• Handled Fine Tuning Databases System in-coordination with Application team to utilize the maximum resources for Database and Applications.
• Extensive experience in application development using NET Framework, C#. NET, VB.NET, Visual Basic 6.0, COM, COM+, SQL Server, ASP.NET.
• VBScript, JavaScript, XML/ XSLT, DHTML, Web Services, and CSS.
• Expertise in Database Programming and Development using MS SQL Server 2000/2005/2008, Oracle7.x/8i and good experience in SQL, T-SQL, PL/SQL, SSAS, SSIS, SSRS, Jobs and Stored Procedures.
• Manage and maintain server infrastructure for Empyra and its customers.

TECHNICAL SKILLS

Operating Systems:Windows Advanced Server 2000/2003/2008, Windows XP/Vista/Windows 7.
Languages: C#, C, C++, VB.NET, ASP.NET, Visual Basic 6.0, VBScript, Java Script, HTML, XML/XSL.
Databases:ORACLE 8i, 9i/10G and SQL Server 2000/2005/2008.
Technologies: OOPS, OOAD, ActiveX, COM/DCOM, COM+, ADO, ADO.NET, Web Services.
Reporting Tools:Crystal Reports, Data Reports, SQL Server 2008 Reporting Services.
Tools: SVN, Visual SourceSafe 6.0, Microsoft Office Project 2003, Visio, Toad, SQL Developer, SharePoint 2010.
EDUCATION

• Bachelor of Engineer in Computer Technologies (Confidential,University, April 2000).
• Microsoft Certification (MCP, MCAD) ASP.NET, C# and SQL Server.
• MCITP Database Administrator 2008.

PROFESSIONAL EXPERIENCE
Confidential Jan 2006 to Present
Environment: Windows Advanced Server 2003/2008 OS Servers, IIS, Web Metrics, Load balancer, Fire Wall, ASP.Net, C#, SQL Server 2005/2008, SQL Server 2005 Reporting Services, HTML/XML/DHTML.
Role: Sr. Systems Engineer.
Project Description:
Empyra is a software company. Which have OneFlow Cloud Solutions provide cloud solutions based on OneFlow platform. OneFlow solutions on the cloud are scalable, with rapid start-up, and no hardware investment. OneFlow is a platform solution that is used to build solutions for different verticals. Empyra provide pre-configured solutions for Workforce Development, Housing Demolition and Rehabilitation management. Empyra OneFlow provides integrated workflow and tracking to ensure that information gathered through the process can be reported on. The Empyra OneFlow portal brings jobseekers and OneStop organizations together by matching the needs of the jobseeker with service/solution offerings specifically tailored to their needs.
Responsibilities:

• Responsible for installation and configuration of SQL server 2005, 2008 on Servers. Applied patches and service packs to keep the database at current patch level.
• Administered all development, QA and production SQL Servers/databases and related systems.
• Experience in Performance Tuning, Recreating index, Query Optimization, Client/Server Connectivity.
• Monitored lock Escalation, Dead Locks, resources utilization by sessions, capturing long running SQL queries.
• Extensive experience in ETL process consists of data transformations, sourcing, mapping, conversion and loading.
• Establish and ensure appropriate data quality and ETL metrics are defined, monitored and managed.
• Developed SSIS packages to extract and load data from transactional databases.
• Created ETL processes using windows scripts, batch files, SQL stored procedures, and SQL jobs.
• Used dynamic parameters in SSRS to enable/disable the parameters based on user selection.
• Provided 7 x 24 Production support for the database and application issues.
• Installed and configured SharePoint 2010 and Create SharePoint team sites.
• Created SharePoint groups and assigned different permission levels to different sites.
• Provide support to development teams to setup and upgrade/manage Empyra and client environments with configuration management and project management software.
• System Admin/Network Admin for Windows server 2000/2003/2008 based networks and for mixed platform.
• Developed and implemented properly the backup and disaster recovery procedures.
• Also part of the development team involved in application designs and development in ASP.NET, VB.NET, C#.

Project : State of Ohio Attorney General “Coin Project” May 2006 to Dec 2006
Confidential
Environment: Windows Advanced Server 2003/XP, ASP.Net, VB.net, Crystal Reports, Oracle 9i/10G, HTML/XML/DHTML.
Role: Sr. Software Engineer.

Project Description:
This .NET project was for the State of Ohio Attorney General’s charitable organization Information Network (COIN). The project scope enabled public online registration for professional solicitors and fund-raising councils for bingo organizations who engage in solicitation for charitable organization operating in the state of Ohio. Professional solicitors and fund-raising councils need to have an account set up with the Attorney General’s office to use the online registration application to submit solicitation notices or financial information.
Responsibilities:

• Develop modules using ASP.NET, VB.NET, Web Services, and Oracle that resulted in increased registration speed and reporting capabilities by 70%.
• Developed various database Classes and Business Classes to achieve client specified functional requirements.
• Developed queries and stored procedures by using SQL developer tool.
• Suggested Application level tuning changes for code, queries, SQL objects which may not be performing up to the optimum database performance standards.
• Developed & executed scripted changes requests in accordance with change control procedures.

Confidential
Environment: Windows Advanced Server 2003/2000/XP, ASP.Net, VB.net, Crystal Reports, SQL Server 2000, HTML/XML/DHTML
Role: Software Engineer
Project Description: Primero Cafeteria Solutions suite addresses the needs of managing daily school food service operations. The system allows parents to make payments for cafeteria plans with their credit/check cards through any internet enabled PC at any time. The system prompts parents with low balance reminders through an email notification while providing an online menu and payment history.
Responsibilities:

• Implemented XML driven Config Files to specify the format of Fixed Length / Comma Separated Data Files. Used these user defined .Config files to achieve Data Import / Export, to and from the Student Information System which not only achieved the integration between Primero and products of different vendors but also made implementation process very simple.
• Extensively utilized XML for implementing Dynamic Menu Building and having Users and Roles assigned to each user helped establish Role Based Security in Primero.
• Reduced deployment time in half by adhering to coding standards utilizing VB, SQL Server and developing reporting tools for customers with Crystal Reports.

Project : Ultima*Zoe Health Care System Aug 2004 to Sep 2005
Confidential,USA
Environment : Windows Advanced Server 2000/XP/98,ASP.Net, C#, Crystal Reports, SQL Server 2000, HTML/XML/DHTML
Role: Senior Developer
Project Description: Ulitma*Zoe is a web based health information management system. It is a specialized web-based system, which identifies and handles all the departments of a health care organization. The unique feature of this system is its user-friendly appearance and GUI. All modules are arranged in a Zoe Explorer (Treeview) which allows the user to easily navigate throughout the system and is HIPAA compliant.
Responsibilities:

• Analyzed requirements for the project and wrote design and functional specifications resulting in greater reporting capabilities for health care departments.
• Developed N-tier architecture application using ASP.NET, Visual Basic, and C# and stored procedures in SQL Server.
• Extensive use of the ADO.NET objects such as Data grids, Data Tables, Data Readers and Datasets for data retrieval and manipulation.

Project : Scheduling For Surgical System Oct 2003 to July 2004
Confidential,INDIA
Environment: Windows Advanced Server 2000/XP/98, ASP.Net, C#, Java Script, SQL Server 2000, HTML/XML/DHTML
Role: Senior Developer
Project Description: The Scheduling Program is a resource management tool that allows scheduling staff to utilize a streamlined graphical display. The Scheduling program provides the ability to enter demographic information about the patient when the surgery is scheduled and reserve the time, equipment, space, and human resources for a surgical procedure. The system identifies the time or resource conflicts at the scheduled surgery time and generates a procedure or preference card for the surgeon or procedure type.
Responsibilities:

• Managed all stages of the SDLC cycle from design, development and unit testing, on both development and production environments including IIS.
• Developed N-tier architecture application using ASP.NET and VB.NET.
• Implemented SQL, Stored Procedures, defined constraints, and created new tables.

Project : W-HIS (Web Enabled Healthcare Information System)
Confidential
Environment: Windows NT, Windows 2000/98, ASP, ASP.Net, VN.NET, Oracle 9i, SQL Server 2000, HTML/XML/DHTML
Role: Sr. Software Engineer
Project Description: W-HMS is a complete web based Healthcare Information System. It has been designed and developed for Healthcare organizations to provide the finest automation and messaging systems. The solution has been designed with complex processing requirements and stipulations. Benefits of W-HMS include its reliability and scalability. It was developed in a pure Internet/Intranet development environment.
Responsibilities:

• Involved in Analysis and Implementation of the total project implementation which resulted in $2 million dollar cost savings.
• Analyzed requirements for the project and writing design and functional specifications.
• Developing N-tier architecture application using ASP.NET and developed PL/SQL, Stored Procedures in SQL Server.