SUMMARY:

• Dedicated BI developer with 7 years of experience in development and maintenance of database/business intelligence applications. Proficient with SQL Server, BI Stack, Power BI, Tableau, and Azure within large and complex environments.

TECHNICAL SKILLS:

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

T-SQL Programming: Dynamic SQL

Data Modeling: ER-win, MS Visio

Development Tools: BIDS, SSDT, SSMS

Integration: Services (SSIS)

Analysis Services: (Multidimensional/Tabular Cubes)

Reporting Services: (SSRS, Report Builder)

BI Tools: Power BI, Tableau

Collaboration Tools: SharePoint

Source Control: Team Foundation Server (TFS)

Microsoft Azure: Cloud 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

PROFESSIONAL EXPERIENCE:

Confidential, Princeton, NJ

SQL/BI Developer

Responsibilities:

• Analyzed business needs and documented the functional requirements via JAD meetings.
• Created logical model and defined various constraints utilizing ER-Win for data mart.
• Implemented complex business logic utilizing various procedures and functions written in SQL.
• Designed indexes and indexed views to speed up query performance and utilized SQL Profiler for further suggestions.
• Maintained historical data in OLAP data mart using checksum and timestamp methods.
• Developed SSIS packages for data profiling and data scrubbing utilizing multiple tasks and transformations.
• Utilized event handlers, custom logging (with C#.Net) and error row redirect to handle run time errors in SSIS packages.
• Passed parameter values from parent package to child package using parameter-variable binding.
• Configured SSIS packages utilizing parameters and expression to make them dynamic.
• Deployed SSIS packages to testing and production environments utilizing project deployment model.
• Monitored the entire ETL process and resolved any issues with the help of error logs.
• Summarized the data in the reports adopting drill down functionality in SSRS.
• Enhanced performance of reports by utilizing caching and snapshot techniques.
• Managed roles on report manager to handle security of reports
• Designed dashboards using Power BI with rich visuals such as charts, slicers, gauges, funnel, word cloud.
• Delivered reports in different rendering formats utilizing standard and data driven subscriptions based on client demand.
• Deployed SSRS reports to the reporting server and assisted in troubleshooting deployment problems.
• Supported deployment process by checking in all DBOs with documentation to Team Foundation Server.
• Migrated data from on-premises data servers onto Microsoft Azure cloud platform utilizing Azure data factory.
• Configured the cloud databases for HA solutions with Geo-replication.

Confidential, San Diego, CA

SQL/BI Developer

Tools: and Environment: Microsoft SQL Server 2012, SSDT, SSMS, SSIS, SSRS, T-SQL, TFS, DTA, Tableau, C#.Net, Visual Studio

Responsibilities:

• Collaborated with the project team and business users to gather business requirements.
• Created Entity Relationship (ER) diagrams for the proposed data mart.
• Wrote complex stored procedures for operations such as incremental load utilizing timestamp and index maintenance.
• Implemented error handling techniques such as try-catch blocks, @@error variable, and raiserror functions in scripts and stored procedures.
• Communicated and coordinated with clients to understand business needs and expectations from the ETL Process.
• Created ETL strategies to populate the OLAP data-mart with facts and dimensions.
• Designed mappings between sources to operational staging targets utilizing star schema.
• Maintained master/child package model for flexible execution of complex ETL packages.
• Wrote C#.Net script to load data from text files skipping header and footer records.
• Configured SSIS packages with parameters and deployed in the SSISDB catalog utilizing project deployment model.
• Created OLAP cubes to facilitate the reporting application.
• Created aggregations and user-defined hierarchies for OLAP cubes and KPIs.
• Created various SSRS reports such as drill down, drill through, cascaded parameterized, multivalued and cross tab reports per business requirements.
• Subscribed SSRS reports utilizing standard and data driven subscription with a multitude of rendering formats such as pdf and excel for better content visualization.
• Designed various dashboards and score cards to support analysis utilizing Tableau desktop.
• Deployed Tableau dashboards to Tableau Server and setup refresh schedules.
• Tracked changes in SQL code and the BI application in Team Foundation Server.

Confidential, Philadelphia, PA

SQL BI Developer

Tools: and Environment: MS SQL Server 2008R2, BIDS, SSIS, SSAS, SSRS, Erwin, TFS, Excel, Tableau, SQL Profiler, DTA, Windows Server

Responsibilities:

• Documented changes made to various database objects such as procedures and functions.
• Designed data marts involving bottom-up approach and star schema.
• Defined constraints on tables to improve the data quality; primary key, foreign key, check.
• Optimized queries utilizing tools such as SQL Profiler and Database Engine Tuning Advisor (DTA).
• Utilized covering indexes to avoid RID and key lookups as a part of TSQL query optimization strategy.
• Identified dimensions and facts to be include in OLAP data mart through analysis of multitude of OLTP data sources.
• Designed and optimized ETL packages dealing with different data sources (SQL Server, Flat Files, Excel and XML).
• Utilized script task and script component to design C# scripts to deal with the flat files inconsistencies.
• Redirected error outputs to error tables to identify dimensions and facts that were not properly populated.
• Configured SSIS packages with XML files and deployed in the MSDB database utilizing package deployment model.
• Wrote SQL-based tests and audit scripts to validate SSIS packages and data loads.
• Utilized MOLAP storage modes and proactive caching for SSAS cubes.
• Designed usage based optimizations for better query performance in SSAS as per business requirement.
• Maintained different versions of documents on Team Foundation Server (TFS).
• Utilized SSRS as the reporting tool to create, design and manage complex reporting structures for drill down, drill through, and ad-hoc reports based on user needs.
• Developed user interactive dashboards, multiple chart types, trends, and KPIs utilizing Tableau.
• Utilized conditional formatting to create reports which were visually appealing and descriptive representations.
• Performed optimization of reports using a multitude of SSRS report optimization techniques at report level and query database level.

Confidential, Moorestown, NJ

BI Developer

Tools: and Environment: MS SQL Server 2008R2, BIDS, T-SQL, SSMS, SSIS, SSAS, SSRS, Excel, ER-win, SQL Profiler, DTA, SharePoint, Excel Power Pivot

Responsibilities:

• Coordinated with business users to clarify business requirements.
• Implemented database integrity per business requirement utilizing database constraints and triggers.
• Implemented error handling techniques in SQL Server such as scripts and procedures utilizing try-catch statements, throw and raiserror functions.
• Identified dimension and fact in DWH enhancement utilizing Kimball approach.
• Designed and developed ETL Framework using SSIS.
• Extracted and loaded data from multiple sources (Excel, flat files, SQL Server) to the staging area for integrating it with newly created data mart.
• Performed data profiling, cleansing, validation, and verification with SSIS tasks and SQL stored procedures in pre-staging and staging environment.
• Implemented master-child package models to improve the performance of the complex ETL strategy.
• Implemented SSIS packages utilizing checkpoint, logging, breakpoint, and transaction options.
• Configured the properties of SSIS packages using SQL Server configurations.
• Delivered on-demand and scheduled reports for business analysis and management decisions utilizing SSRS.
• Collaborated with the Team Foundation Server to update project documents, scripts, and packages.

Confidential, West Chester, PA

SQL Developer

Tools: and Environment: SQL Server 2008, SSMS, T-SQL, SSIS, Erwin, SQL Profiler, DTA, Windows Server, Excel

Responsibilities:

• Participated in JAD sessions to understand the scope of requirements and drafted functional requirement documents.
• Created application prototypes during the development phase.
• Developed logical and physical data models with Erwin.
• Modified temporary tables, indexes, and lookup techniques to optimize stored procedures.
• Optimized SQL queries utilizing execution plans, indexes and batch processing.
• Embedded complex SQL queries and procedures in SSIS Packages based on business requirements.
• Implemented transactions with multiple isolation levels and locks technique to avoid dirty reads and deadlocks in SQL.
• Developed complex SSIS packages to extract data from various heterogeneous sources such as SQL Server database, flat files, excel files to be loaded into existing data warehouse.
• Optimized SQL scripts and stored procedures with SQL profiler and tuning advisor.