RATNARAO YAMANI
IT & Software
Hyderabad,TG
Summary
Dynamic IT strategist with over 18 years of experience in data warehousing and ETL, actively seeking a Snowflake Architect position. Expertise in collaborating on RFI and RFP processes has successfully secured business opportunities while supporting sales teams. Proficient in designing and implementing cloud data warehouse solutions, utilizing advanced knowledge of Snowflake, Azure, and AWS, along with data modeling skills to enhance data management and drive business intelligence initiatives. A commitment to innovation and efficiency ensures alignment with organizational goals, backed by a proven ability to foster effective team collaboration and adaptable problem-solving in fast-paced environments.
Overview
20
20
years of professional experience
2
2
Certifications
Work History
Sr Solution Architect
Ibexlabs cloud consulting pvt ltd
03.2025 - 09.2025
- Responsible for providing expert-level guidance and support to clients navigating complex data migration and cloud implementation projects, ensuring alignment with industry best practices.
- Spearheaded Snowflake cloud DB data migration projects, focusing on transitioning data from diverse on-premises databases, including Oracle and Flat files.
- Worked on data modernization POC and implemented Hybrid architecture. Used Data Vault and Dimensional modeling to track the data auditing, scalability, adoptability and Azile. Implemented Medallion architecture to track the data accuracy and easy maintainability.
- Managed and optimized data solutions within Azure/AWS public cloud environments, ensuring scalability and efficiency.
- Led strategic initiatives to enhance data infrastructure and support business intelligence efforts.
- Consulted with clients to understand their data warehousing needs and devise tailored solutions leveraging Snowflake's capabilities.
- Oversaw the implementation of best practices for data governance, security, and compliance within cloud environments.
- Achievements:
- Successfully migrated multiple large-scale databases to Snowflake, resulting in improved data accessibility and reduced operational costs.
- Enhanced data processing speeds through the strategic implementation of Snowflake optimized solutions.
- Improved overall data security posture by implementing industry-leading security measures and access controls within cloud environments.
- Led the design and implementation of cloud solutions, enhancing system performance and scalability for diverse clients.
- Mentored junior architects in best practices for cloud technologies, fostering a culture of continuous improvement and innovation.
- Conducted comprehensive assessments of existing infrastructures, recommending strategic optimizations to reduce costs and improve efficiency.
- Collaborated with cross-functional teams to develop technical architectures, ensuring alignment with business objectives and client needs.
- Developed and maintained technical documentation for cloud architectures, ensuring clarity and consistency across all project phases.
- Implemented security best practices in cloud deployments, safeguarding client data and complying with industry regulations.
- Optimized application performance through cloud migration strategies, resulting in increased scalability and reduced operational costs.
- Spearheaded the integration of Agile methodologies within project teams, resulting in faster delivery and enhanced stakeholder engagement.
- Analyzed client requirements and translated them into scalable cloud solutions, driving customer satisfaction and long-term partnerships.
- Collaborated with cross-functional teams to ensure seamless integration of new systems.
- Spearheaded technology innovation initiatives to stay ahead of industry trends and maintain a competitive edge in the marketplace.
Sr Solution Architect
Birlasoft
04.2023 - 06.2024
- Served as the single point of contact for all project deliverables, communicating progress, and addressing any roadblocks to ensure successful project completion.
- Developed solution architecture for Cloud Data Warehouse projects, ensuring alignment with business requirements, and technical feasibility.
- Hands-on experience in dimensional modeling (Star/Snowflake), data architecture, and data modeling using ERwin. Implemented conceptual, logical, and physical models.
- Engaged in comprehensive requirement-gathering sessions, collaborating with stakeholders to define project scope and objectives.
- Coordinated cross-functional teams, including functional, development, and testing resources, to ensure seamless project execution.
- Oversaw data migration efforts from Oracle to Snowflake, managing the migration of over 60 objects with precision. Implemented Azure Blob as an external stage for data storage and processing, optimizing data ingestion workflows. Utilized dbt for data transformation, loading data into the Confirm and Pub layers, facilitating efficient data processing and reporting.
- Achievements:
- Streamlined data migration processes result in faster project turnaround times. Improved data quality by implementing robust data transformation pipelines using dbt.
- Contributed to optimized reporting capabilities by enabling Qlik Sense resources to work on the PUB layer.
Architect
RR Donnelly
10.2020 - 03.2023
- Managed client communications, providing regular status updates, and proactively addressing roadblocks to ensure successful project outcomes.
- Architected cloud data warehouse solutions, focusing on migrating SAP HANA BW views to Snowflake DB to enhance data analytics capabilities.
- Orchestrated a team of 17 offshore members, ensuring efficient development and delivery of all project deliverables.
- Engineered the migration of SAP HANA GUI-based views to Snowflake Views, utilizing dbt as a transformation tool, leading to streamlined data processing.
- Implemented and managed Snowflake landscapes, including Performance (L environment) and Production environments, optimizing each for specific data needs.
- Designed and maintained database structures within Snowflake, including stage and base environments, ensuring efficient data storage and retrieval.
- Leveraged dbt to migrate code from development to production environments, ensuring consistency and reliability across landscapes.
- Achievements:
- Successfully facilitated the migration of SAP HANA BW views to Snowflake, modernizing the client's data infrastructure.
- Enhanced data accessibility for end users through the creation of Reader accounts, improving data-driven decision making.
- Improved data loading efficiency by strategically assigning warehouse sizes based on specific data requirements, ensuring optimal performance.
Solution Architect
ValueLabs
07.2019 - 01.2020
- Provided technological guidance and support in the implementation of Snowflake DB features, such as streams and tasks.
- Devised solution architecture for Cloud Data Warehouse transitions, leading the migration of an on-premises MS SQL Server 2012 DWH to Snowflake DB.
- Managed the ingestion of data from diverse source systems, converting it into .csv format, and staging it in a local file directory.
- Orchestrated bulk data loading into Snowflake internal stages, utilizing PUT and COPY commands, optimizing data transfer processes.
- Directed data cleansing and transformation processes, leveraging Informatica, ensuring data accuracy and consistency within temporary tables.
- Developed secure views and granted access to the Tableau BI reporting team, enhancing data accessibility. Employed Snowflake DB streams and tasks to maintain historical data and facilitate data scheduling, ensuring data governance, and compliance.
- Achievements:
- Successfully migrated the on-premises DWH to Snowflake, delivering a scalable, efficient cloud data solution.
- Significantly enhanced data accessibility for end users by creating READER accounts, empowering data-driven decision-making.
Lead ETL Developer
Miracle Software Systems, Inc
11.2016 - 04.2019
- Oversaw the troubleshooting of validation issues, performing in-depth data analysis, and providing recommendations for system improvements.
- Directed a team of 8 ETL developers, providing mentorship and guidance to ensure high-quality deliverables and adherence to project timelines.
- Engaged with onsite teams to gather business requirements, translating them into actionable tasks and designs for ETL development.
- Engineered data models (Conceptual/Logical/Physical) using Erwin, ensuring alignment with business requirements and data warehouse architecture.
- Managed the estimation of efforts for ETL builds and resource allocation, ensuring efficient project planning and execution.
- Utilized Informatica PowerCenter tools (Designer, Repository Manager, Workflow Manager, Workflow Monitor) to develop and maintain ETL processes.
- Built ETL architectures and Source to Target (S2T) mapping documents to facilitate data loading into the data warehouse.
- Achievements:
- Facilitated the seamless extraction of data from various sources (flat files and RDBMS databases) into a staging area, improving data accessibility.
- Enhanced code quality and reliability by conducting thorough code and document reviews of all deliverables.
Technical Lead
RIOSOFT Technologies
08.2012 - 11.2016
- Reviewed code and documentation to ensure quality and alignment with project requirements in consultation with the offshore team & client.
- Collected business requirements and devised technical design documents for data warehousing projects. Constructed data models (Star Schema) using Erwin, optimizing data flow and behavior across the business.
- Estimated effort for ETL builds and resource allocation, driving efficient project planning and execution.
- Customized data models for data warehouses, supporting data from multiple sources in real-time.
- Built ETL architectures and Source to Target (S2T) mapping documents for data loading into the data warehouse. Developed mappings to load data into staging tables and subsequently into Dimensions and Facts.
- Achievements:
- Enhanced data accessibility by effectively extracting from flat files and RDBMS databases into staging, then populating data warehouses.
- Optimized data transformation processes using Informatica transformations such as Filter, Expression, Joiner, and Stored Procedure.
Team Lead (G40)
CSC India Pvt Ltd
09.2005 - 01.2012
- Conducted code migrations to QA and PROD environments, performing thorough ETL code reviews to ensure code quality and adherence to standards.
- Managed onsite and offshore resources to ensure effective delivery of data solutions, optimizing team performance and project outcomes.
- Interacted with business users to gather and document business requirements, translating them into actionable technical specifications.
- Developed ETL mappings as per business requirements, implementing code changes to enhance system functionality.
- Implemented PL/SQL stored procedures and packages, improving database performance and efficiency.
- Designed table partitioning and sub-partitioning strategies, optimizing data storage and retrieval.
- Created stored procedures to dynamically generate parameter files and update tables, enhancing data management and automation capabilities.
- Achievements:
- Improved ETL processes through batch design changes, leading to performance tuning of Informatica mappings and database objects after production code deployment.
- Resolved numerous ETL service outages and job failures, ensuring system stability and minimizing downtime.
Education
Master of Science - Computer Applications Development
Periyar University
Tamil Nadu 04.2001 -
Skills
Collaborative team management
Effective communication
Data-driven problem-solving
Collaborative project coordination
Adapting to change efficiently
Snowflake database expertise
Data storage solutions
Data extraction and transformation
Data build tool expertise
Experience with Azure Data Factory
Enterprise architecture development
Data integration techniques
Certification
informatica power center mapping designer
Timeline
Sr Solution Architect
Ibexlabs cloud consulting pvt ltd
03.2025 - 09.2025
Sr Solution Architect
Birlasoft
04.2023 - 06.2024
Architect
RR Donnelly
10.2020 - 03.2023
Solution Architect
ValueLabs
07.2019 - 01.2020
Lead ETL Developer
Miracle Software Systems, Inc
11.2016 - 04.2019
Technical Lead
RIOSOFT Technologies
08.2012 - 11.2016
Team Lead (G40)
CSC India Pvt Ltd
09.2005 - 01.2012
Master of Science - Computer Applications Development
Periyar University
04.2001 -