SUMMARY

• Sr. DBA/Database Developer Manager with over 18 years of experience in database development/administration, software programming for industry oriented solutions, Office automation, financial solution.
• Providing database services like creating and managing DTS, SSIS, SSAS, SSRS, OLAP, data conversion and transformation, data integration across multiple database systems (Oracle, SQL Server, AS400), Cognos.
• Experienced in creating and fine tuning tables, stored procedures, indexes (clustered and non clustered), Knowledge of Win 2008 enterprise server and MS SQL server 2008.
• 10 years SQL Server Data developer/DBA
• 10 years experience Database Development Oracle
• 7 years experience MS Access, Excel Development
• 5 years SharePoint Integration
• Experienced in resolving complex technical issues.
• Experienced on MS Visual Studio (4 years)
• Data Modeling, Data Conversion, Design/Engineering, Spatial Database development.
• Consultant specializing in technology customization, training, Turn - key systems for: Information Systems, GIS, Management Systems, Project Scheduling solutions, Presentation solutions.
• Strong Leadership skills and team building
• Detailed Oriented
• Highly experienced in implementing complex solutions dealing with mixed technologies and multiple database and data storage scenarios.
• Business Process Modeling
• National Award for Outstanding as Application Development
• Application Developer
• Deep expertise with ERP software and business processes
• Strong verbal and written skills
• Expert in technical knowledge
• Strong analytical and problem solving
• Data Conversion Expert
• Expert Trainer and Technical Document development
• Experienced systems development life cycle and methodologies (BIM)
• Project management experience in Complex projects, presentations.
• Knowledge of RAID and SAN storage systems

TECHNICAL SKILLS

RDBS: Applications MS SQL Server 2000/2005/2008/2012 , Oracle Spatial, SAP, ESRI SDE Administrator, ArcGIS, Intergraph RDBS, GeoMedia Professional, AutoCAD, ESRI, Small world, ArcGIS, ArcGIS Server, AS400, Sybase, DB2,.

Development Languages: ASP.NET, HTMS, C#.Net, Visual Basic. VBA, JAVA, Microsoft Visual Studio, Microsoft Access VBA, .NET, APL, JavaScript, Visual Basic, XML, AJAX, FLASH, Google Maps,Webservices, WCF and Windows Services-Tier, Silver light and GUI Development, Server Reporting Services, UNIX, pearl, C++,.

Business Application: SharePoint, Primavera, SAP, Microsoft Word, Word Perfect, Excel, Power Point, Visio, Access, Microsoft Project, Oracle, SQL, Visual Basic, Outlook, etc.

PROFESSIONAL EXPERIENCE

Confidential

Database DBA/Developer

Responsibilities:

• 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

Database DBA/Developer

Responsibilities:

• 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

Database Architect/DBA/Developer

Responsibilities:

• Design and document database architecture. Data Modeling.
• 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:

• 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
• Quality Control processes
• Data Ownership and Interactive updates
• Web based Public Access to community services and news using SQL SSRS, SSIS and OLAP

Confidential

Principle Programmer Developer

Responsibilities:

• 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

Application Development/ Programmer-DBA

Confidential

Responsibilities:

• Lead Consultant responsible for implementing 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
• Wireless communication accessing GIS data
• Mapping services
• Quality Control processes
• Data Ownership and Interactive updates
• Oracle 11g Reporting Services

Confidential, San Diego, CA

Principle Programmer/Analyst-Database/Developer

Responsibilities:

• 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

Principle Programmer/Database Development, Analyst-Project Manager

Responsibilities:

• Developed database application called “Survey Information Management System” (SIMS) for the san Diego Survey Department.
• This application was developed in Microsoft Access polling data from SQL Server publications, Office automation programming using .NET, auto-application launching CAD, GIS and other applications based on file type.
• As Project Leader/Principle Developer to assessed the City’s Survey department’s work flow and implement a solution that would reduce administrative time and effort, increase accuracy and eliminate costly redundant efforts.
• Developed training materials and conduct training courses.
• Developed data conversion tool using C++.
• As Lead Developer/Manager and implementer of a custom application/spatial database that tracks all activity and data associated with the day to day tasks.
• This application collected and managed project creation, status, and time by crew, vender communications, deliverables, data files and report.
• The spatial database is connected to GIS where any and all information can be displayed spatially.
• Also the spatial data is connected to SPASH, San GIS, CDMS, CADD files, Orthographic images, surface model data and survey application model data.
• Developed and led the training courses.
• This solution increased efficiency by 65%, reduced redundant efforts by 40%.
• Trained users and developed technical documentation

Confidential

Principle Programmer/Analyst-Database/Developer-DBA

Responsibilities:

• Developed SQL Server Spatial database migrating data from their existing AS400 Mainframe, Oracle Enterprise Database, and other SQL Server databases for the use in analyzing crime statistics to develop criminal patterns for capturing wanted felons. The system “Regional Justice Information System” (ARJIS) is a web based incident tracking application developed for the San Diego Police Department, using SQL Server 2000, 2005 2008. SQL Server 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.
• Also implemented was Resource Governor, Creation of Resource Pools, Workload Groups, TLog backup and restore, Event Monitoring, enabled SQL Server Audit, Monitoring Job Activity and performance and tuning
• Designed and developed ArcSDE for the Public Access Crimes Website “ARJIS”
• Assessed the City’s current crimes information collection process, recommend and implement the solution.
• Developed code for data conversion using C++.Basic. VBA, JAVA, Microsoft Visual Studio, Microsoft Access VBA, .NET, ASP.NET,
• Conducted info sessions and interviews, collected, process and organized information gathered from the meetings and developed the ArcSDE data structure and database.
• This solution uploaded and QA/QC the crime data automatically and reported all anomalies to analysts for correction.
• Developed the GIS mapping categories for the ARJIS application.
• This solution had to process millions of records, organize the information and accurately upload the processed data to this critical application.
• This project was very successful saving the police department incalculable hours of research.
• This application also provided invaluable instantaneous information to the police officers resulting in many timely arrests and quick situation resolutions.
• Trained users and developed technical documentation

Confidential

Principle GIS Programmer/Analyst-Database Developer

Responsibilities:

• As project lead I developed a solution that produce a spreadsheet of sewer mains identified for replacement, develop training materials and train the users. Using Oracle, ArcEngine, ArcSDE, ASP.NET architecture, ArcMap,
• The result was the creation of “SHARQ”.
• Conducted the needs assessment, reported findings, developed prototypes and headed the development.
• Data was warehoused on a SAN storage configuration
• The application’s primary purpose was to produce a spreadsheet of sewer mains that needed repair.
• The GIS application identified sewer networks associated with a basin, selected by the downstream manhole.
• The basin mains were sorted by facility sequence number, hydraulic flows and maintenance information.
• This application managed the City’s sewer system’s maintenance and assets, provide tools for engineers to collect project specific data for the execution of their state mandated sewer system repairs and maintenance.
• SHARQ was very successful resulting in nation recognition and high praise from the City of San Diego.
• Also the City funded the web version which resulted in a substantial increase in their project planning efficiency by reducing the information gathering and analysis process by 80%.
• Developed data models for the City of San Diego’s sewer system.
• 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 Small world, 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.
• Expert in providing technical support on AutoCAD and Intergraph’s advanced applications
• Provided support on applications such as MGE, InSewer, Storm and Sanitary, GeoMedia, Iplot, IrasB and C, Micro Station, Bentley, Small world and ESRI.
• Lead development projects to integrate multiple spatial repositories such as Oracle, GIS, CAD, Microsoft Access, DBF, etc
• Technical Lead for the Geographical Information Case Test Cases
• This project required leadership in organizing analysts in evaluating and recommending solutions that will allow GeoMedia to manage spatial data for Storm and Sanitary (an Intergraph sewer design software product).
• Technical Lead Analyst on developing process/data models for the City of San Diego’s planning and Design departments.
• Developed and implemented GIS 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.
• These applications included Micro station, Inroads, Storm & Sanitary, IRasC and GeoMedia.