Ronel
Mid-level SQL Developer
•
6 years experience
Summary
Ronel is an experienced professional who has more than 5 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). She also has an Intermediate to advanced level of expertise in MS SQL's scripts, stored procedures, views and tables. Overall, she is highly competitive in her field and has very good attention into details that made her achieved every client's project and expectation.
Work Experience
SQL DBA Developer
November 2016 - Present
- 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
- Design, Develop, Maintain and Deploy SSIS Packages for data warehousing
- Create Tables to become source/target of the data that will be using on DataMart/Data warehouse to SSIS
- 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
- 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.
- Design, Develop, Maintain and Deploy SSIS Packages for data warehousing
- Modify databases according to requests and perform tests
- 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
- Create Metadata.
- Create Source and Target.
- Select Tables that needs to be replicated.
- Create Replication.
- Create Technical Documentation.
- Applications and Tools used: DBMoto (version8.0).
Education
Bachelor of Science in Information Technology
2013
Bulacan State University