Raj Allam Email & Phone Number

Crystal City, Virginia, United States

IPPS-A (Integrated Personal & Pay System - Army): The Army currently relies on more than 60 separate legacy information systems to provide personnel & pay management for all Army components (Active, Guard, and Reserve). These systems were designed at different times, reside on different hardware platforms, and to consolidate the Army is developing and implementing the Integrated Personnel and Pay System – Army (IPPS-A), a Web-based tool accessible to Soldiers, HR professionals, Combatant Commanders, and other authorized users throughout the Army.Responsibilities: • Highly involved IPPS-A strategic decisions and timely offered inputs on various data management paradigms Metadata, Master data, Data Quality, Data Archiving, Data Security and Business Intelligence platforms.• Architect epic level design patterns for Program protection Implementation Plan (PPIP), Data Conversion & Interface Plan (DCIP), Business Intelligence and Data Analytics Plan (BIDA), Data Quality Analysis Report (DQAR), Service Oriented Architecture & Enterprise Service Bus (SOA-ESB) and Out Bound DD(Topics) shipping data to partner systems. • Reviewed CDRL's, DD's, comment sheets with various parties Army, System Integrator(SI), PMO and Government over DCIP, BIDA, DQAR, SOA-ESB, Out Bound DD's and emphasized importance of data quality framework, Error Resolution Automation process and Audit & Traceability for IPPS-A program. • Build DODAF Models [OV1 - OV6c, SV1 - SV10c], Data Models [ELDM & Epic models], SOA Models [Topics & Web Services], Taxonomies, Enterprise data dictionary, DIV2(logical construct) to DIV3(physical construct) logistics and DD's connecting dots across IPPS-A place holders such as Inbound Interfaces, PeopleSoft HCM and Outbound partner systems. • Appraised Outbound DD delivery patterns Topics, Web services and P2P outbound interfaces, offered recommendations and comprehensive data flows from external seeding systems to subsequent HCM data hops and IPPS-A resting systems.

Crystal City, Va

IPPS-A (Integrated Personal & Pay System - Army): The Army currently relies on more than 60 separate legacy information systems to provide personnel & pay management for all Army components (Active, Guard, and Reserve). These systems were designed at different times, reside on different hardware platforms, and to consolidate the Army is developing and implementing the Integrated Personnel and Pay System – Army (IPPS-A), a Web-based tool accessible to Soldiers, HR professionals, Combatant Commanders, and other authorized users throughout the Army.Responsibilities: • Highly involved IPPS-A strategic decisions and timely offered inputs on various data management paradigms Metadata, Master data, Data Quality, Data Archiving, Data Security and Business Intelligence platforms.• Architect epic level design patterns for Program protection Implementation Plan (PPIP), Data Conversion & Interface Plan (DCIP), Business Intelligence and Data Analytics Plan (BIDA), Data Quality Analysis Report (DQAR), Service Oriented Architecture & Enterprise Service Bus (SOA-ESB) and Out Bound DD(Topics) shipping data to partner systems. • Reviewed CDRL's, DD's, comment sheets with various parties Army, System Integrator(SI), PMO and Government over DCIP, BIDA, DQAR, SOA-ESB, Out Bound DD's and emphasized importance of data quality framework, Error Resolution Automation process and Audit & Traceability for IPPS-A program. • Build DODAF Models [OV1 - OV6c, SV1 - SV10c], Data Models [ELDM & Epic models], SOA Models [Topics & Web Services], Taxonomies, Enterprise data dictionary, DIV2(logical construct) to DIV3(physical construct) logistics and DD's connecting dots across IPPS-A place holders such as Inbound Interfaces, PeopleSoft HCM and Outbound partner systems. • Appraised Outbound DD delivery patterns Topics, Web services and P2P outbound interfaces, offered recommendations and comprehensive data flows from external seeding systems to subsequent HCM data hops and IPPS-A resting systems.

Chantilly, Va

• Owned 12 data delivery streams under MIDAS program• Align the solution architecture and design with our overall technology strategy with project road map.• As a member of tiger team, engaged several cloud architectural initiates right from setting up VPC backbone, three tier architecture cloud initiative, EMR transient clusters, data migrations, redesigned applications to cloud standards, applications inventory over cloud, processing models against S3, HDFS and Redshift data storages.• Re-designed applications stack to support AWS EMR transient nature & Idempotency.• Architect several applications on spark platforms as part of iterative process model initiative, helps to performance over real time & near real-time scenarios• Involved fine tuning long running M/R, Hive hqls, PIG scripts, Spark jobs, scaling cluster resources horizontal and vertical on need basis.• Architect analytical capabilities over Cognos, Tableau and SAS tools based on data temperatures like COLD data using Redshift spectrum and HOT data over native redshift capabilities.• Build centralized log analytics platform using Splunk for understanding data/process behavior patterns of MIDAS applications and ingesting real-time logs producing insights in the form of metrics, dashboards, alerts and visualizations.• Hands-on EMR spin ups, performance tuning, boot-strap scripts, test automation (2-sets & 10-sets), data processing – read & write on S3 and intermediate hops on HDFS, data encryption, data compression techniques, storage formats to smooth sail end-to-end data flows• Configured S3 buckets with various life cycle policies to archive the infrequently accessed data to storage classes based on requirements.• Taking MIDAS cloud initiative to NeXT generation by prototyping LOG Analytics using Elastic search & Kibana combination, Server less architecture following the footsteps of Lambda, Kinesis, Glue & Athena combi, kubernetizing spark ETL loads

• RWA (Real world analytics): Involved building analytics platform for RWA EMR (Electronic medical records), Claims, Survey databases Humedica, Optum, Med stat, GE centric, THIN, Kantar, Thomson & Routers for conducting BI experiments. • Common data model (CDM): Defined Abstract (Pfizer RWA definition), RWA databases insights, high level requirements, data model assessments, vendor model assessments, proposed architecture, common data model report includes near term and long-term strategies.• Data catalog: Data catalog a metadata repository which holds information of Pfizer R&D data sources and used to identify and discover "data about data". The data catalog currently has information about the top Research and Development assets such as Applications, Databases, Data entities, Business processes, Data Flows, Database structure (tables, views, etc), Informatica Metadata (mappings, source and targets, sessions, etc), Literature References, Glossaries etc• RDM (Reference data management): Designed Pfizer master clinical entities to build single version of truth organizing source identification, collection, transformation, rule administration, error detection and correction, consolidation and data storage class acts.

London, United Kingdom / Valleyforge Pa Usa

• Worked as on-site team leading 27 off-shore team players to support three warehouse systems Legacy warehouse (support, retiring application), profit system (finance system) and new build enterprise warehouse to replace legacy in AmeriSourceBergen Enterprise Business Intelligence.• Involved in designing high-level & detail design deliverables.• Involved in finalizing business requirements by closely working with business stake holder teams.• Involved source data profiling to understand source systems data structures, relationships, data gaps, data quality measurement etc• Worked as On-site lead with 15 member off-shore team to build and support British Petroleum warehouse to load on-going data for almost 37 countries around world.• Involved in the design, development and implementation of the Enterprise Data Warehousing (EDW) process and Data Mart.