Data Architect / Data Modeler / Cognos / Ssis Resume
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.
