Sql Server Data

Location:

White Plains, NY

Posted:

January 24, 2017

Contact this candidate

Resume:

Raviteja

Senior SQL/MSBI/SSAS/SSIS/SSRS Developer

PROFESSIONAL SUMMARY

Around Eight years of strong IT experience in Database Design, Development and business intelligence of Microsoft SQL Server 2014/2012/2008/2005 with various business domains like Banking, Insurance, Health care and Retail.

Working knowledge with SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).

Expertise in Data Warehouse Modelling with SQL Server Analysis Services (SSAS).

Good experience in writing MDX queries while creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2005/2008/2013

Use DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models.

Creating SSAS Cube from Scratch and involved in end to end development.

Completely Involved In Entire business.

Sound Knowledge on PowerBi Reports.

Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, and drill down reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).

Experience in Importing/Exporting Data from various heterogeneous data sources to SQL server using transformation of OLTP data to the Data Warehouse using SSIS.

Working with SQL Server Job scheduling to execute Integration Services packages and to send reports to the client.

Experienced in database Installation, configuration, maintenance, monitoring, SQL jobs.

Experienced in database backups/restoration, replication, linked server, log shipping, clustering, database mirroring.

Experience in creating SQL Logins, Roles and Authentication modes as a part of security policies for various categories of users.

Advance knowledge of Excel 2013 using PivotTables, Power Pivot, and Power View.

Experience in Performance tuning and SQL Profiler of SQL Server.

Hands on experience in execution of Parent and Child package execution.

Ability to work in-groups as well as independently with minimal supervision.

Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS

RDBMS : SQL Server 2014/2012/2008R2/2008/2005/2000/7.0, Oracle, MS Access.

SQL Server Tools : MS SQL Server 2014/2012/2008R2/2008/2005/2000/7.0, MSSQL Server Reporting

Services2014/2012/2008R2/2008/2005/2000 (SSRS), MSSQL Server Analysis

Services 2013/2008R2/20082005(SSAS), MSSQL Server Integration Services

2012/2104/2008R2/2008/2005 (SSIS), Data Transformation Services(DTS),

Oracle SQL Developer, ODBC, OLTP, OLAP, SQL Server Management studio

(SSMS), MS SQL Server 2000 Enterprise Manager, SQL Query Analyzer,

Web Services, SQL Profiler, Bulk Copy Program (BCP).

Operating Systems : Windows /XP/2000/2003/2007

Programming Language : T-SQL, C++, HTML, DAX, MDX.

Reporting Tools : Crystal Reports, SQL Reporting Services and Actuate E-Reporting, PowerPivot,

PowerBI, Cognos Reporting tool.

Development Tool : Visual Studios, TFS.

ACADEMIC QUALIFICATION

Bachelor of Engineering (B.E)

Work Experience

#Project 7:

Project

: Retail

Client

: PepsiCo

Location

Role

Duration

: White Plains, NY

: SR MSBI Consultant.

: October 2016 to till Date.

Team Size

: 12

Tool

: SSMS, SSAS, Tera Data, PowerBI.

Description:

PepsiCo is a global food and beverage company they had a vast number of outlets and having business customers worldwide. Now here in this project they want to know their retail products how their products in the market and how much sales they are doing YTD and QTD calculations etc., And also customizing their products into the each and every store with organized way.

Here we develop PowerBI reports to monitor the business. Me personally involved and developed SSAS Cube to get reports fast in PowerBI.

Roles & Responsibilities:

Creating Data bases, tables, views, indexes, Writing Stored Procedures.

Create SSAS Cube as Per the business requirement.

Involved Cube development like creating Named Queries, Dimensions, measures, calculations, partitions in measure group, dimension relations, Table mapping, Aggregations and Browsing the cube.

Worked on processing the cube as per the needed.

Created Jobs in SSIS to run the process in cube and to get data from the data source.

Involved in Some admin works like creating user access logins to particular users and providing access to the Database.

Involved in daily Stand-up Meeting like Scrum Call.

Involve din entire business by knowing the up to date business requirements from the business users and Business Analyst.

Good Interaction with client on weekly basis.

Worked on Deployment as per the needed.

Done unit Testing by writing MDX queries and re-checking the data is getting matched or not.

Created Dashboards and Stories by using Table calculations and Quick Table Calculations (Year over Year Growth, YTD Total, and YTD Growth).

Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.

Creating SSIS Packages by using different data Transformations like Derived Column, Lookup, Data Conversion, Conditional Split, Pivot, Union all and Execute SQL Task to load data into Database.

Designed Data-Mart for Prescription using Relational Model and wrote SSIS Packages to extract data from the old PDX system and load it into the new data mart of SQL Server.

Develop complex MDX, stored procedures, function table and views to generate various drill-through, drill-down reports, with dynamic grouping capability, parameterized dynamic Dashboard/Scorecard and link and pass the selected parameter values it to its sub reports using SSRS.

Lead the design, development and maintenance of custom reports using BIDS/SSDT and Report Builder.

Implemented complex business logic with case, cast, convert, CTE using T-SQL.

Extensively used Package Configurations while deploying the SSIS packages from DEV- Stage, Stage - Prod environments.

Monitoring Jobs and Investigate Failures.

Create and update SSIS Packages to pull data from source to destination database.

Migrated DTS packages from SQL Server 2012 to SQL Server 2014 as SSIS Packages.

Worked On Bug Fixing.

Involved in Deployment and Administration on SSIS packages with Business Intelligence Development Studio.

Generating drill through reports, drill down reports, parameterized reports, linked reports, Crystal reports, sub reports, table, matrix, charts in SSRS 2012.

Scheduling the jobs to send the reports.

#Project 6:

Project

: Insurance Management

Client

: FUSION.COM

Location

Role

Duration

: Richmond, VA

: SR BI Consultant.

: August 2015 to Sep 2016.

Team Size

: 4

Tool

: SSIS/SSRS/SSAS 2014, SSMS 2014, TFS, Oracle SQL Developer.

Description:

The main objective of the project is to specialize in providing the Different types of insurance in two environments,

1. Savvis: Air, Rail, Event, Lodging, Rental Car

The Savvis is a company given name and this environment main role is to provide the Quote Insurances I.e.travel. Travel includes the above insurance types.

2. Peak 10: Any Health Products, Gift cards, Travel Products send through ancilyze.

The Peak 10 is also a company given name and this environment main role is to provide a health insurance.

Achievements:

Completed PPOe Configuration Beta Release to Production.

Delivered EDW solutions for Ancilyze (Health care domain) & Data warehousing solution for true-sight application.

Successfully delivered widget integration for Netherlands AllSecur.

Successful timely delivery of Viva Aerobus portal integration with PPOe.

Roles & Responsibilities:

Creating Data bases, tables, views, indexes, Writing Stored Procedures.

Applied various types filters like Data source filters, Quick filters and Context Filters.

Created table calculations, calculated fields and parameters.

Creating Workbooks by Importing data, Defining Relationships.

Created List, Cross Tab Reports with Quick Filters, Summarized Filters.

Developing, Designing and supporting interactive Tableau Dashboard reports.

Experience in creating various views in Tableau (Tree maps, Heat Maps, Scatter plot).

Implemented Binning & Blending concepts in my Tableau Reports.

Worked on Individual Axis, Blended Axis and Dual Axis concept while working with reports.

Created Dashboards and Stories by using Table calculations and Quick Table Calculations (Year over Year Growth, YTD Total, and YTD Growth).

Creating SSIS Packages by using different data Transformations like Derived Column, Lookup, Data Conversion, Conditional Split, Pivot, Union all and Execute SQL Task to load data into Database.

Designed Data-Mart for Prescription using Relational Model and wrote SSIS Packages to extract data from the old PDX system and load it into the new data mart of SQL Server.

Lead the design, development and maintenance of custom reports using BIDS/SSDT and Report Builder.

Use PowerPivot to extract, import and join data that coming from different sources and use DAX to create new calculated measures and make this available in Clients SharePoint Site.

Import own data through PowerBI connects to the SaaS sources you use (such as Microsoft Dynamics, Google Analytics, Salesforce, and many more) and automatically creates dashboards and reports for you. You can also import Excel workbooks from OneDrive or your computer.

Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins, Temp tables for applications.

Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.

Interact with the implementation MS SQL Server T-SQL scripts for ETL to enhance delivery of existing and future reporting solutions.

Implemented complex business logic with case, cast, convert, CTE using T-SQL.

Extensively used Package Configurations while deploying the SSIS packages from DEV- Stage, Stage - Prod environments.

Monitoring Jobs and Investigate Failures.

Create and update SSIS Packages to pull data from source to destination database.

Migrated DTS packages from SQL Server 2012 to SQL Server 2014 as SSIS Packages.

Worked On Bug Fixing.

Involved in Deployment and Administration on SSIS packages with Business Intelligence Development Studio.

Generating drill through reports, drill down reports, parameterized reports, linked reports, Crystal reports, sub reports, table, matrix, charts in SSRS 2012.

Scheduling the jobs to send the reports.

# Project 5:

Project

: Social Media Analytics

Client

: DELL

Location

Role

Duration

: Fairfax, VA

: BI Consultant

: January 2014 to July 2015.

Team Size

: 7

Environment: MS SQL Server 2012, TFS, T-SQL, SSAS, SSIS, SSRS, Excel, Visual Studio 2010/2012, Windows Server 2008, Oracle SQL Developer, Tableau 8.2.

Description: It is a social media tool that helps to analyze client's followers to generate sentiment reports and social-reach metrics. It captures the real sentiments of customers about client business, product, or service. This tool will extract subjective information that are most relevant to client business, from their social conversations by taking advantage of human judgment, interpretation, and accuracy while analyzing conversations with well written machine learning algorithms and provides Sentiment Analysis, Influencer’s and Keywords metrics.

Roles & Responsibilities:

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.

Created Users, Groups and Set Permissions on Server.

Connecting to Data sources.

Worked on Quick filters.

Logical calculations, mapping, formatting.

Formatted the Reports as per the Client requirement

Updating the status to the Manager on daily and weekly basis.

Extracted data from various sources and performed data blending.

Creating Workbooks by Importing data, Defining Relationships.

Created List, Cross Tab Reports with Quick Filters, Summarized Filters.

Developing, Designing and supporting interactive Tableau Dashboard reports.

Experience with the design and development of Tableau visualization solutions.

Created Bar Charts, Columns Charts, water fall charts, Heat Maps, And Geographical Maps.

Strong knowledge on software development life cycle (SDLC).

Experience in Marks, Action, Filters, Parameters, Cards, Publisher and Security.

Created Derived Columns to fulfil the User Requirements.

Created Parameters to reports be more User friendly to End Users.

Connecting multiple data source with Data Blending technique.

Formatting the Data by using Legends, Marks, Colours, Sizes, and Shapes.

Providing the Security while Publishing to the Tableau Server.

# Project 4:

Project

: Data Warehousing and Migration

Client

: East Boston Saving Bank

Location

Role

Duration

: Boston, MA

: Sr. ETL/MSBI Developer

: January 2012 to December 2013.

Team Size

: 7

Environment: MS SQL Server 2008 R2, TFS, SharePoint 2010, T-SQL, SSAS, SSIS, SSRS, Excel, Visual Studio 2008/2010, Informatica 8.1.1 Power Center, Windows Server 2008, tableau 7.0, tableau desktop.

Description:

East Boston Savings Bank provides financial services to its clients in the area of Commercial Banking, Business Banking, Card Services, Home Lending, Investing, Private Bank, Private Client Services among others. The Primary Objective of the project is to extract, transform and load data from various sources using Microsoft Integration Services (SSIS) and maintain them in a Data Warehouse. This project is also responsible for loading data (gets from various legacy systems) into SQL Servers by creating Integrated Packages (SSIS) and makes available data for Analysis (SSAS) cubes and Reporting services (SSRS).

Roles & Responsibilities:

Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business. Configured performance tuning settings using indexes, SQL profiler

Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation.

Experienced in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using DTS and SSIS services.

Created packages in SSIS with error handling.

Worked with different methods of logging in SSIS.

Developed ETL programs using Informatica to implement the business requirements.

Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.

Analyzed the Informatica mappings for Source to Target for Data Analysis.

Imported various heterogeneous files using Informatica Power Center 8.x Source Analyzer.

Performing intensive data analysis on large data volumes, testing for quality assurance, and migrating releases into stage and production environments.

Extensively worked on Facts and Slowly Changing Dimension (SCD) tables.

Designing the Reports as per client Requirement and created the reports using Excel file and SQL Server database.

Created complex reports utilizing the features like hierarchy, New Calculated Columns, Drill functionality, Tables, graphs, line Charts and Bar Charts.

Created Parameters to achieve desired functionality.

Implemented Binning & Blending concepts in my Tableau Reports.

Worked on Dual Axis concept while working with reports.

Created Filters, Groups, Sets on Tableau Reports.

Created and modified some of the existing reports and dashboards.

Publishing sheets and dashboards on server Using Tableau Desktop.

Created conditional filters and Action links to filter the data on dashboard.

Writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers and SQLCMD.

Maintaining jobs for data messaging from development server to test server for generating daily reports.

Used some data conversion tasks in SSIS to load the data from flat file to SQL Server database.

Created ETL SSIS packages both design and code to process data to target databases.

Created document for Self-Service Deployment and Execution process for SSIS packages.

Constructed OLTP and OLAP Databases.

Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.

Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.

Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.

Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.

# Project 3:

Project

: Client Consolidated View (CVV) Enhancements

Client

: AAA US.

Duration

: November 2009 to December 2011.

Team Size

Role

: 5

: Sr.MSBI Developer

Location

ETL Tool

: Hyderabad, India

: SSIS 2005/2008

Reporting Tool

: SSRS 2005/2008

Environment: Windows Server 2003/2008, SQL Server 2005/2008-R2/2012, DTS, SSIS, SSRS, SSAS, ProClarity/Performance Point, Microsoft Access 2013, Visual Studio 2008/2010, Team Foundation Server, .NET, Visio 2007, VB, ASP.NET, JavaScript.

Description:

AAA is one of the leading American automobile insurance companies. The CCV project was developed in an effort to streamline the entire process of Insurance and to keep track of various financials on a daily, weekly, monthly basis. The main goal of the project was to extract, transform and load data from different sources using Microsoft Integration Services (SSIS) and maintain them in a Data ware house. This project also involved in migration of data from SQL server 2005 to SQL server 2008.

Roles & Responsibilities:

Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, Oracle DB, and SQL).

Good experience in writing MDX queries while creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2005/2008.

Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects.

Expertise in identification of Business & Data requirements and converting them into conceptual & logical data models.

Experience in Dimensional Data Modelling Star and Snow Flake Schemas.

Designed and developed SQL Server Analysis Services (SSAS) databases and OLAP cubes used in ad-hoc analytic research and automated reporting.

Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.

Involved in designing cubes in SSAS environment using Snowflake and Star Schemas.

Involved in Designing, Analysing, building and testing of OLAP cubes in SSAS and adding calculations using MDX.

Updated functional specification and technical design documents. Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data mart.

Create and maintain project artifacts including; data requirements, technical specifications, test plans, etc using Business intelligence tools.

Extracted and Transformed data into Staging Servers named as P Staging Server for historical data and T Staging Server for load increment.

Performed Loading operation of historical data using full load and incremental load into Enterprise Data Warehouse.

Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.

Developed Custom Logging so user can know when a row is inserted in custom logging table by every SSIS package that executes.

Migrated DTS packages from SQL Server 2005 to SQL Server 2008 as SSIS Packages.

Filtered data from Transient Stage to EDW by using complex T-SQL statements in Execute SQL Query Task and in Transformations and implemented various Constraints and Triggers for data consistency and to preserve data integrity.

Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Send Mail Task, Package Execution task to achieve business needs.

Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.

Design and develop dynamic advanced T-SQL, PL/SQL, MDX query, stored procedures, XML, user defined functions, parameters, views, tables, triggers, indexes, constraints, SSIS packages, SSAS Cubes, SQL Server Agent jobs, deployment scripts and installation instructions for enterprise data warehouse and applications.

Created and modified various Stored Procedures used in the application using T-SQL.

Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.

Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.

Created reports that have been defined by business architect and generated reports in a Crystal format of Crystal Reports.

Created share point pages, master pages, navigation and security, charts, score cards, KPI, SSRS reports and lists and also worked on Excel 2010, Power Pivot for providing ad-hoc reporting for the clients.

Wrote complex Expressions and Calculations for SSRS reports with Conditional Formatting.

Created Project Expense Statements in all Data Marts and other Financial Reports using SSRS.

# Project 2:

Project

: Insurance Management

Client

: International group of Insurance, Inc. (IIG), US.

Duration

Location

: April 2009 to October 2009.

: Hyderabad, India.

Team Size

Role

: 7

: Sr. SSIS Developer

ETL Tool

: SSIS 2005

Reporting Tool

: SSRS 2005

Environment: Windows Server 2003/2008, SSMS 2005, SSIS, SSRS, Visual Studios 2005.

Description:

The main objective of the project is to specialize in providing short and long term international health, international medical, and international travel health that are Designed for both US and non-US citizens, including any student traveling or living abroad. It generates clinical indicators to describe the history of the patients entered into the system. The project takes advantages of using Smart Card Storage and Touch Screen optimized user interface and which can provide data in a structured and well-defined format in the reporting services and to provide the managers the ability to analyze the data and make the business decisions.

Roles & Responsibilities:

Created the tables, views, indexes, Writing Stored Procedures.

Configured performance tuning settings using indexes, SQL profiler

Creating database consolidating data and Loading into live database using IS.

Involved in complete SDLC life cycle.

Extract, Transform and Load source data into respective target tables to build the required data marts.

Implemented different types of constraints on tables.

Designed and applied entity and attributes description and definition for the models.

Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.

Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.

Migrating COGNOS reports to SSRS.

Developed optimal stored procedures and queries to create data sets for reports.

Responsible for scheduling the subscription reports with the subscription report wizard.

Creating SSIS Packages by using different data Transformations like Derived Column, Lookup, Data Conversion, Conditional Split, Pivot, Union all and Execute SQL Task to load data into Database.

Involved in the performance Tuning.

Unit tested the packages.

Scheduling the jobs to send the reports.

# Project 1(Internship):

Project

: Sales Information System

Client

: DIGIPRISE

Duration

Location

: August 2008 to March 2009

: Hyderabad, India.

Team Size

: 7

Role

: SQL Developer

Environment

: Microsoft SQL Server 2005.

Environment: SSMS 2005.

Description:

Supermarket has 60 stores throughout the India. To meet their customer needs they decided to build a Data Warehouse to analyze the key factors like total sales revenue on the monthly and quarterly basis on the region and seasonal wise the sales amount and the decision support system is focused on analyzing the entire business process. In order to provide the critical information like daily revenue, total sales, goals and new plans, the company developed business intelligence system suite of products, transformed data is loaded into data marts.

Roles & Responsibilities:

Worked on stored procedures, triggers, functions and views.

Involved in Index operations (Rebuild & Reorganize) and database maintenance.

Worked On Bug Fixing

Reviewing and Execution of Test Cases.

Coordinating the Developing activities with the development team and QA team.

Enhancements of the existing code according to client requirements.

Performance tuning and Code review: Responsible for code review of the database objects like

Stored procedures, triggers, functions and views.

Contact this candidate