COMPUTER SKILLS:

Programming: C#, VB, Perl, T - SQL

Stat Packages: SAS, SPSS, R, Stata

Databases: Confidential SQL Server. MySQL, Oracle, Confidential Access

BI Tools: SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SAS Visual Analytics, IBM Cognos

Platforms: Windows, Unix/Linux

EXPERIENCE:

Confidential

Business Intelligence Developer

Responsibilities:

• Develop BI solutions (Oracle, SAS, Cognos) for SE Asia regional offices on a variety of projects: data warehousing, reporting, etc.
• Supply backend DB support (Oracle PL/SQL) for Java developers on various in-house applications (mobile dashboards, web based data entry UI’s etc.).
• Responsible for maintenance of existing Regional Datawarehouse (Oracle PL/SQL) as well as user support on Global BI platform (SAS).

Confidential

Database Operations Manager

Responsibilities:

• Provide SQL Server support for German based global logistics company for SE Asia region (Thailand, Singapore, India, China and Malaysia).
• Design and implement BI solutions for in-house Accounting and Freight Management System (ASP/SQL Server). Optimize existing code as well create new enhancements.
• Authored Omnibus Reporting system (T-SQL), a data warehouse used across the company for finance, performance and logistic reporting. Data updated via an SSIS package and SQL Job.

Confidential

MIS Data Analyst

Responsibilities:

• Responsible for standardization of multiple CRM servers ( Confidential NAV) across different locations for a global, high-end jewelry manufacturer..
• Rationalize back-end SQL Server DB's (2005/2008) to allow distributed querying and eventual population to data warehouse and Confidential Cubes for dynamic reporting across all business units.
• Migrate existing reports (SSRS) and stored procedures to reflect this change in architecture.
• Ensure that all business units are using the same computations and business logic when producing reports and dashboards.

Confidential

Chief Data Architect

Responsibilities:

• Performed data analysis and created database solutions for a variety of on-line/retail clients. Work mainly done while in Vietnam, as well as other client locations. Clients included:
• Architected backend MySQL databases for social networking sites HipKingdom.com and 9life.vn, as well as analyzing web traffic data (T-SQL, Google Analytics) to improve site content.Created Confidential Cubes for employee productivity and sales databases (SSAS). Modified existing Sales Tracking tool (C#, XAML, SQL Server) to add sales lead functionalty used by Finance/Client Service teams.
• The Advantage Card. Generated monthly performance reports (spending, foot fall, basketsize, etc.), as well as ad hoc reports to guage brand performance. Analysis results were used to generate eDM/SMS campaigns, which were further anaylzed in SQL Server/Access/Excel to measure campaign effectiveness.
• Created monthly performance reports on POS data (T-SQL) for loyalty programs as well as analyze effectiveness of various promotions (personal shopper lists, shelf tags, coupons). Built Confidential Cubes (SSAS) on SQL Server / Oracle databases to allow internal users to run ad hoc analyses. Converted existing performance reports from an existing reporting tool to SQL Server Reporting Services (SSRS).
• Generated monthly performance reports on theater ticket/concession sales and promotion effectiveness

Confidential

Database Programmer/Architect

Responsibilities:

• Maintained SQL Server 2008 databases for UI development team accessed via a LINQ library (C#.NET 3.5).
• Created SQL Server DB objects as needed (stored procedures, tables, indexes) .
• Employed Team Foundation Server/Visual Studio 2008 to maintain source code as well as synchronize DB schema- SQL source files.

Confidential

IT Director/ Mathematics Teacher

Responsibilities:

• Taught Calculus and Geometry to high school students at a leading international school.
• Migrated existing student information system AdminPlus (an older Windows desktop app) to an Open Source web based systemCentreSIS, employing an Apache/PHP/PostgreSQL architecture.

Confidential

SQL Server Developer

Responsibilities:

• Created a proof of concept UI to add SQL Server Reporting Services (SSRS) capabilities to an existing medical informatics system, utilizing ReportViewer .NET control (C#.NET) and SSRS .
• Performed exploratory Data Warehouse design (SSAS 2005) on existing database.

Confidential, Redmond, Washington

SQL Server Developer

Responsibilities:

• Developed SQL Server 2005 T-SQL objects (stored procedures, C#.NET CLR functions) for existing data import system.
• Web trend data was fetched from an FTP server using a custom C# utility and pushed into an Confidential Cube (SSAS).
• SQL Server Reporting Services (SSRS) used to publish data for end users.
• Employed SQL Server Mirroring and Service Broker for DB synchronization across servers.

Confidential

Access/SQL Developer

Responsibilities:

• Upgraded an Access 2003 UI (forms, reports) as well as SQL Server 200 back-end DB for a political candidate tracking application for a major Nevada law firm (developed remotely).
• Replaced existing Macro driven processing with VBA code to streamline data entry.
• Created C#.NET (2.0) UI for a Legislative Bill Tracking system for Nevada State Legislature Bills, with SQL Server 2000 back-end.

Confidential, Seattle, Washington

Database Developer

Responsibilities:

• Created middle-tier object library (C#.NET 1.1) for Call Tracking system.
• Architected back-end database (SQL Server 2000). Employed XML data type to pass multiple parameters into SQL (using OPENXML).

Confidential, Seattle, Washington

Database Analyst

Responsibilities:

• Migrated 100's of stored procedures (SQL Server 2000) to new DB schema, for Confidential of website for a major U.S.on-line retailer / department store.
• Employed VB.NET 1.1 to enumerate dozens of DTS packages and identify those necessary for migration.

Confidential, Seattle, Washington

Developer/DBA

Responsibilities:

• Provided SQL Server 2000 support for ongoing cancer research studies.
• Converted existing SAS (v8.2)/Perl processes to Access 2000/SQL Server 2000 applications.

Confidential, Bothell, Washington

Data Analyst

Responsibilities:

• Created SAS (v 8.2) scripts to produce summary Confidential for Phase-II clinical trial data.
• Used SAS macros to automate data analysis. Performed QA testing against existing statistics to validate data.

Confidential, Seattle, Washington

SQL Server Developer

Responsibilities:

• Created SQL Server 7.0 stored procedures to import sports statistics from Confidential Inc. Codebase maintained with Visual Source Safe.
• Statistics were downloaded via an FTP server on a scheduled basis with a custom import tool, then imported into SQL Server via Confidential .

Confidential, Seattle, Washington

SQL Server Developer

Responsibilities:

• Responsible for back-end SQL development (SQL Server 7.0) for a healthcare information website (later nought by WebMD.com).
• Created DTS Packages to perform maintenance tasks and identify data integrity problems. Performed DBA duties as well, such as replication and creating scheduled jobs.

Confidential, Seattle, Washington

Access Developer

Responsibilities:

• Added and modified forms and reports in an existing Access 97 application, used for utility customers issue tracking.
• Created VBA library to support this added functionality.

Confidential, Seattle, Washington

SQL Server DBA/ Programmer

Responsibilities:

• Served as DBA and Developer for a SQL Server 7.0 DB for an internet start-up company, building an on-line document archival, retrieval and digital signature service.
• Maintained DB schema with Erwin 3.5.

Confidential, Redmond, Washington

Data Analyst

Responsibilities:

• Created Data Services using VBScript and SQL 6.5/7.0 along with a customized, in-house API to publish ads on Confidential .
• Worked closely with customer service department to fill ad requests from site advertisers.