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: RAW Analytics
Role: Informatica Developer
Client: Toyota, New York, US
Location: Dubai, UAE
Duration: May 2022 – June 2023
Technologies: Informatica PowerCenter 10.4.1, Oracle 12c, Windows 10, UNIX, Power BI

Project Summary:
This project supported Toyota’s procurement analytics by integrating data from Oracle Apps (OLTP) into a centralized warehouse. The ETL processes enabled historical tracking and vendor selection analysis, and Power BI dashboards provided actionable insights for business users.

Key Responsibilities:

• Developed Informatica mappings using PowerCenter tools like Source Analyzer, Mapping Designer, and Transformations.
• Used key transformations: Lookup (Connected & Unconnected), Joiner, Router, Expression, Update Strategy, etc.
• Designed and implemented Slowly Changing Dimensions (SCD) logic for tracking historical changes.
• Created and managed parameterized sessions and workflows.
• Conducted unit testing, peer reviews, and resolved defects in mappings.
• Built reusable transformations and mapplets to optimize development effort.
• Tuned ETL mappings to improve load performance.
• Designed and developed interactive Power BI dashboards for procurement and supplier analytics, enabling decision-makers to track quotations, approvals, and vendor performance.
• Connected Power BI to the warehouse layer, ensuring accurate data representation with filters, slicers, and DAX measures.

Roles & Responsibilities

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:

• Collaborated with cross-functional teams to gather and analyze business requirements and translate them into technical specifications.
• Designed and developed interactive dashboards and reports in Power BI, leveraging DAX, Power Query (M), and efficient data models.
• Performed end-to-end ETL testing, data validation, and source-to-target mapping to ensure data accuracy and consistency.
• Conducted root cause analysis and performance tuning to optimize report load time and query execution.
• Participated in Agile/Scrum ceremonies including sprint planning, stand-ups, and retrospectives for iterative development and delivery.
• Ensured quality through test case creation, defect logging, and support for UAT and production deployments.
• Worked closely with Technology Leads and Project Managers to provide accurate work estimations and ensure on-time delivery.
• Followed SDLC and quality standards to maintain compliance and consistency across development lifecycles.
• Monitored automated report refreshes and scheduled data updates using Power BI service and gateways.
• Stayed updated with the latest trends in BI tools and cloud technologies to support digital transformation initiatives.