Sidney Bicharr Email & Phone Number

Trust Fund Management System (TFMS) The Trust Fund Management System (TFMS) is an application used to manage Indian Moneys in Trust. The responsibilities and authorities as outlined by the Indian Act allow the Minister to manage the Indian Moneys as a fiduciary (Statutory obligation of the Minister's fiduciary responsibilities to collect, receive and hold moneys for the use and benefit of Indians or bands and to manage and expend Indian Moneys in accordance with the Indian Act.) The TFMS is a sub-ledger of Oasis, the departmental financial system. The System maintains all the detailed financial information for trust accounts which arise from the Crown's fiduciary obligations towards First Nations. The system supports the Resolution and Individual Affairs Sector in fulfilling their responsibilities to safeguard over $1 billion in trust funds for First Nations and individuals. This financial information is maintained within various types (classes) of accounts for the owners of the moneys being held. There are four classes of accounts within TFMS: Band Accounts; Individual Accounts; Indian Moneys Suspense Accounts; and Special Accounts. The easiest way to picture TFMS is to think of it like a banking system. It contains both financial and non-financial (account) information. Worked with: .Net -VB/ASP.NET, Model-View Presenter, CSLA.Net, Oracle 10G, PL/SQL Developer, Enterprise Architect, Enterprise Library, User Interface Application Process Block, Test Track Pro

330 Sparks Ottawa

My task included design and implementation of software as part of a team.Designed and implemented a Notification System for the NEATS Application.Designed and implemented a reporting feature of NEATS for the dynamic generation of monthly PWI reports for the Director General using Fytek. Refactored parts of the application for maintainability and Robustness and Extensibility.Implemented a NEATS auditing feature to track important information relevant to the business requirements. Built with Visual Studio.net 2008, ASP.Net 2.0, IIS Server, XML, Design Patterns(Gang of Four), Oracle 10g-11g, Pl/Sql Stored Procedure, Sql, Sql Navigator, Beyond Compare, Visual SourceSafe, UML, Fytek, XML, HTML, Javascript, CSS, JQuery, VB.NET.

Reporting System (OWNERS || ) for release of substances to the environment. OWNERS is an on-line reporting mechanism used by Environment Canada, provincial and municipal governments and private sector organizations to collect environmental data from industry. It was developed in response to industry requests to streamline and simplify environmental reporting requirements. Duties and Work Performed as Lead Developer were: Design and implementation of software, and delegation and review of implementation tasks to in-house employees and contractors. Mentoring the permanent in-house software developers on the Invenio project by increasing their design and development capabilities with Microsoft technologies. Heavily involved in the database design and its updates which included proper normalization techniques. Work with the project manager to estimate development efforts and realistic task deadlines. Transitioned to Team Foundation Server (TFS) as our source control tool. Worked with the Single Window infrastructure team to consume web services that expose data from our central data repository as our second data store.. Provided internal demos to the managers and subject matter experts for the Invenio project. Properly documented design decisions, implementation and any design changes in the project technical document.•Organized and participated in architecture/design workshops with co-workers•Evaluate and solve, implementation and design issues relating to Architecture development technologies: Worked with: .Net 3.5 -C#/ASP.NET, Model-View Presenter, Microsoft Entity Framework with EFExtensions, WCF(Windows Communication Foundation, Microsoft Unity (Dependency Injection), SOLID - Agile and OO Design Principles, Visual Studio 2008, Visual Source Safe, Continuous Integration -CruiseControl.Net, Sql Server 2008, Object Oriented Programming, Agile, Linq-to-Sql(Entity framework)

Architected and implemented a three-tier web application called Managex to automate warranties on components for medical equipment used by various hospitals to meet scalability and performance requirements. The database schema was created and modified using Case Studio and normalization techniques were also applied for robustness. Implement query design, stored procedures and migration scripts for projects in Pl/Sql. Organize meetings with quality assurance testers for transfer of information and testing procedures. Wrote Pl/Sql package for the core evaluation of Warranties. Mentor new employees on how to write efficient code using good design patterns and programming standards. Used Object Oriented Programming in C# for implementation.Built with Visual Studio.net, C#.NET, ASP.Net 2.0, IIS Server, XML, Design Patterns(Gang of Four), AJAX, Web Services, Oracle 10g, Pl/Sql, Case Studio, Tortoise SVN, UML, XML, HTML, DHTML, Javascript, CSS, N-Unit. Architected and implemented an e-commerce website for a start up company called Pull Muds Website was designed as a three tier application. Designed and implemented a robust database schema with normalization techniques. Designed and implemented data access layer which included the required SQL queries and stored procedures used in the application. Designed and implemented the UI and the business logic layer for scalability to meet web server scalability and performance requirements. Took advantage of the latest VS 2008 controls and also designed custom web controls that were used for the website.Built with Visual Studio.net, C#, XML, COM, Design Patterns, Gang of four Design Patterns, UML, XML, MS SQL Server 2005, N-Unit, AJAX, T-SQL, IIS WebServer, Web Services.

Heavily involved in the full SDLC of ATS C2App for SR 1, 2, 3 and 3.1 of Battle-View using MIP standards. Our team used Extreme programming rules for the successful completion of Battle-View SR1. My responsibilities range from project planning, feasibility study (prototyping), System analysis and requirements definition, System design and implementation. All code was properly unit Tested using N-Unit. Wrote Stored procedures used for inserting, retrieving and deleting data from the SQL Server 2005 database. Draw software design diagrams using UML standard from requirements. Implementation was executed using the most efficient Software patterns, high quality coding standards integrated with N-unit test cases and excellent code review mechanism. Microsoft .NET Common Language Runtime (CLR) and Framework provide the common runtime environment for Battle-View. Rational Clearcase and Clearquest were used to check-in and keep track of code and track software bugs (SPRs). Microsoft SQL Server 2005 was used as our latest ODB to use and implement the data model (implemented by CGI). Built with Visual Studio.net, C#, XML, COM, Design Patterns, ODB, Microsoft SQL Server 2005, Rational Clearcase, Rational Clearquest , Gang of four Design Patterns, UML, T-SQL, XML DOM, DTD, XPath and XSLT, Microsoft Office Development Libraries used for Automation, DSL Client.

Developed an online Video Store called Star Entertainment as a consultant for Amin Technologies using Macromedia-fireworks, ASP.Net and custom web controls. Created a database using Microsoft SQL Server and I used Ado.Net technology to access and retrieve data from the database. Tools used were Visual Studio.net, ASP.Net, XMl, Design Patterns, Microsoft SQL Server, ADO.Net, UML,XML Developed a website for a Non Profit Organization called ‘International Medical Relief Association’. Integrated the website with MySQL database. Developed the shopping cart and secure donation processing, with a control panel for the page configurations. The technology used was PHP/MySQL database, Javascripts. Worked on a contract in which I designed and implemented a company website www.oreglun.com with the use of Java Server Pages (JSP), Hyper Text Transfer Protocol (HTTP), Enterprise Java Beans(EJB) With Integrated development Environments such as Eclipse, Dreamweaver and Borland J-Builder. Personally modeled the algorithm using (UML) for the website and implemented it from the client interface to the backend Server using Apache tomcat web-server. Used MySQL database with SQL queries and JDBC-ODBC for data manipulation. Used HTML, DHTML, CSS, Java script. The technology used was JSP/MySQL database,UML, Borland J-Builder, Eclipse, Dreamweaver, Javascripts, Flash, Apache Tomcat, HTML, DHTML, CSS, Java script,SQL.