.

.

Puneet Nagri

Sr. Data & BI Solutions Architect

Hartford, CT, 06106

860-***-****

admq1p@r.postjobfree.com

https://www.linkedin.com/in/puneet-nagri/

VISA: H1B

Senior BI practitioner with total 10+ years of experience in building rapid BI solutions and its automations. Extensive end to end (data to dashboard) experience in various business functions like product, actuarial, operations, geospatial, customer, sales etc. Hands-on experience in creating tailored solutions for differing business requirements. 5+ years of experience in leading BI teams and developing resources from both offshore & onshore locations. Working directly with sales team to build custom embedded BI solutions, for past 1 year.

Skills

E2E Business Intelligence & Analytics

Excellent

SQL/PLSQL (ETL/Data Wrangling)

Excellent

Scripting/Automation

Excellent

Data Visualization/UX

Excellent

Business Requirements Analysis & Design

Excellent

Tools & Technologies

Microstrategy Tools for Analytics, Embed & SDK

Excellent

HTML & JavaScript (Client side)

Very Good

Teradata/Microsoft SQL Server/Netezza/Oracle

Very Good

Excel VBA/Windows Scripting

Very Good

ESRI ArcMap/ArcPro

Good

Cognos Reporting Tool and Data modeler

Average

.

.

Work History

Senior Consultant Lead BI Architect

Accenture (Property & Auto Insurance Client), Hartford, CT

• Major responsibilities: Solution Architect for Field Sales embedded solution in Salesforce. Business function lead for Product and Actuarial. SME for Microstrategy, Teradata and Rapid BI solutions.

• Delivered 3 major BI applications as embedded solution in salesforce using REST API, bringing data from disparate granularity together.

• Created and optimized reusable core data assets for analyzing quoting behavior, policy profile and post monitoring.

• Delivered rapid BI solutions for Underwriting, 3rd party data, regulatory and Mylearning.

• Conducted technical POCs (proof of concept) and developed strategies to implement them.

• Conducted training workshops and knowledge sharing session for end client. Lead BI Architect Location Lead

Accenture (Property & Auto Insurance Client), Bangalore, Karnataka

• Lead of Info delivery team of 6 members.

• Developed BI solutions through complete data life cycle (Staging, Wrangling, Governance, Delivery, Quality, Performance/Usage) for various business areas like product, actuarial, operations, geospatial, customer, sales etc.

• Using Jenkins, Access/Excel macros and SQL, built various BI solutions, which bring data from multiple sources (Teradata, Sql server, SAS, file system etc.) and dissimilar granularity together into one Dashboard.

• Built automatic data compression procedure in Teradata, which compresses huge tables(~100GB) by approximately 60%, saving disk space.

• Created COE best practices for geospatial analytics. Created geospatial BI solutions rendering custom points and polygons.

• Performed location analytics of finding shortest path, intersection, union and spatial join of shapes. Implemented automations which reduced processing time by 90%.

• Built Fraud identification dashboard, which enabled business partners to quickly gauge footprint of customer/quote/policy/claim across systems.

• Built data consumption layer for self-service BI.

• Built data quality framework and quality scorecard.

• Built home grown tool for work and resource management. BI Architect

Accenture (Telecom Client), Bangalore, Karnataka

• Created workflows and strategies of bringing Microstrategy tool as reporting capability.

• Designed Microstrategy schema for self-service reporting. Senior BI Consultant

Accenture (BI Capability), Bangalore, Karnataka

• Analyzed designs and performed project estimation for BI solutions.

• Demoed technology solutions to business partners. 2019-09 - Current

2015-11 - 2019-09

2014-01 - 2015-10

2013-07 - 2013-12

.

.

BI Developer Analyst

Accenture (Retail Client), Bangalore, Karnataka

• Redesigned 300+ Cognos Report Net Dashboards to Cognos 10 Dashboards.

• Optimized system and platform performance capabilities with simple MS office-based accelerators and automations.

Education

Bachelor of Technology: Computer Science

GGSIPU - Delhi

High School: Science + Math

Kendriya Vidyalaya (Public School) - Jammu

Grade 10

Kendriya Vidyalaya (Public School) - Jammu

Certifications

IBM Cognos Report Author

IBM Cognos Metadata Modeler (Framework Manager)

IBM Pure Data Systems for Analytics (Netezza)

.

2011-04 - 2013-07

2006-08 - 2010-08

2005-04 - 2006-03

2003-04 - 2004-03

Contact this candidate