Developed, implemented, and optimized stored procedures and functions using T-SQL.Actively listened to customers, handled concerns quickly and escalated major issues to supervisor.Demonstrated respect, friendliness, and willingness to help wherever needed.Involved in Migrating Objects from Teradata to Snowflake.
Modeled Data warehouse using Star and Snow flex schema, created complex Store procedure, Trigger, Functions, Views, Joins, CTE, Indexes and Constraints. Carried out day-day-day duties accurately and efficiently. Oversaw database management, including upgrade, backup, recovery, and migration. Loaded data from SQL server to 3 different databases using SSRS. Connected to multiple data sources like SQL Server, Oracle, Db2, Azure SQL DW and Flat Files and transformed data in Power Query using both graphical interface and M Formula Language. Requirements gathering from the business analyst and preparing POC documents for the design & development of BI solutions (ETL/Reporting). Involved in maintaining data consistency and data integrity using various constraints like Unique, check, primary key, and default. Quickly learned new skills and applied them to daily tasks, improving efficiency and productivity. Maintained excellent attendance record, consistently arriving to work on time. Used SSIS and Azure Data Factory to create jobs for extracting, cleaning, transforming, and loading data into Data Warehouses and used SQL Server Agent jobs and Azure Trigger run to automate jobs. Experience in designing SSIS package for integrating data using OLEDB connection from heterogenous sources (excel, SQL database, CSV, flat files etc.) by using multiple transformations provided by SSIS such as Data conversion, conditional split, merge, union all etc. Developed and maintained SQL server database and Data Warehouse. Implemented row level security on data and have good understanding of application security layer models in Power BI. Created Drill-down and Drill-through reports to provide interactive representation of data for Data Analysis, Forecasting and business decisions. Created tables, views, store procedure, user defined functions, triggers, CTE, indexes, constraints, tamp table and table variables using T-SQL. Created reports using time intelligence calculations and functions. Developed Complex calculated Measure, Calculated Column and Role level security using DAX. Developed analysis reports and visualization using DAX functions like table function, aggregation function and iteration functions. Develop and implement Data Engineering Solutions and ETL processes with Azure Data Factory and SSRS. 
Scheduled Automatic refresh and scheduling refresh in power BI service.Published Power BI reports in the required organizations and made Power BI Dashboards available in Web clients and Mobile apps.Worked with a team to deliver solutions that help drive the business forward.Worked on all types of transformations that are available in Power BI query editor.Ability to have conversation with stakeholders and manage good relationship with them. Ability to adapt in a fast-paced environment in a high growth industry.Skills able to multi-task and adapt to shifting priorities, meet deadlines set in project planning and Produce quality deliverables.
Experienced in SSIS ETL Integrated data from heterogenous source to destinations performing transformation like lookup, Data Conversion, Merge Join and slowly changing dimensions.Excellent in creating Report, Dashboard, Dataset, Workspace, App, Incremental Refresh, Embed Report, Pin tiles, Power BI Gateways, Relationships and DAX.An Experienced Business Intelligence Developer, Expertise in business Intelligence applications design, development, and Maintenance of Power BI, SSIS and MS SQL Server 2016/2014/2012/2008 R2/2008.
0 kommentar(er)
