ETL DW Developer Resume

PROFESSIONAL SUMMARY:

Goal oriented professional with around 8+ years of experience in Information Technology.
Hands - on experience in writing Packages, Stored procedures, Functions, and Database Triggers using SQL and PL/SQL.
Proficient in all phases of System Development Life Cycle (SDLC) including Design, Analysis, Development, Testing and Implementation using Oracle 11g/10g/9i/8i.
Work in a team environment to analyze, program, implement and support computer-based solutions for existing business functions. Oracle Application Server Administrator doing upgrade and maintenance of the server/software
Expert in handling initiatives related to business intelligence software, data warehousing, master data management (MDM), business activity monitoring, application migration and consolidation, and service-oriented architecture (SOA).
Very Strong skills and clear understanding of requisites and solutions to various issues in implementation throughout the Software Development life cycle (SDLC).
Developed Web applications, using Oracle application/database architecture, PL/SQL, Mod- PL/SQL, Oracle Application Express (APEX 3.0), Oracle report server 10G, Oracle Web Services and Oracle BPEL
Experience in performance Tuning using Explain plan and hints. Experience with Query Optimization procedures using SQL Advisors.
Worked with advanced features of 9i such as external tables and merge statements.
Expertise in export and import of data, SQL*Loader, UTL File package.
Creating and managing user tables- namespaces, data types, and data dictionaries.
Designed Conversion and Interface Programs using PL/SQL procedures and packages.
Extensive experience and knowledge in Oracle Forms and Reports, SQL*PLUS, SQL*Loader, SQL Developer, PL/SQL Developer and TOAD Tools.
Analyze data quality and report the anomalies to business users using TOAD.
Extensive experience in all phases of Software Development Life Cycle (SDLC) involving requirement analysis, design, development of client/server, web based and n-tier application.
Experience in Error handling and debugging coding issues and troubleshoot production problems.
SQL Server 2012/2008/2005/2000 RDBMS database development including T-SQL programming.
ETL implementation using SQL Server Integration Services (SSIS)
Possess excellent communication and problem solving skills.
Effective in working independently and collaboratively in teams.

TECHNICAL SKILLS:

RDBMS: Oracle 10g/9i/8i, MS SQL Server 7.0, MySQL

Oracle Tools: Oracle Forms 9i/6i, Oracle reports 9i/6i, SQL *PLUS, SQL Loader Developer 2000

Programming Languages: C, C++, JavaScript, C#.net, VB.net, ASP.net, SQL, PL/SQL

Scripting Technologies: JavaScript

Operating systems: UNIX, Windows 2000, Windows XP, Windows7

Web Technologies: HTML, JavaScript, ASP.NET, XML, Schemas and Web services

Reporting Tools: Crystal Reports, SSRS

SQL Server Tools: Enterprise Manager, Profiler, SSIS, SSRS.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship