We provide IT Staff Augmentation Services!

Data Architect Resume

4.00/5 (Submit Your Rating)

NJ

SUMMARY

  • Over 10 years of extensive and diversified experience in the IT industry specialization and expertise in Data Warehousing and Business Intelligence area.
  • Performed overall project management, analysis, architecture, design, development and implementation of data warehousing / business intelligence initiatives
  • Accomplished Data Warehouse Architect, Data Modeler and Designer
  • Managed the evaluation of ETL and OLAP tools and recommended the most suitable solutions depending on business needs
  • Microsoft certified professional in SQL Server and Windows applications C#.
  • IBM certified Cognos 10 Administrator, IBM Certified Developer - Cognos 8.2/8.4/10.1 BI Metadata Models and IBM Certified Designer - Cognos 10 BI Reports
  • Strong domain Knowledge in Insurance, ERP and supply chain management.
  • Proficiency in Cognos 8.2 & 8.4, Microsoft SSIS and SQL Server 2012, 2008 and below, Crystal Reports 9.0.
  • A leader who offers in-depth experience in project management, information technology applications, process modeling, and data modeling.
  • Designed and developed the architecture of business intelligence components including data models, ETL, and enterprise reporting.
  • Expertise in Analysis of Databases, Data Warehouses and Data Marts for BI applications/solutions including design and development of data models, ETL, and enterprise reporting
  • Expertise in developing and managing TM1 and SSAS Cubes
  • Good problem solving abilities and organizational skills.

PROFESSIONAL EXPERIENCE

Confidential, NJ

Data Architect

Responsibilities:

  • Principal Data Architect for Income and Asset Projections
  • Conducted successful proof-of-concept tests for new architectural ideas.
  • Designed database, data models, ETL processes, data warehouse applications and business intelligence (BI) reports
  • Designed Conceptual, logical, and physical data modeling for relational and OLAP model for various projects.
  • Analyzed, Proposed and developed the concept of converting the reports to SSRS sourced from the SSAS cubes
  • Proposed BI solution for the international projections reporting
  • Design and development using SSIS and SSAS cubes for reporting using SQL Server database.
  • Database development including stored procedures, functions and migration to SQL Server 2012
  • T-SQL Performance Tuning, Query Optimization, using SQL Profiler and other related monitoring including query execution plan and optimization the indexes.
  • Performance tuning using SSIS 2012 features like cache and project deployment models in the catalog.

Confidential, Hartford, CT

DWBI Architect

Responsibilities:

  • Data warehouse Architect for financial Applications including of design, data models, ETL processes, data warehouse applications and business intelligence reports and cubes
  • Analyze business needs and propose recommendations on the future of developments
  • Design, develop and test Cognos 8.4 and Cognos 10.1 reports, Framework manager models for new applications and versions as per business need.
  • Play a key role in migrating the project’s existing production reports and models from Cognos 8.4 to Cognos 10.1.
  • Create and schedule reports, jobs, events, dashboards based on business requirements and refresh the applications to ensure that the service level objectives are met.
  • Create and manage the TM1 cubes and validate the refresh data.
  • Setting alerts to aid business key performance indicators and work with clients for issues and upgrades.
  • Handle ad hoc requests in identifying and analyzing application issues, train and provide proper knowledge transfer to offshore team and new joiners.
  • Quality assurance coordinator and implement software quality assurance tools such as Cognizant’s C2.0 to review project activities, audit planning and reporting activities for the project. Maintain and track the quality compliance of the project and tracking project audits with the delivery assurance group

Confidential

DW&BI Developer

Responsibilities:

  • Consulted with Business Unit Management and SME’s to Identify and document Business needs and Objectives.
  • Dimensional data modeling using star and snowflake schema in data warehouse/ data mart environment
  • Design and development in Cognos 8.4 reports
  • TM1 cubes design and development
  • ETL development in SSIS packages
  • Developed ETL logic in stored procedures
  • Coordinating with client and offshore team
  • Maintaining and tracking the quality compliance of the project and tracking project audits with the delivery assurance group

Confidential

Database Lead

Responsibilities:

  • Internet Configurator Enhancer (ICE):
  • Requirement Gathering from the business customer
  • Preparing Design Document and test cases.
  • Database design, Writing procedures and Coordinating with Data Architecture
  • Testing and defect fixing.

Confidential

Migration Lead

Responsibilities:

  • Analysis for feasibility of migration,
  • Deep dive analysis with the application team to understand baseline application.
  • Estimation for migration, Converting Oracle Procedures, Packages and functions to SQL Server 2005 procedures, functions and also other database objects.
  • Converting the inline queries in the front end code.
  • Testing the ported version and support for QC testing.
  • Requirement analysis, High Level Design of the Modules and preparing Design Document.
  • Data Modeling, writing procedures, packages, functions and triggers.
  • Performance optimization
  • Design, procedure review and testing.
  • Involved in phase 3 UAT

Confidential

Environment Windows 2003 Advanced Server, IIS, SQLServer2000, VB6.0, Web Services, ASP, ERWIN and RVW - Ramco Virtual Works.

Analysis, Design & Development Engineer

Responsibilities:

  • New Customer Registration in Web page
  • Customer Portal component and Sales Office Desktop component
  • All the customers who access Customer Portal should be a registered customer. The new customers who wish to avail the benefits of Customer Portal should register in the company web page. They should provide the required information and select the organization units in which they like to make transactions.
  • The information from the web page is transferred to the Sales office Desktop database. The Sales office person in the company will view the customer details through Sales Office Desktop and will interact with customer to clear all ambiguous issues. Then the sales office person creates the customer and updates the same in the Customer master. The username and password is sent to the customer. The customers can access the Customer Portal by providing the username and password.
  • Having discussion with RGG (Requirement Generation Group) team to understand the functionality of the system.
  • Analyzing the requirement documents given for Web Portal Module.
  • Database design and Coding stored procedures.
  • Preparation of Test Plan and Test cases for the respective components.
  • Doing the Unit and Integration Testing in the Web Portal Module.

Confidential

Analysis, Design & Development Engineer

Responsibilities:

  • Functional fit with the company Business Processes.
  • Degree of Integration between the various Component of the ERP System
  • Flexibility and Scalability
  • Technology -Client/Server Capabilities, Security
  • Analysis & Preparation of the Design
  • Database design, Coding stored procedures.
  • TSQL Programming using procedures, functions and performance tuning of queries and stored procedures
  • Preparation of Test Plan and Test cases

We'd love your feedback!