Quality Assurance Sql Server

AMIT SHARMA

********@*****.***

202-***-****

Abstract

Information Technology professional with 12 years of experience with

systems design, development, testing, and innovative problem solving

skills pursuing management career opportunities.

Education

Master of Science - Earned a degree in Information Systems and

Technology at Johns Hopkins University - Year of graduation: May 2005.

GPA in major: 4.0; GPA Overall: 3.82.

Bachelor of Science - Earned a degree in Decision Information Systems

and Management Science and Statistics at University of Maryland, College

Park - Year of graduation: May 1998.

Work experience

HEALTH AND HUMAN SERVICES (HHS) Washington, DC

May 2010 - Nov 2010

Technology Specialist

. Responsible for development of an enterprise wide strategy for

deployment of Percussion Rhythmyx content management software

across HHS and its sub agencies such as National Institutes of

Health (NIH), National Cancer Institute (NCI), Health Resources

and Services Administration (HRSA) etc.

. Responsible for development of an enterprise wide strategy for

deployment of Enterprise Google Maps software across HHS and its

sub agencies such as National Institutes of Health (NIH), Center

for Disease Control (CDC), Indian Health Service (IHS), etc.

. Enterprise strategy development includes considerations such as,

IT security, assessing and mitigating risks, taxonomy, etc.

. Responsible for development of the healthcare.gov web asset, one

of President Obama's critical healthcare initiatives.

. Responsible for development of an enterprise wide HHS mobile

software strategy.

. Responsible for development of the newmedia.hhs.gov web asset

which supports the HHS new media strategy and communications.

. Responsible for development strategy for the comment analysis tool

used to capture user sentiments from HHS web assets.

. Provide leadership and direction to staff and contractors in

support of the goals and vision of the organization.

GLYNN TECHNOLOGIES Bethesda, MD

Apr 2009 - Jan 2010

Chief Solution Architect

Health and Human Services (HHS)

Apr 2009 -Jan 2010

. Responsible for development of an enterprise wide strategy for

deployment of Accenture Digital Diagnostics Engine (ADDE) software

across HHS and all sub agencies such as National Institutes of

Health (NIH), Center for Disease Control (CDC), National Cancer

Institute (NCI), etc.

. Responsible for all project management activities, including but

not limited to, generating key performance indicators (KPI),

tracking all project tasks and activities, tracking all issues and

managing risks, loading resources for optimal results, etc.

. Responsible for development of policies and standard operating

procedures for usage of ADDE software and servers.

. Responsible for capacity planning across all deployments for the

different agencies.

. Responsible for creating security and governance policies

. Responsible for creating policies and procedures that mitigate any

risks involved with deploying the software across the HHS

enterprise.

. Responsible for providing guidance in analysis of scans across HHS

web assets as well as sub agencies' web assets.

. Responsible for creating and executing the Data Management Plan,

and the Quality Assurance Plan.

. Responsible for delivery of HHS Enterprise Deployment Strategy and

Implementation documents and artifacts.

. Acting liaison for HHS to coordinate with Accenture team for all

upgrades and new ADDE software development initiatives.

. Responsible for delivery of in class training to classes of 20 or

more students in each class across the HHS enterprise and sub

agencies on a weekly basis.

. Responsible for providing guidance and working closely with the

CIO of each organization within HHS to ensure successful

implementations of the solution.

. Responsible for business development resulting in growth of the

project over 400% percent in size of personnel resources.

. Responsible for coaching and mentoring team, and providing

individual performance feedback and metrics to team members.

ACCENTURE Reston, VA

Apr 2004 - Apr 2009

Senior Consultant

Accenture Marketing Sciences (AMS)

Sep 2008 -Apr 2009

. Responsible for presales engineering of Accenture Digital

Diagnostics (ADD) software and generating new business for AMS.

. Responsible for conducting presales demonstrations of ADD software

for Fortune 500 clients.

. Responsible for scanning web properties for Fortune 500 clients

and conducting web asset analysis

. Responsible for generating and analyzing reports detailing web

assets key performance metrics.

. Responsible for coaching and mentoring team, and providing

individual performance feedback and metrics to team members.

Department of Homeland Security (DHS)

Feb 2008 - Sep 2008

. Responsible for database migrations of several DHS databases from

MS Access to a secure platform, Oracle 10g advanced encryption.

. Responsible for data cleansing and data migration, data strategy,

work products, and deliverables.

. Responsible for quality assurance of database migration and

auditing of data migrated.

. Responsible for creation of all database scripts to generate

schemas, objects, dataloads, etc.

. Responsible for coaching and mentoring team, and providing

individual performance feedback and metrics to team members.

Sonepar USA

May 2007 - Nov 2007

. Manage and lead the Data Architecture team to support

implementation of Business Intelligence (Cognos, Informatica, SQL

Server) across Sonepar USA.

. Responsible for delivering functional and technical approach for

logical and physical datamodels to unify the 14 disparate

subsidiaries owned by Sonepar.

. Responsible for creating data strategy and executing the data

framework for source, staging, operational, and datawarehouse

environments.

. Responsible for management of all databases (staging, operational,

datawarehouse) and data strategy across all environments (dev,

test, production).

. Worked directly with senior partners and the CIO of Sonepar while

providing leadership, managing, and leading business intelligence

efforts with many different groups, (Sonepar marketing, finance,

IT, etc.) and teams (Accenture ETL, Reporting, Functional, etc.)

for a successful implementation.

. Responsible for coaching and mentoring team, and providing

individual performance feedback and metrics to team members.

Internal Revenue Service (IRS) - Integrated Customer Communication

Environment (ICCE) Feb 2005 - Apr 2007

. Responsible for architecting, modeling and developing the strategy

and solution of the Individual Taxpayer Id System (ITIN). The

ITIN system streamlines legacy systems and processes for issuing

Taxpayer Ids and managing Taxpayer information.

. The ITIN system adds considerable value for the IRS not just by

saving the agency money but also making relevant information and

resources available to the IRS and Taxpayers.

. Responsible for creating and executing the Data model and data

framework for the ITIN system.

. Responsible for creating and executing the Data Management Plan,

and the Quality Assurance Plan for the ITIN system.

. Responsible for custom design and development of ITIN system and

ITIN Reports.

. Responsible for taking the system live and providing production

support for the ITIN system.

. Responsible for correcting defects and making enhancements through

change requests.

. Responsible for developing a prototype for the Online Payment

Agreement (OPA) system. The OPA system adds considerable value

for the client by creating additional channels for collection of

taxes owed to the IRS.

. Technologies utilized include but are not limited to: WebSphere

5.1, Oracle 10g, Java, JSP, JavaScript, XML, Clearcase,

Clearquest, etc.

. Responsible for coaching and mentoring team, and providing

individual performance feedback and metrics to team members.

Department of Education - Common Originations and Disbursements (COD)

Nov 2004 - Jan 2005

. As part of the Technical Architecture team, consolidated disparate

database information into central production data model.

. Conducted table and field level analysis to revamp and streamline

the DB2 database model using ERWIN data modeler.

. Increased database performance by eliminating unused tables and

fields in the production environment.

Department of Education - Front End Business Integration (FEBI)

May 2004 - Nov 2004

. Developed critical portions of proposal for Front End Business

Integration (FEBI) of Federal Student Aid Systems (FSA) valued

over $1 billion.

. Developed a prototype of the proposed system to manage federal

loans and grants.

. Researched and drafted the proposed Single-Sign On functionality

for the FEBI solution.

. Researched areas for FEBI proposal including Siebel, Service

Oriented Architectures, user interfaces, etc.

. Researched and drafted Accenture credentials for similar J2EE

projects.

. Developed and documented conceptual design for FAFSA NextGen,

Student Aid on the Web, and FEBI Agent Desktop.

. Gathered and documented requirements for FAFSA NextGen and Student

Aid on the Web.

. Developed and maintained design log for changes to all prototype

applications for FEBI.

Department of Education - Data Strategy

May 2004 - Nov 2004

. Developed and executed functional test plan for XML Registry and

Repository system and made appropriate fixes to the J2EE

application using Websphere in addition to fixes made to the web

front end of the application.

. Developed and executed performance test plan for XML Registry and

Repository system using LoadRunner 7.0 and Wily 5.1.

. Created documentation of Oracle database housing data for the XML

Registry and Repository system.

. Created a user guide for all roles using the XML Registry and

Repository system.

. Created performance test plan report as deliverable for client.

. Created Performance Readiness Report and Operational Readiness

Report submitted to the client.

. Developed robust security plan for the XML Registry and Repository

system.

. Developed XML Registry and Repository system deliverables and

documentation and Quarterly Reports detailing system usage.

. Developed XML Data Strategy initiative for Federal Student Aid

systems.

Independent Consultant

Nov 2002 - Apr 2004

Verizon

. Utilizing six sigma methodology, prototyped, designed, and

developed a web application system on the .NET platform for

managing access to secure remote facilities housing

telecommunications equipment for Verizon.

. Designed an Oracle back-end interfacing with a web-based front

end.

. Design also included seamless integration of the .NET and Oracle

system with HandySoft's Bizflow, a workflow system.

. Created business process and change process flows in Bizflow.

. Prototyped user-friendly interface incrementally with customer

involvement and approval.

. Created and executed test plans for all modules of .NET, Oracle,

and Bizflow functionality and consistency.

Arlington County, VA

. Analyzed and scoped implementation of Rhythmyx Content Management

System.

. Participated in Joint Application Development (JAD) sessions to

resolve issues related to integration with all existing

infrastructure.

. After conducting research and analysis of integration issues,

recommended customizations needed to seamlessly integrate Rhythmyx

with existing systems and infrastructure.

Technical Resources International Bethesda, MD

Jul 2001 - Nov 2002

IT Manager

. Managed all IT department functions, wrote proposals and cost

estimations.

. Architected solutions for clients based on requirements.

. Managed and developed web application solutions for clients.

. Architected and developed an online "peer review" system used to

conduct reviews of documents, code, systems, etc.

. Designed and developed web application solution for Center for

Disease Control (CDC) to manage anthrax vaccine study data; and

National Institute for Allergy and Infectious Diseases (NIAID) to

manage simian vaccine studies.

. Technologies utilized include, but not limited to: ASP, VBScript,

JavaScript, HTML, XML, Microsoft Access, SQL Server 2000, Oracle

9x, etc.

OneSoft Corporation Fairfax, VA

Jan 2000 - Apr 2001

Technical Lead

After conducting business process analysis, designed and implemented

Internet commerce solutions for clients (onsite and offsite) utilizing

OneCommerce, which enables clients to leverage technologies to gain

competitive advantages in the marketplace. Technologies utilized

include, but are not limited to: ASP, XML, XSL, JavaScript, VBScript,

HTML, and SQL Server.

Arthur Anderson

. Conducted analysis of requirements specifications for Expatriate

Human Resource System.

. Architected Expatriate Human Resource System solution based on

requirements.

. Designed database architecture in accordance with requirement

specifications.

. Created XDRs to identify relationships in the database and XML

structures to establish hierarchy in data.

. Actively involved in overall design, development, and deployment

of project and solution.

Briggs & Stratton

. Architected solutions at client site, which included analysis of

requirements and design of databases and site structure.

. Prototyped design integration with Eprise, a workflow system.

. Customized the solution in accordance with requirements

specifications.

INTECH, Inc. Fairfax, VA

Jul 1999 - Dec 1999

Consultant

Ephones

. Developed Internet commerce solutions utilizing OneCommerce.

. Wrote ADO calls to the SQL Server database and by passed

OneCommerce because OneCommerce calls executed very slow. Worked

on Workstation (DHTML tool used to manipulate and administer the

site) for adding pager plans and pagers and phones to the system.

Hamilton Insurance

. Developed a web-based application for Hamilton Insurance Agency

utilizing the following technologies: ASP, JScript, VBScript,

HTML, and MSAccess.

. Solution replaced a paper-based system which Hamilton Insurance

Agency used to keep track of incidents that occur at nursing homes

as well as provide reporting capabilities.

Sterling Software

. Responsible for support, maintenance, and enhancements of Cytrix

Terminal Server thin client technology.

. Support, maintenance, and enhancements of Vantive and Vantive on

the Go interfaced with SQL Server and Sybase Databases, support of

Aublix search tool and support, maintenance, and enhancements of

Crystal Reports.

Electronic Data Systems (EDS) Washington, D.C.

Jul 1998 - Jul 1999

Information Analyst

. Developed web presence for government e-commerce, and sales and

marketing.

. Responsible for Y2K compliance initiative within sales and

marketing group.

. Conducted research on various projects on feasibility of new

technologies

. Conducted research and developed strategy for government e-

commerce initiative.

. Participated in development of strategic business plan for a 2-3

year outlook.

. Conducted analysis on proposals for information technology

contracts.

. Developed and maintained intranet for INS-ITP account.

Skills

Operating systems: Windows 98/95, 3x, NT 4.0, 2000, XP, Unix and Linux

Software: WebSphere 5.1, ERWIN Data Modeler, LoadRunner 7.0, Wily

Introscope 5.1, Bizflow 8.5, Microsoft Office, Interdev 6.0,

Microsoft Visio, .NET, Visual Source Safe, Clearcase,

Clearquest, Toad Data Modeler, Accenture Digital Diagnostics

Software, Percussion Rhythmyx, Drupal

Languages: Java, JSP, JavaScript, ASP, VBScript, XML, XSL, Visual

Basic 6.0, C, SQL

Databases: SQL Server 200x, Oracle 11i, MySQL 5.x, Sybase, and

Microsoft Access 200x

Contact this candidate