SUMMARY:

• Business Intelligence professions with over 6 years’ experience in developing BI applications utilizing SQL server, MS BI stack (SSIS/SSRS/SSAS), Power BI, Tableau and MS Azure. Proficient in managing large - scale projects within all phases of requirements gathering, development, and implementation. Experience within multiple industries including banking, finance, technology, legal, and healthcare.

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: (SSAS, OLAP Cubes, Tabular Model)

Reporting Services: (SSRS, Report Builder)

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

SharePoint: 2013/2010, PerformancePoint Services

Languages: Java, Python, Bootstrap, C#.Net CSS, HTML 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, Princeton, NJ

Power BI/SSRS Developer

Tools: and Environment SQL Server 2012, T-SQL, SSMS, Excel, Erwin, SSIS, SSAS, DAX, SSRS, Power BI, Power Pivot, SharePoint, TFS

Responsibilities:

• Collaborated with the development team in JAD meetings to outline functional requirements.
• Documented data mapping and transformation processes in the functional design documents based on the business requirements.
• Developed and created the new database objects like tables, views, indexes, stored procedures and functions and wrote batch scripts.
• Manipulated and managed data efficiently creating complex stored procedures and functions
• Utilized DAX expressions, formulas and calculations in SSAS tabular model.
• Managed cubes objects such as KPIs, drill through actions, perspectives, aggregations, and translations.
• Designed and implemented report layouts according to reporting standards of the department.
• Developed reports and dashboard with SSRS (ad-hoc, drill-down, drill-through, parameterized, and sub reports).
• Implemented interactive sorting for tabular and other types of reports and used sub reports for using multiple data sets in a report.
• Created scorecards with power pivot to compare performance and display information required by clients.
• Created rich dashboards utilizing power BI to identify trend and pattern from OLAP data.
• Developed dashboards with multiple charts and gauges utilizing reporting services.
• Automated report deliveries to multiple recipients with subscriptions in SSRS.
• Deployed reports, both in native mode and SharePoint mode, utilizing SSRS deployment wizard.

Confidential, San Diego, CA

Power BI/SSRS Developer

Tools: and Environment SQL Server 2012, T-SQL, SSMS, Excel, Erwin, SSIS, SSAS, SSRS, SharePoint, Power BI, Tableau, TFS, DTA, SQL Profiler, MS Azure, Iaas, PaaS, Data Factory, Visual Studio, C#

Responsibilities:

• Collaborated with senior management, subject matter experts, and IT teams to define business requirements
• Transformed business requirements into functional and nonfunctional requirements.
• Created complex stored procedures to perform various tasks including, but not limited to: index maintenance, data profiling, metadata searches, and loading of the data mart.
• Created SSAS cubes with KPIs and aggregation for the front-end analysis team.
• Designed SSRS reports for in depth business analyses.
• Designed expressions to calculate, group, filter, parameterize, and format report contents.
• Generated score cards with executive summary dashboards to display performance monitoring measures using Tableau.
• Deployed SSRS reports in native and SharePoint integrated mode.
• Delivered on-demand reports in multiple rendering formats with standard and data driven subscriptions.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
• Created reports in Power BI desktop preview portal utilizing the SSAS Tabular via Analysis connector.
• Deployed data intensive Power BI dashboards to SharePoint team site as per business requirements.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Implemented data blending, groups, combine fields, calculated fields, and aggregated fields to compare and analyze data in different perspectives in Tableau.
• Implemented code check-in/check-out and managed multiple versions of complicated code within TFS.
• Provisioned VMs with SQL Server on cloud utilizing Microsoft Azure and setting up communication with the help of endpoints.
• Migrated enterprise database to Microsoft Azure with Redgate and azure data factory.
• Helped to develop backup and recovery strategy for databases on virtualization platform utilizing Microsoft Azure.
• Performed thorough unit testing on all relevant platforms to ensure proper implementation.

Confidential

Power BI/Reports Developer

Tools: and Environment Microsoft SQL Server 2012, SSDT, SSMS, T-SQL, SSIS, SSRS, SSAS, ER-Win, Power BI, SharePoint, TFS, DTA, Tableau, Visual Studio, C#

Responsibilities:

• Analyzed business requirements, facilitating planning and implementation of the OLAP model during JRD meetings
• Participated in JAD meetings to ensure a common understanding with business, development and test teams.
• Encapsulated frequently executed SQL statements into stored procedures to reduce the query execution times.
• Designed the new data mart with star schema, following Kimball methodology, with Erwin data modeling tools
• Performed data cleansing and scrubbing in the staging database.
• Implemented new and complex calculated members in cubes improve report performance.
• Designed cube objects such as KPIs, aggregations, perspectives, and translations.
• Formatted dashboards, multiple chart types, trends, and KPIs with Power View to support analyses.
• Scheduled reports utilizing subscriptions and shared schedules.
• Formatted dashboards, multiple chart types, trends, and KPIs with Power View to support analyses.
• Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management.
• Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
• Designed, implemented and deployed multitude of dashboards with Microsoft Power BI desktop for insurance claim analysis to improve business decision in specific case scenarios.
• Created Tableau scorecards, dashboards utilizing stack bars, bar graphs, scattered plots, geographical maps.
• Proactively resolved issues to drive quality and system performance improvements across the application
• Participated in cross-team information sharing resources and worked to identify risks early in the development process
• Implemented TFS for project version control and change management with bug tracking.

Confidential, Parsippany, NJ

SQL Reports Developer

Tools: and Environment MS SQL Server 2008R2, BIDS, SSIS, SSRS, Erwin, SQL Profiler, T-SQL, SharePoint, Power Pivot, Power BI, TFS, Excel, Tableau

Responsibilities:

• Worked with product owners to recommend and implement appropriate solutions to support business needs.
• Interpreted technical and function specifications based on the project requirements in JAD meetings.
• Designed CTEs to manage code in complex stored procedures.
• Assisted with the development and maintenance of SSAS cubes.
• Managed reports per the standardized report cycle (authoring, managing, security, generation).
• Analyzed data and clarified data outputs with reports and models.
• Identified inefficiencies in the database platform and recommended solutions accordingly.
• Created reports with SSRS, including summary, drill-down, and matrix reports.
• Implemented an interface to organize reports, sort data sources, schedule report executions, and track report history.
• Optimized reports utilizing snapshot, caching and embedded data set.
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Utilized TFS for source control and for changing the management of BI and SQL codes.

Confidential, New Jersey

SQL/SSRS Developer

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

Responsibilities:

• Collaborated with managers, business analysts, and business users to gather business requirements.
• Wrote complex SQL queries utilizing joins, sub-queries, and common table expressions (CTEs) to acquire business related data.
• Wrote dynamic SQL batches to perform bulk operations in the OLTP environment.
• Designed an OLAP data model of the data mart utilizing ER-win per functional requirements.
• Created data mappings to establish relationships between source and target tables.
• Created complex cubes with multiple fact measure groups and dimension hierarchies based on reporting needs.
• Developed various reports using SSRS and Excel services for business analysis and decision-making.
• Developed multiple reports in SSRS with features such as document maps, actions, conditional formatting.
• Designed and created report templates, bar graphs, and pie charts based on financial data.
• Created various analytical dashboards utilizing Power Pivot with manipulation features.
• Designed complex data intensive reports in Power Pivot utilizing various graph features such as gauge, funnel, line better business analysis
• Deployed reports and dashboards on the reports/SharePoint server; scheduled deployments with subscriptions.

Confidential, New York, NY

SQL Database Developer

Tools: and Environment MS SQL Server 2008, BIDS, SSIS, SSAS, SSRS, SSMS, T-SQL, Windows Server, SQL Profiler, DTA, TFS, Power Pivot

Responsibilities:

• Created functional/non-functional requirements via JAD sessions.
• Designed data integration process and collaborate with business analyst for various project needs.
• Developed complex stored procedures and functions to perform data profiling and business calculations.
• Modified the OLTP database structure per changes in the business process.
• Wrote queries with joins and common table expressions to simplify complex queries involving multiple tables.
• Optimized the logic in procedures, functions, and triggers.
• Enhanced the performance of inefficient queries with SQL profiler and DTA.
• Created SSIS packages to perform incremental loads using timestamps.
• Utilized SQL server table configuration to configure package properties.
• Devised complex expressions for calculations, groupings, filters, and formatting contents of SSRS reports.