Val
Mid-level Data Warehouse Developer
•
7 years experience
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