We provide IT Staff Augmentation Services!

Data Architect Resume

NJ

SUMMARY:

  • Main area of experience has been in Solution Design, Data Modeling, Data Integration, Data quality, System Analysis, Business Intelligence with Telecom as core domain. Involved in several projects acting as Solution archiect and System Analyst for the Telecom Business Support System (BSS) & Data Warehouse platforms. My current technological expertise is Data Architect BI support systems.
  • 11 years of total IT experience in the Business Requirements Analysis, Solution Design, Data Architecture, Data Modeling, Data Integration, Data Quality, Implementations of Data warehousing and Database business systems for Telecom, Banking and Technology industries.
  • Around 3 years of experience of solution architecture/Data Modeling.
  • Around 3 Years of experience in BSS systems like BSCS & CRM - Siebel.
  • 8+ years of Data warehousing ETL (Extract, Transform, Load) utilizing Informatica 7 / 8/ 9 Power Center, SQL Server, Oracle, Teradata, SQL, PL/SQL, Unix Shell Scripts, Sun Solaris and Windows, including complete System Life Cycle from Analysis and Design to Implementation.
  • 2+ Years’ experience with OLAP Tool- Business Objects XI R2 (Designer, Web Intelligence).
  • 2 + years’ experience in Big Data Technologies, Hadoop Mapreduce, Hive, Pig,
  • Extensive database experience using Oracle 10g/9i/8i/7.x, SQL Server 12.0, Teradata, Erwin, SQL, PL/SQL, SQL*Plus, Win 3.x/95/98/2000, Win NT 4.0 and Sun Solaris 2.x.
  • Experience with ETL integration efforts of various data sources into a staging area; Installation and Developed common logic using Reusable transformations and mapplets. Developed Strategies for Extraction Transformation Loading (ETL) mechanism;
  • Knowledge on Bigdata technologies HADOOP Map-Reduce, Hive, HBase, Sqoop, Phoenix, R Programming.

TECHNICAL SKILLS:

Telecom Products: BSCS, CRM-Siebel.

ETL Tools: Informatica, Pentaho Kettle

OLAP & Reporting: Business Objects

Data Modeling: Erwin, Visio, SQL data modeler.

RDBMS: Oracle, SQLServer, Teradata

Scripts: Unix, BTeq scripts

Languages: Java, C++, C, UNIX Shell Scripting.

OS: UNIX, Windows 98/2008 R2/NT /XP/7/8, Sun Solaris, Linux.

BI Methodologies: Kimbal, Inmon.

BigData Technolgies: Apache hadoop,Mapreduce, Hive, HBase,Pig,Phoenix, Sqoop,Oozie, Hadoop Cluster Setup.

PROFESSIONAL EXPERIENCE:

Data Architect

Confidential, NJ

Responsibilities:

  • Meet with business stakeholders and other technical team members to gather and analyze application requirements
  • Formulate Principles & Guidelines that forms the core for the Confidential Health/Retail Data Warehouse
  • Discuss with Enterprise Architect’s team to review and finalize the architecture.
  • Analyze the legacy data structure and its data elements and discuss with business and IT stakeholders about their usage and come up with data dictionary.
  • Prepare Logical Data Model using CA Erwin Data Modeler for Underwriting, Customer subject areas
  • Analyze the existing database applications and design Enterprise Conformed Dimension Bus that works for existing database applications.
  • Design Physical Data Model for Teradata using CA Erwin Data Modeler
  • Perform comprehensive data analysis of 8 Source Systems Data present in legacy Confidential warehouse.
  • Creation of mapping documents for Informatica PowerCenter ETL tool for all 8 source systems.
  • Design Data acquisition and Data Integration Strategy for all 8 source systems
  • Coordinate with Design and Developer Teams for smooth design and development efforts.
  • Create Core Data Mart and User Symantic views.
  • Provide first level operational support for development and production database systems.

Environment: Erwin Data modeler, Teradata, Oracle, Team Tracker, SVN.

Solution Architect

Confidential, Bellevue, WA

Responsibilities:

  • Part of building the BI/IDW data warehouse model to support E/// events from BI/IDW Teradata CDM 14.0 data model.
  • Design and implement IAM model for roles & authentication.
  • Role Mining / Role Optimization
  • Role-Based Access Controls (RBAC)
  • Entitlement & Entitlement Aggregation
  • Identity Governance
  • Reviewing the business and functional requirements from TMobile.
  • Involving in the JAD meetings.
  • Select Data and/or Functional Area for analysis
  • Find corresponding references in BSCS Ix 4.0
  • For each functional area review relationships between applications; for example how GL relates to Product, Customer, Billing, Taxes, Payments
  • Identify / List supporting source system tables for each relationship
  • Use table list to build theme specific subject area diagram (Erwin) using bscs all v1
  • Review metadata definitions of source tables under review.
  • Identify related subject areas / tables within the CDM 14
  • Review definitions of subject areas / tables to match context of source tables under review.
  • Use table/column descriptions for source and candidate target tables. Search source / target metadata using keywords for potential mapping.
  • Build Source-To-Target Table level matrix as context to continue mapping. Depending on context of source table, the cardinality of source to target tables will likely be one (1) source to many (N) target CDM tables
  • Initiate a column level mapping. Document questions, issues for each mapping as appropriate; i.e., data type mismatch, domain problems, candidate columns for primary key for target, use of surrogate keys
  • Notate potential candidates for domain reference tables
  • Mark each source column that does not have a corresponding target column for follow-up. Eliminate process / audit related columns that do not provide substance to the target table meaning/interpretation.
  • Adjust mappings as appropriate.
  • Review issues / questions with source subject matter expert

Environment: Erwin, BSCS iX 4.0,Oracle,Teradata, Unix, Visio, Brackets UML, Golden Gate

Sr. Data warehouse Developer

Confidential, Bellevue, WA

Responsibilities:

  • Logical/physical modeling of DB objects in the SQL Server.
  • Developing ETL design, change data capture, created SQL views.
  • Follow the quality standards and guidelines for configuration management, testing, project planning and execution.
  • Carrying out impact analysis for change requests.
  • Establishing and monitoring issue management, change management and quality management processes.
  • Loading data from Flat Files into the Staging area using Informatica PowerCenter into Sql Server.
  • Using the designer designed Mappings, which populated the Data into the
  • Target Star Schema on SqlServer Instance.
  • Worked with pre and post sessions, and extracted data from Transaction System into Staging Area.

Environment: Windows, Informatica PowerCenter 9.1, SQL Server 2012, Octopus, Visual Stuido 2012(VSTF).

Sr. Data warehouse Developer

Confidential, Plano,TX

Responsibilities:

  • Worked with Business Users to identify Key Business Rules and Measures and recommend controls to validate the information.
  • Perform Data Profiling to analyze the data from correctness, completeness, accuracy, integrity, consistency dimensions
  • Coordinate with Business Leaders and Project Managers to assure the solutions are complying with Business Strategies and are according to IT strategic plan.
  • Architect for Data Management Framework for Confidential &T Data Warehouse Quality Data Management.
  • Program, including but not limited to Metadata Management, Incident Management, Change Management, Data Quality Management, Master Data Management.
  • Designed Conceptual, Logical and Physical Data Model using ERWIN Data Modeler
  • Defined processes to capture Data Definitions, Metadata, Process Lineages, Data Sources, and Downstream Applications.
  • Coordinated with Development Teams, Offshore team, Project Manager, Business Users to deliver key project milestones.
  • Worked on Unix and Btech scripts.
  • Defiening and ipleenting data quality metrics on diffirent subject areas like Customers, Orders, Payments, Call detail records, Confidential &T Uverse etc.
  • Used different techonologies like Oracle, Teradata and HIVE to capture the different metrics.

Environment: Teradata, Oracle, Bteq, Unix Scripting,Erwin,HIVE,HDFS

Confidential, SanJose, CA

Production Support in Disaster Recovery

Responsibilities:

  • Co-coordinating offshore team in all deliveries.
  • Generate and review the audit reports.
  • Involving Change Management Process, Release plans and Upgrading plans.
  • Root Cause Analysis of various aborts in Golden Gate,Datamover and Informatica.
  • Client Status Reporting.
  • Impact analysis and deployment support.
  • Dollar U scheduling and monitoring.
  • Unix scripting and Teradata stored procedure implementation.

Environment: Informatica PowerCenter 8.1,Oracle Golden Gate, Data mover, Teradata, Oracle 10g, SQL,Unix Shell Scripting.

Sr. Data warehouse Developer

Confidential, Charlotte

Responsibilities:

  • Interacting with onsite co-ordinator and client in understanding the requirements.
  • Preparing the low level design documents.
  • SQL Scripting usind Netezza and building the model microstrategy
  • Developing informatica mappings/sessions/maplets/workflows.
  • Preparing and executing unit test cases.
  • Fixing defects raised as part of system testing.
  • Deploying the informatica and database objects in different environments like SIT,UAT and PROD.
  • Developing Autosys jobs for process flow control.
  • Developing/Enhancement of stored procedures in oracle, teradata and netteza database.
  • Unix scripting and BTeq scripting.

Environment: Informatica PowerCenter 8.1, Netezza Oracle 9i, Teradata, SQL, TOAD, Autosys, Unix Shell Scripting.

Data warehouse Developer

Confidential

Responsibilities:

  • Requirement Analysis.
  • Impact analysis on Du’s data warehouse system due to change requests.
  • Data integration from various BSS/OSS source systems into enterprise data warehouse system using ETL tool Informatica.
  • Unit testing of ETL code.
  • Guide team members in learning datawarehousing and telecom domain.
  • Good knowledge in data warehouse concepts and SQL.
  • Oracle stored proedures implementations.
  • Unix scripting.
  • Developing informatica mappings / transformations / sessions /workflows.
  • Good knowledge in the below areas of Business Objects XI R2 Designing universes.
  • Resolving loops in universes using concepts like aliasing and contexts.
  • Creating classes and objects(dimensions, measures and detail).
  • Creating objects with LOVs and cascaded LOVs.
  • Developing reports (Desk-I & Web-I) .
  • Knowledge on BSS applications systems like BSCS,SIEBEL-CRM,Prepaid Intelligence Network etc.

Environment: Informatica PowerCenter 7.1, Business Objects, Oracle 10G,Unix Shell Scripting.

Confidential

Order Management Developer

Responsibilities:

  • Requirement Analysis.
  • Impact analysis.
  • Developing the code for BT’s transaction workflow management.
  • Oracle stored procdure enahancements.
  • Unix scripting.
  • Unit testing
  • Testing support.

Environment: Oracle, CSS-Order System

Hire Now