SUMMARY:

• I am a knowledgeable productive worker with exceptional innovative problem solving skills with over 17 years of experience in data archictecture, database warehouse design, ETL, Business Intelligence development, and GIS (ESRI) spatial databases. I have excellent communication skills presenting and explaining complex issues. The following chronological list of s demonstrates the variety and depth of projects I have undertaken to successful completion.
• Over 17 years of experience in 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.
• Managing large teams (Supervisor, Director)
• Data Architecture
• Data Modeling
• 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 a Data Warehouse
• Performance tuning and troubleshooting
• Project estimation (determine scope, duration, resources required prior to beginning a project)
• 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 a team-oriented, collaborative environment
• Installation, Configuration, Maintenance and Administration of SQL Server 2005/2008/2012.
• Upgrading SQL Server from version .
• 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
• Created automated reports and email correspondence to inbound customers
• 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

TECHNICAL SKILLS:

RDBS Applications: MS SQL Server 2000/2005/2008/2012/2014 , Oracle, SQL, Oracle Spatial, SAP, ESRI SDE Administrator, ArcGIS, Intergraph RDBS, AutoCAD, ESRI, Smallworld, ArcGIS, ArcGIS Server, AS400, Sybase, DB2,. Redshift

Development Languages: Informatica, Profisee Maestro, C#.Net, Visual Basic. VBA, JAVA, Microsoft Visual Studio, MDX, SQL, T-SQL, Microsoft Access VBA, .NET, APL, JavaScript, Visual Basic, XML, FLASH, Google Maps, Web services, WCF and Windows Services-Tier, Silverlight and GUI Development, Server Reporting Services, UNIX, pearl, C++

Business Application: Primavera, SAP, Epic, Microsoft Word, Excel, Power Point, Visio, Access, Microsoft Project, Oracle, SQL, Visual Basic, Outlook, Crystal Reports. Microsoft Word, Excel, Power Point, Visio, Microsoft Project

PROFESSIONAL EXPERIENCE:

Confidential

Sr IT Speciaist (ETL Developer)

Responsibilities:

• Develop ETL using SSIS and Stored Procedures
• Profisee Maestro MDM Development
• Implemented Informatica Power Center Solutions
• Implemented Informatica MDM Solution
• Data Modeling
• Best Practices
• Hospital Reporting

Confidential

Database DBA/BI Developer

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 Developer managing synchronizing data with Salesforce, and other Source systems to the 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
• Hospital Reporting

EDF Renewable Energy

Database Architect/DBA/Developer

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

Confidential

IT Manager/Database DBA/Developer

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

Confidential

IT Consultant/Developer

Responsibilities:

• Lead Consultant responsible for producing a 5 year strategic plan to implement GIS technologies within their Public Utilities department. This involved setting up interviews with the identified departments, gathering sorting and quantifying the collected data, identify the needed technologies and producing a detailed 5 year plan implementing these technologies. The technologies recommended were:
• 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

Confidential, Irvine Co

Principle Programmer Developer

Responsibility:

• Lead developer on developing and implementing MS Office based tool that automatically generated contracts based on client type and service criteria, using Microsoft 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

Confidential

Application Development/ Programmer-DBA

Responsibilities:

• Lead Consultant responsible for implementing a GIS based CMMS to manage the city’s maintenance program for the Public Utilities department. This involved setting up interviews with the identified departments, gathering sorting and quantifying the collected data, identify the needed technologies and producing a detailed plan implementing these technologies. The 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

Confidential, San Diego, CA

Sr. GIS Application Development/Database Developer

Responsibilities:

• 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

Confidential

Sr. GIS Application Development/Database Developer

Responsibilities:

• 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.