SUMMARY:

• Over 8 years of MS SQL Server Development experience in Insurance, Online Banking, Finance Facilities Management, domains with expertise in MSSQLServer2005/2008R2/ 2012/2014/2016 and over
• 6 years of experience in Microsoft’s Business intelligence stack products like SSIS and SSRS and
• 2 years of experience in Power BI Service and Tableau Server.
• Highly proficient in the use of T - SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions, Relational Database models and Data integrity, and SQL joins.
• Expert in TSQL-DDL/DML/DCL, perform most of the SQL Server Management Studio functionality using T-SQL Scripts.
• Strong experience on developing ER diagrams like logical and physical data models using Erwin tool, Visio and Power Builder.
• Strong Knowledge on Normalization /De-normalization database design methodology.
• Highly experienced in whole cycle of DTS/SQL server integration services Packages (SSIS) for performing Data transfers and ETL Purposes across the different servers.
• Experience in creating jobs, Alerts, SQL Mail Agent, Database Mail and scheduled SSIS Packages based on Business or Application needs.
• Integrated and transformed data from different data sources like Oracle, DB2, Excel, and Flat Files to SQL Server 2008R2 using OLE DB connection providers by creating various SSIS packages.
• Highly Proficient in creating SQL Server Reports, handling sub-reports and writing queries to perform roll-up and drill down operations in SSRS.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets.
• Used 2012, 2014, 2016 version of SSAS to develop tabular models and experience in performing tuning of tabular cubes.
• Proficient in designing Enterprise reports using SQL Server Reporting Services (SSRS) to generate drill down, drill through, parameterized, linked, matrix and charts reports in SSRS 2005/2008/2012/2014.
• Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows performance for monitoring and tuning SQL Server performance.
• Expertise in creating OLAP cubed and developing complex calculations, Aggregations, implementing dynamic security model using MDX functions in SSAS.
• Experience in Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema and Operational Data Store (ODS).
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Expert in creating the MDX cubes (Multidimensional Expression) and dimensions. (SSAS)
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
• Experience in configuring security, organizational content packs, data Gateways, refresh schedules for PowerBI service.
• Hands on Experience in development of Reports and Dashboard in Tableau.
• Hands on Experience with Power BI Desktop,Power BI Mobile and the Power BI Service.
• Experience in creating aggregates, hierarchies, charts, filters, quick filters, table calculations with Power BI.
• Ability to analyze and dissect user requirements and build Front-End BI applications according to specifications.
• Good understanding of BI semantic model and how Microsoft’s Business Intelligence stack (SSAS Cubes, SSRS, Performance Point, Power Pivot) fits into SharePoint.
• Worked on Tableau Administration tasks such as publishing workbooks, setting per missions, managing ownerships, working with Sites, providing access to the users and adding them to the specific groups and Projects, scheduling Refreshes and Subscriptions in Tableau Server.
• Hands on experience on Power View and Tableau Software for powerful and interactive platform for visual analysis and business intelligence.
• Expertise in writing performant MDX, DAX queries against cubes for SSRS datasets.
• Conversant with all phase of Software Development Life Cycle (SDLC).
• Excellent problem solving, analytical, technical, interpersonal and communication skills and an extremely diligent strong team player with an ability to take new roles.
• Experienced in using various client tools such as SSRS, PerformancePoint, PowerPivot, PowerView, PowerBI desktop and good understanding dashboard design patterns and visuals.
• Designed Data Mapping documents, DDL scripts, and Data dictionary and Meta data of the models and maintained them. Created Error and perfromance reports on SSIS Packages.
• Developed SSIS Packages for File Transfer from one location to other using FTP task.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel sources files, XML files, Live data, RSS Feedetc.) and loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Created dashboards using benchmarked data to provide an analytical snapshot of point in time data.

TECHNICAL SKILLS:

OLAP/Reporting Tools: SSAS, SSRS, MDX, Crystal Reports, Tableau 7/8.0/8.2/9.0 , Power BI

ETL Tools: SQL Server Integration Services (SSIS), SQL Server DTS.

Other Tools: Microsoft Office 2003/2007/2010 and 2013.

Data Modeling Tools: Microsoft Visio 2003/2007/2010 , Erwin and Power Builder

SQL Server Tools: SQL server Management Studio, Microsoft Visual Studio 2010,2015 (Data Tools)

Programming languages: C, C#, SQL, PL/SQL, T-SQL

Databases: MS SQL Server 2005/2008R 2/ 2012/2014/2016 , SQL Server Azure, MS Access

Data Warehousing & BI: Star Schema, Snowflake schema, Facts and Dimensions tables

Operating Systems: Windows XP/Vista/7/8 and 10; Windows 2003/2008R2/2012/2014 Servers.

PROJECT EXPERIENCE:

Confidential, Raymond, OH

SQL BI/Power BI Developer

Responsibilities:

• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Worked on development of SSIS packages for various inbound/outbound data, OLAP data architecture as well as Report functionalities in SQL Server 2014.
• Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for data extraction, data load and transformations.
• Installed and configured SQL Server 2014 in Test environment with latest service packs and migrated few databases.
• Integrated Custom Visuals based on business requirements using Power BI desktop.
• Created complex T-SQL Queries, Stored Procedures, Indexes, Functions and, Views to support efficient data storage and manipulation
• Developed physical data models and create DDL scripts to create database schema and database objects.
• Developed Dynamic packages using SSIS and Implemented Incremental Data Loading.
• Implemented Error Logging using Event Handlers and also implemented logging in SSIS Packages
• Involved in Analyzing, designing, building of OLAP cubes with SSAS 2012(R2) Identified and defined Fact relationships in SSAS.
• Developed DTS packages to copy tables, schemas, and views and to extract data from Excel and Oracle using SSIS.
• Designing the Reports as per client Requirement and created the reports using Excel file and SQL Server database.
• Designed, Managed and published various reports using SQL Server Reporting Services 2012 and PowerBI.
• Analysis the metric dashboard reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards with Power BI service.
• Published the dashboard reports to Power BI service for navigating the developed dashboards in web.
• Created Customized and interactive dashboards using multiple data sources.
• Created conditional filters and Action links to filter the data on dashboard with Power BIDesktop.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
• Created Dimensions with the cube wizard and also individually and Generated Named calculations and named queries.
• Developed customized reports using PowerBI Desktop based on the requirement.
• Created Cubes using different types of OLAP methods like Multidimensional OLAP (MOLAP), Relational OLAP (ROLAP).
• Written complex T-SQL queries and created Stored Procedures, Triggers, Function and Views to get data from multiple databases.
• Refreshing the cube to get the latest information updated and deployment of Cubes to the production server.

Environment: SQL Server 2014/2012/2008 R2, SSIS, SSRS, SSAS, Business Intelligence Development Studio (BIDS), MS Excel, Windows XP, Power BI.

Confidential, Grand Rapids, MI

Sr.SQL D eveloper

Responsibilities:

• Created new database objects like procedure, functions, packages, triggers and views using T-SQL in development production environment for SQL server.
• Deploy SSRS report in SharePoint for web based access for multiple end users.
• Developed SSIS Packages to Extract, Transforms and Load data into data warehouse database from heterogeneous database data sources.
• Expert in developing T-SQL (DDL, DML) statements, Data Integrity (constraints), Rules and Validation issues including complicated joins and cursor loops, creating indexes for fast retrieval of data, creating views, indexes, triggers, cursors, stored procedures and functions.
• Hand on experience in Business Intelligence Process for Data Integration and Migration services.
• Successfully redesigned and migrated complex applications from Access to SharePoint and SQL Server 2008 by evaluating database structures and data movements.
• Performed performance tuning and optimization of SQL queries to improve query performance and to reduce runtime.
• Created Dimensions with the cube wizard and also individually and Generated Named calculations and named queries.
• Created Cubes using different types of OLAP methods like Multidimensional OLAP (MOLAP), Relational OLAP (ROLAP).
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV files into SQL Server 2008R2.
• Good knowledge of Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modeling for FACT and Dimension Tables using Analysis Services.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region viewing data of another region using SSAS.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler and SQL Analyzer.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Created Write back functionality in SSAS to write the data back into the cube to make changes to the data those changes return back in to the cube.
• Created Star Schema for OLAP cube generation and extensively worked dimension modeling for analysis service using SSAS.
• Used Data Transformation Services(DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.

Environment: SQL Server 2012/2008R2, SQL Server Integration Services (SSIS),SQL Server Analysis Services (SSAS), Tableau, Visual Studio 2010, MS Excel, Windows XP.

Confidential, Philadelphia, PA

MSBI Developer/ SSAS Developer

Responsibilities:

• Created SQL Server Integration Services (SSIS) packages to import data from heterogeneous data sources like Oracle 9i, SQL Server Text files (CSV, XSL, and XML).
• Understanding the Erwin ER Diagrams
• Used SSIS to unite data from existing system and performed transformations on MS SQL 2012.
• Extract Transform Load(ETL) development Using SQL server 2012, SQL 2008 Integration Services(SSIS)
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2008R2 to MS SQL 20012 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Designed Cubes with Star Schema using SQL Server Analysis Services 2008 (SSAS). Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server 2012 Analysis Services (SSAS).
• Activities included the design and development of Business Intelligence processes using SSIS to load, extract, and transform data for the university Data Warehouse.
• Worked on scheduling data loading and transformations using SQL Server Integration Services (SSIS) between different maintenance systems.
• Mastered in using Sorts, Groups and Sets, Refernce lines, Bandes and Boxes in different kinds of charts with help of Tableau 7.0.
• Built Interactive dashboards using techniques like Guided analytics and visual best pratices provided by Tableau 7.0/8.0.
• Experience in Creating Users, Groups and Projects on tableau server .
• Experience in creating various views in Tableau(Tree maps, Heat Maps, Scatter plot).
• Experience in creating Filters, quick filters, table calculations, calculated measures and parameters.
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2008R2(SSAS)
• Implemented the core business process using T-SQL, Stored Procedures and Functions
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
• Performed partitioning of cubes as well as cube optimization in order to increase the performance of cubes.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Developed a Drill Down, Cross-tab, and Tabular Report using Report Server in SSRS to draw data from the Data Warehouse.
• Understanding the OLAP processing for changing and maintaining multi-dimensional data warehousing, Optimizing Dimensions, Hierarchies and adding aggregations to the OLAP Cubes.
• Scheduling the SSIS packages and Jobs
• Developed perspectives to simplify the process of browsing the cubes.
• Used Lookups Transformation to get the data from data sets
• Created SSIS Packages to migrate slowly changing dimensions

Environment: SQL Server 2008R2/2012 Enterprise Edition, Business Intelligence, SSAS, SSIS, T-SQL, MDM, SSRS, Windows Server 20012, Oracle 9i, Ms excel 2008, Microsoft Visual Studio 2008, Tableau 7.0/8.0/8.1, Tableau Server.

Confidential

SQLServer Developer

Responsibilities:

• Involved in SDLC of the project from requirements gathering from Business users to perform technical design, development and testing.
• Worked extensively in writing and debugging complex stored procedures, views, triggers and user-defined functions
• Designed the Data warehouse and done the mappings from Source to the Target tables.
• Worked extensively on SSIS packages to implement the data load strategy
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Deployed SSIS packages into various Environments (Development, Test and PROD) using Deployment Utility.
• Created SQL Server jobs and scheduled them to load data periodically using SQL server Agent.
• Identified the dimension, fact tables and designed the Data-Mart using Star schema.
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server 2008R2 Analysis Services.
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV files into SQL Server 2008R2.
• Involved in Dimensional Data Modeling and Cube partitioning in SSAS.
• Generated multi parameterized reports in MS SSRS 2008R2 allowing users the ability to make selections before executing reports; thus making them user friendly.
• Created views and Stored Procedures for generating report. Responsible for creating the reports based on the requirements using SSRS.
• Worked on several complex drilldown, parameterized reports and on reports that call sub reports using SSRS.
• Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories based on business needs.
• Optimized the queries by creating various clustered, non-clustered indexes and indexed views
• Performance Tuning of Stored Procedures and SQL queries using SQL Profiler and Index Tuning Wizard in SSIS.
• Provided daily support to the user team as well as technical team for system wide tasks including monitoring, alerting and problem resolution.
• Involved in testing, bug fixing and documenting the work for the project at each and every phase.

Environment: SQL Server 2008R2, DTS, SQL Server Management Studio, SSIS, SSRS, SQL Server Business Intelligence Development Studio(BIDS), SSDT, SQL Server Query Analyzer, ETL, Erwin, Red Gate SQL Source Control.

Confidential

SQL Server Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirement and provided documentation.
• Designed the ETL process based on the schemas (snow flake and star schema) for extraction and transformation of data from the source database and loading on to the target database.
• Supported the Capital Markets Technology Applications specifically application related pricing, hedging and securitization of Mortgages as well as applications related to income forecasting.
• Worked with team of technical staff and business managers and practitioners in the business unit to determine systems requirements and functionalities needed in large/complex development project.
• Designed ETL strategies using Visio showing Data Flow to peer developers and Lead.
• Implemented ETL using SSIS 2008 to perform Loan data flow to the system from heterogeneous sources like Excel Spreadsheet, Flat files, XML documents residing in FTP locations.
• Implemented complex business rules using multiple transformations like Conditional Split, Look up Transform, Derived Column, and Union All. Also, handled errors efficiently.
• Scheduled the SSIS packages to run as jobs on periodic basis according to the requirement using SQL Server Agent.
• Configured SSIS packages to move the same between different Environments and for optimal performance.
• Designed error tolerant SSIS packages and logged the execution details.
• Work directly with users and business partners to gather reporting requirements and provide solutions.
• Prepared documents to show the details of packages and Reports created for future .
• Prepared the reports to show ineligible loans, total loans securitized etc. on day-to-day as well as weekly/monthly purposes using SSRS 2008 and scheduled them.
• Implemented the core business process using T-SQL, Stored Procedures and Functions.
• Developed code, perform reviews to advance application upgrade, extension, or other development. Analyze application for data integrity issues.
• Ability to analyze and resolve performance issue with database code involving SSIS and MS SQLServer 2005/ 2008
• Responsibility as a Tier-3 Primary during the production support for applications as on needed basis.
• Knowledge of financial instruments such as Mortgage, bonds, MBS etc.
• Implemented Source Control using Team Foundation Server.
• Work closely with business stakeholders, business analyst, and production teams across functional units to identify business needs and discuss solution options.
• Designed and developed Complex Queries, T-SQL Stored Procedures, Triggers, Tables, Constraints, Views, and Functions in MS-SQL Server2005/ 2008
• Responsible for designing and developing a Drill Down, Cross-tab, and Tabular Report using Report Server in SSRS to draw data from the Data Warehouse. Periodically developed a Report to be used by the Senior Management utilizing SSRS.

Environment: MS SQL Server 2005/2008, SSRS, SSIS, SSAS, T-SQL, Visual Studio 2005, BIDS, Windows 2003/2008 Server.