Chiranjib Nath

Senior/Lead Business Intelligence Developer at H-E-B, Inc.
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Austin, Texas, United States, US
Skills

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
Join now
You need to have a working account to view this content.
Join now

Credentials

  • The Neuroscience of Strategy and Creative Leadership
    LinkedIn
    May, 2023
    - Oct, 2024
  • Learning Power BI Desktop
    LinkedIn
    Jan, 2023
    - Oct, 2024
  • Top 10 Skills for BI Developers
    LinkedIn
    Jan, 2023
    - Oct, 2024
  • Advanced Microsoft Power BI
    LinkedIn
    Dec, 2022
    - Oct, 2024
  • Data Dashboards in Power BI
    LinkedIn
    Dec, 2022
    - Oct, 2024
  • Power BI Data Visualization and Dashboard Tips, Tricks, & Techniques
    LinkedIn
    Dec, 2022
    - Oct, 2024
  • Power BI Essential Training (2020)
    LinkedIn
    Dec, 2022
    - Oct, 2024
  • Power BI Top Skills
    LinkedIn
    Dec, 2022
    - Oct, 2024
  • Power BI: Dashboards for Beginners
    LinkedIn
    Dec, 2022
    - Oct, 2024
  • California Consumer Privacy Act (CCPA) Essential Training
    LinkedIn
    Aug, 2021
    - Oct, 2024
  • Creating a Great Place to Work for All
    LinkedIn
    Aug, 2021
    - Oct, 2024
  • Diversity and Inclusion in a Global Enterprise
    LinkedIn
    Aug, 2021
    - Oct, 2024
  • Learning GDPR
    LinkedIn
    Aug, 2021
    - Oct, 2024
  • Advanced Microsoft Power BI
    LinkedIn
    Jul, 2021
    - Oct, 2024
  • Power BI for Marketers
    LinkedIn
    Jul, 2021
    - Oct, 2024
  • How to Rock an Interview
    LinkedIn
    Jun, 2021
    - Oct, 2024
  • Learning Azure SQL Querying
    LinkedIn
    Jun, 2021
    - Oct, 2024
  • Learning Power BI Desktop
    LinkedIn
    Jun, 2021
    - Oct, 2024
  • Programming Foundations: Databases
    LinkedIn
    Jun, 2021
    - Oct, 2024
  • Advanced SQL for Data Scientists
    LinkedIn
    May, 2021
    - Oct, 2024
  • Business Analyst and Project Manager Collaboration
    LinkedIn
    May, 2021
    - Oct, 2024
  • Marketing Foundations: Competitive Market Analysis
    LinkedIn
    May, 2021
    - Oct, 2024
  • Power BI Data Modeling with DAX
    LinkedIn
    May, 2021
    - Oct, 2024
  • SQL Tips, Tricks, & Techniques
    LinkedIn
    Mar, 2021
    - Oct, 2024

Experience

  • H-E-B, Inc.
    • United States
    • 200 - 300 Employee
    • Senior/Lead Business Intelligence Developer
      • Apr 2019 - Present

      • Profile data, build prototypes solutions, reports, and dashboards for displaying information based on business needs • Analyze business problems and issues using data from internal and external sources to provide insight to end-user/Business team and decision-makers • Excellent communication and analytical skills as a BI Developer, I work on Enterprise Objectives that may participate in a consultation with users in cross-functional teams to address business issues. • Planning and Analysis for Sales, Indirect spend, and Product data. • Worked on gathering business requirements from the business partners. • Created Logical and Physical Data model based on the business requirements • Created Projects on MicroStrategy – Planning and Analysis (P&A) and Digital Commerce (eCommerce) • Maintained Projects on MicroStrategy. • Created MicroStrategy Schema objects – Attributes, Facts, Hierarchy, Transformations, Logical Views • Created MicroStrategy Public objects – Metrics, Filters, Consolidations, and Groups. • Developed Grid and Graph reports on MicroStrategy (MSTR) reporting tool. • Created Dossier, Documents, and Analytics Solution on MSTR Developer. • Performed Data blending for Source data and created Dossier based on the Business requirements. • Created Aggregated Fact table based on Data Mart on MSTR Developer. • Created Snowflake Schema, views on Teradata. • Analyzed data for Indirect Spend, Department (Accounting, Floral, Pharmacy), Sales, and Product, location, time, Home Delivery,Cold Chain, Omnichannel. • Performed Unit Testing after developing new artifacts – Grid reports, Documents and Dossiers. • Performed Deployment activity – Creating RFC, IBOP. • Supported Production issues and resolved in on time. • Collaborate closely with stakeholders across procurement, merchants, supply chain, marketing, IS, finance & accounting, and store operations to understand and prioritize business needs • Take ownership and accountability over projects and outcomes Show less

  • General Motors
    • United States
    • Motor Vehicle Manufacturing
    • 700 & Above Employee
    • Business Intelligence (BI) Data Analytics Developer/ Software Development Associate
      • Sep 2013 - Feb 2019

      • Worked on report development, performing requirements gathering, and testing. • Created Cognos Reports, Dashboards, Visualizations & Framework Packages modeling using databases: Teradata, Hadoop, Oracle, and MS SQL Server. • Created complex reports, dashboards, and Visualization Using Power BI Desktop and Tableau tools. • Created cubes based on the MS BI solution (MSAS) & developed reports by using Power BI Desktop, Excel template, and SSRS tool. • Created Hyperion Reports using Essbase multi-dimensional database Cubes. • Created data dictionary using Erwin data modeling tool. • Created Hadoop/HIVE tables for reporting analysis. Page 1 Resume of Chiranjib Nath • Worked in supporting deployment activities in Test/MTT, CERT/MTC, and production/MTP by using TFS tool. • Worked in Operation support – root cause analysis, defect resolutions • Worked in supporting QA Phase. • Worked in data analysis – deep dive analysis to support production issues. • Worked on Analyzing the reports using Smart View tool. • Validated the DataStage transformation jobs. • Responsible for analyzing the existing Data landscape at GM IT and work with the larger team in reconciling, enhancing and creating streamlined data models and data integration strategies. • Played an integral role in creating the next generation platform for Business Intelligence at GM. • Worked on data modeling and data integration. • Excellent collaborator– the ability to work cross-functionally. • Involved in identifying 3rd party data for profiling. • Developed tie-out reports for critical data-sets and applications. • Identify source systems and data-model. • Provide white-glove support and training to business. Show less

  • Employer: IT America Inc/ Client: Farm Credit Bank of Texas (FCBT)
    • Austin, Texas Area
    • Software Engineer
      • Dec 2012 - Jul 2013

      • Applied Data Warehouse principles including Fact and Dimension Tables in a Star Schema model • Written complex SQL Query • Planning, Designing, execution and reporting of tests and defects • Tested both Type 1 and Type 2 Slowly Changing Dimension (SCD) Data Warehousing tables. • Translated business requirements and/or report specifications into QA test cases. • Validated Data Warehouse specific tenants such as business to surrogate key mapping, • Validation of slowly changing dimension logic and testing source to target data lineage • Validated Fact and Dimension tables with Microsoft SQL Server 2008 utilizing data models and mapping documents • Validated the ETL package by using SSIS tools. • Validated the BI report by using MicroStrategy tool • Performed data analysis and root cause analysis techniques • Written Stored Procedures and triggers using t/SQL • Validated reports and comparing back to source system. • Extensive experience in creating Test Plans and Testing approaches in a Data Warehouse / Business Intelligence environment: planning, designing, management, execution and reporting of test cases and defects as well as the entire testing effort around a reporting/Data Warehouse • Ensured that QA tasks are linked to Sprint Backlog items in • TFS Develop test cases in TFS • Leaded a testing team and being responsible for test planning and scheduling Show less

  • Employer: IT America Inc/ Client: Lending Processing Services (LPS)
    • Orange County, California Area
    • Software Engineer
      • Jul 2012 - Sep 2012

      • I have written the SQL query to validate the source to target data by using SQL server 2008 R2 • Validated the ETL package by using SSIS tools. • Extensively used the Team Foundation Server (TFS) for team query, documentation, and task analysis • Used Microsoft Test Manager for executing test cases. • Followed Agile methodology • Analyzed business requirements to help drive and develop test cases. • Developed test cases in TFS • Executed test cases and provide feedback to Project Management and Development. • Captured test results in TFS. • Worked with QA automation engineers to drive and capture test cases in automated tests. • Participated in sprint task breakdowns • Recorded tasks in TFS • Ensured that QA tasks are linked to Sprint Backlog items in TFS • Ensured that test cases are linked to QA tasks • Ensured that bugs reported are linked to test cases or QA tasks • Ensured that progress is being captured in TFS • Collected and provided constructive feedback for Sprint retrospectives Show less

Education

  • West Texas A&M University
    Master of Business Administration - MBA, Business Administration and Management, General
    2019 - 2023
  • The City College of New York
    Master of Science (M.Sc.), Information Systems
    2009 - 2012
  • CUNY New York City College of Technology
    Bachelor of Technology (B.Tech.), Telecommunications Engineering Technology
    2008 - 2009
  • CUNY New York City College of Technology
    Associate in Applied Science (A.A.S.), Telecommunications Engineering Technology
    2005 - 2008

Community

You need to have a working account to view this content. Click here to join now