We provide IT Staff Augmentation Services!

Dba Resume

5.00/5 (Submit Your Rating)

New Jersey, NJ

Hire Now

PROFESSIONAL SUMMARY

Over 10+ years of experience in database application development and 4 years of experience in Data warehousing. Expert programming knowledge of stored procedures/functions/packages and triggers in SQL and PL/SQL on Unix and SQL server environments. Excellent knowledge of object oriented architectures, concepts and technologies. Expert in designing and developing complicated ETL mappings using Informatica and SSIS. Experienced in the integration of various data sources like SQL server, Oracle, DB2, Teradata, Siebel and MS Access. Detailed knowledge of human resources, claims data and purchasing system processes. Also offer strong BI analysis skills. Able to use Visual Basic 4.0,5.0,6.0 Oracle PL/SQL 9i, 10g MS SQL 2000-2005 VB.NET Cobol JCL Teradata HTML SQL*Plus Unix Shell scripting AutoSys and Crystal reports and Congnos.
Operating Systems used MS DOS Windows 95,98,NT,XP and UNIX

PROFESSIONAL EXPERIENCE

Confidential,September 2009-November 2009
Data Base Analysts /DBA


Performed maintenance and normalization of data from OLTP system. Performed BI analysis on stored data from stable data warehouse. Created custom BI analytical reports to allow users to view data in various ways using SSRS. Built and debugged SSIS packages. Created transformations to transfer data and load into thedata warehouse/data mart database schema.

Confidential,August 2008-May 2009

Applications Developer/Programmer Analyst

Analyzed information to determine, recommend and plan installation of a new system or modification of existing system. Developed production applications using Oracle PL/SQL. Performed data analysis using SQL server Query Analyzer on data warehouse data. Developed and implemented databases and ETL processes according to design and coding standards. Worked with business users and source system IT team to define, agree and document new process specifications. Designed ER diagrams, logical model (relationship, attributes, and, candidate keys) and physical database for Oracle as per business requirements using Erwin

Confidential,July 2006-March 2008
Applications Developer/Programmer Analyst
Used SQL server management studio and BI development studio to design and manager SQL server 2005 relational and multidimensional databases. Built multidimentional cubes for OLAP analytical processes and strategies. Used SSIS to transfer millions of rows of data to and from large mix data sources. Resolved performance issues to reduce data load from 6 to 2 hours.

Confidential,December 2005-January 2006
Application Developer/Programmer Analyst
Performed maintainence on various MS Access/Visual Basic/SQL 2000 applications.

Confidential,June2005-July 2006
Applications Developer/Programmer Analyst
Responsible for the coding and testing for enhancements and modifications to company applications using MS Access and SQL 2000. Took ownership of projects and supported issues that aroused form all the branches and branch office support. Communicated and troubleshot issues in a timely manner. Organized, created and managed functions/stored procedures so that turnover to DBA was flawless. Documented processes, modifications, and enhancements to programs. Gathered specifications for design, code and testing of new applications and processes.

EDUCATION

Bachelor of Science in Computer Information Systems

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship