Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

RANADHEER REDDY DASARI

Cherrybrook,Australia

Summary

Seasoned collaborator experienced in meeting needs, improving processes and exceeding requirements in team environments. Diligent worker with strong communication and task prioritization skills.

Overview

10
10
years of professional experience
1
1
Certification

Work History

Senior Technical Business Analyst

Simply AI
05.2023 - Current
  • Worked with multiple client engagements & Technology Partners Informatica, Catholic Education Network, Resolution Life, ORX, Tabcorp, Snowflake, Kada, Informatica,
  • Collaborated with stakeholders to define project objectives and criteria for Resolution Life AIA Migration & Oracle Fusion Migration for Tab Corp.
  • Determined areas for improvement and implemented processes to alleviate problems
  • Streamlined processes to cut downtime and optimise employee productivity
  • Assisted in business development efforts, securing new contracts within Resolution Life and spreading the company's client base.
  • Delivered the Data Migration program for Resolution Life by migrating there data platforms from Microsoft Hyperscale Environment to Snowflake using IICS Cloud.
  • Assessed needs for projects and made proposals to senior executives
  • Streamlined project management processes, improving efficiency and reducing overall costs by adopting RPA in data migration program there by reducing cost of project and saving more than 1.5 Million in revenue for client and finishing the project with in 6 Months.
  • Developed strategies for automated testing and documentation using UI Path understanding the client requirement and pain points
  • Streamlined the delivery of data Migration for Catholic education network by providing the right user guidelines and solutions in adopting Informatica Cloud and Snowflake from Microsoft SSIS / SQL Server
  • Assisted Internal Simplyai team in delivering a data model and reporting the insights in Power BI for ORX
  • Promoted a culture of data literacy within client organizations by delivering hands-on training sessions for clients.
  • Worked well in a team setting, providing support and guidance.
  • Used strong analytical and problem-solving skills to develop effective solutions for challenging situations.
  • Proven ability to develop and implement creative solutions to complex problems.

Cloud Migration and Delivery Analyst

Informatica
11.2023 - 01.2024
  • As part of partner engagement with Informatica worked with Catholic education network to migrate the data and processes residing in SSIS and SQL server to Informatica Cloud and Snowflake
  • Assessed existing SSIS packages and dependencies and developed a plan for seamless transition to Informatica CDI /Snowflake focusing on cost and performance
  • Conducted thorough assessments of client infrastructure, enabling seamless transitions to the cloud environment.
  • Designed and Implemented data ingestion ,Mass Ingestion and data transformation pipelines as a reusable template in Informatica CDI / MI
  • Collaborated with upper management to drive strategy and implement new processes.
  • Parsing the JSON/XML data from API's after landing in snowflake as per the target table requirements.
  • Coordinated efforts between technical teams, vendors, and stakeholders to ensure smooth execution of all tasks involved in the end-to-end migration process.
  • Worked on design and development of stored procedures for auditing purposes on target tables as a generic scripts which can be reused by the client going forward.
  • Implemented facts and dimensional tables as per the existing client data model in snowflake as per the client requirements
  • Improved data migration efficiency by designing and implementing optimized ETL processes in order to consume less credits.
  • Documented the current data warehouse architecture to guarantee capacity met current and forecasted needs.


Senior Technical Business Analyst

Resolution Life
01.2023 - 05.2023
  • Worked in CRS (Controls Recon & Stabilization) squad alongside other team members to remove the design gaps and improve the data quality
  • As part of this initiative, I was responsible to lead migration of Contract Risk subject area objects (Around 20 key tables with relevant risk details)
  • Conducted Initial Data Analysis to understand current gaps based on issues raised by customers through digital portals / Customer service
  • Documenting Root Cause analysis for issues and coming up with proposed solution to rectify issues
  • Revisiting Business logics wherever required which have become outdated with recommendations from data stewards and governance
  • Changing IICS - ETL pipelines wherever required and implementing new logic
  • Fixing Historical data wherever rules need to be applied based on analysis and evaluation provided
  • Migrating historical data post data fix and make sure current Informatica Cloud ETL pipelines run doesn't have any issues
  • Reduced overall 90 data level issues which were sitting with DQ squad in one go as part of outcome
  • Improved performance of few of ETL data pipelines by optimizing design.

Solution Designer

Resolution Life
06.2022 - 12.2022
  • Designed architecture strategies for large-scale system-wide application deployments
  • Authored development guidelines to expedite application design efforts through ready-made frameworks
  • Analyzed IICS workflows to generate logic for new scheduling design in Control M.
  • Designed 5 major end to end process from IICS scheduling to Control M by revamping the original design and reducing the number of components running in IICS with audit controls in place while data getting loaded from file to staging.
  • Reduced batch run timing from 16 hours to 8 hours with optimizing design to handle current caveats
  • Has been instrumental in working with operations to understand gaps which need to be catered in design.

Data Migration Lead

Simply AI
11.2021 - 06.2022
  • Converted around 12000 IICS components as part of migration & DDL Components to Snowflake
  • Proposed Automation strategy to fast track migration timelines from 14 months to 6 Months
  • Cost saving of ~2 million to customer with delivery approach proposed
  • Collaborated with internal teams and customer representatives to determine data migration requirements prior to accepting projects
  • Led data migration projects, data file analyses and platform validation.
  • Assigned data migration roles and responsibilities for new projects to support successful execution of individual migration tasks
  • Offered troubleshooting assistance to junior personnel during IICS ETL conversion & and testing and validation phases of jobs
  • Researched and resolved complex issues discovered during migrations which were impacting the performance of taskflows in IICS
  • Created data mapping documentation for use in migration efforts
  • Coordinated with external stakeholders to align data migration scheduling to minimize business process disruptions
  • Improved overall user experience through support, training, troubleshooting, improvements, and communication of system changes
  • Understanding of Insurance Data flows and there data marts and subject areas functionally.

Data Analytics Engineer

Tech Mahindra
07.2019 - 11.2021
  • Played key role in Optus strategic roadmap of digitalization and being data driven organization by creating data sets to support visualization and analytics need
  • Worked on Proof of concept to check the adaptability of snowflake for Enterprise needs.
  • Worked in Company Performance Reporting team as subject matter Data Expert handling prepaid portfolio
  • As part of CPR team was instrumental in building reporting layer using pre-defined guidelines established which is being used by business in all weekly trade meetings and Executive leadership reviews as Single Source of Truth (SSOT)
  • Developed data sets and extracted insights on Daily/Weekly/Monthly/Ad hoc basis providing insights on key KPI's (Gross Add, Churns, Plan Fees Sales, Active Base, Revenue, ARPU, Churns projection and Forecast, FB Analytics, MVNO movements, Others) based on business needs
  • Got strong understanding of Optus product Suite and other segments of business (Postpaid, Fixed, Wholesale, Devices, Optus Sports, Sales)
  • Worked and Implemented an solution for integration of forecasted targets with actuals into data sets there by providing single view of insights in dashboards to analyse the current performance of Key Performance Indicators for Prepaid Portfolio
  • Specialized in deriving performance insights and analysis on new product performance post Market launch.
  • Worked with Facebook Analytics to derive customer insights and observe the trends to create an action plan for business campaigns
  • Worked on producing timely insights and ad hoc analysis using Teradata and Tableau/Power BI /Cognos Cubes for COLES/CATCH/GOMO/Optus Prepaid Voice products
  • Conducted primary and secondary research to better understand customer needs and behaviours.
  • Collected and analyzed data from variety of sources to create detailed market research reports for top-level decision makers.
  • Worked on data trend analysis and liaising with DevOps for any new developments and enhancements as required.
  • Worked on migrating data from IDW TO EDW at Optus and supported BRT for prepaid data sets and developing reconciliation reports for evaluation.


Data Engineer

Tech Mahindra
05.2016 - 01.2019
  • Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity, and verifying pipeline stability.
  • Analyzed complex data and identified anomalies, trends, and risks to provide useful insights to improve internal controls.
  • Communicated new or updated data requirements to global team.
  • Managed multiple DWH of Optus supporting production and non-production environments as part of BAU support maintaining SLA
  • Fixing batch failures due to data level issues or process issues and recording fixes and addressing solution in case of it being repetitive
  • RCA of issues reported by end users of DWH
  • Following Escalation matrix in case of any application majors to communicate stake holders and business
  • Automation of Batch failures
  • Performance tuning of code in Teradata
  • Performed Backup and Purging Activities as part of weekend housekeeping.

Internship

Indian Space Research Organization (ISRO)
01.2014 - 03.2014
  • Involved in designing and developing GPS receiver-based position and time display unit, using live satellite feed from Earth Base Station at ISRO
  • Study how GPS receivers work, including principles like trilateration, signal acquisition, signal processing, and error correction
  • Studied how GPS receivers are used for accurate time synchronization
  • Understand concept of GPS time, Coordinated Universal Time (UTC), and how they are utilized in different sectors like telecommunications, financial systems, and scientific research
  • Was part of a team of Senior ISRO Scientists understanding code and testing in getting coordinates.

Education

BTECH -

JNTU-A
06.2014

Skills

  • Business Analysis
  • Business Planning
  • Competitive Market Analysis
  • Requirements Analysis
  • Requirements Gathering
  • KPI Tracking
  • Customer Relationship Management
  • Consulting
  • Project Analysis
  • Data and Analytics
  • Data Migration/Data Cleansing
  • Data Analysis Expertise
  • Data operations/Performance Tuning
  • ETL
  • SQL and Databases
  • Data Visualization Tools
  • Jira/Confluence
  • Telecom /Insurance Domain
  • Project Management

Certification

  • AWS Cloud Solution Architect - Associate
  • Mintable Manager Foundation
  • Databricks Accredited Lakehouse Fundamentals

Timeline

Cloud Migration and Delivery Analyst

Informatica
11.2023 - 01.2024

Senior Technical Business Analyst

Simply AI
05.2023 - Current

Senior Technical Business Analyst

Resolution Life
01.2023 - 05.2023

Solution Designer

Resolution Life
06.2022 - 12.2022

Data Migration Lead

Simply AI
11.2021 - 06.2022

Data Analytics Engineer

Tech Mahindra
07.2019 - 11.2021

Data Engineer

Tech Mahindra
05.2016 - 01.2019

Internship

Indian Space Research Organization (ISRO)
01.2014 - 03.2014

BTECH -

JNTU-A

Similar Profiles

CREATE PROFILE
RANADHEER REDDY DASARI