Professional Summary

• Over 4+ years of extensive experience in data warehouse complete life cycle using SQL Server suite of products SSIS, SSRS, SSAS and PowerBI.
• Expert in developing T - SQL (DDL, DML) statements, Data Integrity (constraints), Rules and Validation issues.
• Extensive knowledge and experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers. 
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility and SSIS services and loading data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Experience in implementing various SSIS features like Event Handling, Precedence Constraints, Break Points, Check Points, and Logging for Complex SSIS Packages .
• Expertise in SQL Server Analysis Services (SSAS) delivers online analytical processing (OLAP) for business intelligence applications.
• In-depth knowledge in ER Modeling and Dimensional Modeling ( Star and Snowflake Schema ) building Dimension and Fact tables.
• Experienced in building and writing MDX Queries, Calculated Members, and KPI’s using Microsoft SQL Server 2005/2008 Analysis Services Business Intelligence (SSAS, SSRS).
• Strong ability in defining query for generating drill down reports, handling parameterized reports, and creating stylish report layouts in  SSRS .
• Expert in designing Enterprise reports using SSRS, PowerBI and Excel Pivot table based on OLAP cubes.
• Experience in configuring security, Organizational Content Packs, data Gateways, refresh schedules for  PowerBI service .
• Extensive experience with all phases of Software Development Life Cycle(SDLC) in different environments like Banking, Insurance, Engineering, and Information Technology. 
• Quick learner and excellent team player, ability to meet deadlines and work under pressure - either unsupervised or in a team.

Technical Skills:

Languages: C, C ++, .Net, C #, SQL, T - SQL, PL-SQL.

Client & Server-Side Scripting : ASP.NET, JavaScript, MDX, DAX 

Web Technologies: ASP.NET, HTML 

Reporting Client tools: MS SQL Server Reporting Services(SSRS), PerformancePoint, PowerPivot, Power view, PowerBI, Tableau

IDEs: SQL Server Management Studio (SSMS), SSDT, SQL Server Business Intelligence Development Studio (BIDS), Visual Studio, Edition and 2012, 2015 Professional Editions. 

Versioning: Team Foundation Server (TFS), SharePoint. 

Operating Systems : Windows/Server, UNIX, MS - DOS 

Methodology : Agile, Waterfall

PR O FE SS IO NA L EXPERIE NCE

ALBI/Tableau Developer

Responsibilities:

• Extensively worked with Business Users gathering their requirements and actively cataloging and supporting various issues and providing their solution.
• Created and managing new database objects like Sequences, Functions, Triggers, Indexes and Views using joins, sub queries and correlated sub queries in Development and Production environment for SQL Server. 
• Created SSIS packages that extract data from database tables and write the data to text files.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Created packages in SSIS with error handling using SSIS 2012.
• Worked with different methods of logging in SSIS.
• Designed & Supported daily, weekly, monthly batch processes using job scheduler.
• Generated reports with SSRS and Power Pivot, deployed reports in SharePoint integrated mode.
• Created Subscription of reports in different formats like pdf, excel etc. to be executed automatically on daily, weekly, and monthly basis.
• Formatted the reports using the Global variables and expressions. 
• Upgraded Tableau Server from 9.3.8 to 10.1.6.
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary reports and dashboard using KPI's.
• Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
• Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Used calculated fields extensively for different logics for Trend, Extended price calculations for the different cost types.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Creating New Schedule's and checking the task's daily on the server.
• Created scripts to send automated alerts whenever restore or backup fails.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop Expert in generating complex, dashboard reports, ad-hoc, business views along with user acceptance test and data accuracy test.

Environment: MS SQL Server 2008/2005, T- SQL, TableauDesktop10.1/9.3, Tableau server/Administrator, MS Excel 2007/2003, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), SQL Server Business Intelligence Development Studio, Team Foundation Server (TFS), Visual source safe (VSS), Microsoft SharePoint 2010.

Confidential, AL

Reports Developer

Responsibilities:

• Analyze the Application support documents and Service Level Agreements (SLA).
• Implemented stored procedures and functions to meet the dynamic nature of SSIS packages and SSRS Reports existing software application requirements.
• Built and published customized interactive dashboards utilizing Power BI.
• Created the data model by pulling the data from multiple sources and transform the raw data into business information by applying the transform rules.
• Experienced in Developing power BI Reports and Dashboards from multiple data sources using Data Blending.
• Explore data in a Variety of ways and across multiple visualizations using Power BI.
• Applied transform rules Data Conversion, Data Cleansing, Data Aggregation, Data Merging and Data split.
• Created new measures and new calculated columns for reports and dashboard analysis.
• Created data visualizations using various visual objects (Line chart, Bar chart, Tree map, Single card, KPI, Map, Pie chart, custom visuals).
• Used different types of visualization Like (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer etc.) in Power BI according to the requirements.
• Published reports and dashboards to the Power BI service through the Office 365 integration.
• Shared the dashboards among multiple users in the group.
• Good Knowledge and experience on Power BI Gateways (Personal and Enterprise gateways).
• Used agile development Methodology.
• Implemented dashboards and scorecards with power pivot for executive management for data insights as per business requirements.
• Maintained existing Power BI reports and dashboards and made changes onto the same as per new and changing business requirements.

Environment : MS SQL Server 2012, SQL Server Integration Services, Microsoft Visual Studio, Team foundation server (TFS) 2010, T-SQL, PowerBI, MS Excel, SharePoint, Windows 2010 Server.

SQL BI Developer

Responsibilities:

• Responsible to meet the informatondem ands of our business users by deliverin gtime ly, accurate, meaningful, and standardized data and reporting.
• Developed tables, Views, Stored Procedures, and Triggers using SQL S erver M an agem e n t Stu d io.
• Identified and resolved the query performance using SQL Profiler .
• Optimized the performance of queries with modifications in T - SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Established Inner Join, Outer Join and created Ind exes whenever necessar y.
• Creat ed SSIS Packages to integrate data coming from Text files and Excel files.
• Worked on extracting, transforming, and loading data using SSIS Import/Export Wizard .
• Designed Complex Packages with Error Handling and Package Logging that stores the Logging results in SQL table and flat files.
• Responsible for installation, configuration, security, maintenance, restoration of SSRS.
• D evelo p ed Tabular Reports, SubReports, Matrix Report s, drill down Reports, and Charts using SQL Server Reporting Services ( SSRS) .
• Performed Sorting, forma tting, a n d Grouping t o customre p ort s in SSRS.
• Creat ed Que ry Pa ram e t e rs an d Rep o rt Parameters to control data returned by the query and fiter data at the report level.
• Fully utilized the Software Development Lif e Cycle processes includin grequirement .

Environment: T-SQL, Microsoft SQL Server Management Studio 2010, SSDT, SSIS, Windows Server 2010, Microsoft Office 2010, SQL Reporting Services (SSRS), SharePoint.

Confidential Health Street

SQL Developer

Responsibilities:

• Gathered the requirements from Business Users and passed on the requirements to the team.
• Created custom SQL procedures to read data from flat files to dump to database using SQL Loader.
• Installation and configuration of MS SQL Server.
• Discussed and documented the building of data warehouse at every step.
• Exported the existing data from a legacy database to a newer database.
• Optimized the existing stored procedures and automated them for various tasks.
• Created new Database objects like Tables, Views, indexes, and functions.
• Developed a new set of complex stored procedures for newer business requirements.
• Imported data from various sources like Excel, Access.
• Writing T-SQL joins, sub queries, tracing, indexing strategies and query/index tuning and performance tuning for better running of queries.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Developed ETL packages using multiple data sources (SQL Server, Flat Files, Excel source files, XML files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS transformations.
• Participated in disaster prevention and recovery strategies.

Environment: MS SQL Server 2008R2, VS2010, Business Intelligence Development Studio(BIDS), T-SQL, XML, Performance Point Server 2007, SSIS, SSRS, SSAS, OLAP, OLTP, Windows 7, TFS, Microsoft Excel.