Ram Iyer

TECHNICAL PROFILE

An experienced SYSTEMS PROFESSIONAL/DATAWAREHOUSE SPECIALIST with years of database development, database design and management experience. Strong technical background in Data Warehouse, Business Intelligence BI , multi-language, multi-platform programming, re-engineering, Application Integration and Data modeling (Third normal form - 3NF/Star/Snowflake) with expertise in project coordination, determination of scope and priority, project implementation, and training/development of IT staff. Proficient project and time management skills, able to implement projects on schedule and within budget.

"He has an excellent work ethic. He has completed his assignments on time, contributes to team discussions, and puts in the extra effort on the weekends to ensure that the system is functioning and stable" DW Director.

BI/ETL Tools: Cognos, Impromptu, Power Play, Crystal Info, Syncsort, Informatica, Custom, Ab Initio, 
Oracle Warehouse Builder (OWB11gR2), Microstrategy



Databases: Oracle 10g/11g, UDB, IDMS, DMS II, SqlServer



Software: SQL Developer  SQL*Loader, SQL*Plus, Oracle Reports, Clearquest, TOAD, 
Dataprofiler(Ab initio), Oracle 11i



Modeling Tool: Oracle SqlModeler, Erwin, Power Designer, BDM, DV



Languages: SQL, PL/SQL, Pro*C, Pro*COBOL, COBOL



Operating Systems: UNIX, AIX, Windows, HP-UX, Sun Solaris



Platforms: HP, IBM , SUN, UNISYS

 Merchandise/Retail ** Treasury               ** Telecom

 Risk Management    ** Customer Care          ** Marketing

 Order Processing   ** Benefit Administration ** Membership Maintenance

 Water Management   ** Sales Management       ** Purchasing

 Health Care        ** Warehouse              ** Inventory Management

 Insurance          ** Human Resource         ** Bill of Material

 MRP II             ** Distribution           ** Legal/Courts

ACCOMPLISHMENTS & ACHIEVEMENTS

• Completed all projects within contracted periods
  
• Designed/developed mapping specs and ETL technical specifications
  
• Developed transformations for legacy elements, developed Look up data
  
• Developed Mappings/ETL transformations for XML sources and property page delivery/load
  
• Analyzed OTA XML schemas to build ETL
  
• Developed graph for across system validation and EDW load
  
• Adopted strategy to prevent failures and acted swiftly to recover from application failures
  
• Delivered Data Mapping validation strategy, Reviewed/examined legacy data with Ab Initio data pro-filer
  
• Designed/Developed Ab Initio graph for Base/Subtype, interface tables , multi-update of EDW
  
• Analyzed/Developed strategy to improve performance on graph (from 11 hrs to 4 min )
  
• 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 via Oracle Designer 6i
  
• Performed Database administration DBA Oracle 8I/9I over 1TB with multiple instances and led a team of 5/6 database professionals in the design, build, and deployment 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
  
• Delivered over 200+ Oracle objects integration with Cognos/Crystal reports and implemented 600+ processes to support re-engineering effort
  
• Reviewed application processes/databases to improve performance by 600
  
• Designed/Led data warehouse/model (Star/Snowflake) and relational/normalized model (3NF) with over 500+ objects in database schema effort
  
• Diagnosed application errors/complex problems and fixed it in short turnaround time within 8 hours
  
• Designed/developed Mappings, Graphs, source/target, transformations and work flows using ETL tools
  
• Helped to succeed and thrive by building valuable information from data to reduce inventory and increase sales
  
• Adopted strategy to prevent failures and acted swiftly to recover from application failures
  
• Created proposals to support technology implementations
  
• Analyzed critical/complex processes of application packages to design ETL processes
  
• 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 database transaction processing and data warehouse applications
  

Professional Experience:

Consulted for several years in Data Management/Data warehouse/Modeling/Databases/ETL/BI with Big 4/Major Bank, TVA.HUD, Marriott International, HHS, McGraw Hill, John Hopkins, Russell William, World Duty Free, World Bank, Cable & Wireless and LCI. My proven expertise helps in the on-time deliverables, maintain quality and make your management happy. My passionate interest is essential for quality deliverables and directly contribute to your project success. Possess strong commitment to team dynamics with the ability to contribute expertise and follow leadership directives at appropriate times. Well-organized, goal-driven, and inquisitive data management professional, who brings fresh insights on adding value to data. Collaborated with key members of the business and information technology departments to develop and implement DW/BI solutions.

• Helped others achieve business and personal objectives, getting critical work done, and enabling them to feel good about themselves as people and professionals.
  
  
• Helped in getting timely, easy-to-access business information that helps organizations make critical decisions by consolidating distributed nationwide databases from local office to either shared service center at corporate or a couple regional centers, optimizing operational data bases and building interfaces to ERP applications.
  
  
• Added a realm of benefits without sacrificing the main benefit of in-house staff confidentiality. Built on that basic platform of trust, clients will gain access to a wealth of experience in the field. Aspired to complete customer satisfaction, thus creating a base for long-term profitability and a consistent source of referrals.
  
  
• Helped to leverage their data assets by providing value to their information consumers, that aid accountability, help shape strategy and realize measurable impact on their bottom line.
  
  
• Delivered central reliable source for populating numerous dashboards and queries, enabling the BI team to reduce the number of data feeds by 22% to production source systems.
  
  
• Established faster, better, and more cost-effective solution for a lot of people by retiring large data volumes of Microsoft Excel based maverick "spread-marts". User community was excited to see single version right data 1st time!
  
  

June 99 - Till Date Consultant IPS MD

Assisted the Federal agency in building Data Warehouse on ground-up with Geo-coded/GIS Census dimensions. Reviewed/identified the flaws in functional requirements and architectures. Recommended right architectures to support business needs. Built logical/physical data models and ETL architecture in-line with requirements, where business excited 1st time. Delivered ETL to populate data warehouse. Worked with Oracle database instances and objects. Delivered integrated applications with Geo-Coded, GIS and demographic data to enable BI reporting. 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 issues. They were excited about the delivery.

Assisted the Oracle accounting of Energy Company in walkthrough and document requirements on users’ perspective, Identified the system of record for sourcing, performed Impact analysis of requirement on Database , ETL(INFA), BI and presentation layers of Enterprise Data Warehouse (EDW), Designed/Implemented changes 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 user community gain confidence in Data Management deliverables. Provided Analysis of over 100+ data files for completeness and compatibility and Developed impact analysis and gap analysis on data warehouse artifacts.

Designed and delivered data mapping and ETL (INFA) from XML source (EPIC) systems to KOR database. The data were moved from landing, staging to KOR database. Worked in EBusiness Environment Implementation project for the Hospitality 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. Performed data analysis and database design and development as well as created and managed Entity Relationship Diagrams, Data Dictionaries Mapping documents, System Design Document, Data Validation, data acquisition | conversion strategies, interfaces and data warehouse artifacts. Optimized data warehouse assets to ensure high performance and data integrity. Diagnosed | Monitored | Isolated and expediently resolved issues pertaining to data warehouse and reporting systems. Developed data source integration into As-Is data warehouse infrastructure.

Skilled in the full implementation of the end to end solution from ETL to BI. My business centric 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.

Worked in EBusiness Environment Implementation project for the Hospitality 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. Delivered numerous ETL reliable mappings for the project and in many instances produced the mappings in extremely short periods of time. Oriented quickly with staff/consultants in a very short period of time and work effectively.

Develivered process and ETL modules for OWB, EPF and Oracle E-Business integration. Built logical and physical model of business entities, Developed ETL process to bring data from legacy system, Generated ETL, Process flows etc via OWB, maintained database objects and repository. Provided technical expertise to resolve database related issues and design problems. Researched and defined data sources and targets for ERP modules data extracts using ETL technology along with Human Resources, Financial, Projects data mart conversions for Enterprise Performance (BI)/Hyperion interfaces/data feeds. 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 piece for large ERP implementation. 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.

Designed and delivered data mapping and ETL (Abinitio) from multiple source systems to EDW. The data were moved from landing, staging to EDW. Worked in BASEL II Reporting, Data Governance/Quality, 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 (Abinitio) reliable graphs for the project and in many instances produced the graphs in extremely short periods of time. Oriented quickly with staff/consultants in a very short period of time and work effectively.

Development and growth of the entire Data warehouse for Merchandise application. Re-engineering of data warehouse approach adopted in this project. Provided technical expertise to resolve database related issues and design problems. Preparation of Application Database analysis, Building Logical, Physical Data model and Database design, Integrating Oracle Objects with COGNOS/Impromptu/Crystal Reports, Development DBA for 8I/9I, Development tools support, participation in user discussion and project review, Implementation and resolution of information flow issues, Managing Data warehouse production environment, Monitoring Data warehouse processes and identify, research and coordinate the resolution of data anomalies, Tuning database and applications, Developing and trouble-shooting data mapping and data conversion, Training of end users on applications, 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. Evaluation of ETL tools for ETL process. Development of custom ETL, Informatica, Ab Initio, Syncsort and OWB based ETL processes. Building OLAP cubes in Cognos Powerplay using summary tables, Building Logical, Physical Data Model for Star Schema using Oracle Designer 6i modeling tool were involved. Primarily Designer 6i with Oracle 8i/9i are used for modeling. Cognos is used for Business Intelligent development

Delivered billing module to support manufacturing application. Built logical and physical model of business entities, Developed ETL 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, HL 7(HL-7) environment.

July 98- June 2000 Consultant World Bank Group Treasury DC

Feb 98- Jun 98 Consultant Cable & Wireless, VA

June 97- Jan 98 Consultant LCI International Mc Lean, VA

Feb 97-May 97 Consultant 1-800-Flowers, NY

Nov 96-Feb 97 Project Manager/ DBA Intelligent Systems International, Gaithersburg, MD

• Composition Envelope System - Catholic University, Brookland, Washington D.C.
  
• Membership Maintenence System, American College of cardiology, Bethesda, MD
  
• Process Data Logging and Analysis, DC Department of Waterworks, Blue Plains, Washington DC.
  

Dec 94 - Aug 96 Project Leader/DBA AT&T/ISTEL, Oxford, UK. and P&O Containers, UK

Jul 91 - Nov 94 Project Leader/DBA SQUARE D SOFTWARE LIMITED AND CITI BANK, INDIA

Nov. '88 - June '91 Project Leader/Designer EMIRATES TRADING AGENCY, UK AND OMAN INSURANCE, DUBAI, U.A.E.

Training Experience:

• Received the Class 1 Certification from MARCAM Corporation USA, for MAPICS a MRP II Product
  
  
  
• Received the certification of Business Partners Program of IBM
  
  
  
• Conducted training program in Oracle for a large Corporations in India as well as in USA.
  
  
  

Education:

Memberships:

Volunteering