PROFESSIONAL SUMMARY:

Business Intelligence professional with more than 6 years of IT experience in analysis, design, development, testing and maintenance of database and data warehouse utilizing Microsoft SQL Server 2012/2008R2/2008, BI suite (SSIS, SSAS, SSRS, SharePoint, Power BI) and Tableau within various industries including technology, healthcare, insurance and IT.

TECHNICAL KNOWLEDGE:

Database: MS - SQL Server 2012/2008R2/2008/Azure SQL

T-SQL Programming, Dynamic SQL, C#.Net, HTML, CSS, VB, Core Java, JSP:

Data Modeling: ER-win, MS Visio

BI Tools: Power BI, Power Pivot, Tableau

Testing: Quality Center (HP Life Cycle Management tool), Integration Services (SSIS), Analysis Services (SSAS, OLAP Cubes), Reporting Services (SSRS, Report Builder)

Development Tools: BIDS, SSDT, SSMS, Visual Studios

Source Control: Team Foundation Server (TFS), GITHUB

Microsoft Azure: Cloud Services (PaaS & IaaS), PowerShell Azure SQL Database (PaaS), Azure Storages (Blob, Tables, Queues), Backup/Recovery, Azure Data Factory

SDLC: Agile, Scrum, Waterfall, and Spiral

Collaboration Tools: SharePoint 2013, PerformancePoint Services

PROFESSIONAL EXPERIENCE:

Confidential, San Diego, CA

MS BI Developer

Technical Environment: Erwin, SQL Server 2012, TSQL, SSIS, SSRS, SSDT, SQL Azure, Tableau, C#.Net TFS, MDX, Power BI, SharePoint (Performance Point Services).

Responsibilities:

• Collaborated with managers, business analysts, and business users to gather business requirements.
• Wrote complex stored procedures, views, triggers, and user-defined functions to implement business logic structures.
• Enhanced stored procedure performance and rectified parameter sniffing issues with SQL profiler.
• Implemented ER-Win data modeler to design dimensional models of the data mart with star schema.
• Designed data mappings from source to target tables on the OLAP data mart design.
• Developed SSIS packages for the ETL process; loaded and transformed data from multiple sources into the data mart.
• Implemented SSIS transformations for data scrubbing and validation checks prior to loading into the data mart.
• Implemented advanced SSIS features such as event handlers and data viewers.
• Utilized C# to design user friendly application wherein user can browse and select excel and flat files as data sources to perform ETL strategy.
• Implemented script task in SSIS utilizing C# script to modify the value of the variables based on the requirement and sent it back as a new column to be added in data source.
• Created calculated members, KPIs, and perspectives, supporting analytical applications and dashboards.
• Designed multiple reports with SSRS report designer for business analyses.
• Utilized Power BI to design and deploy analytical reports/dashboards from tabular models, assisting with KPI analyses.
• Deployed SSRS reports to the report server in SharePoint integrated mode and rectified deployment problems.
• Provided report access security at server, report, and report item levels.
• Delivered reports with standard and data-driven subscriptions.
• Created action filters, parameters, and calculated sets for preparing dashboards and worksheets utilizing Tableau.
• Implemented actions, sets, groups, and hierarchies features in Tableau.
• Generated dashboard with quick/context/global filters, parameters and calculated fields utilizing Tableau.
• Implemented TFS for version control and change management of BI solution for cross-functional communications.
• Configured database server on cloud for required users per business requirement.
• Created storage, resource group, and virtual machines in MS Azure.
• Assisted in setting up test bed to migrate data from on premise SQL server 2012 to the cloud environment mapping the functionality and performance of MS Azure compared to on premise one.

Confidential, Redwood City, CA

BI Developer

Technical Environment: SQL Server 2012, T-SQL, SSDT, SSIS, SSAS (Tabular), SSRS, Tableau, Erwin, C#.Net, MDX, DAX, SharePoint, Power BI, PerformancePoint Services (PPS).

Responsibilities:

• Updated status of project in daily scrum as well as project status meetings.
• Wrote complex SQL queries utilizing joins, sub-queries, and common table expressions (CTEs) to acquire business related data.
• Optimized inefficient queries by analyzing execution plans, creating indexes, and utilizing SQL profiler.
• Created packages with varying transformations to perform data scrubbing/cleansing.
• Designed SSIS packages to track non-loaded dimensions and fact rows utilizing the redirect error output feature.
• Enhanced existing SSAS Tabular model cubes, perspectives, aggregations, and Calculated Measures for reporting.
• Customized KPI’s and calculations utilizing Data Analysis Expressions (DAX) in SSAS Tabular.
• Implemented row level filters in Tabular cube data utilizing read or process roles.
• Wrote complex queries in SSRS to generate a multitude of reports such as drill down, drill through, sub-reports, and parameterized reports.
• Generated SSRS reports from cubes and SSAS tabular models.
• Scheduled reports utilizing subscriptions and shared schedules.
• Improved the performance of reports by creating snapshots/cached reports checking execution logs.
• Created ad-hoc reports with PowerPivot and performance point services.
• Utilized TFS for source control and changing the management of BI and SQL codes.
• Performed end to end testing of the application, worked on defect logging and tracking.
• Prepared test plan, test scenarios, test cases, test summary reports including regression testing.

Confidential, Dallas, TX

BI Developer

Technical Environment: SQL Server 2008R2, T-SQL, BIDS, SSIS, SSAS, SSRS, MDX, Erwin, TFS, SharePoint.

Responsibilities:

• Collaborated with business analysts and gathered system specification requirements for the project.
• Created new database objects such as procedures, functions, indexes, and views with T-SQL logics.
• Developed complex mappings with SSIS to transform and load data from multiple sources into the SQL server database.
• Implemented business logics with built-in transformations such as SCDs, aggregates, lookups, and data conversions.
• Designed data mart to store patient scheduling information by following In-mon methodology.
• Created SSAS cubes to facilitate the business reporting based on historical and current data.
• Designed business reports with SSRS and Power BI on the top of the OLAP cube and data mart.
• Developed customized KPI’s utilizing multi-dimensional expressions (MDX).
• Designed reports with features such as groups, actions, sub-reports, document maps, and conditional formatting in SSRS.
• Created source-to-target data mappings with the required transformations.
• Enhanced report performance with optimized data-sets, parameters, caches, and snapshots.
• Implemented report security at server, report, and item levels.
• Manipulated TFS to synchronize data/codes among the team.

Confidential, Houston, TX

BI Developer

Technical Environment: SQL Server 2008R2, SSIS, SSRS, SSAS, BIDS, MS Excel, HP Quality Center.

Responsibilities:

• Collaborated with business users and gathered business requirements for the project.
• Analyzed functional requirements to design a staging database and dimensional model of the OLAP database.
• Wrote complex queries, stored procedures, and UDFs to support the ETL process, front end applications, and reports.
• Implemented business-specific rules and advanced constraints by embedding DML triggers on tables.
• Performed software testing utilizing Application Life Cycle Management (Quality Center) tool.
• Created complex SSIS packages to consolidate data from Flat File, Excel, loaded data into to SQL server.
• Implemented error and failure handling in SSIS packages with event handlers, row redirects, and precedence constraints.
• Optimized packages with non-blocking transformations and parallel task executions.
• Created attribute hierarchies and stored cube in MOLAP storage mode for better performance.
• Secured part of SSAS cube utilizing perspectives.
• Created multiple reports (parameterized, drill down, and sub reports) to support business needs.
• Designed and deployed report models on report manager for ad-hoc reporting.
• Configured the report server to deploy reports in SharePoint integrated and native modes.
• Secured reports as per report information sensitivity levels utilizing role based security.
• Administered reporting services to schedule report executions, deliveries, and tracking report history.

Confidential, Chevy Chase, MD

BI Developer

Technical Environment: SQL Server 2008 R2, BIDS, T-SQL, SSIS, SSAS, SSRS, Flat File, HP Quality Center, Excel.

Responsibilities:

• Gathered system requirements by collaborating with the BA, DA, and project manager in JRD meetings.
• Created stored procedures and user defined functions to facilitate the automation of data entry by a front-end application.
• Maintained the OLAP dimensional model of the claims process based on the data warehouse’s dimensions and facts.
• Designed Test Matrices and priorities of bugs utilizing HP Quality Center.
• Created SSIS packages to extract data from various sources such as Flat files, Excel, and SQL.
• Utilized various transformations in SSIS to perform ETL operations such as data profiling, data cleansing, and data verification.
• Optimized the performance of existing ETL strategy by taking into account new advanced SSIS features and by re-writing the existing package business logic.
• Utilized Indexing, Partitioning and multitude of TSQL query optimization strategies following Microsoft best practices to improve the performance of data fetch from data mart for faster report generation.
• Debugged runtime errors by implementing event handlers in SSIS packages.
• Optimized cubes utilizing usage-based aggregations and appropriate storage modes (MOLAP, HOLAP and ROLAP).
• Devised complex expressions for calculations, groupings, filters, and formatting contents of SSRS reports.
• Developed a multitude of reports with SSRS including tabular form, matrix, chart, sub, drill down, and drill through reports.
• Streamlined report security for various users using SSRS report manager.

Confidential, Franklin, TN

SQL Developer

Technical Environment: SQL Server 2008/R2, BIDS, T-SQL, SSIS

Responsibilities:

• Created technical design specification documents based on BRD via JAD sessions.
• Designed high-level normalized databases with ER-Win.
• Enforced data integrity with constraints and triggers.
• Wrote stored procedures, triggers, indexes, and views with SQL Server.
• Optimized the performance of existing TSQL queries utilizing Microsoft best practices as well as SQL Profiler and DTA.
• Wrote queries with joins and common table expressions to simplify complex queries involving multiple tables.
• Enhanced the performance of inefficient queries with SQL profiler and DTA.
• Wrote ETL SSIS packages to move data from flat files and excel files to be loaded into existing data mart as per business requirements.
• Enhanced features of front-end applications utilizing core Java to modify the look and feel of the application on a timely basis.