Rajesh Kumar
Datawarehouse Ssis Bi Developer @Projectx
Signup · Get unlimited contacts
WORK HISTORY
Datawarehouse Ssis Bi Developer @Projectx
Toronto, ON, CA
Coordinating with the Business Analyst for Preparing Business Requirement Document (BRD) and Technical Specifications (TS) for the requirements/ change requests. Involved in Creating New SSIS Packages (loading data from Oracle to SQL server data warehouse tables) based on the existing DTS Packages functionality. Created Parameterized reports, Cascading parameterized reports, Crosstab reports, Drill down reports & Summary reports in Power BI and Cognos. Used Azure Data Factory (ADF) to perform Incremental Loads from Azure SQL DB to Azure Synapse. CreatedSCD Type 1 and SCD type 2 stored procedures to load target Dimension and Fact Tables in the Enterprise data warehouse. CreatedFact tables, Dimension tables, and wrote stored procedures using T-SQL to load the Fact and Dimension tables. Building the Azure Data Factory Pipelines and Automating the report on daily basis and monthly basis. Responsible for Debugging the Pipelines Errors and making sure the Pipeline runs Successfully in the Production Environment. Created SQL Stored Procedures to implement SCD Type2 functionality which captures history per each batch run on ETL Control. Reviewing and ensuring the Data Integrity, Data Quality, and monitoring of all the associated ADF pipelines. Developed Power BI reports in accordance with business requirements. Use multiple data sources like SAP, SQL Server, and Oracle. Develop and test various Power BI visualizations for the dashboard and ad-hoc reporting solutions by connecting from different data sources and databases. Responsible for the design and implementation of the reports interface and used DAX queries for writing the calculations on each Power BI report. Build the Source to target mapping document based on Subject areas for the ETL Data Integration initiative. Data Extraction, Transforming, and Loading (ETL) using SSIS, BCP, Bulk Insert, DTS, and XML between SalesForce and Access to MS SQL server database.
ABOUT RAJESH KUMAR
5+Years of experience in gathering Business Requirements, designing, and implementing Business Intelligence Information & analytical solutions using MSBI (SSIS, SSAS, SSRS), Power BI, SQL Server, and Azure Databases. Database Design, Development, Data Modeling, and Implementation of business applications with RDBMS, Data Warehouse/Data marts, and ETL for both OLTP and OLAP systems. Expertise in creating complex stored Procedures, Packages, Functions, Triggers, Views, and common table expressions (CTEs) to support Middle tier, Batch reporting processes. Experience in developing complex queries, sub-queries, constraints, Collections, types, Indexed views, PL/SQL tables, User Defined Functions, and managing large volumes of data by creating Table Partitions, Cursors, Bulk collections, and Indexes. Experience with Azure Data Lake, Azure Data Factory, SQL Data Warehouse Azure Blob, and Azure Storage Explorer. Firsthand Experience in creating Datasets and Linked services as part of Azure Data Factory Pipelines Experience in transforming the data using Data Flows, and Data Bricks in Azure Data Factory. Expertise in Building Azure Data Factory Pipelines to Automate various Reporting Projects. Experience in SQL server administrative skills including backups, disaster recovery, database maintenance, user roles, authentication and authorizations, and database creation. Skillful in ETL-Extraction Transformation Loading, from heterogeneous sources (Excel, Flat file, CSV file, Access DB, DB2) by using multiple transformations provided by SSIS. Such as Data Conversion, Conditional Split, Lookup, Derived Column, Sort, merge, and union all. Has a stronghold in SQL and PLSQL programming on ORACLE and SQL Server databases with a good grounding in Database communications. Optimizing the speed of the database by tuning SQL queries, configuring the database, changing database structure, and redefining the database. Extensively worked on Table Design creating Clustered Indexes, Non-Clustered Indexes, Primary key ForeignKey Relationships, overly complex joins, and SQL Scripts for Views and Materialized Views. Highly proficient in packages to extract, transform and load data (ETL) using SSIS, designed packages for tasks and transformations Data Conversion and Pivot tables. Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer. Ability to work with SQL Server DBAs, system architects, and application developers to design stable, reliable, effective and optimized databases.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.