Senior BI consultant
Blutech consulting
Total des années d'expérience :8 years, 2 Mois
Senior BI Consultant June 2021 - Present
Developed Dashboards with different subject matter views (drill-down/dynamic, Pivot Table, Chart). Created packages to transfer data between OLTP and OLAP database using Look ups, Derived Columns, Condition Split, Execute SQL Task, Data Flow task, Execute package task, etc.
Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
Extensive use of DAX functions for the reports and for the tabular model.
Designed Dynamic row level security for entire Branch banking hierarchy with different level of user utilization using DAX function within SSAS.
Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL .
Involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems.
Involved in Analyzing and integrating the data.
Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
Developed complex programs in T SQL, writing Stored Procedures, Triggers and Queries with best execution plan.
Extensively worked on Views, cursors, CTE's, schemas, permissions and performance issues with client/server database design.
Created views to restrict access to data in a table for security. Expert in extracting data using SSIS from OLTP to OLAP. Performed Bulk data migration using DTS and SSIS from flat files.
Worked with integration services for transferring and reviewing data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data)
Developed Incremental Load using Lookup in SSDT visual studio.
Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases.
Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing.
Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
Worked-On:
Power BI, SSAS, SSRS, SSIS, SQL server .
Database development functions including converting requirements to T-SQL code, manage existing Database Platform, Unit testing, and maintenance
Writing PL/SQL packages, procedures, and functions using PL/SQL
Created dashboard using IBM Cognos.
Created the indexes on tables and partitioning the table for SQL tuning purpose
Developed complex SQL scripts, stored procedures and worked on SQL tuning.
Creating, revising and documenting database procedures and packages of each report in the design specification document for the code flow.
Involved in database testing, wrote SQL queries using SQL developer.
Created and generate complex and ad hoc reports.
Created and maintaining SSIS Package (ETL) to Extract and Transform data from, Flat File or CSV, and to load into Staging Database.
Effectively using various control flow and data flow tasks provided by SSIS such as Data Conversion, Lookup, Conditional Split, Slowly Changing Dimension, Merge and Union all.
Scheduled and maintained various daily, weekly and monthly ETL packages and jobs through SQL Server Agent in SSMS
Develop T-SQL scripts
Develop ETL processes (MS SQL Server Integration Services (SSIS) preferred)
Develop reports using SAP crystal report for Visual studio.
Writing PL/SQL packages, procedures, and functions using PL/SQL
Creating the indexes on tables and partitioning the table for SQL tuning purpose
Developing complex SQL scripts, stored procedures and worked on SQL tuning.
Design and develop reports in using MS SQL Server Reporting Services (SSRS)
Design and deploy data table structures, forms, reports, and queries
Develop, implement, and maintain change control and testing processes for modifying Databases.
Ensure all database systems meet business and performance requirements.
Implementing the data model required by the application.
FYP project on android