SUMMARY:

• Confidential is a Data Architect having more than Twelve Years of experience, including extensive working experience as onshore delivery leader in various projects in US and UK for last eight years.
• He has vast experience in data management domains like Relational a nd Dimensional Data Modeling, Data Architecture Definition, Data Analysis, Data Analytics, Confidential Technology, Data Science, Data Transformation, Data Migration, Big Data Architecture .
• He has extensive experience in Industry Standard Data Models, such as Teradata FSLDM, IBM IIW. He is well versed with various data modeling practices using market - leading Data Modeling tools, such as CA Erwin.
• He is currently working as part of the Analytics and Information Management - Data on Demand (AIM- DoD ) in Confidential Technology Solutions, which provides consultancy services in data architecture definition and strategy, creates data models for both green field as well as migration projects.
• 12 years of concentrated Data Architecture and Data Modeling experience in OLTP and Dimensional data modeling
• Excellent knowledge i n CA Erwin Data Modeler and Model Manager
• Ability to work with IT stake holders and business owners to understand business and IT priorities thereby build an efficient data architecture plan and subsequently execute it
• Ability to adopt and build data architecture standards, principles and processes
• Ability to provide thought leadership for architectural and implementation initiatives
• Demonstrated sense of logic, decision making and problem resolution skills with excellent communication, written, analytical and facilitation skills
• Good time management skills and an ability to meet stringent deadlines
• Trained and certified in Big Data (Hadoop Architecture, Hive, No SQL, PIG), Data Analytics and Data Science, Python, R, Machine Learning by IBM Big Data University
• Trained in Confidential Data Modeling, SPARQL, Resource Description Framework (RDF), Ontology Model

TECHNICAL SKILLS:

Data M odeling Tools: CA Erwin 9.2, 8.2, 7.3, 7.2 and 4.1.4, CA Erwin Application Programming Interface (API) using Excel Visual Basic Application (VBA)

Hardware Platforms: Sun Solaris Sparc, Windows Compatible Hardware platform

Database Programming Languages: Oracle SQL, PL/SQL

Database: Oracle RDBMS 11g, 10g and 9i, SQL Server 2008, 2012, Teradata 14

Domain Skills: Property & Casualty Insurance, US Retirement Services, Information and Media, Credit Decisions, High End Technology

CURRENT PROJECT EXPERIENCE:

Confidential, Windsor, Connecticut

Data Architect

Responsibilities:

• Takes part in reviewing and understanding Business Requirement Documents (BRD), Functional Requirement Documents (FRD) and Technical Requirement Documents (TRD)
• Built design of Logical and Physical Data Models for ODS; which are customized from IBM Insurance Information Warehouse (IIW)
• Built design of staging data model and did mapping from ODS to staging
• Provide guidance to developer and testers on data extraction mechanism and mapping from LDM/PDM to staging and downstream data warehouses
• Led a team comprising of offshore and onshore members to manage Confidential ’s mapping and metadata using a new tool named Analytix Mapping Manager (AMM)
• Defined metadata and mapping management strategy for Confidential
• Worked closely with the AMM team to test the tool and suggest enhancements

Confidential, Enfield, Connecticut

Data Architect

Responsibilities:

• Takes part in reviewing and understanding Business Requirement Documents (BRD), Functional Requirement Documents (FRD) and Technical Requirement Documents (TRD)
• Review design of Logical and Physical Data Models; which are customized from Teradata FSLDM
• Provide guidance to developer and testers on data extraction mechanism and mapping from LDM/PDM to downstream extracts and reports
• Manage onshore and offshore team deliveries
• Work closely with Confidential DA Resource Manager (RM) to handle resource capacity and placement
• Create and establish DA best practices as per Confidential requirements
• Perform DA effort estimation and project planning

Confidential

Lead Data Architect

Responsibilities:

• Takes part in reviewing Business Requirement Documents (BRD), Functional Requirement Documents (FRD) and Technical Requirement Documents (TRD)
• Discusses business requirements with the Subject Matter Expert ( SME) and guides offshore team members to design data migration architecture framework
• Works with customer business owner to validate business requirements
• Works with offshore Project Manager to create and update project plan, status report, test planning
• Guides offshore team members to get business requirement clarified, code review and unit testing
• Designs intermediate staging Logical/Physical data model for holding in-scope migrated data
• Takes part in Non Functional Requirement (NFR) discussions and provides necessary solutions to meet NFR
• Assists business owner to successfully conduct User Acceptance Test (UAT)

Confidential, Parsippany, New Jersey

Lead Data Architect

Responsibilities:

• Takes part in reviewing Business Requirement Documents (BRD), Functional Requirement Documents (FRD) and Technical Requirement Documents (TRD) and acts as approver of all or some of these documents on behalf of Data Architecture (DA)
• Discussed business requirements with the Subject Matter Expert ( SME) and guides offshore team members to design Conceptual and the Logical Data Models and validates them with the business
• Coordinates and guides creation of Physical Data Model (PDM) and works closely with the application development team to implement required performance enhancement features (such as adding indexes, splitting tables) in PDM
• Designs Fact tables, Dimension tables (including defining strategy for the slowly changing dimensions) in line with the enterprise’s conformed Dimension design
• Defines Bus Matrix for the specific project requirements
• Defines tables required for reporting, aggregation that caters to the need for slicing and dicing of summary data
• Participates actively in the Computer Associate (CA) Erwin community forums and works closely with CA Technologies engineers to resolve Erwin bugs
• Develops extended capabilities of CA ERwin using knowledge of its underlying database structure and the ERwin API (based on Visual Basic for Applications (VBA)) to provide functionality beyond that available in the ERwin tool
• Got i nvolved with D&B data architecture team and data governance team to plan future D&B data management strategy, which includes evaluating and deciding on products for data lineage and data mapping (IBM Infosphere Suite of products), schema maintenance (igniteXML), data modeling, data lineage (IBM Infosphere Suite of products)
• Worked as the O nshore L ead for the Erwin r7 to r8 upgrade project which involved upgrading 175 data models
• Works as the ERwin Model Manager administrator for the r8 Model Mart, performing activities such as uploading downloading data models, maintain version numbers using the Model Mart versioning mechanism, marking the uploaded data models as per requirement, setting the profile and mapping the users to profiles, querying the underlying Model Mart database to fetch reports
• Creates Business Definition Layout (BDL) to document the layout and data dictionary of all Input Sources which needs to be eventually loaded into the D&B databases
• Creates D&B standard XML schema, to move data between the D&B services and the data stores, using D&B proprietary tool Master Data Management (MDM) and external tool Altova XMLSpy

Confidential

Technology and Tools: Erwin 4.1.4, Oracle 10g, 9i database, Unix Shell Scripting

Data modeler and Leader

Responsibilities:

• Understood business requirement from onshore counterpart, developed Logical Data Model (LDM), Physical Data Model (PDM) DDL scripts using Erwin
• Wrote /modified PL/SQL packages, stored procedures and t une the SQL, PL/SQL codes for better performance after studying the query plan