Senad Sadic Email & Phone Number

Mississauga

• Developed, maintained, managed, and enhanced internal software systems used for enrollment, billing, and settlement of commodity consumers (residential and commercial) in the US and Canadian energy markets• Owner and sole developer of several critical application, a few to mention:- Contract Import Management (Desktop application in combination with several web services used to import customer data contained in different file formats as well as a fully automated paperless import process using an ASP web service used by various web portals and other systems passing a high volume of data)- Credit Check application (Equifax credit report for Canadian and US consumers)- Reward Management System (Used to synchronize high volumes of data between Just Energy and vendor for marketing campaigns)• Developed and maintained existing SQL Server 2000/05//08 R2/10/12 SQL CLR, stored procedures, views, functions, triggers, user defined data types and other database objects • Worked closely with QA teams and Release Management team to facilitate quick diagnosis and resolutions for identified defects.• Assisted and directed Release Management team with deployments of new versions of software (applications, WCF and ASP Service, CLR, machine config file, etc.)• Involved in all phases of the software development life cycle (SDLC) including requirements analysis, architecture design, development, testing, deployment and ongoing support for applications and services using agile & scrum methodologies.• Created, managed and debugged various reports using MS Reporting services and MS Data Transformation Services.• Migrated several legacy MS Access applications to C# .NET applications.Technologies used: Visual Studio 2008/10/12/13/15/17 and TFS, C#.NET, VB.NET, WinForms, ADO.NET, Infragistics, LINQ, EF, SSIS, MS SQL Server 2005/08/12/14, DTC, Transact-SQL, XML, XSLT, OOP, WCF, Web Services (SOAP, HTTP POST), TFS, ActiveX, Entity Data Model, AWS Lambda, DynamoDB, Node.js

Toronto

• Customized, developed, maintained and troubleshoot client/server learning and management system. The application was developed in MS Access 97 and VBA as the front-end and MS SQL 6.5 server serving as the back-end on a Windows NT 4 environment.• Maintained databases for ETL (extract, transform and load), query, reporting, and analytics.• Developed advanced stored procedures/views using T-SQL and MS Access queries to implement business rules.• Responsible for data migration from client/server learning and management system to online based LMS.

Toronto

• Designed and developed data models by translating business requirements and relationships into logical structures.• Consolidated and automated several workflow processes using DTS packages reducing long-term cost.• Maintained databases for ETL (extract, transform and load), query, reporting, and analytics.• Automated regular data processes using Perl and XML to design, build, and test data transfers via HTTP Post.• Technologies used: Visual Basic 6, ASP, T-SQL, MS SQL Server 7 (Query Analyzer, Enterprise Manager, Analysis Tools), MS Access 2000, MS Visio, MySql 4.1, Perl and XML.• Strong experience and understanding of relational database design, modeling, programming, analytics, and administration.

Toronto

• Maintained client databases for extraction and analysis of direct marketing campaigns using VBA as front end and MS SQL 2000 server as a back-end. Utilized trigger base curriculums to target customers grouped on certain criteria to receive communication either by email or direct mail (DM).• SQL Server programming and administration. Experienced in stored procedures, triggers, and jobs. Scheduled jobs to run stored procedures that could also be triggered based upon meeting one or more criteria. Created DTS Packages to import/export data to different file formats.• Generated Crystal Reports 8.5 which included report preparation with advanced design technique, writing SQL queries to populate the data required for the report. Administered and published reports on the web using the Enterprise edition of Crystal 8.5.• Set up and programmed email templates for clients’ direct marketing campaigns using Crystal Reports 8.5 as a reporting tool where every click was tracked (email opening, url click).• Managed migration of data from Access 97/2000 to an MS SQL 2000 server.• Created forms, tables, queries, reports, writing VBA and SQL statements in Access 97/2000.• Analyzed Access 97/2000 queries in MS Excel 97/2000 and created presentations in MS PowerPoint 97/2000.

Mississauga

• Monitored and controlled output queues, jobs, and devices.• Security and printers administration, troubleshooting.• Performed scheduled backups.• Provided users desktop support, installed and configured hardware.

Diploma, Applied Information Technology

Bachelor Of Science - Bs