Kap Shiwram Email & Phone Number

Mississauga, On, Ca

Toronto, Canada Area

* Creating reports from Oracle E-Business Suite (OEBS), EPICOR, Microsoft Dynamics CRM from the source systems directly and from data replicated to MS SQL and Azure servers* Data cleaning using Information Builders DQS server and Python to fix addresses, deduplicate records such as customers and inventory* Data quality reporting and dashboards for business data using PowerBI, custom Javascript webpages with Google Charts and automated daily emails from custom C# and python scripts* Developed & maintained daily ETL data loads using MS SQL stored procedures, SSIS/SSDT packages and ADF pipelines* Developed & Maintained daily ETL using custom Python scripts to extract Microsoft CRM data through Azure Synapse and land in Azure and MS-SQL servers* Developed Python scripts to synchronize data between Oracle and CRM and hosted web applications on Acquia/Drupal sites* Create database and stored procedures for PowerApp apps, including writing Microsoft Flow services* Data analysis with KNIME to combine various Excel files and database queries, to generate cleansed load files to cleanse source data* Source system daily data quality monitoring using MS-SQL replicated data from Oracle, EPICOR, Microsoft CRM, delivered to business users in Power BI or through custom email applications developed in Microsoft C# and Python

Toronto, Ontario, Canada

* Production support for SAP order-to-cash for Marketing department* ITIL certified, working with ticket management systems to track issues and report on tickets* Managed several out-source vendors such as InfoSys, HP, WiPro* Worked with internal audit on SOX compliance and segregation of duty with SAP security setup

Toronto, Ontario, Canada

* Developed ETL process from custom Sybase Marketing sales system to a global datawarehouse in MS-SQL Server, with users in North America, Europe, Brazil, China, Hong Kong, Singapore and Japan* Developed SAP Business Objects reports and a Business Objects Universe where business users can develop their own reports* Microsoft SQL server DBA* Developed interfaces between systems using WebMethods and TIBCO, using an enterprise service bus