Senior IT Consultant - Enterprise Data Modeling Expert

SUNDARAM SURAMPUDI

Mississauga, ON. 647-***-****. www.linkedin.com/in/ssurampudi

**********@*****.***

PROFESSIONAL SUMMARY

-More than 10 years in IT Consulting in diverse verticals – Banking (4 years), Insurance (2 years), Government (8 years), Mining (< 1 yr), Utilities (4 years), Transport (<1 yr), Hospitality (< 1 yr), Telecom (1 yr), Retail (1 yr) etc.

-More than 5 years in Business Systems Analysis/Agile/Project Planning/ERP Financials

-Consummate team-player adept at lead/specialist, functional management, and client-facing roles, managing on-shore/off-shore/cross-functional resources with varying team sizes (4 to 10).

-Bachelor of Electrical Engineering (1984). Underwent Training in Logistics & Supply Chain Management, TQM/ISO/ BPM/Six Sigma/SPC/SAP Sales & distribution/PeopleSoft Financials, Agile (SCRUM Product Owner/JIRA training) and PMP

-Incorporated @2415897 Ontario. Canadian Citizen with valid secret level security clearance till 2035

ENTERPRISE DATA MODELING EXPERIENCE (> 10 years)

-Extensive Data Modeling experience in Canonical/Reference/Data Mesh/Data Vault/Data Warehouse/ Dimensional / Data Product/Data Contract Modeling.

-Extensive modeling with tools like ERWIN, Power Designer, ORACLE SQL Designer, Power BI/Fabric/ Synapse, SAP Business Objects Universe, Cognos Framework Manager, UML/Sparx EA/Toad/Visio, IBM Rational Software Architect, Archi. In addition to data modeling, conversant with Business/ Application/Cloud/Technical Process/ Architecture modeling (BPM/BPR included)

-Conversant with Open Data Product/Contract (ODCS) specifications and Open Table Formats (Delta-Unity Catalog/ Iceberg etc.). Proficient with Python SDK integration/ coding to generate data models using DBT/Databricks Delta/ Iceberg. Created Data Products and Data Contracts using Unity Catalog.

-Created Data Models aligned to Guidewire Data Models (Policy/Billing/Claims/Contact Center/General Ledger)/ ACORD for Insurance, Financial Services Data Model/BIAN for Banks, ARTS for retail etc.

-Implemented Data Mesh on Kafka/OpenAPI/BIAN/Inner-Outerpedia at IBM PNC Project

-Executed Data Governance/DQ/Predictive Model implementations using Databricks/Purview/ Spark/ SparkML/Great Expectations, Trillium/Atacama/Stibo/Initiate (Domain Models), SAP BODS/Talend/ Pentaho/ Melissa, Cloudera Navigator (API), IGC/Navigator API synchronization etc.

-Was a Data Governance Check Point Compliance Auditor for Ontario Ministry Cluster Project/Data Architecture Governance (OPS/IT)

CLOUD/DATA ENGINEERING/DATA ANALYTICS EXPERIENCE (>10 years)

-Extensive Data Engineering Experience on Azure Databricks (2 years), Azure Synapse/Fabric/AWS Redshift/ Cassandra/BigQuery (1 year), Hadoop (Cloudera/Hortonworks) (4 years), PySpark (3 years)/Python (5 years)/R (1 year), AI/ML (SckitLearn, Agents) (1 year), Batch/Streaming Ingestion (SSIS/BODS/Datastage/Informatica/ Talend/Pentaho/Spark/Debezium/Flume/RabbitMQ/ Kafka/IBM MQ/Nifi/nodered etc.) (10 years)

-Data Federation including Dremio (<1 yr)/Databricks (2 yrs)/Pythonic Federation (2 yrs)/SQL Mesh (<1 yr)/DBT (<1 yr)/Presto (<1 yr)

-Databases handled include Oracle (5 yrs), SQL Server (10 yrs), Postgres (1 yr), DB2 (1 yr), MySQL (3 yrs), Mongo (1 yr), Cassandra (1 yr), Duckdb (1 yr), Hyperscale (2 yrs), Synapse (2 yrs), Netezza (1 yr), Teradata (1 yr), Parallel Data Warehouse (1 yr), Redshift (1 yr) etc.

-Business Intelligence/Data Analytics tools include SAP BO (8 yrs), Cognos (1 yr), SSRS (10 yrs), MicroStrategy (1 yr), Power BI (2 yrs), SAS (1 yr), Pythonic reporting/dashboards (2 yrs) etc.

Allied Skills (8 years)

-Application Servers/Web/UI Frameworks (>3 yrs): .NET/J2EE, Node/Express/Vue JS, Tomcat/IIS/ WebSphere/Nginx/Caddy/Flask Visual Studio [Core]/Eclipse/IntelliJ etc.

-Collaboration/CI (> 3 yrs): Team Foundation, Git/Gitter/Waffle, Confluence/JIRA, Jenkins/Travis CI

-Build/Deployment (>2 yrs): Maven, Gradle, yarn, docker/compose, vagrant/puppet, kubernetes etc.

-Monitoring/Analysis (<1 yr): Nagios, ELK etc.

-BPM (1-2 yrs): Bonita, ProcessMaker, ARIS Express, Modelio, Camunda, Activiti, jRules, Joget etc.

-ERP/Financials (3 yrs): SAP BW/SAP SD/PeopleSoft Financials, E-X/Tally/QuickBooks etc.

-Pythonic MLOps/GenAI/Agents/LangChain/PyTorch, Ray.io, Dagster

-SAP Business Objects Institutional Trainer (IIBS – 2010)

PROFESSIONAL EXPERIENCE:

2415897 Ontario Inc., Mississauga

Aug 2025 onward (Self Learning)

-Agentic AI/RAG App (POC) for Municipal Civil Works RFP Content Generation. Python libs used: langchain/llama-index/RAG/Graph-RAG/Streamlit/LanceDB/Pydantic/MartkItDown/Instructor/Extractor/litellm

Senior Manager/Senior Data Modeler, Cognizant-MGM Project, Las Vegas (Remote)

Sep 2023 – July 2025

-Implemented Medalion Architecture for Bronze (Ingest/Cleanse/Standardize), Silver (Semantic Entities), and Gold (Business Entities/Data Products/Data Contracts/Data Mesh) with taxonomy and DQ rules

-Data Dictionary, Source to Target, and File Base Data Import (FBDI)/Financial Accounting Hub (FAH) Template mapping from Source Systems e.g. OPERA/PATRON/LMS etc. to Oracle Financials 24B

-Collected and Analyzed Requirements Analysis/As-Is data models/Azure data flows of MGM (Las Vegas) Resorts

-Source System Data Integration (Proof of Concept) on Microsoft Fabric

-Wrote Python Code for Data Ingestion/Validation of Opera feeds from HyperscaleDB/Oracle Golden Gate with CDC/ Oracle Business Intelligence Cloud Connector (BICC) with SOAP/REST API’s using Azure Functions, Azure Event Hub, Azure Service Bus, and Streaming Autoloader/Delta Live Tables, Loaded data into Oracle FAH from Databricks for GL entry generation etc.

-Wrote ML code to perform multi-class label prediction (SVM) for predicting menu item multi-level label classification.

-Coordinated with DevOps to unlock Databricks Data Federation/Delta Sharing features for LMS data onboarding (1.3 billion records across 8 tables) and delta sharing of data sets with history time-travel to downstream medallion layers

-Showcased the following CDC Integration patterns SQL Server/ORACLE 1. CDC Streams 2. Debezium/Kafka/Airbyte on Azure Container Services and Azure Logic App for CDC Ingestion 3. Azure Event Hub Pub/Sub Feeds (to Databricks/Azure data product consumers) 4. ADF pipelines for source system to ADLS data lake staging 5. Databricks Delta Live Table/Unity Catalog /Streaming Data Quality with Change Data Feeds (CDF)

-Used Synapse (Serverless/Dedicated Pools)/Azure/Fabric Data Flows to ingest Hyperscale/Oracle/DB2 sources into Synapse tables with ADLS staging/Synapse replication, Power BI Semantic Datasets/Reports/ Dashboards.

-Performed tuning and optimization of Unity Catalog data assets using partitions, cluster/Z-order/vector indexes etc.

-Performed Data Steward Control/Governance activities using Microsoft Purview, Unity Catalog User Data Functions, Azure Shared Data Sets (Data Products/Data Contracts)

-Maintained/Enhanced ADF/Synapse/Fabric Pipelines/Apache Airflow logic (Python functions)/schedules/job monitoring and management/job performance tuning and optimization etc. (Nextgen initiative) to load data from source systems/Oracle Golden Gate into ADFS and Hyperscale. Subsequently, all flows/jobs migrated to Databricks/ Spark streaming/Databricks Live Tables (POC).

-Connected Power BI to SQL Workspaces for BI/Data Analytics as well as Azure Data Fabric datasets

-Used Foreign Data Catalog Federation to connect to Hyperscale/Teradata/SQL Server instances.

-Extensive coding on PySpark/SQL/Scala notebooks in Databricks. Azure DevOps/Git CI-CD Pipelines

Data Architect, Health Canada, Ottawa (Remote), A/c. 2415897 Ontario Inc.

Feb 2023 - Mar 2023

-Gathered requirements and created solution patterns for movement of existing SAS Viya/9.4/DataGrid data sets to Azure blob storage, ingestion into Azure Synapse using SAS tools/Azure Data Factory Pipelines/ Jupyter notebooks etc. and self-service analytics using a combination of tools including SAS, Power BI etc.

-Outlined Agile EPIC/Story creation to decompose above effort into manageable sprint cycles with defined value proposition

-SAS 9.4 DataGrid/Azure Data Lake/Azure Synapse

-Extensive PySpark/Python/SQL coding, Azure DevOps/Git CI-CD Pipelines

Data Architect, Innovapost, Ottawa (Remote), A/c. 2415897 Ontario Inc.

April 2022 – Dec 2022

-Created source data intake/ETL/SQL/BI transformation patterns (3NF, Dimensional/Fact, Power BI Datasets/ BOBJ Universe Reporting datasets) for Teradata EDW using Data Model/DataStage ETL/Production Deployment patterns for Maximo/Flight Dispatch Billing domains

-Identified spaghetti SAS code in SAS Marketing Campaign Management/SAS BI and Analytics/Service Performance Measurement domains to be migrated to Glue/Python/Power BI on AWS

-Teradata/Vantage 17.x, AWS/Python/Power BI/SAP BO/ERWIN, Git CI-CD Pipelines

Big Data Developer, ESDC, Ottawa (Remote), A/c. 2415897 Ontario Inc.

Oct 2021 to Mar 2022

-Tasks include building data ingestion/data pipelines to batch ingest relational/CSV/JSON/XML/ SAS7BDAT/IBM Mainframe Cobol Copybook/Control files (with PII Obfuscation) using ORACLE Golden Gate/SAS Viya/Spark/Python/ Sqoop etc. to load to HDFS/Hive/Impala for downstream SAS VA analysis

-SAS/CAS Code to parse/ingest/transform/job schedule mainframe dat/control files, SAS7BDAT etc. (DATA STEP/SAS PROC HADOOP etc.)

-Cloudera Navigator Metadata management/IGC 2-way metadata synchronization using API/Python

-Oracle Big Data Analytics (OBDA) cluster – Cloudera based/RedHat Linux DEVOPS assist

-Extensive PySpark/Python/SQL coding, Azure DevOps/Git CI-CD Pipelines

Data Architect, IBM PNC Bank Project, USA/Canada (Remote), A/c. 2415897 Ontario Inc.

Dec 2020 to Oct 2021

-OpenAPI 3.0/2.0 (Swagger) End point definition/creation/documentation/microservices for BIAN Reference OuterPedia/ System of Reference InnerPedia Service Catalogs, Data Pipelines/Data Streams on Kafka/SpringBoot/ KQLDB/ Python/Informatica, Code CI/CD pipelines on Jenkins.

-Maintenance of Kafka Schema Registry/AVRO Schemas

-Assist in creation of Data Pipeline definitions (running on Informatica/ORACLE Golden Gate/Hadoop etc.) for varied PNC Pneumonic/System of Record (SOR) data sources including COBOL Copy books, Relational Databases, NoSQL, JSON/XML, Excel Sheets, CSV, Hadoop HDFS, Spark/Hive/Impala Data frames, Teradata data warehouse etc.

-Implemented Data Mesh revolving around BIAN reference architecture

-Cloud provisioning on OpenShift.

-Python coding, Azure DevOps/Git CI-CD Pipelines

Senior Data Engineer (Python/Power BI), Enbridge Project (Remote), A/c. 2415897 Ontario Inc.

Sep 2020 – Nov 2020

-Refactoring/Design of Python code (Advanced)/Power BI (with Python/GeoPandas/Azure Map/MapQuest integration) for Enbridge Gas Pipeline Asset Integrity Executive Dashboards (Power BI/SharePoint Online) with Data Wrangling/ Cleansing.

-File and Data Repositories include SQL Server/T-SQL/SSIS, ORACLE/Developer/Designer/PL-SQL, Azure Blob, Cosmos DB NoSQL, Hadoop Data Lake on Azure etc.

-Feature/Backlog/Sprint planning using Azure Boards.

-Technologies : Azure SQL/Repo/Maps/Boards, Python Pipelines, SQL Server 2016/Python/Power BI/ SharePoint, Azure DevOps/Git CI-CD Pipelines

Senior Data Analyst/Developer/Architect, Toronto Transit Corporation (Hybrid), A/c. 2415897 Ontario Inc.

Feb-Aug 2020

-Designed/Refactored/Developed Enterprise patterns/Data Adapters (SSIS/C#/Python) for Data Federation, Source Data Acquisition (Relational/Object databases, XML/JSON/CSV, XLSX/XLSB, PDF/DOCX, WSDL/ REST/OData etc.), Data to Staging/Warehouse/Data Vault design patterns on Microsoft Parallel Data Warehouse Appliance/Azure Synapse Cloud Data Warehouse/Python-Pandas-C# Data Wrangling code/ Stored Procedures/SSIS ETL/Azure Data Factory/Cosmos DB NoSQL Collections/MicroStrategy/Power BI (DAX/M)/SharePoint etc.

-Business data Integrations include Metrolinx feeds, Presto device incidents, Maximo/ServiceNow, Streetcar/ Bus Fleet/Subway operations, MS Dynamics etc.

-Technologies: Azure/Synapse/PDWSQL/Cosmos//C#/MVC/Python/SSIS/ADFSharePoint/MicroStrategy/Power BI/ Azure DevOps/Git CI-CD Pipelines

Data Architect/Pre-Sales (Data Platforms, IIOT), Infosys/BHP (Chile) Project, Toronto, ON (Remote), A/c. 2415897 Ontario Inc.

July-Oct 2019

-Formulated Agile/EPIC/story point framework to size/scope business change requests, business entity/ activity decomposition, feature extraction, backlogs/Kanban, sprint incremental business value creation etc. towards Statement of Work (SOW) document.

-Explored OT (Operational)/IT integration patterns including time series databases (Influx DB/Elasticsearch NoSQL/ Kibana/Logstash/SQL Server 2017/PI Archives/OLE), OPC UA/PI Asset Framework (Data Modeling/Asset/Data/ Event/Analysis) hierarchies, ARCGIS Maps/Shape Files/Features, Edge/Fog computing, MQTT/Kafka broker/Node Red Web socket integration etc.

-Formulated data platform ingestion/data pipeline/ETL Proof-Of-Concept patterns (PI Integrator/Python/ Kafka/ Spark/ Sqoop/Flume) for diverse data sources including IIOT 4.0 (Sensors/PLC, PI Historian, XLS, SQL Server, CSV/XML/ JSON/MongoDB NoSQL, ESB/REST End Points, AVRO/Parquet serialization etc.) to On-Prem Cloudera Data Lake.

-Defined Data Vault models (aligned to CRIRSCO Copper Mining/Mineral Reconciliation), full/delta loading, schema versions, Oracle SQL Data Modeler (Forward/Reverse Engineering/ Volumetric/Impact Analysis).

-Created Normalized templates of excel sheets for Mineral Reconciliation Metrics on Power BI/DAX/M

Data/BI Architect/Analyst, Canadian Nuclear Lab/Protiviti, Chalk River, ON (Hybrid), A/c. 2415897 Ontario Inc.

Sep 2018 – Mar 2019

-Translated Business Requirements BI/analytical product features.

-Designed (Cognos Framework Manager)/Integrated (Dell Boomi Data Pipelines)/Deployed (SQL Server/ORACLE repo/Stored Procedures)/Reported/Analyzed (using Cognos 11 Analytics) Earned Value Management/ Project Finance data marts integrating source data from Oracle/P6 Primavera/Deltek Cobra EVMS/PCRS/ MFRS (Custom Financial Apps) with hierarchical roll-ups on WBS, Calendars, Cobra Data Sets etc.

-Integrated JSON Work Break Down Structure (JSON) objects into SQL Server.

-Power BI quick run Earned Value Management storyboarding/reports/dashboards.

-Technologies Used/Existent : ORACLE, SQL Server, Cognos, Dell Boomi, SSIS, SSAS, SSRS, Power BI, Python

Senior Developer, Sryas Inc. A/c. Bell Canada (Remote), A/c. 2415897 Ontario Inc.

Mar 2018 - Aug 2018

-Designed, developed, and deployed MS BI/analytics/reporting integration for Bell Canada ITSM Canaconnect portal, ensuring WET compliance.

-Sourced data from BMC Service Management and Excel templates into the Canaconnect Service Catalog using SSIS ETL, C#, LINQ, data pipelines, MVC, Dapper, T-SQL, stored procedures, and CTEs.

-Enabled SQL Server Blob File Tables/Streams for service contract documents with geo-tagging and location analytics using SQL Server, SSAS, SSRS, and Power Pivot.

-Built the analytics/reporting/dashboard layer with SSAS tabular models, SSRS, Power BI, Python, Pandas, SharePoint, Scikit Learn, Dataiku, and Dremio Data Virtualization.

-Developed Power BI dashboards featuring Power Pivot, ‘M’ scripts, direct SQL Server queries, role-based datasets, DAX, Azure Data Factory, Azure Directory Federation, and advanced ticket incidence analytics (clustering, decision trees, predictions, scorecards).

-Managed code deployment across DEV/QA/SIT/UAT environments, handled version/release management with VSS and TFS.

-Explored RavenDB and MongoDB NoSQL for multi-modal data persistence. SSIS/C#/Python/M-scripts

Team Lead, Newfound Consultants/Indigenous and Northern Affairs, Toronto, A/c. 2415897 Ontario Inc.

Oct 2017 – Mar 2018

-Executed/Administered Digitization/Records Management of current/historical documents/workflow of INAC projects (Capital Assets/Funding/Maintenance of Roads/Buildings/Water Management Systems) on GCDOCS/Comprehensive Integrated Document Management/Web-Windows/OpenText/ Kofax

I&IT Cluster Architect, Ministry of Education, Toronto, ON, A/c. 2415897 Ontario Inc.

Dec 2016 – Sep 2017

-Mentored/Assessed/Reviewed Business/Application/Data Architecture documents, mitigated risks, aligned them to OPS/GO-ITS Governance/Regulatory/Compliance (GRC), facilitated project checkpoint (CP1/2/3/4) clearances (including TRA/PIA/PII/Security/AODA compliances), refreshed Cluster/Corporate SharePoint with project artifacts and proceedings (CART/CAMT/ACT/ARB)

-Stewarded Project life-cycle artifacts include BPM/UML/Infrastructure/Canonical/Data Movement (Conceptual-Logical-Physical) Data Models, Impact Assessments, glossaries/catalogs, EA Patterns (Zachman/TOGAF/ArchiMate 3.0) etc. Project engagement in transactional, application, security, Data Warehouse, business intelligence, ETL, Cloud/ SAAS/PAAS/IAAS/Microservices etc.

-Projects check-pointed include Transfer Payments Common Registration (TPCR) (>10 mn $ project outlay), Municipality Grants, Community Housing etc.

-Prepared Data Integration Roadmap showcasing Life-Long-Learning (3L) with Azure cloud/data lake/ machine learning domain integrations for Evidence based Decision Metrics

-Maintained EA artefacts on Power Designer, Visio/Bonita Soft BPM, ArchiMate, Sparx EA etc.

-SAP Power Designer 14.x/16.x, ArchiMate/Visio, ORACLE 11g/SQL Server 2014/Azure/MS Power BI M/ DAX for Architectural Risk Assessment (ARA) tracking/SharePoint publication for ongoing projects

Big Data Developer, Scotia Bank RDAR/RMSS Card Authorization (POC), Toronto, A/c. 2415897 Ontario Inc.

Aug 2016- Nov 2016

-Business Requirements/Agile Product Delivery, Requirements to technical feature set conversion.

-Facilitated/Implemented/Designed components including Talend (yarn jar execution)/Tidal Big Data pipelines/schedulers with Python/Hive/Pig/Sqoop/PySpark code stubs/AVRO NoSQL Schemas to acquire/ ingest/ wrangle/enrich/Profile/DQ cleanse/analyze (Descriptive/Qualitative/Quantitative metrics) full/daily incremental data feeds (KQ-KS/TransUnion/Probe/Delinquency/Oracle 11g EDW etc. - Approx. 16 TB/6 yrs. History)

-Facilitated SAS 9.4/R/Hadoop (SASPROC logistic regression) Credit Risk Scorecard Models for Retail Card Authorization (RCAM)/DevOps documentation (Chef/Puppet/Config/Knox/Kerberos scripts) for above.

-Hortonworks/Sqoop/Pig/Hive/AVRO (NoSQL)/PySpark [ML]/Python/HDFS/Yarn/RHEL/Nifi/ETL, Java/ J2EE/Spring XD Data Flows, Git/Waffle board/Slack

Senior Data Solution Designer, BSM Wireless (IoT), Toronto, A/c. 2415897 Ontario Inc.

Mar 2016 - August 2016

-Translated business requirements for agile product and proof-of-concept delivery.

-Acquired and processed time-stamped Sentinel fleet management telematics data (XML/JSON) via RabbitMQ/Kafka queues, storing ~1 million messages/day (5TB) in SQL Server, SSAS/SSRS, Cassandra, AWS (S3/RDS/Redshift), and Hortonworks Data Lake.

-Administered and improved multi-stage SSIS/Talend ETL pipelines, implementing T-SQL procedures and data quality checks (deduplication, missing values, sensor validations, trending) to replace inefficient legacy processes.

-Integrated CRM data and developed REST endpoints using Node/Express/Vue/AngularJS/.NET C#/Python/Pandas

-Created embedded operational analytics dashboards and reports in Jasper Professional (including Meter Health, Geo-Fence metrics), using webhooks and SSO authentication.

-Developed Power BI, SSAS, SSRS, and Tableau dashboards with self-service analytics and RBAC for power users.

-Built Docker/Vagrant-based POCs for device data ingestion (Python, Pandas, Kafka, MemSQL, Cassandra, MongoDB) to handle non-Ontario/US payloads, ensuring Patriot Act compliance.

-Utilized a technology stack including SQL Server, VMWARE, AWS, .NET, Java, Jasper Professional, Power BI, SSIS, SSAS, SSRS, JIRA, Git, and Jenkins.

Business Systems Analyst (RDAR), Scotia Bank International Banking, Toronto, A/c. 2415897 Ontario Inc.

Feb 2016-Apr 2016

-Elicited/Created Strategy Maps/Process transformation/Data Flow Diagrams/Change Management/ XSD structure changes/Business Unit Merger & Acquisition Impact Assessment, Business Rule refactoring for collections/credit risk assessment/Enterprise Data Hub patterns. ORACLE/SQL Server/ Hortonworks

Senior Big Data Developer/Analyst, Economical Insurance, Kitchener/Toronto, A/c. 2415897 Ontario Inc.

May 2015- Sep. 2015

-Business Requirements translation/Agile Product Delivery

-Designed/Developed Hadoop Data Hub (RH Linux, Cloudera CDH4.x, Flume, HDFS/Map-Reduce/ Sqoop/ Pig/Hive[XML Serdes]/Avro/Impala-Parquet/Oozie/Python/Spark, Pentaho ETL/Data Cleaner & Melissa DQ) batch/real-time data pipelines for data ingestion/in-line processing of Guidewire XML Events (Policy/Billing/ Claims/Contact Center/General Ledger)/SQL Server/ORACLE etc.

-Extended data pipeline processing logic to blend/wrangle/cleanse/enrich with New Business Retention Key Metrics (New Policy Count/PIF Count/Written-Earned-Unearned-Realized Premiums Month-over-Month) and extraction/loading (REST endpoints) to ORACLE GL Module, Digital Apps, and Pentaho-ctools/Mondrian/Saiku Dashboard/Power BI DAX Analytics/Reporting

-Generated Pentaho/SSAS Tabular/.NET/C#/SSRS/Power BI/Tableau analytics/visualizations

-Agile/SCRUM/Backlog/Sprint, JIRA/Confluence/Stash, testing against DEV/UAT/PROD, Git CI-CD Pipelines

BI Architect/Senior Developer, Innovapost, Mississauga, A/c. 2415897 Ontario Inc.

Oct 2014 – Mar 2015

-Business Requirements translation/Agile Product Delivery

-Designed/Built/Deployed SAS ETL/Data Pipelines/SAP BOE 4.1 Universe (Data Model) with KPI Metrics/ Web Intelligence-Qlik Reports for Letter Mail Process Performance metrics. ODS/SQL-SAS ETL refactoring. WIN 2012/ORACLE 11g/SQL Server 2012

Enterprise Data Architect/Analyst, Canadian Tire, Oakville

Dec 2013 - Oct 2014

-Translated business requirements into agile product delivery and proof-of-concept implementations.

-Defined and designed Cloudera Hadoop Data Hub enterprise architecture, including source-to-target mappings, QA assertions, ACLs, data pipelines, interface diagrams, lineage and transformation maps, impact assessments, and operational documentation for the Netezza-Hadoop ecosystem.

-Collaborated on sprint planning and execution with Hadoop DevOps, offshore (Kiev), onshore (SAS Product Category Management), and third-party teams.

-Managed and orchestrated data flows, pipelines, schedulers, sources, and sinks across DataStage, Netezza, Hadoop, Oracle 11g, SQL Server 2012, Postgres, Flume, Hive, Pig, Sqoop, Python, Pandas, and Oozie.

-Designed and built data integration and enrichment patterns for upstream systems (IBM COBOL, ARCGIS, IBM DB2, SQL Server, Postgres, MQ, ESB, Oracle, Access), mid-stream systems (Netezza Data Marts, IBM Customer Master, Stibo Product Master, Atacama DQ, PeopleSoft Financials), and downstream applications (COGNOS BI, VB.NET/SQL Server/C#/.NET apps, e.g., Border Customs App).

-Contributed to SAS VA platform assessments, product mastering (Stibo), Liferay/Jasper portals, enterprise data model refinement, and alignment with canonical reference models (ARTS, ERWIN), including reverse/forward engineering to Oracle/Netezza.

-As Data Architect for SAS Product Category Management, participated in agile sprint planning, backlog management, risk/issue tracking, traceability, daily standups, product walkthroughs, SAS interface table mapping, data lake feed extracts, DQ resolutions, and team coordination (team of 12).

-Maintained and presented project asset libraries, solution blueprints, process maps, requirements, SOW/RFC docs, technical artifacts, DataStage metastore glossaries, and SharePoint CMS updates for information management.

-Designed and updated ERWIN conceptual, logical, and physical models, Datastage and ERWIN metastores, and Netezza business views in alignment with ARTS-centric EA patterns.

-Supported EDH/Netezza cluster management and monitoring (Nagios), Solr indexing, Talend ETL, and big data analytic tools (Tableau, Datameer, PowerView, Mahout).

Solutions Architect/Pre-Sales Engineer, Oil & Gas BI Insights, Rolta Canada

July 2013 - Nov 2013

-Aggregated business requirements into technical feature sets.

-Drafted/Validated RFP/RFC bids for Oil & Gas BI Insights, ArcGIS/OpenLayers Spatial Analytics etc.

-Explored/Researched/Integrated EA patterns/Industry Frameworks/technology stacks including/not limited to ISA95/PPDM (Petro-Products Data Model)/Process Historians/OLE for Process Control (OPC), SAP HANA, Manufacturing/Maximo Asset Management Integrations, Big Data/Hadoop/AWS (S3/RDS/RedShift) patterns/data pipelines, Open Data, Streams/JSON, Data Modeling, Document-Key Stores (MongoDB/ CouchDB/Cassandra), ArcGIS/GeoJS/OpenLayers/OpenGeo Feature Set Data modeling and Overlaying for spatial analytics, GRASS/Geokettle etc.

-Mentored/Managed/Administered/Performance-monitored directs/functional resources including Project Manager, DBA, Infrastructure Manager, Senior/Developers (2)/Finance/Marketing etc. for design, development, and implementation of Oil & Gas BI/Location Insights for Asset/Operational/ Maintenance/ Sustainability KPI

-Pre-sales/webinar activities to top ‘C’ level O&G executives including VP/GM/Senior Managers etc.

-Pre-sales enablement (Gross: 1 million $), POC management, SME training (SAP Manufacturing), order pipeline execution management, project executions, billing etc.

-Developed on technology stacks including ESRI/Open-Source GIS, Postgres/PostGIS/OBIEE/ORACLE 11g/Oracle Warehouse Builder/Data Integrator/ETL, SAP BOBJ (Universe/Webi)/BODS 4.x (SAP/BW Integrations), SQL SERVER 2012/MS SSIS/C#/. NET/XML, Pentaho/Geokettle, Power Pivot/View/Map/ DAX, SAP Predictive Analysis/Lumira/ Tableau/Qlik/Hive/Python/Pandas etc.

SAP Business Objects Developer, Sun Life Financials, Toronto, A/c. 2415897 Ontario Inc.

Feb13 - May 2013

-Facilitated Group Retirement Saving (GRS) BI Reporting project completion/Project Manager-Information Architect-Business Analyst-Financial Analyst reconciliation/stakeholder signoffs by identifying/mitigating development risks relating to data model (ERWIN/Sybase Power Designer 16/ ORACLE) alignment and integration to Canadian Data Warehouse (CDW), Corporate Information Factory (CIF), and ACORD, Informatica 9.1/SSIS. flows, SAP BOE 3.1/Universe/ Webi/Websphere/XCelsius report designs/Access Control, SAP BO Java API

-Updated Project Asset Library (Lotus Notes), Trillium DQ Assets, JIRA/HP Application Life Management docs, ERWIN/Sybase Power Designer 9.1 Data Models, as per project requirements.

Solution Architect/Business Objects Lead/Business Systems Analyst, Community Care Information Management (Ministry Of Health), Toronto, A/c. 2415897 Ontario Inc.

June 2011-November 2012

-Participated/Contributed/Influenced/Monitored/Managed Requirements Analysis/Gathering, Stakeholder Negotiations (Vendor/CAB/Steering Committee level presentations), LHIN (Customer)/ Vendor (Fujitsu) Delivery Management for Delivery, Testing, Implementation, Training etc.

-Complete Life cycle application deployment - Business Systems Analysis (Business and Technology Roadmaps/CAB Committee Technical Presentation and Approvals/BRD/Milestone Plans/Work Breakdown/ Cost Estimations), Technology Architecture, Environment Specifications/Rollouts (DEV/Test/ QAT/SIT/PRE-PROD/PROD), RFC, Database Architecture/Modeling/Design, BI/Reports/Dashboard across all environments, Testing/QA Milestones

-Solution Architecture/Design/Deployment of Integrated Assessment Record (IAR) Analytical Reference Model/ BI Analytics to integrate/amalgamate assessments including CIHI/RAI XSD/XML non-clinical assessments- OCAN, RAI-MH/CA/MD, ADAT, Concerto Repository, Enterprise Master Patient Index Record, Provincial Provider Registry

-Proposed integration of MS Dynamics financial data to operational feeds to derive activity costing/360-degree overview of non-clinical patient assessment lifecycle, operational costing/ resource-facility utilization metrics.

-Updated JIRA/HP Center/Afresco Project CMS with artefacts including Scope, Milestones, Risk Log, RFC, Sprint plans, Enterprise Architectural Patterns, Data Governance/Steward Access patterns, Infrastructure Patterns (BOBJ/BODS/ ORACLE virtual provisioning), Integration/ETL life-cycle patterns (sourcing, ingesting, referencing, standardizing, quality checking, testing, staging, and loading), BI patterns (Semantic/Universe, Dimensional/Analytical Reporting, Dashboards/KPI, Broadcast/Multicast/ Personalization), OperDocs (Build-Run Books/User Guides/Migration Guides etc.) on VMWARE/ORACLE/SAP Business Objects Data Services 3.x/4.x provisioning, SAP BO 3.x/4 (Universe/ XCelsius/Webi)/Excel Power Pivot/Tableau-Qlik-R (POC) dashboards etc.

-Provisioned/Maintained/Monitored/Performance Tuned and Optimized 6 virtual (ORACLE/BODS/ BOE) environments (DEV/TEST/UAT and LHIN SIT/PPT/PROD environments) to meet HL7/HIPAA/Privacy regulatory compliances.

-Leveraged ExistDB/BaseX/MongoDB for navigating/storing IAR XML documents

-Team Size include 5 members from vendor, 6 internal members (testing/DBA/ Infrastructure/Business Analyst), 2 (LHIN), and several teams from Ministry. Presented solution for stakeholder approval by Change Advisory Board (CAB)

-Win2K3[8]/WINAD, RH Linux/LDAP, Oracle 10/11g/PL-SQL, SQL Developer/Modeler, SQL Server 2008 [12]/ SS[A][R]S/VB/C#/.NET/Java/Python/R/Profiler/Optimizer, Power Query/DAX/Excel/Tableau, Initiate MDM/DQ, ERWIN/ Visio/BPM, Concerto Messaging, XML web services, MS Dynamics

Senior Consultant (BI), Avanade Inc, Mississauga, A/c. 2415897 Ontario Inc.

Feb 2011-May 2011

-Executed BI Projects at Canada Post, Ottawa, Data Modeling/Profiling for Union Gas, and Microsoft BI projects for Cancer Care per Project Scope and Guidelines.

-SAP Business Objects/BODI XI 3.2/4.0, Universe/Webi/ Crystal/

Contact this candidate