Sql Server Project

Raymund T. Concon

** ********** *****, ******,** L4N 0Z1

Home: 705-***-**** Mobile: 416-***-**** Email: *********@*******.***

Objective: Obtain a Senior Information Systems Analyst position with a progressive company that recognizes the importance of advancement using emerging technologies.

Technical Skills:

More than eleven years Analyst/Developer experience utilizing the following:

Platforms: Windows 95/98, NT, 2000, XP, Windows Server 2003/2008, Windows 7

Programming/Scripting Languages: Visual Basic, VB.Net, C#, Visual Basic for Application, .NET Framework, VBScript, Javascript, Standard Query Language

Database: MS SQL Server 2000/2005/2008 R2(Report Services, T-SQL, DTS, SQL Query Analyzer, Stored Procedures, Triggers and Cursors, Views, SQL DMO, SQL-NS), Oracle (PL/SQL, TOAD, SQL Plus), Sybase, Centura Intersolve 32 bit SQLBase, Ventyx (Indus) PASSPORT, MS ACCESS/EXCEL 2010 (Macros, Queries, Reports), PowerShell

Report Designers: Crystal Reports, Arpeggio, VB Data Report, MS Access Reporting Tool, SQL Server Reporting Services

Other Technical Skill set: ASP/ASP.Net, ADO/ADO.Net, XML Web Services, HTML, DHTML, XML, XSL, IIS, CSS, PWS, COM/DCOM, MTS/COM+, DAO, RDO, ODBC, OLE DB, Visual Interdev, Visual SourceSafe,

MS Access/Excel VBA Macros.

Software Applications: MS Office 2010, MS Outlook 2010, Internet Explorer 8, MS Powerpoint, MS Visio, MS Project, Mercury Test Director, Citrix, MS Virtual PC, Remote Desktop, System Center Configuration Management (SCCM) Expert, BMC Remedy - IT Service Management (ITSM).

Work Experience:

Hydro One / Inergi (CapGemini) 20 Dundas St. West Toronto Ontario (Oct 2011 to June 30, 2012)

Position: Senior Information Technology Analyst

o Team Lead - Task Force Group for the Windows7/Office 2010 migration project

o Undertakes remediation of MS Office 2003 applications for compatibility with MS Office 2010 (including Access databases and complex Excel spreadsheets containing macros and VBA codes)

o Provide assistance to the deployment team in assessing the user’s applications compatibility issues with Windows 7 environment

o Diagnose and resolve issues and problems with the client’s IT systems, applications and databases involving several processes.

o Investigate causes then analyze the problem and provide detailed alternative solutions.

o Assist in the UAT of Core Business applications

Development tools used: MS Office 2010 (Excel and ACCESS (Macros, Queries, Reports)), Visual Basic, Database: MS SQL Server 2005/2008, MS Virtual PC, Remote Desktop/Assist, System Center Configuration Management (SCCM) Expert, BMC Remedy - IT Service Management (ITSM)

Ontario Power Generation / New Horizons System Solutions (CapGemini) 700 University, Toronto, Ontario (March 2006 to Oct. 2011)

Position: Senior Information Systems Analyst

o Maintained and developed software applications for the following:

Niagara River Control Center projects:

- Lake Erie Flow Forecast Model

- Lake Erie Forecast Monitor

- Real Time Data Monitor

- On-line Early Warning System

- External Export Gateway

- Water Record Accounting Metric

OPG Energy Markets - Trade and Risk Management Department projects:

- Intake-Offtake Comparator (Trade)

- Epistle and Boxology

- Short Term Profit and Loss

- Short Term Market Risk/Position Report

- MISO Transmission Outages

o Paticipated in the following migration projects:

- Windows 2000 to Windows Server 2003 migration project

- Office 2003 to 2007 migration project

o Responsible for developing and maintaining technology solutions required to address evolving business needs through assisting the business groups to define their processes. Also, working with in-house systems development and technology partners and analysts to ensure that the business and application infrastructure deliver best in class technology solutions in support of Ontario Power Generation Chief Information Office (CIO) business strategies.

o Participates in planning meetings to understand and help define scope of business requirement; conduct requirements gathering to gain a total understanding on new, and/or changed business requirements; and participate as well as define project scope and implementation strategies.

o Develop the application/technical architecture for highly complex applications including the integration of internal and 3rd party systems and applications, infrastructure components, frameworks and tools.

o Responsible for Programming and Designing, which includes the hands-on development of frameworks, application code and analytical reports, development and adherence to programming standards and the development of appropriate testing procedures. Involve in the design of applications that meet/exceed business requirements that are robust, maintainable, secure, and recoverable.

o Participate in disaster recovery activities

o Create, build, deploy, debug, and distribute Smart Device Applications for Pocket PC and Windows CE .NET platforms namely the FX Checks System of Darlington Nuclear.

Development tools used: C#, Visual Basic 6, VB.NET, ASP/ASP.NET, ADO.NET, XML Web Services, IIS 6.0, Database: MS SQL Server 2000/2005, Oracle 9i/10g, Visual Source Safe, Office Web Components 2000, XML, HTML,PDF, COM/ DCOM, MTS/COM+, Visual Interdev, MS Virtual PC, Remote Desktop, Centura Intersolve 32 bit SQLBase, Indus PASSPORT, MS Excel 2003 and MS ACCESS 2003 (Macros, Queries, Reports)

Imex Systems Inc. 2600 Skymark Ave., Bldg. 5, Suite 200 Mississauga, Ontario (Dec 2005 to Feb 2006)

Position: Senior Information Systems Analyst

Project: City of Kenora’s Web based Facility Booking and Program Registration System

o Design, develop, unit test and debug .Net applications – created user controls for the User Interface, classes and web services for the business logic tier

o Develop and maintain SQL Server 2000 database using stored procedures, triggers, views, cursors, DTS

o Fix defects using AXOSoft OnTime

o Make documentation for the application

o Provide support for users as required

Development tools used: C#, VB.NET, ASP.NET, ADO.NET, XML Web Services, COM/ DCOM, MTS/COM+, IIS, Database: SQL Server 2000, Visual Source Safe, Windows XP and 2000 Server

RCM Technologies Canada Corp., 895 Brock Rd. South, Pickering, Ontario (Jan 2005 to Sept 2005)

Position: Technical Specialist-IT Support and Development

The roles include, but are not necessarily limited to the following:

o Develop, support and maintain engineering project application and databases (Indus PASSPORT, SQL Server, MS Access 2003).

o Developed various applications such as Design Change Package Close Out (DCPCO), Environmental Qualification Completion Assurance (EQCA), Bill of Materials (BOM), Project Time Tracking System and DCPCO Revenue Monitoring System.

o Developed utility programs and DTS packages that extract, load, transfer and manipulate data from Ventyx (Indus) Passport.

o Created scripts (stored procedures in SQL Server and macros in Access) to interpret and convert the data from Indus Passport database to RCM SQL Server database for proper table and data set up.

o Secondary point-of-contact for employee technical support and assistance in maintaining the Canadian network.

Development tools : Visual Basic, VBA, SQL Server 2000, MS ACCESS 2003, Indus PASSPORT, Windows XP

Software Laboratories Inc., Manila, Philippines (Feb 2002 – March 2004)

Client :Strategiweb Inc. (a subsidiary of the Milcon Group of Companies worldwide)

Position :ASP.Net Analyst/Developer

Project :Web based Visaer Aerospace Maintenance System for JetBlue Airways (USA)

o Design, develop, unit test and debug .Net applications – created user controls for the User Interface, classes and web services for the business logic tier

o Develop and maintain Oracle9i database using TOAD and SQL Plus

o Fix defects/issues using Test Director

o Develop documentation for the application

o Provide support for users as required

o Compile and check in the DLL file to VSS.

Development tools used : Visual Basic, ASP, Javascript, COM/ DCOM, MTS/COM+, Visual Source Safe, Web Server – IIS5.1, Database – Oracle9i, Platform – Windows 2000

Client: Unilever Philippines, Inc. (UK owned company)

Position: Programmer Analyst

Project: Accounting System

o Modified the Fixed Assets and Capital Expenditure Accounting module using VB 6.0 as the front end and SQL Server 2000 as the back end. Provided support for users and maintained existing programs as required.

o Created various reports using stored procedures (T-SQL) in SQL Server 2000 and Crystal Report 8.5 that includes for both the Concern Financial and Fiscal Book : Fixed Assets Registers, Depreciation Allocation, Gross Book Value Allocation, Net Book Value Allocation, Outstanding Disposable Assets Registers, Sale and Write off Fixed Assets Registers, Quarterly Summary of Depreciation Expense

Development tools used : Visual Basic 6, SQL Server 2000, MS ACCESS 97-2000, Crystal Report

Client: Philamcare Health Systems, Inc. (AIG affiliated company)

Position: Analyst/Developer

Project: Data conversion and transfer from Aetna systems to Philamcare systems and establish system environment and enhancements during and after conversion. Member of the Technical conversion team.

o Extraction of data from A/S400 to SQL Server utilizing Data Transformation Service (DTS).

o Developed utility programs such as control report summarizing the total records extracted per data extraction and read the flat file and transfer it to SQL Server format in the designated extraction database.

o Created scripts (stored procedures) to interpret and convert the data from extraction database to production database for proper table and data set up.

o Created control report summary of total in loaded data and total converted data for data integrity.

o Validated all data elements such as date format, null and invalid values by developing an exception report.

Front end tools for Interface Module – Visual Basic 6.0, Visual Basic programming

Database Engine – MS ACCESS 97, SQL Server 6.5 and 7.0, SQL Coding Standard, Report Generation – Crystal Report, Arpeggio, Platforms – A/S400, Win NT, Win 2000, Win XP

Client: Philippine American Life and General Insurance Company (AIG affiliated company)

Position: Analyst/Developer

Project: The Budget Collaboration System (BCS) is an intranet transaction processing system designed to streamline the preparation of departmental budgets as well as efficiently analyze the entire company’s expenditures and allocations.

o Manage the existing system; the system generates daily, weekly and monthly reports that are used by investment professionals

o Developed Data Entry forms and Report modules.

o Created business (COM) objects to interface with clients.

o Created stored procedure scripts to interface with the report modules.

o Maintain, debug and modifiy other existing modules as required.

o Provided support for users as required.

Front end tools for Interface Module – Visual Basic 6.0, IE/Netscape, ASP, IIS4.0, ADO, OLEDB, ODBC, VBScript, Javascript, COM/DCOM/MTS, Visual InterDev, Database Engine – SQL Server 2000, MS ACCESS 2000, SQL coding standard, Report Generation – Crystal Report, Platform – Win NT

Relevant Education/Training:

o Web Application Development using ASP.NET

CTC Train Canada - 595 Bay Street, 3rd Floor, Toronto, ON M5G 2C2, January 17-19, 2011

o Upgrading Your SQL Server 2000 Database Administration (DBA) Skills to SQL Server 2008 DBA Skills

CTC Train Canada -, March 9 -11, 2011

o Microsoft .Net Course (Mastering Series - C#, VB.Net, ASP.Net, ADO.Net, XML)

North American School of Information Technology, 3609 Sheppard Ave., Scarborough ON, November 2005 – March 2006

o Microsoft Visual Basic Fundamentals and Development (Mastering Series)

Computer Training Labs, Manila, Philippines, February 2002

o Visual Basic 6.0 Module 2.0,

Informatics Computer Institute, Manila, Philippines, November 2000

o Local Area Network Course,

Ateneo Information Technology Institute, Manila, Philippines, August 2000

o Information Technology Top Gun Training Program,

Newtech Systems & Services, Inc., Manila Philippines, December 1999

Course content:

Program Logic Formulation

Systems Analysis and Design

RDBMS and SQL (MS ACCESS, SQL SERVER)

Visual Basic programming language

Powerbuilder programming language

Certification: Microsoft Certified Professional, JULY 25, 2003

Education: (University)

Bachelor of Science in Management and Industrial Engineering

Mapua Institute of Technology, Manila, Philippines

Graduated: March 1985

Description:

The Management and Industrial Engineering (MIE) program provides undergraduate students with an engineering education needed to understand, design, implement, and manage complex management systems upon which organizations depend.

Undergraduates combine the use of analytical methods, information systems and behavioral science to study, analyze and lead projects in interdisciplinary organizations focusing on improving the efficiency and quality of operations while reducing the costs.

LINGUISTIC SKILLS: English and Tagalog (Filipino) – fluent in speaking, reading and writing both

Contact this candidate