Deputy Manager at Doosan Bobcat India Pvt Ltd (2013-06 – Present)
Led Business Intelligence (BI) and Data Engineering initiatives, delivering scalable analytics solutions using Snowflake, DBT, ODI, OBIEE, and Oracle Analytics Cloud (OAC).
- Designed and developed enterprise-grade dashboards, reports, KPIs, and semantic data models to support business decision-making using OACS(OBIEE).
- Developed and maintained OBIEE Repository (RPD) components, including Physical, Business Model & Mapping (BMM), and Presentation layers.
- Created interactive dashboards, analytical reports, scorecards, and advanced visualizations to meet business reporting requirements.
- Implemented complex hierarchies, aggregate tables, dimensional models, and optimization techniques to enhance reporting performance in OBIEE OACS.
- Possess extensive hands-on experience with ODI 12c Designer, Topology, Security, and Operator modules.
- Developed ODI mappings, packages, procedures, load plans, and end-to-end data integration solutions.
- Worked extensively with ODI Knowledge Modules including LKM, IKM, CKM, and JKM for efficient data loading and validation.
- Executed large-scale migration projects from Informatica PowerCenter to ODI 12c, ensuring seamless transition and minimal business disruption.
- Performed data load monitoring, troubleshooting, debugging, performance optimization, and production support activities.
- Successfully migrated legacy Informatica ETL workflows to ODI 12c, significantly improving system scalability, maintainability, and performance.
- Managed and coordinated weekly sprint releases, deployments, and production rollouts across ODI, OBIEE, and OAC environments.
- Provided production support, performance tuning, incident resolution, and root cause analysis to ensure high system availability.
- Demonstrated strong expertise in Snowflake Cloud Data Warehouse development, architecture, and optimization.
- Developed and implemented Data Vault 2.0 models, including Hubs, Links, Satellites, and Reference tables for enterprise data platforms.
- Built, validated, tested, and optimized DBT models in Snowflake to support scalable and maintainable ELT frameworks.
- Designed reusable DBT transformations, incremental models, snapshots, and data quality validation frameworks.
- Collaborated with business stakeholders, architects, and cross-functional teams to deliver high-quality data solutions aligned with organizational goals.
- Mentored team members and contributed to best practices in Data Warehousing, Cloud Analytics, Data Modeling, and Agile Delivery.
- Led development teams, code reviews, release management, and deployment activities using GitHub version control.
Associate Project at Cognizant Technology Solutions (2012-09 – 2013-06)
Client: Agilent Technologies
- Provided Production Support, performance tuning, incident resolution, and root cause analysis to ensure high system availability.
- Designed and developed enterprise-grade dashboards, reports, KPIs, and semantic data models to support business decision-making.
- Developed OBIEE dashboards and reports for HR analytics
- Built RPD models and implemented security
- Performance tuning and enhancements of existing reports
- Developed and maintained OBIEE Repository (RPD) components, including Physical, Business Model & Mapping (BMM), and Presentation layers.
- Created interactive dashboards, analytical reports, scorecards, and advanced visualizations to meet business reporting requirements.
- Implemented complex hierarchies, aggregate tables, dimensional models, and optimization techniques to enhance reporting performance.
Senior Software Engineer at Infosys Technologies (2008-03 – 2012-08)
Projects:- Cisco: OBIEE development and support for sales/marketing analytics- Royal Bank of Scotland: MIS reporting using OBIEE- Emerson: Supply chain analytics dashboards- Infosys Training: BI and OBIEE development training- Developed reports, dashboards, and performed admin activities across projects
- Designed and developed enterprise-grade dashboards, reports, KPIs, and semantic data models to support business decision-making using OACS(OBIEE).
- Developed and maintained OBIEE Repository (RPD) components, including Physical, Business Model & Mapping (BMM), and Presentation layers.
- Created interactive dashboards, analytical reports, scorecards, and advanced visualizations to meet business reporting requirements.
- Implemented complex hierarchies, aggregate tables, dimensional models, and optimization techniques to enhance reporting performance in OBIEE
- Completely developed the sales marketing dashboards and reports in OBIEE for cisco project.
