RAJESH YANIMILLA
Summary
- Seasoned Data Analyst with over 12 years of expertise in Banking and Finance, Retail Domain. Proficient in MAS, regulatory reporting and transaction reporting. Skilled in requirements analysis, user testing, and effective training. Adept at leveraging industry insights for strategic decision- making.
- Involved in the full software development lifecycle – from requirements gathering to production
deployment - Detail-oriented team player with strong organizational skills. Ability to handle multiple projects simultaneously with a high degree of accuracy.
Overview
8
8
years of professional experience
Work History
Senior Data Engineer
Quess Corp(OCBC)
2022.11 - Current
- Performed precise data mapping and modelling,
strategically identifying the primary data source for critical attribute. - My role includes collaborating with stakeholders to understand data requirements and translate them into functional specification documents.
- Performed thorough impact analysis of data marts , downstream applications and reports for any source changes.
- Reengineered existing ETL workflows to improve performance by identifying bottlenecks and optimizing code accordingly.
- Coordinated and managed end-to-end project lifecycles, encompassing System Integration Testing (SIT), User Acceptance Testing (UAT), production rollout, and postproduction warranty phases, ensuring seamless project delivery and ongoing support.
Senior ETL Consultant
Ernst & Young (DELL)
2021.12 - 2022.11
- Streamlined data integration tasks for increased efficiency, utilizing advanced ETL tools and techniques.
- Data profiling and strategize data cleaning and
transformations efficiently. - Partnered with stakeholders to define clear project requirements, translating them into actionable tasks for successful execution.
- Designed robust ETL flows and written complex SQLs to extract and manipulate data for reporting and analysis purpose.
- Implemented performance monitoring tools to proactively identify areas for optimization within the ETL process.
Data Architect & Teradata Consultant
Tech Mahindra(OCBC)
2018.12 - 2021.12
- Liaised with business users on requirements and decompose measures to source attributes from the host systems. Involved in the user requirement discussion with business users and prepare the Functional specification for Regulatory Reportings.
- Data profiling and strategize data cleaning and
transformations efficiently. - Collaborating with user team and Technical Team to identify impediments for delivery and provide solution by effective negotiation on budget and timeline.
- Improved database performance by optimizing queries, indexing strategies, and overall architecture design.
ETL Informatica Developer
Collabera Technologies (DELL)
2016.11 - 2018.11
- Worked closely with Architectural teams to finalize the ETL approach and incorporating the standards
- Developed complex mappings, workflows, and sessions to meet project objectives and deadlines.
- Streamlined data extraction, transformation, and loading for improved overall system performance.
- Ensured data integrity through rigorous testing and validation of ETL code.
- Provided support during production deployments by troubleshooting issues and ensuring seamless transitions between environments.
Education
Bachelor of Technology - Computer Science Engineering
SR ENGINEERING COLLEGE
WARANGAL05.2011
Skills
- Snowflake
- Informatica (IICS, BDM, PC), Stream sets
- Teradata FSLDM
- Oracle, SQL Server, Green plum, Hive
- UNIX
- Control-M
- Agile Methodologies
- JIRA
- Confluence
- CI/CD, Jenkins, Git, Bitbucket
Timeline
Senior Data Engineer
Quess Corp(OCBC)
2022.11 - Current
Senior ETL Consultant
Ernst & Young (DELL)
2021.12 - 2022.11
Data Architect & Teradata Consultant
Tech Mahindra(OCBC)
2018.12 - 2021.12
ETL Informatica Developer
Collabera Technologies (DELL)
2016.11 - 2018.11
Bachelor of Technology - Computer Science Engineering
SR ENGINEERING COLLEGE
Similar Profiles
Aisakani Aisakani null
Infrastructure Engineer at Quess Corp Singapore Pte Ltd (OCBC Bank)Infrastructure Engineer at Quess Corp Singapore Pte Ltd (OCBC Bank)
Aisakani Aisakani null
Infrastructure Support Engineer at Quess Corp Singapore Pte Ltd (OCBC Bank)Infrastructure Support Engineer at Quess Corp Singapore Pte Ltd (OCBC Bank)
Abhishek ChaudharyAbhishek Chaudhary
Vice President - Technology Solutions at OCBCVice President - Technology Solutions at OCBC