Sales Sql Server

Tenny Ing Work Experience

Tenny Ing

Software Developer/Administrator

***** ******* ****** ****,

Canyon Country, CA 91387

Telephone: 626-***-****

E-mail: abmj3e@r.postjobfree.com

Computer Software:

Software: Sql Server Stored Procedure and T-Sql, Sql Server Reporting

(SSRS) and Integration (SSIS),

Sql Analysis Services (SSAS) and Data Warehousing, Visual Basic and C#,

Visual Studio.NET, WPF, WCF,

Sharepoint,, Microsoft Access, Business Objects, Crystal Report, Excel

Pivot Table, Certified Sql Server

DBA/Developer, Web Services, VBA, Biztalk, Team Foundation Server,

Customize Dynamics GP, SL, Nav, and

AX.

Accounting Software: Customizations of Microsoft Great Plains, Solomon,

Navision, Axapta, or Dynamics GP,

SL, Nav, AX, and Microsoft CRM.

Databases: Sql Server, Oracle, DB2.

Internet Programs: ASP.Net, ASP, Java, Javascript, Vbscript.

Miscellaneous Programs: MS Excel, MS Word, Windows Servers, VPN,

PCAnywhere, GotoMeeting.

I am a certified Sql Server Dba/Developer, have over 15 years experience in

various software development, analysis, data modeling, query optimization,

and administration. I am certified from Microsoft to optimize and

administer Sql Server. I work with many development softwares, and develop

many business applications with tools like MS Access, Visual Basic, C#, Sql

Server, .NET, and Crystal Reports. Also have extensive experience in

customizing Microsoft Dynamics Accounting softwares. I understand multi-

dimensional programs like Sql Server Reporting and Analysis, and Business

Objects. I can perform complex data analysis. I use ODBC, JDBC, WCF and

OLEdb to communicate with various backend databases like Sql Server,

Oracle, DB2.

Senior Software Consultant at Capemini/WB Revenue, Prints, and

Advertisement Budgeting and Forecasting System (06/01/2009-Present):

I have been maintaining and working with the complex Revenue, Prints,

Advertisment Budgeting and Forecasting system for the business users. The

program involves using Excel Pivot tables and multidimensional Sql Server

data warehousing queries (SSAS and SSIS). I co-ordinate and maintain the

frontend and backend programs like MS Access and Visual Basic Consolidation

screens, Import and Export of SAP DB2 and EIS Oracle data with the RPA Sql

Server database, using the stored procedures and statements. I perform the

monthly Actual Load from the SAP Excel data, and verify with the business

user data. I debug the Access and Excel interface and backend VBA and Sql

Server codes for the program. I use Excel Pivot Tables to verify and

analyze the RPA data, and also understand the budgeting business rules in

the background.

I performed the data modeling and query optimization like normalizing the

Sql queries and indexes, during the creation of the Sql to Oracle database

interface.

NPA National Promotion and Adversting (7/1/2008- 12/31/2008):

Create Sql Reports (SSRS) with Visual Basic and Stored Procedures for

reports like Sales Reports by Representative, Sales Report by Client,

Receivables Aging Report, Company Class Sales Reports and many other

reports. The data come from custom Sql Server database and Dynamics GP. I

performed the data modeling and query optimization like normalizing the

queries and indexes.

Colliers & Seeley (3/1/2005-8/31/2006):

Data Integration (SSIS) to create Visual Basic XML application and Web

Services front and background programs to transfer Excel and Text data into

an accounting database. Modules include General Ledger, Accounts

Receivable, Accounts Payable, and Project Accounting. The program involves

Queuing Service, XML, Ado.Net, .Net, and other software. The program also

allows the users to select data sources and destination companies to

integrate the data files.

Fiserv.com (07/01/2008-12/31/2008):

Write Visual Basic.Net application (SSIS) and install Web Services and for

the Fiserv corporation. Configuring and debugging the Visual Basic.Net

application for connecting the Web Services with Visual Basic code. The

application works with the database servers to smoothly reading and

updating server data. ASP.Net and XML is used extensively to communicate

with the whole system. Also, work with the computer supports to address

and solve the login issues and database server connections and

configurations. The data come from custom Sql Server database and Dynamics

GP.

Hyperion Solutions Enterprise and Ledger Link (12/1/2009-1/31/2010):

I performed the Actual Load of the SAP data to the Hyperion Solutions

database, using the Hyperion Enterprise and Ledger Link. I ran the Mapping

Exception reports in Hyperion Ledger Link to enter the Local Currency and

US dollar Account Mapping data, for the preparation of loading the Actual

data from SAP. I also enter the missed Accounts in the Hyperion Enterprise

Data Entry for the load for the period. I ran various exception reports in

the Hyperion Enterprise to verify the load before actually loading the data

into the Hyperion Enterprise. The SAP data were provided by the business

users.

Warner Studio (10/10/2006-08/20/2007):

Create and update Visual Basic, Visual Studio.Net, and Crystal Report

programs to work with complex reports. Writing codes to print custom

Accounting Statements, Trial Balance reports, Sales Orders, Invoices,

Returns, and Collection Letters for sub-companies. Also debugged other

programmers work.

Panavision (12/10/2006-08/20/2007):

Create and update Visual Basic.Net programs to customize the Manufacturing

Pegging and other entry windows. To add searching criteria to the Pegging

Entry window to make it much easier to work with.

EBay Seller Website (7/1/2004-2/20/2005):

Create an eBay Seller website under Viccomp using ASP.Net with C#, VB and

third party components to automate eBay seller selling process. I

performed the data modeling and query optimization like normalizing the

tables, queries, and indexes. There is a scheduled program running in the

background on the website to bring data from eBay periodically like item

categories, css data to present graphical items on the pages, xml data for

sellers to select items. The program has all the maintenance screens and

reports to print eBay's buyer, seller, items, shipping, bidding and other

data. Accounting functions like ordering and invoicing are also automated.

It also automates processes like item listing, re-listing, revising,

feedback, second chance offering to buyers and others, using .Net and eBay

Api functions. I will provide a link to for reviewing the website as

needed.

Mailinglist Website (10/01/2003-2/6/2004)

Write an ASP.Net application with C# and VB to fill order on the webs. The

users are able to enter orders and view order list counts with a click of

the button and web menu. It uses Sql Server and Ado.Net to manage the

databases in the background.

Viccomp Website (05/01/2003-12/31/2003)

Write an ASP.Net business application with C# and VB for the service

company on the webs. The users are able to enter use demonstrations and

view company information with a click of the button and web menu. It uses

Sql Server and Ado.Net to manage the databases in the background. I

performed the data modeling like normalizing the tables.

GoAmerica (01/01/2009-03/31/2009):

Create Visual Basic programs to integrate General Ledger, Accounts

Payables, Accounts Receivable transactions with GoAmerica's home grown CRM

software. Create Sql scripts and other procedures for the integrations

also.

McManus Reporting on Lawson (08/01/2004-7/21/2007)

Write various kinds of reports in Crystal likes Gross Margin MTD/YTD

Report, Income Statement Detail MTD/YTD Report, Sales Analysis Report,

Sales Criteria Report, Sales Ledger Report and other reports using Crystal

Formulas and Grouping functions.

NationalLink (12/01/2004-Today)

Write various kinds of reports in Crystal Report likes Sales Work Order

Report, Sales Report, Sales Ledger Report and other reports using Crystal

Formulas and Grouping functions. Also Use Sub Reports to perform look-

ahead for subtotals. The data come from custom Sql Server database and

Dynamics GP.

Pacific Dental Services (10/1/2007-3/10/2008):

Create a Solomon to convert its General Ledger accounting data into Lacerte

tax program using complex Visual Basic Tools methods and codes. Creating

mapping tables to accurately convert Solomon data into the correct fields

in tax program.

Pro-Elite (10/1/2007-03/10/2008):

Integration Data to create Visual Basic XML and Web Services program to

convert Excel files into Accounts Receivables, Sales, and Accounts Payable

modules of an accounting database. Creating Visual Visual Basic front

entry for selecting batches and transaction to convert into the system.

Also enable the users to select source locations and files for conversion.

A xml screen will show the xml files during conversion also.

Using QOdbc and Integration Manager to Integrating Quickbook v2007 and

MySql data into Sql Server database.

ITS (10/1/2007-03/10/2008):

Integration Data to Create Visual Basic eConnect XML and Web Services

programs to convert Excel and text files into Accounts Receivables, Sales,

and Accounts Payable modules. Creating a front entry window for selecting

batches and transaction to convert into an accounting Sql Server database.

Signtronix (1/10/2006-3/10/2008):

Create and update Dexterity, Visual Basic, Crystal Report programs to work

with Sales Order and Manufacturing Sales Configurator. Also work with

Create Automatic Returns with the Sales modules. Adding many Crystal

reports to work with the Manufacturing and Sales module data. Also

debugged other programmers work.

Rybovich (8/1/2005-12/1/2005):

Create Visual Basic programs to automatically integrate Accounts Payable,

Project Accounting, Sales Order, and Accounts Receivables modules data for

batch posting and single posting. The programs create custom billing fees

based on users percentage, and save many manual work for the users.

Extensive analysis and testing were done to assure data are integrated

correctly and accurately.

AESS (8/1/2005-10/30/2005):

Create and update Visual Basic and Dexterity program to work with Human

Resource tables, and data to automatically update User Defined fields in

Human Resources Payroll tables. The process will be run during the

processing of payroll checks, and records necessary payroll data in a

custom table.

Kidsline's Inventory Data Center (1/1/2003-12/31/2006):

Use Great Plains Visual Basic and Dexterity to write an add-on screen to

show data from Inventory, Sales Order, and Manufacturing modules. The data

include Quantity On Hand, Quantity On Orders, Quantity Available, Quantity

In Use, Quantity Sold, Minimum Order Quantity, Maximum Order Quantity, List

Price, Quantity Period to Date, Quantity Year to Date, Sales Amount Period

to Date, Sales Amount Year to Date, Manufacturing Quote Quantity,

Manufacturing Open Quantity, Manufacturing Complete Quantity, and other

Quantities. The users just need to enter an Item Number or select it from

Great Plains' Inventory Item Lookup Window.

Kidsline's Great Plains Form Modifier and Visual Basic (VBA) (5/1/2003-

6/30/2007)

Use Great Plains Modifier to add new data fields to Sales Order Entry

window. Write Visual Basic for Application (VBA) to manage the data fields

and show various totals. The program can verify the user entries. Also

use VBA to modify Inventory Popup window to show Order Counts and Print

Counts for the users to view.

Ares Management (12/1/2007-2/28/2008):

Create customization for Solomon Voucher and Adjustment screen window, and

customize the Payables Crystal, and General Ledger Reports.

Personal Storage Canada Setup a New Company General Ledger's Data

(10/31/2003-12/31/2003)

Convert and Integration from an existing accounting program's data into

Great Plains. Using Visual Visual Basic and Great Plains' Integration

Manager, the General Ledger text files are converted or transferred into

Great Plains. The programs updated the General Journal Entry data files,

General Ledger Account file and other associated files. The programs do

many data verification tasks before actually converted into Great Plains.

Triosoft (08/01/2002-12/31/2003)

Use Visual Basic and Dexterity to write conversion programs to transfer

data from a Point-of-Sales system to Great Plains. Also write another

program to transfer data from Great Plains to a Point-of-Sales system. The

middle files are in text or ASCII format. The programs perform data

verifications in both ways.

Resource Connections (09/01/2000-12/31/2000)

Write a Microsoft Access Conversion Program to convert Great Plains and

Excel Payroll and Invoice files into Access file format. Create Analysis

Reports from the resulting data files. Create a Great Plains Dexterity

Payroll Data Entry screen as an add-on interface to Great Plains'

Receivable Management Module.

Pacific Spice Sales Order Entry Window and Reports (3/1/2000-8/31/2000)

Add new data fields to Great Plains' Sales Order Entry windows like weight,

special quantities. And then Write a Visual Basic for Application program

to update and find the totals for the added-on data fields. Also need to

update the Subtotal, Tax, Discount and Total for the SOP window screen.

Use Report Modifier to update a few SOP reports with new data fields and

totals.

Superior Readymix (10/01/1999-10/31/2000)

Write a Microsoft Visual Basic Data Conversion Programs to convert CMS

Payroll and Invoice Text files into Great Plains e-Enterprise Sql Server

files. Over thirty Sql Server files are updated in the background. Write

an Invoice Lookup Program to look up Invoice data in a Microsoft Visual

Basic.

Hasco Oil Company (01/01/2001-07/31/2006)

Write various kinds of accounting reports in Crystal likes Customer Product

Sales Analysis by Salesman for

Period/Month/Quarter/Year with Receipts, Customer Product Sales Analysis by

Salesman for

Period/Month/Quarter/Year with Receipts, Sales Analysis by Salesman by

Product Line Group, Sales Analysis by Salesman by Product Line Group for

Period with Receipts, Back Order Report, Old Customer Business Report, New

Customer Business Report, Inventory Receipt Report, Invoice Tax Report,

Commission Report, and other reports using Crystal Formulas and Grouping

functions.

Blt XML Data Converter to Convert Text Files into Sql Server Data

(04/15/2004-04/30/2004)

Convert from an existing accounting program's text data into Sql Server

2000 data using Xml files and Xml Converter. Using Visual C# as a front

program to select various text files and also to select destination Sql

Server table to convert into. The Xml Converter validates business rules

for the Sql Server files.

Signature Credit (01/20/2002-12/31/2002)

Add and update a comprehensive Credit recording program in Access Project

and Sql Server 2000. Use extensive Sql Server Transact Sql statements,

Stored Procedures, and Ado accessing methods. The program helps order

entries, generate billings, various reports. It is the main program for

the users to run their business.

Rentbox Website (10/15/2003-12/31/2003)

Fix and improve an ASP application. Use Ado and T-Sql to fix and improve

the website application for entering property management and membership

information. Also use Javascript and Vb Script for writing the web

program.

Hanson Association (01/01/2001-06/30/2001)

Use Microsoft Access to create a Quote and Purchase Order program to

automate the quote and Purchase order process. The program includes

various maintenance screens and reports for the user to edit/view and print

data. The conversion process enables the user to convert a quote into a

purchase orders and be able to work with multiple manufacturers.

Kaufman & Broad (08/01/1999-12/1/1999)

Write a Microsoft Visual program to manage property management and client

information. The program allows the users to browse and edit the property

and client information with look up window and editing screen. The program

also uses Word Automation to send data to Word to create forms to print to

the printer. The whole process is automatic.

Glacier Water Services (02/01/1998-12/31/1998)

Write an Invoice Conversion Program to convert text files from their

database to Platinum Accounts Receivable Module for Btrieve. Includes

Invoice Edit Report to check and verify the validities of the Text file,

that it reports blank and valid Client Key, Item Key, and Account Number.

Other supporting reports (e.g. Account Checking Report) are also written.

Mustek, Inc. (06/01/1995-10/31/1998)

Write various kinds of reports in Microsoft Access to present an summarize

clients' data in an organized pattern. Some of the reports are Accounts

Receivable Aging Report/Summary, Accounts Payable Aging report/Summary, AR

Gross/Net Profit Reports, AR Top Income Reports, Monthly/Yearly Income

Analysis, Credit Returns Report, Sales Return Report, Invoice Summary,

Accounts Payable Reports, Inventory Reports, Chart of Accounts Report,

Accounts Receivable Summaries, Accounts Payable Summaries and many other

reports (involved complex calculations).

Also create a Rebate Entry Program in Microsoft Visual Basic to record

their rebates received from the mail. Create various Rebate Reports to do

daily summary for the manager to review every day.

Spector Entertainment Corporation (07/01/1996-12/31/1997):

Write a cash receipt program in Microsoft Access to record decoder leased

and received from customers. The program can zoom into Customer tables to

select customers, items and accounts. Balances and Discounts are

automatically updated as data are entered. Built in error checking

mechanisms to report to the user if a questionable entry was made. Various

database tables are updated as the data are entered in the network

environment. There are also Monthly Billing Report to generate billings

and a Posting Program to post invoices generated to Platinum Accounting

System.

Interplay Production, Inc. (10/01/1993-12/31/2001)

Write various kinds of reports in Microsoft Access to present an summarize

clients' data in an organized pattern. Some of the reports are Accounts

Receivable Aging Report/Summary, Accounts Payable Aging report/Summary, AR

Gross/Net Profit Reports, AR Top Income Reports, Monthly/Yearly Income

Analysis, Credit Returns Report, Sales Return Report, Invoice Summary,

Accounts Payable Reports, Inventory Reports, Job Cost Report, Accounts

Receivable Summaries, Accounts Payable Summaries and many other reports

(involved complex calculations). Also create a Conversion Program in

Microsoft Visual Basic to convert the Invoice Data into Platinum Accounting

System.

Contact this candidate