CAREER SUMMARY:

• A data warehouse, business intelligence solutions developer, and a project manager with a proven track record of progressive management experience, team leadership, and IT technical program management skills.
• Ability to manage multiple complex projects for internal and external customers.
• An innovative and creative problem - solver with an strong work ethic, results-oriented with an aptitude for learning while maximizing resource utilization; with an ever-present sense of urgency to produce quality deliverables.
• Summarily an impassioned consultant focused on translating business objectives into leading-edge practical and efficient technical solutions that exceed business expectations.

TECHNICAL CAPABILITIES:

Languages: T-SQL; PL-SQL; PowerShell; C#; C++; HTML, XML; Visual Basic, ASP.NET, VBA, PERL, PASCAL, BASIC, JSON, Javascript, PYTHON

Application Knowledge: SQL Server 6.5- 2014, Exchange Server, BizTalk Server, ASP.net, Oracle 10G+, MySQL 5.5+, MongoDB v2.4.6+, MS Analysis Services, Integration Services & DTS (Data Transfer Services), Reporting Services, Business Objects: BOXI, Seagate Crystal Reports, Informatica PowerCenter, Proclarity, EMC Powerpath, Timefinder, SRDF, SnapView & MirrorView,BMC Control-M for Windows, PeopleTools 8-8.4, Peoplesoft HRMS 8

Operating System Knowledge: Redhat & Ubuntu Linux, Apple OSX, Windows Server and Desktop

Hardware Knowledge: HP Proliant series; Dell PowerEdge Series; HP Smart Array Cluster Storage SANs; EMC Clariion/VMAX SAN

Cloud Knowledge: Amazon EC2, RDS (MySQL), EMR, and RedShift Cloud instances,Windows Azure and SQL Azure Data Warehouse Birst

PROFESSIONAL EXPERIENCE:

Confidential, Irvine, CA

Director, Data Architecture

Responsibilities:

• Worked with business and technology solutions teams in the development and maintenance of the organization’s end to end Information Architecture by creating Information Architecture strategies and developing the associatedroad mapsand high level plans. Establish a Master Reference Data Strategy and implementationroad map.
• Designed, developed, and coordinated Enterprise Metadata and Taxonomy Strategy, including repository implementation, planning, and maintenance. Develop the standards, processes and procedures to align with the Information Architecture for the organization. Formulate the standards, processes and procedures to align with the Information Architecture for major application projects.
• Reviewed the Information and Technology Architecture design of key application projects to ensure alignment with the enterprise standards and target architecture/road map. Support various project teams in data analysis, logical and physical data models and prove guidance and mentoring to technical team. Provide leadership to create the strategy and direction for data warehousing, business intelligence and analytics for the enterprise.
• Monitored regulatory guidelines, compliance guidelines and emerging industry standards to determine their impact on information architecture.
• Oversaw the creation and evolution of architecture deliverables, including services, frameworks, templates, taxonomies, tools, standards, guidelines and best practices that support the delivery of IT solutions.
• Lead architecture reviews from a data engineering perspective.
• Provided technical design leadership to projects with the responsibility to ensure the efficient use of resources, the selection of appropriate technology
• Worked with project teams to establish standard data design building blocks, shared services, architectures and tools
• Lead efforts to improve business performance through information solutions and capabilities such as Master Data Management, Metadata management, business intelligence, etc.
• Ensured the Information Architecture balances functional, service quality, and systems management requirements.
• Assessed and evaluated risk to understand the implications of design decisions and new technologies.
• Supported various project teams in data analysis, data modeling, and information architecture related topics and provide guidance and mentoring to IT development staff in data related areas.
• Evaluated emerging trends in enterprise wide information sharing such as “big data”, and determine the impact on future state for the company.

Confidential, Aliso Viejo, CA

Program Manager, Data Warehouse

Responsibilities:

• Program Manager in the SQL Systems Data Warehouse Engineering group. Manage SQL Server Fast Track Data Warehouse reference architectures currently available on Bull, Dell, HP and IBM platforms with multiple partners including Cisco and EMC in the recent FTDW 3.0 release.

Confidential, Irvine, CA

Principal Consultant

Responsibilities:

• Built an integrated metadata environment consisting of both operational and business metadata and ensure the quality and integrity of the data for client sites.
• Optimize performance of data structures and indices.
• Performed data discovery/data profiling of client data to recommend data warehouse model.
• Designed and implemented data validation and quality processes in client ETL solutions.
• Developed processes for defining and documenting data standards and metadata models using MS Visio.

Confidential, Redmond, WA

Operations Program Manager, Analytics

Responsibilities:

• Planned Confidential MSN adCenter online advertising rollout activities, procedures, and policies for repeatable and successful execution
• Led the Confidential adCenter business continuity planning initiative to support 99.9% availability for production website operations
• Conducted release readiness reviews and established deployment go/no-go criteria for adCenter Production Operations for Confidential MSN adCenter
• Responsible for addressing and triage of production service impacting high-priority incidents and managing escalation to and engagement with the Confidential adCenter product development team and the Confidential business
• Gathered and reported on Quality of Service and KPI metrics for operations and site revenue generation performance
• Developed policies and procedures for managing consistent operations, methodologies, and standards based on Confidential Operations Framework (MOF) and IT Infrastructure Library (ITIL)

Confidential, Lake Forest, CA

Business Intelligence/Analytics Architect

Responsibilities:

• Developed architecture for company commercial mortgage management and underwriting system
• Gathered business requirements from executive management for project specs in data warehouse design
• Designed data universe for Business Objects Business Intelligence and data warehouse infrastructure
• Developed systems monitoring for Business Objects- Business Intelligence framework and SQL Server database systems for transparent and reliable systems performance

Confidential, Irvine, CA

Business Intelligence/Analytics Technical Lead

Responsibilities:

• Managed production leads database and data warehouse for online operations of Confidential
• Developed predictive analytics model for determining lead-prospect quality
• Managed code-versioning and development cycle flow from development to production
• Led engineering of processes to ensure the stability and reliability of production database systems
• Triaged and resolved database performance issues, database capacity and replication issues
• Created web analytics reporting interface and lead data processing throughput statistical reports for Sr. Mgmt

Confidential, Orange, CA

Database Engineering Manager

Responsibilities:

• Led SQL Database Upgrade/Project rollout for Peoplesoft 8.8 Upgrade (Financials and HRMS)
• Developed ETL processes using Informatica for production Loan servicing operations.
• Developed data migration procedures for Loan Servicing operations
• Ensured continuity in ETL processes for nightly scheduled data warehouse operations
• Managed 18 SQL Server 2000 cluster farms supporting 26 different applications (including Peoplesoft, Peregrine, Informatica, Empower, & others)
• Lead the standardization of job/system monitoring and maintained status across all database servers for 5 distinct operational sites for Sarbanes-Oxley (SOX) compliance
• Designed and developed ASP.net websites to report on process and job status for Loan origination systems (LOS) reporting

Confidential, Irvine, CA

Senior Database Architect

Responsibilities:

• Responsible for Production database/SQL Server availability, development, and performance tuning
• Designed and developed database schema for business process reengineering efforts for SOX compliance
• Develop custom stored procedures to facilitate mortgage lending operations (for LOS, CRM, and CMS systems)
• Develop ETL processes with DTS to enable data transfer/communication between internal/external direct marketing initiatives
• Facilitated backend database phone-lead data storage/retrieval for Confidential proprietary application server

Confidential, Orange, CA

Senior Analytics Technical Lead

Responsibilities:

• Architected enterprise data warehouse for Confidential production operations reporting to Sr. Mgmt
• Created OLAP/multi-dimensional cubes for enterprise OLAP reporting purposes with MS Analysis Services and Cognos Powerplay
• Produced custom reports using Cognos Impromptu, ASP, and ASP.NET to support Sr. Mgmt company sales and marketing analysis functions
• Responsible for 24/7 uptime of production database/SQL Server cluster and network operations center.
• Optimized transact-SQL, stored procedure code for OLTP and data warehouse processing of online site data
• Organized and managed a system for detailing issues from business users related to data warehouse reporting
• Developed/Maintained Trilegiant (Consumerinfo co-partner) credit report configuration tool in C#.NET

Confidential, Irvine, CA

Database Architect

Responsibilities:

• Managed the design, architecture, and administration of databases for company web and wireless development efforts at Go2.com
• Optimized web/wireless search processes for Go2.com website operations.
• Wrote custom class in C# to “geocode” yellow page listing address with a MapQuest.com HTTP API.
• Upgraded 16 SQL Server 7.0 servers to SQL server 2000.
• Administered SQL Server 2000 Cluster on Compaq DL760 Server running on Confidential Windows 2000 Advanced Server on a Compaq Smart Array Clustered Storage SANs.
• Developed T-SQL triggers to preserve referential integrity in rigid schema definition
• Configured SQL replication using merge replication to keep 2 site user databases synchronized for data redundancy and load-balancing of the go2online.com website
• Manage backup/disaster recovery plan for Production, QA, and Development SQL and Oracle database servers using a combination of incremental, transaction, and full backup strategies
• Lead Development of web management tools of customer data and database administration using C# and other MS .NET technologies such as web services and XML definition
• Managed and supervised a team of 6 database engineers and 2 quality assurance technicians for daily operations and maintenance of go2 production site and network operation center

Confidential, Anaheim, CA

Business Systems Analyst

Responsibilities:

• Lead migration from existing MRP system to Confidential -backed Symix system using COM, SQL Server, and Active Server Pages
• Created custom interfaces into SQL databases for company MRP system using ODBC and OLE DB access classes in Visual basic
• Implemented, configured, and trained users in MS Exchange Server 6.5 on multiple sites and provided a GroupWare environment using Visual Basic and Active server pages
• Used active server pages to develop a system for managing projects and problem reports for QA team reporting
• Designed and managed offline databases for field sales representatives allowing for remote synchronization of centralized server database