Ramya Arumugam work email
- Valid
Ramya Arumugam personal email
With over two decades of in-depth expertise in Data Engineering and Business Intelligence, I am a seasoned expert in creating advanced Data Pipeline strategies that seamlessly integrate, transform, and process data across Data Warehouse and Data Lake environments. My deep expertise in Cloud Technologies, particularly in designing and executing robust Analytics solutions utilizing ETL/ELT methodologies, Snowflake Cloud Data Warehouse, and AWS Services, empowers organizations to derive actionable insights and drive data-driven decisions.Key Competencies:Project Management: A seasoned Agile Project Manager with deep expertise in Scrum, Waterfall, and Agile methodologies. Proficient in developing processes that drive continuous progress, team achievement, and successful project delivery. Extensive experience in project analysis, design, re-engineering, process optimization, cost control, resource planning, risk management, and status reporting.Enterprise Data Architecture: Accomplished Enterprise Data Architect with a proven track record in shaping enterprise architecture across multiple lines of business. Expert in developing and executing long-term architecture strategies, defining principles, styles, patterns, and standards. Technical Proficiency: ❖ Data warehousing/Business Intelligence: dbt (Data Build Tool), Informatica Power center v10.4, Informatica Data Quality v10.4, Informatica Intelligent Cloud Services, Informatica Analyst, Metadata manager, Master Data Management v10.3 (MDM), Test Data Management (TDM), IBM Data Stage v9.1, Lavastorm LAE v4.6, Siebel Analytics v7.8, Oracle Business Intelligence v10.1, Denodo v7.0 ❖ Cloud Technologies: Snowflake Cloud, AWS Cloud Services ❖ DevOps: CI/CD pipeline, containerization (Red Hat OpenShift), automation technologies GitHub, Jenkins, Docker, Kubernetes ❖ Data Modeling Tools: erwin Data Modeler, ER Studio Data Architect, Alation Data Catalog ❖ Databases: Snowflake, NoSQL (MongoDB), Oracle, MS SQL Server, PostgreSQL ❖ Programming: SQL, PL/SQL, SnowSQL, Python, Shell Script ❖ Workload Automation/Scheduling Tools: Apache Airflow, Control-M, AutoSys, IBM Tivoli, Tidal Automation, AppWorx, Crontab ❖ Monitoring Tools: Splunk, New Relic ❖ Versioning Tools: Git, GitHub, Team Foundations Server (TFS), Subversion (SVN), PVCS Version Manager, IBM Rational ClearCase ❖ Service Management: Atlassian JIRA, ServiceNow, HP Service Manager ❖ Collaboration Tools: SharePoint, Confluence, Slack, MS Teams ❖ Project Management Techniques: Gantt Chart, Work Breakdown Structure, Agile, Kanban, Scrum
-
Data ArchitectMphasisFremont, Ca, Us
-
Principal Data Engineer/Enterprise Data ArchitectMphasis Jan 2020 - PresentBangalore, Karnataka, InWorking as Consultant with First Republic now part of JPMorgan Chase Bank---------------------------------------------------------------------------Enterprise Data Architect with extensive support in the overall enterprise architecture across multiple lines of business, developing and driving long-term architecture strategy, providing cost-effective solutions, and supporting the development of architecture principles, styles, patterns, and standards.Projects accomplished -❖ Banking Core Transformation Program: Developed and deployed a fully integrated banking solution that delivers seamless support for retail and commercial clients, the best-in-class digital products and capabilities, integrated with open banking APIs and events, a rich data platform with actionable analytics, security and compliant solutions.❖ Snowflake Migration: Managed cloud migration to Snowflake, creating scalable data ingestion pipelines with Informatica and Python. Migrated Data Lake and Data Marts from data center hosted on-prem SQL Servers to Snowflake cloud-based data platform. Accomplished Client's expectation to have migration with Low down-time, ensuring the bank experiences no disruptions, and keeping the impact on production processing to a bare minimum, given the critical nature of the business application. Entire process of moving to a new Snowflake platform executed in 2 phases, Data Migration (Phase I) and ETL Conversion (Phase II) successfully.❖ Banking Data Lake Implementation and Cache platform and Transaction history for Online banking❖ Denodo Development and Support: Enterprise data modeling and virtualization tool enables business users to efficiently retrieve, analyze, and create reports from both on-premises and cloud databases❖ Salesforce Integration for real-time data movement from Salesforce using Fivetran ❖ Enterprise Data Integration & Retention : Data Pipeline tool and architecture design for data movement from Snowflake share to AWS
-
Role: Senior Data Engineer (Designation: Technical Project Manager)Mphasis Oct 2015 - Dec 2019Bangalore, Karnataka, InProjects accomplished – Working as Consultant with First Republic now part of JPMorgan Chase Bank❖ Enterprise Data Warehouse Modernization: Led the migration of legacy data warehouses to Snowflake, modernizing ETL, database upgrades, data mart creation, and application consolidation to keep up with the constantly evolving needs of the industry and incorporating new technologies.❖ SSIS 2012 to Informatica Conversion: Migrated existing SQL Server Integration Services (SSIS) packages to Informatica, streamlining ETL processes, enhancing scalability, and leveraging Informatica's advanced features using IDQ, MDM, TDM, Data Masking, Metadata Management.❖ NoSQL Database for Banking Apps: Implemented a NoSQL Database solution to Support Mobile applications for Bankers, designed to handle large data volumes at high speed with a scale-out architecture. This solution enabled the timely delivery of information to customers, significantly improving response times.❖ Customer Segmentation Analysis: Developed data models and ETL pipelines for analyzing customer data for Data Scientist and Analytics team, enabling targeted marketing and improved retention.❖ Data Warehouse Development & Production Support: Built Data ingestion pipelines with Informatica, Python and data movement using DBT and Fivetran.
-
Role: Senior Etl Lead (Designation: Delivery Project Leader)Mphasis May 2011 - Sep 2015Bangalore, Karnataka, InProjects accomplished – Worked on assignments with Ally Bank, Abbott Laboratories, AIG Insurance❖ Life and Retirement Annuities Data Warehouse: Implemented ETL for Western National Life, AGL Indexed Annuities, and SPIA/DIA products into the DW, enhancing reporting and analytics for AIG. ❖ HR Global SOR - Data Migration into Workday: Extracted and transformed data using APIs, tables, and flat files, outputting in iLoad format for Workday uploads at Abbott Laboratories. Decreased data migration time, resulting in labor cost savings.❖ Core Policy System: Managed data warehouse and reporting for the Global Extended Warranty application, processing daily iWarranty data for Ally Bank via Cognos. Reduced data processing errors, saving warranty claims and administrative costs.❖ Data Acquisition and Standardization - BASEL I/II: Oversaw data acquisition and standardization to meet BASEL I and II compliance, reduced risk of penalties, and enhanced financial stability and reporting accuracy for Ally Bank.❖ Commercial Lending Profitability and Risk Management: Created data management and reporting tools to support Finance, Risk Management, and Commercial Lending, focusing on retail dealers for consumer and auto finance.
-
Role: Etl Developer (Designation: It Analyst)Tata Consultancy Services Oct 2005 - Apr 2011Mumbai, Maharashtra, InProjects accomplished – Worked on assignments with British Telecom, Nokia, Cummins Inc, Michaels Stores Inc, PNC Bank❖ Bulk Data Extract: Enabled real-time visibility into mortgage business data for PNC Bank, improved decision-making and customer service by providing immediate access to loan terms and down payment information.❖ Clearance Optimization (Inventory): Enhanced data access for merchandising activities at Michaels Stores, Inc., improved inventory management, optimized pricing, and streamlined replenishment processes, resulting in cost savings of approximately 15% and a 10% increase in sales efficiency.❖ Global Visibility & Progressive Bill of Material: Provided real-time supply chain visibility from suppliers to the Cummins plant. Enhanced supply chain efficiency, reduced lead times by 20%, and improved production planning, leading to cost reductions and better resource management.❖ Retail & Common Contact Center Platform: Facilitated direct communication with retail sales personnel to boost engagement and market share for Nokia by 12% through improved communication channels and better alignment with retail strategies.❖ Line Share Automation: Streamlined data processing for order entry, including pre-order inquiries and firm orders for British Telecom. Reduced processing times by 30%, increased order accuracy, and enhanced customer satisfaction, resulting in operational cost savings and improved service delivery. -
Asst. Systems Engineer3I Infotech Nov 2004 - Sep 2005Navi Mumbai, Maharashtra, InProjects accomplished – Worked on assignments with Oriental Insurance Company Ltd❖ PREMIA insurance management solutions suite development and enhancement of software solutions to capture information related to underwriting / policy administration, claims management, reinsurance and accounting using Oracle Forms/Reports & PL/SQL. -
Software EngineerDowell Technologies Pvt. Ltd Aug 2003 - Oct 2004Chennai, Tamilnadu, InProjects accomplished – Worked on assignments with ITC Ltd, Aquili Information System❖ HRMS (Human Resource Management System) product suite designed to empower the human resources department in efficiently storing, updating, and sharing information related to Time & Attendance, Payroll, and various other workforce management tasks using Oracle Forms/Reports & PL/SQL.
Ramya Arumugam Skills
Ramya Arumugam Education Details
-
Sri Sivasubramaniya Nadar College Of EngineeringComputer Applications -
M.O.P. Vaishnav College For Women - IndiaCommerce & Accountancy
Frequently Asked Questions about Ramya Arumugam
What company does Ramya Arumugam work for?
Ramya Arumugam works for Mphasis
What is Ramya Arumugam's role at the current company?
Ramya Arumugam's current role is Data Architect.
What is Ramya Arumugam's email address?
Ramya Arumugam's email address is ra****@****sis.com
What schools did Ramya Arumugam attend?
Ramya Arumugam attended Sri Sivasubramaniya Nadar College Of Engineering, M.o.p. Vaishnav College For Women - India.
What skills is Ramya Arumugam known for?
Ramya Arumugam has skills like Sdlc, Software Project Management, Requirements Analysis, Agile Methodologies, Solution Architecture, Pmp, Itil, Global Delivery, It Service Management, Business Analysis, Service Delivery, Pre Sales.
Who are Ramya Arumugam's colleagues?
Ramya Arumugam's colleagues are Ayesha Shaik, Charan Kumar H S, Francisco Puig Escalante, Rajesh Tarigoppala, Nethra Princesss, Ashish Narayan01, Joseph Breen.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial