SUMMARY

• A business intelligence Consultant with extensive experience in analyzing and developing SQL server based analytics solutions for different Business enterprises.
• Hands on multiple BI platforms to develop, optimize and represent data using different reporting platforms as well.
• While my core focus has remained on enterprise data solutions delivery utilizing various ETL frameworks and bringing business value representing data in various visualization formats I has also been involved in developing front end solutions utilizing Microsoft .NET framework, ASP.NET MVC and other open source platforms like Umbraco.
• Interactive visual report created for quick digestible report summarizing company performance
• Use of parameters, transformations, custom visual charts
• Scheduling updates of the Power BI dashboards
• Setting up user permissions and data access privileges
• Experience in Application Development Analysis, Requirement Analysis, Scoping, Developing, Debugging, Testing and Documentation of various phases in a project life cycle of Client/Server applications

TECHNICAL SKILLS

RDBMS: MS SQL Server 2005/2008/2014, MS Access

Programming Languages: T - SQL, PL/SQL, V-SQL, Java, VB scripts, UNIX Shell Script

Tools: & Packages: SQL Server Management studio Enterprise Manager, Profiler, Business Intelligence Development studio (BIDS), DTS, ETL, Visual Source Safe(VSS)

Operating Systems: Windows Vista/XP/2003/2000, Windows Server 2000/2003/2007.

BI Tools: Power BI Service(Web), Power BI Desktop,SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SSMA (SQL SERVER Migration Assistance), PowerBI, Performance Point Server 2007, MS Visio, Crystal Reports 9.0/XI.

Web Technologies: XML, XPath, HTML, XSL, JavaScript, IIS.

Data Modeling: Visio 2007, Power BI

Application Packages: MS Office Suite, MS Outlook, Microsoft Office SharePoint Server (MOSS), Share Point portal.

Version Control: CVS, SVN and TFS

PROFESSIONAL EXPERIENCE

MS SQL/ Power BI Lead / SSRS Developer

Confidential, EL Segundo, CA

Responsibilities:

• Implemented Power BI on enterprise level and was responsible for managing Users, Licenses, Assigning Workspaces to Power BI Premium Capacity.
• As a Power BI Lead developer created various kinds of reports using Power BI desktop based on the client's needs.
• Responsible for Power BI data modeling to have proper presentation level filters.
• Creation of proper meta data layer for reusing of existing datasets.
• Making sure all the best practices are followed to meet the enterprise standars and delivary scalable cloud based solutions for the end users
• Utilized power BI desktop to design real time reports and scorecards for analytical decision.
• Published reports from Power BI desktop to Power BI service and created various dashboards on top of the reports to give an overview about the each report
• Deployed reports and Power BI dashboards on the reports/SharePoint/Web server; scheduled deployments with subscriptions.
• Deployed Power BI data gateway on clients server to facilitate access to data that resides at a on-premises network and for scheduled data refreshes.
• Created Power BI Content packs to share the reports with the organization and implemented row level security to achive role based security.
• Written complex .net code to use Power BI Rest APIs to embed reports in to clients internal portal.
• Written complex in sql programs, stored procedures to pull data from different data sources into power bi and created rich scale visualizations to show power ful insights for business users
• Monitoring the admin portal for tenant management of Power BI in the organization. It includes items such as usage metrics, access to the Office 365 admin center, and settings.
• Defined calculated columns, Measures using complex DAX language in power bi desktop for aggregating data for various purposes and to show good data analysis techniques.
• Used Power BI auditing to audit actions performed by users, such as "View Report" and "View Dashboard" by date range, user, dashboard, report, dataset and activity type
• Created, Maintained & scheduled various reports in Power BI like Tabular Reports, Matrix Reports.
• Made changes to the existing Power BI Dashboard on a regular basis as per requests from Business.
• Provided production support on the existing Power BI dashboards and other ETL processes to resolve the issues quickly.
• Developed custom reports using SQL Server Reporting Services (SSRS) to review score cards, business trends based on the data from different retail locations.
• Created Drill-through, Drill-down, Cross Tab Reports and Sub-Report using Report Definition Language (RDL) using SSRS 2012

Environment: MS SQL Server 2008 R2, 2012, Visual Studio 2015/2012/2010 SSIS, SSRS, PowerBI, CMS, Umbraco, Report Builder 2.0 and 3.0, SharePoint, Excel, UNIX, Windows 7, PowerPivot

MS SQL/ Power BI Admin/SSIS/ SSRS Developer

Confidential, Los Angeles, CA

Responsibilities:

• As a Power BI Lead developer, Created various kinds of reports using Power BI desktop based on the client's needs.
• Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.
• Utilized power BI desktop to design real time reports and scorecards for analytical decision.
• Published reports from Power BI desktop to Power BI cloud and created various dashboards to give an overview about the each report
• Deployed reports and Power BI dashboards on the reports/SharePoint/Web server; scheduled deployments with subscriptions.
• Installed R to run complex R scripts to load datasets into a Power BI Desktop data model for statistical (linear and nonlinear modelling, classical statistical tests, time-series analysis, classification, clustering) and graphical techniques
• Written complex phython scripts to perform advanced data shaping and analytics in datasets, including completion of missing data, predictions, and clustering and creation of custom visuals (out of box funtionality) with in Power BI query editor
• Created visually rich report tooltips that appear when you hover over visuals, based on report pages you create in Power BI Desktop which include visuals, images, and any other collection of items you create in the report page
• Deployed Power BI data gateway on clients server to facilitate access to data that resides at a on-premises network and for schedule data refreshes.
• Created Power BI Content packs to share the reports with the organization and implemented row level security to achive role based security.
• Used Power BI Rest APIs to embed reports in to clients internal portal.
• Developed a Web page(CMS Portal) using CMS Umbraco and created custom controls which allow the end user to drag and drop the Power BI Reports from Umbraco backoffice.
• Published reports and dashboards designed in Power BI utilizing Power BI services and shared it across through Microsoft Office 365. .
• Worked with the application developers and provide necessary SQL Scripts using T-SQL.
• Created joins and sub-queries for complex queries involving multiple tables.
• Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
• Working directly with stakeholders for requirements gathering and developing various decision making Dashboards.
• Created numerous simple to complex queries involving self joins, correlated sub-queries, functions, cursors, dynamic T-SQL.
• Expert on creating complex CTE, Sub Queries, Joins, cumulative queries for multiple kind of reports.
• Proven experience developing and managing data integration solutions using Microsoft BI technologies.
• Developed custom reports using SQL Server Reporting Services (SSRS) to review score cards, business trends based on the data from different retail locations.
• Created, Maintained & scheduled various reports in SSRS like Tabular Reports, Matrix Reports & Parameterized Reports using SQL Server Reporting Services SSRS.

Environment: MS SQL Server 2008 R2, 2012, Visual Studio 2015/2012/2010 SSIS, SSRS, PowerBI, CMS, Umbraco, Report Builder 2.0 and 3.0, SharePoint, Excel, UNIX, Windows 7, PowerPivot

MS SQL/ SSIS/ SSRS/ BI Developer

Confidential, LongBeach, CA

Responsibilities:

• Worked in Confidential IT Team for fulfilling the end user requirements and incidents.
• Worked on Onsite-Offshore model and responsible for the deliverables, and also coordinating with the team.
• Worked on QNXT database and data for generating daily and monthly reports.
• Created complex reports related QNXT database data and had good experience in working with QNXT.
• Extensively worked on Data Flow tasks like for each Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.
• Extracted Data from various Databases such as SQL database, flat files to SQL server 2012 using SSIS.
• Automated all the existing reports using SSIS or SSRS for the end user.
• Experience in Microsoft Visual C# in script component of SSIS
• Worked on Pueto rico and Florida Compliance reports and adhoc report requests.
• Extracted data using SSIS packages (ETL) from different server locations and data sources.
• Used SSIS to create ETL packages to validate, extract, transform and load data into data warehouse and data marts.
• Created ETL process using SSIS to transfer data from heterogeneous data sources.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS
• Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
• Created, Maintained & scheduled various reports in Power BI like Tabular Reports, Matrix Reports.
• Created Tabular Models as a source to Power BI dashboards and scheduled jobs to refresh it in a timely manner.
• Developed and maintained multiple Power BI dashboards/reports and content packs.
• Made changes to the existing Power BI Dashboard on a regular basis as per requests from Business.
• Provided production support on the existing Power BI dashboards and other ETL processes to resolve the issues quickly.
• Developed custom reports using SQL Server Reporting Services (SSRS) to review score cards, business trends based on the data from different retail locations.
• Created Drill-through, Drill-down, Cross Tab Reports and Sub-Report using Report Definition Language (RDL) using SSRS 2012
• Created Drill reports which give all the details of various Claims like closed Claims, summary of Claims and scheduled this report to run on daily, weekly or monthly basis
• Processing claims to adjudicate successfully in developing whether there is any price mismatch with proper ICD - 9 and ICD - 10 and HCPCS/CPT codes as per Networks.
• Created Data Mart Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Testing of applications for performance, data Integrity.
• Responsible for performing SQL tuning, multi-tasking and optimizing long running queries.
• Involved in creating the scorecards for Platform, Application and Service Operations on weekly basis.