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 using Bigdata/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

OLAP Tools (6 years)

Business Objects, Oracle Express/Discoverer,

SQL Server 2000/2005 DTS/ Analyze services, Tableau,

COGNOS Enterprise server, Power Play, Visualizer

Scheduler etc, Microstrategy, Pentaho analytics, Power BI,

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, Canonical and logical modeling.

Graph database design and models, DataLake architecture and strategy

Mainframe migration strategy to Cloud.

Programming

Mainframe Cobol, Python

Worked in data migration from Mainframe in many of these projects. Worked in IBM1401m VAX cobol, MS Cobol in many projects.

Professional Experience

Self Employment (1099/W2) (Jan 2020 – Current)

Data Architect (IRS- Kforce/Booze Allen) From Jun 2023-

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

Data flow diagrams updates in ECM feature/tasks

Data Architect ( contract Fedex)

Source system analysis for Datawarehouse migration to Oracle cloud

MDM and canonical centralized model repository for middleware data exchange

Reporting systems design from data warehouse to feed reporting tools

Main frame data Analysis and conversion model to Oracle/cloud

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

Mainframe migration strategy to AWS cloud.

Promote data quality, governance, standardization rules in the enterprise systems

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

Architecture strategy, logical modeling for migration to AWS data lake and Data warehouse

Environment : SQL server,,Mainframe z/os, Oracle 19, Erwin, Visio, Micro Strategy,

Data Solutions Architect (Defense Health Agency)

Bechtel, Reston VA (Feb 2018 -Dec 2019)

CSRA, Falls Church VA (Jan 2016 -2017)

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

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

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

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

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

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

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, 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 (Mainframe) From 06/03 – 12/03

Project Lead/Sr Data warehouse Consultant

PFIZER, New Jersey (As/400/Mainframe) 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-***-**** (Home)

703-***-**** (Cell)

ad39nx@r.postjobfree.com

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 & Cobol programming Indian Inst. of Science, Bangalore

-0-

Contact this candidate