Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Timeline
Generic

Phillip Martin

Murrieta,Ca

Summary

INTRODUCTION: Knowledgeable productive worker with exceptional innovative problem solving skills with experience as a technical leader/manager in data architecture, database warehouse design, ETL, Business Intelligence development, and GIS (ESRI) spatial databases. Excellent communication skills presenting and explaining complex issues.

PROFESSIONAL SUMMARY: Over 25 years of experience in Management, Solutions Architect, Sr. Data/Enterprise Architect including Data Modeling and Best Practices, BI/Database Developer and DBA ETL, database development/administration. Experienced in Agile, SCRUM, and Waterfall methodologies.

Experienced Systems Administrator with 15 years of expertise in design, development and maintenance of complex software and management of server infrastructures and data center operations across operating system platforms. Highly proficient in implementing enterprise solutions for business applications in broad scale, web-delivered environments. Determined to deliver best technical solutions to meet functional and business requirements. Diligent troubleshooter, with strong communication skills to interact effectively with employees and departments various IT environments. Flexible with positive work attitude focused on producing results under tight deadlines. Demonstrated understanding of the Software Development Life Cycle.

Seasoned System Administrator with 10-year background in Information Technology. Progressive experience marked by continuous contributions above and beyond requirements. Career achievements in large-scale software deployments, network buildouts and data security.

Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.

Overview

28
28
years of professional experience
1
1
Certification

Work History

Supervisor

  • Director
  • Data Architecture
  • Data Modeling
  • Azure ADF
  • Microsoft Dynamics
  • Epic data transportation
  • Designed and Developed ETL packages and jobs for data transformation
  • Responsible for Master Data Services (SQL Server)
  • Responsible for Data Governance Services (SQL Server)
  • Integration of multiple source systems feeding Data Warehouses
  • Performance tuning and troubleshooting
  • Project estimation experience (determine scope, duration, resources required prior to project start)
  • Excellent skills dealing with technical and non-technical personnel
  • Some Experienced in implementing Informatica Power Center
  • Some experience with Informatica MDM
  • Integrated mapping technologies with business intelligence on company cloud platform and services
  • Working in team-oriented, collaborative environment
  • Upgrading SQL Server from version 2000 to 2012
  • Have good experience with partitioned schemas, partitioned tables and indexes, creating File groups using SQL
  • SQL Server 2008/2012 online Indexing and Recoveries features
  • Implementing Business Intelligence tools (Tableau, PowerBi, Cognos, Salesforce)
  • Offshore coordination dealing with data collection, integration and transformation
  • Prepared Financial Statistical reports based on market trends
  • Data Migration Management
  • Implementing SQL Server security and Object permissions like maintaining Database authentication modes, creation of users, configuring permissions and assigning roles to users
  • SSRS Reporting Development 2008R2, 2012, and 2014
  • Applied strong leadership talents and problem-solving skills to maintain team efficiency and organize workflows
  • Handled customer complaints, resolved issues, and adjusted policies to meet changing needs
  • Evaluated employee performance and coached and trained to improve weak areas
  • Achieved results by working with staff to meet established targets
  • Created successful work schedules for each team member to maintain deadlines and fully staff shifts
  • Conducted routine inspections to check quality and compliance with established specifications
  • Boosted team performance by developing customer service training materials and conducting service training
  • Maintained compliance with company policies, objectives, and communication goals

Database Developer

  • Managing synchronizing data with Salesforce, and other Source systems to Data Warehouse
  • Developed Bi solutions using SSIS, SSAS, SSRS
  • Experienced in implementing Business Intelligence tools (Tableau, PowerBi, Cognos, Microstratigy)
  • Develop database utilities and automated reporting (SSRS)
  • Coded and deployed SSRS projects in Microsoft Visual Studio Premium 2012 and Report Builder 3.0
  • Created SSRS Reports with drill down, drill through, KPI, chart capabilities
  • Managed SSRS Report Sites with security
  • Experienced in setting up Direct Mail promotions
  • Experienced in marketing analytics and sales analytics
  • Create shell scripts for task automation
  • Analyze and sustain capacity and performance requirements
  • Analyze, consolidate and tune database for optimal efficiency
  • Monitor systems and platforms for availability
  • Participate in integration strategies, projects, activities and automation
  • Oversee backup, clustering, mirroring, replication and failover
  • Restore and recover corrupted databases
  • Install and test upgrades and patches
  • Implement security and encryption
  • Provide 24/7 support for critical situations
  • Evaluate and recommend new database technologies
  • Project Coordination with overseas clients, China, India
  • Projects:
  • Developed Spatial database – this database was designed with spatial objects holding geographic and geometric objects of census and postal information related to their customer database
  • This warehouse allowed front applications to auto generate vicinity maps for spatial analysis
  • Migrated MySQL database to SQL Server 2012 and Azure
  • Rewrote stored procedures from MySQL to SQL Server
  • Database Administration – implemented Red Gate Database Administration Tools set to monitor and maintain SQL Server Clustered environment.
  • Built databases and table structures for web applications
  • Modified databases to meet needs and goals determined during planning process
  • Identified issues within databases, performed troubleshooting and implemented effective solutions
  • Developed and updated databases to handle customer data
  • Designed and developed analytical data structures
  • Coordinated with project management on database development timelines
  • Authored and coded database descriptions

IT Consultant/Developer

GIS
  • Lead Consultant responsible for producing 5 year strategic plan to implement, technologies within their Public Utilities department.
  • Wireless communication accessing GIS data
  • Mapping services
  • SharePoint Integration
  • BI Development/Administration and Management
  • Designing and plan BI solutions Writing and Coding Stored Procedures
  • Complex queries using T-SQL
  • Developed, managed and deployed SSIS packages
  • Coded and deployed SSRS projects in Microsoft Visual Studio Premium 2012 and Report Builder 1.0, 2.0
  • Created SSRS Reports with drill down, drill through, KPI, chart capabilities
  • Managed SSRS Report Sites with security
  • Debugging, monitoring and troubleshooting BI solutions
  • Creating and deploying reports
  • Writing relational and multidimensional database queries
  • Configuring, deploying and maintaining database servers
  • Quality Control processes
  • Data Ownership and Interactive updates
  • Web based Public Access to community services and news using SQL SSRS, SSIS and OLAP
  • Application Development using Windows Office Automation – Irvine Co
  • Project: Report Automation Tool
  • Consulted with clients to align future software development with customer priorities
  • Offered software-related technical support through various communications ch

Lead developer, Programmer

Microsoft
  • Responsible for overseas teams, i.e. China and India for development and data ETL
  • On developing and implementing MS Office based tool that automatically generated contracts based on client type and service criteria, using, Access as rapid development platform migrating to SQL Server, SSIS,SSRS, Resource Governor Concepts, Resource Pool, Workflow Groups, Performance Monitoring, Monitoring Events, Audits and .NET architecture
  • Application Development/, -DBA
  • ESRI ArcMap, Oracle, City works
  • Implementation of Computerized Maintenance Management System – City of

Lead Consultant

GIS
  • Responsible for implementing a, based CMMS to manage city’s maintenance program for Public Utilities department
  • This involved setting up interviews with identified departments, gathering sorting and quantifying collected data, identify needed technologies and producing a detailed plan implementing these technologies
  • Technologies recommended were:
  • Database Development
  • Writing and Coding Stored Procedures
  • Complex queries using T-SQL
  • Developed, managed and deployed SSIS packages
  • Wireless communication accessing GIS data
  • Mapping services
  • Quality Control processes
  • Data Ownership and Interactive updates
  • Oracle 11g Reporting Services

Principle Programmer/Analyst-Database/Developer

Caster
  • Developed an Database application called “4Caster” for the San Diego’s 4.3 billion dollar CIP management department, using Microsoft Access as desktop application, SQL Server as Business Universe Database, SSIS, SSRS, pulling data from SAP/Oracle, Primavera Project Management System and Business Objects reporting, ArcGIS, was used in combination to produce dynamic reports that Increased Efficiency by 65%
  • BI Development/Administration and Management
  • Designing and plan BI solutions
  • Implemented GIS Solutions using ESRI ArcInfo and ArcMap
  • Writing and Coding Stored Procedures
  • Complex queries using T-SQL
  • Developed, managed and deployed SSIS packages
  • Debugging, monitoring and troubleshooting BI solutions
  • Creating and deploying reports
  • Writing relational and multidimensional database queries
  • Configuring, deploying and maintaining database servers
  • SQL Server Business Universe Database was built using Cluster Server, Replication, TLog backup and restore processes, Job, SQL Log monitoring, scheduled SQL Server Audits, Snapshots, and Rollback triggers, scheduled index tuning, security encryption, sql email trigger alerts
  • Produced a 2.5 billion dollar budget for the City’s CIP program within 6 months by automating their existing broken process, which was accomplished
  • Revamped the entire budget analysis process by automating their complicated workflows (4.3 billion dollar CIP program)
  • This application was designed to analyze and predict future costs by forecasting project construction costs
  • 4Caster interfaces with SAP, Primavera, Oracle, Microsoft Access and ArcGIS to extract key data for the financial forecast prediction process
  • 4Caster allows collaboration between project managers, analysts, and the central project controls department, giving all users graphic, tabular and spatial access to their project
  • 4Caster was also designed with security to prevent cross data corruption and tampering
  • This implementation was highly successful reduced the forecast analysis phase by 85%, increased accuracy over 200% and reduced resource requirements by 75%
  • Outputs were Excel spreadsheets, PDF, Word Documents
  • Trained users and developed technical documentation

Development/Database Developer/Project Manager

GIS Application
  • Expert in Data Conversion:
  • Developed many data conversion and transfer solutions between very complex enterprise and custom developed systems
  • (Access, Oracle, MS SQL Server), Database solutions: DTS, SSIS, SSAS, SSRS
  • The solution dealt with moving information between Smallworld, Oracle, MS Access, MS SQL Server, ArcSDE, and other relational databases and spatial environments
  • I was also successful in developing Global Data View technology to access 12 different spatial data formats within a single environment
  • Dynamic- Oscillating- Spatial repositories designed to incubate spatial data for final migration to the enterprise repository.

SDE Administrator/Data Architect

GIS
  • Developed and implemented, technologies to manage, publish city mainframe police incident information to the public and law enforcement
  • Setup and implemented Engineering Applications at WSD
  • Setup, implemented and trained users to operate specialized CADD based applications that were under-utilized for many years.

Principle Programmer Developer, Web Services

Google
01.2008

Senior CRM Administrator - PSJH Sr IT Engineer

Providence St Joseph Health, Reporting
06.2016 - Current
  • Responsible for Data Architedture, ETL, DynamicsCRM, Profisee Maestro, Cognos Report development, Best Practices
  • Responsibilities:
  • Database Architecture
  • Data Integration
  • Microsoft Dynamics Integration support
  • Develop ETL using SSIS and Stored Procedures
  • Implemented Informatica Power Center Solutions
  • Implemented Informatica MDM Solution
  • Best Practices
  • Hospital

IT Management/Database DBA/BI Developer

West coast Consulting
04.2013 - 04.2016
  • Responsible for all new development using Database Architecture Solutions, Business Intelligence Development, SQL Server 2008/2012, 2004, Spatial, I, Data Warehouses, ETL Processes
  • Responsibilities:
  • Data Warehouse Development and Architecture
  • Develop ETL using SSIS and Stored Procedures
  • Developed Managed and deployed SSRS projects
  • Responsible for Master Data Services (SQL Server)
  • Responsible for Data Governance Services (SQL Server)
  • Implemented Informatica Power Center
  • Implemented Informatica MDM

Database Architect/DBA/Developer/Project Management

EDF Renewable Energy
11.2011 - 04.2013
  • Responsible for all new development using Database Architecture Solutions, SQL Server 2008/2012, Spatia,BI, Data Warehouses, SharePoint Integration-Administrator, Linear and Relational Databases, ETL Processes
  • Responsibilities:
  • Design and document database architecture
  • Data Modeling
  • BI Development/Administration and Management
  • Designing and plan BI solutions
  • Writing and Coding Stored Procedures
  • Complex queries using T-SQL
  • Developed, managed and deployed SSIS packages
  • Debugging, monitoring and troubleshooting BI solutions
  • Coded and deployed SSRS projects in Microsoft Visual Studio Premium 2012 and Report Builder 3.0
  • Created SSRS Reports with drill down, drill through, KPI, chart capabilities
  • Managed SSRS Report Sites with security
  • Creating and deploying reports
  • Writing relational and multidimensional database queries
  • Configuring, deploying and maintaining database servers
  • Implemented Microsoft Dynamics CRM
  • Build database schema, tables, procedures and permissions
  • SharePoint Integration
  • Set up data sharing and disk partitioning
  • Develop database utilities and automated reporting
  • Create shell scripts for task automation
  • Analyze and sustain capacity and performance requirements
  • Analyze, consolidate and tune database for optimal efficiency
  • Monitor systems and platforms for availability
  • Participate in integration strategies, projects, activities and automation
  • Oversee backup, clustering, mirroring, replication and failover
  • Restore and recover corrupted databases
  • Install and test upgrades and patches
  • Implement security and encryption
  • Provide 24/7 support for critical situations
  • Evaluate and recommend new database technologies

IT Manager/Database DBA/Developer

Darnell Technical Services
08.2010 - 10.2011
  • Responsible for all new development using SQL Server, Oracle Spatial, lMS Office, .Net, ESRI
  • Responsibilities:
  • Implement Database and COT/Custom Application Solutions and strategic plans for contracted clients
  • Provide Information Technology solutions to customers, which includes data integration, data transformation, data migration, reporting services, analysis and optimization
  • Project: “GIS 5 Year Strategic Plan – City of Pomona

Sr. GIS Application Development/Database Developer/Project Manager

San Diego Data Processing Corp
03.1999 - 07.2010

Adjunct Professor

Whittier College
03.1996 - 01.1999
  • Geographic Information Systems
  • Taught Remote Sencing, 3D GIS, Mapping, Data collection and Enhancement using ESRI Arc Info

Education

Profisee Maestro Development -

Informatica Power Center

Associates Degree - Chemical Technology and Computer programming

Los Angeles Trade Technical College
Los Angeles, CA

10 Informatica IDQ 10 Oracle Training – 9/10 - undefined

San Diego State University, Whittier College
2004

Masters - Information Technology (GIS

ITT Technical Institute - Indianapolis
Indianapolis, IN
2002

8i DBA training courses - undefined

Informatica Power Center
2001

Bachelors Degree - Information Technology

ITT Technical Institute - Indianapolis
Indianapolis, IN
1996

Skills

  • TECHNICAL SUMMARY:
  • RDBS Applications: MS SQL Server 2000/2005/2008/2012/2014, Oracle Spatial, SAP, ESRI SDE Administrator, ArcGIS, Intergraph RDBS, AutoCAD, ESRI, Smallworld, ArcGIS, ArcGIS Server, AS400, Sybase, DB2, Redshift
  • Development Languages: Informatica, Profisee Maestro, ASPNET, HTMS, C#Net, Visual Basic VBA, JAVA, Microsoft Visual Studio, MDX, SQL, T-SQL, Microsoft Access VBA, NET, APL, JavaScript, Visual Basic, XML, AJAX, FLASH, Google Maps, Web services, WCF and Windows Services-Tier, Silverlight and GUI Development, Server Reporting Services, UNIX, pearl, C
  • Business Application: Visual Studio 2008/2010,2012, BI, SharePoint, Primavera, SAP, Epic, Microsoft Word, Excel, Power Point, Visio, Access, Microsoft Project, Oracle, SQL, Visual Basic, Outlook, Crystal Reports
  • Microsoft 70-511 – Windows Application Development with MS NET Framework 4, C#, VB
  • Microsoft 70-515 – Web Application Development with MS NET Framework 4, C#, VB
  • Oracle Training - Oracle7/8
  • Technical Project Management
  • Classroom Facilitation
  • Engineering abilities
  • CRM familiarity
  • Classroom activity development
  • Value Engineering Initiatives
  • Data Quality Engineering
  • Risk mitigation plans
  • Quality assurance procedures

Accomplishments

  • Achieved [Result] by introducing [Software] for [Type] tasks.
  • Achieved [Result] by completing [Task] with accuracy and efficiency.
  • Documented and resolved [Issue] which led to [Results].
  • Supervised team of [Number] staff members.
  • Achieved [Result] through effectively helping with [Task].
  • Collaborated with team of [Number] in the development of [Project name].
  • Resolved product issue through consumer testing.

Certification

Microsoft 70-433 – Database Development Microsoft 70-432 – SQL Server 2008, Implementation and Management Microsoft 70-450 – Designing, Optimizing and Maintaining a Database Administrative Solution Microsoft 70-451 – Designing database Solution and Data Access Using MS SQL Server 2008

Timeline

Senior CRM Administrator - PSJH Sr IT Engineer

Providence St Joseph Health, Reporting
06.2016 - Current

IT Management/Database DBA/BI Developer

West coast Consulting
04.2013 - 04.2016

Database Architect/DBA/Developer/Project Management

EDF Renewable Energy
11.2011 - 04.2013

IT Manager/Database DBA/Developer

Darnell Technical Services
08.2010 - 10.2011

Principle Programmer Developer, Web Services

Google
01.2008

Sr. GIS Application Development/Database Developer/Project Manager

San Diego Data Processing Corp
03.1999 - 07.2010

Adjunct Professor

Whittier College
03.1996 - 01.1999

Supervisor

Database Developer

IT Consultant/Developer

GIS

Lead developer, Programmer

Microsoft

Lead Consultant

GIS

Principle Programmer/Analyst-Database/Developer

Caster

Development/Database Developer/Project Manager

GIS Application

SDE Administrator/Data Architect

GIS

Profisee Maestro Development -

Informatica Power Center

Associates Degree - Chemical Technology and Computer programming

Los Angeles Trade Technical College

10 Informatica IDQ 10 Oracle Training – 9/10 - undefined

San Diego State University, Whittier College

Masters - Information Technology (GIS

ITT Technical Institute - Indianapolis

8i DBA training courses - undefined

Informatica Power Center

Bachelors Degree - Information Technology

ITT Technical Institute - Indianapolis

Similar Profiles

CREATE PROFILE
Phillip Martin