Chief Architect

Jigar Patel

** *** ******* ** ****** nh *****.

Phone. Day: 312-***-**** evening:630-***-****

• E-mail: ab2sjn@r.postjobfree.com

summary

An Enterprise Architect with 14 years of experience in Storage, System,

S erver, and Database Architecture.

Experienced in Planning, management and execution of 40 Million dollar yearly

C APEX a nd in leading team of 20+ team members. E xceptional leadership skills

Expert in Storage Architecture(EMC & Hitachi), network architecture (Cisco &

A rista), Database Architecture, System architecture (HP DL and IBM eX5),

S torage& Server Consolidation, SQL Server 2012/2008, Capacity Planning and

m anagement, Infrastructure monitoring.

Actively involved in storage industry and connected with high profile people

f rom companies like FusionIO, OCZ, Nutanix, Nimbus, Kaminario, StorSimple,

Violin memory, Pure and Tegile.

Implemented and managed more than 1 200 TB SSD Storage for High

P erformance Market Data systems since 2008 u sing FusionIO on HP and IBM

S ervers.

Expert in storage architecture & optimization techniques to reduce enterprise

d ata footprint and reduce capex and opex using innovative technologies.

Ran Innovation lab to test new technologies/products like FusionIO, OCZ,

Virident PCIe SSDs, Nimbus, XTremIO, Pure SSD Storage, HP DL 580 G7, 380 G7,

370 G6, IBM x3890 X5 / M2, x3850 X5 / M2, x3650 M3 /M2 servers, Arista Network

switches, Adaptec MaxCache.

Architected high performance networking solution for distributed dynamic

c aching and databases for Market Data applications using caching software like

S caleout,NCache and App Fabric and arista 10GigE switches using Jumbo Frames

a nd windows SNP.

Worked to get FusionIO technology certified by IBM and HP.Identified key

i ssues with IBM X3850 M2 server architecture and worked with IBM to get them

f ixed.

Excellent Vendor relationship management skills coupled with excellent

n egotiation skills. Developed close relationship with HP, IBM, FusionIO, Arista,

O CZ and several others.

Hands on Microsoft Certified DBA(MCDBA) with thorough knowledge and

e xperience in OLTP & OLAP logical and physical database modeling, architecture,

d evelopment, implementation and administration, used ERWIN, ER Studio, Sybase

p ower designer, TFS and Visio.

Experienced in build and release management using automated builds and

r elease with TFS and VSDB.

Experienced in Agile development using tools like JIRA and target process

u sing onsite and offshore resources. Unique experience of working as offshore

r esource with Infosys & Patni and as onsite off shoring manager at Thomson

R euters and Think Finance. Set up and trained offshore teams of 20+ members and

d elivered projects successfully.

Expert in High availability Disaster Recovery architecture to meet organization

RTA and RPA. Very Good with Server clustering, log shipping, Replication,

D atabase Mirroring (SQL 2012/2008) technologies.

Mastered the art of performance tuning SQL server. Used various tools like

S QL profiler & perfmon. S trong background in query optimization and query

a nalysis.

Experienced in EDM / MDM using tools like ER Studio & MS MDS, Caching

Technologies, Data ware housing, BI and ETL. E xperienced in VLDB operations

w ith databases of 2 TB size.

Familiar with S EI CMM Level 5, six sigma, lean a nd I SO 9001 q uality

s tandards.

Trainings, seminar and memberships

Active member of SearchStorage.com, SearchDataCenter.com,

S earchnetwokring.com, SearchVirtualization.com, SearchSQL.com and Storage

D ecisions conference.

Active member of SearchCIO community.

Active SQL Server PASS, Windows and SQL Server Connections member

Professional experience

Feb 2013 – Till Date GMO LLC(Grantham, Mayo, Van Otterloo) Boston MA USA

GMO, founded in 1977, is a privately held global investment management firm servicing

clients in the corporate, public, endowment, and foundation marketplaces. As of December 31,

2012, GMO managed $106 billion in client assets.

Role: Enterprise Architect

As an Enterprise Architect, I am responsible for designing and creating architecturally

sound systems which are scalable, highly available and high performance. Lead storage, network,

system and database teams to ensure architecture guidelines are followed and architecture is

aligned with strategy.

Enterprise Monitoring

Architect and implement enterprise monitoring solution using VCOPS, Hyperic, HP SIM,

VCenter and Microsoft system center 2012

Storage Architecture

Provide storage architecture for Hitachi VSP, Netapp and Flash Storage.

Working on strategy to reduce enterprise storage foot print from 4.5 PB to less than 2 PB by using

innovative technologies and Copy Data Management techniques.

Provide ways to rapidly provision lower level environment from production data with list storage

consumption.

Database Architecture

Develop and implement EDM capabilities. Evaluate and implement big data technologies.

Training team members to improve code quality and performance.

Provide sound architecture involving third party systems including Eagle PACE, Sentinel, Long

view LVTS.

APM & Workload Automation

Configure, Implement and promote use of APM tool from DynaTrace.

Evaluate, configure and implement workload automation tool to execute more than 18000 jobs.

March 2012 – Feb 2013 Think Finance Dallas/ Fort Worth, TX USA

Role : Chief Architect

As chief Architect reporting to SVP IT, my responsibilities included preparing

t echnology strategy, architecting next generation database, server, storage, network and

virtualization platforms architecture and strategy. Directly managing and leading database

team of 6 members consisting of OLTP and OLAP systems across several products

including Mobiloans, PlainGreen, PayDayOne, Greatplains and new products. Primary

areas of my work included

Strategic Planning

Member of IT Strategy committee

Identifying and refining technology requirements across enterprise.

Exploring and identifying appropriate new technologies.

Work in conjunction with other technology managers to coordinate system implementation.

Defining go to strategy for new technology initiatives in the area of Cloud, SaaS, PaaS, BigData,

Social media analytics, Security and License Cost Optimization, Virtualization & DR to name a

few.

Define strategy for enterprise wide caching, improve key business functions using Biztalk by

improving Biztalk system performance.

Database Architecture

Enterprise data modeling across OLTP and OLAP database systems using ERStudio.

Developing Enterprise Data Dictionary, setting up Domains and data lineage.

Data retention and archival architecture & implementation.

Architecting Hardware and application monitoring solutions and implementing them.

Database code versioning and automated deployment using MS TFS and Visual Studio for

multiple products/ projects.

Team building including hiring new members, mentoring and training existing team members in

SQL Server technology. Lead team of 6 members and its growing.

Highly technical and hands on with Microsoft SQL Server 2005, 2008 and 2012

Designed and architected high performance computing system for near real time Data

warehousing.

Server Architecture

Designing Server hardware specification for all enterprise server needs for Database, Web,

Virtualization needs by working with server vendors HP and IBM. Implemented HP DL 560 G8,

380 G8, HP DL 580 G7, 380 G7, 370 G6, IBM x3890 X5 / M2, x3850 X5 / M2, x3650 M3 /M2

models.

Utilizing new generation processor technologies from Intel (Nehalem & Sandy Bridge) to

architect high performance systems and reduce software licensing cost.

Network Architecture

Designing high speed networking for optimal performance using TCP IP V 6, jumbo framing and

various other low level tuning techniques including windows SNP.

Implemented 10GigE networking and designing VLANs for optimal application performance.

Storage Architecture

Designing storage subsystem for company wide application which is cost effective, high

performance, scalable and highly available.

Designed storage systems using host based PCIe SSD solutions which are highly available at a

fraction of cost as compared to SAN solutions from major vendors.

Designed Storage solutions to support tiring, inline dedupe, compression and encryption.

Evaluating new generation storage technologies like XtremIO, Nimbus, Pure Storage, and Violin.

Designed highly scalable, available Storage solutions for desktop virtualization systems based on

Nutanix.

July 2007 – March 2012 Thomson Reuters Financials Chicago, IL USA

Thomson Reuters is the world’s leading source of intelligent information for businesses and

professionals. It combines industry expertise with innovative technology to deliver critical information to

leading decision makers in the financial, legal, tax and accounting, healthcare, science and media markets,

powered by the world’s most trusted news organization.

Role : Director Database & Platform Technology

Worked as a Director Technology in Thomson Reuter’s WebQA product line. WebQA is a financial

database integration and analysis product for financial and investment firms as well as related financial

researchers. The core database is used by many internal and external applications for financial research.

WebQA product integrates data feeds from many diversified data vendors as well as ThomsonReuters internal

data feeds. Its high transaction OLTP system which gets market data updates from all the markets in world.

On average 100 million transactions per day with highest around300 million transactions per day per server.

These feeds include vendors like I/B/E/S, World scope, Compustat, Barra, Reuters, First call and DataStream.

The content set include Equities, Fixed Income & Equity Indexes, company fundamentals, Estimates, Broker

Research, Ownership, Fixed Income Pricing and much more. The product also consists of daily data ingestion

to manage the daily data update.

Key Achievement

Implemented Solid State Storage Solution at massive scale and achieved >10X performance

improvement and lowered Storage cost by more than 10 Million USD.

Saved company close to 4 Million Dollar by negotiating better pricing with vendors

FusionIO, IBM and HP.

Saved company 3 Million dollar by changing license models used for licensing SQL

Server, Windows OS and other enterprise software.

Saved company 4 million dollar by doing server consolidation and cluster consolidation.

Designed, Architected and overseen implementation of SNMP monitoring of hardware in

multiple data center for proactive hardware monitoring and reduce unplanned downtime.

Designed, Architected and overseen implementation of GMI and PAWZ monitoring across

multiple data center and infrastructure monitoring using HP Open view and IBM Tivoli.

Designed, Architected and implemented 10GigE network database and web servers.

Tested various new servers including HP DL 580 G7, 585 G7, 370 G6, 380 G7.

Received TOPS (Thomson Outstanding Performer award)

Primary areas of my work include

Design and Implementation of SSD storage solutions for Database Servers to get high

performance and replaced EMC DMX. Implemented more than 500 TB of SSD Storage in

production running since 3.5 years.

Implemented, Designed and executed 10GigE networking infrastructure for the product.

First product in ThomsonReuters to implement and use 10GigE at this scale.

Create, Plan, manage and execute CAPEX of 25 40 Million USD for my product line.

Logical and Physical Database Design for OLTP & OLAP systems, Database Architecture,

storage and network architecture.

Evaluate, Test and validate new technologies, server models and prepare organization wide

guidelines and standards for database and web servers and storage.

Pioneered usage of NAND flash based drives. Evaluated and implemented NAND flash for

first time in Production environment in company and first major client implementation for vendor.

Suggest cost saving options, consolidation strategy and streamline and optimize key

organization processes and infrastructure. Prepare technology and infrastructure roadmap.

Database development – coding procedures, function, triggers, deployment,

administration, performance monitoring & tuning

Development, design and architect the new market data feed ingestion.

Working with SQL Server 2008 R2/ 2005 running on Windows Server 2008 R2 / 2008 64

Bit Intel Nehalem based Systems with 512 GB RAM and EMC DMX/ VMax and FusionIO SSD.

Provided 24x7 365 days Database Administration and Production Support for more than 75

Servers across more than 12 environments and two product lines for close to 3 years.

Leading offshore team of 40+ developers / DBA and 6 10 full time members.

Involved with more than 100 SQL Server 2008/2005 Database servers with more than 5 TB

data on each across 15 different environments including production, DR, QA and Development for

2 product lines WEBQA and Outpost.

Design, implement and monitor Replication, Storage systems and high availability of

Servers.

Experienced in Capacity Monitoring using tools like PAWZ, Perfmon.

Experienced in Infrastructure monitoring using HP Open View, IBM Tivoli, and SNMP

Monitoring.

Experienced in High Availability and disaster recovery planning, design and

implementation.

Vendor management, price negotiation HP / IBM/ FusionIO/ Arista/ OCZ/ Nimbus /Pure /

SolidFire/Kaminario/Adaptec/XIO.

May 2007 – June 2007 Marketing Analytics Evanston, IL USA

Marketing Analytics is a recognized leader in market response modeling. Marketing Analytics helps

their clients to quantify what drives sales and help them use the results to increase market share, revenue, and

profit.

Role: Database Manager

As a Manager Database Systems, my responsibilities include designing and creating architecturally

sound web based BI systems. Optimizing existing database infrastructure and improve scalability of the

systems to support double digit growth of the organization.

May 2004 – April 2007 Ticketsnow.com Crystal Lake, IL, USA

Ticketsnow.com owned by Ticketmaster and known as Live Nation is world’s biggest online ticket

selling company. Ticketsnow.com is a high transactional (OLTP) ecommerce web site selling Tickets with

seasonal load variance.

Role : Enterprise Database Architect (October 2006 – April 2007)

As an Enterprise Database Architect my responsibilities include shaping highly efficient, highly

available, highly scalable and high performance ecommerce (OLTP) website. Identifying opportunities to

improve the organizational profitability by doing cost optimization using new technologies.

Project Work

Server consolidation – In this initiative, I lead a project to optimize the hardware allocation

by server consolidation. This was achieved by using 64 Bit Architecture, New multi core (Dual and

Quad) processors, Server Virtualization. The overall goal of the project was to reduce the number

of servers by 50% or more. The net savings expected was around 1 million dollars which includes

cost saving in hardware, support, maintenance, power and cooling, Software Licensing and other

over heads like Disaster Recovery. Usage of third party product like CiRBA or IBM NDAT for

identifying consolidation candidates.

Storage Consolidation – In this initiative, I lead a project to optimize the storage system by

better provisioning techniques like Thin provisioning or better capacity planning and forecasting.

This should help to consolidate lots of direct attached storages or on board disks to a NAS (for file

systems) or SAN (for high performance Databases) to allow easy and centralized management.

Achieving cost optimization by identifying the best combination of RAID levels, SATA or SCSI

drives and Tiered storage configuration and Fiber Channel (FC) Vs iSCSI SAN systems.

64 Bit system Architecture – In this initiative, I presented a detailed report which includes

the market study of 64 bit processors available in market for windows based system and present the

best possible options for various architectures. For ex: Itanium systems for Scale up Vs AMD

optron/ Intel Xeon systems for scale out architectures.

Enterprise Data warehousing (EDW) and BI – In this initiative I designed and implemented

EDW system to provide improved data analysis and support smart decision making based on real

data. The EDW will help organization grow to the next level by providing business critical

information from hidden data. SQL Server 2005, SQL Server Integration Services (SSIS),

Microsoft BI Stack (Pro clarity), MS Office 2007, Share Point server 2007 and SQL Server

Reporting services were used.

Role : Manager Database Systems ( May 2005 – October 2006)

As a Database Manager I lead team of DBA, Database Developers across the company.

Project work

Actively involved in development of three mission critical projects in Web, Client Server

and Data ware housing using SQL Server 2005. SQL Server 2005 deployment on HP MSA 1500

and HP EVA 6000 SAN.

T SQL Development, Database Design and Architecture in SQL Server 2005

Development of Sales Fact in Data ware house using SQL Server 2005 using SSIS for ETL

and ODS.

Actively involved in defining, designing and implementing SOA based Web Service

Architecture.

Performance monitoring and improvement of Web Services and all web sites.

Planning and designing Enterprise Database Integration with ER Studio.

Evaluating cutting edge technologies like Texas Memory Systems’ RAM SAN, Cast

IRON’s Application Route and Zazat’s Z box (In memory SQL Server Database).

As a Manager Database Systems my main responsibility include

Overall management of company’s database environment with the help of team of 7 team

members which includes 3 DBA and 4 database developers.Overall responsibilities include hiring

of team members for database. Actively involved in hiring and setting best QA team.

Driving the company’s EIBOXOFFICE Point of Sale (POS) product’s development efforts

by providing fastest, low cost and high quality data storage options using SQL Server and SQL

Server Express.

Achieving 99.99% high availability for company’s mission critical OLTP ecommerce

website backend production servers with various proactive measures. This includes proactive

system monitoring, on going performance tuning, and automated notification for critical system

events using several tools like Perfmon, sysmon, logmon, SQL Server Profiler and third party

tools.

Utilizing best available third party tools to achieve desired results. This includes piloting

various software for backup from companies like Idera, Veritas, CA, Red Gate and Quest. Used

SQL Lite Speed for fast, encrypted and compressed backup.

Managing and executing various database related tasks like Database Design, Database

programming, Deployment in several ongoing development projects.

Setting best practices and coding standards for Database team. Versioning of the database

code and change management. Ensuring the quality and performance of new and existing database

code.

Implementing HP MSA 1500 and HP EVA 6000 SAN for SQL Servers. Defining and

designing SAN, configuring RAID levels depending application nature for optimum performance.

Implementing HP Open View for Pro active monitoring of server environment.

Role : Database Architect / DBA (May 2004 – May 2005)

Hardware, Database & Application Performance tuning of SQL server 2000 clusters

running on windows server 2003 enterprise edition.

Increasing the site uptime. The company had a problem of frequent database downtime

which in turn brings the website down. Average 100K loss in revenue per hour of down time.

Performance tuning of the present environment and re architecting bad applications.

Overall environment management. Writing lot of OSQL utilities for the product support

group.

Fine tuning of the cluster disk subsystem. Setting effective backup strategy.

Providing 24X7 support for the database issues related to product and web sites.

Troubleshooting and solving the complex end user issues related to data, integrity,

transactions and product bugs in database.

Training the developers of the company in writing efficient database code.

October 2003 – April 2004 ASAP Software INC. Buffalo Grove, IL,USA

ASAP eSmart Buffalo Grove, IL, USA

ASAP Software is leading seller of license software products. ASAP esmart is a leading asset

management service offered by ASAP to the end client. As a data center DBA my responsibilities include

Role : Data Center DBA

Installation and management of SQL server 2000 clusters running on windows server 2003

enterprise edition. 24*7 customer support.

Backup and restore of databases. Database size ranges from 63 GB to 470 GB

Replication for reporting database and log shipping for warm standby server.

Performance tuning of SQL server 2000. Database auditing and security management.

Managing development, QA and production database environment.

June 2003 – August 2003 FreeMarkets INC.

FreeMarkets is NASDAQ Listed Company (FMKT) and world leader in GSM (Global Supply

Management) and e sourcing solutions. For more information click the link below.

Role: Sr. Database Architect / DBA

Platform : SQL Server 2000, Windows 2000, C#, ASP.net, XML, Sybase Power Designer, Visio

Team size: 25 Members

Nov 2002 – May 2003 Infosys Technologies Limited Bangalore, India

Infosys is World’s Second most profitable Software Company after Microsoft. Infosys Technologies

Ltd. (NASDAQ: INFY) has over 17000 employees worldwide.

Role: Sr. Database Architect

June 1998 – Nov 2002 Patni Computer Systems Limited Gandhinagar, India

Platform : SQL Server 7.0& 2000, Windows 2000, Access, VB6.0, Crystal Reports 8.0, Erwin

Role: Sr. Database Architect / SQL Server DBA

Education

YSM (Young software manager) Globsyn Tech. Limited.

First rank in University

Aptech computer education HDSE (Higher diploma in software engineering)

First rank

1994 – 1998 S.S.Engineering College, Gujarat, India

Bachelor in Engineer Instrumentation and control

Second rank in University

Professional qualification, training and seminar

MCDBA (Microsoft Certified Database Administrator)

interpersonal skills

Excellent Self-learning skills, Team Player, Exceptional leader, Tough Negotiator, Strong in

conceptualization, Ability to handle Complexities, Proactive, Assertive, Good in Time

Management, Focus on Quality, Prioritization, Customer oriented, Can work under pressure &

dedicated.

Work status

US Citizen. Authorized to work for any employer in USA.

References

Available upon request

Contact this candidate