Data Integration/Full Stack Developer
Topco Associates LLC
Keywords
Extract Transform Load (ETL)
Microsoft SQL Servers
SAP Applications
SAP HANA
SQL Databases
AngularJS
ASP.NET
.NET Framework
Data Integration
Data Warehousing
Skills
Angular, React, Programming, JavaScript, TypeScript, Python, NET, VB.NET, C, C++, C#, CSS, PERL, JAVA, PHP, CGI, SQL, HTML5, SASS, ES6, SAP Business Objects, Web, Crystal Reports, Tableau, Qlik Sense, QlikView, MS Power BI, Oracle Reports, Yellowfin, BIRT, MS SQL Server, Reporting Services, Frameworks, AngularJS, ReactJS, NODE.JS, jQuery, Bootstrap, ASP.NET, SOAP, REST, Data Integration/ETL, SAP Data Services, BODS, Tableau Prep, Oracle Data Integrator, Informatica, SQL AWS Glue, Server Integration Services, SQL Server DTS, Cognos Data Manager, Talend, Pentaho, GitHub, GitLab, Docker, Jenkins, Puppet Enterprise, Azure, AWS, Jira, SAP HANA, Microsoft SQL Server, Oracle, IBM DB2, Access, PostgreSQL, MySQL, MongoDB, SQLite, Data Integration, Master Data Management, web application, UI/UX, Agile development, API, JSON, XML formats, server-side, web services, GIT, version control, UI, Postman tools, Software Design, Unit Testing, ETL/BODS jobs, SAP, HANA, database, Data Warehouse, ETL, Relational databases, Enterprise Data Warehouse, Business Objects, file transfer, stored procedures, Medusa, mobile devices, data entry, analytics, bugs, ASP/.NET, quality control
Project history
01/2017
-
12/2019
* Designed and developed both front-end and back-end components of a Master Data Management
Solution web application using modern and responsive UI/UX design
* Incorporated the Agile development methodology by working interactively with self-organizing teams
from both Topco and 3rd party to determine requirements and solutions together for each phase of the
project
* Integrated with third-party services and external REST and SOAP API's as part of the implementation to
send and receive product information in JSON and XML formats
* Developed server-side Node.js web services to simplify the development of the application and route
requests through the service
* Used GIT Labs for source code version control
* Used Soap UI and Postman tools to test the web services responses
* Involved in creating Software Design Documents, Technical Design & Unit Testing Documents
* Developed ETL/BODS jobs to extract data from the SAP ECC system and load it into the HANA staging
database
* Developed transformations that apply the business rules given by the client and loaded the staging data
into a Data Warehouse on SAP HANA
Solution web application using modern and responsive UI/UX design
* Incorporated the Agile development methodology by working interactively with self-organizing teams
from both Topco and 3rd party to determine requirements and solutions together for each phase of the
project
* Integrated with third-party services and external REST and SOAP API's as part of the implementation to
send and receive product information in JSON and XML formats
* Developed server-side Node.js web services to simplify the development of the application and route
requests through the service
* Used GIT Labs for source code version control
* Used Soap UI and Postman tools to test the web services responses
* Involved in creating Software Design Documents, Technical Design & Unit Testing Documents
* Developed ETL/BODS jobs to extract data from the SAP ECC system and load it into the HANA staging
database
* Developed transformations that apply the business rules given by the client and loaded the staging data
into a Data Warehouse on SAP HANA
01/2016
-
12/2018
Data Integration/Report Developer
Halifax Regional Municipality
* Experience using SAP Business Objects Data Services as an ETL tools to load data from SAP ECC and
Relational databases to Enterprise Data Warehouse
* Interfaced with HR business and BI team to help identify business requirements, define project scope to
build data mart from scratch, create Business Objects Universe, WEBI and Crystal Reports
* Aligned and integrated employee data from SAP with employee information stored in a separate FDM
system to have consistency between the 2 systems while cleansing bad data and removing duplicate
records
* Automated manual processes by implementing BODS/ETL jobs to increase efficiency by creating files,
using file transfer protocols and sending notification emails
* Created and modelled database schemas, tables, views and stored procedures
Relational databases to Enterprise Data Warehouse
* Interfaced with HR business and BI team to help identify business requirements, define project scope to
build data mart from scratch, create Business Objects Universe, WEBI and Crystal Reports
* Aligned and integrated employee data from SAP with employee information stored in a separate FDM
system to have consistency between the 2 systems while cleansing bad data and removing duplicate
records
* Automated manual processes by implementing BODS/ETL jobs to increase efficiency by creating files,
using file transfer protocols and sending notification emails
* Created and modelled database schemas, tables, views and stored procedures
01/2007
-
12/2012
Software Developer
Medusa Medical
* Contributed to the development of the Siren Suite of solutions used by EMS organizations to capture
clinically rich and accurate Electronic Patient Care Reporting (ePCR) data in real time on mobile devices
* Implemented new features into the Siren Suite of Solutions to assist in rapid data entry capabilities, realtime
alerting, robust workflow tools, and powerful analytics that help improve processes and optimize
organizational performance
* Developed reports to help EMS organizations reduce cost and improve operations efficiencies
* Closely collaborated with project team members to identify and quickly address problems/bugs
clinically rich and accurate Electronic Patient Care Reporting (ePCR) data in real time on mobile devices
* Implemented new features into the Siren Suite of Solutions to assist in rapid data entry capabilities, realtime
alerting, robust workflow tools, and powerful analytics that help improve processes and optimize
organizational performance
* Developed reports to help EMS organizations reduce cost and improve operations efficiencies
* Closely collaborated with project team members to identify and quickly address problems/bugs
01/2005
-
01/2007
Software Developer
Sports Direct Inc
* Using ASP/.NET, developed new pages, features and functionality for several sports media websites such
as www.covers.com and www.wagerline.com
* Accurately followed requirements documents and worked closely with the quality control team to
produce error free results
* Provided 24-hour technical support on major web sites
* Developed complex stored procedures to calculate contest and office pool winners
* Designed and developed an Articles Database interface used by content editors to manage, edit, sort and
delete articles
as www.covers.com and www.wagerline.com
* Accurately followed requirements documents and worked closely with the quality control team to
produce error free results
* Provided 24-hour technical support on major web sites
* Developed complex stored procedures to calculate contest and office pool winners
* Designed and developed an Articles Database interface used by content editors to manage, edit, sort and
delete articles
Local Availability
Only available in these countries:
Canada
I can only work for remote positions.
Other
Extensive experience in front-end development and design using frameworks such as Angular and React. In addition, proficient at implementing core backend development tasks including 3rd party API integrations. Adept at employing the Agile methodology of software development. Expertise in DevOps culture through CI/CD tools. Experienced in build & uploading deployable code and hands on experience with a wide variety of ETL tools. Excellent technical and interpersonal skills, as well as close attention to detail, have enabled me to manage projects and achieve a track record of establishing high levels of credibility with clients and management.
