Van Solevilla Email & Phone Number

Clearwater, Fl, Us

Responsible for dashboard visualization, SaaS data modeling, and reporting via API integration from Salesforce, data warehouse, data lake, Snowflake and other cloud applications. Develop analytical data analysis in Looker for different internal teams with respect to revenue, sales, forecasting, stats, lead life cycle and other relevant data points to help drive improvement. Conduct continuous data verification for on-point reporting and company wide data visualization.

Clearwater, Fl, Us

Gb

• Created load procedures, functions, tables, and views in SQL• Created reports via SSRS and Tableau for reporting and data remediation purposes• Performed data profiling and data remediation for on-boarding external data• Created and maintaining SSIS other ETL tools for data loading• Performance tune new and existing load procedures via multiple coding techniques• Created and execute test scripts for small and large scale deployments• Participated in daily stand-up meetings in completing user stories and prioritizing sprint backlog• Gathered business requirements for the data-warehouse and business-intelligence reports to be used by the management• Provided comprehensive support to all end users and stakeholders through training and documentation

Gb

• Created procedures, functions, tables, and views via Oracle and SQL• Created and maintained SSIS packages and other ETL procedures for extraction, loading and transformation• Develop, optimize and support Informatica PowerCenter components to provide MDM ETL processes for data extraction, transformations and loading of data• Performance tuned existing load procedures via multiple coding techniques • Performed data sourcing and mapping from outside source system to in-house data warehouse• Trained multiple new joiners and overseas contractors on various IT processes and procedures • Interacted with internal clients to gather business requirements for various projects• Worked with multiple groups, local and overseas, with day-to-day operations and special projects• Prioritized multiple projects and document processes upon completion• Developed, coordinated, and implemented methodology and scope for multiple complex projects

• Conducted data management for various projects and developed SSIS packages for ETL procedures • Execute database deployments on all servers (Beta, Staging, and Live) • Create Public Data Sets for completed studies/projects using SQL procedures and SSIS• Create procedures, functions, views, and other objects/scripts for internal project use • Manage internal global deployments across multiple projects• Responsible for database permissions and jobs creation for daily and nightly use • Co-developed an internal Inventory Tracking application for internal use across projects• Perform multiple data quality procedures and techniques to ensure accuracy of data

Us

• Trained new hires on internal IT processes and procedures, including internal software operation• Provided functional and technical support, troubleshoot and diagnose hardware and software problems, including desktops, laptops, routers, switches, firewall, access points and remote systems• Collaborated with network team to troubleshoot company-wide problems• Maintained active directory and group policies• Created SSIS package for ETL procedures for various projects• Created stored procedures, functions, tables and views in SQL• Performed data cleansing techniques to ensure accuracy of data for various projects• Responsible for data warehousing and data management

Bachelors Of Applied Science, Information Technology

Computer Engineering Technology, Specializing In Microsoft