Senior Data/Solution Architect (18+ Years)

SUMMARY

**+years of Lead data architect/ Solution architect experience in the areas of Finance, Retail, health care Supply chain, Manufacturing, data warehousing. Fast technology learner and constantly updating/adopting of current technology developments Extensive knowledge in building enterprise wide data warehouse applications using Relational, multidimensional Model, Cubes

Experience in Enterprise Architect methodology with full cycle of SDLC, Kanban/Agile4/scrum methods in Client/server application in Unix/ Linux and experienced in AWS/Azure cloud, SQl and NoSQL database projects. .

Good functional knowledge of all business processes, agile framework, improvement and process re-engineering, mapping to system process design methods and transforming to technical architecture solutions

Skills

Knowledge in

Microsoft Technologies NET, XML, Java/J2EE, AI/ML,

Data management

Informatica, Cognos, SQL Server DTS Services, Oracle Data warehousing tools Datastage, OWB, ODI, Infosphere, AWS Glue, Azure ADF, Alation, Collibra, Microsoft Purview, Salesforce architecture

Data Modeling/Data warehousing

Process Design (12 years)

Enterprise Data warehouse design/model architecture, Virtual/Self service data analytics, ERWIN, ERstudio, Oracle Designer, Visio, MS Office tools,data vault models, Medallion architecture, Microsoft Data fabric,

Graph database design and models, DataLake architecture and strategy

Mainframe migration to cloud

Data Management and related tools

Data architecture standards, data governance, Metadata management, Master data management, data quality and Enterprise meta data dictionary/Business glossary

Cloud Data Solution (Design, storage & tools) 5 years

AWS/Azure cloud storage and tools selections, setting up of DataLake architecture with structured/unstructured data, Data migration/ ingestion tools, Predictive, data mining Analytics tools vendor evaluation on Open source tools. Knowledge in AI/ML predictions analytic models.

AI Analytical models and Vector Databases

Model design for AI analytics tools

Building Applications with vector Databases(Pinecone)

Knowledge in BigId for AI data security

Knowledge in ChatGPT, Gemini and Claude

Knowledge Graph and semantic models (Neo4J, Amazon Neptune.

Domains Experience

Finance, Healthcare, Pharma, Mortgage and Insurance, Retail/POS, Manufacturing, Supply chain.

Professional Experience

Data Architect USDA (Attain X) (From Aug 2024 Jun 2026

Design Enterprise logical model combining both process and system

Compare4 data flow models with industry standards between systems

Established data governance, AI governance, data quality, and rules for master data

Review/design Entity/semantic models solutions for AI analytics

Develop roadmap and architecture for cloud data lake/warehouse using AWS/Snowflake

Develop implementation roadmap for mainframe migration/modernization

Develop use cases to deploy AI agents in policy manuals, FAQs, workflow process.

Review tools for responsive AI adoption using LLMs,in workflows, user training as AI data strategy

Environment: Mainframe, Oracle, SQL server, Db2, ERStudio, Salesforce, Python, Collibra, AWS, Databricks/Snowflake, Graph DB

Data Architect – contract thru Kforce/Booz Allen (from Jun 2023-July 24)

Create logical data model (Infosphere) and maintain and publish data dictionary

Data mapping with PEGA Json target files from legacy SQL server data structures

ECM case management tool tasks and features data points update

Designed Databricks/AWS-based medallion architecture for data lake and data warehouse

Performed data modeling and data mapping for migration from legacy systems

Data flow diagrams updates in ECM feature/tasks

Data Integration and Warehousing using ETL tools like Informatica, Glue,

Develop Analytics model for web site traffic usage with Google Analytics data

Environment: SQL server,,Mainframe. ERStudio, Datavault, Postgre SQL,Python, Google Analytics, AWS, Dbeaver, IBM Infosphere. Databricks/Snowflake, Collibra.

Data Architect ( contract Fedex) (Jan 2022 –May 2023) (Ztek consulting)

Source system analysis for Datawarehouse migration to Oracle cloud

MDM reference model centralized repository for middleware data exchange

Reporting systems design from data lake/warehouse to feed reporting tool

Data repository design and model in Service now for Enterprise reporting and analytics.

Review/design Entity/semantic models solutions for AI analytics

Develop roadmap and architecture for cloud data warehouse using Azure/Snowflake

Promote data quality, Data/AI governance, security/encryption rules in the enterprise systems

Data migration plan documentation, strategy to Service now from various data sources.

Analytics tool Alteryx product evaluation as part of AI data strategy.

Environment : SQL server, Mainframe z/os, Oracle 19, AWS, Salesforce,Python, Erwin, Datavault, Power BI/Qlik Sense,Snowflake, Alation

Data Solutions Architect (Defense Health Agency) SPN solutions (Jan 2020 – Nov 2021)

Datawarehouse migration from SQL server to IBM Db2 planning

Consolidation of payer/claims/provider data into new target analytical model

Interface from various internal and external sources to target planning

Data warehouse Capacity and performance design in IBM Db2 environment

Discussion with 3rd party vendors for acquiring pharma data

Lead ETL development team DW implementation, migration plan from SQL server to Db2.

Reviewed solution using Snowflake architecture for health care data analysis

Create data architecture framework, data governance, data quality reference deliverables

Environment : SQL server, Mainframe/ Db2 11.1, Oracle 12, Erwin, NoSql, Visio, Informatica IICS, Tableau, Business Objects, Azure/Snowflake/Cortex, Power BI, Azure ADLS, DataFabric

Bechtel, Reston VA (Feb 2018 -Dec 2019)

Solutions Architect

Involved in Enterprise MDM solution project and MDM tools evaluation

Designed Enterprise Logical/Physical architecture, relational and graph node models

Evaluation of Enterprise search insight product for knowledge management repository/taxonomy using

intelligent AI based text search capabilities

Cloud migration strategy roadmap for applications and data from data center

OWL/Ontology based semantic data models for Graph database project.

Design and architect Collibra for data governance and quality implementation

Environment : Oracle SOA, Orchestra Networks MDM, DataFabric, Azure ADLS,Synapse, Data fabric, ERStudio,,Cosmos DB, Collibra, Power BI, Informatica, OWL,RDF models, Peoplesoft, Salesforce

CSRA, Falls Church VA (Jan 2016 -2017)

Solution Architect Principal (Data Analytics service Area)

Proposal for Capacity planning, hardware sizing, architecture for migration to cloud

Delivered solution for DW,MDM, data governance practice to client CMS

Capacity planning, (100TB) hardware sizing, architecture write up for proposal both AWS/Azure

Participated IV&V, STIG compliance process for system suitability & testing.

Proposals/solution for Navy,VA,FEMA,CMS,FAA in Data management areas

Involved in pre-sales proposal solutions as part of CSRA sales effort

Predictive analytics design for Drug smuggling in CBP model demo project

IoT device (camera, LPR) to capture predicting advanced threats in border crossing points.

Environment : Oracle, Cloudera,, AWS Redshift,,Power BI, MongoDB, Json, xml, Informatica, PostgreSQL, Salesforce, IBM infosphere 11.5 MDM, ERStudio, FHIR

Security Exchange Commission, Washington DC (IBM) (Jan 2014- Nov 2015)

Sr Data Architect

Developed Enterprise logical/physical model complying FEAF framework

Design from transaction sources, financials, Salesforce about broker/data

Design ODS/Data warehouse using Oracle/IBM Big Insight Hadoop framework

Data analytics using Blue analytic sheets from Neteeza DB storage

Data transformation plan to Hadoop and out of Hadoop to Oracle for further reporting

Environment : Oracle, Neteeza, Sybase, ER Studio, IBM Big Insights, Apache Scoop/Spark, Python, Java/ AWS PostgreSQL,,Pentaho, ERStudio, Watson, Informatica, cognos, Oracle Federal financial

CGI Federal, Herndon, VA (Jun 2012- Nov 2013)

Sr. Data Architect/Enterprise Architect

Involve in Enterprise data warehouse effort in identifying prime source systems

Track enterprise level data Governance and model standards using Erwin repository

Grouping applications for business process, business and service applications including internal/external

Enterprise data security, quality and naming standards, MDM (DRM) and TOGAF

Open payments Health care CMS project as data architect (transaction and Datamart)

Involved in pre-sales proposal solutions as part of CGI sales effort

DW design (Kimball) from sources like financials, HR and custom applications

Environment : Oracle 11g, Micro strategy, DB2, SQL server, Erwin, Unix, Sharepoint, Tableau, SAS,Python, Jenkins AWS,Mongo DB, Cognos,Informatica.FHIR,

Mori Associates for (Department of Transportation, Federal, Washington DC ) (Feb-11 - Apr 2012)

Lead/Data Architect

Establish data design standards and star schema reporting designs

Establish data flow and data quality standards

Develop complete ETL design and controls to load target tables

Design logical, physical of Oracle 11g database with metadata information

Lead Oracle BI report development and user training

Maintain all the project contract, software development, security documentation and follow the

guidelines (NIST, FEAF)

Maintain the source and data objects standards and version controls

Environment : Oracle 11g RAC, ODI, OBIEE, ArcGis, Web Services and SOA suite, Hadoop, Erwin, Unix, Sharepoint, Bigdata (Cloudera, Data Mining, Oracle SOA service), Python, AWS

Surecom, Inc (2002 – 2011) - Clients Projects

Blue Cross Blue Shield, Washington DC From 04/10-01/11

Lead/ Enterprise Data Architect

Design fact and Dimension tables (star schema)based on the source Claims and Enrollment data

Conversion/migration from COBOL flat file to DB2 Target table for reporting collection

Design logical, physical of DB2 Report database with metadata information.

Create data mapping, ETL specs for loading from flat file into DB2 target tables

Analyze new report requirements and review the target tables design based on HIPAA compliant

ICD-9, ICD-10 standards compliant report analysis

Consolidation of payer/provider data into new target analytical model

Environment : Oracle 11g, DB2, COBOL, Mainframe, DB Studio, Rocket shuttle, Informatica, Erwin, Unix, Sharepoint, Cognos, Informatica

US Marine Corps, Quantico VA From 04/08 – 03/10

Lead/ Data Architect

Develop project scope, data migration plans for Retail and Finance Datamart

Design fact and Dimension tables (star schema) based on the source Retail and Finance data

Review logical/physical model, table re-org/design, sql-execution plan, indexes, database memory parameters, disk cache sizes, disk storage area size, through put rate while executing reports as performance improvement applying DoDAF framework

Create data mapping for Retail and Finance Datamart using OWB

Define Data Architecture and EIA standard and data definitions in DODAF standard

Define and capture the change process in ETL mapping for documentation

Environment : Retail/POS, Oracle10g, OWB 10.2 RAC, ERWIN, Unix, Clear case Tools, Sharepoint, Cognos

Sprint Nextel, Reston VA From 12/06 – 03/08

Lead/Data Integration Architect

Building various API interfaces using web services for various business groups and as well as for external vendors common usage to facilitate data interchanges in common XML/XSLT format.

Develop data mapping for interface requirements with standard Canonical data model

Maintain/update logical/physical Data model according to naming standards and grouping by functions

Involved in MDM, Data governance, data quality process in TOGAF

Create Semantic models in XSD schemas, WSDLs and validate using XML Spy

Environment Oracle10g,, ERStudio,XML Spy, Contivo, SQL server 2005, Unix, MS Project, Clear case tools, Microstrategy, Informatica, Cognos, Peoplesoft HR, Oracle 10g

Freddie Mac, Mclean, VA From 03/05 – 10/06

Project Lead – Data Architect

Maintain repository for data models (Erwin) and data dictionary for seller projects

Responsible for change/maintain logical/physical models and generate ddls to implement the change in database (DB2 8.1,Sybase 12.5, Oracle)

Follow data abbreviation standards using metadata repository rules in logical and physical modeling for project using web services and XML schema for interfaces

Discuss business requirements and guide the team in data redundancy, storage, performance while changing the data models

Environment : Mainframe, Cobol, Sybase, DB2, oracle, Erwin, Unix, MS Project, Clear case tools, Visio, Lotus notes, Web services, DB Artisan, Micro strategy, Datastage, Clearcase, Clearquest, Cognos

Merck Inc, Westpoint, PA From 01/04 – 12/04

Project Lead/Sr Data warehouse Consultant

PFIZER, New Jersey (SAP migration) From 01/03 to 11/03

Lead/Data Warehouse Consultant (clinical data)

(Experience in Singapore & India)

Senior IT Consultant (From 2002 – 2003 )

(Projects in Accounting, Retail, supply chain,Banking, Manufacturing)

Personal Details

Ramanan Balakrishna

US Citizen, Fairfax, VA 22031

703-***-**** (Mobil)

********@*******.***

https://www.linkedin.com/in/rambala96/

Qualifications

Masters Degree (Economics & Statistics) Madurai Kamaraj University, India

Bachelor of Arts (Economics & Statistics) Madras University, India

Systems Analysis & programming Indian Inst. of Science, Bangalore

Holding PMP certification since 2003

Training in Hadoop Cloudera, Hbase, PIG, R/Gephi MapR Kafka/spark (May/2013)

Training in Databricks architecture, Google Analytics

Contact this candidate