Sql Programmer/analyst Resume
5.00/5 (Submit Your Rating)
San Antonio, TX
SUMMARY:
- I have an extensive technical background in data management and database development utilizing relational systems including Teradata, SQL Server, Oracle, Sybase and Access.
- Database projects were typically transaction processing systems and warehouses. Industries include Telecom, Utilities, Finance, Healthcare, Automotive and Aerospace.
- Also worked in the engineering field where my role was both project design and providing solutions for improving workflow and access to information.
TECHNICAL SKILLS:
- MS SQL Server Transact - SQL
- Oracle SQL*Plus
- PL/SQL
- Oracle Forms and Oracle Reports.
PROFESSIONAL EXPERIENCE:
Confidential, San Antonio, TX
SQL Programmer/Analyst
Responsibilities include:
- Working directly with clients on specifications and solutions.
- Development using Teradata SQL Assistant and Studio.
- Automating Reporting in Excel.
- Defining standards and processes to obtain consistent results more efficiently.
- Managing Federal Communications Commission (FCC) regulatory reporting.
Confidential, Orient, NY
Facility Configuration Specialist
Responsibilities:
- Captured the information to create process flow/plan diagrams for critical systems including the sanitary, power, decontamination, cooling, and water plants.
- On the Maintenance System (MS SQL Server 2008) developed queries, reports and entity relationship diagrams for managing facility assets.
- Organized and updated engineering drawings so that accurate information was more easily available to other employees.
- Migrated maintenance data from legacy systems to MS SQL Server.
Confidential, Hauppauge, NY
Structural Engineering
Responsibilities:
- Created detailed drawing templates to simplify setup, produce a uniform appearance and minimize errors. This cut completion times in half.
Confidential, Melville, NY
Civil Engineering/CAD Management
Responsibilities:
- Provided AutoCAD/Civil 3D management for the civil/survey groups (10-15 users).
- Created Extract-Transform-Load (ETL) systems with MS Access for updating surveys. Coded utility programs help maintain detailed drawing templates.
- Conceived the acquisition of Newforma Project Center software to manage the engineering documentation.
Confidential, Hauppauge, NY
Database Development/Administration
Responsibilities:
- Erwin was used for data modeling and entity relationship diagrams.
- SQL Report Writer for reports.
- SQL Server data warehousing projects included extracting/loading patient and claims data from healthcare insurance companies utilizing Data Transformation Services (DTS).
- Quality assurance data from monitoring stock market quote systems was managed using Oracle.
- Proficient in database administration in Oracle, MS SQL Server and Sybase.
- Remained a member and leader of the database group for 10+ years. This work ended, unfortunately, when the technical center was moved to another area.