Sangar S.
BI Architect at Carhartt
- Role
- Bi Architect at Carhartt
- Location
- Detroit, MI, US
- LinkedIn followers
- 500 followers
About Sangar S.
Expertise in creating semantic models using SQL Server technology in the areas of…
Experience
Bi Architect
Aug 2018 — Present · Dearborn, MI, US
Served as the principal architect for designing, developing, and delivering Tabular models, Power BI Datasets, and reporting solutions in Power BI & SSRS Paginated Reports.• Involved in architecting and creating Dimensions, KPIS, Measures, Calculations, Calculated Tables, aggregations, and partitions. • Worked on multiple hierarchies, data-driven KPI goals, handling Type-2 slowly changing dimensions. Created a partitioning strategy to minimize daily processing of partitions through ADF. • Created Power Queries, M Queries, DAX tables, Measures, calculated columns, measures, relationships, time intelligence and Attributes for the Reports and Tabular Models. • Involved in configuration of Azure SSAS Setup, Azure Functions, Azure run books to Auto scale, On Premises Gateway Configuration, Tier Allocation, QPU Management and Scale out. • Primarily responsible for Administration and Configuration of Power BI Gateway, Pipelines, Data Flows, User Setup and Organizational Workspace, Content packs, report deployment and App publishing. • Developed and administered Power BI datasets, Power BI data flows and Power BI Apps. Wrote calculated columns, Measures queries, rolling period calculations, time frame logic and trend calculations using DAX in Power BI. • Designed and developed business intelligence dashboards, mobile reports, tracking frameworks, key KPI’s and interactive data visualizations, analytical reports and data visualizations using Drill through reports, custom bookmark pages, mobile reports and executive dashboards for corporate users in Power BI. • Responsible for setting the policies, procedures, and controls put in place to manage the deployment, development, and usage of Power BI across an organization. This includes Data Security, Data Quality, User Training and Adoption, Report and Dashboard Development, Change Management, Monitoring and Auditing and Integration with Other Systems
Education
New Mexico State University
Master of Science (M.S.), Computer Science
2005 — 2008
University of Madras
Bachelors, Computer Science
2000 — 2004
New Mexico State University
Master of Business Administration (M.B.A.), Finance, General
2009 — 2011
New Mexico State University
Graduate Certification, Finance
2009 — 2011
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.