SUMMARY

• A professional with 7+ years of experience using MS SQL Server and its suite of BI products SSIS, SSRS and SSAS.
• Highly proficient in designing database objects such as tables, indexes, functions and views.
• Knowledge on End to End system of Confidential Operations Business intelligence.
• Worked as Senior BI developer for Commercial virtue of Confidential .
• Experience in System & Data modeling, Database Design, Development, Implementation, Testing.
• Experience in developing ETL strategies using SSIS & Developing Cubes using SSAS (Both Multidimensional &Tabular).
• Experience using power BI solutions for various business reporting needs.
• Experience in installation, configuration of MS SQL Server on Windows 7, and 2008/ R2 servers.
• Extensive experience in writing Complex SQL queries, Stored Procedures, Views, and Triggers.
• Extensive experience in SQL Query Optimization, Debugging, Performance Tuning and Troubleshooting
• Good Knowledge of Data Warehouse architecture and attribute relationships between Fact and Dim tables.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views, Deploying and Processing SSAS objects.
• Experience in creating and scheduling SSIS Packages to perform Dimension and Cube Processing.
• Experience in Reporting Services for MS SQL Server and SQL Server Agent in Support Services and MDX technology of the analysis services.
• Experience in gathering Business Requirements and translating them into technical specification and creating reports with respect to business requirement.
• Designed DTS/SSIS Packages for importing and exporting data migration and conversion.
• Developed and maintained high performance code and versioning using Team Foundation Server.
• Creating Confidential Azure servers and databases using Confidential azure portal
• Creating Azure Data Factory and loading data between different sources and targets (destinations) using azure portal
• Experience in creating the data factories in azure portal from visual studio
• Excellent verbal, written communication and presentation skills, problem solving and conflict resolution skills.
• SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server OLTP Administration and development experience with Business Intelligence Development Studio (BIDS).
• SQL Server Analysis Services development, creation of cubes and processing them to maintain data consistent.
• Experience in writing MDX queries and creating mdx reports from cube
• High level of self - motivation and ability to meet project deadlines.

TECHNICAL SKILLS

Confidential SQL Server Suite: SQL Server, SSIS, SSRS, SSAS

Programming Languages: T-SQL, PL-SQL

BI Tools: MSBI, Power BI

IDE: SQL Server Management Studio, Confidential Visual Studio

Operating Systems: Windows

Version Control: VSTF, VSS

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

SQL Developer

Responsibilities:

• Working with different business users to develop vision document and Business Requirement Specifications.
• Working on DB maintenance of different applications
• Involved in creating change management plan according to the changes to project
• Developed Use Case Diagrams and workflows. Also, Developed Use cases and the Use Case Specification Document.
• Responsible for defining the scope of the project, gathering business requirements and documenting them textually.
• Creating different schemas for various types of data
• Worked with User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and also created indexes to the tables that have least updates to improve the query performance.
• Improving the database performance by creating and using both clustered and non-clustered indexes and by optimizing T-SQL statements using SQL Profiler. Using SQL Profiler to audit and analyze the events during a particular time horizon and stored in script.
• Perform unit testing of packages developed
• Performance improvement for long running job
• Proficient in implementing different transformations like Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Sort, Audit, Multicast, Merge, Merge Join, Union All, Term extraction, Aggregate, Execute SQL Task, and Execute Package Task etc. to generate underlying data for the reports
• Experience in Debugging, Error Handling and Deploying the SSIS packages
• Expert Knowledge in creating/using Variable, Expressions, Package Configurations, Logging, Break Points and Check Points
• Knowledge of performance tuning, query optimization and indexing
• Proficient in T-SQL and experience in oracle sql and pl/sql

Confidential

SQL/MSBI Developer

Responsibilities:

• Analyzing the complete ETL process from end to end
• Creating the logics for calculated columns in the tables
• Working on the stored procedures to check the performance for load process
• Loading huge data from different sources to staging database using the stored procedures already developed to analyze the performance
• Working on stored procedures which take more time to execute to improve the performance and tune the procedure
• Run the SSRS reports which take more time to generate the report and analyze the query for the improving the performance
• Deployment and testing of SSRS reports
• Deployment of cube and testing of MDX reports
• Creating Azure servers and databases for data storage using Confidential Azure portal
• Using Data Factory in azure portal for data load from different source and destinations
• Creating different tables with calculated columns in sql server databases
• Loading data from different sources to azure database using data factory created in the portal
• Creating a solution for data factories using visual studio to load the data
• Creating different pipelines for transformation of the data and load into the destination with visual studio solution

Environment: SQL Server 2012, SSIS 2012, MS Visual Studio 2010, TFS

Confidential

SQL/MSBI Developer

Responsibilities:

• Designing the database in SQL server based on the reports requirement
• Analyzing the data in DB2 server and comparing with SQL database
• Analyzing the new reports requirements and mapping with DB2 database
• Using Integration Services to transfer and review data from heterogeneous sources like Excel, CSV, flat file etc.
• Creating SSIS packages and Stored Procedures to migrate the data between source and target systems.
• Writing stored procedures to load the Dimensions and Fact tables in DWH database
• Using various SSIS data transformations like Aggregate, Sort, Multicast, Conditional Split, Derived Column etc. Using T-SQL queries, Stored Procedures to build SSIS packages.
• Developing SSRS reports on DWH and deployed to report manager
• Generating Sub-Reports, Drilldown reports, Drill through reports and parameterized reports using SSRS.
• Creating and maintaining multiple Extract, Transform, Load packages and remediation of issues found during testing - across multiple data sources.
• Creating SQL jobs and scheduling based on daily data files time.
• Handling exceptions and errors in data.
• Creating subscriptions for SSRS reports on daily basis.
• Working in post-production environment, making changes to the existing stored procedures as per the changed business requirements or needs.

Environment: SQL Server 2012, MS Visual Studio 2013

Confidential

SQL/MSBI Developer

Responsibilities:

• Analyzing the sample reports and business requirements
• Developing database based on the sample reports by reverse engineering process
• Developing logic for SLA based on the level of the calculations required
• Calculating SLA both at business level and vendor level
• Loading the data into DWH and implementing the SLA logic
• Creating Cube on DWH and deploying it using SSAS
• Creating MDX reports on the cube and deploying them to the share point site
• Developing the priority based reports and deploying
• Creating subscriptions for the deployed reports
• Developing reports with exporting directly in the required format without displaying other rendering formats.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.
• Creating Source to Target mapping documentation, low level and high level design documents depicting the source and target systems.

Environment: SQL Server 2012, MS Visual Studio 2010

Confidential

SQL/MSBI Developer

Responsibilities:

• Involved in extracting data for cleansing activity from SQL source then transformed and loaded into Data Warehouse Targets using SSIS.
• Extensively working in Data Extraction Transformation and loading from source to target system using SQL Server 2008 Integration Services
• Importing source/target tables from the respective data base by using execute package task using control flow tasks in SQL Server Integration Services.
• Documenting the source details, ETL process details of all the required PRISM database tables to design the new data structures
• Using SSIS to implement the Slowly Changing Dimensions, to maintain Historical Data in Data warehouse.
• Creating Adhoc reports, Parameterized reports, Toggle reports, Reports with Sub reports using SSRS.
• Extensively working with SSIS tool suite, designing and creating mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Multicast and Derived Column.
• Working with different methods of logging in SSIS.
• Extensively using Event Handlers and Error Handling in SSIS packages and notifying process results to various users using send email Task.
• Creating AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.
• Designing reports for the end user using SQL Server Reporting Services (SSRS) and creating multiple operational Drill-through and Drill-down, parameterized, cascaded, Matrix type reports and Charts using SSRS.
• Generating different SSRS reports at the Master Project level, Sub Project level as per the customer requirement.

Environment: SQL Server 2008R2, MS Visual Studio

Confidential

SQL/MSBI Developer

Responsibilities:

• As part of a Development team, worked mostly on Integration Services, database migration planning, performance evaluation, migration process from development to production.
• Interacting with the client directly to get the requirements and explain the project status.
• Creating Scripts to extract data from the source Oracle database.
• Creating Tables, Stored Procedures in the target SQL Server database.
• Creating SSIS package for the extraction of data from Oracle database and loading into a SQL Server database regarding the resource management.
• Using different transformations in SSIS to modify the source data from Oracle before loading into the target SQL Server tables.
• Creating ETL packages (dtsx files) to validate, extract, transform, and load data to target databases using SSIS.
• Creating Stored Procedure for the generation of data report depicting the allocated hours and actual hours for every resource and the project.
• Using Import/Export wizard to move the data between SQL Development and SQL Test databases.
• Developing stored procedure driven reports, building custom application on reports, formula writing/editing in reports, Report Administration and performance tuning of reports using SSRS.
• Various types of reports (Drill down, Matrix, and Navigating) with charts were created using SQL Reporting Services 2005 (SSRS).
• Designed different kinds of reports like Linked, cascaded and parameterized reports and Worked on Drill Down and Drill-through Reports using SSRS.
• Deploying these reports to share point site and adding filters, web parts
• Publishing the reports in the share point site

Environment: SQL Server 2008R2, MS Visual Studio

Confidential

SQL/MSBI Developer

Responsibilities:

• Involved in SSIS Package Developing.
• Responsible of data loading processes.
• Involved in Error Handling.
• Creating Parameterized Reports.
• Creating knowledgebase and matching policy.
• Applying business rules on the domains created in the knowledgebase.