Summary:

• Hands on experience in working of MS BI stack of SQL Server SSIS, SSAS, SSRS versions 2012, 2008 R2 and 2005 BIDS .
• Expertise in gathering of information pertaining to data requirements and transformations in order to initialize a solid implementable and repeatable process.
• Proficient in data Extraction, Transforming and Loading ETL using SQL Server Integration Services SSIS tool. Extracting data from one or many data systems, applying a series of rules or functions on the extracted data to derive it in the end target and finally loading the data in the end target or destination.
• Following through the ETL life cycle starting from the process of initiating the cycle, building reference data, Extracting from sources , Validating, Transforming cleaning, applying business rules, checking for data integrity, create aggregates or disaggregates , Stage load into staging tables, if used , Audit reports, publishing to the target tables , and finally to archiving and cleaning up.
• Active role in designing, development and deploying of SSIS Packages for building high performance data integration solutions.
• Expertise in writing of T-SQL queries DDL and DML which is utilized in construction of tables and normalization techniques on database tables.
• Expertise in creation of Entity Relationship Diagrams ERD using Microsoft Visual Studio 2010 to the proposed database, explaining and linking the tables concisely while maintaining referential integrity, data integrity and column integrity.
• Experienced in creation of databases and database objects such as tables, views, complex stored procedures, triggers, indexes and breakpoints.
• Expert in defining of relations of attributes between tables by identifying and defining primary keys in addition to relational foreign keys during the creation of tables in order to maintain thorough uniqueness.
• Experienced in development of content and visually rich reports in SQL Server Reporting Services SSRS like tabular, matrix, list, chart, gauge, and map.
• Experienced in using creation of advanced analytics dashboards, datasheets using Tableau desktop. Connecting one or more data sources to a report as required.
• Designing, creating, and managing multidimensional cubes that contain data gathered from other data sources relational databases and Online Analytical Processing OLAP by using SQL Server Analysis Services SSAS .
• Experienced in defining data sources, data source views, dimensions, attributes, attribute relationships, hierarchies, and cubes in Analysis Services project within SQL Server Data Tools. In addition to usage of run time error handling and event handling.
• Experienced in usage of Microsoft BI tools like Power View, Power Pivot, Power Query, Power Map which are utilized to retrieve, analyze, and to finally display the data in a well-defined visual form.
• Excellent analytical, professional written and verbal communication skills and interpersonal skills.
• Ability to work independently or as part of a team to fulfill critical business objectives.

Skill Set:

MS SQL Server 20012, 2008 R2 SQL Server Integration Services SSIS , SQL Server Analysis Services SSAS , SQL Server Reporting Services SSRS , AS/400 - formally renamed the IBM iSeries, MS Visual Studio 2010, Tableau Desktop 8.0, 8.1, and 8.3. Tableau Server, Tableau Reader, Tableau Public.

Projects Summary:

Confidential

ETL Developer

Responsibilities:

• Extensively worked with SSIS tool suite, designing and creating mappings using various SSIS transformations like OLEDB command, conditional split, lookup, aggregator, and multicast and derived column.
• Expertise in using various kinds of joins Inner Join, Outer Join, Left Outer Join etc. and sub-queries to simplify complex queries involving multiple tables.
• Created Database Objects Schemas, Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Extracted data from various sources like SQL Server 2008/2012, .CSV, Excel and Text file sources, alongside from various other servers, creating a centralized data warehouse structure in their headquarters.
• Involved in Creation, Development and Deployment of SSIS packages in SQL Server 2012 and SQL Server 2008 R2.
• Created logging for ETL process at package level and task level to log the number of records processed by each package and each task in a package using SSIS
• Performed and fine-tuned stored procedures and SQL queries and User Defined Functions UDF .
• Wrote SQL queries using Joins and Sub queries and Functions to retrieve data from data sources.
• Familiar with OLAP cubes and fact table, star and snowflake schemas, building multi-dimensional cubes and KPIs for decision makers using SQL Server Analysis services SSAS .
• Developed different types of Tabular, Matrix Cross Tab or Pivot Reports, Chart and Graphs, reports that aggregate data, reports that contain parameters and group, reports containing totals and subtotals, drill-down reports and ad-hoc reports using SQL Server Reporting Services SSRS and Tableau in certain instances.

Environment: MS SQL Server 2012, 2008 R2, SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , SQL Server Analysis Services SSAS , Microsoft Visual Studio 2010, Tableau Desktop 8.3, Tableau Public.

Confidential

BI Developer

Responsibilities:

• Designed and developed SSIS packages to import data from various sources such as Excel, Flat Files, ODBC and OLE DB sources.
• Developed ETL specifications, source to target mappings and other documentations that were developed for the ETL development.
• Implemented various transformations using Audit, Fuzzy Look-up, Multi-Cast, Column Conversion and Term Look-up etc. to enhance the whole ETL process.
• Usage of event handlers, error handling, coding, troubleshooting and performance tuning SSIS packages that were developed.
• Involved in development and design of OLAP cubes, fact tables, dimensional tables and KPI efficiently using SQL Server Analysis Services SSAS .
• Worked in developing of complex Stored Procedures, Functions, User Defined Functions, Triggers, Views and TSQL statements.
• Experience in designing Logical and Physical Modeling using ERWIN and ER Studio.
• Developed complex reports such as Tabular, Matrix, Sub Reports, Charts, Drill Down reports etc. to depict the necessary analysis required, with various functions such as parameters, filters, row count, document mapping etc. using SQL Server Reporting Services SSRS .
• Developed visually rich reports using Tableau 8.1 focussing on market trends, customer sales and forecasting alongside showing country/state/region wise sale analysis and growth analysis and finally comprising them in a dashboard.

Environment: MS SQL Server 2012, SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , Tableau 8.3, Tableau Reader, Tableau Server.

Confidential

Role: ETL Developer and Reporter

Responsibilities

• Deep involvement in usage of T-SQL Statements DDL and DML for altering tables, inserting new columns, creating temporary tables, joins and writing stored procedures in SSIS packages for improving overall performance.
• Created Logging, Break Points, Check Points, and used Error Handler in SSIS and automating the ETL process.
• Created cubes for Dimension and fact tables for future and current reporting using SQL server Analysis Services SSAS .
• Built MDX queries for Analysis Services Reporting Services.
• Worked as a developer in creating complex Stored Procedures, Functions, Triggers, Views and complex SQL statements for applications
• Developed Custom Functions, Manual Running Totals and Complex Formulas for reports and further used calculations, sorts, filters and sections to enhance data presentation in reports.
• Used Tableau Desktop for visual analytics, creation of KPI's for top management and preparing dashboards using calculations and parameters in Tableau.
• Created datasheets, dashboards and stories for all the functional areas including Finance, Change Management, Order Management, Pricing, Purchasing, HR, Demand Planning and Sales/Marketing

Environment: MS SQL Server 2012, SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS, Tableau 8.1 and 8.3, Tableau Public, Tableau Server.

Confidential

ETL Developer and Reporter

Responsibilities:

• Was part of a team working on their ETL and complex reporting needs to support their client requirements and catering to the forensic services.
• Assisted seniors and managers in the analysis of the collected data and interpreting them in conformity to client specifications in order to derive correct and best possible outcomes.
• Direct involvement in requirements gathering, analysis, design, development, change management, deployment and final stage of reporting to the required clients.
• Developed SSIS packages, bringing data from various sources such as Excel, SQL server, flat files, for the daily load in order to generate and maintain a centralized data warehouse.
• Used various data transformations like conditional splitting, fuzzy lookup, multi cast, column conversion, fuzzy grouping etc. to meet specified needs and requirements.
• Extensively used joins and sub-queries to simplify complex queries involving multiple tables and to merge data of multiple tables to create a concise form of database.
• Analyzed the specific needs and requirements as provided by the clients and gathered the necessary requirements for design and development completion.
• Used Data Definition Language DDL and Data Manipulation Language DML for writing triggers, break points and check points.
• Error/event handling and performance tuning of SSIS packages for a more optimized running environment.
• Making of breakpoints to review the status of the data and to configure and fix the error upon notification.
• Created matrix, chart and tabular forms of reports using SQL Server Reporting Services 2012/2008R2.
• Designed and deployed reports with drill down, drill through and drop down menu options and parameterized and linked reports.
• Used Tableau for certain clients to make comprehensive dashboards consisting of multiple sheets of comparison and detail.
• Scheduled and deployed reports using SSRS to generate weekly, monthly and quarterly reports including current status if required by the client or the management meeting strict deadlines.

Environment: MS SQL Server 2012, 2008 R2, SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , Microsoft Visual Studio 2010, Tableau, K-Check KPMG's screening tool to identify key risks and improvement areas .

Confidential

Business Intelligence Unit Reporter

Responsibilities:

• Worked closely with my manager in analysis of business markets, new sectors, and existing clients to create a concise database for upper management to overlook.
• Generated matrix, tabular, and chart reports consisting of current market trends and analysis in UK wherein the company could venture and expand its services to.
• Involved in gathering, extracting and loading data on local database warehouse and ensuring creation of a solid structure in order to have a smooth transition till the last stage of the process.
• Used SQL Server Integration Services SSIS to load data largely predominantly from excel files to local database and added transformations over it to meet the requirements.
• Incorporated various functions and specifications on reports such as adding parameters, filters on reports.

Environment: MS SQL Server, 2008 R2, SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , Microsoft Visual Studio 2008.