Ram Iyer

Ram Iyer Email and Phone Number

Data/MDM/Cloud integration Specialist - Self Employed with Active MBI Clearance @ Glen Burnie, MD, US
Glen Burnie, MD, US
Ram Iyer's Location
Glen Burnie, Maryland, United States, United States
Ram Iyer's Contact Details

Ram Iyer personal email

About Ram Iyer

• Well-organized, goal-driven, and inquisitive data management professional, who brings fresh insights , adding value to your data. • Delivered over 600+ Data Feeds from ICD to ETL code delivery in Multi technology environment of Federal Agencies and supported 400+ jobs to run as well oiled machine in complex infrastructure setups.• Skilled in the full implementation of the end to end solution from ETL to BI. My business focused approach to data warehousing ensures that the warehouse delivers clear value. Whether you’re just getting started, expanding, or realigning with the business, you can count on my services to ensure your success.• Experienced in the overall development of the data integration architecture/design of the project. Delivered the overall data integration design for ERP implementations by leveraging ETL technology and designing solutions to integrate data from various application systems and platforms into a common, integrated business management and reporting environment. • Experienced in PostGreSQL / Greenplum database and worked on data pipeline for non-relational data structure, NoSQL data model, ETL development, database design, and SQL development with experience in data analysis, data modeling, BI reporting.• Involved in complex discussions and engagements that may involve multiple project teams.• Communicated complex topics through effective documentation as well as presentation.• SQL/PLSQL, UNIX, Oracle 19c, Designer, HL7,Erwin, Informatica 10.4, Abinitio, OWB 11gR2, DataProfiler, OBIEE , Greenplum, Postgresql, Python• Reviewed application processes/databases to improve performance by 600% • Diagnosed application errors/complex problems and fixed it in short turnaround time (within 8 hours) • Helped to succeed and thrive by building valuable information from data to reduce inventory and increase sales • Delivered the project in three-quarters of the budgeted time and did it right the first time • Consult on all facets of system architecture and deployment with emphasis on OLTP and DW applicationsSpecialties: • Execute tasks right the first time • Deliver with gut instinct for what will work and what won’t. I think this talent takes roughly years to refine. • Implement projects on schedule and within budget with proven expertise • Virtual Team Leadership• Scope/Capture Requirement Definition • Help to leverage your data assets by providing value to your information consumers, which aid accountability, shape strategy and realize measurable impact on your bottom line.

Ram Iyer's Current Company Details
Federal Agency

Federal Agency

Data/MDM/Cloud integration Specialist - Self Employed with Active MBI Clearance
Glen Burnie, MD, US
Ram Iyer Work Experience Details
  • Federal Agency
    Federal Agency
    Glen Burnie, Md, Us
  • Federal Agency
    Dm | Data Lake | Etl Consultant
    Federal Agency Nov 2022 - Present
    Supporting Cloudification of applications in Federal agency. Helped in systems development and modernization of legacy systems, building up and leveraging data and analytics to operate more effectively.Prepared On-Prem to cloud Data Pipelines delivery process and evaluated/implemented connectivity options. Strategized and enabled On-Prem to could Data Pipeline deliverables for existing applications. Developed data pipelines (150+) to support end to end delivery with multiple design patterns.Deployed developed artifacts for multiple environments to adhere to federal protocols. Delivered flexible Orchestration with 150+ artifacts to perform desired production schedules and demonstrated well oiled production launch.
  • Federal Agency/Ibm
    Mdm | Dm | Dw | Bi Consultant
    Federal Agency/Ibm Feb 2013 - Apr 2022
    • Worked on Massively Parallel Processing, Big Data Analytics effort (MDM) high pressure assignment, to build the next generation Fraud Detection application. The Solution Data Warehouse, with approximately over 50K attributes covering a comprehensive, historical, picture of all key entities, with associated relationships. A rich Operational Data Store was built using Greenplum DB to house key data needed for scoring entities based on sophisticated business rules and tax fraud analytic models.PostGreSQL, Greenplum, Informatica 10.4 B2B, data Transformation (B2B), ETL, data Analysis, Python, Control-M, Xmlspy, bash/Linux shell scripts, dashboards, Federal Domain : MeF, GMF, TPPS, TPDS, EFDS, Return Review Program (RRP)Security Clearances: *** US Treasury/IRS MBI Public Trust - Active
  • Federal Agency
    Mdm | Dm | Dw | Bi Consultant
    Federal Agency Feb 2013 - Apr 2022
    Here are notes about my deliverables from leadership:1) I wanted to thank you for your contribution to the Program over the last 9 years. You were a critical resource for the ETL team and you could be counted on to complete your assignments, including Filing Season Changes for many data sources, in a timely manner. You reacted quickly to production, and test environment defects with analysis and fixes, proactively followed up on issues, opened tickets to document production issues and helped to resolve them. The team members who worked with you said that you worked very hard, always strived to learn new skills, and when called, you were willing to work after hours when we had production incidents. 2) Thank you for the support and goodwill you’ve shown over the years in the project. It was a pleasure to learn from you, and part of your team.Your support and encouragement during the difficult and the good times in the project are inseparable. Thank you for the support, hard work, excellent delivery, and encouragement during your tenure with the project. I am sure, your delivery will continue to have an impact on the project moving forward.3) We have overcome filing season obstacles yearly, navigated opposition that has come our way, and made improvements to project that will have an ROI for years to come. Thank you for the late nights and early mornings. Thank you for the dedication to success. Thank you for being YOU! It has been both an honor and blessing to have had the privilege to work with you.
  • Self Employed -
    Mdm | Dm | Dw | Bi Consultant
    Self Employed - Nov 2009 - Feb 2013
    **** Active MBI clearanceDelivering Business Intelligence, Analytics and Data Integration based solutions to US Government customers. Delivering in large program at the US Internal Revenue Service modernize their core solution to find and prevent tax fraud by building MDM framework in Return Review Program (RRP).Some of our other customers rely upon us to help in high expertise Data Management, Data Warehouse, Big data ETL and Business Intelligence projects, because their internal resources are fully engaged in long term mission critical work. The user community was excited to see right data 1st time! The user community gained confidence in the application by providing additional engagements including regulatory need.• The user community was looking for fix on reporting layer for awhile, but we re-looked Data provisioning and Information Delivery process and walked-through requirements bottom-up and resolved the issue. • Worked in E-Business Environment Implementation project for the Hospitality/energy Industry in the area of data mapping of XML source applications, ETL design/development/enhancements, data validation/analysis, unit test process and trouble shooting. Learned the sources and processes quickly. • Developed ETL and coached/directed others for efficient components.• Designed/developed mapping specs and ETL technical specifications.• Developed walk through process to navigate complex business requirements.• Designed/developed mapping specs and ETL technical specifications/process for HL7 oriented application.• Provided Strategic Business Intelligence services.• Locked in enjoyable teaming relationships for Federal RFP responses• Provided effective technical contents adhering to RFP guidelines/winning strategies• To identify real business ROI in Data Warehouse(DW)/Business intelligence(BI) solutions• To find right data for business community in BI delivery• To recover from a failed or stalled DW/BI initiatives
  • Independent Professional Services
    Erp | Data Management | Data Warehouse(Dw) | Bi Consultant
    Independent Professional Services Jun 1997 - Jun 2009
    ACCOMPLISHMENTS & ACHIEVEMENTS• Designed/Developed mapping specs , mappings and ETL technical specifications for across system validation for EDW, BDM and DV • Examine over 90+ processes and data sources in legacy systems, built data models (3NF) with 110+ entities with complex relationships • Generated 55+ applications and maintained 220+ database objects • Performed Database administration (DBA over 1TB) with multiple instances and led a team of 5/6 database professionals of a large (2+ TB) data warehouse • Coordinated a team of 5 in a project to develop 100+ processes in bbx, PL/SQL, SQL, and shell. Completed projects in 4 months • Designed/Led data warehouse/model (Star/Snowflake) and relational/normalized model (3NF) with over 500+ objects in database schema effort • Adopted strategy to prevent failures and acted swiftly to recover from application failures • Analyzed critical/complex processes of application packages to design ETL, XML processes
  • Independent Professional Services
    Dm | Dw | Bi | Etl Consultant
    Independent Professional Services Jun 1999 - Aug 2002
    Development and growth the entire Data warehouse (DW) for Merchandise application. Consult with local businesses and lead project teams in major Merchandise DW and Re-engineering initiative. Provided technical expertise to resolve database related issues and design problems. implementation and resolution of information flow issues, Managing Data warehouse production environment, Monitoring Data warehouse and identify, research and coordinate the resolution of data anomalies, managing the meta data, resolving basic end-user questions and ensuring complete knowledge and understanding, Adding new functionality, worked with business and technical managers to design/develop cubes/reports using the Cognos toolset with multiple summary tables. Prepared data model and designed databases for data mart and OLTP requirement using ERWIN. Evaluation of Informatica tool for ETL process. Development of custom ETL, OWB and Syncsort based ETL processes. Building OLAP cubes in Cognos Powerplay.
  • Self Employed
    Dm | Dw | Bi | Etl Consultant
    Self Employed 2008 - 2009
    • Helped the Fixed Assets and accounting of Energy Company in walk-through and document requirements on users’ perspective, Identified the system of record for sourcing, performed Impact analysis of requirement on Database , ETL, BI and presentation layers of Enterprise Data Warehouse (EDW),• Designed/Implemented enhancements to Database/ETL/BI/Presentation layers, Balanced impact of changes on Database , ETL, BI and presentation layers regarding reporting deficiencies and Rightly aligned the Database/ETL/BI/Presentation layers. Built BI solutions for ERP/ Oracle E-Business Suite and operational data and enforced ETL standards.• FA user community was excited to see right data 1st time! Availability of Data Model, Requirement Specification, ETL mapping specification, and Cognos Frame Work Design Specification helped FA user community gain confidence in Data Management deliverables.
  • Linium
    Erp | Dm | Dw | Bi | Etl Consultant
    Linium Jun 2007 - Jan 2008
    • Researched and defined data sources and targets for ERP modules data extracts along with Human Resources data mart conversions for Enterprise Performance (BI). • Defined Business Rule conversions and extensions to satisfy BI metadata requirements and Federal Energy Regulatory Commission (FERC) guidelines for reporting in Enterprise Planning application.• Developed data integration/feed piece for large ERP, Hyperion implementation.
  • Ips Inc
    Dm | Dw | Bi | Etl Consultant
    Ips Inc Aug 2004 - May 2007
    London, Gb
    • Designed and delivered data mapping and ETL (INFA) from XML source systems to KOR database. The data were moved from landing, staging to KOR DB. Developed ETL/BI/Models and coached/directed others for efficient components.• Worked in BASEL II, Credit Risk Reporting, Data Governance/Quality, BDM and Enterprise Warehouse Environment Implementation project for the Financial institution in the area of data mapping of multiple legacy applications, ETL design/development, data validation/analysis, unit test process and trouble shooting. Delivered numerous ETL (Ab initio) reliable graphs for the project and in many instances produced the graphs/mappings in extremely short periods of time. Oriented quickly with staff/consultants in a very short period of time and work effectively.
  • Ips Inc
    Dm | Dw | Bi | Etl Consultant
    Ips Inc Sep 2002 - Jul 2004
    London, Gb
    Delivered billing module to support manufacturing application. Built logical and physical model of business entities, Developed ETL (OWB) process to bring data from legacy system, Generated billing application via Designer 6I, maintained database objects and repository. Provided technical expertise to resolve database related issues and design problems. Coordinated development tools support, identify, research and coordinate the resolution of data anomalies, Training of end users on applications, resolving basic end-user questions and ensuring complete knowledge and understanding, Adding new functionality. Delivered ETL on XML/DB environment.
  • World Bank Group
    Dm | Dw | Bi | Etl Consultant
    World Bank Group Jul 1998 - Jun 2000
    Preparation of Repository and models for Risk Management Data warehouse application. Packaged Application Database analysis, Building Logical, Physical Data model and Database design, Integrating Oracle Objects with Crystal Info. Participated in user discussion and project review. Developed tools to manipulate a series of data specific to applications. Mastered an application once it is assigned. Functioned effectively even when there is only sketchy documentation available. Building OLAP cube, Building Logical, Physical Data Model for Star, Normalized and Relational Schemas using Erwin modeling tool was undertaken. Primarily Platinum Erwin is used for modeling. Crystal Info is used for Business Intelligent view
  • Cable & Wireless
    Dm | Dw | Bi | Etl Consultant
    Cable & Wireless Dec 1997 - Jun 1998
    Worked in building data warehouse.
  • Qwest Communications
    Dm | Dw | Bi | Etl Consultant
    Qwest Communications Jun 1997 - Nov 1997
    Jouy-En-Joas, Yvelines, Fr
    Worked in re-engineering, DW implementation
  • 1800Flowers.Com
    Dm | Dw | Bi | Etl Consultant
    1800Flowers.Com Dec 1996 - May 1997
    Jericho, New York, Us
    Worked in Oracle re-engineering project
  • Square D Software
    Consultant
    Square D Software Aug 1995 - May 1997
  • Bitech International
    Senior Consultant
    Bitech International Apr 1990 - Oct 1995
    Dubai, Ae
  • Mascon Global
    Senior Consultant
    Mascon Global Nov 1984 - Jun 1990
    Gurgaon, Haryana, In

Ram Iyer Skills

Data Warehousing Etl Data Integration Business Intelligence Oracle Informatica Integration Ssrs Pl/sql Data Modeling Unix Obiee Cognos Enterprise Architecture Requirements Analysis Enterprise Software Oracle Warehouse Builder Sql/plsql Erwin Sql Oracle E Business Suite Erp Performance Tuning Oracle 10g/11g Oracle Designer Olap Business Objects Database Administration Owb 11gr2 Ab Initio Data Marts Xml Software Documentation Db2 Hl7 Abinitio Dataprofiler Big Data Big Data Analytics

Ram Iyer Education Details

  • University Of Jaffna
    University Of Jaffna
    Mathematics & Statistics
  • Annamalai University
    Annamalai University
    System Analysis & Design

Frequently Asked Questions about Ram Iyer

What company does Ram Iyer work for?

Ram Iyer works for Federal Agency

What is Ram Iyer's role at the current company?

Ram Iyer's current role is Data/MDM/Cloud integration Specialist - Self Employed with Active MBI Clearance.

What is Ram Iyer's email address?

Ram Iyer's email address is ir****@****hoo.com

What schools did Ram Iyer attend?

Ram Iyer attended University Of Jaffna, Annamalai University.

What are some of Ram Iyer's interests?

Ram Iyer has interest in Law Of Attraction, Etl, Technology, Web Marketing, Self Development, Business Models, Economics, Business, Stock Market, Ab Initio.

What skills is Ram Iyer known for?

Ram Iyer has skills like Data Warehousing, Etl, Data Integration, Business Intelligence, Oracle, Informatica, Integration, Ssrs, Pl/sql, Data Modeling, Unix, Obiee.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

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.