Ram Iyer Email & Phone Number

Glen Burnie, Md, Us

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.

• 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

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.

**** 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

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

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.

• 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.

• 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.

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.

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.

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

Worked in building data warehouse.

Jouy-En-Joas, Yvelines, Fr

Worked in re-engineering, DW implementation

Jericho, New York, Us

Worked in Oracle re-engineering project

Dubai, Ae

Gurgaon, Haryana, In

Bs, Mathematics & Statistics

Masters, System Analysis & Design