OBJECTIVE:

• To seek a challenging position as a SQL/OLAP BI Developer

TECHNICAL SKILLS:

Programming Languages: Visual Basic, C, C++, C#, ASP.Net, Java script, HTML, PHP, Verilog, VHDL, Tcl/Tk, Assembly, AutoIT script

Databases: - MS SQL 2005/2008 and MySQL 5/6

ETL Tools: - SSIS

BI Tools: - SSRS 2008 and Tableau 6

PROFESSIONAL EXPERIENCE:

SQL Developer/Data Analytics Application Developer

Confidential, Fremont, CA

Responsibilities:

• Designed and developed incremental ETL programs and processes using SSIS for a multi-source, manufacturing component assembly and testing SQL Server data warehouse. Data sources included flat files, Access databases and SQL Server databases. Enforced data integrity rules such as unique business keys and referential integrity across sources and defined, developed and maintained automated alerts in case of serious data validation failures. Transformation rules included de-duping, pivoting, ranking and aggregation.
• Implemented an enterprise ETL environment to track statistics including the history of files loaded, database replication status for each synchronization job, and the number of records loaded and rejected per table and business entity. Enforced universal primary keys where possible and mapped local keys to universal primary keys otherwise. The ETL environment supported multiple source and target databases.
• Implemented the enterprise master data synchronization strategy using stored procedures to consolidate enterprise data from multiple sources into a normalized master database and propagated the standardized data back to the sources using both push/pull strategies and into to the data warehouse. Tracked the history of changes to master data using triggers for auditing and troubleshooting data quality issues.
• Implemented stored procedures to incrementally update the solar component, solar array and location dimensions and incrementally load the energy production, weather and solar conditions, component testing, and array tracking fact tables (up to 3 million records added per month) . Implemented type 2 slowly changing dimension.
• Gathered and implemented analytical requirements by writing complex SQL queries and views against the star schema in the absence of a Business Intelligence solution.
• Analyze data quality issues and created weekly reports for review by upper management.
• Created recurring backup jobs to transfer data across databases.
• Synchronized database table schemas, stored procedures and data across production, development and QA environments in an agile process.
• Designed and implemented a table partitioning strategy for large, raw data tables and the archiving strategy, process and jobs.
• Updated the data model by adding derived, calculated data entities and attributes. Gathered and analyzed the requirements for complex model calculations and designed and programmed the business logic and algorithms to implement these calculations
• Analyzed execution plans to troubleshoot query performance issues and tuned queries using table and query hints. Defined and maintained table indexes by defragmenting and keeping statistics updated.
• Defined the BI Architecture and built 90% of the BI layer. Gathered requirements for and created various performance comparison OLAP reports using SSRS 2008 and Tableau 6.0.

MIS Engineer

Confidential, Fremont, CA

Responsibilities:

• Developed database queries including stored procedures and functions to support the back-end system for order processing, inventory bookkeeping and shipment tracking.
• Designed and developed ETL programs and processes using SSIS to load flat files into a SQL Server database used in the analysis and reporting of forecast and backlog of demands and for supply data. Created automated alert jobs to send status notifications after the daily ETL process.
• Implemented Config-To-Order engine to parse the orders received thru B2B gateway. Identified different servers and validated on the orders configurations. Generated automated alerts for illegal order configuration.
• Created GUI with visual C# for reporting in Visual Studio Team System environment. Implemented authorization function to control access for different user groups to the logistic system. Wrote programs that consumed the SAP system API for work order creation and closing.
• Implemented user controls to define product configurations used by the Config-To-Order engine to prevent processing of illegal orders.
• Implemented user controls for delivering orders to the shop floor for production to begin and for receiving finished goods into the system. Validation on finished good was enforced; if scanned serial number did not match the order information, it was rejected back to the shop floor.
• Implemented a process to inject hold/release/cancel commands from customer directly to shop floor after validating order status to aid production efficiency. In addition, this process provided a function for the manufacturer to override the issued commands.
• Synchronized database table schemas, stored procedures and data across production and development environments

Video Engineer

Confidential, Fremont, CA

Responsibilities:

• Scripted with AutoIt in Windows environment to automate repeatable tasks from encoding raw video with different encoders, compared encoded video with raw video objectively, and lastly loaded test results into database for reporting usage among team members
• Implemented results of evaluations and reporting tool using PHP/MySQL with JavaScript and hosting by apache2 (Internal access only)
• Analyzed video evaluation results with tools such as MTS4EA MPEG Analyzer from Tektronix
• Configured Intel Canmore platform in Linux environment to playback H.264 format videos. Implemented script to test the hardware decoder with H.264 conformance test videos. Utilized various tools to transcode video into different formats and containers, and performed extractions from containers and decoding to raw YUV format.

Server Administrator and Quality Assurance

Confidential, Milpitas, CA

Responsibilities:

• Installed and managed a Windows Server 2003. Provided Domain and Active Directory management for setting up user accounts and access controls
• Implemented a logging system for operators to record support tickets and customer inquiries. Developed a web forms system using PHP and MySQL for operators to retrieve customer history and provide quality related statistics for different types of problems.

Data Analyzer/Reporter/Web Developer

Confidential, San Mateo, CA

Responsibilities:

• Web development (online application forms and reports)
• Updated contents of webpages with HTML hard coding
• Implemented web-based forms in PHP/MySQL to collect data from online submissions with JavaScript for data validation. All forms included front end user interface to collect data and administration area to view results with requested filtering and customized reporting.