Marcel Martinez Email & Phone Number

Washington, Dc, Us

Washington, Dc, Us

Gathered user requirements and designed appropriate database solutions.Troubleshot system errors and performance issues.Collaborated with programmers and quality assurance testers to ensure professional deliveries.Extensively worked in Oracle SQL, PL/SQL, Query performance tuning using tools like TOAD and SQL DeveloperCreated database objects like tables, views, indexes, stored-procedures, triggers and cursors using DDL, DML statements.Wrote stored procedures for querying the data dynamically by defining parameters.

Washington Dc, Us

Researched and adapted enterprise database management systems such as SQL Server for inclusion in the enterprise GIS application software and corporate database. Developed and implemented a plan to ensure stability, efficiency, transactional consistency, efficient storage, and replication across the transactional database and publication database at the state level and the National Operations Center.Developed and implemented enterprise databases while utilizing database theory including entity relationship diagramming, object-oriented, hierarchical, relational design, and data normalization within a multi-disciplinary team. Developed standards and procedures for GIS processes including quality control, data input, map registration and geodetic control, digitizing, map editing, data storage, verification and output.Coordinated with GIS practitioners and Data Stewards within Service programs, National and State Centers as it applies to collecting, creating, organizing, and maintained spatial data while applying corporate data standards. Assessed the usefulness of pre-developed application packages and adapted them to the user environment. Also, coordinated, developed, tested, documented and revised system design procedures in support of maintenance of hardware, peripherals, network, and GIS operating systems.Developed and applied geospatial models through Model Builder and object-oriented programming languages such as Python, and C# for complex and simple resource analysis.Coordinated and provided technical assistance and training to resource personal regarding analysis, decision making, and conversion of manual processes utilizing object-oriented programming languages, as well as client/server applications to automated procedures while make use of the established and approved technologies within the context of an enterprise geospatial system and related technologies.