About Me
- Total experience 4 years.
- Having around 3 years of experience in Microsoft Business Intelligence (SSIS, SSAS, SSRS) Development & Maintenance data warehouse assignments.
- Having a...
- Having around 1 year of experience in Microsoft Power BI and DAX query .
- Having around 3 years of experience in Microsoft SQL server Management Studio (SSMS).
- Designed and Developed the SSIS Packages by using different data transformations to Load data into DB tables(truncate load and incremental load).
- Having good experience in data warehouse(DW) and data mart(DM) development .
- Good Experience with Package Configurations, Error Handling.
- Involved in Package Deployment for moving package to Production Server.
- Having good experience in Package Scheduling Using SQL SERVER AGENT.
- Good experienced in Creating Cubes, Partitions, Aggregations and Usage Based Optimization in SSAS.
- Experience in creating SQL Logins, Roles as a part of security policies for various categories of users.
- Experienced in creating Jobs, Alerts, SQL Mail Agent, Database Mail and Scheduled SSIS Packages.
- Knowledge in creation of SSRS reports like Parameterized Reports, Sub-reports, Cascading report etc.
- Having around 1 years of Experience in JAVA Operational Service.
- Strong ability to understand new concepts and applications.
Skills
Data & Analytics
Database
Web Development
Programming Language
Others
Development Tools
Positions
Portfolio Projects
Company
SQL & BI Developer
Role
Data Scientist
Description
- Extract the Data from Teradata EDW system to SQL Server/Teradata staging database and Application Project view
- Creating Packages on SSIS by using different data Transformations like Derived Column, Conditional Split and Execute SQL Task in Dataflow level to load data into data warehouse.
- Scheduling Jobs to execute SSIS packages using SQL SERVER AGENT.
- Involved in Incremental loading.
- Involved in Error Handling using Event Handlers, Progress Tab & Logging.
- Implemented Breakpoints and Checkpoints.
- Involved in Cube, Dimensions & Partitions processing.
- Involved in Cube, Dimensions, Aggregations, and Partitions creation using SSAS.
- Debugging the CUBE solution for issues reported by the business.
- Managing Security (Creating users, logins and roles, granting permissions).
- Daily Log checking for errors on Production Server.
- Monitoring free space of database.
- Monitoring Database performance and optimizing performance.
- Monitoring the Performance of the servers.
- Implemented automated mailing to notify long running user queries on servers.
Company
MSBI (SSIS,SSAS,SSAS) Developer
Description
- Total experience 4 years.
- Having around 3 years of experience in Microsoft Business Intelligence (SSIS, SSAS, SSRS) Development & Maintenance data warehouse assignments.
- Having around 1 year of experience in Microsoft Power BI and DAX query .
- Having around 3 years of experience in Microsoft SQL server Management Studio (SSMS).
- Designed and Developed the SSIS Packages by using different data transformations to Load data into DB tables(truncate load and incremental load).
- Having good experience in data warehouse(DW) and data mart(DM) development .
- Good Experience with Package Configurations, Error Handling.
- Involved in Package Deployment for moving package to Production Server.
- Having good experience in Package Scheduling Using SQL SERVER AGENT.
- Good experienced in Creating Cubes, Partitions, Aggregations and Usage Based Optimization in SSAS.
- Experience in creating SQL Logins, Roles as a part of security policies for various categories of users.
- Experienced in creating Jobs, Alerts, SQL Mail Agent, Database Mail and Scheduled SSIS Packages.
- Knowledge in creation of SSRS reports like Parameterized Reports, Sub-reports, Cascading report etc.
- Having around 1 years of Experience in JAVA Operational Service.
- Strong ability to understand new concepts and applications.