Power Bi Sql Server

Gaurav Gautam

**** ********** *** *** *****, CA *4583 Cell 925-***-**** **********@*****.***

Summary

Build complex data pipelines with various type of source system such as SQL server, Kafka, oracle, flat files, cloud sources with destination systems such as Azure Synapse, Redshift, Snowflake, ADw, etc.

Leveraged various ETL and pipeline technologies such as SSIS, Azure Data Factory, Golden gate, ODI, Informatica.

Built analytics dashboards to demonstrate customer journey for B2B and B2C customer groups using data from Web analytics platforms such as Adobe Analytics, Google analytics, (SEM) Marketing pixels, Email marketing, SEO, CRM and ERP.

Total 17 years’ experience in the area of Analytics, SQL, RDBMS, EDWS and BI tools.

12 years of experience in leveraging SQL, databases, Spotfire, Power BI, Tableau, Qlik, & SQL.

Advanced experience in Adobe or Google Analytics

Advanced user of Spotfire, Tableau and Power BI.

7 years of experience in using Azure, GCP & Google query.

Expert skills in dealing with multitude of data sources such as web analytics, excels, Google analytics, etc. and budling complex dashboards on Power BI.

Advanced skills in Excel functions and formulas and data wrangling including pivoting.

Ability to build dashboard and reports in power BI to depict and demonstrate stories.

Experience

Oct 18 – Till Date Lotus Fee LLC (Sempra Energy) TIBCO Spotfire Architect

.

Managed end to end BI system – build pipeline, ETL, Analytics model and Power BI dashboard.

Perform initial configurations and implementation of Microsoft Power BI architecture in coordination with EBI management team.

Review and expand any existing usage standards, processes or training materials as part of implementation.

Administer Microsoft Power BI platform and On-Premise Gateway, lead upgrade planning, configuration, and capacity planning.

Coordinate with Microsoft Premium Support and other EBI team members when troubleshooting and resolving performance issues.

Guide Power BI Dashboard developers and other colleagues during dashboard development using Power BI and DAX to establish and promote best practices for dashboard and data set development and publishing (location, layout, dataset access, DAX usage, security, performance tuning, naming conventions).

Optimize Workspaces and datasets to promote ease of self-service, and provide a secure, structured organization of workspaces, apps, data sets and dashboards.

Worked with business teams to define technical requirements, functional requirement and then build the data pipeline using SSIS to bring data from SQL server, Oracle, Salesforce, Google analytics, Adobe analytics into Azure SQL server.

Set up time based and event-based refresh of the data on the destination system.

Created elaborate design, document and user guides on how to do it or use it.

Leveraged Power BI to using Dashboard/reports/analysis to measure performance of different cross-functional channels, initiatives, campaigns and created foresight for future improvements.

Developed various types of stories driven dashboards, using Power BI that support business use-cases, feature/functionality concepts.

Train and evangelize dashboard usage and encourage data driven decision making.

Extensively used SQL and excel for driving actionable business insights from disparate data systems.

Create key reports and extract insights from various data sources using SQL, excel and Power BI.

Drive business decision making by creating actionable dashboards/reports in Power BI/Excel.

Worked extensively on SQL Server SSIS, SSAS, Power BI, Azure, Azure Synapse and data factory.

Examples of dashboards build.

oProfit loss analysis

oSEM and SEO performance

oEmail marketing performance

oKPI dashboards

oSales Summary

oOrganic social

oExecutive dashboard

oProduct analytics

oProduct usage

Dec ‘10 – Sep 18 Disney/Twenty First Century Fox Sr data Analyst

Designed and implemented ETL packages and pipeline from adobe analytics data feed, SQL server sales data, order data, etc. to Azure cloud analytics database.

Worked with business to consolidate technical and functional specifications for BI system design.

Translated technical design document into workable solution using hands on experience with SQL server, SSIS, Azure, Adobe analytics, Google analytics, etc.

Manage metrics creation, data collection, data ingestion, and reporting the overall performance of business through Power BI dashboards.

Develop sound reporting around traffic, engagement, conversion, return rate, loyalty, AOV, RPV and RPS in Power BI/Excel using data from various sources

Performed analysis using SQL and Power BI on customer life cycle, customer segmentation & market basket analysis.

Monitor, analyze, and report on traffic and conversions using business data sets on MS Excel and Power BI.

Collaborate with data-warehouse design & operation team to ensure marketing data is collected and cross-linked in right way simplifying Ad-hoc data analyses & reporting

Leveraged Azure and AWS for various services.

Skills/Software

BI skills: Qlik, Power BI, Tableau, MS Excel and SQL.

MS Office: MS Excel, MS Outlook, MS Word, MS Visio.

Passionate to learn new skills/ technologies as needed.

Databases: SQL Server, Oracle, Post-gres, Redshift SQL/PL SQL.

Oracle data sync, Oracle golden gate

Clouds: Azure, AWS, GCP and OCI

Pipeline and ETL : SSIS, SSAS, Informatica, Analytical cube modeling, Power BI Data Prep, Power PI modeling.

Education

Bachelor of Science in Computer Science, NITK Surathkal, India May, 05

Contact this candidate