PROFESSIONAL SUMMARY:

• More than 15 years in IT Consulting experience
• More than 8 years of traditional data ops in Data Warehouse/Mart/MPP/ ETL/BI/ Analytics
• More than 4 years of Government/OPS Go - ITS Experience at Ministry Of Health, Canadian Nuclear Labs, Government Of Manitoba, OPG etc.
• 3-4 years of Hadoop Data Hub/Lake Ops experience in Bank (Scotia)/Insurance (Economical)/Retail ( Confidential ) verticals
• 1-2 yrs in streaming/sensor data involving RabbitMQ/Kafka/Spark (NewSQL/Python clients) and intermittent Java API plumbing
• More than 3 years in Business Systems Analysis/Agile/Project Planning/ERP Financials
• 6 months experience in GCDOCS Records digitization
• 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)
• Industry vertical exposure to Consulting/Manufacturing/Electronics/Retail/Shipping/Supply Chain/Insurance/ Banking/Healthcare/Government/Utilities/Research & Development
• Canadian Citizen with valid secret level security clearance valid till 2026
• Incorporated at 2415897 Ontario Inc.

TECHNICAL SKILLS:

Languages (>8 yrs): SQL (T-SQL, PL-SQL, PgSQL, ANSI-SQL)/HiveQL/KafkaQL/LensesQL for Kafka streaming and batch/PrestoQL/NewSQL, Python/API, C#/VB/.NET API, Java, Javascript etc.

Distributed Cache/ Computing (3-4 yrs): Worked on Impala/Hive/Parquet/Spark/HDFS/Cassandra. Familiar with Dremio/Arrow, Presto, MemSQL, CrateDB, Yugabyte, CockroachDB etc.

Payload Processing (>8 yrs): CSV/TSV, XML, JSON, Parquet, AVRO, Binary

Frameworks (>3 yrs): Hadoop, Spark, Kafka, Arrow, ScikitLearn, Tensor/Keras, SpringXD etc.

Messaging (>3 yrs): Flume/RabbitMQ/Kafka/MSMQ/IBM MQ

Web/UI Frameworks (>2 yrs): .NET, Node/Express/Vue JS, Flask, WebSphere, J2EE etc.

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

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

Application Servers (>3 yrs): Tomcat, NGINX, NodeJS, Caddy, Websphere, J2EE, Visual Studio .NET

Development Tools (> 6 yrs): ETL Tools (SSIS, BODS, Informatica, Talend, Pentaho, DataStage), Visual Studio Core, IntelliJ, NodeJS etc.

Modeling/Database (> 8 yrs): ERWIN, Oracle SQL Designer, Toad, Power Designer, Visio, IBM Rational Software Architect, Sparx EA, DBArtisan, Archimate/Archi, DBDesigner, Open ModelSphere, Dia, UML, Dbeaver, SquirrelSQL, HeidiSQL, DBVisualizer etc.

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

Operating System (> 8 yrs): Linux, Windows

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

Big Data Hadoop (3-4 yrs): Cloudera, Hortonworks

Relational Databases (> 10 yrs): ORACLE, SQL SERVER, Postgres, MySQL, Sybase, Ingres, DB2 etc.

NoSQL/Distributed Databases (1-2 yrs): Hive, Cassandra, MongoDB, CouchDB, CrateDB, Dremio, Yugabyte, CockroachDB, HANA etc.

BI and Analytics (> 8 yrs): JupyterLab, Zeppelin, SAP BO/Lumira, MS Power BI/MSBI, Cognos 11 Analytics, SAS 9.4, SAS VA, Tableau, Qlikview, Datameer, Dataiki DSS/Knime/ Orange etc.

Public/Private Cloud (< 1 yr): Familiar with AWS/Azure. Private cloud on Minio/LeoFS (AWS clone)

PROFESSIONAL EXPERIENCE:

Data/BI Architect

Confidential

Responsibilities:

• Designed (Cognos Framework Manager)/Integrated (Dell Boomi)/Deployed (SQL Server repo)/Reported and 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.

Senior Developer

Confidential

Responsibilities:

• Designed/Developed/Deployed MS BI/Analytics/Reports integration for Bell Canada ITSM Canaconnect (Canada.com) portal with WET (Web Experience Toolkit) compliance
• Sourced data from BMC Service Management/Excel Provisioning Templates into Canaconnect Service Catalog portal using SSIS/C#/Linq/MVC/Dapper/SQL Server T-SQL scripts/tables/stored procedures
• Enabled SQL Server Blob File Tables/Streams (for Service Contract Documents) with geo-tagging/SQL Server/SSAS/SSRS/Power Pivot for location analytics
• Built analytics/reporting/dashboarding layer for Service Portal using SSAS tabular models/SSRS/Power Pivot/ Power BI DAX/M/Python/Dataiku Data Science scripts as well explored Data Virtualization using Dremio/Data Visualization using Tableau
• Deployed Code across DEV/QA/SIT/UAT environments, code repositories, Visual Source Safe (VSS) version/ release management, and Team Foundation Server (TFS) project activities.

I&IT Cluster Architect

Confidential

Responsibilities:

• 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/Security/AODA compliances), and 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) Models, Impact Assessments, glossaries/catalogs, EA Patterns (Zachman/TOGAF/ Archimate 3.0) etc. Project engagement in transactional, application, security, Data Warehouse, business intelligence, Cloud/ SAAS/PAAS/IAAS/Microservices etc.
• Prepared Data Integration Roadmap showcasing Life Long Learning (3L) with cloud/data lake/machine learning domain integrations for Evidence based Decision Metrics
• Maintained EA artefacts on Power Designer, Visio/BonitaSoft BPM, Archimate, Sparx etc.
• SAP Power Designer 14.x/16.x, Archimate, Visio artifacts, ORACLE 11g/SQL Server 2014/Azure/Power BI DAX

Big Data Developer

Confidential

Responsibilities:

• Facilitated/Implemented/Designed components including Talend (yarn jar execution)/Tidel Big Data Lake pipelines/schedulers with Python/Hive/Pig/Sqoop/Spark code stubs/AVRO 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)
• Performed Data Quality profiling/remediation on financial data feeds based on business rules/HIVE coding.
• 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/Spark ML /Python/HDFS/Yarn/RHEL/Nifi,Java/J2EE/SpringXD Data Flows, Git/Waffleboard/Slack

Senior Data Solution Designer

Confidential

Responsibilities:

• Acquired/time-stamped Sentinel (Fleet Management) Telematic device (XML/JSON) payloads via RabbitMQ/ Kafka (Provider/Consumer) queue messages for SQL-SERVER/SSAS/SSRS geo-enabled Column Tables/Cassandra DB/AWS/Data Lake POC/Patterns - Approximately 1 million messages/day. 5 TB data
• Implemented Data Quality Remediation (De-duplicate, Missing Values, Tacho/Firmware/Timestamp/Speed/way-point distances/braking/idling/rpm/engine-hours/excess trip distance validations/meter health metrics/period trending etc.) on vehicle telemetry payloads
• Refactored multi-stage SSIS/Talend ETL/T Dataflows-Stored-Procedures/PySpark routines etc. to replace complex, inefficient, and resource hungry stored procedures
• Integrated CRM data/Designed-Published-Consumed Data REST end-points (using Node/Express/Vue/Angular JS and .NET C#) for embedded Jasper (Views/Domains/Topics/Dashboards)/SSAS/Tabular/SSRS/Power BI (DAX/M) analytics/visualizations/data applications with webhook authentication/SSO/Virtual hosts etc.
• Simulated POC scenarios (on vagrant/docker clusters) for device payload ingestion into Kafka topics/MemSQL pipelines/Cassandra sinks (for eventual AWS hosting) to integrate non-Ontario/US payloads (Patriot Act Compliance)
• .NET/Java/J2EE components, JIRA/Scrumban, Git, Jenkins CI.

Business Systems Analyst

Confidential

Responsibilities:

• 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, and Enterprise Data Hub Loading patterns. ORACLE/SQL Server/ Hortonworks

Senior Big Data Developer

Confidential

Responsibilities:

• 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/batch/real-time pipelines for data ingestion/in-line processing of Guidewire XML Events (Policy/Billing/Claims/Contact Center/ General Ledger)/ SQL Server/ORACLE etc.
• Performed DQ cleansing using DataCleaner/Melissa DQ
• 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 end-points) 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 reporting/dashboard/analytics/data visualizations
• Agile/SCRUM/Backlog/Sprint, JIRA/Confluence/Stash, testing against DEV/UAT/PROD environments

BI Architect/Senior Developer

Confidential, Mississauga

Responsibilities:

• Designed/Built/Deployed SAS ETL/SAP BOE 4.1 Universe with KPI Metrics/WebIntelligence-Qlik Reports for Letter Mail Process Performance metrics. ODS/SQL-SAS ETL refactoring. WIN 2012/ORACLE 11g/SQL Server 2012

Enterprise Data Architect

Confidential, Oakville

Responsibilities:

• Defined/Designed Cloudera Hadoop Data Hub EA patterns/Source-to-Target Mappings/QA Assertions/ACL/ data flows (NzSQL/SQOOP/Flume/Pig/HIVE/AVRO/HDFS/Impala), component/interface diagrams, lineage/ transformation maps, impact assessment, operdocs/build-run books etc. for Netezza-Hadoop compute ecosystem.
• Executed/Collaborated on sprint plan activities with diverse teams including Hadoop DevOps, Offshore (Kiev)/ Onshore (SAS Product Category Management)/Third-Party Service Providers.
• Refactored data flow logic (DataStage/Netezza/Hadoop/ORACLE 11g/SQL Server 2012/Postgres ETL/ELT/NzSQL/ PL-SQL/PgSQL, Flume, Hive/Pig/Sqoop/Python, Oozie jobs etc.)
• Designed/Built Data Integration/Enrichment patterns for upstream system of record (IBM COBOL Copy Book/ Estate/Spatial/IBM DB2/SQL SERVER/Postgres/MQ/ESB/ORACLE/Access), mid-stream System of (Netezza Business Area Data Marts/IBM Customer Master/Stibo Product Master/Atacama Data Quality/ PeopleSoft Financials 8.4), mid-stream Data Migration (PeopleSoft 8.4 to 9.2 against Data Hub), to downstream applications (COGNOS BI, VB.NET/SQLSERVER/C#/.NET apps e.g. Border Customs App)
• Contributed to project initiatives in SAS VA (Scoping/Sizing/Platform Assessment), Product Mastering (Stibo), Liferay/Jasper portals, Enterprise Data Model refinements/alignment to canonical models like ARTS (ERWIN repos), Reverse/Forward Engineering to ORACLE/ Netezza etc.
• As Data Architect for SAS Product Category Management, participated in sprint product backlog planning (EPICS/User Stories/Effort Estimates/Scrumban), Sprint Execution/JIRA-Confluence Risk/Issue Logs/ Traceability-Lineage-Impact Assessment Documents/Daily Standups/Product Walkthroughs, SAS Interface Table Maps, Data Lake Feed Extracts(ETL/ELT/Job Schedulers)/DQ resolutions, Team size 12 including PM, Solution Architect, Business/QA Analysts, Product Owner, Scrum Master, and Vendor teams. Agile trained.
• Maintained/Presented Project Asset Libraries, Solution Blue Prints, Visio/BPM Process Maps, Requirement Docs, SOW/RFC docs, technical artefacts, DataStage Metastore Glossaries, SharePoint CMS/Flows/Form Updates etc. as part of project/Information Management Design Committee activities
• Designed/Refactored/Updated ERWIN/Conceptual-Logical-Physical Models/Repos/Datastage and ERWIN Metastores/Netezza Business Views etc. in line with EA design patterns (TOGAF/Zachman/ARTS centric)
• Contributed/Assisted in initiatives relating to EDH/Netezza Cluster management and monitoring (Nagios), Solr document indexing, Talend ETL, and Big Data Analytic tools (Tableau/Datameer/PowerView/Mahout).

Solutions Architect

Confidential

Responsibilities:

• Explored/Researched/Integrated EA patterns/Industry Frameworks and 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 patterns, Open Data, Streams/ JSON, Data Modeling, Document-Key Stores (Mongo/Couch/Cassandra), ArcGIS/GeoJS/OpenLayers 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
• Developed on technology stacks including ESRI/Open Source GIS, Postgres/PostGIS/OBIEE/ORACLE 11g/ Oracle Warehouse Builder, SAP BOBJ/BODS 4.x, SQL SERVER 2012/MS SSIS/C#/.NET/XML, Pentaho/ Geokettle, SAP Predictive Analysis/Lumira/Tableau/ Qlik/Hive/Python etc.
• 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 (SAP Manufacturing), order pipeline execution management, project executions, billing etc.

SAP Business Objects Developer

Confidential

Responsibilities:

• Facilitated Group Retirement Saving (GRS) BI Reporting project completion/Project Manager-Information Architect-Business Analyst-Financial Analyst reconciliation/stakeholder sign-offs by identifying/mitigating development risks relating to data model (ERWIN/Sybase Power Designer 16) 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/Designer/Business Objects Lead

Confidential

• Complete Life cycle application deployment including 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/Design, BI/Reports/Dashboard Design/Development/ Deployment across all environments, Testing/QA Milestones
• Solution Architecture/Design/Deployment of Integrated Assessment Record (IAR) Analytical Model/ BI Analytics to integrate/amalgamate assessments including CIHI/RAI XSD/XML non-clinical assessments- OCAN, RAI-MH/CA/MD, ADAT, Enterprise Master Confidential t 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 Confidential t assessment life-cycle, 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), Oper. Docs (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, XCelsius/Webi/Excel PowerPivot/Tableau-Qlik-R (POC) dashboards etc.
• 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, etc.
• Provisioned/Maintained/Monitored/Performance Tuned and Optimized 6 virtual (ORACLE/BODS/BOE) environments (DEV/TEST/UAT and SIT/PPT/PROD) for isolation between development and production (LHIN) usage to meet HL7/HIPAA/Privacy regulatory compliances.
• Team Size include 5 members from vendor, 6 internal members from testing/DBA/ Infrastructure/Business Analyst, 2 from LHIN, and several teams from Ministry. Presented solution for stakeholder approval by Steering Committee/Change Advisory Board (CAB)
• Windows 2K3 8 /WINAD, RH Linux/LDAP, Oracle 10/11g/PL-SQL, SQL Developer/Modeler, SQL Server /SSAS/SSRS/Visual Studio/VB/C#/.NET/Profiler/Optimizer, PowerPivot/Excel/’R’/Tableau Public, Initiate MDM/DQ, ERWIN/Visio/BPM, Concerto Messaging, XML web services, .NET/Java SDK, MS Dynamics

Senior Consultant (BI)

Confidential, Mississauga

Responsibilities:

• 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.
• MS Office/Visio, SAP Business Objects/BODI XI 3.2/4.0, Universe/Webi/ Crystal/XCelsius dashboards, SAP BW, Microsoft BI (SSIS/SSRS/SSAS/SQL Server/.NET/VB/C#/XML/Visual Studio/Profiler/Optimizer) 2K5/ 8 R2

Data Modeler, Architect

Confidential

Responsibilities:

• Gathered/d/Interfaced/Explored BMO’s Architecture Centre of Excellence EA artefacts for right-sizing (IBM’s Rational Software Architect/Visio/Sparx) IBM Value Stream Maps, IBM M1/FSDM/BDW/BIAN operational/data warehouse/canonical models to satisfy Business Requirements Document specifications/ Sparx EA artefacts and AS-IS/TO-BE states to align with EA frameworks/TOGAF
• Performed/Modeled/Designed/Contributed/Implemented Enterprise Conceptual/Logical/Physical/Class/Object Models (ERD/ORM/XSD/Java Class/JPA/POJO/SOA), UML (Domain Models/Classes/Components/ Packages/ Web Services/State Charts/Sequence-Activity Diagrams etc.), Integration Patterns (ETL/ELT/Java/JPA/ Hibernate/DROOLS), BI Semantic Layer (Universe/XSD/Classes), Reporting Patterns (Broadcast/Multicast/ Personalization) for Online Business Banking (OLBB) Wholesale Payments Processing Engine to process Wires/ACH/CC Payment Services against MECH/BESS/SWIFT/MONEYNET/IBM MQ, generate Payments/ Events/Alerts/Notifications/Balance Thresholds/BAI Cash Balances reporting.
• POC for reporting/integration on Talend, SAP Busines Objects, MicroStrategy, Jasper, Intalio BPMS
• Refactoring of ORACLE 10g data flows/PL-SQL code of legacy wholesale payments prior to mifration
• Key member of 2 project teams involving Payments (Project Stakeholder/Manager-1, Senior Business Analyst-1, Development Team Leads-2, and senior developers-5) and Cash Balances/Alerts/Notifications (Technology Head-1, Managers-2, Senior Developers-5). Change Management/SDLC/Project Management methodologies

SAP Business Objects Trainer

Confidential, Mississauga

Responsibilities:

• Performed Elicitation/Gap-Analysis/Requirements/Feasibility/Visio flows/Data Modeling/POC for implementing SAP Data Integrator with HR/Sales Rapid Marts and BOBJ 3.x Webi/XCelsius (or) Tableau Reporting
• ETL/ELT/SAP-BW/Sybase Workforce Integration integration/data quality for incidence management
• BI for Electrical Defect Incidents/Accredited Electrical Contractor Management/Billing/Communications etc.

Senior Systems Analyst (Business Intelligence)/Solution Architect

Confidential

Responsibilities:

• Government of Ontario IT Standards (GO-ITS); AP- 928 Nuclear Work Management; M-28 OPG Compliance Reporting (T+1/ Outage & Online Metrics/Work down Up curves etc. to meet Sparx EA/BRD release changes
• Updated Project/Technical Artefacts-gap/risk/impact assessment, baselines (ITIL/ITSM), UML/ERD/ Dimensional Models, Test cases etc. for Nuclear Data Warehouse (NDW) outage/inline metrics
• Designed SQL 2K5/8R2 T-SQL/SS IS AS RS /VB/C#/.NET optimizations, BI/Dundas SharePoint dashboards
• Developed/Refactored SSIS ETL/VB.NET Integration code for integration of data from Primavera P3 (Dbase)/ P6 (Oracle), PassPort/SPS/NIMS/SCORES (SQL Server), SAP (Finance), Postgres (PgSQL)/VB A /Access/ Excel/.NET apps.
• Line of Business Integration with XML/WSDL/ SOAP/ Business Data Catalogs (BDC)/Application Definition Files (ADF), Excel Calculation/Web Services
• Explored ‘R’ Analytics as an alternative analytic toolset

Data Architect/Senior Business Objects Consultant

Confidential

Responsibilities:

• Migrated Business Objects 6.5 to XI R3 Edge/WIN AD Security at Build-a-Bear, St. Louis
• Promoted SAP R/3 BW Data/SAP Rapid Mart Extractor/BOE Reporting POC to BlackBaud
• Reconciled Webi/Dynamics Inventory Closing for Da Costa Management, BC and Sleep Country, Toronto

Senior Consultant, Data Migration/Analytics

Confidential

Responsibilities:

• Built data structures for migration reconciliation across legacy Cobalt/VSAM to COVERALL/SQL based TRITECH systems as per BRD requirements through JAD sessions with business users/analysts
• Prepared BO Universe Semantic Layer for hierarchical KPI reconciliation of data across legacy/new systems as well as reconcile report balances across diverse subsystems with generated reports in SSRS/VB/C#/Visual Studio, Cognos PowerPlay/Transformer, and Proclarity
• Performed Metadata Extraction/Data Modeling/Reverse Engineering/SSIS Data migration/SQL re-factoring/ optimization/data validation/conversion from Cover-ALL Cobalt Database (VSAM) to TriTech (ZIMM) on ORACLE/SAP BO Universe/webi/XCelsius/Tableau (POC) Reports/Dashboards
• Performed data analysis with Business Analysts/Financial Analysts/Underwriters to uncover/rectify closing balance discrepancies, specifically treasury reconciliation.
• Administered DevOps for Business Objects XI R3.1 Edge Environment

Senior Business Objects Consultant

Confidential

Responsibilities:

• Designed BOBJ XI R2 Universe, BI Webi Reporting/Analytics to identify/reconcile excessive Bill Back Payouts
• Reconciled inconsistencies/duplications across Mercator/DTS-SSIS/VB/C#/Visual Studio Integrations by re-engineering/ refactoring of code
• Data sources include SAP/CRM/MSA/Marketing Subsystems

Business Objects Consultant

Confidential

Responsibilities:

• Refactored/Enhanced data/process models in Visio, DB Artisan, Sparx Enterprise Architect
• Refactored Informatica data flows for erroneous data extracts
• Designed BOBJ 6.1/XI Universes/Operational/Analytical Reporting for Order Acceptance/ Fulfillment/ Reconciliation/Marketing Contribution Analysis/Assay, Root-Cause Analysis

Business Objects Consultant

Confidential

Responsibilities:

• Systems Analysis (Scope/Requirements/Gap/Feasibility) for legacy report refactoring for Community Housing & Loans, Child & Family Service Case Management, and Child Day Care Grant Management w/ HIPAA/HL7
• Data/Dimensional models/PL-T-ANSI-SQL/ERWIN/Sybase Power Designer/PowerBuilder 10-Sybase ASE/ Postgres-PgSQL/BOE VB/.NET SDK, SQL Server 2K 5, Ingres Open Road, DB2, Oracle/Oracle Warehouse Builder, MVCC/Tortoise/Visual SourceSafe
• Refactored critical deficiencies in Child Day Care LOB DB2/Lotus Notes messaging middleware/DB2 Data warehouse ETL (Case Management daily offloads) to address duplication/data quality issues.
• Normalization/Reconciliation of Child Day Care Center Entitlement Grants against Child Day Care Spaces.

Reports Analyst

Confidential

Responsibilities:

• ERWIN/SQL 2005/VB/C#VS Studio/Cold Fusion/InfoPath/SSIS/BOBJ/Crystal/MOSS SharePoint application for Guide Enrolment w/DQ (Dedupe/ Matching/Cleansing), sales, donor funding, council administration, Events etc.