Senior Data Architect / Enterprise Data Warehouse Expert

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,

ETL Tools (5 years)

Informatica, Cognos, SQL Server DTS Services, Oracle Data warehousing tools Datastage, OWB, ODI, Infosphere, AWS Glue, Azure ADF

Data Modeling/Data warehousing

Process Design (12 years)

Enterprise Data warehouse design/model architecture, Virtual/Self service data analytics, with Rational Rose/UML, ERWIN, ERstudio, Oracle Designer, Visio, MS Office tools, Snowflake, data vault models

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 data dictionary

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 IoT cloud architecture and AI/ML predictions analytic models

AI Analytical models and Vector Databases

Model design for AI analytics tools

Building Applications with vector Databases

Professional Experience

Data Architect USDA/USCIS (Attain X) (From Aug 2024)

Design Enterprise logical model combining process and system

Compare4 data flow models with industry standards between systems

Integrated MDM with downstream systems using canonical data models

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

Identified data redundancies and gaps to improve data quality and integration efficiency

Develop implementation roadmap for mainframe modernization

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

Review tools for AI adoption in analytics, workflows, user training as AI data strategy

Environment: Mainframe, Oracle, SQL server, Db2, ERStudio, Collibra, AWS, Visio, Microsoft tools, Power BI

Data Architect – IRS – 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 data architecture data integration and analytics

Performed data modeling and data mapping for migration from legacy systems

Data flow diagrams updates in ECM feature/tasks

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

Environment: SQL server,,Mainframe. ERStudio, Postgre SQL,Google Analytics,AWS, Power BI, Dbeaver, IBM Infosphere. Databricks, 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 warehouse to feed reporting tool

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

Review various external collection data and model for Enterprise analytics and reporting

Promote data quality, AI governance, standardization 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,,Erwin, Visio, Power BI/Qlik Sense,

Micro Strategy, Snowflake

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,IBM Db2 11.1, Oracle 12, Erwin, NoSql, Visio, Informatica IICS, Tableau, Business Objects, Micro Strategy, Azure Data lake, Power BI

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

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, Databricks, Azure data lake, Data factory, ERStudio,,Cosmos DB, Collibra, Power BI, Informatica, RDF models, PostgreSQL, 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 a Fed client

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, GCP

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/Datawarehouse 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 (Feb 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 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, Pentaho, Mongo DB, Cognos,Informatica

Mori Associates for (Department of Transportation, Federal, Washington DC ) (jan - Dec 2011)

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, Hbase, R Data Mining, Oracle SOA service), Java/J2EE,Python, AWS

Surecom, Inc (2002 – 2011) - Clients Consulting

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 : Oracle10g, OWB 10.2 RAC, ERWIN, Unix, Clear case Tools, Sharepoint, Cognos

Sprint Nextel, Reston VA From 07/07 – 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 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

Sunrise senior Living, Mclean, VA From 12/06 – 06/07

Lead/Sr Business/Data architect

Develop project scope, data migration plans from people soft HR to ADP external systems

Study impact on Data warehouse and staging tables due to migration

Create data mapping for ADP system to Data warehouse using OWB based on SOA

Organize the data dictionary effort covering all IT systems in the organization

Environment : Peoplesoft HR, Oracle10g, ERStudio, SQL server 2005, Unix, MS Project, Clear case tools, Visio, sharepoint, Informatica, Cognos

Freddie Mac, Mclean, VA From 06/04 – 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)

Manage change control and maintain project artifacts in clear case and clear quest tools as per standard SOX compliance

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

Identify/document data aggregation, facts and dimensions for data warehouse module and enhance reporting Options using star schema

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

GE Capital and Consumer finance, CT From 01/04 - 06/04

Project Lead/Data Analyst

Merck Inc, Westpoint, PA From 06/03 – 12/03

Project Lead/Sr Data warehouse Consultant

PFIZER, New Jersey From 01/02 to 03/03

Lead/Data Warehouse Consultant (clinical data)

(Experience in Singapore & India)

Senior IT Consultant (From 1995 – 2001 )

(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

-0-

Contact this candidate