Ramesh Murugan Email & Phone Number

Texas, United States

Menlo Park, Ca, Us

Seattle, Wa, Us

• Designed & built large scale, robust & fault tolerant data lakes & data pipelines to process & publish huge volume of Daily & Monthly Worldwide AWS Revenue data for the purpose of compensating Sales Agent• Integrated data from heterogeneous data sources, apply and ensure data standardization & data validation rules• Managed end-to-end data architecture, from selecting the platform, designing the technical architecture, and developing the application to finally testing and implementing the proposed solution.• Built and set up development tools and infrastructure required for data pipelines• Productionized models developed by the Data Science team by building model hosting and inferencing solutions

Seattle, Wa, Us

• Built data pipelines delivering the information required by Data Scientists to enhance the capability of Alexa Data Services.• Worked with Data Scientists and Product Manager across the globe to provide them data that matters the most to help them with their statistical analysis.• Communicate analysis and insights to stakeholders and business leaders both verbally and in writing.• Built data pipelines to source structured and unstructured data from various sources such as Redshift, JSON, S3, Oracle using AWS pipeline and Amazon Internal tools such as Datanet Distributed Job Scheduler, Hammerstone etc.• Built various Python and SQL scripts to ingest information into SQS & Kinesis Queues eventually used by Data Associates & Data Scientists.• Automated and built the multiple solutions to improve Alexa's internal customer experience:

Teaneck, New Jersey, Us

• Involved in building the ETL architecture and Source to Target mapping to load data into Data Marts for Comprehensive Capital Analysis and Review Reporting.• The Data Mart involved 23 Line of Business servicing systems and 6 origination application information flowing into different DataMart such as Servicing, Origination Risk Exposure Data Credit Mart etc.• Worked on Informatica BDM & Sqoop to load data to HDFS raw layer and then load the data to Staging, UIR and Mart Hive tables.Knowledge on Spark programming.• Analyzed the business requirements, designed and developed the ETL mappings involving complex business rules in Informatica to load the data from sources such as Relational tables, Flat files, Oracle tables, Mainframe into the target Data warehouse.• Developed Dimensional data modeling of the data warehouse projects by using star & snowflake schema.• Data analysis using python libraries pandas & Informatica Data Quality (IDQ).• Instruct, guide team members and facilitates team and client meetings effectively

• Developed technical specifications of the ETL process flow• Coordinated offshore and onsite team with a total of 7 ETL developers• Analyzed the existing mainframe reports and created reporting tables for new system.• Designed and developed Informatica jobs from heterogeneous sources, applied transform logics and loaded data into Data Warehouses / Data Marts. • Used Informatica Power Center to create mappings, sessions and workflows for populating the data into dimension, fact, and lookup tables simultaneously from different source systems (SQL server, Oracle, Flat files).• Active participation in decision making, QA meetings and regularly interacted with the Business Analysts and SMEs to understand the Business Process, Requirements & Designs.

Bangalore, Karnataka, In

• Worked on multiple Enhancement projects for GMACI client (General Motors Insurance)• Develop programs for the requirements and conduct table review internally within the team to ensure the deliverable quality.• Providing 24x7 on call support