We provide IT Staff Augmentation Services!

Principal Architect Resume

Philadelphia, PA

SUMMARY:

  • Over 19+ years of strong experience in Business and Data Analysis, Data architecture Data Profiling, Data Migration, Data Conversion, Data Quality, Data Integration, MDM, NoSQL and Metadata Management Services and Configuration Management.
  • Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design.
  • Expert in the Data Analysis, Design, Development, Implementation and Testing using Data Conversions, Extraction, Transformation and Loading (ETL) and SQL Server, ORACLE and other relational and non - relational databases.
  • Strong experience in using Excel and MS Access to dump the data and analyze based on business needs.
  • Experienced in designing star schema (identification of facts, measures and dimensions), Snowflake schema for Data Warehouse, ODS Architecture by using tools like Erwin Data Modeler, Power Designer, E-R Studio and Microsoft Visio.
  • Experienced in Data Modeling retaining concepts of RDBMS, Logical and Physical Data Modeling until 3NormalForm (3NF) and Multidimensional Data Modeling Schema (Star schema, Snow-Flake Modeling, Facts and dimensions).
  • Experienced in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export through the use of multiple ETL tools such as AbInitio and InformaticaPower Center.
  • Good exposure to architecting & solutioning the IT applications for business needs starting from creating logical/functional architecture diagrams, physical architecture diagrams & sequence diagrams.
  • Focus on Organization, Client Relations and Process Improvements.
  • Proficient in Gathering Requirements, Business Case Development to Rollout, Production and Maintenance with a solid understanding of Business Processes and analyzing them and documenting.
  • Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
  • Expertise in documenting the Business Requirements Document (BRD), generating the UAT Test Plans, maintaining the Traceability Matrix and assisting in Post Implementation activities.
  • Expertise in SQL queries, PL/SQL Packages, SQL Plus, Stored Procedures, Functions, Triggers and Performance Analysis, Creating Partitions, Indexes, Aggregating tables when required.
  • Expertise in Physical Modeling for multiple platforms such as Oracle/Teradata/ SQL Server/DB2.
  • Knowledge on Service Oriented Architecture (SOA), Rest web services using XML, JSON, SOAP, XSD and WSDL, XmlBeans.
  • Designed data marts using Ralph Kimball and Bill Inmon dimensional data modeling techniques.
  • Experienced in identifying entities, attributes, metrics, and relationships; also assigning keys and optimizing the model.
  • Experience in RDBMS (Oracle) PL/SQL, SQL, Stored Procedures, Functions, Packages, Triggers.
  • Worked with Terra bytes of Volume databases.
  • Experience in Dimensional Modeling and Data Warehouse. ETL tools Informatica /Data Stage/BI tools such as Business Objects. Star & Snow Flake Schemas.
  • Extensive experience in using ER modeling tools such as ERwin and ER/Sudio.
  • Experience in logical/physical database design and review sessions to determine and describe data flow and data mapping from source to target databases coordinating with End Users, Business Analysts, DBAs and Application Architects.
  • Extensive experience with Normalization (1NF, 2NF, 3NF and BCNF) and Denormalization techniques for improved database performance in OLTP and Data Warehouse/Data Mart environments.
  • Expert in developing transactional enterprise data models that strictly meet normalization rules, as well as Enterprise Data Warehouses using Kimball and Inmon Data Warehouse methodologies.

KEY COMPETENTS:

  • BI & DW: 18 + years of business focused Technology consulting experience.
  • Data Architecture/Modeling/Analysis: 12+ years of experience with requirements gathering, data modeling (Logical/Physical modeling), data architecture, source system analysis, data quality/profiling.
  • Data Integration / ETL: 12+ years of Data Integration experience. DI focus enabling high level architectures at the Data Model& ETL/EAI level.
  • Data Governance: 10+ years of experience in Metadata, Master data & Reference Data Management
  • Big Data: 4+ years of experience in very complex & large scale data architecture & integration
  • Business Intelligence & Analytics: 12+ years of experience in architecture & development Strategy, Consulting, Delivery & Presales experience.
  • Project/Program Management: 8 years of experience in managing complex DW Bi projects.
  • Industry / Domain: Experience across Telecommunications, Insurance (IIW), Manufacturing, Life Sciences and Healthcare, Confidential, Retail, E-Commerce, Airline & Higher Education (University).

TECHNICAL SKILLS:

Data Modelling Tools: Confidential InfoSphere Data Architect ( Confidential IDA) 9.1, Embarcadero ER/Studio Data Architect 9x, CA All Fusion Erwin 9.5 CA Model Mart, Oracle Designer/2000.

ETL Tools: Informatica Power Center/Mart V1-9.X, Confidential IIS Data Stage 9.x, Ab Initio GDE 1.13.11, Confidential 7.5, Confidential InfoSphere, Confidential WebSphere WMQI/MQ Series, Confidential WBIMB, Oracle Warehouse Builder, Data Mirror, Data Junction 7, Oracle PL/SQL, SQL*Loader.

BI/OLAP/Reporting Tools: Confidential Cognos Framework Manager V10, Cognos Query Studio, Cognos Reports Studio, Cognos Analytics Studio, SAP Business Objects, Hyperion Essbase, Oracle OBIEE, Brio Query (Designer/Explorer/Navigator) 6.X, Brio Enterprise Server (BES), Brio On Demand Server (ODS), Brio Broadcast Server (BCS), Executive Information System (EIS), Brio Report, Brio Structured Query Reporting (SQR), Brio Activator (InSQRIBE), Oracle Discoverer Enterprise Reporting Actuate e.Reporting Suite 4.X., SAS 9.2, EG 4.3, DI 4.2, SMC 9.2, SIMS 4.2, EM 6.2, Oracle OBIEE.

Databases: Oracle V6-V12, NCR Teradata, Informix 7.X, Sybase 11.X, Confidential DB2, MS SQL Server2000, MS Access, MS Excel, Flat Files, Hyperion Essbase, SQL Base, Confidential Total, XML, SAP IDO, MySQL, Oracle EBS V11, HIVE, Hadoop HBASE, Confidential Netezza (AWM & DWM), Confidential PDA, Confidential UDMH (Unified Data Model for Healthcare)

Big Data: Hive, HBase, HDFS, Confidential Big Insight, Cloudera Hadoop CDH, Impala, HUE, NOSQL

Data Appliances: Confidential Pure Data Systems (PDA), Confidential Netezza.

Healthcare Database: Confidential UDMH (Unified Data Model for Healthcare), EPIC Clarity Database, Allscripts, Jeffchart, IDX.

Data Mining Tools: Quest SQL Navigator 3.X, Quest Toad 6.X/8.5, Teradata SQL Assistant 6.2.0, Microsoft OLAP Services (MS SQL Server/2000), Oracle Discoverer/2000 (Oracle Browser), Rapid-SQL, Sybase Advantage, Confidential DB2 Command, MS Multi-Dimensional Express (MDX).

Data Profiling/Analysis Tools: Avellino Discovery 3.2.0.

Operating System: UNIX (HP, Sun Solaris, AIX, Dynix), Windows (2000/NT/98/95/3.X), Confidential AS400, OS/390, MS-DOS.

Languages/GUI: Oracle PL/SQL, SQL, T-SQL, Brio Structure Query Language (SQR), JavaScript, Cobol, Fortran, Oracle Developer/2000, Visual Basic 5.X, Power Builder 5.X, Gupta (Centura) SQL Windows.

Middleware: DBC Drivers, Confidential DB2 Connect, Confidential Client Access Express (CAE), Informatica Power Connect, CA Unicenter, Callidus TRUECOMP Variable Compensation System, Confidential WMQI/MQ Series Message Flows/Queues, Maestro Scheduling Tool., Confidential TIVOLI TWS Job Scheduler, Visio, MS PowerPoint.

ERP: Oracle EBS 11, SAP R/3, J.D. Edwards, and Oracle Financial.

Engineering / Functional: Project Planning (IT & Non-IT), Industrial Engineering, Operations Research, Project Engineering & Management, Product Design, Production, Production-Planning, Material Requisition Planning (MRP), Purchase, Quality Control, Documentation.

Methodology: Waterfall, Scum, Iterative, Summit, PMI, PRINCE2. Ralph Kimball (DW) and Bill Inmon methodology ( Corporate Information Factory). Informatica Velocity.

Business Domain: Banking & Financial Services, Insurance, Telecom, Manufacturing, Retail, Healthcare (Provider), Life Sciences (Pharma), e-business, Airlines.

PROFESSIONAL EXPERIENCE:

Confidential, Philadelphia, PA

Principal Architect

Responsibilities:

  • Data Architecture & Data Model design, implementation & review for a leading US healthcare provider’s Big Data & EDW Implementation project including clinical & operational data.
  • Data Integration (Scoop & Confidential IIS Data stage) into Confidential Big Insight (HIVE & HBASE) & Confidential UDMH on Confidential PDA (Netezza) platform.
  • Build Conceptual (CDM), Logical (LDM) & Physical (PDM) data models on Hadoop HBASE, Confidential Netezza’s AWM & DWM data models.
  • Requirement Analysis & Transformation into Use Cases (KPI).
  • Data Governance, Data Profiling & Source System Analysis.

Tools: Confidential Pure Data Systems (PDA)/Netezza, Confidential UDMH, Confidential BigInsights, Hadoop HBASE, HIVE, Scoop, NOSQL, Confidential IIS Data stage, Confidential IDA, Oracle, DB2/Oracle

Confidential, Normal, IL

Sr. Data Architect

Responsibilities:

  • Data Architecture & Data Model design for ISU’s Higher Education Data Warehouse (HEDW) & Admissions, Financial Aid, Student Records, Student Accounts Data Marts.
  • Data Integration (ETL) with enabled high level architectures at the Data Model and ETL level.
  • Requirement Gathering, Analysis & Transform requirements into KPI/Metrics.
  • Data Governance, Profiling & Source System Analysis.
  • Build Conceptual (CDM), Logical (LDM) & Physical (PDM) data models.
  • Quality Assurance, Reviews and Validations of deliverable(s).
  • Strong Relational & Dimensional Modeling concepts and demonstrated experience.

Tools: HEDW, Mainframe, ER/studio Data Architect, Informatica, Cloudera Hadoop CDH, Impala, HUE, DB2/Oracle, NOSQL

Confidential, Chicago, IL

Sr. Data Architect

Responsibilities:

  • Data Integration with enabled high level architectures at the Data Model and ETL (SAP Data Services / BODS) level.
  • Requirement Gathering, Integrate & Transform requirements into System & Design Requirements.
  • Data Analysis, & Data Profiling of various Media system databases & files.
  • Lead Data Modeling (Conceptual, Logical & Physical) of the data staging and data mart schema.
  • Quality Assurance, Reviews and Validations of deliverable(s).
  • Strong Relational & Dimensional Modeling concepts and demonstrated experience.

Tools: SAP BW, SAP Data Services (Business Object Data Services - BODS), ER/studio Data Architect, Business Objects, SAP ECC, Oracle 11i, Flat Files.

Confidential, Portland, OR

Sr. Data Architect

Responsibilities:

  • Build Transplant Data Mart for Clinical Informatics & Clinical Transplant departments.
  • Requirement Gathering, Integrate & Transform requirements into Data Models.
  • Data Analysis, & Data Profiling of various Healthcare source systems databases & files.
  • Lead Data Modeling (Conceptual, Logical & Physical) of the data staging and data mart schema.
  • Metadata Modeling using Cognos Framework Manager.
  • Data Integration with enabled high level architectures at the Data Model and ETL level.
  • Quality Assurance, Reviews and Validations of deliverable(s).
  • Strong Relational & Dimensional Modeling concepts and demonstrated experience.

Tools: ER/studio Data Architect, Confidential Cognos Framework Manager V10, Cognos Report Studio, Cognos Query Studio, Cognos Analytics Studio, Confidential InfoSphere Data stage, Oracle 11i, Flat Files, EPIC Clarity Healthcare.

Confidential, Chicago, IL

Sr. Managing Consultant & Data Architect

Responsibilities:

  • Build Business Analytics & Data Model capabilities for Telecom, Confidential & Insurance Customers.
  • Data Integration with enabled high level architectures at the Data Model and ETL level.
  • Lead Data Modeling team & process (Logical & Physical) at Confidential Insurance Information Warehouse (IIW).
  • Requirement Gathering, Data Analysis, Data/ETL Architecture, Design, Development, Testing & Support of Data Extracts, Marts, DW & EDW components.
  • Lead & Contributed to Data Quality & Profiling initiatives.

Tools: Informatica, Data stage, AllFusion Erwin 9.x, ER/studio Data Architect, Oracle, Confidential DB2, Confidential Cognos, SAS, Oracle OBIEE, Oracle EBS, MySQL.

Confidential, Detroit, MI

Director & Sr. Technology Architect

Responsibilities:

  • Design & Deploy BIDW Solutions & Delivery for Healthcare & Life Sciences customers (BCBS).
  • Data Integration with enabled high level architectures at the Data Model and ETL level.
  • Lead & Data Governance & Data Modeling team & process (Logical & Physical)
  • Requirement Gathering, Data Analysis, Data/ETL Architecture, Design, Development, Testing & Support of Data Extracts, Marts, DW & EDW components.
  • Thought Leadership & Presales Support for new pursuits & opportunities.

Tools: ER/studio Data Architect, Informatica, AllFusion Erwin, Oracle, Hyperion, SPSS

Confidential, San Francisco, CA

Group Manager & Data Architect

Responsibilities:

  • Evangelize best practices for Data Governance & Data Architecture for leading Confidential & Pharma customers (Pfizer, GSK, and Citibank).
  • Lead ETL CoE Roadmap Assessment, Approach & Build for leading Confidential &Pharma customers.
  • Lead Conversion / Migration project - ETL Tool Migration from Confidential to Informatica.
  • Data Integration with enabled high level architectures at the Data Model and ETL level.
  • Lead Data Modeling team & process (Logical & Physical)
  • Requirement Gathering, Data Analysis, Data/ETL Architecture, Design, Development, Testing & Support of Data Extracts, Marts, DW & EDW components.
  • Lead & Contributed to Data Quality & Profiling initiatives.
  • Contribute & Lead Customer Data Integration (CDI) Gap Assessment for leading Biotech.

Tools: Informatica, Confidential Data stage, ER/studio Data Architect, AllFusion Erwin, Oracle, MS SQL Server, Teradata, Business Objects, Avellino Discovery, MySQL.

Confidential, Dallas, TX

Sr. Manager & Practice Evangelist

Responsibilities:

  • Lead Data Governance, Roadmap Assessment & Build (in ETL & BI Reporting) for leading Pharma majors (Pfizer, Novartis, and Organon).
  • Data Integration with enabled high level architectures at the Data Model and ETL level.
  • Requirement Gathering, Data Analysis, Data/ETL Architecture, Design, Development, Testing & Support of Data Extracts, Marts, DW & EDW components.
  • Lead & Contributed to Data Quality & Profiling initiatives

Tools: Informatica, Confidential Data stage, AllFusion Erwin, Oracle, MS SQL Server, Teradata, Business Objects.

Confidential, Dallas, TX

Data Modeler

Responsibilities:

  • Build Data Integration capabilities for leading Airline company
  • Data Integration enabling high level architectures at the Data Model and ETL level.
  • Lead Data Modeling team & process (Logical & Physical)
  • Requirement Gathering, Data Analysis, Data/ETL Architecture, Design, Development, Testing & Support of Data Extracts, Marts, and DW & EDW components.
  • Lead & Contributed to Data Quality & Profiling initiatives.
  • Build Data Integration processes

Tools: Ab Initio ETL, UNIX Shell Scripts, Teradata, Cognos, Avellino Discovery.

Confidential, St. Louis, MO

Data Modeler

Responsibilities:

  • Build Data Governance & Data Integration capability for world’s top Brewery.
  • Data Integration for multiple subject area integration (SAI) enabling high level architectures at the Data Model & ETL/EAI level. (Deployed 15 SAI in 3 years)
  • Lead Data Modeling team & process (Logical & Physical)
  • Build & Published Data Models at fastest pace.
  • Received customer accolades & appreciations for best efforts as Data Architect (2 times).
  • Requirement Gathering, Data Analysis, Data/ETL Architecture, Design, Development, Testing & Support of Data Extracts, Marts, DW & EDW components.
  • Lead & Contributed to Data Quality & Profiling initiatives.
  • Build Data Integration processes (Extracts) using ETL (Data stage) & EAI (WMQI/MQ Series).

Tools: Confidential Data stage ETL, Confidential InfoSphere, Confidential WebSphere MQ Series, WBIMB/WMQI EAI, Oracle, MS SQL Server, Confidential DB2, Confidential, TOTAL, Business Objects.

Hire Now