Deepankar Majumdar
Raipur
Summary
Results-driven Technology Analyst with 4.4 years in ETL development and cloud reporting. Skilled in Oracle Data Integrator, OBIEE, BI Publisher, Azure Cloud, and CI/CD automation. Experienced in SQL/PLSQL, Unix shell scripting, and data migration, focusing on dashboard development and job monitoring.
Overview
4
4
years of professional experience
3
3
Certifications
Work History
TECHNOLOGY ANALYST
INFOSYS LTD.
09.2021 - Current
- Designed and optimized ETL workflows using ODI 11g/12c, ensuring data integrity during migration from 11g to 12c.
- Developed and maintained OBIEE RPD (Physical, BMM, Presentation layers), including fact/dimension modeling, joins, hierarchies, and performance tuning.
- Created PL/SQL procedures and complex SQL queries for efficient data extraction and validation.
- Automated ODI and OBIEE processes with Unix Shell scripting for job execution, monitoring, and file handling, enhancing operational efficiency.
- Built OBIEE dashboards and reports with drill-downs, row-level security, and performance optimization through aggregates and caching.
- Developed analytics dashboards in OAC, including financial KPIs with automated data refresh.
- Managed production, test, and development jobs using ODI and SQL Developer, ensuring high system availability.
- Worked with Oracle GoldenGate to troubleshoot replication issues in coordination with DB teams.
- Performed testing using QTest and supported deployments through CRs and CI/CD processes.
- Collaborated in an Agile environment, contributing to sprint planning, execution, and delivery.
Education
MBA - AI & ML
D.Y. PATIL VIDYAPEETH
Pune05-2026
B.TECH - C.S.E
S.S.I.P.M.T
Raipur09.2021
Skills
- SQL and PL/SQL
- Unix scripting
- Data warehousing and modeling
- Oracle database management
- Business intelligence tools
- Data visualization with Tableau and Power BI
- Performance tuning and optimization
- Data extraction techniques
- Cloud infrastructure (Microsoft Azure, OCI)
- CI/CD pipeline management
- Version control (Git)
- ServiceNow administration
- QTest and Rally proficiency
- IT asset management (ITAM)
- Change management strategies
- Communication skills
- Analytical thinking
- Dashboard creation and development
- Dimensional modeling
- Star schema design
- Oracle BI expertise
- Report creation and BI publisher
- Python programming
Websites
Certification
• Microsoft Azure Fundamentals (AZ-900)
Accomplishments
- Reduced ETL runtime by 35% using parallel processing and tuning.
- Improved reporting SLA by 50%, enabling faster business decisions.
Projects
Pacific Gas and Electric (04/01/25 – present)
- Monitored PRD, TEST, and DEV jobs using ODI, SQL Developer, and Unix shell scripts to minimize downtime
- Troubleshot Oracle Golden-Gate replication issues with DB teams
- Developed and supported OBIEE RPD models and reports using PL/SQL and SQL
- Worked on OCI projects using ABS and BCS to generate CCB reports via OpenText
- Used ALM for defect tracking and coordinated with cross-functional teams
SERVCO (01/01/25 – 03/01/25)
- Managed production jobs using ODI and shell scripts, proactively resolving failures
- Supported OBIEE reporting and basic RPD maintenance
Infosys – Internal project (11/01/24 – 12/01/24)
- Developed OBIEE RPD (Physical, BMM, and Presentation layers) and built interactive dashboards
- Used PL/SQL for data validation, and optimized SQL queries for reporting
- Implemented drill-downs, prompts, row-level security, and performance tuning
Infosys – Internal project (10/01/24 – 11/01/24)
- Built a financial analytics dashboard in OAC using ODI and cloud warehouse data
- Created KPIs, and automated data refresh using ETL flows and scheduling scripts
National Australia Bank (02/01/22 – 09/01/24)
- Migrated ODI code from 11g to 12c, and automated deployments using Unix shell scripts
- Developed and optimized PL/SQL procedures, functions, and complex SQL queries
- Supported OBIEE RPD development, consistency checks, and performance tuning
- Managed export/import, QTest validation, patching, password rotations, and CRs
- Worked in Agile teams with sprint planning, retrospectives, and task estimation
Languages
- Hindi
- Bengali
- English
- Hindi
- Bengali
Professional Development
Data Analytics Bootcamp – Coding Ninja (12/01/24 – present)
- Gained hands-on experience in Python for data analysis, automation, and visualization using Pandas, NumPy, and Matplotlib
- Learned advanced Excel (formulas, functions, dashboards, productivity techniques) for efficient data analysis
- Developed strong skills in SQL for querying, cleaning, and manipulating large datasets
- Trained in Power BI to design and publish interactive dashboards and reports
- Introduced to machine learning fundamentals and generative AI concepts for intelligent, data-driven solutions
Languages
English
Proficient (C2)
C2
Hindi
Proficient (C2)
C2
Bengali
Proficient (C2)
C2
Japanese
Beginner (A1)
A1
Korean
Beginner (A1)
A1
Timeline
TECHNOLOGY ANALYST
INFOSYS LTD.
09.2021 - Current
MBA - AI & ML
D.Y. PATIL VIDYAPEETH
B.TECH - C.S.E
S.S.I.P.M.T