Lakku Raja sekar Reddy

Over 3 years 6 months of experience in data warehousing, specializing in analysis, design, and development with tools such as Informatica PowerCenter, IICS, Oracle SQL, and Snowflake. Expertise in designing data quality rules and scorecards to profile and cleanse critical business data, along with creating data profiling tasks to analyze source data patterns. Proven ability to develop mapping specifications and data cleansing rules, optimizing ETL processes for improved performance. Skilled in building interactive dashboards and reports using Power BI, connecting multiple data sources for comprehensive data analysis and reporting.

Project Title 1: HR Analytics
Role: Informatica Support
Client: Honeywell, US
Location: Bangalore
Duration: June 2022 – June 2024
Technologies: Informatica PowerCenter 10.4.1, Oracle 21c

Project Summary:
The HR Analytics project focuses on ETL processes to consolidate HR data from multiple sources into a centralized data warehouse. It includes daily, weekly, and monthly data loads, ensuring data accuracy, performance, and reliability.

Key Responsibilities:

• Handled ETL job failures, data quality issues, and performance bottlenecks.
• Applied quick fixes to minimize operational disruptions.
• Set up proactive monitoring for ETL workflows.
• Performed root cause analysis by tracing logic from target to source and validating at the DB level.
• Implemented long-term solutions for recurring issues.
• Collaborated with DB and infra teams for efficient data processing.
• Managed production deployments for ETL code changes and enhancements.

Project Title 2: RAW Analytics
Role: Informatica Developer
Client: Toyota, New York, US
Location: Dubai, UAE
Duration: June 2024 – Till date
Technologies: Informatica PowerCenter 10.4.1, Oracle 12c, Windows 10, UNIX, Power BI ,Dax ,Data Bricks

Project Summary:
The project supported Toyota’s procurement process by extracting and transforming data from Oracle Apps (OLTP) into a data warehouse for analytics. It involved handling supplier quotations, approvals, and procurement history.

Key Responsibilities:

• Developed mappings using PowerCenter tools: Source Analyzer, Mapping Designer, and Transformations.
• Implemented transformations like Lookup, Joiner, Router, Update Strategy, Expression, etc.
• Designed SCD (Slowly Changing Dimensions) logic using update/insert strategies and flag columns.
• Created and managed sessions and workflows using parameters
• Conducted unit testing and peer reviews, and resolved mapping defects
• Built reusable transformations and mapplets for efficient development
• Tuned mappings to enhance performance during data loads