Sr. Data Architect Resume Worcester, MA - Hire IT People

SUMMARY:

18 years of experience in Data Warehouse/Business Intelligence
Experienced in Data modelling, Database design, normalization techniques using Database diagrams, Erwin, and other Data modeling tools
Experience on Migrating SQL database to Azure data Lake, Azure data lake Analytics, Azure SQL Database, Data Bricks and Azure SQL Data warehouse.
Migrating On premise databases to Azure Data lake store using Azure Data factory.
Experience in Developing Spark applications using Spark - SQL in Databricks for data extraction, transformation, and aggregation.
Experience in Database Design and development with Business Intelligence using SQL Server 2014/2016, Integration Services (SSIS), DTS Packages, SQL Server Analysis Services (SSAS), DAX, OLAP Cubes, Star Schema and Snowflake Schema.
Domain Knowledge of Insurance, Finance, Telecommunication and Health Care.
Strong skills in visualization tools Power BI, Confidential Excel - formulas, Pivot Tables, Charts and DAX Commands.
Expertise in various phases of project life cycles (Design, Analysis, Implementation and testing).
IBM Certified Cognos 8 BI Solution Architect
Microsoft Certified Technology Specialist.

SKILL:

ETL Tools: AbInitio 1.13, Infomatica 8.6, SSIS, Data Stage, BODI

Reporting Tools: Cognos BI 10.1, Business Objects XI, Tableau, SSRS

Data Modeling Tools: ER Win, Visio

Database: Oracle 11g, Teradata V14, SQL Server, Netezza, SAP

Language: SQL, PL/SQL, C, JAVA, Python

Teradata Utilities: BTEQ, Fastload, MultiLoad, TPump, Teradata Manager, ASF-2

AWS: Python, Lambda, S3, SQS, Redshift, Glue, Jenkins

System: UNIX, AIX, Windows, Cloud

ENGAGEMENT OVERVIEW:

Sr. Data Architect

Confidential, Worcester, MA

Responsibilities:

Data Modeling, Conceptual, Logical and Physical modeling for Workers Compensation, Subscription, Claim and Re-Insurance subject areas.
Design and implement end-to-end data solutions (storage, integration, processing, visualization) in Azure for migration of On-Perm data to Cloud
Design and implement database solutions in Azure SQL Data Warehouse, Azure SQL
Architect & implement BI solutions on Azure using Azure Data Platform services.
Data Mapping, Data Governance, Security, encryption, and best practices for cloud environments
Develop Data Pipelines, Data Governance, integrating data across the enterprise
Develop dashboards and visualizations to help business users analyze data as well as providing data insight to upper management using Power BI.

Environment : Oracle 11g, SQL Server 2016, Azure, Power BI, ErWin

Confidential

Sr. Data Architect

Responsibilities:

Requirements analysis, Develop Technical Specifications. Design of datawarehouse architecture
Data Modeling, Conceptual, Logical and Physical modeling using Erwin.
Source to Target data mapping, ETL data flow diagrams. Developed mappings using various power center transformations like Source Qualifier, Aggregator, Filter, look up, sequence generator, etc.
Develop Cognos Framework Manager Models, Dynamic Cubes. Setup up data security based on Sales Office Hierarchy
Developed reports in Cognos Report Studio with Drill Up/Down, Drill thru features.

Environment : Oracle 11g, Informatica, Cognos BI 10.2.2, ErWin

Confidential

Sr. Data Architect

Responsibilities:

Requirements gathering, Data Analysis, Technical specifications, Transformation Rules
Data Modeling (Logical and Plysical). Data Profiling, Data mapping to data warehouse data elements.
Database development, develop stored procedures, packages and triggers. Query Optimization. Database performance tuning.
Development of Cognos Framework Manager Models, OLAP Cubes. Setup up security based on Sales Office Hierarchy. Design the folders and query items for Adhoc reporting.
Development of reports in Cognos Report Studio reports. Upgradation from Cognos 8.4.1 to 10.1.

Environment : Oracle 11g, Informatica 9.1, SSIS, SQL Server 2008, Teradata, Cognos BI 8.4.1/10.1, Erwin