To attain a position where my experience and skills are utilized to best serve the needs of the company, and where I can contribute to the achievement of the company’s goals while gaining valuable knowledge and experience essential to my career development.
Over 12 years of experience in the Design & Development of Web and Client-Server applications.
Over 8 years of database developing experience in data modeling and Relational Database Systems, Database design and programming, business process analysis, SSIS, SSRS and support related to commercial databases & applications.
Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on using Intelligence Development Studio (BIDS, Data Tool), Enterprise Manager, Profiler, and SQL Query Analyzer.
Hands on experience on all phases of Software Development Life Cycle (SDLC) including requirement gathering, analysis, design, implementation and coding, testing, deployment, and maintenance on agile scrum settings.
Extensive experience in writing complex Stored Procedures, User-Defined Functions (UDF), Triggers, Views, SSIS packages, and SSRS reports.
Strong analytical, logical and problem-solving skills with ability to quickly adapt to new technologies by self-learning.
Ability to multi-task and work on several project simultaneously, excellent team player, highly motivated and looking for new challenges.
Excellent working experience with Adobe Creative Suite including Photoshop, Acrobat professional, InDesign, Dreamweaver, and Muse.
Information Systems Development Diploma, Ryerson University
In House FileNet training, Openaccess LTD.
New York City Police Department, NY Feb 2019 – Current
Sr. CRM Developer- reporting to: Computer Systems Manager, Information Technology Bureau (ITB)
The Information Technology Bureau (ITB) plays an integral role in establishing the NYPD as one of the leading counterterrorism and crime-fighting forces in the nation, developing and implementing cutting-edge technology to support strategies, programs, and procedures that promote safety, efficiency, and effectiveness.
Designed and Implemented a new payment option for Firearms Licensing department by applying customization and configuration on CRM forms, views, dashboards, ribbons, business rules, workflows, web resources, C# plugin and actions as per business requirements.
Provided Crosse functional and TDD documentation for the new payment gateway integration.
Worked in customizing Microsoft Dynamics Solutions to enhance operational and business processes by building Workflows, creating entities, attributes, entity relationships, views and forms.
Provided assistance and direction for Adx Portal and CRM application’s Solution/Configuration deployment into UAT and PROD environment.
Miami Dolphins and Hard Rock Stadium, Miami/Fort Lauderdale Area, FL Sep 2018 – Feb 2019
Sr. Application Developer / CRM Developer- reporting to: Director, Business Systems
Hard Rock Stadium is a multipurpose football stadium located in Miami Gardens, Florida, a city north of Miami. It is the home stadium of the Miami Dolphins of the National Football League.
Automated CRM Dynamics cases creation by building bulk create case ASP.NET C# LINQ based tool that run as a service to extract cases from voice of fan NFL survey.
Created and deployed customized Outlook CRM plugin ASP.NET C# based to manage CRM contacts using ASP.NET C#, LINQ, Windows forms, SQLite, REST APIs.
Applied customization and configuration on CRM forms, views, dashboards, ribbons, business rules, workflows, web resources, and actions as per business requirements.
Worked with marketing team to develop and implement marketing automation campaigns using Eloqua marketing automation platform include Email Click-Throughs, Website Visits, Form Submissions, Email Opt Out, and Email Bouncebacks.
Provided technical subject matter expertise for the technical delivery processes and implementation. This may include, but is not limited to, informal meetings with team members on technical strategy of project; attendance at status meetings with product owner entities as requested: review and involvement in all technical work product reviews.
Was part of the team who implemented 3rd party Computer telephony integration (CTI) with CRM Dynamics to enable integration for both inbound and outbound call.
Royal Bank of Canada (RBC), Toronto, ON Nov 2016 – Aug 2018
Sr. Technical Systems Analyst / MS CRM Developer - reporting to: Software development Manager
RBC Investor & Treasury Services is a specialist provider of asset services, custody, payments and treasury services for financial and other institutional investors. Serving clients from 19 countries, delivering services to safeguard client assets and maximize liquidity.
Provided customization, configuration, automation, troubleshooting and technical support of online and on-premise MS Dynamics CRM 2016/365
Interviewed system users, analyzed business processes and activates to gather business requirements and create Use Cases, Use Case Diagrams and then translated them to functional and technical requirements.
Used CRM Dynamics 365 portal to create a survey portal using incident entity form to collect customer feedback and log cases directly to CRM Dynamics in order to improve customer experience.
Worked with portal entity form, web form, steps, web role, JQuery to create portal web pages as per business requirements.
Provided re-engineering for legacy (VB.NET / SQL) applications, converting Hub System applications to new development with C# ASP.NET/SQL windows base application using Entity Frameworks, LINQ, SQL 2014, User-Defined Table Type.
Customized Microsoft Dynamics CRM 2011 UI elements, created custom web objects and implemented client-side functionalities using HTML, Jscript, jQuery, XML, OData, SOAP, FetchXML, and Ajax
Created monitoring system on CRM Online instances using Application Insights SDK by sending telemetry to the Azure Application Insights portal, where you can utilize its powerful analysis and diagnostic tools, or export the data.
Implemented enterprise application using platform services like Azure websites, Azure SQL, Azure Service Bus, notification hubs, event hubs, stream analytics, Document Db, application insights etc.
Applied RESTful endpoint web service using OData and SOAP endpoint development and external service integration.
Built CRM Dynamics custom reports using SSRS and fetchXML and Run PowerShell script for SharePoint site deployment.
Developed an application for case submission to help user to submit case to CRM 365 . Used CRM and PowerApps.
Supported more than 400 C#.NET/SQL windows base processes by redesign, monitoring, and optimize performance to insure 24/7 availability for inbound transactions data.
Mapped data from the legacy mainframe-based system HP- SM9 (HP Service Manager Software) to the CRM, utilizing the data migration wizard in the Dynamics CRM online.
Supported data conversions hub system for different heterogeneous sources such as flat file, Excel, XML, and SQL using SSIS, BCP and Bulk Insert.
Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
Used SQL Profiler for Performance monitor to resolve Dead Locks and Long running queries by checking appropriate changes to Transaction Isolation levels.
Provided direction, expertise, feedback, coaching and development to build the capabilities of more junior staff.
Worked with other key architecture roles to ensure the technology is being applied to meet the business objectives (Applications Architect, Data Architect, etc.)
Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
Involved in data migration project to build data migration strategy and process using Kingswaysoft SSIS Integration Toolkit for MS CRM which acts as an ad-on in SSIS for data migration to and from MS CRM 2013/2015.
Provided technical expertise and assist development to QA and productions teams during project execution.
CanadaHelps, Toronto, ON May 2016 – Nov 2016
Application Developer - reporting to: Chief Technology Officer
CanadaHelps is a charity that advocate for small and medium-sized charities throughout Canada and provides technology that creates easy and affordable ways for those charities to collect donations online.
Conducted Scrum Daily standup, Product backlog, Sprint Planning, Sprint Review & Sprint Retrospective meetings.
Created and Updated application database’s tables, stored procedure, User-defined functions (UDF) to provide insert, update, delete and data validation and integrity backend functionality.
Was part of the team who developed and implemented tracking system to track user’s interests using ReactJS and babel ES5, APIs to connect to server side ASP.Net and store the captured user’s statistics in SQL tables to generate SQL business reports using (SSRS)
Provided support and bug fixing to various application tiers (front-end, middle-tier, and back-end).
Open Access Ltd., Toronto, ON Jun 2010 – May 2016
Technology Manager/MS CRM Developer - reporting to: IT Manager
Open Access Limited (OAL) is an investment firm that provides money management services for group RRSPs, DPSPs (Deferred Profit Sharing Plan), DCPPs (Defined Contribution Pension Plans), and non-registered group plans.
Designed and implemented C# ASP.NET MVC, LINQ, SQL backend Member Statements - A web-based application that provides Open Access members with periodic reports on their mutual funds, term deposits (GICs), and cash positions.
Designed and developed C# ASP.NET MVC, LINQ, SQL inventory management system used by Administration to maintain and track an inventory of all company equipment and generate periodic management and financial reports as required.
Migrated from various CRM systems GoldMine, and MS CRM 2013 to cloud Microsoft Dynamic CRM including forms customization, sales cycle modification, users’ security groups and user privileges and permission.
Customized Microsoft Dynamic CRM Sales module including leads, accounts, contacts, opportunities and related custom entities according to the business process.
Provided implementation, migration, and support of Microsoft Cloud-based Solutions including Azure, MS Office, and Dynamics.
Developed and customized components, to migrate the functionality from on premise to Dynamics CRM.
Created and Deployed PowerShell scripts to create, remove, and update users account, emails, access on Azure, and MS office.
Conducted elicitation workshops to define application functional requirements, use cases, test cases, application usability requirements, forms, views, reports specifications and business process flows.
Mange Microsoft Dynamic CRM and Office 365 users’ access and permission customize user’s login default page, upload new sales lists to the CRM system and make sure the list is organized and clean to correct map the CRM lead form’s fields.
Designed and automated DTS process using SQL Server Integration Service (SSIS) to extract data from external sources into development database.
Responsible for importing and exporting data from/into various formats including CSV/TSV, XLS, XLSX, TXT, PDF.
Used Adobe Photoshop and Adobe InDesign for WireFrame, Mockup and Layer composition.
Provided periodic progress update to the Business side/project owners to ensure quality and timeliness of deliverables.
Assisted fellow developers in generating effective solution alternatives to address a wide range of business challenges.
In collaboration with other project team member and stakeholders, developed other requirements such as, Interface Requirement Document, Integration Requirement Document, Data Migration Requirement, Non-Production Environment Requirements (servers, network system, storage and processing capacities, etc.), to scope the project.
Worked closely with Audit and Compliance to ensure Applications controls are in place and up to standards
Techwheel, Oakville, ON Jan 2009 - Jun 2010
.NET Developer - reporting to: IT Manager
Monitored the progress of the project & prepare documents for management.
Attended business meetings and gathered business requirements.
Designed and implemented Views, Stored Procedures and Triggers.
Responsible for writing complex stored procedures.
Designed and automated DTS process using MS-Enterprise Manager to extract external data source into production database.
Performed database normalization.
Responsible for extracting the data based on business requirement.
Created various Functional Requirements documents like Business Process Flows, Use Case Diagrams and produced logical and physical data models using ERwin and Power Designer.
Gordian Data Inc., Mississauga, ON Jun 2007 – Dec 2008
Web Applications Developer- reporting to: Project Manager
Member of the core design and development team that implemented GoCorp online Solution (www.mybizintel.com)
Designed & implemented ADO.NET classes that connect SQL Server using direct and indirect calls and TSQL.
Designed & implemented stored procedures and triggers for automating tasks.
Assisted in design and Implementation of application user login and security.
Conducted user acceptance Test.
Review work of other team members & train junior programmers.