** ********* ********

Nepean, Ontario, Canada K*E 7B9

613-***-**** (cell)

ad09ku@r.postjobfree.com

biraj saha

Skills & Abilities

Technical: Microsoft Azure (ETL & spark sql) & Dynamics CRM/365, SDK/API design, algorithms, ETL, metadata/reporting, Entity-framework embedded data access, web services (REST/SOAP), CDC, JSON/XML, enterprise architecture, customer support, defect-free code writing/reading, RDBMS/SQL, stored procedures, database conversions, MDX/OLAP, SDLC/Agile, patent filings, R&D tax credits, governance, localization/internationalization, change management, design patterns, pattern matching, verbal/oral communication,

Azure: Data Factory, Service Bus, CosmosDB Data Lake Stor,e Gen 2, Databricks, Analysis Services, Power BI, Stream Analytics, Event Hubs, Durable/non-Durable Function Apps, Data Lake Analytics/USQL, ARM templates, Azure DevOps Buld/Release Definitions, Delta Lake (CDC),

DAX, Power Query (M), Azure Open AI (“chat-gpt-4), Azure Cognitive Search, Azure Service Bus, Azure Redis Cache, Azure Table Storage, Microsoft Dynamics CRM/365

Programming Languages: C#/.NET/WPF (MVVM), MVC Web Api, pyspark, Java (J2EE, JUnit, Emma, JDBC, JCE, JNI, JJJT, JSP, JavaBeans, JAX-RS, JAXB), /ADO.NET, C++ (multiple platforms), XSLT, Oracle PL/SQL, Oracle Pro*C, HTML (limited: Python, Perl, .NET, JavaScript, LISP, APL, Orbix, ObjectStore)

Processes: Scrum, Agile, ISO-9001, Rational Unified (RUP), TDD/IDD, JIRA, Gerrit, Redmine

Standards: DDD, Solid Principles, Onion Architecture, REST-API, ASP .Net MVC / WebApi, HTTP, XML, XML Schema, Java Swing, JDBC, JSON, SQL, SOAP, WSDL, MDX, STL, .NET, Javadoc, DOxygen, CORBA, ANT, HTML5/CSS, Docker, yaml

IDEs: Eclipse IDE, MS Visual Studio, JetBrains Rider, VS Core, Jenkins, Maven, Exceed Hummingbird, Ingres Windows4GL, Silverstream, IBM VisualAge, Powerhouse 4GL

Source control: Git, Perforce, MS SourceSafe, PVCS, CVS, RCS, IBM Rational Team Concert

Web (Application) Servers: Apache Tomcat/IIS, IBM Websphere, Microsoft IIS7

ORM: ADO. Net Entiy Framework, Dapper

RDBMS: Redis, DB2, Oracle, MS SQL Server (& Change Data Capture aka “CDC”), Teradata, Informix, Netezza, Ingres,

OLAP: MS Analysis Services, SAPBW, IBM DB2 OLAP (Essbase)

Operating Systems: Windows, Linux, AIX, HP-UX, Solaris, VMS

Soft: test-driven principles (unit testing), tabular/data modeling, fast learner (languages, processes, architectures, technologies, paradigms, environments),

large scale problem solver, strong communication skills, quality-oriented, customer focus, team delivery, “builder/pillar/code horse”

Experience

SENIOR SOFTWARE ENGINEER

JATO DYNAMICS LTD.

december 2022 – current

Member of “Milano” development team responsible for company-wide “Car Sales”,

“Auth Service” & “Licensing” APIs. Full Scrum process in a team with 2-3 other developers and having primary design/coding responsibilities in development of major features including one with Azure OpenAI.

Feature developments include incorporating Azure OpenAI (chat-gtp-4) into existing SalesProduct (for generation of marketing documentation based on query result data) as well as Azure OpenAI integration for “chat buddy” conversations regarding general JATO product information. Also includes incorporating MS Dynamics (365/CRM) email capabilities to generate “alerts” based on summary “trend” data and periodically send them via email to customer contacts (developing timer-based azure functions to do so).

C# .Net 4.0, Azure (Durable) functions, Azure Open AI, Azure Cognitive Search, Azure API Management, Azure Data Factory, Azure Synapse Server, Azure Cosmos DB, MS Dynamics CRM/365 & Dataverse API, PowerBI, Azure Blob Storage, Azure Table Storage, Azure Blob Storage, Azure DevOps CI/CD, Git, Azure Maps/Microsoft Maps, Nuke Build/Deploy for C#, VeraCode

FULL-STACK DEVELOPER

KIVUTO SOLUTIONS INC.

March – december 2022

Maintenance on their existing Education License Management System (ELMS) Product

Angular, Identity Server, Kubernetes/minikube, C# .Net MVC/WebAPI, SQL Server Active Server Pages, Azure Blob Storage, Azure DevOps CI/CD, Git

SENIOR SOFTWARE DEVELOPER,

FACILISGROUP

DECEMBER 2020 – NOVEMBER 2021

-Back-end development in a team (among 3 teams overall) of 4 other developers as well as 2 testers and 1 product owner in the migration of the company’s long-standing flagship “AtEase” website product from its inaugural to second version. Responsibilities include feature work, the most major being developing email workflow implementation to support both Supply Chain Management (SCM) as well as Customer Relationship Management (CRM) use cases for Quotes, Purchase Orders, Sales Orders, etc..

-Product was high in business complexity, thus code designed as per Domain-driven design for onion architecture and MVC implementation.

-Working in Azure DevOps with C# in ASP.Net MVC/WebApi with MS SQL Server, Redis (deployed via Docker containers), leveraging both Dapper and Entity-Framework ORMs as well.

-Introduced employment of generics as well as MediaTr-based DI handlers to the code base.

-Introduced Docker container employment for developers’ environments for local Redis cache configuration.

-Introduced Azure Blob storage integration to code base (for persisting user’s email template settings).

-Also includes fixing (performance/functionality/customer-impacting). various types of bugs as well

SENIOR SOFTWARE DEVELOPER

CERIDIAN HCM InC.

DeCEMBER 2018 – DECEMBER 2020

-Currently leading a team (among 3 teams overall) of 4 other developers (3 senior, 1 new grad) as well as 2 testers and 1 product owner in the development of an inaugural “Advanced Analytics” release offering for Ceridian’s flagship “Dayforce” product. The development primarily included building an ETL solution that loads data from client databases instances transforms it and persists in Microsoft Azure that gets loaded into an analysis server instance which in turn is used by Power Bi reports that are embedded back in the Dayforce product.

-Strict adherence to Scrum process.

-Involved in primary backlog development and grooming with manager, product owner and other “lead”.

-Was assigned the most complicated technical problems amongst developers, including:

Deep participation in initial development of overall solution, including development of arm templates, Azure Data Factory (ADF) pipelines, C# - based function app development, data lake storage, Azure Data Lake Analytics (ADLA) U-SQL transformation scripts. Powershell-based runbooks, and Azure DevOps release pipelines for deployment.

Developed a “sql”-based “measure validation utility” for QA automation

Appointed “unit testing champion” (as part of an R&D-wide initiative) on team, developing “basic” guidelines that were adhered to by the team in the development of C#-based “Azure Function apps”

Analysis Server modeling for HR “module”, including row-level security & column-level security solutions. Also defined initial set of measures and corresponding DAX expressions.

Led development of main “transformation” development in Azure Databricks with notebooks built with python, pyspark and spark sql.

Resolved complex scalability issues surrounding databricks usage withn ADF to enable unlimited multiple concurrent customer runs.

Built last-minute “azure function”-based asynchronous REST API to be invoked by existing customer support tools able to clone an existing customer “production” environment to another new “customer support instance” for troubleshooting purposes, doing so by cloning the underlying power bi reports as well as underlying azure analysis services database.

Design solution for implementing incremental extractions for client fact tables (payroll-related) that were too large to contain a primary key (thus CDC can’t be used).

Mentored “new grad” and co-op hire such they were able to immediately contribute with solutions and code submissions.

Performed interviews for new hires and co-op students.

SENIOR SOFTWARE DEVELOPER

COGNIVA INFORMATION SOLUTIONS, OTTAWA, ON

JUNE 2015 – DECEMBER 2018

-Feature development & maintenance on Cogniva’s “C3” enterprise software document classification governance product suite, as a lead developer on C3 “Designer” modeling tool (predicated on a patented “faceted” metadata model and C3 Data Access Layer server component,

-Developed an Auto-classification “Configuration” module in C3 Designer to enable modelers to specify document-oriented patterns such that at runtime end users can get their documents automatically classified. UI portions developed with MVVM pattern (no code behind!).

-Developed a Database Import module in C3 Designer containing both UI as well as corresponding runtime algorithms. This module enables a modeler to specify an SQL statement as part of an “Import object” specification associated to one of the other modules in the C3 model. Each specification can be then be later executed to run the SQL and then have the retrieved data transformed and persisted into the respective target C3 model. UI portion also developed in WPF with MVVM pattern.

-Lead developer/architect of new next generation web-based designer modeling/ application architecture, including the development of a new CRUD-based framework predicated on an object-relational persona-oriented meta-model. The framework API leverages on this meta-model to facilitate a general-purpose model-driven nested/linked grid-based UI written in AngularJS (by another developer, and currently being converted to react/redux by other developers). Also includes a new ORM-based light weight data access toolkit to serve as the basis for architectural refactoring of existing components/products. Moreover, also developing a couple of new applications (customer: Army) based on this new Framework.

-Designed and developed features to synchronize to C3 model data to external content management systems OpenText Content Server categories (via WebDav API) and Microsoft SharePoint term stores (via SharePoint Client libraries).

-Technologies include C#/.Net, MS LINQ, .Net MVC Web API, ADO .Net Entity Framework ORM (& DataSets), MS SQL Server, (limited) AngularJS

SOFTWARE DEVELOPER, SUSTAINED ENGINEERING

TREND MICRO CANADA

OTTAWA, ON

October 2014 – JUNE 2015

-Member of team dealing with maintenance of released versions of TrendMicro’s “Deep Security” enterprise-wide security product line, specifically their centralized “Deep Security Manager” web application tool written in Java (also including Oracle/MS SQL Server RDBMS, JSP, JavaScript, Tomcat & install4j). Specialized in vulnerability protection for all machines in corporate environments of various grains, areas of protection include anti-malware, intrusion prevention, firewall checking, and web reputation.

-Resolved code-related issues for customers including Eatons, Navasite, Wipro, Telus, particularly application-level as well as database-related issues.

-Participated in implementation of integration of various cloud providers - Amazon Web Services (AWS), VMWare VCloud & Microsoft Azure with Trend Micro’s Deep Security Service line, specifically with respect to functionality integrating “protected” AMI/Azure instances with Deep Security Manager.

-Attained “VMWare Technical Solutions Professional” accreditation as part of orientation and training process.

-“Customer support lead” on TrendMicro’s “Deep Security as a Service” (DSaaS) product offering, duties included triaging and overseeing handling of customer support requests assigned to other R&D staff.

-

PRINCIPAL ENGINEER

SAFENET INC.

OTTAWA, ON

JUNE 2014 – JULY 2014

-Bug fixing and customer support for SafeNet PKCS-11-compliant Java Cryptography Extension (JCE) security provider component. Maintenance included resolving defects for upcoming release as well as resolving customer issues from existing releases (Fidelity, Ericsson).

-Participated in envisioning for a new REST-based Administrative API as part of a newly envisioned “Common Software Platform” architecture for next generation “Hardware Security Module” security appliances.

ADVISORY SOFTWARE DEVELOPER

IBM CANADA

OTTAWA, ON

NOVEMBER 2007 - JUNE 2013

January 2010 - June 2013: IBM Cognos 10 Mashup Services SDK API "In Market" component owner - Design/Development/Customer Support (4th level)

-Lead developer in maintaining large scale public web services (REST/SOAP APIs) Cognos BI Server SDK component for integration of report execution into external client applications to execution of reports.

-Fixed customer-driven defects, investigated hotsite and information requests, developed features & managed backlogs and pools amongst 2-3 other developers. Agile process (RTC, use cases, stories) employed. Customers supported include; Disney, Johnson&Johnson, JABIL Circuits, University of Texas, Acosta, Dillard’s, JP Morgan Chase, ADP, Raymond James, Boeing, Mass Mutual.

-Developed features and resolve defects related to industry-standard web services (WAS, IIS7, Apache) in various architectural functional areas relative URL, embedded images, HTTP header & cookie processing, SSO, REST-API XPATH-based interface processing, output format processing (XML/HTML/JSON/PDF/thumbnails), WSDL/SOAP –based interface.

-Also resolved defects in “core” semantic areas including report prompting, drill and report filtering.

July 2011 - March 2013: IBM Cognos Process Improvement – Envisioning/Development

-Member of 6-member team implementing CI solution via Jenkins server for all IBM Cognos BI Server components. Involved definition and implementations pertaining to all component quality phases including build, unit test, sanity/integration/performance tests and code coverage/profiling integration.

-Member of 5-member team implementing Maven build and packaging POM-based solution for all existing IBM Cognos BI Server components.

July 2012 - August 2012: Big Data – Envisioning

-Short term participation in large-size architectural team envisioning Big Data solution involving use case realization and integration of various existing products including IBM Cognos BI Server, IBM Vivesimo, IBM Cognos Business Insight, and IBM Cognos Mashup Services.

February 2010 - March 2010: SEC/XBRL - Report Authoring/Modeling

-Metadata Modeler (using Cognos Framework Manager) and Report Author (using IBM Cognos Report/Query Studio) on an international team developing a reporting/analysis solution as a proposal for RFP from US Securities and Exchange Commission (SEC).

-Other products involved included IBM Cognos TM1 & IBM Data Stage, Collaborated twice daily online via conference calls and WEBEX.

April 2010 - August 2010: IBM Cognos 10 Cloud – Development

-Developed IBM Cloud implementation for IBM Cognos BI Server, including IBM Websphere WAS and IBM DB2. On RHEL Linux platform.

-Publication: ISBN 978-1-58347-363-4 – “IBM Business Analytics & Cloud Computing”

July 2009 - December 2010: IBM Cognos 10 Relational Metadata Service - Design/Development

- Lead designer/developer of a new SOAP-based asynchronous service (JAVA) to import database schema metadata via JDBC from supported RDBMS vendors (Oracle, MS SQL Server, DB2, Teradata, Netezza, Informix, ODBC). Developed in JAVA (JUNIT, Emma, JDBC) with SOAP interfaces and XML-based APIs.

January 2008 - July 2009: IBM Cognos Data Lineage SDK API/algorithm – development

-Designed and developed Java-based SOA service features to determine and compute the “data lineage” (series of source metadata transformations) for a given set of columns/cells in a report.

SEnior Software Developer

Cognos Incorporated

ottawa, on

June 2000 – November 2007

August 2006 – January 2008: IBM Cognos 10 Metadata Service - Design/Development

-Designed/developed new Java-based and SOAP-based asynchronous service containing new features to be implemented by teammates. Included socket-based facilities to communicate with existing IBM Cognos BI server components developed in C++

June 2006 - August 2006: Framework Manager "Relative Time" Modeling - Analysis/ Envisioning

-Developed new feature to generate MDX calculations in IBM Cognos Framework Manager modeling tool pertaining to “relative time” computations (e.g. “current period”, ”last 4 months”) that can be then published and readily used (as “draggable objects”) by Cognos report authors.

November 2003 - August 2006: Cognos Metrics Designer ("Metadata"/"Runtime") - Design/Development

-Lead “Metadata/Runtime” developer in C++-based (Windows & UNIX) ETL tool for IBM Cognos Metrics Studio & IBM Cognos Metrics Manager scorecarding products.

-Received “Special Contribution” award (“customer focus”). Major customers: Shell, Tyson Foods, Government of Wisconsin, Accenture, AMGEN.

November 2001 - August 2003: Cognos Framework Manager ("Metadata" component) - Design/Development

-Lead developer of 3-member “Metadata” component within a 15-member team involved in development of this new query planning / metadata modeling too. Developed in C++ on both Windows and UNIX. Responsibilities include initial component development as well as API implementations for model CRUD operations, model semantic “core” logic (e.g. object referencing, validations, and 2-tier model security implementations) as well as various complex algorithms (e.g. model merge/import, database import, and publish). Major customers: MetLife, Manugistics, Boeing.

June 2000 - August 2001: Cognos Architect ("Metadata" component) - Maintenance (team lead)

-Team lead in maintenance of this Cognos Series 7 Metadata modeling tool, built in C++ for Windows. Involved fixing long-standing defects as well as feature development.

Senior Software Engineer

EDS Systemhouse / MCI WorldCom Systemhouse

ottawa, on

September 1998- june 2000

June 1999 - June 2000: SAA (SOA Automation Adapter, MCI WorldCom) - Technical Lead

-Technical lead in a 5-member development of Tivoli-based API and adapter to support remote invocations of transactions from WorldCom LNP sources, to be later passed to the SOA API (below).

November 1998 - June 1999: LNP GUI (MCI) – Development

-Team member in 7-member Java-based application for operators to manually enter LNP transactions and view statistics, which then get processed to the SOA API (below).

October 1998 - June 1999: Local Number Portability (LNP) SOA API – Development

-Oracle Stored Procedure API development to be invoked from remote applications to register LNP transactions that later get processed by existing server-side daemons involved in an existing distributed architecture for customer Lockheed Martin.

September 1998 - October 1998: SMS Telco Messaging – Maintenance

-Implemented enhancement for existing C++ messaging system for customers MCI and Sprint.

Senior Programmer Analyst

MCI / SHL Systemhouse

FREDERICTON, NB

1996-1998

May 1998 - September 1998: CSX Transportation Customer Order Processing (COPS) System (Jacksonville, FL) – Development

-Rewrote DB2 HOST calls in COBOL to Oracle PL/SQL stored procedures as 6-member development effort for performance improvements to the existing “Customer Order Processing” system.

-Also assisted in tuning various SQL blocks as well as JDBC algorithms as part of a separate large-scale CSX Java-Oracle development of a new scheduling system.

January 1998 - May 1998: REPAP Pulp & Paper MRP Database Conversions/Interfaces (Miramichi, NB) – Development

-Remote work involving analysis and development of database conversion scripts for conversions and back-interfaces between Oracle database of newly procured MRP product Marcam Avantis*Pro and existing heterogeneous legacy system data sources (spreadsheets, flat files, MS Access, Mainframe data). Legacy systems include Inventory, spare parts, vendors, account receivables, invoices, purchase orders, accounts payable, general ledger. Analysis involved reverse engineering product’s Oracle database with Oracle Designer*20000 and interacting with various IT personnel and operational managers regarding mappings back to legacy system. Worked with a team including a report author, and a junior developer.

April 2007 - December 2007: Atlantic Canada Online (ACOL) Personal Property Registry System – Development

-Developed Oracle PL/SQL stored procedures for NYSIIS search algorithms as part of a server-side team development for ACOL system to invoke.

December 1996 – February 1997: Canadian Forces Base Gagetown, New Brunswick (Oromocto, NB) - Intranet development

-Developed HTML-based intranet containing various base departmental (e.g. artillery, infantry, etc.) information and orders (e.g. daily, base routine) as content. Set up central Windows server containing IIS web server and MS FrontPage. Mentored another “private” to be the ensuing “webmaster”.

Undergraduate Co-operative Education Program

University of New Brunswick

1990-1994

1993 - 1994: Workers Compensation Board, Saint John, NB (3 terms) - Ingres Windows4GL, Ingres/RDBMS (VAX VMS), System Architect (Data Modeling), FrameMaker, MS Doc2Help

1991 - 1992: Supply and Services Canada Banking and Cash Management Directorate, Hull, Quebec (2 terms) - Oracle V5 RDBMS, Oracle SQL*Report, Oracle SQL*Forms, Cobol, SQL, JCL, Powerhouse 4GL

1991: IBM Canada, Markham, Ontario (1 term) - APA*Foil, File Editing

1990-1994: UNB Faculty of Administration Lab - Helpdesk (part-time) - Novell (LAN), Borland Quattro*Pro, WordPerfect, Lotus

Education

University of Waterloo - Waterloo, Ontario, Canada - M. Math (CS)

1994-1996

Research area: Object-oriented data model constraint theory (Thesis title: A mapping of object schemas to existential graphs)

GPA: 84

TA: CS100 (2 terms), CS338 (2 terms), Math faculty UNIX server helpdesk (2 terms)

UNIVERSITY OF NEW BRUNSWICK - FREDERICTON, NEW BRUNSWICK, CANADA - B.C.S

SEPTEMBER 1989 – APRIL 1994

Specialization: Information Systems

GPA 3.7 (First Class Honors)

FREDERICTON HIGH SCHOOL - FREDERICTON, NEW BRUNSWICK, CANADA – HIGH SCHOOL DIPLOMA

SEPTEMBER 1989 – APRIL 1994

GPA 90 (“Black F” award)

References

Available upon request.

Contact this candidate