PROFESSIONAL SUMMARY:

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

TECHNICAL SKILLS:

Database: MS SQL Server 2016/2012/2008 R2/2008 T - SQL Programming, Dynamic SQL, C#.Net

Data Modeling: Erwin, MS Visio

BI Tools: Power BI, Power Pivot, Tableau Integration Services (SSIS), Analysis Services (SSAS, OLAP Cubes), Reporting Services (SSRS, Report Builder)

Development Tools: BIDS, SSDT, SSMS

Web Tools: CSS, HTML

Source Control: Team Foundation Server (TFS)

Microsoft Azure: Cloud Services (PaaS & IaaS), PowerShell, Azure SQL Database (PaaS), Azure Storages (Blobs, Tables, Queues)

Backup/Recovery: Azure Data Factory, Azure SQL Data Warehouse

SDLC: Agile, Scrum, Waterfall, and Spiral

Collaboration Tools: SharePoint 2013/2010

PROFESSIONAL EXPERIENCE:

Confidential, EL Segundo, CA

SQL/SSRS Developer

Technical Environment: SQL Server 2012, Visual Studio 2010, SSRS, Report Builder, Oracle Sql developer, SSMS

Responsibilities:

• Involved in Daily, Weekly Status Meetings with the team Members, PM and the Leads.
• Wrote Complex SSRS Expressions and built the reports in Adhoc Tool called Report Builder.
• Wrote SQL scripts and built reports in SSRS.
• Utilized derived tables, temporary tables and Common table Expressions in SQL.
• Developed complex reports with multiple datasets and heterogeneous sources and created the automation process of report generation and distribution in SSRS.
• Exported data from SSRS report to several file formats likes PDF and Excel according to the needs of management.
• Enhanced the Reports by updating the embedded Scripts in SSRS to the Stored Procedures.
• Wrote Code sourcing Oracle Database by Connecting Reporting Services (SSRS) through ODBC.
• Worked on the Enhancements of Existing Reports and Fixed Bugs in the PROD Environment.
• Created New Reports with Minimal Requirements by Communicating with the Business Users.
• Used Drill down, Drill Through, Parameterized functionality in the reports.
• Deployed Reports to Report Center/ Reporting Services Portal.

Confidential, Rancho Cucamonga, CA

SQL/SSRS Developer

Technical Environment: SQL Server 2016, SSIS, SSRS (rdlc, rdl), SSMS, SSDT, MS Visio, ER-Win, C#,XML.

Responsibilities:

• Participated in daily, weekly stand up meetings with PM and other leads to discuss the status of the project.
• Developed complex stored procedures and user defined functions involving with multiple tables and views.
• Wrote SQL scripts with different types of temp tables and common table expressions to carry out the business logic.
• Improved performance of queries used as data sets for SSRS reports.
• Adopted drill down, drill through, and parameter functionality for reports with multiple pages.
• Delivered various reports in multiple rendering formats with data driven subscriptions to users.
• Created letters and reports with RDLC (Report Definition Language Client Side) and RDL (Report definition Language) files in SSRS.
• Debugged issues with C# code and XML in RDLC files.
• Configured data Sources and used shared and embedded datasets in SSRS reports.
• Created SSIS ETL packages to attach the letters to its respective events by extracting data from different sources and loading to the different destinations such as SQL server, flat file and excel file.
• Developed new reports and optimized existing reports to meet the user needs.
• Analyzed reports and used complex expressions and fixed bugs in stored Procedures.
• Managed development work on Team Foundation Server (TFS).

Confidential, San Diego, CA

SQL/SSRS Developer

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

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 Pre-staging and staging database, and data mart utilizing dimensional modeling.
• Implemented normalization and de-normalization of existing tables wherever needed for faster query processing.
• Implemented SQL queries into stored procedures utilizing execution plan and indexes for better performance.
• Generated parameterized, cascading parameterized, drill down, and drill through reports in SSRS.
• Optimized embedded queries or stored procedures that generate reports utilizing SSRS.
• Created dashboards with charts, graphs that convey meaningful data and insights utilizing power view.
• Improved the performance of SSRS reports by optimizing data sets, making use of report caching and snapshots.
• Performed various report administration action utilizing report manager, defined shared schedule, and created and managed different users in SSRS.
• Configured database server on cloud for required users per business requirement.
• Migrated SQL 2012 on-premises databases to the cloud utilizing SQL Server Azure (PaaS).

Confidential, San Diego, CA

SQL/SSRS Developer

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

Responsibilities:

• Involved in DataMart planning meeting with Project Manager, Business Analyst and Team members to analyze the business requirements and outlined the proposed solutions.
• Developed stored procedures for performing various tasks on databases.
• Implemented execution plan, indexes and dynamic SQL to optimize queries such as stored procedures and UDFs.
• Implemented error handling in procedures utilizing try-catch block, and raiserror.
• Created various data connections from data source to SSRS for report and dashboard development.
• Created parameterized reports, drill down reports & summary reports by utilizing SSRS.
• Created document map for easy navigation to the particular section of the SSRS report.
• Scheduled reports execution on daily basis in order to support the incremental load of the databases in SSRS.
• Developed best suitable user interface for management dashboards with Power Pivot.

Confidential, Newark, DE

BI/SSRS Developer

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

Responsibilities:

• Evaluated data in the source databases and mapped with OLAP destination.
• Analyzed the historical data and extracted required data to support management decision making.
• Maintained required business logic with stored procedures, user defined functions, CTE and dynamic SQL.
• Optimized SQL queries by utilizing execution plan and indexes.
• Improved the performance of the tasks in the control flow level by replacing it with new tasks.
• 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 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 in SSRS.
• Created reports with filters, interactive sorting, and parameters in SSRS.
• Generated reports utilizing SSRS and Excel power pivots with expanded data capacity, advanced calculations and deployed them on SharePoint Server.

Confidential, Irvine, CA

SSRS Developer

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

Responsibilities:

• Interacted with business users to gather business requirements.
• Encapsulated frequently used SQL queries into stored procedures or UDFs.
• Created complex stored procedures with proper error handling, transactions and performance tuning features.
• Created tables, views, stored procedures, functions, CTEs and indexes in support of various databases and reports applications.
• Created several reports using SSRS like drill through reports, linked and sub reports.
• Optimized SSRS reports by optimizing the embedded queries, or optimized the stored procedures that generate them.
• Created multiple reports for different departments utilizing SQL scripts and stored procedures as data sets in SSRS.
• Exported business data to Excel for further analysis utilizing SSRS.

Confidential, Hillsboro, OR

SQL/Report Developer

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

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.
• Designed chart reports (line and column), parameterized reports for performance analysis utilizing SSRS.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Generated and deployed report models for creation of ad hoc reports by non-technical business users in SSRS.

Confidential, Atlanta, GA

SQL Developer

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

Responsibilities:

• Created new database objects such as procedures, functions, triggers, indexes, and views with T-SQL.
• Utilized derived tables, temporary tables and CTE’s in dynamic SQL.
• Used joins instead of sub-queries to improve the performance of queries.
• Performed error handling using try - catch and raise error.
• Worked on transactions following ACID properties.
• Altered database objects like views and stored procedures to support maintenance.