Candidate Information Title Data Architect Warehouse Target Location US-VA-Fairfax Email Available with paid plan Phone Available with paid plan	20,000+ Fresh Resumes Monthly     View Phone Numbers     Receive Resume E-mail Alerts     Post Jobs Free     Link your Free Jobs Page     ... and much more Register on Jobvertise Free
Search 2 million Resumes Keywords: City or Zip:	Related Resumes Data Architect Oracle Dba Germantown, MD Data architect South Riding, VA Sql Server Data Warehouse Falls Church, VA Data Warehouse Business Objects Germantown, MD Data Warehouse Api Management Woodbridge, VA Data Architect Rockville, MD Sql Server Data Warehouse Bethesda, MD

SUMMARY18+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, CubesExperience 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 solutionsSkillsOLAP Tools (6 years)Business Objects, Oracle Express/Discoverer,SQL Server 2000/2005 DTS/ Analyze services, Tableau,COGNOS Enterprise server, Power Play, VisualizerScheduler etc, Microstrategy, Pentaho analytics, Power BI,Knowledge inMicrosoft 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 ADFData Modeling/Data warehousingProcess 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 strategyMainframe migration strategy to Cloud.ProgrammingMainframe Cobol, PythonWorked in data migration from Mainframe in many of these projects. Worked in IBM1401m VAX cobol, MS Cobol in many projects.Professional ExperienceSelf 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 dictionaryData mapping with PEGA Json target files from legacy SQL server data structuresECM case management tool tasks and features data points updateData flow diagrams updates in ECM feature/tasksData Architect ( contract Fedex)Source system analysis for Datawarehouse migration to Oracle cloudMDM and canonical centralized model repository for middleware data exchangeReporting systems design from data warehouse to feed reporting toolsMain frame data Analysis and conversion model to Oracle/cloudData repository design and model in Service now for Enterprise reporting and analyticsMainframe migration strategy to AWS cloud.Promote data quality, governance, standardization rules in the enterprise systemsData migration plan documentation, strategy to Service now from various data sources.Architecture strategy, logical modeling for migration to AWS data lake and Data warehouseEnvironment : 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 ConsultingBlue Cross Blue Shield, Washington DC From 04/10-01/11Lead/ Enterprise Data ArchitectDesign fact and Dimension tables (star schema)based on the source Claims and Enrollment dataConversion/migration from COBOL flat file to DB2 Target table for reporting collectionDesign logical, physical of DB2 Report database with metadata information.Create data mapping, ETL specs for loading from flat file into DB2 target tablesAnalyze new report requirements and review the target tables design based on HIPAA compliantICD-9, ICD-10 standards compliant report analysisEnvironment : Oracle 11g, DB2, COBOL, Mainframe, DB Studio, Rocket shuttle, Informatica, Erwin, Unix, Sharepoint, Cognos, InformaticaUS Marine Corps, Quantico VA From 04/08  03/10Sunrise senior Living, Mclean, VA From 12/06  06/07Freddie Mac, Mclean, VA From 06/04  10/06Project Lead  Data ArchitectMaintain repository for data models (Erwin) and data dictionary for seller projectsResponsible 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 complianceFollow data abbreviation standards using metadata repository rules in logical and physical modeling for project using web services and XML schema for interfacesDiscuss business requirements and guide the team in data redundancy, storage, performance while changing the data modelsIdentify/document data aggregation, facts and dimensions for data warehouse module and enhance reporting Options using star schemaEnvironment : Mainframe, Sybase, DB2, oracle, Erwin, Unix, MS Project, Clear case tools, Visio, Lotus notes, Web services, DB Artisan, Micro strategy, Datastage, Clearcase, Clearquest, CognosGE Capital and Consumer finance, CT From 01/04 - 06/04Project Lead/Data AnalystMerck Inc, Westpoint, PA (Mainframe) From 06/03  12/03Project Lead/Sr Data warehouse ConsultantPFIZER, New Jersey (As/400/Mainframe) From 01/02 to 03/03Lead/Data Warehouse Consultant (clinical data)(Experience in Singapore & India)Senior IT Consultant (From 1995  2001 )(Projects in Accounting, Retail, supply chain,Banking, Manufacturing)Personal DetailsRamanan BalakrishnaUS Citizen, Fairfax, VA 22031PHONE NUMBER AVAILABLE (Home)PHONE NUMBER AVAILABLE (Cell)EMAIL AVAILABLEhttps://LINKEDIN LINK AVAILABLEQualificationsMasters Degree (Economics & Statistics) Madurai Kamaraj University, IndiaBachelor of Arts (Economics & Statistics) Madras University, IndiaSystems Analysis & Cobol programming Indian Inst. of Science, Bangalore-0-