Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Balaji Chandran

McLean,VA

Summary

Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals. Background includes Data warehousing, Data Visualization, Reporting, Cloud services and Data analytics. Proficient in Data engineering, Architecture, Cloud Technologies and deep learning. Quality-driven and hardworking with excellent communication and project management skills.

Overview

17
17
years of professional experience
1
1
Certification

Work History

Sr. BI Architect, Lead Design, Data Visualization

H-E-B Grocery
06.2023 - Current
  • Developed customized reports for business stakeholders, improving decision-making capabilities.
  • Collaborated with cross-functional teams to identify key performance indicators and align data strategies accordingly.
  • Spearheaded the migration of legacy systems to modern BI platforms, streamlining data access and analysis.
  • Implemented robust security measures to protect sensitive data from unauthorized access or breaches.
  • Evaluated emerging technologies and implemented best-fit solutions for continued growth in business intelligence capabilities.
  • Provided end-user training on BI tools, empowering employees to make data-driven decisions confidently.
  • Performed routine maintenance of BI infrastructure, ensuring optimal performance and minimal downtime.
  • Streamlined reporting processes by automating manual tasks, saving time and reducing human error.
  • Established a solid governance framework to maintain consistency in data definitions and calculations across the organization.
  • Designed complex queries for ad-hoc analysis, providing valuable insights into previously unexplored areas of the business.
  • Monitored system usage patterns and made recommendations for capacity planning, ensuring scalability as organizational needs evolved.
  • Integrated disparate data sources into a centralized repository, enabling unified reporting and analytics capabilities.
  • Collaborated with system architects, design analysts and others to understand business and industry requirements.
  • Established and secured enterprise-wide data analytics structures.
  • Reviewed project requests describing database user needs to estimate time and cost required to accomplish projects.
  • Documented and communicated database schemas using accepted notations.
  • Enhanced BI system performance by optimizing data models and implementing efficient ETL processes.

Sr. BI Architect, Lead Design, Data Visualization

Novo Nordisk
10.2022 - 06.2023
  • Working as a BI Solution Architect to design inbound data from Mobile originated for the patient enrollment/registration/activity recorded. Working on Major initiatives of the business development team like ‘Proposal development’, ‘Client Ask New Cloud Service Development’ Patient Communicable universe, high value actions reports and OmniSMS initiatives.
  • Responsible for Tableau Environment, Security, Architecture setupalong with creating users, groups, and Projects and assigning role level access.
  • Worked on database migration forTableau/Powerbi/Qliksense reporting from the secured access the data files from the, Adobe campaign Management, S3 and Snowflake database.
  • Created STTM & Data dictionary documents.Created Technical specification documents related to Tableau design and architecture.
  • Createdseveral tableau data extracts with prebuilt calculations, parameters and sets to enable end users to easily utilize the extracts as semantic layer to create their own dashboards.
  • Created Multiple PTAB tables for the Performance tuning of Tableau workbooks and extracts to make them functional with large sets of data.
  • Supported Powerbi/Qliksense reports while migrating database from sqlserver to corporate datawarehouse in Snowflake.
  • Created responsive workbooks for iPad/Mobile/PC orientation views and worked with end user in creating complex dashboards in an iterative process. Created Server Monitoring workbook views and confidential custom workbook to see ‘My Activity’ on Tableau server using Tableau Server Repository Database (PostgreSQL).

Lead Solution Architect

Johnson & Johnson
01.2022 - 09.2022
  • Delivered complex IT solutions by leading cross-functional teams and utilizing cutting-edge technologies.
  • Reduced project costs and optimized resources by implementing efficient solution architecture processes.
  • Achieved on-time delivery for all projects by effectively managing timelines, milestones, and team collaboration.
  • Enhanced system performance with well-designed infrastructure and application optimizations.
  • Developed high-quality documentation to support project requirements, design decisions, and architectural strategies.
  • Standardized tools, frameworks, and methodologies across projects for streamlined processes and consistent results.

Lead BI Solution Architect

World Bank Group (WBG/IFC)
09.2012 - 12.2021
  • Assisting customers in simplifying the Architecture by Automation using JSON Templates, Python scripts, Azure Fn and Power shell.
  • Improved solution efficiency by designing and implementing scalable architectures for enterprise clients.
  • Being a team and as an individual given ownership on the agile methodology to complete user stories for building Power BIdashboards, Power BI Report builder (SSRS)reports, Tableau dashboard in biweekly sprint.
  • Reduced system downtime through proactive monitoring, maintenance, and optimization of IT infrastructure.
  • I have extensively worked on Powerbi Dashboard, created cards, charts, drill through, drill down and linking the dashboard.
  • Have created mobile apps using Power Apps for user to append changes to existing texts and additional checks.
  • Using Power Automate, added automatic report refresh alerts and outlier’s triggered alerts. Added automate to trigger email to intimate approval request from the business.
  • Have excellent hands on in Analysis service, Azure Data Lake, Azure Delta Lake in implementing SCD type 2 dim for capturing the snapshot and type 1 for overriding the records.
  • I have worked on azure functions to create a dynamic report bursting using C# scripts for snapshotting Powerbi SSRS reports.
  • Writing DAX queries for building paginated reports/UI front end Angular/Ajax reports using Json files.
  • Writing detailed Drill through DAX queries for accessing drill through reports from Widgets/Summary reports.
  • Creating Azure functions to embed the Power BI reports via REST API to run the batch jobs for taking monthly snapshots either PDF/Excels.
  • Every Month periodic snapshot will be validated with the Standard reports portal system and then 1000 odd snapshot reports (pdf & excel) will be auto generated and shared via online share point library.

Education

Bachelor of Science - Computer Science And Systems Engineering

JNTU University
Tirupathi, Andhra Pradesh, India
05.2006

Skills

  • Problem Solving
  • Data Modeling
  • Architecture and Design Solutions
  • Dashboard Visualization
  • Report Development - Tableau, Power BI
  • Azure Data Bricks, Synapse Analytics, AWS Technologies
  • Data Warehousing
  • SQL Proficiency
  • Data Visualization
  • RDBMS
  • SQL and Databases

Certification

  • OCA Certified (SQL, PL/SQL)
  • AWS - AWS Technical Practitioner Professional
  • Azure DP 900, Azure DP 200 Certified Associate
  • AWS – AWS Associate Solution architect certification program is in progress

Timeline

Sr. BI Architect, Lead Design, Data Visualization

H-E-B Grocery
06.2023 - Current

Sr. BI Architect, Lead Design, Data Visualization

Novo Nordisk
10.2022 - 06.2023

Lead Solution Architect

Johnson & Johnson
01.2022 - 09.2022

Lead BI Solution Architect

World Bank Group (WBG/IFC)
09.2012 - 12.2021

Bachelor of Science - Computer Science And Systems Engineering

JNTU University

Similar Profiles

CREATE PROFILE
Balaji Chandran