BI Developer
OSN
Total years of experience :10 years, 6 Months
• Working as BI Developer in a client facing role. Responsible for Development/Support of Business Intelligence Applications and helping the Users to get insights from the data. Working in migration of Cognos to Azure data warehouse, BI ETL/Reports Development, and Power BI development.
• Creating ETL, Reports and Dashboards using Microsoft BI Stack, Cognos, POWER BI & Dax.
• Communicate with Business users for requirement analysis & complete tasks in timely manner.
Worked as Database & BI Developer responsible for Sql Development, SSIS packages & SSRS Report Development, and Power BI development.
• Working as a Database & MSBI Developer/Administrator for the team which handles multiple applications.
• Design, develop and implement relational databases & Database Objects based on customer requirements.
• Involved in Creation and Execution of Tables, Stored Procedures, Functions, Views, Cursors, CTE’s, Indexes, Synonyms, UDD’s, and Triggers and Jobs.
• Performance Tuning of SQL Queries and Stored Procedures with the help of SQL profiler and Execution Plans. Knowledge in Index tuning.
• Creation and Deployment various types of Reports using SSRS. Scheduling, Manage subscriptions in SSRS reports.
• SQL-Server Installation, User’s Creation, Backup and Restore, Preparation of Migration Scripts, Integration of Database Objects into SVN.
• Creating and Deploying SSIS Packages based on business requirements.
• Used SSIS transformations like Derived Column, Conditional Split, Multicast, Union All, Lookup’s, sort, Slowly Changing Dimensions (SCD)
• Creation of Real-time Dash-Boards & Performs Data Analysis From various data-sources using Power -BI Desktop and Publish them into Power-BI Service.
• Manage Data-base objects Integration and Versioning.
• Performs UNIT Testing on Sql-Server Objects, SSIS packages, SSRS Reports and ensures that they are working according to the business logic.
Team Size
4
Responsibilities
Involved in Development, Support and Database Administration.
Responsibilities:
•Worked as a part of Database and Reporting team which performs data migration, Back-end development, Code Automation and Product Support.
•Worked Extensively on Microsoft SQL Server and Related Technologies.
•Involved in Creation and Execution of Tables, Stored Procedures, Functions, Views, Cursors, CTE’s, Indexes, Synonyms, UDD’s, and Triggers using T-SQL
•Creation and Deployment of SSIS Packages based on business requirements.
•Creating User Friendly reports using SSRS, Microsoft-Excel.
•Creating and Deploying SSIS Packages based on business requirements.
•Monitoring, debugging and scheduling SSIS packages
•Involved in Database maintenance, Deployment, Backup, Restore
