SUMMARY

• More than 20 years of experience in Data Architecture, Data Modeling, Data Management
• Enterprise Data Architecture/Modeling, Conceptual Data Modeling, Logical Data Modeling, Physical Data Modeling
• Entity Relational Model, Dimensional Model, Object Model, Object Relational Model, Canonical Model, Semantic Model
• OLTP, OLAP, EDW, DW, DM, MDM, ODS
• Data Integration, Data Migration, Data Profiling, Data Analysis, Data Governance, Data Lineage, Data Quality, Meta Data Management
• Oracle, SQL Server, DB2, Sybase, Teradata, Netezza, Kognitio, UDB, LDAP
• End to end solution in data architecture, implementation of reference architecture and reference data modeling, System Analysis, Business Analysis, Solution Architecture, Data Management for present and future Enterprise Data Landscape
• Working experience with State of Florida, State of California, Boston Scientific, ADT, Confidential, Confidential, Experian and others
• Business domain experience in CMDB, Remedy/ITSM, Asset Management, Financial Risk Analysis, Investment banking, Quantisense BI application, State Welfare System, Benefit Recovery System, Child Support, Pharmaceutical, Infrastructure, Production Engineering, Customer Relationship Management (CRM), Supply Chain Management (SCM),Enterprise Resource Plan (ERP), Material Resource Plan (MRP), Order Fulfillment System(OFS), Bill Of Materials (BOM), Customer Relationship Management (CRM), ECOM, Survey, Telecommunication, Retails and others

TECHNICAL SKILLS

PRIMARY TOOLS: Sybase PowerDesigner, CA ERwin, ER Studio / DB Artisan, Teradata SQL Assistant, TOAD, SQL, TSQL, Data Profiler, Metadex, Teradata Mapping Manager, Composite, SSIS, MATLAB, Python, Azure ML

PRIMARY DATABASES: Oracle, Teradata, SQL Server, Netezza, DB2, Sybase, Kognitio

PROFESSIONAL EXPERIENCE

Confidential

Enterprise Data Architect

Responsibilities:

• Introduced first time the SAP PowerDesigner as an Enterprise Architecture tool in the CTO Architecture & Engineering in the year 2014. Provided all technology leadership including capability demonstration, training and mentorship. Now the PowerDesigner Repository Server is the single most metadata repository within CTO comprising of CMBD/Remedy, MDH, Maximo/ITSM, Runbook, Nlyte, RDR, PRDB, Ariba, AIF, BART, DNT, DOMIRA, … all active and important SOOs, SORs and ADSs in the Technical Infrastructure (TI) domain.
• Pioneering in Cisco Composite as a Data Virtualization tool and now it is used in the production supporting eSMART/BI team for data federation. Provided POC, training, standards, and reference architecture to demonstrate how data virtualization is useful for data management.
• Enterprise Data Management (EDM) automation for KBE (Key Business Elements) tracking and auditing, Data Governance, DQ (Data Quality) metrics, LMDR (Local Metadata Reporting) and EDR (Enterprise Data Repository) reporting automation.
• Lineage analysis and tracking for Midrange, Middleware, Mainframe, Storage, Database, and Network key elements using Data Movement Models (DMM).
• Data Modeling for many existing databases/systems (for Remedy, Master Data Hub, etc.) where no data models and data models were existing earlier.
• Solution data architecture for Patch Management delivered in an innovative way and used now as a reference template for data centric projects.
• Data architecture for SACM (Software Asset Configuration Management), IM (Incident Management), PM (Problem Management), CM (Change Management), KM (Knowledge Management), CMS (Configuration Management System), RDM (Release and Deployment Management) and etc.
• Reference data architecture framework for federated data, reference data, master data, canonical data, business semantics data, metadata and virtual data, etc. are documented for data architecture standardization, best practices and guidelines.
• Data modeling standards for conceptual, logical and physical data models.
• Data provisioning, Data analysis, lineage analysis, impact analysis, root cause analysis, data mapping, data profiling, and data dictionary, etc.
• Building a data architecture platform for enterprise data using a shared and collaborative environment, version control to facilitated users for packaging, designing, documenting and publishing the artifacts.

Confidential

Principal / Enterprise Data Architect

Responsibilities:

• Solution Architecture for Enterprise Data Warehouse (EDW), Enterprise Data Architecture
• Strategic Roadmap to build future and present Enterprise Data Landscape
• BI application support using Virtual Data Marts, Semantic data layers, data aggregation
• Master Data Management (MDM) solution, Reference architecture (CIF & Data Bus), Near Real Time EDW
• Enterprise data dictionary, Enterprise naming standards, Guidelines and best approaches, Gap Analysis
• Enterprise Data Modeling, Solution Architecture for Enterprise Foundation layer, Enterprise risk assessment and mitigation, Dimensional layer, Data Virtualization, Canonical Model
• Data Modeling (conceptual, logical and physical) for Supply Chain Management (SCM), Product Information Management (PIM), Campaign & Marketing Management, Customer Information System
• Implementation support for third party BI solution from Quantisense
• High end in memory (64 TB) Kognitio database implementation for BI application
• Implemented Teradata Retail Reference Logical Model (LDM)
• Mentoring/supervising/reviewing junior level Data Architects / Data Modelers
• Secondary Activities: Data Profiling, Lineage Analysis, Data Mapping, Data Governance, Data Analysis, etc.

Environment: CA Erwin, Teradata, Kognitio (in Memory DB), Quantisense (BI Application), SAS, SAP MDM, Teradata SQL Assistant, Teradata Mapping Manager, Data Profiler, Metadex, Virtual Data Marts, AS/400 iSeries System, DB2/400, SQL Server, Oracle, Netezza, Weka (an open source tool for Predictive Analysis on Big Data sets)

Confidential, NJ

Sr. Data Architect

Responsibilities:

• Enterprise Data modeling and database design for transactional, operational and analytical databases (EDW)
• Strategic and tactical data architecture solution, roadmap for the enterprise
• Data governance, data quality, data migration, ETL, data analysis and data modeling review
• Evaluating data modeling tools to recommend a standardized tool across enterprise (Sybase Power Designer vs. CA Erwin vs. IBM Rational Data Architect)
• Data models conversion from ERWIN to POWER DESIGNER
• Meta data management, data artifacts and publishing data dictionary in the intranet
• Data naming convention and data modeling standards for enterprise
• Creating standard templates in wiki pages for data models publication
• Implementing Oracle Materialized View (MV) replication techniques for data marts
• Implementing data virtualization, canonical data model, semantic data model, data integration using Composite / DataBig
• Secondary activities:
• Review database disaster recovery strategy, database growth plan, and data archive
• Review query optimization, database tuning and database server tuning and setup
• Review failover cluster, high availability and scalable approach
• Review data security, access privilege, role and fine level access control
• Development DBA

Environment: Transactional and Analytical Databases, Power Designer, Erwin, Toad, Oracle, Teradata, Informatica, Trillium Data Quality/ Data Governance, Directory/LDAP, Multi - tier architecture, SOA, Web applications, J2EE

Confidential, NY

Data Architect

Responsibilities:

• Designing a new data model for Oracle and analyzing the scope of improvement in the existing database in the Sybase
• Implementing Financial Service Reference Logical Data Models (FSLDM) from Embarcadero
• Sybase to Oracle migration for data and application
• Governing and enforcing corporate wide enterprise architecture
• Metadata Management
• Guiding and helping on replacement of the present ETL process implementing Informatica

Environment: Sybase ASE 12.5, Oracle 10g EE, Oracle Migration Workbench, Informatica, Swis SQL, TOAD, PL/SQL Developer, SQL Developer, Embarcadero DBArtisan, Erwin, SQL, TSQL, SOA, J2EE, BEA WEBLOGIC

Confidential

Data Architect

Responsibilities:

• Concept development for Corporate Data Architecture
• Requirement analysis, Client interaction and model demonstration
• Data modeling (conceptual, logical and physical)
• Metadata Management
• Use Case modeling, Class Diagrams, Sequence Diagrams and Object Relational Model
• Oracle 10G installation and administration on 5 Oracle Servers and 7 Database instances
• DB2 database design and administration support
• Data Migration strategy and Lead
• ETL Development in SQL Server DTS
• SQL Coding, Stored Procedure, Query optimization
• Portal Database replacement from Cloudscape to Oracle for WPS
• Explain data relationships to development team
• Interviewing new resources (DBA) in my responsibilities areas

Environment: Enterprise Architect, Erwin, ORACLE 10G EE, SQL SERVER 2000 EE, DB2 4.1, DB2 UDB, SIEBEL, IMS, INFORMIX, VSAM, J2EE, WEBSPHERE PORTAL, IBM WEBSPHERE, RAD HAT LINUX, WINDOWS ADVANCED SERVER, SOA, J2EE, Web Application

Confidential

Data Architect

Responsibilities:

• Interact with users/access to the requirement documents in the respective financial domains to understand the requirement.
• Logical and Physical OLAP Database Modeling and implementation
• Data migration strategy and planning
• Data analysis
• Review and walkthrough with Clients, Manager and Technical Lead
• Demonstrate, knowledge transfer and handover the assignment

Environment: SQL Server 2000 Enterprise Edition, Oracle 9i, Erwin 4.1,Windows NT, Web application in .net.

Confidential

Data Analyst

Responsibilities:

• Conceptual, Logical and Physical data modeling for OLTP/OLAP Database/ Data Warehouse
• Data migration strategy and planning
• Data analysis
• Data staging database modeling
• Gap analysis, data verification and validation
• Data profiling, mapping and define the scope of data in the context of new system
• Responsible for data migration project’s end result

Environment: SQL Server 2000 Enterprise Edition, Oracle 9i, Unix, Windows NT, Web application, Sparta Trackwise System and Pharmaceutical application.

Confidential, Florida State

Data Architect

Responsibilities:

• Responsible as Tech Lead in Data Migration, Data Architect for designing conceptual, logical and physical data model (ER/Dimensional), and implement of database/Data Warehouse schema, and also tune and optimize as Data Base Administrator in Oracle 9i, SQL Server 2000 EE. Use to participate in the requirement analysis and system design for application development.
• The role involves user interaction, writing specifications, functional analysis, program assignment, holding meetings, assess and resolve technical issues, training, motivating, planning, managing, program testing, implementation, and demonstration etc.
• Being data migration tech lead carried overall responsibility of data migration activities. I have designed high level and low level specification, crosswalk, data mapping and data analysis in DB2 Data Warehouse.
• I pioneer the data purification/cleansing based on data analysis and exception reports generated in the verification process. That involves a significant numbers of state workers to cleanse the source/legacy data based on my analytical reports.
• As a data modeler I have designed the OLTP database for web application, used UML Rose model for prototype, dimensional model for Oracle Data Warehouse for reporting and data staging for migrated data.
• I have used ErWin, UML/Rose model in Rational and Cornos as case tool. Also used Rational Clear Quest to log defects

Confidential

Sr. Analyst

Responsibilities:

• Worked in the requirement analysis, data analysis, general system design, detail design, and data base design.
• As a chief technical consultant in the batch programs, responsibility was to set the standards for testing checklists, to set the standards for QA and coding guidelines. I was the sole designer for data migration from the Mainframe to the client/server.
• Wrote the conversion plan and cross walk for data transfer from the legacy system (Mainframe) to Oracle database. I did the logical and physical data model for data migration staging database in Oracle.
• I have created an online data cleansing application using dimensional model for oracle Data Warehouse. I have designed the strategy to implement ETL mechanism from heterogeneous data sources such as DB2, Sybase, and flat files.

Environment: COBOL, DB2, Oracle 8, SQL Manager, C, Tuxedo, PL/SQL, IBM MF, TSO, ISPF, XPEDITOR, File Aid, Changeman, UNIX, FTP, Merant Net Express, Mainframe Express, Windows NT/2000, Visual Basic, Bpwin, Erwin 4.1 and 3.5, ERRPT, Metavante CSF

Confidential

Sr. Data Architect

Responsibilities:

• Was responsible for requirement analysis, data analysis, system analysis, design, user interaction, Database support and implementation.
• Responsibilities include writing specification, resolve technical issues, SQL approval, checking for SQL functionality, and database access optimization.

Environment: IBM VisualAge for Java, J2EE, EJB, IBM Mainframe OS/390, BM MQ Series, MF-COBOL, VS-COBOL II, XDB, ICS, MF-Workbench, SQL, DB2, Erwin, XDB, Data Warehouse, CICS, JCL, VSAM, MVS, TSO/ISPF, EDI, FTP, XPEDITOR, File Aid, Intertest, Changeman, Panvalet