SUMMARY:

MS BI Professional who is proficient in SQL Server, MSBI Stack (SSIS, SSAS, and SSRS), Power BI, and Tableau within large and complex environments. Experience within multiple industries including healthcare, financial, banking, legal, and technology.

TECHNICAL SKILLS:

Databases: MS - SQL Server 2008, 2008R2, 2012 T-SQL Programming, Dynamic SQL, Java

Data Modeling: Erwin, MS Visio

Development Tools:  BIDS, SSDT, SSMS Integration Services (SSIS), Analysis Services (SSAS, OLAP Cubes, Tabular Model), Reporting Services (SSRS, Report Builder)

BI Tools: Power BI, Tableau

Collaboration Tools:  SharePoint, Microsoft AzureCloud Services (PaaS & IaaS), Azure SQL Database (PaaS), Azure Storages (Blobs, Tables, Queues), Backup/Recovery, Azure Data Factory, Azure Data Warehouse PowerShell

SDLC: Agile, Scrum, Waterfall, and Spiral

Source Control: Team Foundation Server (TFS)

PROFESSIONAL EXPERIENCE:

Confidential, San Diego, CA

SQL/Tableau Reports Developer

Tools and Environment: SQL Server 2012, T-SQL, SSMS, SSDT, Erwin, SSIS, SSAS, SSRS, SharePoint, Power BI, Tableau, TFS, MS Azure, Data Factory, SharePoint, SQL Profiler.

Responsibilities:

• Understanding the business requirements such as KPI needs, mapping documents, measures and dimensions Specification.
• Designed data modeling per business requirement utilizing Erwin.
• Created stored procedures and functions for preparing data in staging area for data cleansing and data profiling.
• Wrote TSQL queries to extract data utilizing sub queries, Joins, CTE and user defined functions.
• Analyze and managed indexes in production enviornment in terms of performance optimization utilizing execution plan.
• Implemented TSQL constraints to validate data within tables per business requirement.
• Implemented error handling within queries utilizing try-catch, raiserror, throw per business requirement.
• Importing source tables from the respective databases by utilizing Control Flow Tasks in SQL Server Integration services.
• Involved in creating ETL packages with SSIS to extract data from staging tables to partitioned tables with incremental load
• Wrote MDX and DAX queries for SSAS cubes (Tabular and Multidimensional model) and SSRS reports.
• Implemented single value and multi valued parameterized reports for Business users utilizing Tableau.
• Implemented Conditional format features of Tableau to generate user-friendly reports.
• Implemented detail and summary filters and extensively used Drill-through reports with Tableau.
• Created Tabular, Crosstab Chart types of reports in Tableau as per end user requirements.
• Created dashboards utilizing Tableau as part of comparison analysis.
• Created KPIs utilizing calculated function and quick table function in Tableau.
• Migrated legacy reports into Tableau environment.
• Involved in deployment of Tableau reports to the Tableau server.
• Incorporated TFS for solution source control, project co-ordination, and task management.
• Migrated data from Microsoft Azure cloud platform to on-premises data servers utilizing Azure cloud technology.

Confidential, San Diego, CA

Tableau Reports Developer March

Tools and Environment: Microsoft SQL Server 2012, SSDT, SSMS, T-SQL, SSIS, SSRS, Tableau, Erwin, SharePoint, TFS

Responsibilities:

• Created system requirement gathering document based on extensive JRD and JAD sessions that yielded the conceptual design.
• Created stored procedures, Triggers, User-defined Functions, views for both online and batch requests handling business logic and functionality of various modules.
• Optimized the performance of queries with modification in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables and created indexes wherever necessary.
• Wrote dynamic SQL batches to perform the bulk operation in OLTP environment.
• Created SSIS package for data scrubbing and cleaning utilizing TSQL queries and various transformations viz. fuzzy lookup, fuzzy grouping, derived column, data conversion, etc.
• Created different types of application oriented reports such as drill down reports, drill through reports, and parameterized reports in Tableau.
• Utilized multiple data sources such as SQL server, SSAS cubes and tabular model for creating Tableau reports.
• Involved in created mapping documents in the reports for analyzing data geographically with Tableau.
• Used push method of delivering reports - subscriptions by scheduling the reports to deliver on time utilizing subscriptions facility in different formats viz. Excel, Pdf, Text, etc.
• Created Rich dashboards utilizing Tableau and prepared user stories to create compelling dashboards to deliver actionable insights and deployed them on Tableau server.
• Created analytical dashboards to assist business users with critical KPIs and facilitating strategic planning with Tableau
• Created visually compelling and actionable interactive Tableau reports, dashboards and deployed them on Tableau Server.
• Tracked changes in SQL code and the BI application in Team Foundation Server.

Confidential, Greenbelt, MD

MSBI/Report Developer

Tools and Environment: MS SQL Server 2008R2, BIDS, SSIS, SSRS, Erwin, SQL Profiler, SQL Debugger, SharePoint, Power Pivot, TFS, Excel,

Responsibilities:

• Gathered business requirements, definition and design of the data sources and data flows.
• Analyzed data quality, worked in conjunction with the DWH architect on the development of logical data models.
• Created T-SQL scripts and complex stored procedures for data validation and to process data in tables.
• Tuned database objects and server to ensure efficient data retrieval.
• Migrated data from Legacy system (Text files, Excel docs and Access files) to SQL Server Databases utilizing SSIS.
• Wrote complex stored procs to generate dataset for SSRS reports.
• Developed drill-through reports, parameterized reports, tabular reports, matrix reports and linked reports within SSRS and Tableau.
• Wrote complex expressions and calculations for SSRS reports.
• Designed dashboards and scorecards with Tableau for top level management.
• Created KPIs with Tableau calculated function.
• Automated report deliveries to multiple recipients with subscriptions in SSRS.
• Involved in rendering reports to multiple formats such as PDF, Image, and Excel according to management needs.
• Involved in deployment of SSRS reports and Tableau dashboards on the SharePoint server for better accessibility.
• Managed development changes for the BI solution with TFS.

Confidential

Gaithersburg, MD

BI/Reports Developer

Tools and Environment: MS SQL Server 2008/R2, SSMS, BIDS, SSIS, SSAS, SSRS, T-SQL, Excel, Erwin, Tableau

Responsibilities:

• Teamed up with Business analysts and conducted JRD session for requirement gathering from Business Users.
• Developed system design, architecture design diagrams and application design specifications.
• Created complex stored procedures for data profiling, data manipulation and reporting database.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered, Non-Clustered Indexes for significant performance boost.
• Designed, Created and Implemented complex ETL Strategies using SSIS Packages that extracted the data from different heterogeneous sources like Flat Files, Excel Files and dumped it into a Data mart.
• Created SSRS Reports on the top of the cube utilizing some MDX queries
• Developed dashboards with multiple scorecards utilizing Tableau for business analysis.
• Delivered on-demand and scheduled reports for business analyses in SSRS.
• Developed dashboard reports with reporting services, report model and ad-hoc reporting using Report Builder
• Created report snapshots to improve the performance of SSRS.
• Involved in deploying reports to Report Manager and SharePoint; involved in troubleshooting for any error occurs in execution

Confidential, Rockville, MD

SQL Developer

Tools and Environment: SQL Server 2008, SSMS, T-SQL, SQL Profiler, DTA, TFS

Responsibilities:

• Analyzed and tuned complex queries/stored procedures for faster execution and developed database structures.
• Developed and created various backup and recovery plans depending upon OLTP load, server down time, percentage of data loss and budget issues and automated all the things utilizing SQL Server agent.
• Redesigned and improved existing procedures, triggers, UDF, and views with execution plans, SQL profiler, and DTA.
• Monitored and resolved deadlocks in SQL Server databases with locks, isolation levels, and SQL Profiler.
• Involved in creating parameterized reports, cross-tab reports, drill down reports and summary reports utilizing SSRS.
• Worked on performance tuning on existing reports for the faster processing of reports. 
• Involved in report deployment, security utilizing report server and report manager.