Summary
Overview
Work History
Education
Skills
Software
Certification
Timeline
Generic

Aparajita Jena

Business Intelligence Lead
Irving,TX

Summary

Over 15 years of experience as a BI Architect/Lead, leading cross-functional teams to develop and implement business intelligence strategies.

Expertise in designing data warehouses, ETL processes, and data visualization solutions to support data-driven decision-making.
Extensive experience in data analysis, data modeling, ETL processes, and data visualization.
Strong ability to bridge the gap between technical and non-technical stakeholders, translating business needs into actionable BI strategies.
In-depth knowledge of BI tools and technologies, relevant tools -Domo,Power BI ,Tableau & OBIEE
Adept at data governance, data quality management, and ensuring data compliance.

Overview

15
15
years of professional experience
4
4
years of post-secondary education
9
9
Certifications

Work History

BI Analyst Lead

Allied Stone Inc.
Irving, TX
03.2023 - Current
  • Analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data.
  • Used Domo, business intelligence and other reporting tools to extract data from data solutions and data warehouses.
  • Created and automated data visualizations to present insights and tell compelling stories.
  • Leading a team of 5 Data Analysts & 3 BI Developers, involved in project planning, estimation process.
  • Root cause analysis of problems, evaluate solutions and make decisions.
  • Dimensional Modelling (Star Schema) Data Mining & Designing ETL workflows
  • Designing Dashboards, Cards, Implementing Data Level Security and Object Level Security
  • Optimization and performance tuning of SSMS SQL queries
  • Setting up Azure server and connecting for push/pull data.
  • Provided technical support for troubleshooting analytics and reporting issues.
  • Designed and developed data pipelines to acquire, clean and process data.
  • Developed and implemented data governance policies and procedures.
  • Led server infrastructure development, quality assurance, staging and production systems.

BI Analytics Lead

Amazon
Seattle, WA
09.2021 - 02.2023
  • Requirement Analysis, Design and creating functional spec
  • Liaison between Amazon and Tango Analytics team and led a team of 6 offshore BI Developer (India)
  • Building OBIEE reports and dashboards to build 360 views of different business functions KPIs for asset management /LAT Finance and Admin Team
  • Development of Athena queries and data analysis using Athena
  • Worked AWS S3 and Quick sight.
  • Developed and implemented data collection systems and other strategies to optimize statistical efficiency and data quality.
  • Analyzed large amount of data to identify trends and patterns, hidden stories within data.
  • Performed root-cause analysis on data-related system problems to recommend or execute corrective action.
  • Managed key tasks and resources to achieve cost, schedule and strategic growth initiatives.

Senior BI Consultant

Five Cubes Inc
Irving, TX
05.2019 - 08.2021
  • Drafted strategic business intelligence roadmap, complete with data governance policies and tactical information safeguards.
  • Directed implementation of new business intelligence tools, selecting appropriate solutions and aiding in corresponding onboarding processes.
  • Collected data from wide-ranging sources.
  • Created data analysis tools to allow teams to query acquired information for unique details.
  • Developed and maintained data warehouses and data marts to support business operations.
  • Created data models to support decision-making processes.

Senior BI Developer

Overhead Doors Corporation
Lewisville, TX
02.2017 - 02.2019
  • Designed customized data collection models for specific visualization tasks.
  • Liaised with DevOps team to integrate business intelligence assets into future development lifecycles.
  • Integrated BI assets into customer relationship management tasks, improving service personnel's available intelligence.

Senior BI Analyst

CBRE
Dallas, TX
03.2015 - 12.2016
  • Drafted strategic business intelligence roadmap, complete with data governance policies and tactical information safeguards.
  • Integrated BI assets into customer relationship management tasks, improving service personnel's available intelligence..
  • Developed and maintained data warehouses and data marts to support business operations.
  • Designed customized data collection models for OBIEE visualization tasks.
  • Created dashboards to monitor and track key performance indicators.
  • Generated ad-hoc reports to evaluate specific business requirements.

ERP Specialist

Ut Southwestern Medical Center
Dallas, TX
12.2013 - 12.2014
  • Analyzed complex project server issues and worked on large enterprise and business-critical applications.
  • Devised scripts and automation tools to improve system efficiency.
  • Developed and documented network policies, procedures and standards.
  • OBIEE Reports and Dashboards Development and Maintenance
  • Led server infrastructure development, quality assurance, staging and production systems.

OBIEE Programmer

UT Arlington
Arlington, TX
12.2012 - 12.2013
  • Coordinated with stakeholders to define project technical requirements.
  • Worked with cross-functional design teams to create software solutions that improved overall functionality and performance.
  • Developed in-house applications designed for company needs.
  • Implemented encryption, authentication and additional security measures, safeguarding systems.
  • Created web-based dashboards and reporting tools for data visualization.
  • ODI ETL Mappings and Data Modelling Using Erwin Tool

BI Consultant

Tata Consultancy Services
Kolkata, West Bengal
04.2004 - 11.2012
  • Drafted strategic business intelligence roadmap, complete with data governance policies and tactical information safeguards.
  • Directed implementation of new business intelligence tools, selecting appropriate solutions and aiding in corresponding onboarding processes.
  • Created data analysis tools to allow teams to query acquired information for unique details.
  • Handled massive quantities of business intelligence data, personally managing as much as 10 terabytes.
  • Developed complex dashboard and reporting tools to track business performance metrics.

Education

Bachelor of Science - Electrical Engineering

Utkal University
India
06.1998 - 06.2002

Skills

Data Visualization - OBIEE, DOMO,Tableau, Power BI

undefined

Software

OBIEE

Tableau

Domo

Power BI

Peoplesoft,Oracle EBS,SPS,2020

Certification

Oracle Business Intelligence Foundation Suite 11g Certified Implementation Specialist

Timeline

BI Analyst Lead

Allied Stone Inc.
03.2023 - Current

BI Analytics Lead

Amazon
09.2021 - 02.2023

Senior BI Consultant

Five Cubes Inc
05.2019 - 08.2021

Senior BI Developer

Overhead Doors Corporation
02.2017 - 02.2019

Senior BI Analyst

CBRE
03.2015 - 12.2016

ERP Specialist

Ut Southwestern Medical Center
12.2013 - 12.2014

OBIEE Programmer

UT Arlington
12.2012 - 12.2013

BI Consultant

Tata Consultancy Services
04.2004 - 11.2012

Bachelor of Science - Electrical Engineering

Utkal University
06.1998 - 06.2002

Similar Profiles

CREATE PROFILE
Aparajita JenaBusiness Intelligence Lead