RAMYA MALLAVARAPU
Senior Data Analyst
Hyderabad,TG
Summary
- 10+ years of IT experience in Data Warehouse life cycle (ETL, BI and Data/Dimensional Modeling) and Insurance, Banking and Retail and Auditing domains.
- Experience in Technical & Functional Documents and Effort Estimations.
- Experience in developing ETL routines according to the DWH design and architecture.
- Experience in data migration from MySQL to AzureSQL
- Experience in Data Visualization using Power BI
- Experience in Azure cloud services Azure Data Factory, Data Lake, Azure SQL DB and Azure Datwarehouse.
- Intermediate knowledge on Python programming.
- Demonstrable hands on experience in designing the solutions for ETL projects using SSIS.
- Expertise in different databases like Oracle, SQL Server, MySQL and Snowflake
- Demonstrable hands on experience in framework development for Data Integration projects using Pentaho.
- Expert in both Water fall and Agile methodologies Possess experience working with global clients, coordination with multiple stakeholders (Technical and Functional) within the chain for various tasks like Requirement gathering, Release Management and Planning. Expert in data transfer, end to end campaign execution and report creation on adobe campaign. Excellent Analytical skills and strong in translating business requirements to technical requirements and to their design and implementation Ability to think from a bigger perspective to achieve an optimal solution with an in-depth understanding of actual solution implementation.
Overview
10
10
years of professional experience
7
7
years of post-secondary education
1
1
Language
Work History
Senior Data Engineer
WebMD
02.2023 - Current
- Company Overview: Leading digital health publisher for more than 25 years. And maintain the most comprehensive and reliable source of health and medical information on the internet.
- Understanding the business requirements and design the rules using Sql and Perl scripts
- Developing ETL's flow based on the business logics
- Code & Unit Test Case reviews.
- Developing and generating reports using Medscape BI_Tools
- Loading SCD Type 2 (Slowly Changing Dimension - Type 2) tables in Pentaho Data Integration (PDI) while handling huge data volumes
- Proof of Concept (PoC) for deriving a field using logic passed as a variable in Pentaho Data Integration (PDI)
Data Engineer
Publics Media
02.2022 - 02.2023
- Company Overview: Publics Media is the biggest group of advertising agencies in Eastern Europe, successfully dealing with digital marketing, creative solutions and advertising content.
- Understanding the business requirements and design the rules using Data Stage
- Migrating the data Historic and current data from Sql server to snowflake database
- Developing databricks harmonizers and notebooks using Python language to load the data from Azure storage to Snowflake.
- Implementation and post production support to migrated data and bugs resolution.
- Publics Media is the biggest group of advertising agencies in Eastern Europe, successfully dealing with digital marketing, creative solutions and advertising content.
Data Engineer
APS Bank
02.2021 - 02.2023
- Company Overview: APS Bank is the leading Banking sector in United Kingdom which provides customers the banking services.
- Understanding the business requirements and design the rules using Data Stage
- Preparation of High level & Low-level design documents
- Developing ETL's based on the business logics like data remediation
- Code & Unit Test Case reviews
- Implementation and post production support migrated data.
- APS Bank is the leading Banking sector in United Kingdom which provides customers the banking services.
Analyst
Citation
11.2020 - 02.2021
- Company Overview: Citation is a renowned audit consultancy with major trade organizations and industry partners ensure to give expert advice in business area.
- Understanding the business requirements and design the rules using Data Stage MYSQL scripts
- Development of the ETL for migration of data.
- Scheduling the Jobs for History and present processing data.
- Review of Coding, Test cases and results for the migration
- Quality Analysis on the migration activity
- Deployment of the project to Azure Cloud
- Citation is a renowned audit consultancy with major trade organizations and industry partners ensure to give expert advice in business area.
System Analyst
Retail BAU
09.2016 - 07.2020
- Connecting with internal and external customers to develop and analyze business intelligence needs.
- Creating the Technical documents based on the client requirements.
- Build the mappings according to the ETL specifications for the staging area data load & warehouse.
- Applied business logic on the source data by using various transformations.
- Implementing log providers and package configurations.
- Performing analysis for a wide range of requests using data in different formats and from various platforms.
Developer
Royal Enfield
12.2015 - 09.2016
- Data Transfer from Source to Adobe campaign environment
- Developed pipelines for the data transfer.
- End-to-end development of the campaign execution.
- Report creation of the campaign executed based on the business requirement
Associate Analyst
BSLI(Birla Sun Life Insurance)
11.2014 - 12.2015
- Company Overview: Birla Sun Life Mutual Fund is a joint venture between the Aditya Birla Group and the Sun Life Financial Inc. of Canada. The joint venture brings together the Aditya Birla Group's experience in the Indian market and Sun Life's global experience.
- Created Reports using SSRS based on the requirement.
- Understanding existing business model and customer requirements.
- Extensively working in data Extraction, Transformation and Loading from source to target system using Sql Server Integration Services.
- Used transformations like Derived Column, Conditional Split, Aggregate, Multicast, Sort, and Merge join, Data Conversion and Union all.
- Researcher of business problems and helped in creating models that help analyze the business problems.
- Creating and resolving incidents or tickets using remedy.
- Creating SSRS reports and deploying on to server. And also involving on delivering reports to the end users.
- Birla Sun Life Mutual Fund is a joint venture between the Aditya Birla Group and the Sun Life Financial Inc. of Canada. The joint venture brings together the Aditya Birla Group's experience in the Indian market and Sun Life's global experience.
Education
B.Tech -
PVP Siddhartha Institute of Technology (JNTU-K)
01.2005 - 01.2009
Intermediate - undefined
Sri Chaitanya Junior College
01.2003 - 01.2005
SSC - undefined
Gowtham Public School
01.2002 - 01.2003
Skills
RDBMS
undefinedAccomplishments
AZ-900: Microsoft Azure Fundamentals
PGP in Cloud Computing - Great Learning
Timeline
Senior Data Engineer
WebMD
02.2023 - Current
Data Engineer
Publics Media
02.2022 - 02.2023
Data Engineer
APS Bank
02.2021 - 02.2023
Analyst
Citation
11.2020 - 02.2021
System Analyst
Retail BAU
09.2016 - 07.2020
Developer
Royal Enfield
12.2015 - 09.2016
Associate Analyst
BSLI(Birla Sun Life Insurance)
11.2014 - 12.2015
B.Tech -
PVP Siddhartha Institute of Technology (JNTU-K)
01.2005 - 01.2009
Intermediate - undefined
Sri Chaitanya Junior College
01.2003 - 01.2005
SSC - undefined
Gowtham Public School
01.2002 - 01.2003
Similar Profiles
Sabrina Aponte SolettSabrina Aponte Solett
Production Manager Freelancer at WebMDProduction Manager Freelancer at WebMD
Taliyah WestTaliyah West
Customer Service Representative at WebMDCustomer Service Representative at WebMD
Chandrateja GollapellyChandrateja Gollapelly
Software Engineer I at WebMDSoftware Engineer I at WebMD
AVINASH NAROTEAVINASH NAROTE
Security Consultant - Information Security at Tech MahindraSecurity Consultant - Information Security at Tech Mahindra
Sailekshmi PraveenSailekshmi Praveen
Platforms Analyst at Google Operations CenterPlatforms Analyst at Google Operations Center