SUMMARY:

• A Microsoft Business Intelligence Professional with 8 years of strong experience in all phases of SDLC, including gathering Business Requirements, Design, Development, Testing and Implementation of large - scale enterprise applications in Healthcare and Financial domain.
• Expert in Performing Transformations using SSIS; ADHOC, Parameter, Cascading Reporting using SSRS, Developing Cubes using SSAS.
• Broad experience with Relational Database Management System (RDMS), Data Warehouse Concepts, OLTP and OLAP as per business needs.
• Worked with T-SQL, DBCC, DCL, DDL, DML, PL/SQL Scripts and established relationships between tables using Primary Keys & Foreign Keys.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Views, Sub queries and SQL joins to simplify complex queries involving multiple tables.
• Very strong in creating and maintaining database objects like Indexes, User Defined Functions, Triggers, recursive queries using CTEs in SQL Server.
• Experience in implementing different types of Replication models like Snapshot, Transactional and Merge Replication.
• Experience in Change Data Capture (CDC), Change Tracking (CT).
• Expert in Query Tuning activities including Updating Statistics, Re-building and Re-organizing Indexes.
• Expertise in designing and development of various dashboards, reports utilizing various Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the business/client requirement.
• Experience in developing reports and dashboards in MS Power BI.
• Excellent Experience in publishing Dashboards to Tableau Server.
• Rebuild online index and worked with Dynamic Management Views (DMV) for improving query performance based issues on the server.
• Resolved issues with Indexes, Blocking and locking issues to remove the performance bottlenecks and used Profiler to solve Dead Locks.
• Extensive experience in using Microsoft BI studio products like SSIS, SSAS, SSRS for implementation of ETL methodology.
• Expertise in developing complex SSIS Packages including C# scripting to extract data from heterogeneous data sources.
• Developed SSIS packages for processing fact and dimension tables with complex transforms and Slowly Changing Dimensions type 1 and type 2 changes.
• Hands on experience in Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Hands on experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using (SSRS).
• Experience in developing various kind of reports like Cascading parameters, Drill down, Drill through, Sub Reports and Charts.
• Experience in designing complex reports including sub reports and formulas with complex logic using SSRS.
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services.
• Experience in analyzing Data ware house by building cubes using SSAS.
• Expert in writing MDX queries with extensive experience in creating and customizing Cubes using SSAS.
• Created and scheduled SQL SSIS Jobs.
• Solid Knowledge in developing cubes using Partitions, KPI’s, and Perspectives, slow moving dimensions etc. and created various user roles.
• Experience in Agile (Kanban and Scrum) and water-fall methodologies.
• Strength in problem solving and effective team player with excellent analytical, troubleshooting, and conflict resolution.
• Designed and developed various abstract classes, interfaces, classes to construct the business logic using C#.NET, VB.NET, ADO.NET
• Designed Dll's for the SSIS packages for scripting task using C#
• Strong experience in mentoring team members and writing documentation.
• Good analytical, written, communicational and interpersonal skills.
• Have proven track record working with various environments and a valuable ability to quickly pick up new technologies and become an asset to the company in a minimal amount of time.

TECHNICAL SKILLS:

DATABASES: MS SQL Server 2005/2008/2008 R2/2012, Oracle

PROGRAMMING: T-SQL, PL/SQL, C, HTML,C# .NET, VB.NET, ADO.NET

WEB TECHNOLOGIES: Active X, Internet Information Services (IIS).

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

OLAP TOOLS: SQL Server Analysis Services (SSAS).

REPORTINGTOOLS: SSRS, Report Builder, Micro Strategy, Click View, Tableau, MS Power BI.

VERSION CONTROL: Team foundation Server (TFS), Visual Source Safe (VSS).

OPERATING SYSTEMS: Windows XP/2007/2010

DATAMODELLING TOOLS: Erwin 4.x/7.x, MS Visio 2000/2003

AGILE TOOLS: Jama 4.0 and Rally

SQL SERVER TOOLS: SSMS, Enterprise Manager, SSDT, Query Analyzer, Profiler, Performance Monitor

PROFESSIONAL EXPERIENCE:

Confidential, Denver, CO

Sr. MSBI Developer/(SSIS, SSRS, SSAS)

Responsibilities:

• Responsible for requirement gathering from Business users.
• Worked in designing, creating and deploying SSIS packages for transferring data from flat files, excels spreadsheets, Oracle, Salesforce and heterogeneous data to and from SQL Server.
• Responsible for analyzing, transforming and visualizing the date using MS Power BI.
• Improved query performance by adding covered indexes, adding file groups etc.
• Implemented SSIS data transformations scripts, created maintenance procedures and provided data integrity strategies.
• Responsible for creating joins, joins with custom SQL & blending data from different data sources using MS Power BI Desktop.
• Done the calculations using MS Power BI (Aggregate, Date, Logical, String, Table, LOD Expressions)
• Implemented data validations using script task and script components.
• Responsible for administering user, user groups, and scheduled instances for reports in Tableau.
• Created and scheduling of Jobs
• Created and deployed Reports utilizing Tableau to design complex reports.
• Scheduled Jobs to run SSIS package using UC4/Atomic scheduler.
• Used DTS Migration Wizard to convert DTS to SSIS packages and develop new SSIS packages.
• Worked on PL/SQL developer to interact with Oracle databases.
• Developing cubes using Partitions, KPI’s, and Perspectives, slow moving dimensions etc. and created various user roles
• Involved in implementing Data blending, Replace references, customized queries and advanced visualizations in Tableau.
• Experience in implementing Data blending, Replace references, Customized queries and advanced visualizations in Tableau.
• Responsible for designing and deploying data visualizations using Tableau.
• Designed Dll's for the SSIS packages for scripting task using C#
• Created packages in SSIS with error handling using various data transformations.
• Creating and managing schema objects such as tables, views, joins, indexes, functions, procedures, CTE’s, triggers & maintaining Referential Integrity.
• Improved query performance by adding covered indexes, adding file groups etc.
• Created and deployed Reports utilizing SSRS to design complex reports.
• Created cascading parameters for SSRS reports as well as drill-down, drill through, sub reports and interactive sorting capability.
• Implemented subscriptions and snapshots in the SSRS Report Manager, report security, report delivery. Integrated reports from SSRS with SharePoint.
• Migrated existing SSIS packages and SQL Server databases to new HIPPA server for security compliance.
• Designed and developed various abstract classes, interfaces, classes to construct the business logic using C#.NET, VB.NET, ADO.NET
• Worked closely with Micro strategy team for reporting requirements.
• Scheduled Jobs to run SSIS package using UC4/Atomic scheduler.

Environment: SQL Server 2008/2012, SQL, Enterprise manager, SSAS, SSIS 2008/2012, SSRS,MDX Cubes, Tableau, MS Power BI, SQL Compare, SQL Data Compare,UC4/Atomic, Rally, SQL Sentry.

Confidential, Broomfield, CO

Sr. MSBI Developer/ Tableau (SSIS, SSRS, SSAS)

Responsibilities:

• Responsible for requirement gathering from Business users.
• Worked in designing, creating and deploying SSIS packages for transferring data from flat files, excels spreadsheets, Oracle, Salesforce and heterogeneous data to and from SQL Server.
• Responsible for analyzing, transforming and visualizing the date using MS Power BI.
• Improved query performance by adding covered indexes, adding file groups etc.
• Implemented SSIS data transformations scripts, created maintenance procedures and provided data integrity strategies.
• Responsible for creating joins, joins with custom SQL & blending data from different data sources using MS Power BI Desktop.
• Done the calculations using MS Power BI (Aggregate, Date, Logical, String, Table, LOD Expressions)
• Implemented data validations using script task and script components.
• Responsible for administering user, user groups, and scheduled instances for reports in Tableau.
• Created and scheduling of Jobs
• Created and deployed Reports utilizing Tableau to design complex reports.
• Scheduled Jobs to run SSIS package using UC4/Atomic scheduler.
• Used DTS Migration Wizard to convert DTS to SSIS packages and develop new SSIS packages.
• Worked on PL/SQL developer to interact with Oracle databases.
• Developing cubes using Partitions, KPI’s, and Perspectives, slow moving dimensions etc. and created various user roles
• Involved in implementing Data blending, Replace references, customized queries and advanced visualizations in Tableau.
• Experience in implementing Data blending, Replace references, Customized queries and advanced visualizations in Tableau.
• Responsible for designing and deploying data visualizations using Tableau.
• Designed Dll's for the SSIS packages for scripting task using C#
• Created packages in SSIS with error handling using various data transformations.
• Creating and managing schema objects such as tables, views, joins, indexes, functions, procedures, CTE’s, triggers & maintaining Referential Integrity.
• Improved query performance by adding covered indexes, adding file groups etc.
• Created and deployed Reports utilizing SSRS to design complex reports.
• Created cascading parameters for SSRS reports as well as drill-down, drill through, sub reports and interactive sorting capability.
• Implemented subscriptions and snapshots in the SSRS Report Manager, report security, report delivery. Integrated reports from SSRS with SharePoint.
• Migrated existing SSIS packages and SQL Server databases to new HIPPA server for security compliance.
• Designed and developed various abstract classes, interfaces, classes to construct the business logic using C#.NET, VB.NET, ADO.NET
• Worked closely with Micro strategy team for reporting requirements.
• Scheduled Jobs to run SSIS package using UC4/Atomic scheduler.

Environment: SQL Server 2008/2012, SQL, Enterprise manager, SSAS, SSIS 2008/2012, SSRS,MDX Cubes, Tableau, MS Power BI, SQL Compare, SQL Data Compare,UC4/Atomic, Rally, SQL Sentry.

Confidential, Dallas, TX

Sr. MSBI Developer (SSIS, SSRS, SSAS)

Responsibilities:

• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Imported data from text files and excel spread sheets into SQL Server database using SSIS package.
• Extensive experience in preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Tiers including Dev, INT, UAT and Production.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Worked on developing Tablix Reports, Matrix Reports, Parameterized Reports, and Sub Reports using SSRS 2008.
• Experience in creating Ad hoc reports Using Report Builder 1.0 and Report Builder 2.0.
• Involved in Migration of SSRS 2005 to SSRS 2008.

Environment: SQL Server 2005/2008 Enterprise Edition, SSAS, SSIS, T-SQL, SSRS, Windows Server 2003, Oracle 11g, Hyperion 11.1, Performance Point Server 2007, Report Builder 2.0.

Confidential, FL

Sr. MSBI Developer(SSIS, SSRS, SSAS)

Responsibilities:

• Worked on the Reports module of the project as a developer on MS SQL Server 2008 (using SSRS, T-SQL, scripts, stored procedures and views).
• Generated Monthly and quarterly Reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS.
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS.
• Used Performance Point Server to create interactive reports with an ability to drill down into details.
• Generated pivot tables using the cube data in SSAS and delivered reports using SSRS by using the connection string as SSAS.
• Involved in building of OLAP cubes with SSAS and in adding calculations using MDX
• Involved in creating Data mappings in SSIS and created data models using ERWIN tool.
• Use DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Wrote custom T-SQL stored procedures, indexes, cursor, functions and triggers to improve performance, preserve referential integrity, and provide additional application functionality.

Environment: SQL Server 2008, SSIS, SSRS, SSAS, OLAP, OLTP, XML, Windows 2000/2003 Server, Erwin, Performance Point Server 2007.

Confidential, Irving, TX

MSBI / SQL Server Developer (SSIS, SSRS)

Responsibilities:

• Analyzing the problems in the production environment and try to develop new procedures and methods for monitoring the problems and send alert messages to take pro-active action.
• Created new database objects like Procedures, Functions, Packages, Indexes and Views using T-SQL in SQL Server 2005.
• Worked on Client tools like SQL Server Management studio to administer SQL Server.
• Data conversions and data loads from various databases and file structures.
• Created SSIS Packages to load the data from different carriers like Verizon, sprint and AT&T.
• Developed SSIS master package which include number of child packages.
• Developed parameterized, caching, sub and Ad Hoc reports using SSRS.
• Wrote Complex SQL Queries to generate Reports based on the business requirement.
• Designed and developed Drill down and Drill through reports using SSRS.
• Created Parameterized reports and Linked reports which navigates to other report.
• Scheduled reports for Daily, Weekly, Monthly reports for various categories and regions based on business needs using Reporting services (SSRS)
• Formatted the reports using the global variables and expressions in SSRS, deployed the generated reports on to the Reporting server.

Environment: Microsoft SQL Server 2005, BIDS, Team Foundation Server (TFS), Windows server 2003, Internet Information Server (IIS), Microsoft Office 2010.