Sql Server Management

Manuel J. Gonzalez

********@*******.*** 703-***-****

Transforming IT Departments into Business Centric Technology Partners

Noted for creating transparent mechanisms for IT oversight and measuring IT performance with business outcomes by leveraging business operations, applications, networking, compliance and information security with strong execution and the active practice of personal accountability.

Trusted Business Partner - Team Builder - Accountable for Technology Operations

IT Roadmaps, Vendor - Enterprise Architecture - Cloud Technologies - BCDR - SaaS, IaaS, PaaS, SAN - NAS - ERP - CRM - PMS - ITIL - COBIT - ISO - DevOps - Service Delivery - Help Desk - Data Warehousing - Big Data - SDLC - PMO - Project Management - Governance - Configuration Management - Budget Management - Vendor Management - Contract Negotiation - SOX - PCI DSS - KYC - HIPPA - BCBS 239 - CCAR - ITGC - Resilience - Security - Scalability.

Continuous Education

ISACA – Information Systems Audit and Assurance.

Orlando, FL 2015

•Covering organizational risks, risk mitigation, assurance standards, IT governance tools, techniques and frameworks to implement Information Systems audits.

Massachusetts Institute of Technology – Executive Certificate in Management and Leadership. Cambridge, MA 2010-2014

•Concentration in managing Technical Professionals and organizations, vendor management, contract negotiation, strategic costs analysis, capital allocation, project performance measurement and the integration of high performance teams.

George Washington University – Master of Science in Management Information Systems. Ashburn, VA 2004-2008

•Focused in aligning technology operations with business strategy to discover new sources of profitability by developing and managing business applications (.NET, Java, Cloud), service delivery and network engineering adhering to the PMI’s PMBOK.

The Kimball Group – Ralph Kimball, Margy Ross and Bob Becker

San Diego, CA. 2008-2010

•Dimensional Modeling in Depth - The Data Warehouse Lifecycle - The MS Data Warehouse

Oracle University – Oracle Training Center

Reston, VA. 2007-2008

•Oracle 10g Database Administrator and Developer, Hyperion BI Suite.

IBM Certified Professional Program – IBM Training Center

Raleigh, NC. 2004

•IBM DB2 Database Administrator for Unix, Linux and Windows, IBM WebSphere integration.

Microsoft Certified Professional Program – Microsoft ATCs

Mexico City, Mexico. 1994-2008

•.NET application development (VB, C#) SQL Server, IIS, SMS, Proxy Server and MS Licensing.

UNAM – Universidad Nacional Autonoma de Mexico

Mexico City, Mexico. 1990-1994

•Bachelor of Science in Computer Science and Database Technology.

Professional History Detail

Director of Information Technology for the CIM Group

September 2015 to October 2016

CIM, Los Angeles CA

Global Real Estate investments management company: 14,000 residential units, 4.2 million square feet of office space, 4.7 million square feet of retail space, 7,000 hotel rooms

OFS Capital Management, Chicago IL.

Debt financing, credit selection, due diligence and underwriting to support recapitalizations, leveraged buyouts, growth capital and corporate restructuring: over $12B since 1994.

Assisted the CIO in managing technology vendors and contractors, negotiated contracts and SLAs to support better business outcomes, higher levels of security and resilience for an annualized IT budget of $6 million.

Renegotiated information services spending that had increased at a rate of 14% yoy. Saved $3.8 M in 3rd party services, software licenses and subscription services in the first year by reducing vendor rates, license fees and successfully allocating costs to the corresponding originators. Increased value delivered by 72%. Saved $450K in annual operating expenses with consolidation of redundant services.

Managed the company’s portfolio of applications and SDLC for integrated treasury management processes, consumer and commercial credit management and property management applications for branch offices, multifamily/residential, hotels, development sites, infrastructure and commercial assets.

Managed teams of 3 to 6 agile development SMEs to deliver .NET and Java micro services based on AWS or Azure platforms for proprietary business process models - some with international application, not available commercially.

Analyzed Help Desk operations and activity using ITIL standards and escalation models to remediate highly recurring problems, reducing recurrence by 60%, saving an average of $29.7K per issue addressed and reducing escalation to tiers 2 and 3 by 66%.

Established a higher standard for hardware infrastructure management: change and configuration management, Change Advisory Boards (CAB) involving the business community steering committees.

Incorporated local and international BC/DR (Business Continuity/Disaster Recovery) plans supporting business dictated RTOs (Recovery Time Objectives) and RPOs (Recovery Point Objectives) by implementing Cloud technologies.

In collaboration with the PMO created the charter, FBC/ROI to manage the SDLC of:

•Partnerships with the General Counsel and Internal Audit teams: applications for monitoring compliance with SOX(Sarbanes Oxley Act), PCI (Payment Card Industry Data Security Standard), BCBS 239 (Basel Committee on Banking Supervision), CCAR (Comprehensive Capital Analysis and Review), KYC (Know Your Customer) and international data protection and privacy laws.

•Partnerships with the FP&A team: applications for budgeting and forecasting, quarterly reporting, valuations, cash flow analysis, capital requests used in short-medium-long term planning for asset management and decision making.

•Partnerships with the Investments team: applications for deal tracking, rent/occupancy trend analysis, community performance, new construction, custom market analytics and reporting to provide visibility to investors and lenders.

•Partnerships with the Accounting and Treasury teams: applications for integrated liquidity management, bank reconciliations, risk management, advanced accounting, account payables and account receivables. property accounting, fund accounting, job cost and construction accounting.

Managed internal and external global audits working with both internal audit and the business community to ensure all requirements were met while raising the bar control environment (ITGCs). Successfully remediated, documented, presented and passed internal and external audit requests.

•Technology Stack: Yardi Voyager, Investment Analysis, ABF, Payscan, Construction, Performance Tables, Residential and Commercial modules. Microsoft Dynamics, Sage Fixed Assets, Argus Enterprise, MRI, Entrata, RealPage, Argus, JD Edwards EnterpriseOne, MS Solomon, Visual Studio, NodeJS, Team Foundation Server, GitHub, WebStorm, ErWin, Entity, AngularJS frameworks, SQL Server, Hadoop/Hive/Sqoop, Kafka, Amazon EC2, S3, Glacier, Route 53, RDS, DynamoDB, Lambda, Elastic Beanstalk, Workiva WDesk, Secret Server, MAX Risk Intelligence, Synopsys Software Integrity Platform, Ayasdi’s CCAR stress test, Service Now, Salesforce.com, Windows, MS Office Professional, Google Docs, MSOffice 365, Palo Alto, PBX, VMware, Nimble Storage.

IT Department Manager and Financial Applications Manager for RLJ Lodging Trust

March 2008 to September 2015

RLJ Lodging Trust, Bethesda MD

3rd Largest Lodging Public REIT in the US: 130 properties – Marriott, Hilton, Hyatt, 21,000 hotel rooms

Owned all IT functions in the Trust: Applications, Infrastructure and Service Desk.

Provided financial updates to the CFO and Executive VPs on all IT initiatives: operations, process integration, procurement, capital expenditures and budget variance for high-value projects (debt service, security, compliance and disaster recovery) for an annualized IT budget of $2 million.

Immaculate track record of transparency and long term relationships by directing IT contract negotiations:

•Increased IT value delivered by 75% in 2011, 40.8% in 2012, 33.3% in 2013, 73.3% in 2014 and 75.2% in 2015.

•Reduced IT infrastructure spending by 15% yoy since 2011.

•Saved $75K in 2011, $110K in 2012, $85K in 2013, $155K in 2014 and $55K in 2015 in IT operating expenses.

Hands-on implementation of the company’s ERP with Advanced Accounting, Construction, Executive Dashboards, Budgeting and Forecasting, Investment Analysis, Performance Tables, Analytics, SSIS ETL, document workflow automation and electronic invoice processing.

Incorporated ITIL practices and Change Advisory Board (CAB) meetings and asked business users to attend to alleviate high levels of resistance around change management, system upgrades, patching and infrastructure modernization. The minutes of the meetings along with business owners sign-offs were used as SOX supporting evidence for IT changes but more importantly, they reduced the time to make decisions and gain approval from the CEO, CFO, CAO, SVP of Investments, SVP of Construction and the Audit Committee.

Built and managed the enterprise data warehouse around the company’s ERP system. The resulting multidimensional structure provides the cleansed, conformed, raw data consumed by the Company in the form of BI Analytics and dynamic cubes.

Deployed Tableau visualizations to support senior management decision making, presenting different scenarios for budgeting and forecasting and KPIs.

Actively managed the data collection and consolidation for 148 properties across the country, the data came from 16 management companies, all of them using different ERPs, accounting and reporting systems. This is a mission critical process as the consolidated product is used to prepare the company’s monthly, quarterly and annual reports (10Qs and 10Ks).

Partner with the Investments, Asset Management and Construction teams to on-board and reflag portfolios and individual properties.

Managed the implementation of the mobile strategy for project managers, asset managers and board of directors from vendor and device selection to the timely and accurate delivery of the content needed.

Integrated and managed multi-disciplinary support teams of managers, engineers (network and telecom), developers and analysts to ensure the continued efficient and effective operations of all enterprise data services and datacenter infrastructure subcontracted by RLJ.

Developed and implemented policies and procedures for ensuring the security, quality and integrity of the company’s IT assets while positioning the Company for growth and compliance with PCI DSS (Payment Card Industry Data Security Standard) and SOX Section 404 (Sarbanes-Oxley Act).

•Technology Stack: Yardi Voyager with Advance Accounting, Investment Analysis, ABF, Payscan, Construction, Performance Tables, Residential module. Microsoft Dynamics, Sage Fixed Assets, JD Edwards EnterpriseOne, MS Solomon, Cognos TM1, Tableau, Visual Studio, NodeJS, Team Foundation Server, GitHub, WebStorm, ErWin, Entity and AngularJS frameworks, SQL Server, Oracle, Hadoop/Hive/Sqoop, Kafka, Informatica, Amazon EC2, S3, Glacier, Route 53, RDS, DynamoDB, Lambda, Elastic Beanstalk, Workiva WDesk, Board VantagePoint, Salesforce.com, Windows, Mac OS, iOS, Android, MS Office Professional, E-builder, Google Docs, Palo Alto, Sonic Firewalls, Cisco Communications Manager, VMware, EMC storage, Veam Backup.

Information Architect - Lead DBA - Database Engineer for Marriott International

September 2002 to March 2008

Marriott International

Bethesda, MD

Became a cross-platform information architect and built databases for initiatives supporting Marriott.com, Marriott’s Global Reservations System (MARSHA) Marriott’s revenue management, customer loyalty, and MICROS property management systems.

Built clustered servers for high availability and resilience, backup and restore plans for disaster recovery and encryption mechanisms to secure credit card and personal information. S

Participated in creation of the Marketing Data Mart which consisted of targeted email campaigns linked directly to Increased revenue from new sales to new customers and cross-selling to existing customers. Increased average reservations per email sent.

Responsible for the encryption/tokenization of data in transit and at rest in applications and databases containing information provided by associates to the HQ on-site Marriott Health Clinic, in compliance with the Health Insurance Portability and Accountability Act (HIPPA).

Worked in the development of the Mobile Check-in, lobby check-in kiosks and the eFolio services. Marriott customers are able to check in from a wireless device like a smartphone, tablet or wearable device.

•Technology Stack: MS SQL Server, SSRS, SSIS, SSAS, Oracle 10G, Transaction Processing Facility (TPF), HP-UX and IBM AS400, Netezza, IBM Cognos, Informatica Power Center, IBM DB2 for LUW, IBM Websphere, ERwin, Java, IBM, MS .NET.

Consultant - MS SQL Server DBA and ETL specialist for NDOR.

May 2002 to August 2002

Nebraska Department of Roads

Lincoln, NE

Trained the State appointed DBA in best practices to build, configuration, manage and monitor a clustered SQL Server environment containing the Nebraska’s Accident Record System (ARS), a large database containing all accidents reported in Nebraska roads: layered map imagery, pictures taken as evidence, tickets issued, State police reports and personal records were combined to be consumed by insurance companies and interested legal parties.

Enabled appropriate recovery mechanisms and backup and restore strategies for individual databases and instances.

Documented the procedures as a series of step-by-step documents.

Consultant - MS SQL Server DBA and report developer for IndyMac Bank.

Feb 2002 to May 2002

IndyMac Bank

Pasadena, CA

Developed SQL Server stored procedures supporting KPI Dashboards and financial reports.

Analyzed performance throughput for big queries to enhance response time from the server side.

Developed HTML single page applications for loan officers.

Consultant - SQL Server Team Leader for the Laxmi Group.

Oct 2000 to Nov 2001

The Laxmi Group

Huntington Beach, CA

Deployed SQL Server installations, performance tuning, backup and recovery, custom development of reports and stored procedures as well as training for Mitsubishi Motors, Heald Colleges, QuadraMed, The Comdyn Group and Sprint e-solutions all over California.

Led agile development teams ranging from 2 to 6 direct reports, all developers.Reported to the Director of Operations.

Consultant - SQL Server DBA and Team Leader for Televisa.

December 1999 to September 2000

Grupo Televisa, SA

Mexico City, Mexico

Televisa is the largest TV content producer in Latin America with a market cap of $16B and holds a stake in Univision.

Led a team of 5 indirect reports in the management of storage appliances for proprietary video and data streaming and delivered Microsoft Office and Microsoft BackOffice training.

SQL Server DBA and Team Leader for Lear Corporation.

December 1998 to December 1999

Lear Corporation

Mexico City, Mexico

Makes car interiors: dashboards, carpet, seats, door panels, etc. for all Ford, GM, Chrysler/Jeep and VW models assembled in 4 manufacturing facilities in Mexico, Puebla, Sonora and Coahuila.

Built relational Administered databases for materials and JIT supply chain adhering to ISO 9000 requirements and delivered Microsoft Office and Microsoft BackOffice training.

Financial Reports Developer for Ford Finance.

September 1997 to December 1998

Ford Motor Company, SA

Mexico City, Mexico

Created stored procedures and custom reports to show finance and leasing quarterly and annual operations.

Built parallel modeling databases to show variances between forecast and actuals.

Technical Team Lead for Microsoft BackOffice Presales and Certified Trainer

August 1996 to December 1998

Microsoft Corporation, SA

Mexico City, Mexico

Led a team of 6 indirect reports: developers, trainers and pre-sales representatives reporting to the public sector sales Director of Database Technologies.

Contact this candidate