SUMMARY:

• More than 12 years technology specialization in Enterprise Data Engineering/Modeling/Architecture/ Governance/Integration/ - Master Data, MPP Appliances/Enterprise Data Warehouse/Data Marts, Big Data Hub/Lake, Data Services, Business Intelligence/Analytics/Data Science, ERP Financials, and Business Systems Analysis.
• More than 5 years in Product Management, Agile/SDLC, Systems/Device Integration, and Business Development in Energy Metering/Management, Parallel/Super Computing, and Computer/ Network Hardware.
• 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.
• Business Systems Analysis/Project Management/Change Management:
• Project/Solution Road Maps/Blue Prints, Business Use Cases, Visio-Sparx-Archi EA/BPM-BPR/RACI, As-Is/To-Be, Scope/Risk Assessment, Baselines, Change/Release Plans, Agile Epic/JIRA/ Scrumban/ Agile/Backlog/Sprint/WBS planning/Business & Earned Value calculations etc.
• BRD/SOW/RFC/RFP, Traceability, Transformation/Lineage Maps, Impact Analysis, Taxonomies, Glossaries, Steward Maps, Governance and Data Quality Assessments, Build/Run Books, User/ System Guides and Material, Webinars/Wikis/Blogs, Technical Content Management/Project Asset Libraries/Metadata Glossaries
• Change/Version/Release Management (SharePoint/Alfresco/Git/JIRA/Stash/Waffleboard/Jenkins)
• Enterprise Performance Metrics/Scorecards/Dashboards
• Data Engineering & DevOps:
• Own Virtual/Bare-metal XEON datacenter running on Linux
• Docker/Vagrant/Chef/Puppet/Docker/Ambari/Cloudera/DC-OS/Kubernetes virtual Clusters for Hadoop, Cassandra, Arango/MongoDB, SAP BODS/BOE, MS BI, ORACLE, SQL Server, SAS 9.4/VA etc.
• Replication, Backup/Restore/Imaging, Disaster Recovery, Audit of environments/data/applications
• Enterprise Data Architecture/Data Mastering/Data Driven Applications/Analytics/Visualization (Modeling/ Design/Development/Governance/Analytics):
• Enterprise Architecture frameworks including TOGAF/Zachman/Ontario Public Services GO-ITS CheckPoints 1234/FSDM/ BDW/ACORD/ARTS/PPDM Canonical Models, Enterprise Roadmaps..
• UML/ERD/ORM/OOM, Conceptual-Logical-Physical-Object Models, Metastores/Reverse Engineering/ Data Federation-Virtualization/Semantic and Analytical Models, Capability/Gap/Impact/ Risk/Traceability/Lineage Maps.
• Data Stewarding/Mastering/Quality, Audit/Security/Access Control lists
• T-PL-ANSI-SQL, Hive-AQL-CQL-NewSQL/stored procedures/functions/materialized views, pig/hive/ Oozie/Map-reduce/impala, table spaces/partitioning/mirroring/replicating, performance tuning/query plans on ORACLE 8/10/11g, SQL2K14/12//8R2/VB/C#/.NET/Visual Studio, DB2/ Sybase/Ingres/ Postgres/MySQL,CDH/HDPHadoop/HANA/Cassandra/MongoDB/ArangoDB/NoSQL/Spark etc.
• ERWIN/UML/Power Designer/ORACLE/Sparx/Archi/Visio/IBM Rational Software Architect etc.
• Enterprise Data Driven NodeJS-REST-Open Data End-Points/Environment/Applications/Analytics/ Visualization/Dashboards/Scorecards including Tableau/Qlik/SAP BO BODS Lumira /OBIEE/MS BI - SSIS/SSAS/SSRS PowerBI /Cognos/SAS/R/Dataiku-DSS/Jasper/D3.js/Dashboards/Visualization, Python/Scala/Spark Notebooks (Zeppelin/Jupyter) etc.
• Enterprise Data Integrations include:
• Hive/Ooze/Pig/Sqoop/Flume/Impala/Spark/Flink/Talend/Pentaho/BODS/Informatica/DataStage/Nifi/Python etc. for data pipelines, ingesting/staging/ blending/matching/cleansing/conforming/ enriching/clustering/pivoting etc.
• Data pipeline benchmarking, profiling, tuning and optimization, resource management, data provenance, impact assessment etc.
• Batch/Real Time/Streaming Data pipeline ingestions from diverse data sources including RDBMS, JSON/XML, Flat Files, NodeJS/SOAP/REST/MQ to SQL-NoSQL-Key-Hadoop stores
• Data Virtualization/Federation/DQ/Data Mastering/Data Catalogs include SAP BO Universe, Denodo, Cognos Data Studio, DataStage Metastore, Stibo/Initiate/Trillium/Talend-Microsoft MDM etc.
• Creation of Semantic BI repositories/datamarts - Jasper Adhoc Views/Reports/Dashboards. SAP BO Universes, Cognos Framework-Data-Report Manager, ROLAP/HOLAP cubes, star/snowflake dimensions with multiple hierarchies, fact tables/aggregates, drill down/through/across, enterprise role-based access security/partitioning, Power BI/SAP BO-Lumira/Jasper/Tableau/Qlik/Pentaho KPI/Score Cards/Dashboards/BI Insights/Content management/portals, parameterized multicast, high performance computation, data visualization, data mining, and data science.
• Data Analytics use cases include Insurance New Business Retention Metrics, Insurance Data Migration Treasury reconciliation, Supply Chain SKU de-duplication, data hub design/integration/ standardization, NewSQL/Python Dataframe/Spark Streaming metric design.
• Spatial analytics include mapping Points of Interest (POI) projections/navigation against ESRI, Open Layer, Bing Maps, Google Maps etc.
• Product and Account Management/System Integration/Marketing/Pre-Sales/Business Development:
• Conversant with Google Marketing tools - Google Data Studio, Tag Manager etc.
• Marketing/Direct/Project/Channel Sales (>5 years): Marketing, Product Pricing, Pipeline Management (Direct/Channel/Agent/VAR/System Integrators). Managed projects worth 5 million USD.
• Project/Solution Sales: include Oil & Gas BI Insight solutions, mini/parallel/super computers and energy (trivector) metering/ monitoring/ management/SCADA systems
• Inside Sales (>1 yr): Event (Summits/Conferences) sales to Fortune 100/500/1000 ‘C’ executives
• Marketing and Pre-Sales: Pre-Sales for Oil & Gas, Energy Metering and Management, Marketing collateral, survey and mail-shot management, event management (advertising-conferences-seminars), product pricing, design and packaging, competitive analysis, market intelligence.
• Cash-to-Cash life cycle management (Pre-Sales->Prototype Management>RFP/RFQ (Techno-Commercial multi-part institutional bidding)>Work Order Management>Vendor Management (Service/ Component Outsourcing/Screening/Inward Control/Payables)>Order fulfillment w/shipment-dispatches-inspection-returns management>Account Management> Financial management-budgets-expense control-receivables-dues-ageing-profitability>Project Administration-task/resource management-cost control-> After-Sales Customer Service including On-Field support services-service returns

PROFESSIONAL EXPERIENCE:

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 using MS BI (SSIS/SSRS/SSAS)/Power BI DAX-M-R-Python scripts/SQL SERVER 2016/17, C#, MVC/.NET/LINQ/Dapper, Dremio Data Virtualization/Dataiku Data Science Studio. Explored Tableau Desktop 2018 with Dremio Server from POC standpoint Code escalations across DEV/QA/SIT/UAT environments, code repositories, Visual Source Safe (VSS) version/ release management, and Team Foundation Server (TFS) project activities.
• Records Management Analyst/Team Lead, NewFoundLand Consultants/Indigeneous and Northern Affairs, Toronto ( )
• Digitization/Records Management of current/historical documents/workflow of INAC projects involving capital assets/funding/maintenance(Roads, Buildings, Water Management Systems) etc. on GCDOCS/ Comprehensive Integrated Document Management/Web-Windows/OpenText/Kofax

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)
• 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, Archimate, Sparx etc.
• SAP Power Designer 14.x/16.x, Archimate, Visio artifacts, ORACLE/SQL Server 2014/Azure/MSPower 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 to acquire/ingest/wrangle/enrich/DQ-profile (Descriptive/Qualitative/Quantitative) metrics/cleanse full/daily incremental data feeds (KQ-KS/ TransUnion/ Probe/Delinquency etc. - Approx. 16 TB/6 yrs. history), calculate SAS 9.4/Hadoop (SASPROC logistic regression) Credit Risk Scorecard for Retail Card Authorization Project (RCAM), and DevOps administration (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 Column Table /MS Analytics Platform System/Cassandra (VMWare) persistence - Approximately 1 million messages/day. 5 TB data
• Administered/Implemented/DQ refined multi-stage SSIS/Talend ETL/T-SQL Stored-Procedures/Python-Spark (PySpark) code (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. from customprop key values) to replace complex, inefficient, and resource hungry stored procedures
• Integrated CRM data/Published/Consumed Data REST end-points for embedded Jasper (Views/Domains/ Topics/Dashboards) Power BI (DAX) analytic visualizations/applications ( Node Express Vue Angular JS/ .NET C# ) with webhook authentication/SSO/Virtual hosts etc.
• .NET/Java/J2EE components, JIRA/Scrumban, Git, Jenkins CI.

Business Systems Analyst (RDAR)

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/DataCleaner& Melissa DQ) 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.
• 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
• Agile/SCRUM/Backlog/Sprint, JIRA/Confluence/Stash, testing against DEV/UAT/PROD environments

BI Architect/Senior Developer

Confidential

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/SQL Server 2012

Enterprise Data Architect

Confidential

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/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 DQ/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 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, 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 Models)/Process Historians/OLE for Process Control (OPC), SAP HANA, SAP Manufacturing, Maximo Asset Management Integration, Big Data/Hadoop, Open Data, Streams/JSON, Data Modeling, Document-Key Stores (Mongo/Couch/HBASE/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, SAP BOBJ/ BODS 4.x, SQL SERVER 2012/MS SSIS/C#/.NET/XML, Pentaho, SAP Predictive Analysis/Lumira/Tableau/ Qlik/Hive/Python, AWS 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

Responsibilities:

• 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, Concerto Messaging, XML web services, .NET/Java SDK, MS Dynamics

Senior Consultant (BI)

Confidential

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
• 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

Confidential

Senior Business Objects Consultant

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

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 code/Postgres-PgSQL/BOE VB/.NET SDK, SQL Server 2K 5, Ingres Open Road, DB2, 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.