Pushkar Singh

Software Developer - Toronto, ON

pushkar.s.arora@gmail.com
Resume (pdf)

About Me

I am a software developer with years of experience in translating business logic into easy to use technical solutions. My principles of doing exceptional quality work, paying attention to detail and telling the truth helps me focus on delivering the best.

I have successfully engineered many customized solutions using a strong working knowledge of latest technologies, algorithms, data structures and software design patterns.

When I am not working, I love to play Squash, Golf, read and learn new technologies, paradigms and frameworks.

Work Experience


TD Securities

TD Treasuries - SQL Business Analytics

Software Consultant from SWI - Toronto ON. May 2015 - March 2016

Development of solutions for Risk Data Aggregation and Reporting Liquidity Metrics on a daily basis to generate complete, accurate and timely liquidity risk information to meet regulatory compliance. Technologies used: SQL Server 2012 & .NET .

  • Requirement gathering for data acquisition and staging to SQL Server DB from valuation engine.
  • Designed and developed the SSIS project, Stored Procedures and Views to migrate large amount of output data to Reporting DB.
  • Development of web application for project configuration management.
TD Treasuries

TD Securities - SQL Business Analytics

Software Consultant from SWI - Toronto ON. March 2014 - April 2015

Development of solutions to standardize data integration between front office trading systems and back office risk systems through a standardized platform and interface specification including centralized data quality validations, auditing, and data distribution. Technologies used: SQL Server 2012 & .NET .

  • Investigated and helped build the setup and deployment model for SSIS packages.
  • Developed flexible and robust processors in SSIS for reading schema independent input files from multiple source systems and transform to flat files for load in a DB2 database.
  • Developed processors for sending output files to consumer system using FTP with SSL with C# and Message Queue system.
  • Regularly communicated with business analysts for interfacing business logic to the appropriate solution and its representation in support documents.
SWI

Systemware Innovation (SWI) - SQL Business Analytics

Software Consultant - Toronto ON. July 2013 - March 2016

Involved in development of a business intelligence toolkit that provides interactive data visualizations with the ability to access relational and multidimensional database management systems through web-based interfaces. Based on Javascript, D3 library and .NET.

  • Participated in the planning, documentation, and execution of a visualization toolkit application that queries databases and cubes, and represents them in interactive data visualizations.
  • Carried out code reviews and implemented subsequent fixes and enhancements on JavaScript and C# code.
Rocket Science

Rocket Science Hospitality - Java Web SaaS Application

Software Developer - Kamloops BC. April 2012 - June 2013

Designed and developed a web based multi-tenant SaaS application for managing restaurants’ operations. Used Java, Grails Spring MVC Framework, Hibernate, PostgreSQL, HTML5, CSS3, jQuery, AJAX & TypeScript.

  • Implemented Java design patterns like Composite, Singleton, Factory and Observer.
  • Functionalities designed and coded: Secure Login & Session, Budgeting, Sales, Payroll, Data Export/Import, Reporting and Dashboard.
  • Integrated system with point of sales software and accounting packages using core Java APIs.
  • Responsible for developing entity and session beans.
  • Agile software development. Managing version control, build using ANT & application deployment on Amazon Elastic Beanstalk & Apache Tomcat virtual server.
Wholesale Furniture Brokers

Wholesale Furniture Brokers - Web eCommerce Applcation

Software Developer - Kamloops BC. Jan 2011 - April 2012

Designed and developed backend order management system for a furniture eCommerce website - Requirements gathering, prototyping, GUI Design, Process Flowcharts and Coding. Implemented the whole system in Zend MVC Framework, PostgreSQL, HTML and jQuery.

  • Implemented credit card payment system for secure site checkout using APIs from service merchant.
  • Redesigned various sections of the website for better customer experience.
  • Designed and coded modules for URL rewriting/redirecting for SEO and security.

Other Projects

Web Experience Toolkit (WET) Open Source

Web Experience Toolkit (WET): Open source code library for building innovative websites that are accessible, usable, interoperable, mobile-friendly and multilingual. This collaborative open source project is led by the Government of Canada.

View on GitHub

Credit Rating Calculation & Management - Vodafone

Developed and implemented 'Customer Credit Rating Calculation & Management desktop application for Vodafone. Technologies used: .NET, SQL Server.

Staff Training - Nature's Fare Kamloops

Developed 'Staff Training' web application for Nature's Fare, Kamloops. Used 'Windows Communication Foundation' as a web service in data access tier. Technologies used: .NET, SQL Server, HTML, jQuery.