Rani Aher

• Architect with strong 18 years’ experience in developing strategic focus on emerging markets growth needs, stakeholder management and planning
• Promote a culture that drives autonomy, responsibility, perfection and mastery
• Collaborate with product and delivery team to ensure timely and quality delivery of the product features
• Build an engineering roadmap and technology strategy for the entire engineering team
• Lead the digital data transformation strategy, execution and digital engineering capability to simplify the traditional on-prem data estate and create the futuristic Digital Data capability on Cloud (AWS Data Lake, Snowflake, Tableau, Power BI and ThoughtSpot)
• Lead COE activities for Snowflake & Informatica, Thought Leadership, POV
• 4 years of experience in Snowflake, Python, Airflow and successfully architected and implemented 2 end-to-end projects using Snowflake Datawarehouse
• Extensive experience in database design for data warehouses with strong understanding of Dimensional Modelling, Star and Snowflake Schemas, Dimension and Fact tables
• Extensively used ETL methodology for developing Data Extraction, Transformation and Loading process, in a corporate-wide-ETL solution using Snowflake
• Hands-on experience with Snowflake utilities like SnowSQL, SnowPipe, tasks and streams & Hadoop Technologies
• Experience in product release process including design, development, QA, documentation, deployment and monitoring
• Expertise in Snowflake advanced concepts like setting up virtual warehouse sizing, query performance tuning, zero copy clone, time travel, task and understand how to use these features
• Experience of real-time data processing (streaming)
• Implemented Data Vault Modelling and Dimensional Modelling techniques
• Involved in Project management activities like Proposals, estimation, and contract creation/extension/renewal
• Compliance to Agile Jira SDLC controls, Service Now Change & Incident management
• Used AWS services like S3, IAM, SQS, Greenfield Implementation of cloud based DWH solution
• Part of Platform team who owns the Snowflake Platform and cater needs of BTG Snowflake implementations
• Role and Responsibilities:
• Build an engineering roadmap and technology strategy for the entire engineering team
• Promote a culture that drives autonomy, responsibility, perfection and mastery
• Collaborate with product and delivery team to ensure timely and quality delivery of the product features
• Solution POC and Blue Print development
• Worked with Snowflake COE to develop reusable ingestion patterns, RBAC automation, BTG onboarding scripts, maintenance script etc
• Around 5 BTG onboarded on platform
• Worked as Snowflake SME under COE umbrella to support multiple project needs
• Designed different Platform level component and party the decisions
• Contributed to Recruitment Drives.
• Managed large-scale projects and introduced new systems, tools, and processes to achieve challenging objectives.
• Evaluated hiring, firing, and promotions requests.
• Developed proposals and presentations for internal and external audiences.

• Greenfield Implementation of cloud based DWH solution to cater the regulatory reporting needs
• Role and Responsibilities:
• Build an engineering roadmap and technology strategy for the entire engineering team
• Promote a culture that drives autonomy, responsibility, perfection and mastery
• Collaborate with product and delivery team to ensure timely and quality delivery of the product features
• Solution POC and Blue Print development
• Managed large-scale projects and introduced new systems, tools, and processes to achieve challenging objectives.
• Evaluated hiring, firing, and promotions requests.

• COX CMI DataWarehouse and Reporting
• Greenfield Implementation of cloud based Datawarehouse solution to cater the next gen data store and Lakehouses
• This solution shall provide the single truth of enterprise datasets, Low cost approach to data sharing across business groups & Near real time reporting
• This solution shall reduce the operational overhead of configuring and maintaining underlying Infrastructure and security
• Role and Responsibilities:
• Communication with client on planning, business requirement gathering and documenting the technical and business metadata
• Architecting the project with Data Vault 2.0 and dimension modelling technique
• Solution POC and Blue Print development
• Design different Platform level component and party the decisions
• Help team in Airflow, Snowflake connectivity & POC
• Design the Snowflake data Ingestion Framework used across all projects with effort saving of 25 man days
• Query execution time reduction by at least 50% with even X-Small warehouse
• Overall cost reduction from $100,000 to just $12,000 with efficient and optimised compute
• Experienced in setting advanced Snowflake Cloud data-warehouse concepts like setting up Virtual warehouses,
• Query performance tuning, Zero copy clone, Time travel, Snow-pipe, STREAMS
• Platform level common component planning and development to adhere reusability
• Architect AWS environment for event-based loading to host/deploy services like Amazon S3, SNS, SQS, Cloud-watch, Snow-pipe
• As a Snowflake SME provided deployment approach at Organisation level
• Designed roles and permissions for setting up multiple business process on Snowflake as part of Snowflake initial environment
• Provisioning
• Worked with Snowflake COE for developing the ingestion patterns, RBAC automation
• Worked as Snowflake SME under COE umbrella to support multiple project needs
• Contributed to Recruitment Drives.
• Coached team members on productivity strategies to accomplish challenging goals.
• Interacted with customers and clients to identify business needs and requirements.
• Addressed and resolved technical, financial, and operational concerns by working with team members and directors.
• Managed multiple strategic projects with numerous sub-projects or workstreams.
• HP Partner 360o and Global Channel Warehouse(GCW)
• This project aims to build a consolidated central Data warehouse (DWH) to provide the Partner 3600 view for Claims, Channel compensation, deals & Revenue & Margin
• The end user reports are built using Power BI & ThoughtSpot
• These reporting are catering important primary KPIs daily, weekly, monthly and yearly basis
• The solution is extracting the Azure blob data into Snowflake
• Role and Responsibilities:
• Communication with client on business requirement gathering and documenting the technical and business metadata
• Architecting the project with dimension modelling technique
• Represent the team in Product Owner meeting for important decision making
• Module assignment to the team and to review and integrate each module
• Guided team to develop generic pipelines for Full load and Incremental loads
• Guided team for slowly changing dimensions’ methodology to keep track of historical data using Snowflake streams
• Guide team on complex queries to map the data as per the requirements
• Finalize business logic and implement using Snowflake data pipeline
• Created stored procedure to automate weekly reports with saving around 240 hrs yearly
• Developing jobs and scheduling them using TIVOLI workload scheduler
• Ensured zero defect and timely deployment of all the components
• Documented all the deliverables for smooth handover to production team.

CLOSE BROTHERS

• AFL DataWarehouse
• As Onsite Architect deliver Snowflake based Greenfield data Warehouse implementation with DB2 and Salesforce as source data
• The solution POC was executed and approach the blue print was published to wider audience
• The DWH was built to cater the regulatory report needs
• The initial project has built the Platform for upcoming projects with detailed requirements and billing segregations as per departments
• In this project we are extracting 300+ tables having total size of around 19 TB
• Designed the solution and approach for extracting the 300+ tables using Informatica Push down capability
• Worked with customers or prospective customers to develop integrated solutions and lead detailed architectural dialogues to facilitate delivery of comprehensive solution.
• Developed generic extraction & Ingestion framework using dynamic mapping solution
• This cater the new table extraction automatically by generating code for 300+ tables’ extraction
• Presented roadmap and technology infrastructure to customers, demonstrating deep familiarity with APIs, platform infrastructure, security and integration capabilities.
• Worked closely with product teams to define and prioritize partner feature requests
• This has saved 100 hrs of efforts
• Develop generic landing layer solutions to cater common layer for serving different departments
• Module assignment to the team and to review and integrate each module
• Presented solution to client architect on different strategical solutions with Pros and cons
• Performance Optimisation and job monitoring solutions
• Developed Data Governance, Data Quality requirements
• Documented all the deliverables for smooth handover to production team.

NATIONWIDE BUILDING SOCIETY

• Managed the Data and Analytics Account Data Lake & Warehouse support project at NationWide Bank
• Responsible for RFP, account growth, staffing, new opportunities for this client
• Handled support project escalations and day today account management activities
• Managed closed to 12 member team at onsite and 25 member team at offshore
• NationWide Account growth and Strategies
• Built and strengthened long-lasting client relationships based on customer-centric terms.
• Stakeholder Management, Part of Key Architectural Decision, Proposals
• Evaluated client needs and developed tailored solutions to increase positive customer ratings.
• Lead different Automation initiative, New product POCs,
• Built relationships with customers and community to promote long term business growth.
• Staffing and Recruitment Management

• Developed cloud based Data Quality as a Solution Service offering
• Launched the offering with help of Informatica and implemented for 2 clients
• Lead Modernization initiative for Informatica accounts with help of Informatica JV
• Lead different Service Offerings & Solutions
• Lead Modernization initiative to Increase the portfolio revenue
• Informatica Day planning and initiatives
• Automation initiatives
• Developing BETQ, MLOAD for target tables
• Coordinating the POV & POC Implementation
• Developing reusable artifacts, Estimation templates etc
• Provided detailed technical and operational direction in project challenges, consistently meeting deliverables according to deadlines.

NIKE INC

• Nike project was a big IT consolidation program
• Being Onsite BI transition Manager responsible for support transition program and managed closed to 40 resources
• Develop program level strategies in cases where the impact is analyzed and strategies are evolved & handle this account for 3 years
• The technology involve was SAP Business Objects Data Services 12.2.0.0, Oracle 10G/11G, Unix
• Stakeholder Management
• Communicated project plans and progress to key stakeholders and project contributors.
• Accomplished client goals by providing quality technical projects.
• Managed 2 project teams in Agile environment, realizing success through application of SDLC methodologies and exceptional leadership skills.
• Led cross-functional teams to successfully complete IT projects.
• Implemented best practices to drive quality IT project delivery.
• Resolved staff conflicts and identified potential areas of improvement.
• Negotiated and managed project budgets to meet goals.
• Conducted quality assurance to verify accuracy of data used in IT projects.
• Change management and Platform readiness
• Collaborated with business users, technical teams, database administrators and testing teams during kickoff meetings, joint application designing, and planning sessions to validate requirements.
• Involved in High Level Designing (HLD) and Low-Level Designing (LLD)
• Recruitment Drives

PROCTOR & GAMBLE

• The Customer Financial System was conversion project designed to improve the accuracy and data quality in RDS v1 Data
• The main challenge is there is no window period or blackout period
• Worked on customer shipments on Non-Revenue items reporting
• The technology involve was Oracle 9i, SQL and PL SQL, WEBOSA, UNIX, Control-M, Informatica, Windows NT, :
• Stakeholder Management, Requirement Gathering, Design, Development, Automation
• Collaborated with business planning department to monitor and adjust company-wide technology utilization, modifying infrastructure to meet business goals.
• Fostered strong relationship between technology team and managers to align efforts.
• Partnered with architecture team to develop wholistic technology roadmap, accounting for departmental priorities and overall business goals.
• Analyzed client business processes to propose optimal software applications for unique requirements.

CUMMINS DIESEL

• Managed 5 member team for the enhancement and support of the ERP CARDS system which involve Order management, Ware house management & the reports and EDI (Electronic Data Interface) which will transfer data to Clients in China, Africa etc
• The technology involve was Oracle 9i, Forms 3.0/6i, reports 6i, SQL and PL SQL, Remedy, Red prairie, UNIX, TOAD
• Role and Responsibilities:
• Requirement Gathering, Design, Development, Project Management
• Coached team members in techniques necessary to complete job tasks.
• Designed strategic plan for component development practices to support future projects.

BRITISH TELECOM

• BBDQM is the broadband data quality management project, which displays the quality of service given by BT in the actuate report formats to the BT officials
• The technology involve was Oracle 9i, PL/SQL, SQL, SQL
• Plus, Abinitio, UNIX
• Role and Responsibilities:
• Requirement Gathering, Design, Technical support to team
• Translated complex technical issues into digestible language for non-technical users.

MERCK & CO, NYK

• Managed the application which stores Clinical Research’s laboratory testing related information and has ability to retrieve the data to track the progress of various samples from the point they enter the laboratory until the completion of testing
• The technology involve was Oracle 8i, Forms 6i, Reports 6i, Micro Strategy, Ab initio
• Delivered scalable system architecture to support high-availability Internet site with various internal applications.
• Participated in design sessions with clients to ascertain project specifications.