SUMMARY:

• BI Consultant with an experience of 7 years in design and development of Business Intelligence applications using Microsoft SQL Server in various domains.
• Possess strong conceptual and logical data modeling skills.
• Gained experience with JAD sessions for requirements gathering, creating data mapping documents, and writing functional specifications.
• Merit of creating complex stored procedures to perform incremental loads utilizing timestamp techniques.
• Successfully utilized ETL (SSIS) to develop jobs for extracting, cleansing, transforming, and loading data into the data warehouse.
• Excellent understanding of SSRS with report authoring, report management, report delivery and report security and created reports with analysis services cube as the data source using SSRS.

IT SKILLS:

Cloud Experience: Data Factory, PowerShell, Azure Storage (BLOB, Tables, Queues, and File Share), MS Azure (IaaS, PaaS, SaaS), Azure SQL, Azure Data Warehouses

Database: SQL Server 2016, 2014, 2012, 2008/R2

SDLC: Agile, Scrum, Waterfall, and Spiral

Data Modeling: ER - win, MS Visio

Database Programming: T-SQL, Dynamic SQL, MDX, DAX

Development Tools: BIDS, SSDT, SSMS

Integration Tool: SSIS

Analysis Services: SSAS, OLAP Cubes, Tabular Model

Reporting Tools: SSRS, Tableau Desktop, Power BI, Excel Power BI

Source Control & Collaboration Tool: Team Foundation Server (TFS), SharePoint

Programming Languages: Java, C++, C#, C, Python, JavaScript

WORK EXPERIENCE:

Confidential, Scottsdale, AZ

MS BI Developer

Responsibilities:

• Gathered business requirements from JRD sessions with business analysts, project managers and developers.
• Created logical and physical design phases of the data mart utilizing Erwin as data modeler tool.
• Expanded the Physical Data Model or the OLTP application utilizing Erwin.
• Wrote complex SQL queries using scalar and table variables which held user inputs and performed business logic.
• Optimized the performance of T-SQL queries and SSIS packages.
• Improved the performance of SQL codes, procedures, and functions with SQL Profiler and DTA.
• Created data mapping documents for incorporating the ETL strategy utilizing SSIS.
• Utilized multiple transformations in SSIS to meet the business requirements by extracting data from heterogeneous source systems, transforming and finally loading into the staging database.
• Established error handling procedures in SSIS packages with event handlers, row redirects, checkpoints, and loggings.
• Developed master/child packages to reduce complexity of large ETL packages.
• Utilized parameters to configure SSIS packages, improving the migration process.
• Examined the performance of SSIS packages and optimized as required.
• Successfully conducted test script/SSIS package reviews.
• Configured partition for SSAS cubes to use different storage modes such as MOLAP, HOLAP, and ROLAP to enhance performance.
• Formulated Power BI scorecards utilizing stack bars, bar graphs, geographical maps, KPIs, and gauges to help in analysis of data insights.
• Participated in the configuration of on-premises Power BI gateway to refresh datasets of Power BI reports and dashboards.
• Created a variety of reports using SSRS including matrix report, parameter report, dashboard, charts, drill-down, drill- through, cascade parameterized report, and configured report server.
• Generated on-demand and scheduled reports with SSRS for business analyses and managerial decisions.
• Created sub, drill-down, summary, and matrix reports in SSRS.

Tools: & Environment: SQL Server 2016, Erwin, T-SQL, SQL Profiler, SSAS, SSRS, SSMS, SSDT, Power BI, TFS, DTA

Confidential, Richmond, VA

SQL BI Developer

Responsibilities:

• Collaborated with the design architect and business analyst to outline business requirements in JRD meetings.
• Designed OLAP data model using Star schema with the use of design software such as Erwin.
• Performed data modeling (Star schema) with Erwin for the ETL strategy.
• Incorporated error handing techniques such as try catch and error functions to create robust T-SQL code.
• Conducted data profiling, cleansing, validation, and verification with SSIS tasks and SQL stored procedures.
• Created a SQL Server job in SSMS for package executions.
• Conceptualized ETL strategies to populate the data warehouse/data-mart with facts and dimensions.
• Incorporated error redirection during ETL loads in SSIS packages.
• Gained experience with SSIS performance tuning using counters, error handling, event handling, and re-running of failed SSIS packages using checkpoints and scripting.
• Created sophisticated calculated members using MDX queries and designed and created aggregations to speed up queries and improve performance in SSAS.
• Customized roles and KPIs using multi-dimensional expressions (MDX).
• Designed and implemented SSRS reports such as drill-down, drill-through, sub, and parameterized reports.
• Created a multitude of reports and dashboards with SSRS.
• Built ad hoc reports, parameterized reports, tabular, cross-tab, drill-down, drill-through, chart reports, and reports with sub reports using SSRS.
• Designed dashboards in Tableau using bar charts, straight tables, pie charts, dual combination charts, filled maps, and so on, to make it more accessible to users.
• Gained extensive knowledge in various reporting objects such as facts, attributes, hierarchies, transformations, filters, prompts, calculated fields, sets, groups, parameters, and so on, in Tableau.

Tools: & Environment: SQL Server 2012, Erwin, T-SQL, SSDT, SSAS, SSRS, SSMS, Tableau, MS Excel, TFS, DTA

Confidential, Mayfield, OH

SQL BI Developer

Responsibilities:

• Outlined functional requirements by collaborating with development team in JAD sessions.
• Created logical and physical data models using the Erwin data modeler tool
• Designed the technical specifications document for ETL processing of data into master data warehouse and strategized the integration test plan and implementation.
• Incorporated error handing techniques such as 'Try Catch' to create a robust T-SQL code.
• Scripted T-SQL queries, ranking functions, derived tables, common table expressions (CTEs), stored procedures, views, user defined functions (UDF), constraints, and database triggers.
• Established indexes on OLTP/OLAP tables to improve navigation performance within large datasets.
• Developed packages which schedule maintenance tasks, process cubes, and import files from the data warehouse.
• Performed data profiling, cleansing, validation, and verification with SSIS tasks and SQL stored procedures.
• Implemented logic for incremental load utilizing checksum, time stamp, and SQL Server CDC concepts.
• Deployed and configured SSIS packages to the production server with parameters in the SSISDB catalog.
• Gained experience in error and event handling and precedence constraints, break points, check points, and logging using SSIS.
• Defined Star schema, OLAP cubes and dimensions with SSAS.
• Developed ad-hoc, parameterized, drill-down, and drill-through reports with parameters in SSRS.

Tools: & Environment: SQL Server 2012, Erwin, T-SQL, SQL Profiler, SSAS, SSRS, SSMS, SSDT, SQL Profiler, DTA Windows Server

Confidential, Philadelphia, PA

BI/ETL Developer

Responsibilities:

• Analyzed the business requirements in JAD sessions to understand the business requirements.
• Performed dimensional modeling with Erwin and designed and built relational data mart.
• Developed and deployed database objects such as stored procedures, triggers, indexes, views, and UDFs in SQL Server.
• Enforced business rules by creating constraints in both the production and relational data warehouse databases.
• Wrote complex stored procedures, user-defined functions, and triggers as per business requirements.
• Enhanced existing procedures, triggers, UDF, and views with execution plans, SQL Profiler, and DTA.
• Communicated with the clients to understand business needs and expectations from the ETL Process.
• Developed SISS packages to extract, transform, and load data from OLTP servers to the OLAP database.
• Optimized cubes by assigning appropriate storage modes to partitions, thereby improving query performance.
• Utilized MOLAP storage modes and proactive caching for SSAS cubes.
• Generated reports utilizing SSRS and Excel with Power Pivots and deployed reports in SharePoint integrated mode.

Tools: & Environment: SQL Server 2008 R2, Erwin, T-SQL, SQL Profiler, SSRS, SSMS, BIDS, MS Visual Studio, MS Excel, TFS

Confidential, Philadelphia, PA

SQL Developer

Responsibilities:

• Gathered requirements and specifications from business analysts and end-users.
• Worked closely with solutions architect to design dimensional and data models.
• Incorporated dynamic SQL to develop customizable queries, answerable by the OLTP Server.
• Wrote objects such as stored procedures, functions, DDL/DML triggers, and indexes with SQL/T-SQL.
• Monitored and resolved deadlocks in SQL Server databases with locks, isolation levels, and SQL Profiler.
• Enhanced the performance of SSIS packages with non-blocking transformations and multiple properties.
• Deployed SSIS packages into an MSDB database on the production server.
• Created SSIS packages for data scrubbing, aggregating, and cleansing with multiple tasks/transformations.
• Built SSAS cubes to facilitate the reporting of the business based on historical and current data.
• Managed the report server to enable saved reports browsing within SharePoint integrated mode.

Tools: & Environment: SQL Server 2008, T-SQL, SQL Profiler, SSMS, BIDS, SSRS, DTA, Windows Server, TFS