OBIEE
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
SQL ,PL/SQL
Data Warehousing
ERP - Peoplesoft, Oracle EBS,SPS,2020
Database Management
Predictive modeling
Software
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