BI Developer Resume

SUMMARY:

Expert in Data Model, Design and implement Data Base (OLTP) in SQL Server 2005,2008,2014,2016 for 8 years
Experience in Design, Development Business Intelligence solution (SSIS, SSAS, SSRS) in SQL Server 2008,2014, 2016 for 3 years
Experience in design, implement Data Warehouse for Banking system for 5 years
Extensive experienced in T - SQL programming using DDL, DML, DCL commands, view, stored procedures, functions, triggers, curser, CTEs, Derived Tables, SQL joins and writing queries for 8 years
Experience in SQL Server DBA as installing, upgrading and configuring, build indexes for 2 years
Practical experience in design, implementing ETL Packages using DTS and SSIS in SQL Server 2014, 2016 for 3 years
Experience in Analyzing, Designing, Implementing of OLAP Cubes with SSAS 2014, 2016 and calculation of queries with MDX, DAX for 3 years
Good knowledge in Design, Deploy and Maintain SSRS 2014, 2016 reports i.e. Drill-Down, Drill-through and Dashboards for 3 years
Practical Experience in using SSDT to design and establish SSIS packages as well as SSAS, SSRS for 3 years
Good knowledge in C#.net, Asp.Net in Visual Studio 2013 for 2 years
Experience of working with Oracle Data Base 9i version and PL/SQL for 2 years
Expert in working with banking and accounting software systems for 10 years

TECHNICAL SKILLS:

Databases: MS SQL Server 2005, 2012, 2014, 2016

ETL Tools: Visual studio data tools(SSDT) 2013,2014

Languages: C#.Net, HTML, CSS, TSQL, PL/SQL, MDX

Reporting Tools: Excel, Power View, Crystal Report

Microsoft BI solution: SSIS, SSRS, SSAS

WORK EXPERIENCE:

BI Developer

Confidential

Interacted with team in designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data
Designed ETL packages using DTS with different data sources (SQL server, CSV, Flat Files, XML) and loaded the data into data destination by using SSIS
Effective analyzed, designed ER modeling for OLTP and dimension modeling for OLAP based on business requirements
Designed packages with using ETL and SSIS to load data by using Lookup, Derived Columns and Condition split
Designed and implemented slowly changing dimension (SCD) to maintain historical data in Data Warehouse with using ETL and DTS
Designed and implemented automated and scheduled SSIS package by using SQL Server agent.
Developed and deployed SSIS packages using DTS to load data from OLTP to Data Warehouse system
Developed projects using SQL server 2008/2012 SSAS, developed and designed cubes with facts, Dimensions, calculated members, and using MDX expressions for the various calculated members,, actions and KPI
Generated variety of business reports using SQL Server 2012 SSRS including drill-down, Dashboard with charts, Tabular Reports ; built reports from SSAS cube using MDX
Using Database and Data Warehouse knowledge and analytical programming skills to develop and upgrade reports by SSAS and SSRS to meet business requirements

SQL Server Developer

Confidential

Wrote Stored Procedures, Funct ions, Views and Curser to Extract, Transform and Load data from different FoxPro databases to SQL Server 2005
Created Scheduled Jobs for migration data using SQL Agent
Designed ER diagram and migrating data from FoxPro to SQL Server 2005
Generated reports using SQL Server and Excel
Created requirement documents for Release notes and test

ETL Developer

Confidential

Created new SQL Server Instance, Installation Configuration, Managing Server and Security, copy Database to another location
Interacted with team in designing and deploying cubes using Snowflake and Star Schema Designs for the operational data
Migrated data from different data sources and loaded data into target tables using DTS
Managed Logins, Users, Configured permissions and assigning roles to users
Wrote complex Queries, Views, Stored Procedures, Triggers and Functions
Performed optimization of existing SQL Queries, Indexes, Stored Procedures, Function and Views
Rebuild the Indexes for better performance
Schedule package using SQL Server jobs
Scheduled reports monthly and weekly based on employee’s requirements
Generated reports using SQL Server and Excel
Involved creating ETL process, Data Marts and OLAP technologies
Created reports, Drill-up, Drill-down, Graphs, Charts, Dashboard reports using Oracle Express and Excel

SQL Server Developer

Confidential

Installed SQL server 2000 and established connectivity with the database
Loaded data from Excel, Flat Files, FoxPro, Access, DB2 to SQL Server 2000
Created Scheduled Jobs using SQL Agent
Wrote Stored Procedures, Function, Views, Indexes and Triggers to Transform data from various sources such as DB2, FoxPro to SQL Server
Wrote Queries, Stored Procedures and Views to meet employee’s requirements
Schedule Reports based on employee’s requirements
Provided practical Excel Reports based on SQL Queries include information in the form of graphs and charts