PROFESSIONAL SUMMARY:

Highly adaptable and experienced database and BI Developer with proven track record of high client satisfaction in various domains such as hospitality, insurance, banking and healthcare. Strong hold in MS SQL Server and BI Stack with the ability to perform under strict time - frames.

TECHNICAL SKILLS:

Databases: MS-SQL Server 2008, 2008R2, 2012, 2016

T: SQL Programming, Dynamic SQL, SAS

Data Modeling: ER-win, MS Visio

Development Tools: BIDS, SSDT, SSMS, Integration Services (SSIS), Analysis Services (SSAS, OLAP Cubes, Tabular Model), Reporting Services (SSRS, Report Builder)

BI Tools: Power BI (Power View, Power Pivot), Tableau

Collaboration Tools: SharePoint, 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

Source Control: Team Foundation Server (TFS)

PROFESSIONAL EXPERIENCE:

Confidential, Scottsdale, AZ

SSRS PowerBI Developer

Tools: SQL Server 2012/2016, T-SQL, SSMS, Erwin, SSRS, Power BI, TFS, DTA, SQL Profiler, Data Factory, MS Azure.

Responsibilities:

• Gathered requirements and coordinated with the business users to assure satisfactory data content, quality, data integrity and receipt of desired information.
• Wrote complex stored procedures for database backup and index fragmentation.
• Analyzed T-SQL scripts and added try-catch blocks for error handling.
• Optimized the query codes by adding suitable stored procedures, indexed views and UDF.
• Applied SQL Profiler/DTA to attain query optimization and data tuning results.
• Followed traditional reporting life cycle (Authoring, Managing, Delivering) to build reports in SSRS.
• Generated ad-hoc, parameterized, drill down, and drill through reports utilizing SSRS.
• Written expressions to hide sensitive data at report level in SSRS.
• Created cache refresh plans for frequently used reports in Report Manager.
• Utilized different visualizations such as bar chart, maps, pie charts and tables for designing interactive dashboards in PowerBI Desktop.
• Imported JSON file to change the theme and color palate as per the requirement in PowerBI Desktop.
• Profiled and cleansed data extracted from various sources utilizing mashup codes in query editor on PowerBI Desktop.
• Identified frequently used reports and their ranking utilizing Usage Metrics in PowerBI services.
• Created, validated and reviewed solutions for implementing storage and database solution in Azure cloud.
• Collaborated with TFS to keep track of the history, merging code between the different versions.

Confidential, Dallas, TX

SQL/Power BI Developer

Tools: Microsoft SQL Server 2012, SSDT, SSMS, T-SQL, SSRS, SSAS, ER-Win, Power BI, Excel, TFS, DTA.

Responsibilities:

• Communicated and coordinated with clients to understand business needs and expectations from the ETL process.
• Proposed technical feasibility solutions for new infrastructure design and suggested options for performance improvement.
• Developed multitude of database objects to support business (complex stored procedures, user defined functions, views and tables).
• Utilized triggers and different constraints to implement validations and checks for DML operations.
• Optimized queries to use various indexes such as clustered, non-clustered and solved lookup problem examining execution plans.
• Audited and identified queries that are running slow utilizing DMV/DMF.
• Implemented new reporting requirements utilizing functionality such as drill down, drill through, cascaded parameters.
• Identified slowly running reports utilizing Execution logs in Report Server database.
• Created shared schedules in reporting services to schedule caching, snapshot and subscriptions.
• Delivered reports on daily, weekly and monthly basis utilizing subscriptions in SSRS.
• Designed various dashboards with power BI utilizing different KPIs, page filters and row filters to analyze OLAP data for business decisions.
• Handled active and inactive relationships with multiple data sets utilizing Data Analysis Expressions (DAX) in power BI.
• Created new measures and columns as per the requirement utilizing DAX in Power BI Desktop.
• Created row filters utilizing DAX to secure reports in Power BI Desktop.
• Utilized TFS for Version control and change management for cross-functional team communication.

Confidential, Buffalo, NY

SQL/Reports Developer

Tools: MS SQL Server 2008R2/2012, BIDS, SSDT, SSRS, Erwin, SQL Profiler, SQL Debugger, Power Pivot, Power View, Power Map, TFS, Excel, Windows Server.

Responsibilities:

• Collaborated with the business users to create BRD with the following conversion to SRS document.
• Created T-SQL scripts to link the relationships based on the finalized ER-Diagram and built corresponding tables.
• Implemented exception-handling techniques such try-catch blocks, error functions in T-SQL scripts.
• Involved in query optimization and performance tuning with tools such as SQL profiler, index tuning wizard and database engine tuning advisor (DTA).
• Created ad-hoc reports and managed reports from OLTP and OLAP including its delivery with push and pull delivery methods.
• Deployed SSRS reports to the reporting server and assisted in troubleshooting deployment problems.
• Optimized reports by optimizing the embedded queries, or optimizing the stored procedures that generate them.
• Utilized Power Pivot and Power View for creating analytical reports and dashboards from Tabular Models.
• Displayed geographical information in 3D utilizing Power Map in Excel services.

Confidential, Buffalo, NY

SQL SSRS Developer

Tools: MS SQL Server 2008/R2, SSMS, BIDS, SSRS, T-SQL, Excel, Visio, Power Pivot, DTA, SQL Profiler, TFS.

Responsibilities:

• Collaborated with business analysts to gather project specifications and coordinate with project assets.
• Improved existing procedures, triggers, UDF, and views with analyzing execution plans and updating statistics.
• Utilized different types of joins, CTEs, set operators and group by clause for complex script and batches.
• Created fact tables with multiple granularity levels and maintained fact table relations with alternate keys.
• Generated different SSRS reports such as drill down, drill through and cascading parameters.
• Secured reports at data level, report level and report manager level utilizing roles in SSRS.
• Optimized slowly running reports utilizing execution logs, caching and snapshot.
• Designed and implemented visually appealing dashboards utilizing Power Pivot as the reporting tool.
• Created new columns utilizing DAX to be a part of user defined hierarchies in Power Pivot.

Confidential, New York, NY

SQL Developer

Tools: SQL Server 2005/08, SSRS, SSMS, T-SQL, Windows Server, SQL Profiler, DTA, TFS.

Responsibilities:

• Analyzed multiple user requirements and development specifications for OLAP applications in JAD meetings.
• Created T-SQL scripts to generate tables, implementing constraints and relationships based on the finalized ER-Diagram.
• Created stored procedures, functions, and triggers for data retrieval/updates in the database.
• Applied formatting in SSRS reports with features such as grouping, drill-down, parameters and sub reports.
• Deployed SSRS reports to report server in native mode and SharePoint integrated mode.
• Used TFS platform for exchange of documents for cross-functional communications.