Ramesh Ramakrishnan Email & Phone Number

Cincinnati, Ohio, Us

Cincinnati, Ohio, Us

Implementing Azure real time stream analytics using Kafka /Event Hub/ Data Lake / Cosmos Db / Synapse / Power Bi

Cincinnati, Ohio, Us

Implementing Data warehousing 2.0 using Teradata FSDM

Cincinnati, Ohio, Us

Lead Technology Architect - Business Intelligence Team. • Successfully delivered solutions for Enterprise Data warehouse projects by serving the following roles: Customer Data Mart Architect – Designed, Build and Maintaining 4.5 TB Data Mart. This Project along with Enterprise customer information file won the 24th Annual CIO Award on August 2011. Data warehouse architect (Open system) – assess readiness of data warehouse environment for new projects, participate in the review of the business requirements, and conduct source data profiling.  Data Modeler – build models of data marts that will be supported by the baseline EDR relational model. ETL architect – design and build data integration solutions for various projects.  Developed and implemented House holding algorithm using QualityStage v 8.1 and Information Server (Datastage) 8.1. Continue to provide high-level support of existing data warehouse production solutions Support various marts in UDB like Marketing, Retail, Customer issue tracking, HR and Collection system Closely work with DBA team to Monitor, Optimize and Utilize Db2 UDB environment. Work with DBA team and come up with the Archiving strategies for open system data. Prepare for mentoring relationship with offshore consulting regarding support of solutions. Advocate Best practices Propagate enterprise vision, strategy, and standards

Chicago, Il, Us

Worked as a Senior ETL Analyst. I, Developed various in-house data marts using Datastage v6.0 like Sales Data Mart , Allocations(P&L),Forecast Accuracy, Customer Scorecard and TDM(transportation data mart). Responsible for daily JDE extracts, weekly Seibel extracts, Dimension load and fact jobs. Worked on the upgrade of Datastage server from V6.0 to V7.5

In

Project: Vehicle Cost Analysis Management System (VCAMS)-GM Role: Data Architect / ETL Designer Datastage 6.5 & DBA / Team size: 35This project involves developing two big data warehouses and a data mart for GM. One database is in Oracle and other is in DB2 UDB. Vehicle information are stored in Db2. Project: People Soft Financial /HR Data Warehouse – Clemson UniversityRole: Oracle DBA/ETL Team Lead/Data Architect /Team size : 12Performed as a DBA/ETL Team Lead. Project involves the creation of a data warehouse based on a PeopleSoft Finance and HR system v7.5 implementation using Oracle 8.1.7 and Crystal Reports 8.5. Implemented back up and Restore procedures. Also implemented Fine-grained access control (Row Level Security) for the HR tables using ORACLE 8.1.7 security modules. I have contributed to other activities like interviewing, hiring, project planning, and ensuring that the project completed successfullyProject: Hourly Staffing System Data Mart – GEAE Role: Lead Informatica ETL Developer / Team size: 5Performed as an Informatica ETL designer and developer. Project involves the creation of a data mart in Oracle DB based on Staff information. Did source to target mapping. Extracted data from various sources like mainframe and Oracle DB. Cleansed it and transformed it into a Relational model

Southborough, Ma, Us

Worked on various projects as a Senior consultantProject: Financial Data Warehouse- MICHELIN NORTH AMERICA INCRole: Oracle Express/OFA / Oracle Apps- DBA Project: Failure Analysis System- SEAGATE TECHNOLOGIESRole: Oracle Express /DBA Project: Sales Force Automation - Schering Plough PharmaceuticalsRole: Oracle Express Consultant – PWC ProjectProject: Financial Data MartRole: Oracle Express Consultant Performed as an Oracle Express Consultant in the State University of New York – a client of KPMG.

I worked as a Business System Analyst. This is subsidiary company of Inchcape UK, which is one of the pioneer multinational marketing companies in Middle East. Projects: Retail Data warehouse Upgrade/Maintenance• Responsible for the Retail Data warehouse• Extracted all the retail data from POS and loaded into Warehouse• Maintained 3 years of historyProjects : Customization and implementation of retail system (POS), Back Office Systems (RETAIL)Role: Retail Tech Lead 05/1997 to 10/1998Team size: 55This company having 10 stores across middle east. We have implemented a UK based POS systems to our stores. I am responsible for Customization, Implementation , User training and Support. Also we have fully integrated the back office systems to the POS systems. Using back office systems, company maintained the pricing information accurately. I have extracted the sales data to our data warehouse for future analysis.

Developed WAN system and Maintained it.

Developer

Pgdca, Computer Science

Master'S, Maths

Bs, Maths