Sql Server Management

PROFESSIONAL SYNOPSIS

Over * years of SharePoint experience as subject matter expert (SME) in SharePoint

Wali

Saddiqui, Ph.D.

Phone: 214-***-****

Email:

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

m

Implementation, Architecture and Development. Over 15 years of IT experience across various practice areas,

including System Architecture, Software Development, Networking, and Security, involving Microsoft .NET

Framework, C#.NET, Microsoft SharePoint 2010, Microsoft Office SharePoint Server 2007 (MOSS 2007,

InfoPath 2007, Single Sign-On, SAML, Federation and Security.

Hands-on experience in SharePoint 2010 and MOSS 2007 Installation, Deployment, Configuration,

Upgrade, Logical and Physical Server Farm Architecture, Site Template Customization, Site Definition

Customization, Taxonomy, Metadata, Content Management, Collaboration, Windows Workflow

Foundation, Custom Web Parts, Reports, Business Data Catalog (BDC), InfoPath Forms Server, Master

Pages, Content Types, Features, Custom Actions, Custom Event Receivers, Custom Feature Receivers,

Custom Service Applications, CAML, FAST, Power Shell, and Enterprise Search.

Proficient in designing, developing, deploying, packaging and securing SharePoint 2010 and MOSS

2007 based custom Web Parts, Workflows, Web Controls, Web Services, Custom Actions, SharePoint

Application Pages, Silverlight, Web and Windows Applications using C#.NET, ASP.NET, InfoPath 2007,

VB, C++, C, LINQ, HTML, DHTML, VB Script, JavaScript, XML, XSLT, XPATH, XSD Schema, AJAX,

Visual Studio 2010/2008, and Microsoft Team Foundation Server.

Hands-on experience is design, configuration and implementation of Single Sign-On in SharePoint

2010 farm using Microsoft ADFS 2.0.

Extensive experience in design, configuration and custom development of search solutions in

SharePoint 2010 using Microsoft FAST Search Server.

Proficient in database design and implementation of various client-server and windows based

applications using ADO.NET, ADO, DAO, RDO, ODBC, JDBC, XML Web Services, .NET Remoting with

Access, SQL Server, and Oracle as the back-end database servers.

Expertise in writing Stored Procedures, Triggers, and Packages using TSQL.

1 Wali Saddiqui

Expert in Database Design, Backup and Recovery, Data Transfer, Data Transformation, and

Database Tuning, and Database Migration.

EDUCATION

Ph.D. - Computer Science

Southern Methodist University, Dallas, TX, USA – 2005

MS - Computer Science

Southern Methodist University, Dallas, TX, USA – 2003

B.E - Computer Systems Engineering

N.E.D University of Engineering & Technology, Karachi, Pakistan – 2000

Industry Certifications

AIIM SharePoint Practitioner

Oracle 8: Certified Database Administrator (OCP)

PROFESSIONAL EXPERIENCE

2 Wali Saddiqui

Sr. SharePoint Architect / Tech Lead – ShareSoft, Dallas, TX (July 2011 – to date)

Marshfield Clinic Document Control System (DCS) is a SharePoint 2010

based solution to support system-wide control of documents in the Nurse Line,

Lab, Ambulatory Surgery and Patient Financial Services areas of Marshfield

Clinic, Marshfield, WI. The outcome of this project is to implement a functional

and operational document and record management system for creating,

retrieving, modifying, and storage of all policies, processes, procedures,

protocols, and resource guides throughout the Marshfield Clinic system. It uses

Microsoft FAST Search Server and ADFS to provide search and SSO

functionalities, respectively.

CHRISTUS Health Intranet is a SharePoint 2010 powered Intranet

delivering a unified platform for content management and collaboration while

also paving the way for significant business process improvements. Microsoft

FAST Search Server is leveraged to build a comprehensive information access

solution to reduce the time to find information and increase productivity and

end user adoption. Implementation of a custom look and feel for the Intranet

site is accomplished through the use of SharePoint Designer 2010.

Whataburger Restaurant Portal is a SharePoint 2010 based Intranet and

Collaboration Portal developed using custom web parts, site templates,

application layout pages, master pages, page layouts, workflows, user solutions

and custom look and feel. A combination of the Search Core Results web part

and custom-developed search controls are used to deliver a robust restaurant

directory and a custom utility interacting and collaborating with employees

across more than 500 restaurants nationwide.

Responsibilities

• Designed and implemented SharePoint 2010 based Records

Management System for managing electronic documents including

procedures, policies, protocols, and forms with automated and consistent

document routing, tracking, and CFR Part 11-compliant electronic

signatures.

Developed requirements and design documents including, SharePoint Farm

Architecture, Application Design, Security and Governance Design, and Search

Architecture.

Designed and Developed Records Review and Approval Custom Sequential Workflow

and Custom Sequential Activity involving multi authors, co-authors, reviewers and

approvers using Visual Studio 2010.

Implemented Electronic Signatures in the Workflow based on CFR Part-11

specifications.

3 Wali Saddiqui

Designed and developed Custom Site Templates, Event Receivers, Content Types,

Taxonomy, Security Groups and Permission Levels, Timer Job, Custom Actions for

document library management, and Feature Stapler.

Designed and developed Content Types Hub for the management of the content types

used across the SharePoint Farm.

Design and developed Taxonomy using new Managed Metadata Service, Document

Sets, and Content Type syndication and publication to apply a custom taxonomy.

Design and developed Versioning, Information Management Policies, Records

Retention, and Publishing Workflows.

Developed Blogs, Discussion Boards and WiKis branded with a unified look and feel.

Developed My Sites, Social Tagging, Organization Charts, Colleagues Web Parts.

Environment – Microsoft SharePoint 2010, Microsoft Visual Studio 2010,

ASP.NET, C#.NET, SQL Server, Team Foundation Server, VMWare, SharePoint

2010 Managed Metadata Service Application, Custom Workflows, Custom

Actions, Custom Event Receivers, Custom Feature Receivers, Custom

Application Pages, Content Types, Site Columns, Custom Lists and Document

Libraries, Custom Publishing Pages, Custom SharePoint Timer Jobs, Search

Scopes, Search Managed Properties and Search Crawled Properties, Managed

Term Store and Term Sets.

Sr. SharePoint Architect / Developer – Gimmal Group, Houston, TX (September 2009

– July 2011)

Compliance Suite for Microsoft SharePoint 2010 (CS 2010) takes advantage of SharePoint 2010, one of the

most popular and widely adopted server products in the history of Microsoft, to provide an enterprise records

retention policy solution that meets the standards of DoD 5015.2, provides capabilities that Records Managers

require and delivers the ease of classification that users demand. With the addition of the Compliance Suite,

SharePoint 2010 becomes a repository for both work-in-progress collaborative documents and enterprise

records. The Compliance Suite provides an efficient and intuitive experience for users who are embracing

SharePoint like no other platform before it. Created for organizations dedicated to simplifying wherever

possible, the Compliance Suite lowers the risk of unmanaged content and significantly lowers the costs

associated with the processing, reviewing, and analyzing content. Some of the Compliance suite customers are:

• First Home Loan Bank of California

• Office of the Privacy Commissioner of Canada

• Salt River Project

• US Department of Energy

McDermott International, Inc Records Retention Schedule (MII RRS) is a Microsoft Office SharePoint

Server – MOSS 2007 application to assist with capturing, aggregating and analyzing business records in order

to produce a global Retention Schedule (RRS). The solution enhanced company's ability to provide additional

information pertaining to each aggregated record category required by the Corporate Records Department to

administer the Records Program. In addition, some of the information provided by this solution was also used

by internal Legal Counsel in their review of the laws and regulations.

4 Wali Saddiqui

American Airlines, Inc - led the Global roll-out of MOSS 2007 and migration from SharePoint 2003 to

MOSS 2007 in central, disaster recovery and regional server farms across US and overseas. Designed and

developed MOSS 2007 based web parts, providing heterogeneous client applications communication with

corporate web site. Components include: ASP.NET Web Service, custom SharePoint web part, work flows,

.NET Framework based Rendering Engine.

Responsibilities

• Design and developed Restricted Records Access functionality in SharePoint 2010 to provide

custom security for SharePoint Lists, Folders and Documents based on the content of SharePoint site

columns.

• Design and developed Vital Record processing in SharePoint 2010 that would be required to

reconstitute the organization’s normal business functions after a major disaster.

• Design and developed Cutoff processing in SharePoint 2010 to break, or end, the record at regular

intervals to permit disposal or transfer.

• Design and developed Alerts functionality in SharePoint 2010 providing notification capability that

can be configured to meet specific and very granular requirements.

• Design and developed Record Relationship functionality in SharePoint 2010 providing record

linking, classification, versioning and email attachment linking.

• Design and developed Installer for Compliance Suite features and solutions in a SharePoint server

farm.

• Involved in installation, configuration, setup and testing of SharePoint 2010 based products in various

production environments.

Environment – Microsoft SharePoint 2010, Microsoft Visual Studio 2010, ASP.NET, C#.NET, XML Web

Services, SQL Server, Team Foundation Server, VMWare, SharePoint 2010 Managed Metadata Service

Application, Custom Service Application in SharePoint 2010, Custom Workflows, Custom Actions, Custom

Web Parts, Custom Event Receivers, Custom Feature Receivers, Custom List Settings Page, Custom

Application Pages, Silverlight, MVVM, MVC, Content Types, Site Columns, Custom Lists and Document

Libraries, Custom Publishing Pages, Custom SharePoint Timer Jobs, Search Scopes, Search Managed

Properties and Search Crawled Properties, Managed Term Store and Term Sets, Record Center Site Template,

Item Level Permissions for List Items, Workflow Initiation and Association Pages.

Sr. SharePoint Architect / Developer – Electronic Data Systems, Plano, TX (May 2005 – August 2009)

Client Experience Portal (CXP) is MOSS 2007 based portal that provides innovative UI and allows

authorized users, via single sign-on authentication, access to web-hosted client-facing and EDS internal

SharePoint and non SharePoint applications. It enhances EDS’ ability to provide internal audiences, clients,

and prospective clients with easy-to-use and consistent methods for engaging and interacting with the

company’s global enterprise, directly from their desktops, as an integrated component of eds.com. CXP

enriches and expands the functionality that EDS has traditionally provided to the clients, so that EDS and

clients will ultimately have a complete set of SharePoint features to automate the relationship and service

touch points, from start-up of service through ongoing operations.

Medicaid End User Provisioning System (MEUPS) is MOSS 2007 based automated Portal for provisioning

authorized Medicaid users in the State of Kentucky, Florida and Georgia. MEUPS provides a single sign-on

environment and innovative Portal for both Medicaid staff and the large Medicaid provider community,

automating the user authentication process for several Medicaid subsystems. It helps manage authorization on

several different applications hosted across organizational boundaries. MEUPS is built upon MOSS 2007,

.NET Framework and Microsoft's Active Directory Federated Services (ADFS).

ClearTrust Bridge enables EDS clients Federated access to the EDS ClearTrust protected MOSS 2007 based

web applications. This federation solution eliminates the need for an SharePoint based application user at an

5 Wali Saddiqui

EDS customer site sitting at a local computer workstation connected to customer network to sign on to the

EDS hosted MOSS 2007 and SharePoint 2003 based web applications. It provides a seamless access to the

protected SharePoint web applications to the users who have been pre-provisioned through EDS Identity and

Access Management System (IDAM).

Manage My Identity (MMI) is MOSS 2007 based application that allows the users to experience single sign-

on (SSO) to the applications integrated with the underlying Standard Operating Environment SSO capability. It

also allows users to maintain their security information in the EDS Identity and Access Management System.

Responsibilities

• Global roll-out of MOSS 2007 and migration from SharePoint 2003 to MOSS 2007, with central

server farm in Florida, DR farm in Georgia, and regional farms in Europe and Australia.

• Design and developed MOSS 2007 based Application Integration Web Part framework, providing

heterogeneous client applications communication with CXP. Components include ASP.NET Web

Service, SharePoint Web Part, Work Flows, and ASP.NET Web Service Proxy Object.

• Utilized SharePoint Business Data Catalog for importing user profile data from Oracle ERP,

PeopleSoft, eTrust, and ClearTust into MOSS.

• Provision of SharePoint user authorization, authentication, rendering XML contents, Web Server

Controls, Custom Controls into HTML contents and display on the browser, using CSS, XML, XSLT

and XSD.

• Deployed SQL Server Reporting Services for generation of reports and developed InfoPath forms,

custom Work Flows, Web Parts and Event Handlers for reporting services.

• Define XML & XSLT specifications and develop testing tool for XML and XSLT Validations.

• Build multilingual support in SharePoint Portal using Web Parts Navigation Controls, Master

Pages, C# based Satellite Assemblies and Resource Manager.

• Design and develop ASP.NET Web Service infrastructure and interface to implement standard Web

Methods, properties and classes for all SharePoint Web Parts.

• Develop C#, XML Document and XSLT Transform based Rendering Engine for rendering client

application XML contents, Web Controls and Custom Controls on the Client Experience SharePoint

Portal.

• Design and implement custom Lists, Web Parts, Themes, Site Definitions and Site templates for

Alerts/Bulletins, Reporting, Search, Templates, Display, Sorting, Spell-check, Print Capabilities,

Error Messages, and Help in MEUPS SharePoint Portal.

• Design and develop Content Management Solution including Document Library Web Parts and

XML Content Editor Web Parts.

Environment – Microsoft Office SharePoint Server, Windows SharePoint Portal Services, ASP.NET,

C#.NET, XML Web Services, XML Document, XSLT Transform, XML Parser, XML Reader, XML Writer,

XSD Schema, ADO.NET, SQL Server, TSQL, Visual Studio.NET, Visual SourceSafe, IIS, MS Visio,

Documentum, Microsoft Team Foundation Suite, RSA ClearTrust, LRA BlueCoat, Telerik Controls, VMWare,

Virtual Server, Virtual PC, and Vault

Sr. Software Engineer – MobiNets, Dallas, TX (July 2002 – May 2005)

Streaming Video is a web based application providing a streaming video server and client interaction. It runs

over the Real-Time Streaming Protocol (RTSP) and sends data using the Real-time Transfer Protocol (RTP). In

this project several C#.Net based classes such as Client, Server, RTPpacket, VideoStream and User Controls

such as Setup, Play, Pause and Teardown were developed.

Network Traffic Cop was designed and developed to provide traffic policing using a leaky bucket algorithm.

This application accepts connections from a sender, and a receiver. The Network Traffic Cop reads data from

the sender and forwards the data to the receiver if the sender is within transmission rate parameters such as

transmission rate, bucket size, and the leak rate of the bucket.

6 Wali Saddiqui

WebMigration project involved migration of ASP code to ASP.NET code for better performance and

optimized services. It involved analysis of entire code and applying appropriate modifications. Also it involved

support for application connectivity with SQL Server 2000 using ADO.NET and ODBC.

Virtual Home Agent Reliability in Mobile IPv6 based Systems (VHARP)

VHARP is a complete system architecture, design, implementation and GUI that supports reliability and offers

solution to the reliability problems associated with Mobile IPv6. The advantages of VHARP over all other

systems are reliable Mobile IPv6 operation, transparent failure detection and recovery mechanisms, no

message overhead over the air interface and others.

Efficient Load Balancing for Distributed Home Agents in Mobile IPv6 based Systems (E-LBMip)

The goal of this project was to design and develop a web based application providing dynamic load balancing

among multiple Home Agents in Mobile IPv6. The advantages of this application are reduced message

overhead over the air interface, fair distribution of load among the Home Agents, no service interruption,

efficient resource utilization and others.

Responsibilities

• Requirement gathering and analysis. Application designing, maintenance, refinement and tuning.

• Developing application Web forms using ASP.NET, C#.NET, and XML Web services.

• Provide XML Conversion for different document formats.

• Provide optimized search service using caching feature of ASP.NET.

• Creating an authentication proxy service between authentication server and client application using

SOAP based XML Web service and C#.NET based DLLs.

• Providing SQL Server 2000 connectivity of application using ADO.NET, XSD Schema, and

XPATH.

• Writing Stored Procedures, Triggers and Packages using TSQL for the database transactions.

• Providing application level security using .NET security features.

• Changing ASP code to ASP.NET by incorporating C#.NET and JavaScript.

• Changing C code to C#.NET.

• Creating Windows based database application using Winforms and ADO.NET.

• Improving the code by adding new features such as Event Driven Programming, Web Controls and

HTML Controls that could run at the server and provide fast access and increased processing.

• Installing Visual Studio.NET, IIS6.0, and Service Packs etc.

Environment – ASP.NET, ASP, C#.NET, C, JavaScript, XML Web Services, ADO.NET, TSQL, Visual

Studio.NET Framework, Visual SourceSafe 6.0, IIS 6.0, SQL Server 2000, Windows2K, Crystal Reports, MS

Visio, MS XML Parser, XML Conversion, XMLSchema, XPATH, MTS, Biztalk Server 2003, and MS Viso

2000.

Software Developer – McWin Systems, Dallas, TX (August 2001 – July 2002)

Data Tracking System is a web application that tracks and reports while voice data is flowing through the

network routers. The maintenance portion of this system allows network administrators and operators to

monitor and manage in real-time voice data generated by the mobile user and create troubleshooting tickets if

problem exists. Tickets are automatically verified based on a series of algorithms to avoid human verification

and automatically processed.

Port Scan Detection Tool (PSDT) is a lightweight network intrusion detection tool, capable of performing

real-time traffic analysis and packet logging on IP networks. It can perform protocol analysis, content

searching/matching and can be used to detect a variety of attacks and probes, such as buffer overflows, stealth

port scans, CGI attacks, SMB probes, OS fingerprinting attempts, and much more.

Responsibilities

7 Wali Saddiqui

• Involved in writing complex User Interface using ASP.

• Involved in writing COM/DCOM objects using C++.

• Extensively involved in writing Stored Procedures, Triggers, and Views in SQL Server 2000.

• Involved in generating reports for Investment Performance, Payout Performance, Monthly and

Quarterly Statements using Crystal Reports 8.5/9.0 Enterprise Edition.

• Involved in developing COM+ component to export reports in PDF format.

• Migrating Data from Oracle 8i to SQL Server 2000.

• Involved in debugging, code testing, optimization and maintenance.

Environment – ASP, COM/DCOM, C++, TSQL, Visual Studio, Visual SourceSafe 5.0, IIS5.0, SQL Server

2000, Oracle 8i, Windows2K Professional, and Crystal Reports.

System Analyst – CSIT Inc., Omaha, NE (January 2001 – August 2001)

Adventex is a web based database application, developed for University of Nebraska at Omaha. This helps the

faculty and staff to organize, maintain, access and update the graduate students records online along with

several other helpful web based services such as student profiling, highest grades, student evaluation and

ranking etc.

Online Testing System is a web based application providing online testing, automated admission processing

and online result publishing system. It was designed and developed with aim of automating the entire testing

system. This project successfully brought down the processing delay and latency in the admission and result

publishing processes. This project is critical for the organization as it directly affects the one of the goals for

increased performance, quality and revenue.

Responsibilities

• Database and Object model design for the application. Development and deployment of application.

• Developed COM components for interacting with remote campus applications.

• User Interface design and coding using ASP, C++, JavaScript and Oracle Developer 2000 Forms.

• Database reorganization, recovery and tuning strategies for optimum performance.

• Manage the Oracle databases and corresponding instances and schemas.

• Database software upgrades, installations and testing.

• Document Standard Operation Procedures and assist developers with writing efficient SQL.

• Responsible for creating Oracle Security schemas to provide appropriate levels of access to users

throughout the company. This includes creating roles and logins to adequately protect corporate data.

• Effective management support through the timely response to management staff problems and needs.

Environment – COM, ASP, C++, ODBC, RDO, DAO, Visual Studio, Visual SourceSafe 5.0, IIS5.0, Oracle

8i, Windows NT, Crystal Reports, and Oracle Developer 2000.

Database Administrator and Software Engineer – Topnet Corp. (February 1999 – November 2000)

Operation Management System (OMS) is a web based database application and a complete solution for

shipment tracking, billing, ordering and customer support, developed for TCS International Courier Services.

OMS provides Consignment Tracking information online. TCS has gone one step further through OMS, which

lead to increased performance and revenue.

Online Reservation System (REPAK) is a web based flight reservation system for PIA International. It

provides complete online graphical user interface and transaction management system for flight reservation,

flight inquiry, flight tracking, and other services. It also provides worldwide connectivity with major airlines

reservation systems and a secure transaction management.

8 Wali Saddiqui

Responsibilities

• Involved in Oracle 8 Database Architecture, Physical Design, Table Partitioning, Monitoring Multiple

Databases, Managing Physical Resources, Database Tuning, Security, Auditing, Backup & Recovery and

Establishing Procedures in support of the development & user community.

• Database Installations and Upgrades, Configuration Management and Troubleshooting.

• Review Sun Solaris 2.6 configurations on DBMS to ensure optimal Performance and availability.

• Allocate System Storage & plan future storage requirements for multiple databases.

• Ensure Compliance with Oracle License Agreements.

• Control & monitor user access to the database and maintain archived data on appropriate storage.

• Development of web pages and forms using ASP, Frontpage, HTML, VB and Visual Interdev.

• Provided JavaScript functions for the pages that support both Internet Explorer and Netscape.

• Provided Form Validation, exception handling, field initialization and tab ordering.

• Created Database tables and did normalization.

• Developed user interface and application code using ASP, VB, and C++.

• Provide application connectivity with Oracle8 database using ODBC and ADO.

• Develop COM and Macros using VB.

• Involved in writing Stored Procedures, Functions, Cursors, and Triggers using SQL/PLSQL.

• Involved in Database Design and Entity Relationship Modeling.

Environment – ASP, VB, C++, SQL/PLSQL, Frontpage, Visual Interdev, Visual SourceSafe 4.0, IIS4.0,

Oracle 8, Windows NT, Oracle Reports, Oracle Developer 2000, ODBC/ADO, and Erwin.

TECHNICAL SKILLS

Programming Web Databases & Data Application Operating Systems/

Languages Technologies Access methods Servers / Tools Networking Standards

C#.Net ASP.Net/ASP SQL Server SharePoint-MOSS Windows 95/98/NT/2K/XP

VB.Net/VB6.0 Silverlight Oracle ADFS UNIX

C/C++ Web services MS Access Team Foundation LINUX

VB6 .Net Remoting Erwin Visual Studio SOLARIS

TSQL COM/DCOM Rational Enterprise Visual Source Safe AIX

SQL/PLSQL XML/XLT ADO.NET/ADO Crystal Reports SNMP

VB Script Work Flows RDO IIS DNS

Java Script XPATH DAO MS Visio IPv4/v6

HTML Active X ODBC / JDBC MS XML Parser Ethernet LAN

DHTML Web Controls OLE DB BizTalk Server 802.11Wireless LAN

[1]

9 Wali Saddiqui

Contact this candidate