Project Sql Server

MS. CHING CHANG

PROFILE

Ms. Chang has over *5 years of extensive IT experience and knowledge with Web based projects. Strong project management skills including the following: delivering projects on time; finding efficiencies in projects to meet client budget or timing requirements; assessing detailed project requirements for vague or high-concept projects; developing detailed work plans; building rock solid and cohesive project teams quickly; Specializes in Object-Oriented Design (OOD) and Analysis with 15 years of experience in the software development Life Cycle Design (SDLC) process in Agile environment.

Ms. Chang’s areas of expertise are:

15 years of experience as a program analyst in C# on SharePoint and Microsoft Visual Studio .NET(2012/2015); Manage full project life cycle of design, development, delivery, and maintenance, also with editing technical documentation experience;

16+ years of experience in providing leadership and oversight to the team in fulfilling the tasks and deliverables identified in the statement of work and support software development on web and window applications in Windows Server 2003, 2008;

Strong complex technical problem solving skills in application architecture design, Object-Oriented programming and Design Patterns application in C#, VB.NET on .NET 4.5/4.6; including developing and implementing Microsoft SQL Server 2012/2015 database with performance tuning skills and design complex queries, and Angular JavaScript, JavaScript object Model, JQuery with HTML, XML programming experience, and WCF/WPF programming experience,

Creating and implementing SQL Server 2012/2015 database and Oracle database, created SQL or T-SQL statements, including SSRS, SSAS development and creating reports.

PROFESSIONAL EXPERIENCE

Project #15

Public Community Service Canada & Health Canada

Senior Programmer Analyst

January 2016 – July 2016 (7 months)

Manager: Jean Francois Fiset

Phone: 819-***-****

Email: ****-********.*****@***.***.**.**

Updated and implemented the C# web application in SharePoint, MS Visual Studio .NET (2015 framework 4.6.1 with MS Entity Framework).

Converted GUI part into WET standards required by the GoC, as well as: solving architecture problems, modifying and doing enhancements required by the client, debugging and testing the code; Source control by Team Explorer in Github.

Performed Web UI Development based on design pattern, SCRUM, and OOA. Provided maintenance and upgrades of C#/VB.NET core functionality in MVC and ensured all deliverables were released to specification with a quality WCAG 2.0/3.0 compliant product.

Opened a Test Course for online test takers as required by the client. The administrator is able to assign user IDs, collect all registered data, and send test results back after the test is completed on the PSC website. The web project is programmed in MVC pattern and connected to Oracle 11g database.

Provided advice, guidance, and recommendations on tools, techniques and compliance monitoring of WCAG, CLF 2.0/3.0, WET, web UI, meta data tagging as well as other related policies and guidelines, presenting options, design and code web pages, fix serious bugs on loading and posting back the web pages, implement the project and perform code reviews; Migrate master page, web pages into WET 3.0 standard and HTML5 including web and html controls, also the HTML code inside JavaScript functions. Migrate ASP functions into ASP.NET functions, (https://hpr-rps.hres.ca/index.php?lang=en).

Fix the problem of application architecture, implement web project (MVC), create web forms and functions. Modify the HTML5 and XML code, created web page and web controls. Create test project for the solution and create each test function on controller, model, and view for the program, test them and verify them;

The SharePoint project of Health Canada helps registered users to register latest drug products by verifying their submission and proving the registration into Canada government system.

Analysis of IT systems and IT risks within the GoC’s technology strategies and directions;

Provide advice, guidance, and recommendations on tools, techniques and compliance monitoring of WCAG, CLF 2.0/3.0, WET, web UI, presenting options, design and code web pages on SharePoint website, fix serious bugs on loading and posting back the web pages, perform code reviews;

Migrate master page, web pages into WET 3.0 standard and HTML5 including web and html controls, also the HTML code inside JavaScript functions.

Manage full project life cycle of design, development, delivery, and maintenance; Administrate SQL Server 2012 database and including updating SQL/T-SQL Statements and store procedures; Modify and fix bugs in SQL statements and create new store procedures for the project. e.g. Create one SQL statement for retrieving product information for registered user. improve the SQL statement by adding function code to include his cancelled product information, and cancelled date as clients required, and update the tables and fields, also backup the database for testing store procedures with testing data., also create reports in SSRS, implement table to connect SQL queries;

Created dynamically the table online and created functions of Add-Row and Delete-Row, Add-Column and Delete-Column; and update MS Word documents and format its content using HTML5 for posting to internet sites, ensuring all deliverable are matched to WCAG 2.0/3.0 guidelines ; implementing web services (RESTfull services), modifying XML code and HTTP handles. Implement ASP, JavaScript, JQuery, AJAX and JSON functions; also worked on MS Dynamics CRM to implement the project.

Developed Oracle Java application and implemented them. Provided data analysis, research and reporting to internal customers regarding customer data accuracy and performed data analysis. Team lead on project to develop Oracle PL/SQL database. Support, maintenance and enhancements to GUI system using Web spring J2EE with JSP, HTML, Java Beans and Java Script with Oracle DB.

Support, maintenance and enhancements to GUI system using Web spring and Maven, J2EE with JSP, HTML5, Java Beans and Java Script with Oracle DB, document all aspects of application functionality and provide Visio-based diagrams of database systems.

Implement IIS and TFS, process user groups, setup permissions and such tasks, use TFS SCRUM boards to track tasks, managed the project on Team explorer like commit, merge and review; manage Window Server on the system; Improve web security by configuration;

Project #14

Natural Resources Canada

Programmer Analyst

March 2015 – November 2015 (9 months)

Project Scope / Description: Maintain multiple web applications and projects for both internet and intranet, work on deployment of the solution to the development; debug and test the code, work with clients and QA team, customer support. Focus on Web UI Development;

Performed C#/VB.NET programming and application development (MVC architecture) based on design patterns, SCRUM, OOA ; Analyst the project requirement, create modules and functions, using different views for the front and reusing the models on the back for the view; the maintenance and upgrades of core functionality ensuring all deliverable is released to specification and WCAG 2.0 standards; Modify the structure, methods and tools also do debugging and testing on MVC project in MS Visual Studio .NET (2012/2013;); Review requirements and assist with the solution design for transitioning MS Visual Studio .NET application to functionality existing in the agency’s Oracle-based enterprise environment Documentation.

Implement WEB Experience Toolkit (WET) guidelines into existing web application and translate business requirements into functional specifications and detailed design in Microsoft Entity Framework, and in the development of WEB Services; Troubleshoot applications; Document issues and solutions when arise; Assist with maintaining in-service applications and to provide support to fixes and enhancements in order to enable the Information Management section in supporting applications and progressing project activities.

Deliver a fully functional Oracle database (SQL Server administrator duty) and reporting capacity to enable management across the sector to collaborate on quarterly performance reporting and to demonstrate their outputs, expenditures and activities against other corporate reporting requirements (risk, audit, evaluation, strategic/operational priorities) in a balanced and objective manner.

Implement Team Foundation Server (TFS) 2010/2012 – for Visual Studio, Administration Included Installing and configuring the software, project administration, users, groups, permissions and security management, notification and trigger, data tier, and proxy, ensuring standard branching and merging for each release cycle using TFS Inbuilt features.

Configure software builds and automated deploys to non-production and production environments by Team Foundation Server (TFS) administration; also support and maintain version control.

Used Oracle Designer to create data model and database;

Implemented SQL statements and store procedures, debugged and tested the tables and database;

Performance tuning of database and complex queries, improved the project performance, created reports with ETL development using SSRS and SSIS. The reports connected to the Store procedures and were formatted by the report standards;

Performed unit testing in MS Visual Studio .NET;

Performed C# code review and implemented existing SharePoint websites and C#/VB.NET programs;

Supported and maintained custom web applications using C# functions backup verification and restore requests. Built T-SQL queries for the model inside the project, tested and debugged SQL statements until they functioned successfully, then tested the function with model to view the result on the web page. Changed different input values and verified output again. Review all error messages displayed when preventing the invalid input values.

Utilized combination of AJAX, HTML4/5, JavaScript (JQuery, Date, JS Charts) and CSS, leveraged third party custom controls (Telerik, ASP.NET and MVC, AJAX Controls) to deliver responsive applications and to leverage multi-tier web-based tracking application;

Create web project based on AngularJS, Nancy, HTML5, JavaScript, JQuery, and JSon, including Excel VBA development; implement web pages and database connection, create SQL statements and functions with Oracle database, develop and execute unit testing on the test project;

Control full project life cycle of design, development, delivery, and maintenance;

Edit and update ASP, Java Script functions.

Project #13

Environment Canada

Senior Programmer Analyst

September 2014 – December 2014 (4 months)

Manager: Souleymane Toure

Phone: 819-***-****

Email: **********.*****@**.**.**

Project Scope / Description: The Database project managed the IAS indicator information within Government and shared with other departments. Online users could create and edit their submissions. The project generates monthly reports for the clients.

Performed Oracle Enterprise Manager Administration tasks on new projects and in operations; Translated project requirements and created database documents, built data models on Oracle Designer, implemented tables and fields. Created 3-tier web-based application in MVC project in MS Visual studio .NET (2012, C#, Framework, Microsoft Entity Framework 4.0/4.5, Agile environment), and managed web applications, also managed user groups in IIS.

Performed C# code review and implemented existing websites and C#/VB.NET programs;

Utilized combination of AJAX, HTML4/5, JavaScript (JQuery, Date, JS Charts) and CSS, leveraged third party custom controls (Telerik, ASP.NET and MVC, AJAX Controls) to deliver responsive applications and to leverage multi-tier web-based tracking application; Create MVC project and review them inside the MS Visual studio .NET( 2012) and created models, controls and views by the project document. And then check the functions of program, test and debug them. Check the connection with them.

Analyzed clients needs, provided a complete project schedule, work breakdown structure with effort, duration of work, skills for the tasks and costs; identified impacts, risks and provided threat mitigating options; Performed tests and implemented corrections as required.

Performed modifications on Oracle 11g database (RDBMS), created tables, indexes and foreign keys, processed all jobs on database as an administrator; created SQL statements and stored procedures,

Collaborated with business analyst to understand the business requirements and created store procedures. Tested and debugged until everything was working properly.

Created graphics on MS Excel files to support reports;

Produced reports based on store procedures; Performance tuning of database and complex queries; Work on report and ETL development using SSRS and SSIS;

oEnsured all required data was collected for the clients and was updated weekly.

oCreated SQL Statements and inserted them into the reports in order to verify report results and confirm the report files in order to ensure that new reports were generated and verified each time an old report was deleted.

Tested and implemented deliverables, used TFS, CVS/Subversion source code management tools following programming standards;

Regularly communicated with numerous users and stakeholders, collected user, technical and business requirements, translated, interpreted and clarified business, technical and functional requirements, designed and developed design specifications and IT solutions, wrote design specification documentation, system operation manuals and other technical documents including technical specifications and deployment procedure documentation using SharePoint, MS Office Professional 2010, Visio Suite 2010, UML with full project life cycle of design, development, delivery, and maintenance.

Designed advanced SQL queries in database, SQL stored procedures, triggers, scripts, cursors, jobs, linked servers using Oracle 10g, TOAD, SQL Server 2008 Database, performed SQL Server 2008 Database analysis; The store procedures are created and modified as requirements and updated for each week. When the new requirement comes by the email, the store procedures will be modified and updated into the system. The SQL statements are tested and verified using difference parameter values. Also use the execution plan to retrieve the data and analyze them.

Provide guidance, advice and recommendations on project initiatives related to database environments; Perform database security recommendations, configuration, administration and support; Developing complex queries and views in order to generate various drill-through reports, plus parametrize and link reports; Maintaining, enhancing, analyzing, configuring and optimizing database in Microsoft SQL Server 2008 by creating and updating tables, forms, complex queries, reports, and performing in depth analysis;

Converted business requirements and technical specifications, documents to WCAG 2.0 compliance such as PDF;

Project #12

Amerge Operation Inc.

Senior Programmer Analyst

February 2011 – August 2014 (3 years, 7 months)

Manager: Alona McChen

Project Scope / Description: The C# window application edited logged user input on a desktop. The web project processes the data of the latest companies and their personal information to help the progress of the firms in relation to the services provided and to report to the Canadian Government. Web users log in to complete the forms with their company information about their projects. The project is designed with CLF 2.0 in multiple languages.

Collected, interpreted and clarified business requirements and change requests implementation as well as advanced tuning of web-based distributed SOA oriented multi-tier applications and services for different enterprise level social assistance and financial applications, including GUI, business and data access layers. Using SharePoint, MS Visual Studio .NET 2010, (VB.NET, C#, ASP.NET Framework 3.5/4.0), SQL Server 2008, ASP.NET, Oracle 10g/11g, IIS, AJAX, JavaScript, JQuery, HTML, XML, CSS, applied OOA/OOP rules, created project structures (WCF), models, classes and user interface, and override and overloaded the functions; managed full project life cycle of design, development, delivery, and maintenance;

Used case analysis to further clarify business requirements, created financial transactional systems by document requirements, and built data models for the financial functions in the MVC project;

Developed web-based applications to meet Government of Canada Common Look and Feel Standards (CLF 2.0) and Web Content Accessibility (WCAG 2.0) in MVC project; Get WET document URL: http://www.tbs-sct.gc.ca/hgw-cgf/oversight-surveillance/communications/ws-nw/wet-boew-eng.asp

Interfaced with vendor applications to design forms, diagrams, manuals, programs, data files. Worked with the Commercial System Analysis and Design team on understanding business use cases and identifying problems in terms of factors such as extent of information, variety of items and format of results to be transferred and processed in new system; Working closely with the Manager, on Web Services and Information Management Systems in support of the enhancements and upgrades as described in the project overview.

Designed, coded, implemented, leveraged, developed and deployed Web Services and Object Oriented infrastructure components. Provided real time user support throughout entire project life cycle; improve the project security quality, like creating functions for verifying the query string, web links and session values, also protecting sensitive data from SQL server database.

Actively participated in re-engineering, re-design, re-factoring,

Composed and edit stored procedures and SQL scripts, created complex queries in SQL Server 2008 with T-SQL, performed in depth SQL Server 2008 database analysis in order to meet and exceed client requirements; Performed tuning of database and complex queries;

Edited reports with ETL development using SSRS and SSIS. Created reports in Report Server Project in VS 2008, modified the queries and formatted look and feel in report page, added tables to connect dataset, also added parameters in queries. Exported the reports to MS Excel files and PDF files.

Used Microsoft SQL Server Integration Services to design, create, debug, test and modify SQL statements, and create and edit stored procedures by using SSRS and SSIS; Also created database.

Actively participated in database design and development using SQL Server 2008 with T-SQL to compose and optimize stored procedures, complex queries functions and SQL scripts, define relationship constraints, database normalization, data conversion and transformation/migration rules, SSRS, SSIS;

Created class diagrams, Data Models and other required technical documentation, used Windows scripting to create batch files to get source code from CVS/Subversion, built, automatic test, and deployed the system;

Created database objects, performed database analysis, modeling/re-modeling, database optimization (up to the 4th Normal Form) and advanced tuning of Oracle (PL/SQL) packages, stored procedures, functions, triggers, indexes, integrity constrains, object models, functional dependencies, views on Oracle 10g, performed in depth SQL Server 2008 Database analysis, created complex queries, carried on administration and fine-tuning, provided continuous support throughout the entire project life-cycle; also used MS Access to create database.

Performed SQL Server administration tasks such as creating users, granting permissions, and applying new patches, and maintained server backups and security;

Performed programming, documentation, testing and debugging HTML code in HTML 4.0. Merged coding from old application with new application, implemented XML and CSS3 files, fixed form layout problems and checked form content, converted Business Objects Info View reports and working in Rational Unified Process (RUP);

Used HTML 4 to evaluate and validate web pages by W3C, WET, WCAG 2.0 standards;

Implemented the GUI portion of the project by coding ASP, JavaScript, VB Script, and Adobe Extend Script, and Excel VBA development; Performed coding of JavaScript to add functionality, validate forms, and communicate with the server; install MDM application and manage the mobile data on registered users like accessing the application and sharing data.

Performed leveraging of Team Foundation Server 2010, using Team Foundation Server 2010(TFS) for version control, bug tracking, problem reports and change requests tracking, team collaboration and tasks assignment during development stage and rollout. Tested and implemented deliverable, used TFS, CVS/Subversion source code management tools following programming standards;

Project #11

National Research Council of Canada

Senior Programmer Analyst

October 2010 – January 2011 (4 months)

Manager: Samake Mamadou

Phone: 613-***-****

Email: ******-*******@***-****.**.**

Project Scope / Description: This project captures the state of the firm on an annual basis over the course of the relationship with the NRC-IRAP. The web forms collect the latest companies and their project information to help NRC-IRAP follow the progress of the firm in relation to the services provided by NRC-IRAP and to report to government. The clients login to complete web forms for their company with information about their projects. The project is designed with CLF 2.0 WCAG2.0/WET W3C common and look-and-feel rules both in English and French. The database is connected to SQL Server 2008.

Developed, created, implemented and maintained all new stand-alone high reliability (24/7/365) web-based n-tier application system using SharePoint, Visual Studio 2010 (VB.NET, C#, .NET Framework 3.5), SQL Server 2008, ASP.NET, Oracle 11g/10g, IIS, AJAX, ASP, JavaScript, JQuery, HTML4, XML, CSS in WCF project. Developed custom workflow in C# to control the flow of approvals, escalations and resubmit requests; Update ASP and JavaScript functions and let them matching the new program in the project

Reviewed project architecture and implemented web solution according to business requirements on MS Dynamics CRM by OOA, OOP standards. Created technical documents and built application architecture, Developed Search functions, components, dynamic pages and forms with connection to the database, including WCF, full implementation of WCAG 2.0/WET for the project architecture; Did ffull project life cycle of design, development, delivery, and maintenance;

Communicated with numerous team members in order to establish the best practices, developed risk and cost estimates for system re-engineering, re-design, re-factoring and implementation, collected and clarified business and functional requirements in order to develop and deliver flawless IT solution; Created and modified setup packages, deployment and built scripts, and routines and updated them as required for version control in MS Visual Studio .NET(2010) and TFS;

Interacted with clients and produced the functional documents. Gathered information regarding the users, work flow, search customizations, functionality, appearance and permissions. Maximized leverage of the system by mapping the business requirements of existing components and provided Visio diagrams of new components needed by the business for approval of clients;

Developed web forms in HTML and XHTML according to CLF and mentored staff in the development of the web pages; implemented SQL server, and administrated the database. created reports using SSRS and SSIS; Created Report Server Project in Visual studio 2008 and added report items to project, and added tables to the reports, built queries, modified query to connect to dataset, also added parameters to it; and viewed table, saved file as PDF files.

Created groups and users, and assigned share permissions in IIS, while monitoring the Web server, Request Queues and patching the servers. Checked and fixed the permission issues. Created Web Content Management System and configured, installed and upgraded IIS services;

Conducted debugging and testing for XML files, and implemented data models. Identified structures in documents, analyzed content, such as e-commerce transactions, mathematical equations, and vector graphics, also documents;

Implemented Oracle 10g Database, created stored procedures, and updated SQL/T-SQL code. To connect the models in the web page. Each model needs to check the type format and input and out parameters. Repeat testing and debugging utill them work. The core procedures are created by requirements

Streamlined and automated a manual 10-15 spreadsheet process into a centralized SQL Server database solution using custom DTS packages; also updated database and managed data in the tables.

Created users, granted permissions, and applied new patches in SQL Server. Performed SQL Server 2008 database administration duties such as backing up, verifying and fixing the permission issues; Performed tuning of database and complex queries.

Designed flow charts, conferred with technical personnel to design and plan programs to copy and process data and print training documents in MS Visual Studio .NET;

Designed, developed and unit tested Oracle PL/SQL RDBMS programs to support the web-based applications;

Project #10

Love4u

Senior Programmer Analyst

May 2010 – September 2010 (5 months)

Manager: Aviji, Ashutosh Verma

Project Scope / Description: The project applied social media tools, like Facebook, YouTube, and Twitter in web forms and present company mission and products, also services with SQL Server database 2008 in Visual Studio 2010 in window platform. The C# web based project is an online communication application which connects to all big popular websites and internet tools. The user can log in and build up their web form and contact to other users and applied multiple languages built in Visual Studio 2008 (ASP.NET 3.0) with SQL Server 2008 in full project life cycle of design, development, delivery, and maintenance.

Performed design, implementation, development and programming of web-based and windows-based applications utilizing SharePoint, Visual Studio. Net, C#/VB.NET, JQUERY, CSS, JavaScript, ASP.NET, XHTML, HTML, XML.

Designed, developed, implemented and deployed Window Form, web-based n-tier application (including WCF) for a health-care company in Visual Studio 2010 (VB.NET, C#, .NET Framework 3.5, Agile environment), SQL Server 2008, IIS, AJAX, HTML, JavaScript, Oracle 10g. Created project architecture, built 3-tiers web application.

Developed MS Visual Studio .NET components and tools to optimize customization, interfacing with other internal engineering and business groups. Configured active directory integration for user profiles;

Utilized ColdFusion 8 tools to develop, test, produce, implement and maintain web forms, manuals, programs, data files and store procedures of application systems and sub-systems of projects;

Maintained and obtained production web environment availability and systems security, installing and configuring virtual machines in Windows environments. Debugged performance issues using SQL profiler;

Designed and developed web applications, including analyzing, designing, programming, administering, debugging, modifying, installing, and configuring IIS;Managed tools installed on the Server-side of the Intranet;

Regularly communicated with numerous users and stakeholders, collected user, technical and business requirements, translated, interpreted and clarified business, technical and functional requirements, designed and developed design specifications and IT solutions, wrote design specification documentation, system operation manuals and other technical documents including technical specifications and deployment procedure documentation using MS Office Professional 2010, Visio Suite 2010, UML;

Worked with senior management of the project and a team of

web developers (junior to senior level) on developing, implementing and maintaining web application using VB, ASP, and Javascript code,

editing and reviewing website content;

Negotiated design and functionality issues with HTML designers, e-commerce producers, and technical developers; explained technical issues and hurdles and provided site support;

Designed the data model and built the Oracle RDBMS database

Using PL/SQL and implement XML, and web services manage and administer the SQL Server; edit report in ETL development using SSRS and SSIS.

Project #9

Environment Canada

Senior Programmer Analyst

January 2010 – April 2010 (4 months)

Manager: Benedict Michael

Project Scope / Description: The Invenio IT application is a Composite Web Application of independent modules intended to support online scenarios on a range of operating systems, platforms, browsers in compliance with the Common Look and Feel (CLF) 2.0 standards and WCAG/WET compliance for Internet. It runs on top of the Microsoft platform making use of ASP.NET web forms, Microsoft Visual Studio .NET 3.5 and Window Communication Foundation (WCF) with SQL server database 2008. The MVC 4.0 project architecture applied Model-View-Presenter (MVP) design patterns, SOA principles, AJAX and other new technologies. The project is connected in Government geomantic application system with OGC standards.

Analyzed project documentation and problems outlined by systems analysts/designers and designed a flow chart and diagram of module structure of the MVC architecture using OOA/OOP, documenting factors in terms of extent, variety and format of information to be processed and transferred and

Contact this candidate