PROFESSIONAL SUMMARY:

Business intelligence IT professional with 6 years of experience in design, development, and maintenance of databases utilizing Microsoft SQL Server Azure SQL/2012/2008R2/2008, BI suite (SSIS, SSAS, SSRS, Power BI), and Tableau within multiple industries such as Banking, healthcare, Retail and Technology.

TECHNICAL SKILLS:

SDLC: Agile, Scrum, Waterfall, and Spiral

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

Data Modeling: ER-win, MS Visio

Business Intelligence Tools: Power BI

Collaboration Tools: SharePoint

Source Control: Team Foundation Server (TFS), Integration Services (SSIS), Analysis Services (SSAS, OLAP Cubes), Reporting Services (SSRS, Report Builder)

Development Tools: BIDS, SSDT, SSMS

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

PROFESSIONAL EXPERIENCE:

Confidential, San Diego, CA

MSBI/ SQL Azure Developer

Responsibilities:

• Involved in project planning meeting with Project Manager, Business Analyst and Team members to analyze the business requirements and outlined the proposed solutions.
• Created logical and physical data models using the Erwin data modeler tool.
• Responsible for identifying sources, creating a staging database, and data warehouse dimensional modeling.
• Implemented normalization and de-normalization of existing tables wherever needed for faster query processing.
• Wrote SQL scripts to perform data validation post data load process.
• Implemented SQL queries into stored procedures utilizing execution plan and indexes for better performance.
• Identified types of slowly changing dimensions required for the data mart.
• Maintained data integrity by creating various integrity constraints.
• Managed ETL for extraction, transformation, and loading of data to the destination database.
• Developed mappings utilizing SSIS to transform data from multiple sources: Excel, Flat File, and SQL Server OLTP.
• Implemented SSIS packages with loggings and event handlers for error handling.
• Worked on implementing transactions for billing details and checkpoints in the packages for optimizing the performance.
• Restructured ETL packages with optimized queries and proper transformations for faster data loading.
• Generated parameterized, cascading parameterized, drill down, and drill through reports.
• Delivered on-demand reports in different rendering formats with standard and data driven subscriptions.
• Optimized embedded queries or stored procedures that generate reports.
• Created analytical reports and dashboards utilizing Tableau.
• Deployed SSIS packages from development server to production server utilizing project deployment model.
• Configured database server on cloud for required users per business requirement.
• Worked with azure team for loading dimension tables, and loading fact tables in Microsoft Azure environment.
• Migrated SQL 2012 on premise databases on cloud utilizing SQL Server Azure (PaaS).

Technical Environment: SQL Server 2012, SSIS, SSRS, SSMS, SSDT, MS Visio, ER-Win, TFS, SQL Azure Database, Azure Storages, Tableau.

Confidential, San Diego, CA

MSBI Developer

Responsibilities:

• Generated T SQL scripts for tables and relationships based on approved ER diagram.
• Developed stored procedures for performing various tasks on databases.
• Implemented execution plan, indexes and dynamic sql to optimize sql queries such as stored procedures and UDFs.
• Implemented error handling in procedures utilizing try-catch block, and raiserror and throw functions.
• Created complex ETL packages to pull data from Oracle and MS Access into SQL server.
• Implemented event handlers, logging and error row redirect to handle run time errors on production server.
• Maintained master/child package model for flexible execution.
• Deployed SSIS packages to the production server utilizing project deployment model with parameter configuration.
• Adopted drill down, drill through, and parameter functionality for reports with multiple pages.
• Developed best suitable user interface for management dashboards with Power Pivot and Tableau.
• Designed, developed, and deployed a highly scalable SQL Azure database utilizing T-SQL stored procedures, and views.
• Managed development work on Team Foundation Server (TFS).

Technical Environment: SQL Server 2012, SSDT, SSIS, SSRS, Erwin, MS Excel, Power BI, TFS

Confidential, Newark, Delaware

BI Developer

Responsibilities:

• Evaluated data in the source databases and mapped with OLAP destination.
• Analyzed the historical data and extracted required data to support the management decisions.
• Maintained required business logic with stored procedures, user defined functions, CTE and dynamic SQL.
• Optimized Sql queries utilizing execution plan, indexes and batch processing.
• Implemented incremental load utilizing CDC and checksum/timestamp.
• Designed SSIS packages to process SSAS cubes in differed processing modes.
• Deployed SSIS packages from development server to production server utilizing package deployment model.
• Created test cases for conducting unit tests on database objects and ETL packages.
• Created and deployed cubes depending on business needs for slicing and dicing of data.
• Allocated storage modes such as MOLAP, HOLAP and ROLAP based on data usage.
• Created report data models with Report builder for ad-hoc reporting.
• Created reports with filters, interactive sorting, and parameters.

Technical Environment: SQL Server 2008R2/ 2012, SSIS, SSRS, BIDS, SQL Profiler, Erwin

Confidential, Irvine, CA

SSIS Developer

Responsibilities:

• Interacted with business users to meet needs of both compliance regulations and business requirements.
• Encapsulated frequently used SQL queries into stored procedures or UDFs.
• Created multiple SSIS packages to migrate data from Excel and SQL Server sources.
• Designed several SSIS packages; included proper error handling, optimization, and configuration techniques.
• Migrated SSIS packages from staging to production environment.
• Automated ETL process with SQL Server Agent to execute packages during off hours.
• Deployed SSIS packages to multiple environments utilizing the functionality of package configurations.
• Created multiple reports for differing departments utilizing SQL scripts and stored procedures as data sets.
• Exported business data to Excel for further analysis utilizing SSRS, Power Pivot.

Technical Environment: SQL Server 2008 R2, SSIS, SSRS, BIDS, SQL Profiler, MS Visual Studio, MS Excel

Confidential, Hillsboro, OR

SQL/Report Developer

Responsibilities:

• Created database objects such as procedures, functions, and views.
• Supported front end applications; created stored procedures and user defined functions to facilitate data entry.
• Implemented indexes on tables and views for optimizing performance.
• Altered existing procedural objects to implement changed business logic.
• Maintained performance of SQL Server; including integrity checks, and re-indexing.
• Created various reports such as drill down, cascaded parameterized, drill through, sub report, linked report utilizing reporting services.

Technical Environment: SQL Server 2008, SSMS, BIDS, SSRS, SQL Profiler, MS Excel

Confidential, Atlanta, GA

SQL Developer

Responsibilities:

• Created new database objects such as procedures, functions, packages, triggers, indexes, and views with T-SQL.
• Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning.
• Updated the statistics information for both the old and new servers.
• Assisted with various ad hoc query requests.
• Provided back-end support for functional testing and performance testing.

Technical Environment: SQL Server 2008, SSMS, BIDS, SQL Profiler, MS Excel