Rudolf D Email & Phone Number

North York, Ontario, Canada

Toronto, Ontario, Canada

-Developed Complex SQL Queries, User Functions, stored procedures, CTE's, Views, Indexes, and schema/tables using SSMS 2018.-Involved in Normalization and Denormalization for faster query retrieval.-Implemented advanced SQL queries (DML and DDL) to extract large data quantities from MS SQL and Teradata SQL Assistant.-Worked on live site issues to fix slow running stored procedures, triggers, etc., and provided Root cause analysis.-Experience in Data Analysis and understanding trends and patterns in data.-Extracted, Transformed, and Loaded (ETL) data from various sources to MS SQL Server using SSIS packages.-Developed SSIS packages with various transformations and error/failure handling.-Created and Configured OLAP Cubes (Star Schema and Snow Flex Schema) using SQL Server Analysis Services (SSAS).-Developed data visualizations and dashboards using Power BI and Tableau for analysis.-Designed Tableau and Power BI dashboards for visual representation of MTD sales data.-Worked on end-to-end projects in the Azure environment, including data extraction, storage, and report creation using Power BI Desktop.-Strong knowledge of SQL Server, SSIS, SSAS, and SSRS for data visualization and report development with Power BI.-Designed and created various reports in Power BI and SSRS, including drill-down, drill-through, charts, sub-reports, bar charts, line charts, and pie charts.-Developed T-SQL code, scheduled jobs, and monitored automation for SSIS and SSRS.-Implemented event handlers, error handling, and optimized query performance in SSIS packages.-Migrated on-premises BI platforms to Azure Cloud in proof of concept projects.-Developed lookup transformations, conditional splits, and data matching using SSIS.-Designed and refreshed cubes for OLAP databases and used performance monitoring tools for query optimization.-Provided 24x7 production support for report delivery.

Toronto, Ontario, Canada

-Involved in planning, defining, and designing data based on business requirements.-Worked with business analysts to gather requirements and translate them into technical specifications.-Analyzed company's business practice and product performance to determine potential growth.-Created database objects - Tables, Indexes, Views, User-defined functions, and Parameterized Stored Procedures.-Developed stored procedures, user-defined functions, views, and T-SQL scripting for complex business logic.-Optimized the database by creating clustered and non-clustered indexes, indexed views, and implementing source control and ticketing systems.-Used SQL queries to translate data into valuable information for decision-making.-Developed SSIS packages for ETL from OLTP and various sources to staging and data warehouse, utilizing SSIS transformations.-Designed SSRS reports with dynamic sorting, data sources, and subtotals.-Designed and developed Power BI reports and dashboards for marketing and customer analytics.-Collaborated with the data engineering team to integrate data from various sources and ensure data quality.-Executed extraction and conversion plans to migrate data from Access to Power BI, ensuring data integrity.-Used Power Query in Power BI to transform and clean data, including removing duplicates and handling missing values-Developed complex SSIS packages with control flow and data flow elements, including error handling.-Developed SSAS cubes with multiple fact measures and hierarchies based on OLAP reporting needs.-Utilized Spark Core, Spark SQL, Spark Streaming, and other Spark libraries for big data processing.-Experience in building data pipelines and performing ETL processes using PySpark

India

-Proficient in creating various types of reports using SQL Server Reporting Services (SSRS), including drill-down, drill-through, chart, sub reports, bar charts, line charts, and pie charts.-Developed complex stored procedures for SSRS, analyzed reports, and fixed bugs in stored procedures.-Experience in using SQL Server tools like SQL Server Management Studio, SQL Server Data Tools, and SQL Server Visual Studio.-Extensively used T-SQL in constructing User Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.-Utilized DDL and DML for writing triggers, stored procedures, and data manipulation.-Used Joins, correlated and uncorrelated subqueries for complex business queries involving multiple tables & calculations from different databases.-Implemented error handling using Try-Catch Block.-Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, Excel, Flat files to SQL Server.-Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task, and Send Mail task.-Designed SSIS packages with error handling.-Analyzed and designed reports and reporting solutions according to the specifications given.-Met deadlines while meeting the reporting needs of the business users and project owners.-Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archive data files for different DBMS.-Created SSAS Tabular cubes and loaded dimensions and facts with a star schema using SQL Server Analysis Services (SSAS).-Designed SSAS Cubes storage and partitions, Aggregations, and developed reports using MDX and SQL.-Utilized SQL Server Reporting Services (SSRS) to deliver enterprise, Web-enabled reporting that draws content from various data sources.-Created Ad Hoc and Parameterized Reports using SQL Server Reporting services.

India

-The ability to understand and evaluate disparate data sets.-Perform ad-hoc analyses and assist in data collection and data aggregation.-Assist in reporting on media campaigns, channels and customer segments’ performance.-Provide support in identifying trends and making optimization recommendations.-Work with ad ops team to ensure that campaigns are properly tagged and tracked.-Manual dexterity (e.g., picking, pinching, typing, or other working that uses the fingers).-Programming/Statistical Analysis experience in Python, R, SAS, or SPSS.-Proficiency with SQL based query languages and relational data concepts.-Experience in Integrating SQL Server and Oracle.-Presented PowerPoint briefings and executive summaries to line of business executives.-Manage the creation, design, implementation, and support of multi-terabyte data warehouses on multiple RDBMS systems across the company.-Understanding of common visualization best-practices.-Work both independently and in a collaborative team environment.-Successful completion of a course in statistics.