Mr

Ankit Srivastava is a highly skilled data and analytics professional with deep expertise in implementing and testing ETL processes, particularly using Oracle Data Integrator (ODI). He brings substantial experience in data extraction, transformation, and loading across various platforms, consistently delivering efficient and reliable data integration solutions. His work reflects a solid understanding of both OLAP and OLTP environments, supported by extensive use of tools such as Erwin and ER Studio for data modeling.

Ankit has developed and maintained OBIEE Repositories (.rpd) across all three layers—Physical, Business Model, and Presentation—implementing complex security setups, time series functions, and highly interactive dashboards with global and local filters. His design work enables end-users to access drill-down analytics with precision and clarity, and his knowledge-sharing initiatives, including modeling review sessions and feasibility discussions during requirements gathering, have made him a valuable resource in team environments.

With strong experience in dimensional modeling using star and snowflake schemas, Ankit has designed robust fact and dimension tables to support scalable data warehouses. His proficiency extends into developing physical and logical architectures using Topology Navigator, defining contexts, and configuring agents within ODI.

In addition to his core data expertise, Ankit has worked with a broad range of AWS services, including EC2, S3, RDS, IAM, VPC, ELB, CloudFront, CloudWatch, SNS, SES, and SQS. His familiarity with cloud infrastructure complements his work in building data ingestion pipelines, optimizing ETL workflows, and applying advanced processing techniques, including machine learning and big data tools like Hadoop.

His backend development skills include writing and optimizing complex SQL and PL/SQL routines, such as triggers, packages, functions, stored procedures, and dynamic database object creation. He has demonstrated proficiency in data warehousing concepts, including data cleansing, surrogate key generation, and Slowly Changing Dimensions (SCD), making him a comprehensive expert in modern data ecosystems.