OMER SHAIK
Chicago,USA
Summary
Senior BI/Data Warehouse Developer with over 6 years of experience designing, developing, and maintaining enterprise data warehouses and business intelligence solutions. Skilled in Oracle PL/SQL, Cognos-compatible reporting, ETL tools (Informatica, ODI), and data modeling. Experienced in building data marts, designing dashboards, and training end-users on BI tools. Adept at communicating technical solutions to stakeholders, analyzing complex data, and supporting Financial, HR, and Higher Education domains, including Ellucian ODS/EDW environments.
Overview
6
6
years of professional experience
1
1
Certification
Work History
Senior Software/Data Engineer
Truist Bank
07.2024 - Current
- Built SQL Server and ADF-powered data marts to support customer service analytics; delivered training to users on using new dashboards.
- Integrated real-time CDC feeds via Kafka into a microservices data architecture; supported reporting layer development.
- Designed and documented training content for internal stakeholders to use REST APIs and Spark analytics tools.
- Created and led internal sessions on interpreting system-wide KPIs through data visualizations and dashboards.
Data Engineer
Mayo Clinic
05.2023 - 06.2024
- Created HIPAA-compliant pipelines using PL/SQL, Airflow, and BigQuery to process clinical and financial datasets.
- Developed dashboards to monitor health metrics; documented and trained analytics teams on new workflows.
- Provided curriculum and walkthrough videos to upskill analysts on querying healthcare datasets.
- Built standardized templates and data marts to enable faster dashboard prototyping.
Cloud Software Engineer
Media Agility
12.2021 - 05.2023
- Migrated ETL workloads to Azure and Spark; integrated Redis and Oracle for performance-sensitive pipelines.
- Developed financial and HR reporting systems for education clients using Oracle DB and Informatica.
- Delivered weekly SQL and BI tool training for analysts and junior engineers; recorded sessions and published video guides.
ETL/Software Engineer
Brio Technologies
01.2020 - 11.2021
- Built Informatica-based ETL workflows and wrote PL/SQL stored procedures to support financial reporting systems.
- Modeled dimensional schemas in Oracle to enable analytics on HR and payroll data.
- Provided documentation and live training on ETL monitoring, exception handling, and BI usage for business users.
- Migrated batch jobs from Hadoop to Spark, improving dashboard update frequency and consistency.
Education
Master of Science - Data Analytics
Indiana Wesleyan University
Marion, IN04.2025
Bachelor of Technology - Electronics & Communication Engineering
CMR Institute of Technology
01.2021
Skills
- BI & Reporting: Cognos Report Studio, Oracle BI, Power BI, Tableau, Apache Superset, Report/Dashboard Design, Data Marts
- Languages: PL/SQL, SQL, Python, Java, T-SQL, Shell Scripting
- ETL Tools: Informatica, Oracle Data Integrator (ODI), Apache Airflow, dbt
- Data Warehousing: Oracle, SQL Server, BigQuery, PostgreSQL, Star/Snowflake Schema
- Cloud Platforms: AWS (Glue, Redshift, Lambda), Azure (ADF), GCP (BigQuery, Dataflow)
- Data Integration: Kafka, Spark, Sqoop, CDC (Change Data Capture)
- DevOps & Monitoring: GitHub Actions, Jenkins, Docker, CloudWatch, Azure Monitor
- Training & Documentation: Curriculum Design, End-user Training (1:1 & Group), Video Library Creation, D2L Platform, Technical Writing
- Governance & Security: HIPAA Compliance, IAM, KMS, RBAC, Data Quality & Lineage
- Domain Knowledge: Financial Systems, HR Data, Higher Education Data, Ellucian ODS/EDW
Certification
- AWS Certified Data Engineer – Associate, Amazon Web Services – 2025
- Data Science Certification, 360 DigiTMG Institute – 2023
KEY STRENGTHS
- 6+ years of experience in BI development, data warehousing, and analytics
- Expertise in Cognos-style reporting, PL/SQL, Oracle databases, and ETL pipelines
- Proven ability to design and lead end-user training and documentation initiatives
- Familiar with Ellucian systems and Higher Education data models (HR, Financials, Student)
- Strong communication, problem-solving, and stakeholder management skills
- Authorized to work in the U.S. under OPT (no sponsorship required)
Timeline
Senior Software/Data Engineer
Truist Bank
07.2024 - Current
Data Engineer
Mayo Clinic
05.2023 - 06.2024
Cloud Software Engineer
Media Agility
12.2021 - 05.2023
ETL/Software Engineer
Brio Technologies
01.2020 - 11.2021
Bachelor of Technology - Electronics & Communication Engineering
CMR Institute of Technology
Master of Science - Data Analytics
Indiana Wesleyan University
Similar Profiles
Orinthia (O.J.) BeaversOrinthia (O.J.) Beavers
Senior Mortgage Underwriter at Truist Bank (formerly SunTrust Bank)Senior Mortgage Underwriter at Truist Bank (formerly SunTrust Bank)
Tiaranee Williams-KelleyTiaranee Williams-Kelley
Business Client Care Servicing Specialist I at Truist BankBusiness Client Care Servicing Specialist I at Truist Bank
Eleonora GómezEleonora Gómez
Senior Relationship Banker at Truist BankSenior Relationship Banker at Truist Bank
MARCUS WINSTONMARCUS WINSTON
MERS Specialist 1 at Truist BankMERS Specialist 1 at Truist Bank
Michael A. Espinosa JrMichael A. Espinosa Jr
Adjunct Lecturer - Mariachi Fuego Director at University of Illinois, UICAdjunct Lecturer - Mariachi Fuego Director at University of Illinois, UIC