SUMMARY

• Experienced as an information architect on end to end implementations of small, mid - range and large datawarehouse projects covering technical areas of data modeling, ETL, BI, metadata and master data design, architecture and development. Successfully held client/ delivery management roles and served in the capacity of strategic adviser, technical lead and project manager both as a consultant and industry employee.

TECHNICAL SKILLS

ETL Tools: PowerMart, PowerCentre, MS Data Transformation Services, Datastage, SSIS

Data Modeling: ERWin Platinum, ER Studio

OLAP Tools: Cognos (Transformer, Powerplay), MS OLAP, MS Analysis Services

Reporting/Decision Support Tools: Cognos Impromptu, Business Objects, Crystal Reports, SPSS and ProClarity, SSRS, Tableau, PowerBI

Databases: Oracle 8.x, 9.x, 10g, SQL Server 7.0/2000, Netezza, Teradata and NeoView

Languages: XML, SQL, T-SQL, PL/SQL

Data Profiling: Firstlogic IQInsight

CRM: Siebel and Clientle

Office: MS Word, Excel, Access, Powerpoint, Outlook

Project Management: Visio, MS Project

Database tools: TOAD and RapidSQL

Cloud: Azure Data Factory, Azure SQL, Azure Data Warehouse (Snowflake), Azure Data Lake, Azure Analysis Services,Power BI, Azure Storage

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Provide data architecture leadership for enterprise data strategy initiatives in the areas of data modeling, data warehousing, data integration, and data consumption for a Digital Banking Platform in keeping with data governance standards
• Establish and implement tools and processes for data governance, data quality, data catalogs and data consumption
• Continuously collaborate with Data Management Team to identify areas of improvement in team efficiency and effectiveness as well as team technical growth
• Work with the Project Management Office, provide input into each phase of the systems development cycle and review data designs specifications with the rest of the Data Services team.
• Create detailed technical specifications, change, and release documentation to drive data management projects and change delivery
• Translate business requirements and workflows into functional design specifications and data models while working with the Data Governance Board .
• Work with tools such as SSIS, SSRS and SSAS, Azure Data Factory, Azure SQL, Azure Data Warehouse (Snowflake), Azure Data Lake, Azure Analysis Services,Power BI, Azure Storage and ER/Studio.

Confidential

Enterprise Data Architect

Responsibilities:

• Responsible for the design and implementation of end-to-end enterprise data solutions and architectures that support the strategic objectives of clients.
• Provided technology leadership, influence and guidance in architecture, design and standardization of end to end data management applications.
• Worked with vendors, development teams, business clients and other infrastructure groups to resolve critical business and systems issues.
• Provided POC's for data evolution across systems and organizations and help integrate emerging technologies into the current infrastructure landscape.
• Provided guidance to developers in formulating/defining specifications and developing solutions of varying complexity including the modification of existing applications.
• Hands on involvement in requirements gathering, solution designing, SQL code optimization and evaluation for ETL (Informatica and DataStage) jobs for Data and Process optimization within an Oracle Datawarehouse.
• Established Data Governance principles/guidelines for Enterprise Information Architecture including data management design, security, system platform, and components dependencies.
• Worked with the Project Managers as the primary interface to all Data Warehouse personnel (onshore and offshore) to streamline and ensure a successful design, development, test and release for each assigned project.
• Used Toad Modeler for data model development and maintenance for SQL Server, Netezza and Oracle
• Worked with Tableau and COGNOS for reporting and analytics

Confidential, Arlington, TX

Sr. Data Architect

Responsibilities:

• Led multi-disciplinary teams of business analysts, systems analysts, system and database administrators, programmers, and client users in activities related to information management
• Partnered with all key stakeholders to deliver multi-platform high quality data driven solutions, meeting business needs of both internal and external clients.
• Responsible for planning, developing, improving and maintaining complex components of the logical/physical corporate data model (both Dimensional and 3NF)
• Led efforts at establishing enterprise wide Data/ETL/BI Architecture standards, best practices, and Data Governance procedures.
• Worked closely with technical leads of ETL/DBA/BI departments in an Informatica/Oracle/ERWin/COGNOS/SAS environment.
• Hands on CRUD operations including DDL, DML, DCL using native and ANSI SQL within ETL(Informatica), BI tools (COGNOS etc.,) and relevant databases.
• Disparate source/target data transformations using Informatica connectors for ORACLE, SQL Server, Hadoop, XML/JSON (Document databases) and Netezza environments.

Confidential, Arlington, TX

Sr. Data Architect

Responsibilities:

• Worked in various short term engagements both domestically and internationally
• Provided consulting services in areas of information processing
• Assisted in Data flow optimization and control
• Taught Data Modeling, ETL, Metadata, Master data and BI concepts
• Contributed to Project Management initiatives including WBS and budgeting
• Clients were in London, Dubai, Lahore and Dallas.

Confidential

Sr. Data Architect

Responsibilities:

• Designed end to end Datawarehouse/Business Intelligence Solutions for all LOB’s
• Worked with Data Modelers, ETL architects and COGNOS/BO architects
• Architected, developed and implemented processes to meet internal and external client data needs
• Liaised with senior management to ensure solutions designed and implemented were aligned with Confidential ’s strategic vision
• Worked with Informatica. Teradata, Oracle, ERWin, COGNOS, Business Objects

Confidential

Principal

Responsibilities:

• BI/Datawarehouse architect and strategy lead on various client assignments
• Worked with senior management in the capacity of Information Management Advisor
• Managed and led junior staff on various stages of the development lifecycle
• Worked with Engagement/ Project Managers to help guide clients through various project phases