We provide IT Staff Augmentation Services!

Database Developer /dba Resume

3.00/5 (Submit Your Rating)

Merrifield, VA

SUMMARY:

I am a seasoned Database Developer with experience in SDLC methodology and Metadata Management. Professional, Flexible, and detail - oriented. Offer a unique combination of creativity and analytical skill.

TECHNICAL SKILLS:

Programming Languages: T-SQL, Oracle SQL, SQL Server Management Studio, TOAD, SQL Developer, Visual Basic, Unix, CL/400, HTML, UNIX Shell Scripting

Databases: Oracle 11G RDMS, Microsoft SQL Server 2008, DB2, Real-Time Analytical Intelligence Database (RAID)

Tools: /Suites: SQL Server Management Studio, TOAD, SQL Developer, AccessData FTK Manager, A-PDF Extractor, MS Visual Studio, Oracle Warehouse Builder, IBM Navigator, Core Ftp, Toad, SQL Plus, Microsoft Office Suite, Ultra-Edit, Screen Design Aid, VI Editor, Info-Sphere Data-Stage ETL tool, Subversion, WINSCP, PUTTY, Hyperion Essbase, Informatica ETL, Notepad ++.

Environment: s: SQL Server, Oracle, Windows 8, IBM iSeries DataStage, AS/400, Unix AIX Version 6

PROFESSIONAL EXPERIENCE:

Confidential, Merrifield, VA

Database Developer /DBA

Responsibilities:

  • Standardizing disparate data, such as financial information and customer/patient records into a usable format to be used by Intelligence Analysts.
  • Extract, Tranfrom and Load (ETL) unstructured data from various data sources. These sources include but not limited to PDF, TIFF, JPG, and scanned files
  • Identify database files from external hard drives and extract these files to be used in the ETL process
  • Manage computer software and equipment when traveling with Intelligence Analysts to field offices.
  • Monitor Real-Time Analytical Intelligence Database (RAID) database and recovering data when needed.

Confidential, Reston, VA

Hyperion Essbase Developer

Responsibilities:

  • Analyze, manage, develop and maintain multi-dimensional cubes using Hyperion Essbase cubes
  • Program Calc Scripts, outline design/optimization, Load Rules, database design/optimization, SQL, ASO, MDX, report scripts, and shared services.
  • Manage data in Essbase and conduct data analysis

Confidential, Reston, VA

ETL Developer

Responsibilities:

  • I used Data-Stage to extract, transform and load data from various databases to a data-warehouse
  • Worked on several Finance and Forecasting ETL processes
  • Provided operations support during daily, mid-month, and end of month process runs in the production environment
  • Worked with the Business Analyst team to obtain requirements for the processes developed

Confidential, Reston, VA

Database Programmer Analyst

Responsibilities:

  • Lead programmer for modifying and maintaining the AS400 extract components of the daily, weekly, monthly archive, and periodic releases of data warehouse loads. Provided impact analysis on periodic releases and incorporated changes.
  • Developed new data warehouse ETL processes that supported new clients, service centers, and other projects. Provided thorough testing plans and conducted user acceptance testing.
  • Assisted with the implementation of an Oracle Warehouse Builder to archive incremental tables. Created, tested and implemented OWB maps and processes.
  • Supported the National Data Warehouse user base managed through Help Desk Tickets and other inquiries. Demonstrated flexibility and commitment to delivering solutions to high-profile and emergency requests.
  • Lead programmer for implementing the company’s first Federal client, Military One Source using AS400 extracts as well as Oracle Warehouse Builder.
  • Acted as backup DB2 Database administrator during periodic releases. Updated new table structures, scrubbed data and monitored the system during file releases.

Confidential, Manassas, VA

Support Services Analyst

Responsibilities:

  • Built and instituted an Access database for Help Desk Call log statistics closely tracking call types, call volume, duration and peak hours. Presented the findings to the manager and owner.
  • Kept abreast of all issues, changes, updates to ETS by monitoring the Confidential Intranet site, implementation and configuration management areas and reading the updated documentation.

Confidential, Reston, VA

Application Programmer/Analyst

Responsibilities:

  • Coded and integrated new clients into the Managed HealthCare System( Confidential ) application by developing client specific conversion programs using Cobol/400.
  • Resolved Heat Tickets assigned to the Development group related to Confidential applications.
  • Collaborated with Business Analysts to determine time and programming efforts involved in processing change requests. Created technical documentation to accommodate the requests.
  • Designed screens for Confidential and Confidential applications that improved the efficiency and processing of managed health care information by the claims department

We'd love your feedback!