Roger Delphin

**** ******** *** **********, ** **413 617-***-**** acrwid@r.postjobfree.com

PROFESSIONAL SUMMARY:

Over 3 years of database development experience with Microsoft SQL Server 2008/2012 in OLTP/OLAP/BI environments, Plus 9 years as technical and desktop IT support in an enterprise environment.

Extensive experience in Information Technology with special emphasis on design & development of Database/Data Warehousing/Client-Server/e-commerce applications.

Proficient in ETL (Extract – Transform – Load) using SQL Server Integration Services 2012(SSIS).

Highly experienced in all aspects of system development life cycle such as requirement analysis, design, development, testing, implementation, deployment and maintenance of projects.

Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.

Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services

(SSIS), and ETL package design, and RDBMS systems like SQL Server, Oracle.

Strong leader with experience training developers and advising technical groups on ETL best practices.

Expertise in OLTP/OLAP System Study, developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.

Experience in analysis, design and construction of Data warehouses and Data marts

Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.

Experience in Performance tuning of Queries and indexing to improve Performance.

Ability to code and implement complex business rules in Oracle SQL, PL/SQL, Triggers and Stored Procedures.

Team player and self-starter with excellent communication and documentation skills, ability to work independently or as part of a team and capable of picking up new skills quickly.

Design different kind of Data Models and DFD's (Data Flow Diagrams) for different kind of databases by using Erwin r9 and Visio 14.0.

TECHNICAL SKILLS:

RDBMS/DBMS: SQL Server 2012/2008, SQL Server 7.0, 8.0, 9.0, MS Access, and SQL Plus

Database Tools: SQL Server Management Studio, SQL Server Profiler, SQL Server Business Intelligence Development Studio, Visual Studio, SQL Server Enterprise Manager, T-SQL, Data Transformation Services (DTS), ODBC, OLAP, MOLAP, ROLAP,OLTP.

Data Modeling: Erwin 9.1, r9.6, Visio 14.0, 15.0

Reporting Tools: Crystal Reports, SQL Server Reporting Services, MS Excel

Programming Languages: TSQL, PL/SQL, C, C++, C#.net, Visual Basic.Net, ASP.NET, and HTML.

Operating System/Servers: Windows 8/7/ Windows Server 2012/Windows XP.

ETL Tools: Data Transformation Services (DTS), SQL Server Integration services (SSIS) PROFESSIONAL EXPERIENCE:

Movie Lakay, Pembroke Pines, FL - ETL/SSIS Consultant March 2012 – July 2015

Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.

Utilized SSIS (SQL Server Integration Services) to produce a Data Warehouse for reporting.

Involved in complete SDLC including Requirement Specifications, Analysis, Design, Development, and Testing of application.

Designed the complete Data warehouse Schema using Erwin with proper relationships defined.

Designed and developed the Staging Database and loaded from source to staging and from staging to the Destination tables applying different transformations.

Developed complex T-SQL queries and designed SSIS packages to load the data into warehouse.

Designing SSIS Packages using several transformations to perform Data profiling, Data Cleansing and Data Transformation

EDUCATION:

Keller Graduate School of Management, Miramar, FL. Masters of Information Systems Management

Currently Enrolled

REFERENCES:

Upon Request

Contact this candidate