Sql Server .Net Management Data Engineer Years Experience

NANETTE PITALIO

SUMMARY

. ** years of extensive work experience in business analysis, systems

design, programming and testing, system management and operational

support mostly for the manufacturing companies

. 6 years experience in programming with the .NET Framework using C#,

VB.NET, ASP.NET, expanded libraries such as ADO.NET and Window Forms.

. 10 years experience in Database Development using SQL SERVER. Create

table-valued, scalar-valued functions, stored procedures, synonyms for

shared databases and manipulation of XML.

. Experienced in SQL Server Data Transformation Services and SQL Server

Reporting Services (SSRS)

. Developed Client-Server Application using VB with interface to the

machine such as Wirebond Controller and OPC Siemens

. Experience in Software Development Life Cycle

TECHNICAL SKILLS

.NET Framework Visual C#.NET, VB.NET, ASP.NET,

Technologies ADO.NET, Web Services, WSDL, SOAP 1.1,

COM/COM+ Interoperability, Window Forms, ASP.NET AJAX

Windows DNA, Visual Basic 6.0, ASP, COM+, COM, DCOM,

Other XML, XSLT, VBScript, VBA, Javascript,

CSS, DHTML

RDBMS MS-SQL Server 2000/7.0/2005/2008/Express/MSDE, Oracle 8i,

MS-Access

Reporting Crystal Reports. SQL Server Reporting Services (SSRS), Cognos

Powerplay and Impromptu

Other Tools / Visual Source Safe,Microsoft Visio, Debug View, Progress v.6,

Technologies Client Access/400 for Windows 95

Operating Systems Windows XP/ 2000/NT/98/95/Vista

PROJECT SUMMARY

BDC VIRTIFY INC. 02/08- Till Date

Role Senior Software Engineer

Environment Visual C#, .NET Framework, ADO.NET, COM Interop, VBScript,

SQL Server Expresss, SQL Server Reporting Services (SSRS)

2005/2008, CSS, Visual Studio 2005/2008

International Regulatory Information System (IRiS):

Provides life science solutions for Genzyme Coporation, world's leading

biotechnology company and various governmental agencies. This is a web-

based solutions for managing complex content and compliance requirement of

Regulatory Filing, Change Management Assessment and Plans, Product

Information and Application.

Responsibilities:

. Create stored procedures, functions and triggers of Workflow Management

System, Change Assessment Processes, Regulatory Filing, Product

Application, Product Information using SQL Server Express.

. Designed reusable class libraries using Visual C# in migrating data

records.

. Developed Matrix Reports of Executive Dashboards, Change Assessment

Reports, IMAP, Regulatory Filing Reports using SQL Server Reporting

Services (SSRS) with manipulation of XML in SQL Server and capabilities

to export to PDF, Excel and other formats.

. Developed a shared database in SQL Server for IRiS-PRIMS Interface

utilizing Synonyms, Table-Valued, Scalar-Valued Functions and stored

procedures.

. Developed Product Security Import Tool using Data Transformation Services

in SQL Server. It imports and validates data from Excel with configurable

and dynamic connections. Uses SQL BCP Command to execute the stored

procedures and generate Log Files.

. Utilized XML for exchange of data between the clients existing Business

System and the Auctions Product while MSXML Library was used to parse the

data.

NXP SEMICONDUCTOR 02/06-01/08

Role Sr. Software Engg.

Environment Visual C#, .NET Framework, ASP.NET, ADO.NET, VB.NET, Ajax,

Classic ASP, CSS, JavaScript, Oracle,Crystal Report, Visual

Studio 2005

Various applications has been developed and was responsible for the entire

software development cycle that is from system requirements, business

analysis, design, development and testing, end-user training, system

management and operational support to the business.

Responsibilities:

. Applications were multi-tiered, built using OOPs principles.

. Developed a javascript in Oracle to create and send email for Factory

Messaging System.

. Designed Application Exception handling and logging mechanism, and

implemented them in the form of Class Libraries

. Responsible for creating Visual Studio.NET Setup & Deployment projects

for the installation and distribution in IIS.

. Database work involved, writing PL/SQL statements and stored procedures,

which were in turn called by the Data Access modules using ADO.NET

. Designed and developed reporting solutions for the product using Crystal

Reports, deployed it over the web by using the .NET object model of

Crystal

. Developed Online Request Approval System (hardware, software, account

shared resource, telecommunications and I.T. accountability) using C# and

ASP.NET.

. Ajax Controls and Javascripting is used in development of Conference

Booking System, Prepaid System, Security Documentation

. Developed workflow using Ajax controls in C# and Web Services for Total

Quality Management System, Electronic Specs System and Internal Quality

Audit System which is an electronic form and project registration

automation approvals.

. Developed Power Management System which automates the project tracking

and computation for effectiveness and efficiency in graphical format

using Classic ASP and Oracle as backend database.

. Developed On-line Text Messaging Application using ASP.NET

PHILIP MORRIS INC.

12/02 - 03/05

Role Software Engg.

Environment Visual Basic 6.0, VB.NET, Classic ASP, ASP.NET, SQL Server

2000, MS Access, Crystal Report, VBScript, HTML,CSS, WebChart

Bin Management System:

Tracks each bin status, blend name of cigarette, NET, Gross, Tare and Lot

Number.

Responsibilities:

. Developed class module in VB 6.0 to communicate, save and retrieved data

from the machine to MS Access Database with reference to the OPC Siemens

dll.

. Create UI in VB.NET

PSS-Paradigm Interface:

Pioneered the Primary and Secondary System. This consolidates all data from

front to back end operations of cigarette manufacturing. Analyzes and

forecasts the Product and Consumption Report and Work-In-Progress

Responsibilities:

. Built DTS Tasks, automating transfer of data from different data sources

Excel Spreadsheets, MS Access, Text Files and SAP to SQL Server Tables

. Create VBScript that reads data from Excel Spreadsheet to SQL Server

Tables

. Convert data sources to XML and displays the Product and Consumption

Report, Work-In Progress using Crystal Report 8.5

. Build SQL Agent Scheduled Tasks to run the uploading of data.

. Create SQL Scripts for Database Administrators of PSS Paradigm System

SiPASS-ERIC Interface, HR Time Attendance and Payroll Report:

Timekeeping system that computes overtime, work hours rendered by employee.

It is a report applications which displays posted and unposted overtime and

leaves of employee.

Responsibilities:

. Developed stored procedures that reads data generated in text file in SAP

from the SQL Server Linked Server

. Provides drill-down report using Crystal Report called from VB.NET.

HelpDesk Reporting System:

Graphical presentation of support request status by site, group and

channel.

Responsibilities:

. Displays the percentage of helpdesk request status per category i.e.,

Accepted, Rejected, In Progress and Waiting with the using the ASP.NET

and WebChart application.

. Designed and Implemented Run time and View time security on web reports

in Crystal Enterprise without modifying existing reports. A C++ Dll

wrapper was made for this purpose which in turn used a Visual Basic COM

component, which returned the level of security to the CE environment

when a user views or runs the report

AMKOR TECHNOLOGY 11/96 - 12/02

Role Software Engg.

Environment VB 6.0, DCOM, ActiveX Documents

ASP, SQL Server 7.0/8.0/2000, MS Access, Cognos Powerplay and

Impromptu, HTML, Client-Access/400 for Windows 95

General Electronic Die Release Order System:

Provides solutions to improve the cycle time of die-release transactions

and automate transaction for all Amkor's Die-Banking customers.

Responsibilities:

. Built COM Components using Visual Basic 6.0

. Developed OOP Business Logic Layer Module hosted in MTS Server and

retrieve/saved data from SQL Database using the Middle-Tier Layer

. Create scripts of Database Schema, Stored Procedures, Views, Back-up in

SQL Server 7.0

. Built and deployed ActiveX Document Dlls using Visual Basic in providing

a reporting tool for the customers over the web

Electronic Manpower System / ATPNet Site:

Provides on-line solution for HR to update the Personal System and at the

same time reduce cycle time in generating Headcount, Team Member Roster and

Demography.

Responsibilities:

. Developed data pulling program in SQL Server 7.0/8.0 using Data

Transformation Services and use Linked Server to read data from AS400 and

Paradox. The SQL Script and VBScript consolidates all the data on a

scheduled task to SQL Server Tables.

. Built COM Components using Visual Basic and Developed ASP pages with

VBScript

. Utilized DHTML and Javascript extensively, with the Cascading Style

Sheets specification used to control the appearance of the site.

Oven Cell Controller System:

Monitors the heat temperature profile and acts as central point of control

on sending and reading oven parameter settings to the oven controller based

from the lot transaction downloaded from the MESA System.

Responsibilities:

. Developed an Object-based application in Visual Basic 6.0 Environment.

Reads data from the oven cell controller using PLC Controller

connectivity and use COM, Active X and OPC to write and send the

parameter settings

Electronic Invoicing System:

Captures AS/4400 generated text-based Japanese invoices and transmit to

customers thru Lotus Notes Email.

Responsibilities:

. Responsible for designing, building and deploying Remote Components using

DCOM in the form of Active X Executables in Visual Basic

. Generates TPT Computation Report using Seagate Crystal Report

. Developed VB code that calls Word and Excel Object Library and Export and

saved file in PDF format.

Knowledgebase System, Spare Parts Budget System and Management of Tools and

Spare Parts System:

Responsibilities:

. Utilized DAO/ADO object Libraries inside VB classes to access data.

. Database Access System which is the compilation of engineer's skills and

expertise in troubleshooting machine. Monitors and controls expenses of

each spare parts used and tracks the items purchased. Create an OOP

modules of the inventory, usage and consumption.

. Create a time-based system using the SQL Server Scheduled Tasks to

download data from AS/400 via Client Access/400 for Windows 95 and upload

to SQL Server 7.0.

. Build On-time delivery, Assembly and Test Report using Cognos Powerplay

and Impromptu

EDUCATION

Bachelor of Science in Information and Computer Science

[Academic Excellence]

Contact this candidate