Ola A Email & Phone Number

• Collaborate with the organization by making strategic data-related decisions by analyzing, manipulating, tracking, internally managing and reporting data.
• Analyze reporting requirements using SQL Datasets and develop various Dashboards.
• Create and utilize SQL queries to pull and create a dataset used by various departments.
• Perform tuning of Queries and Stored Procedures as well as ETL packages.
• Involved in creating new stored procedures and optimizing existing queries and stored procedures.
• Use SSIS tool to create packages to extract data from different sources, transform data and load data to data warehouse databases.

• Utilized User Defined Functions to encapsulate frequent and commonly used business logic to make the system more modular, secured, and extensible.
• Created SSIS packages to import data from Excel, XML, OLE DB Source and Flat Files.
• Designed SSIS packages to import and transform data between databases and external data sources using various transformations like Data conversion, Row counts, OLE DB Source, OLE DB Destination, Data flow task.
• Database development utilizing Microsoft SQL Server OLTP/OLAP environments using integration services (SSIS) for ETL (Extraction, Transformation, and Loading).
• Created and rendered reports in different formats like pdf, excel etc. to be executed automatically on weekly or monthly basis and managed subscriptions.
• Generated Sub-Reports, Drilldown reports, Drill through reports and Parameterized reports using SSRS.

Designed and developed data models, data warehouses, and data marts, supporting seamless data integration and storage for 5 major projects.Implemented ETL pipelines to integrate data from multiple sources, reducing data loading time by 30% and enhancing data reliability.Developed detailed reports and interactive dashboards that provided actionable insights.

Bachelor'S Degree, Human Resources Management/Personnel Administration, General

Data Modeling/Warehousing And Database Administration