Data Warehouse Developer Val

Val

Mid-level Data Warehouse Developer
6 years experience

£15 - £25/hour

Hire Val Now!
Summary

Val is an experienced professional who has 6 years of hands on expertise in SQL Server Integration Services (SSIS) with knowledge on SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS). He also has an Intermediate to advance level of expertise in MS SQL's scripts, stored procedures, views and tables. Overall, he is highly competitive in his field and has a very good attention into details that made him achieved every client's project and expectation. 

Work Experience

SQL DBA Developer
November 2016 - Present

Project

  • Design, Develop, Maintain and Deploy SSIS Packages for data warehousing
  • Crafting and executing queries upon request for data
  • Design stable, reliable and effective databases
  • Modify databases according to requests and perform tests
  • Create Tables to become source/target of the data that will be using on DataMart / Data warehouse to SSIS/SSAS/SSRS.
  • Develop/Optimize SSRS Packaged
  • Process Cube in Analysis Services.
  • Writing queries and creating tables
  • Create stored procedures, functions, views and triggers
  • Create batch Job Scheduling and integration services automation
  • Develop technical and training manuals
SQL Developer
May 2016 - November 2016

Project

  • Create Daily Analysis on Ambit Focus.
  • Create Month end Analysis on Ambit Focus.
  • Writing queries and creating tables
  • Create stored procedures, functions, views and triggers
  • Create batch Job Scheduling and integration services automation
  • Develop technical and training manuals
  • Provide data management support to users
Business Intelligence Consultant/Programmer
April 2013 - May 2016

Projects

  • Design, Develop, Maintain and Deploy SSIS Packages for data warehousing
  • Writing queries and creating tables
  • Create stored procedures, functions, views and triggers
  • Create batch Job Scheduling and integration services automation
  • Develop technical and training manuals.

High availability and disaster recovery

  • Create Metadata.
  • Crete Source and Target.
  • Select Tables that needs to be replicated.
  • Create Replication.
  • Create Technical Documentation.
  • Applications and Tools used: DBMoto(version8.0).

eDataBank BI Implementation

  • Modify databases according to requests and perform tests
  • Create stored procedures, functions, views and triggers
  • Create batch Job Scheduling and integration services automation
  • Provide data management support to users

Projects

  • Shadow Training for TM1
  • Create TM1 Cubes.
  • Crate Views.
  • Convert TM1 Cubes from TM1 version 2 to version 10.1.
  • Create Turbo Integrator for Loading of Data.
  • Applications and tools used: Tm1

 

Education

Bachelor of Science in Information Technology
2013
Bulacan State University
Previous Next
To View More Profiles, Sign Up    > Sign Up    >
×

This website uses cookies to enhance your browsing experience. By continuing to browse you are agreeing to our cookies policy.

Don't miss out!

Be up to date with the latest outsourcing and tech news and promotions!