We provide IT Staff Augmentation Services!

Data Architect / Data Modeler / Cognos / Ssis Resume

5.00/5 (Submit Your Rating)

SUMMARY:

  • I am a Masters + 21 years of successful multiple end to end data warehouse / BI / OLAP/ EDL systems design & development experience. Hands on Architect (BI - Data-ETL), Modeler, Analyst, ETL & Reports Developer, DBA who has helped Government, Banks, Finance, Construction, Telco & Auto Industry giants maximize their IT $ ROI through applying industry best practices & skills gathered over time by working with multiple clients / environments. Expert on ER / Dimensional / EDL modeling - CDM - LDM & PDM.
  • With my broad, multi technology, multi project - multi role expertise (worked in all roles), I can steer a Project from inception, business gathering through solution, design, modeling, documentation, ETL, Reporting as well as Production. My efficient & effective communication helps me to discuss and lead meetings / presentations towards objectives, delivering cost effective solutions in either in an Agile or Waterfall methodology enforcing best designs and practices leading to an overall efficiency in BI Governance.
  • Expert on Cognos, ERWIN, Power Designer, Informatica besides Oracle DB2, MS Sql & Big Data.
  • 21 years+ BI & DWH - Architecture, Modeling, Analysis, Design & Development, DBA & Tuning
  • Solution Architect from developing BRDs to Solution to CDM >LDM >PDM to BSTM to ETL to Reporting
  • Excellent presenter and meeting conductor - interfacing with all stakeholder and other teams.
  • DWH Architecture, ETL as well as BI specialist - Cognos / TM-1, /Informatica / SSIS
  • End-to-end vision, and to see how a logical design will translate into one or more physical databases.
  • Dimensional Data Modeling, Conceptual, Logical & Physical Design & Reverse Engineering.
  • 3rd Normal Form, ER Modeling, Dimensional modeling & EDL (Enterprise Data Lake) Architecture)
  • Cognos Design & Development- Framework Manager, Transformer, Analytics, Active Reports
  • Cognos Administration - Folder structure, groups, users, roles and permission
  • Informatica Power Center ~ ETL mappings, mapplets, sessions, workflows & worklets.
  • Meta Data Management, creating Data Mapping & Technical Specifications for multi layered ETL.
  • Creating and maintaining data warehouse assets including staging tables, dimension/fact tables, target tables, indexes, procedures and packages
  • Data & Business Intelligence Governance - RACI
  • Quality Assurance, Pre-Prod, Unit / Integration / System testing & Implementation.
  • SQL & PL - SQL Tuning & Index Tuning plus partitioning strategy to optimize Applications.
  • Installed, configured & administered Oracle & Cognos servers on n tier (IIS / Apache Tomcat)
  • Application Tuning with Explain Plain & cost reduction, partitioning & indexes.
  • Well versed with different data warehouse architectures - Kimball & Inmon

PROFICIENCY:

Data Modeling Tools: ERWIN, Power Designer, Oracle Designer, DeZign

ETL: Informatica (9.1, 9.6), SSIS, Oracle Warehouse Builder

BI: Cognos 8, 10, 11 Business Objects XI R3, OBIEE

OLAP: Cognos Transformer, Power play, TM1, Insight

Database: Oracle 7.4 /8.0/8i /9i/10g/11g, 12g, DB2, MS-SQL 2017

Scripting: PL-SQL / Unix Korn shell (ksh)

PROFESSIONAL EXPERIENCE:

Data Architect / Data Modeler / Cognos / SSIS

Confidential

Responsibilities:

  • Modeled the Conceptual, Logical & Physical designs.
  • Designed & modeled the Central Repository interfacing the SAP 4 HANA systems.
  • Designed & developed Staging, History & External tables besides Dimensions and Facts.
  • Designed & created DataMarts - Finance / Sales / Procurement / Manufacturing each for a separate function.
  • Authored Data Modeling documents including architecture, mapping and standards.
  • Developed ETL Packages using SSIS 2016.
  • Interacted with key stakeholders - Managers / Users and Technical Team SAP to formalize the data models.
  • Designed Cognos Framework, Cognos Analytics (v11) reports & cubes.
  • Migrated, optimized & standardized 200 Cognos 10 reports & 6 cubes to Cognos 11
  • Administered Cognos security on folder structures, roles and permission to secure data.
  • Developed Cognos Dashboard using Data Modules (new features in Cognos 11)
  • Created RACI document for Data & BI Governance listing involved roles across Business & Technology.

Data Architect / Senior ETL Consultant / Modeler

Confidential

Responsibilities:

  • Reverse engineered complex Oracle Pl-Sql code - packages, hadoop procedures and functions across different layers.
  • Creating algorithm, design & process flow.
  • Forward Engineering into new Informatica mappings, sessions, worklets & workflows.
  • Enforcing Push Down Optimization, caching, joiner vs lookups and other tuning techniques.
  • Presented the best design for retaining history in DWH along with a POC. This was agreed & adopted.
  • Adding the necessary framework for the same and creating SCD2 mappings to store data historically.
  • Also presented the best industry practiced approaches to DWH & DM designs.

Data Architect / Modeler / Senior BI Consultant

Confidential

Responsibilities:

  • Creating and maintaining Cognos framework and reports.
  • Developing Feeds for daily consumption by target systems.
  • Created Active Reports in Cognos to give managers remote access to information for presentation purposes.
  • Developed BI dimensional models.

Data Architect / Cognos BI Consultant

Confidential

Responsibilities:

  • Analyzed the existing Legacy System to help create the DWH model & design. Created CDM / LDM/ PDM
  • Analyzed the requirements & developed Cognos reports and dashboards to efficiently address the needs.
  • Advised the DBA s for performance tuning and memory and i/o throughput by Hadoop partitioning & indexes.
  • Designed BI Frameworks & Reports.

BI Architect / Modeler

Confidential

Responsibilities:

  • Remediated OSFI reports by analyzing and leading the remediation effort.
  • Reverse engineered Reports and ETL to the Data Structures, revising them as well as correcting ETL logic.
  • Creating Physical, Business & Presentation layers in Cognos overcoming modeling challenges.
  • Creating DMR models for Analysis Studio and publishing packages.
  • Multidimensional Cubes for user groups using Power Play Transformer.
  • Designing & developing Cognos BI including Frameworks, Reports, Dashboards and dimensional analytics.
  • Developed EDL (Data Lake) Hadoop ingestion layer from source systems on Horton Works.
  • Advising Bank on BI & Analytics best practices as well as on optimizing BRDs, ETL, QA / Test strategies.

Senior ETL Consultant / Modeler

Confidential

Responsibilities:

  • Analyzed existing data processes to introduce new data elements from the Product Vendor establishing the changes needed downstream across different layers of ETL - Landing, Staging, Reporting besides Data Marts.
  • Developing ETL mappings on Informatica 9.5.1 using parameters, variables, delta loads dynamic lookups.
  • Designing lower and higher-level Workflows using parameter file creation, assignment tasks, schedulers, condition, email, command line tasks workflow, session variables etc.

Senior Cognos BI Consultant

Confidential

Responsibilities:

  • Confidential specifically Global Prime Brokerage.
  • Processing, cleaning & correcting Data Acquisition across different location feeds.
  • Merging Source Data elements to synchronize with the business and data warehouse requirements.
  • Highly integrated Framework model using prompt-based macros with in.

Solution / BI Architect / Modeler

Confidential

Responsibilities:

  • Analyzing Business Requirements & creating Data warehouse design & models - Logical / Physical Data Models
  • Managing metadata in Erwin as well as creating dimensional models from the OLTP inputs.
  • Forward engineering Models to Oracle Database including dimensions, facts, partitioning & indexes.
  • Writing PL/SQL procedures, functions & packages for ETL from OLTP to OLAP through successive layers.
  • Creating Cognos 10 Framework Manager models for respective data marts.

Data Architect / Modeler

Confidential

Responsibilities:

  • Studying the requirements and analyzing different source systems which bring in 100s of nightly feeds.
  • Creating the Data Mart Design and the ETL flow - documents and design.
  • Data Vault approach - every DWH record storing the NSSK, Natural Source System Key for audit purpose.
  • Created Source to Target Mappings, highlighting the logic of the data flow to be followed by ETL

Data Architect / Modeler

Confidential

Responsibilities:

  • Designing & creating Conceptual & Physical Design in Power Designer 10.0.
  • Developing a conformed Dims / Facts (Kimball) approach to centrally use these tables from all data marts.
  • Analyzing and enforcing partitioning / materialized views decisions to increase efficiency.
  • Creating database scripts, and advising DBA on space requirement, privileges etc.

Technical Lead - Production DWH

Confidential

Responsibilities:

  • Modeled new data objects - tables, indexes, cubes, and partitions and materialized views.
  • Led team Production Support (24*7) to the Data warehouse batch cycle on UNIX & Oracle.
  • Interacted with senior members of interfacing vendor / recipient systems on a regular basis.

We'd love your feedback!