Data Warehouse/ Business Intelligence Reports Developer/Functional Data Analyst/Power BI Developer

Solution focused and versatile IT Professional with more than 10 year’s exceptional data warehousing and business intelligence experience (Microsoft BI Stack) complemented with analytical, communication, and problem-solving skills involving in all phases of SDLC.

Experienced in all phases of data warehouse development lifecycle, from requirements gathering to testing, implementation, and support. Out of Box thinking to solve client problems, bring new things onto table.

Exceptional background in analysis, design, development, customization, and implementation and testing of software applications and products.

Extensively involved in all the phases of software development life cycle.

Hands on experience on Power BI (Power Query, Power Pivot, Power View) in Excel 2013.

Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), Analysis Service (SSAS), and ETL package design, and RDBM systems like SQL Server.

Extensive experience to build reporting solutions to SharePoint 2010/2013.

Strong leader with experience training developers and advising technical groups on best practices.

Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.

Hands on experience to build complex reports such as Dashboard and Drill-down Reports using SSRS and COGNOS platforms.

Demonstrated broad strengths in Project Management, Business Analysis, New Business Development and Negotiations

Effective analytical and communication skills with ability to interact with end user, self-motivated, quick learner, team player with good Interpersonal skills.

Experience on creating dashboards using tabular models.

Experience in designing Tabular Data Models and Creating Power BI reports and publishing them to Power BI Service.

Worked on Power BI Premium to enable dedicated processing capacity.

Knowledge on ADLS (Azure Data Lake Store) and ADF (Azure Data Factory).

Experience in loading data from Tabular data models and create reports in Excel.

Hands on experience on Sharepoint administration and deploying SSRS and Excel reports on SharePoint 2013.

Knowledge in connecting to Dynamic CRM online data using OData feed.

TECHNICAL SKILLS

ETL : SQL Server Integration Services (SSIS), COGNOS Decision Stream.

Programming : T-SQL, PL/SQL, C, C++, HTML, Scope.

Databases Systems : MS SQL Server 2008/2005/2000.

Big Data Platform : COSMOS

OLAP/Reporting : SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), POWER BI DESKTOP.

Tools : MS Visual Studio, Dundas, Visio, Business Analyzer, Power Pivot, Tableau Desktop, Tableau Server, SharePoint 2010/2013.

PROFESSIONAL EXPERIENCE

Organization: TATA Consultancy Services, Bellevue, WA

Duration: Oct 2016 – Till Date

Organization: C2S Technologies Inc, Bellevue, WA

Duration: May 2013 – Oct 2016

Organization: C2S Technologies India Private Limited, Hyderabad, India

Duration: July 2011 – April 2013

Organization: coServe Solutions (De Blok India Software (P) LTD), Hyderabad

Duration: July 2008 – June 2011

PROJECTS EXPERIENCE

Consultant (Aug 2015 – Till Date)

Microsoft – DSA

Project: Digital Store Analytics.

Created Power BI dashboards to provide insights for management and end users.

Hosted the Power BI reports using Power BI service and created Workspaces and Apps.

Involved in creating the pipeline to pull the data from COSMOS to SQL for reporting.

Created scripts using SCOPE for adhoc analysis on COSMOS.

Created and automated validation reports.

Created custom visuals for Power BI using R Scripting.

Integrated various data sources to created data model in Power BI.

Created SQL Tables and Views for specific reporting needs.

Managed the security on the reports.

Monitoring the pipelines daily.

Created technical documentation for the reports.

Requirements gathering and assigning the task to offshore team.

Consultant (Mar 2015 – June 2015)

Microsoft – ESBI

Project: Enterprise Services Business Intelligence.

Designed and created SSAS tabular model leveraging third normal form tables.

Created complex Power BI dashboards based on the OLAP Reporting Needs.

Designed various reports using Microsoft Power BI designer, Power BI on-premises and Excel Power

View.

Designed Power Pivot reports in excel 2013 by importing data from SQL Server and SSAS.

Use of Data Analysis expressions (DAX) to query data objects and return with result set for Tabular

Models.

Used various OLAP operations like slice / dice, drill down and roll up as per business requirements.

Extensive use of Pivot Tables and Power Pivot Excel for reports.

Created documentation on different approaches to build SSAS tabular model on third normal form tables.

Tools Used: SQL Server 2012, Visual Studio 2010, SharePoint 2013, Power BI.

Consultant (Nov 2014 – Feb 2015)

Microsoft – WWLP

Project: Worldwide Licensing Program.

Refresh and validate the reports as per the publish schedule.

Created data validation reports.

Created power view dashboards.

Maintain and administrate Sharepoint 2013 portal.

Managing security groups and user permissions.

Managing publication emails and created email templates.

Preparing Monthly Deck, Close Deck and Quarterly deck for higher management.

Created documentation regarding the refresh process.

Maintenance and scheduling the refresh of the reports.

Add, Delete and Modify existing pages on SharePoint.

Created complex excel reports.

Running MSRA queries to refresh the data.

Created user stories based on the data.

Tools Used: SQL Server 2012, SSRS, Visual Studio 2010, SharePoint 2013, MSRA, Power BI.

Consultant (Oct 2013 – Nov 2014)

Microsoft – OEM Finance

Project: OEM Finance.

Build new dashboards using SSRS and maintain existing Dashboards.

Testing and maintenance of the SharePoint 2013 after migration.

Deploying SSRS and Excel reports on to SharePoint.

Build SSIS packages to fulfill reporting requirement

Building reports using Axiom with the third-party forecast data.

Creating tabular models for reporting.

Reconciling published reports against MS sales and EC data.

Add, Delete and Modify existing pages on SharePoint.

Handling permissions for reports on SharePoint.

Converted Excel reports to SSRS reports.

Created few visualization reports using Power BI.

Maintenance and scheduling the refresh of the reports.

Tools Used: SQL Server 2012, SSRS, Visual Studio 2010, SharePoint 2013, MSRA, Power BI.

Consultant (May 2013 – Oct 2013)

C2S Technologies INC

Project: Predictive Data Analytics – (PDA), WaySpin

Participated in requirement gathering sessions and transformed requirements into technical specifications.

Creating Unified Modeling Language (UML) diagrams such as Use Case diagrams, Activity diagrams, Sequence diagrams

Designed and Architected PDA reporting Solution end – end by utilizing SQL Server, SSIS, SSRS technologies together.

Adopted and designed best practices for Data Models and Data Storage and Integrations.

Built complex ETL diligently and incorporated several techniques to avail the data to front end reports without impacting reporting users while data is being extracted from source systems.

Migrated SSRS reports to SharePoint 2010 Server. Integrated InfoPath forms and web parts to SharePoint 2010.

Designed and architected End-End Data warehouse and Reporting Systems including Dashboards.

Spearhead the design and development of store procedures, configuration files, tables, views, and functions, implement best practices to maintain optimal performance.

Manage and maximize work performance of developers through training; advising other groups in organization on SSIS development, data warehouse development, and ETL development best practices.

Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes.

Facilitate resolution of issues by providing on-call support to production system.

Build Ad-hoc complex T-SQL Queries and stored procedures for database schema changes and data extractions.

Tools Used: SQL Server 2008, SSRS, Visio, Visual Studio 2008, SharePoint 2010, InfoPath.

Support Engineer (July 2011–April 2013)

Microsoft – Bangalore

Project: Customer Assistance Portal Support and report development

CAP (Customer Assistance Portal) and CAP Reporting Support.

CCF (Customer Care Framework) and CCF Reporting Support.

Working with Development, Test, Operations, and Line of Business Owners.

Adding and removing users (CAP Tool and CCP).

Resolving application issues.

Create and or modify User Templates, Queues, Property Types and Rules.

Inspect log files.

Administer application and reporting permissions.

Determine if issues are bugs or by design.

Escalate infrastructure issues to the Operations team.

Create Bugs for the CAP Product Group.

Participate daily / weekly in the application support triage meetings.

SQL Adhoc reporting assistance.

On-call 24/7 Support.

Educating users and crating documents for FAQ's.

Notifications for Planned and Unplanned events.

Converted Excel reports to SSRS reports.

Tools Used: SQL Server 2008, CAP Portal, SSRS, Visual Studio 2008.

Consultant (Sep 2010–June 2011)

Concepcion-Carrier Air Conditioning Company (Philippines)

Project: Report Development integrating SSRS and Business Analyzer.

Involved in various stages of SDLC like gathering User requirement and System Specification. System Analysis, Design, Development, Testing and Implementation

Data Analysis for GAPs in the system.

Software installation and client server configuration.

Created Data Flow Diagrams.

Extraction, Transformation and Loading of the data using stored procedures.

Design and development of operational reports (SSRS 2005).

Collaboration with various users for design and development of ad-hoc reports.

Optimization of reports for better performance.

Communicating with the client on critical issues, defects status, specs status etc.

Design, Development and Deployment.

Responsible for entire project day-to-day activities.

Onsite-Offshore Co-ordination.

Involved in fixing the issues with the UAT team and writing test scripts.

Tools Used: SQL Server 2008, SSRS, Visio, Visual Studio 2008, Business Analyzer, Dundas Charts

Consultant (May 2009 – Aug 2010)

Al-Hoshan Company Limited – Dubai

Project: Report Development Using SSRS.

Created data mappings from legacy ERP systems to newly created data warehouse.

Developed complex reports from warehouse using SSRS.

Developed and designed ETL systems to transfer data from source systems to target systems.

Established communication channel between business stake holders and technical team to facilitate SSRS reports as per business requirements.

Responsible for installing and administrating SSRS reports on SQL server 2008.

Created professional dashboard to meet industry standards using Dundas Charts.

Involved in fixing the issues with UAT team.

Converted excel reports to SSRS reports.

Creation, manipulation and supporting the SQL Server Database.

Created Stored Procedures, User-defined Functions to take care of back end validations when transferring data to Production Server.

Working with Cross Functional Teams and interacting with all levels of management.

Conducting User Acceptance Testing (UAT) and documentation of test cases.

Tools Used: SQL Server 2008, SSRS, Visio, Visual Studio 2008.

Consultant (July 2008 – April 2009)

Century Pacific Group (Philippines)

Project: Report Development Using COGNOS.

Detailed analysis of user requirements.

Perform analysis, design, and document report requirements.

Software installation and client server configuration.

Development of Cognos solutions.

Working with users and coordinating with application developers to understand and capture data/reporting requirements.

Training report authors.

Created Training material for the end users.

SQL Server configuration.

Offsite support post implementation of cognos solution.

Involved in fixing the issues with the UAT team.

Administration and Authorization.

EDUCATION, TRAINING, AND CERTIFICATIONS

Bachelor of Technology in Computer Science (BTECH) JNTU - India

Contact this candidate