SUMMARY

• 9+ years of experience in Data Design, Implementation, Administration and support of Business Intelligence using SQL Server 2012/2008R2/2008/2005, SSIS, and SSRS.
• Including 5+ years of experience in developing, managing, and publishing visualizations using Power BI Desktop on to Power BI Service.
• Published reports to Power BI Service using Pro and Premium licensed versions, scheduled subscriptions, and worked with various sharing options (Workspaces and Apps).
• Expert in handling and working with multiple data sources to develop PBI reports including SharePoint, SQL/Azure SQL, Oracle, MS Excel, flat text files, media server, etc.
• Well - versed with DAX functions and creating custom visualizations (importing from external sources) as required post clients’ approval.
• Expert in configuring and scheduling refresh activities using On-Premise Gateways and cloud-based data sources.
• Ability to work on VMs with restricted access scenarios.
• Expert in handling ad-hoc requirements from business and providing instant solutions.
• Expert in configuring mobile views for Power BI reports including bookmarks.
• Worked on generating effort estimates with respect to individual resources during onshore-offsite coordination.
• Ability to work on V1 and V2 (New Look) versions of Power BI Service.
• Developed sprint plans with minimal initial estimates and provided critical insights for business with respect to sprint releases.
• Highly proficient in communicating with business users by accommodating stringent secured guidelines to enable data security.
• Documented individual reports meeting client requirements during transition between teams.
• Expert in ETL - Extraction, Transformation, and Loading, Operations Data Store concepts, data marts.
• Expert in different components of SSIS such as Control Flow, Data Flow, and Connection Manager while extensively using different kinds of Containers, Control Flow Tasks and various Transformations under data flow tasks.
• Proficient in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Proficient in SSIS with experience to design ETL architecture, creating and fine tuning ETL workflows.
• Extensively used tools like SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Developed various operational Drill-through and Drill-down reports using SSRS.

PROFESSIONAL EXPERIENCE

Sr. Power BI Developer/Lead

Confidential

Responsibilities:

• Engaged in Lead role while coordinating with the offshore team.
• Generated multiple Power BI reports using a single dataset thereby optimizing the scheduled refresh activity due to limited shared resources.
• Developed KPI reports having daily, weekly, quarterly, and annual metrics.
• Worked as an individual contributor in developing ad-hoc reports by participating in requirement gathering from client on a daily basis.
• Developed individual reports with media servers as data source.
• Configured daily usage metric reports available on Power BI Service according to the client requirements thereby creating business solution to client on various visuals available and their efficiency in driving business.
• Expert in handling Matrix/Table visuals and configuring interactions between them in order to achieve desired functionality.
• Developed multiple matrices on single page to accommodate various metrics and compared business numbers to derive business decisions.
• Developed visuals based on more than one Fiscal Year calendars to compare current quarter metrics with previous year’s quarter metrics.
• Sound knowledge on DAX functions based on business requirements and generated POCs to project the feasibility of the BRD.
• Well-versed with licensing versions of Power BI Professional/Premium along with the Desktop developer version.
• Worked on V1 and V2 (New Look) versions of Power BI Service handling pros and cons from each version.
• Developed reports using SQL/Azure SQL tables/views as well as tabular model as data sources with various data source connecting methods including Import mode and Direct Query.
• Configured scheduled refreshing activity after analyzing the data availability in SQL tables/views by coordinating with various teams to maintain a neutral environment in workplace.
• Implemented security on various reports using corporate login credentials restricting the access levels to different users following their hierarchy such as Regions, Districts, and Stores and their managers.
• With “Parameterized URL” functionality, made reports available to secured devices in different stores and implemented auto-filtering between 627 Stores located throughout NA.
• Performed QA by querying the data sources, comparing the reports with them for accuracy, and released reports to end users with minimal-to-no assistance.
• Well-versed in requirement gathering and expertise in converting business requirements into technical specifications.
• Coordinated with offshore team during daily standup calls to deliver reports with sensitive time-bound limitations.

TECHNICAL ENVIRONMENTS: Power BI Desktop version 2.88 (December release), and Power BI Service (Professional and Premium versions - V1 and V2), MS SQL server 2019, Azure tabular model, Office 365 for business (MS Excel, MS PPT, OneDrive).

Onsite-Offshore Coordinator/Power BI Developer

Confidential

Responsibilities:

• Worked as an onsite-offshore coordinator and developer through the entirety of the project.
• Developed reports/visuals on PBI with minimal data availability and provided forecasted insights to business.
• Introduced agile methodology to the business and generated sprint plans involving individual developers in coordination with the offshore team.
• Projected effort estimates to the business on par with the planned deliverables.
• Has good understanding of shipment and logistics terms like GND (ground), INT (in-transit), LIT (leg in-transit), SIT (shipment in-transit), VPC (vehicle processing center), RH (rail head), etc.
• Implemented dynamic views on limited visuals taking the Power BI limitations into consideration with many-many relationship (cardinality).
• As on onsite resource, initiated daily catch-up calls with offshore team and tracked the developments to meet the time-sensitive requirements by the business.
• Provided clear insights to the business regarding effort estimates of the offshore team and the feasibility of deliverables.
• Worked on virtual machine (VM) during report development due to the infrastructure and security limitations onsite.
• Ability to communicate the business requirements to offshore team and expedite the development to meet critical deadlines.
• Exclusively worked on designing mobile view layout, which is a primary business requirements, as the project is meant to migrate from Qlikview to Power BI.
• Considering limitations with Power BI when compared to Qlikview, great care was taken to make cosmetic feel similar to Qlikview dashboards after migrating to Power BI.
• Workaround approaches have been called out and implemented trying to meet the business requirements during the migration, considering the limitations of Power BI with respect to Qlikview.

TECHNICAL ENVIRONMENTS: Power BI Desktop version 2.71 (July release), and Power BI Service (Professional and Premium versions), Azure cube, Office 365 for business (MS Excel, MS PPT, OneDrive).

Oracle/Power BI Developer

Confidential - Bakersfield, CA

Responsibilities:

• Worked as an individual developer and contributed towards delivering reports.
• Analyzed and worked with data with respect to the oil fields, equipments, work orders, LPO (Lost production opportunity)/BOE (Barrel of Oil Equivalent) loss, etc.
• Worked with queries using Oracle (Toad for Oracle 13) as a primary data source.
• Worked in requirement gathering and refining the requirements into user stories using ADO (Azure DevOps).
• Worked directly with stake-holders to ensure report delivery on time.
• Participated in daily standup meetings, Sprint planning, refinements, and retrospectives towards the delivery of MVP (Minimum Viable Product).
• Well-versed with oil and gas industry terminology.

TECHNICAL ENVIRONMENTS: Toad for Oracle 13, Office 365 for business (MS Excel, MS PPT, OneDrive), Power BI Desktop version 2.66, and Power BI Service (Professional and Premium versions).

MS SQL/Power BI Developer

Confidential - Houston, TX

Responsibilities:

• Exclusively worked with SharePoint, MS SQL Server, Azure SQL, and flat files as data sources to build and deliver PBI reports.
• Worked as an individual developer and contributed towards delivering reports with strategic deadlines.
• Worked with calculated measures, calculated columns, and user-defined functions (DAX) in Power BI reports.
• Expert in configuring scheduling refreshes using cloud databases, On-premise Gateways, and/or personal gateways (if required).
• Well-versed with querying SQL Server/Azure SQL in Test, QA, and Prod environments.
• Expert in re-defining relationships between datasets/tables by creating custom columns using SharePoint data against Power BI- defined relationships.
• Validated data across the Power BI visuals for accuracy by performing cross-validation with respective business teams.
• Worked to meet ad-hoc requirements from the business delivery leads and delivered highly accurate visuals within limited time period.
• Engaged in distributing workflow using Waterfall methodology.
• Worked using Office 365 for business version including OneDrive as cloud storage data source.
• Worked under direct collaboration with stake-holders, SharePoint team, and off-shore team to ensure delivery on time with accuracy.

TECHNICAL ENVIRONMENTS: MS SQL Server 2017, Office 365 for business (MS Excel, MS PPT, OneDrive, MS SharePoint, MS Access, etc), Power BI Desktop, and Power BI Service (Professional and Premium versions).

MS SQL SERVER/MS BI Developer

Confidential - Englewood Cliffs, NJ

Responsibilities:

• Worked on performing requirements gathering, analyzing and designing of the system.
• Load data from various sources like OLEDB, Flat files to SQL Server database using SSIS packages and created data mapping to load the data from source to destination.
• Proficient in creating dynamic well-organized, accurate and insightful Power BI reports/dashboards to support strategic decisions.
• Integrated custom visuals based on business requirements using Power BI desktop.
• Provided continuous maintenance and development of bug fixes for the existing and new Power BI Reports.
• Worked on scheduled and automated refresh in Power BI service.
• Installed and configured Enterprise gateway and Personal gateway in Power BI service.
• Successfully migrated data between different heterogeneous sources such as flat files, Excel and SQL Server 2008 using SSIS.
• Involved in creating multiple parameterized stored procedures which were used to generate reports, with Cascaded Parameters, Gauges and Interactive Charts in SSRS.
• Published Daily, Weekly, and Monthly Reports as per the customer requirements using subscriptions and Created Tabular Reports, Cross Tab Reports, Sub Reports.
• Designed, implemented, and monitored EDI processes to interchange invoicing and purchasing data with suppliers using industry standards.
• Used the parallel execution technique to optimize the performance of SSIS package.
• Created Tabular Models using DAX queries in analysis services and deployed it.

TECHNICAL ENVIRONMENTS: MS SQL Server 2012/2014/2016 SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), MS Visual Studio, Windows 2008 Server, DTS, MS Excel, Power BI Desktop, and Power BI Service.

MS SQL SERVER /T-SQL/MSBI (SSIS/SSRS) ETL Developer

Confidential - New York, NY

Responsibilities:

• Designed SSIS Packages to migrate slowly changing dimensions.
• Developed database maintenance plans for deleting of history data using SSIS packages.
• Proficient in logical and physical database development (using ER-win, Normalization, Dimension modeling and Enterprise manager).
• Rendered the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.
• Developed queries for generating drill down reports in SSRS 2008 and prepared AD-HOC reports through report builders.
• Implemented Event Handlers and Error Handlers during creation of SSIS packages and notified process results to various users.
• Worked on calculating measures, mathematical formulas and user-defined functions (DAX) in Power BI reports.
• Deployed Dashboards, Reports and Data sources using the Power BI Service.
• Created drill down and drill through reports with parameters in Power BI and SSRS.
• Worked on all types of transformations that are available in Power BI Query Editor.
• Created tables, matrix, and chart reports as required and deployed them onto the Power BI Service.
• Implemented security measures at Power BI Service using authentication and authorization methods.
• Performed the Power BI report validation against the databases.
• Deployed and scheduled reports on the Power BI Service.

Environment: Windows server 2003, IIS 6.0, MS SQL Server 2012/2014 Enterprise Edition, SSIS, SSRS, T-SQL, DTS, SQL Profiler, OLAP, OLTP, Performance Point Sever, Office-2007, MS Excel, Power BI Desktop, Power BI Services.

MS SQL SERVER/MSBI DEVELOPER

Confidential

Responsibilities:

• Created and maintained Users, Security Permissions and Migration of the database objects from one server to another server.
• Designed complex queries and stored procedures for high performance reporting and rendered them to HTML, PDF and EXCEL formats using reporting services.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XML etc.) and loaded the data into target data sources by performing different data transformations (DTS) using SSIS.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Designed Query for generating drill down reports in SSRS 2008.Prepared AD HOC reports through report builders.
• Developed Custom Functions, Manual Running Totals and Complex Formulas for reports.
• Collaborated with report developers to build data mart solutions to ensure reporting efficiency and accuracy.
• Proficient in fine tuning the performance of applications to avoid delays in data flow between systems.

Environment: SQL Server 2008 R2, T-SQL, SSRS, SSIS, Visual Studio 2008, MS Office 2007/2003, MS VSS, XML.

MS SQL Server/MSBI Developer

Confidential

Responsibilities:

• Developed a comprehensive reporting environment utilizing data from multiple sources and creating analysis using SQL Server Reporting Services (SSRS).
• Weekly presentation to the business users about the reports and their changes as required.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support SSRS reports.
• Proficient in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
• Experience in creating packages to transfer data between MS ACCESS and FLAT FILES to SQL SERVER using DTS/SSIS.
• Created and managed various database objects like tables, views.
• Designed Dashboards, Scorecards and reports using multiple KPI's, OLAP charts and SSRS Reports with PPS.

Environment: SQL Server 2008 R2, T-SQL, SSRS, SSIS, Visual Studio 2008, MS Office 2007/2003, MS VSS, XML.