COMPUTER KNOWLEDGE:

Langages: T - SQL, SSIS, SSAS, C#, VB.NET, ASP.Net, Python, PowerShell, VB6, PL/SQL, XML, XSL, XSLT, ASP, MTS, COM+, OLAP, COM/DCOM, VBA, MDX, DAX, Win32 API, VB Script, JavaScript, C/C++, MFC and STL,, VBCE and VCCE tool kits, Perl, CSS, Crystal Report, NNTP, Visual Test, JAVA, HTML, XHTML CGI, G2, ADA, Rexx, DCL, MASM, Qbasic, JSON, BASIC Stamps and Propeller microcontroller language, Rasbery Pi Windows IoT programming, Arduino programming, Verilog, R Statistical language, and PLI.

Operating Systems: Windows, Mac OS, UNIX, VMS, VM, and DOS

Applications: SQL Server 6.5-2016, Parallel Data Warehouse (PDW), Confidential SQL Server Integration Services (SSIS), PowerBI, Tableau, Business Intelligence Markup Language (BIML), Azure Cloud Services, Azure Analysis Services, Visual Studio 3.0 - 2017, VS Entity Framework, Hangfire for C#, RESTFUL API, Analysis Services (OLAP) and Data Warehousing, Confidential NoSQL DocumentDB, COSMOS DB, MongoDB, Redis NoSQL, BMC Control-M, WhereScape 3D/RED, PowerShell, Hadoop and Cosmos big data, Windows IoT, Confidential RedShift, Confidential Web Services(AWS), IBM Data-Stage and Active Batch, PowerPivot, Windows Presentation Framework, Windows Communication Framework, SQL Reporting Services, MS Performance Point, DTS, Kimball and Bill Inmon's Data Warehousing concepts, SAP Business Suite, SharePoint Server, Date mining, Visual Studio Team System, VSS, Source Depot, Clear Case and Clear Quest, Subversion, Perforce, HTML Help Workshop, IIS, ERwin, Oracle, Siebel Analytics, Informatica, Sybase, Informix, DB2, IVR, Visual Voice, MS Insight, Wise Installation, MS Office, MS BackOffice, MS Office developer tool kit, Mathematica and Matlab, Auto CAD, Photoshop, FrontPage, circuit analyzers Pspice, and Microprocessor design.

EXPERIENCE:

Confidential, Seattle

.NET/SQL Developer

Responsibilities:

• Worked closely with Confidential Analytics team.
• Implemented Global Analytics Visualization (GAV) web page using ASP.NET MVC, RESTful Web API, Tableau and SQL server.
• Designed an internet upload file loading solution using C# and Entity Framework Core.
• Implemented HangFire job using C#.
• Worked and setup TeamCity and octopus CI/CD process. (Continuous Integration and Continuous Delivery)
• Implemented SQL Azure databases, SSIS packages, Stored procedures, T-SQL queries.

Confidential, Redmond, Washington

Database Engineer/.NET and PowerBI Report Engineer

Responsibilities:

• Worked closely with Engineering Experiences team and architected and implemented SQL Azure database and several PowerBI reports for Net Satisfaction surveying for Bing, outlook, skype and several other engineering teams.
• Analyzed surveying data and provided solutions and answers for Surveying questions.
• Extracted data from Confidential NoSQL and COSMOS DB database.
• Implemented SQL Azure databases, stored procedures, T-SQL queries.
• Design and develop on Azure cloud based back-end services.
• Implemented advance and complex statistical PowerBI reports using R Statistical language.
• Implemented SSIS ETL solutions, consolidating data from Confidential HeadTrax database and flat files from multiple data sources (Office Forms, NoSQL sources,Azure cloud, Excel)
• Implemented Power BI reports for Confidential Engineering Net Satisfaction studies and analysis.
• Implemented .NET C# code to extract Survey Data from surveying Web pages (Office forms).
• Performance tuning SQL queries and designed solutions for real time and fast reports.
• Write technical documents.

Confidential, Bellevue, Washington

Database Engineer/ Business Intelligence Developer

Responsibilities:

• Worked closely with Global Partner Payment (GPP team)
• Implemented Data Warehouse model.
• Implemented informatica ETL using Informatica PowerCenter.
• Implemented highly configurable SSIS packages for full, partial and delta ETL tasks.
• Implemented C# code to generate automated SSIS code.
• Implemented BMC Control-M scheduling for many GPP ETL jobs.
• Implemented WhereScape Data warehouse Automation solutions.
• Worked on various Bugs and maintenance tasks.
• Implemented Power BI reports.

Confidential, Seattle, Washington

ETL/Database/ .NET Engineer

Responsibilities:

• Architected and implemented Colliers SQL staging databases and data warehouses for global real estate business data.
• Architected and implemented SSIS/C# ETL solutions to extract real estate data from SQL databases and Web Services to Colliers DWs.
• Implemented C#.NET Extract tools to load data from Web services.
• Worked closely for Inserting and updating report data into MongoDB. (NoSQL)
• Implemented advance ETL and database build deployment scripts using Windows PowerShell.
• Implemented manty Stored Procedure and T SQL for reporting and ETL support.
• Implemented Tableau reports.
• Implemented Power BI reports.

Confidential, Seattle, Washington

Database/ Parallel Data Warehouse Engineer

Responsibilities:

• Architected/Implemented a Job Scheduling tool (Process Engine) for Confidential new Parallel Data Warehouse (PDW) using C# 2013. This Tool run a collection of jobs (SPs, SSIS, PowerShell, …) for SMP (Symmetric Multi-Processing) and PDW SQL servers.
• Converted ETL stored procedures to run on SQL PDW.
• Implemented informatica ETL using Informatica PowerCenter.
• Created/Converted PDW ETL procedures for Group Health cooperative data.
• Implemented SSIS packages using Business Intelligence Markup Language (BIML).
• Build ASP.NET and C# Web page to control configuration of Process engine data using web GUI.
• Used Hadoop big data servers as source in ETL process.

Confidential, Redmond, Washington

Database/ Data warehouse/ Business Intelligent/Application Design Engineer

Responsibilities:

• Designed and architected data warehouse for Supply Inventory and Operation Planning (SIOP) projects.
• Implemented SSIS/ C# / Stored Procedure ETL solutions to extract transfer and load data from Oracle and DB2 environments into SQL Server 2012.
• Implemented ETL Inserting and updating data in MongoDB. (NoSQL)
• Implemented Excel presentation layer and Excel macros and C# tools to customize and present data for the users and also to transfer data into SQL server.
• Implemented informatica ETL using Informatica PowerCenter.
• Implemented SSRS and Tableau reports. Implemented Tableau desktop and table online reports from Star schema models using SQL stored procedures and T-SQL queries.
• Responsible to setup SQL jobs and database jobs for all SIOP activities and reporting.
• Worked with SQL Azure and Confidential Redshift.

Confidential, Seattle, Washington

Database/Application Design Engineer/ DBA

Responsibilities:

• Implemented SQL Scripts and Stored Procedures to update and manage Walt Disney Taxonomy data for multiple IT departments at Confidential . Taxonomy data is used to define hierarchy for aggregation and reporting.
• Implemented ETL solutions for Taxonomy data.
• Created SSAS cubes.
• Implemented ASP.NET, C# web interface to manage taxonomy data. Web page allows activity such as insertion, update and change of hierarchy and administration of Taxonomy data.
• Implemented SSIS packages to upload and download taxonomy data into heterogeneous RDBMS environments such as Oracle, Access, XML and Excel.
• Implemented ETL and created IBM DataStage and ActiveBatch jobs.
• Worked as 24 hours support on call person for DBA tasks and ETL support one week out of each month.

Confidential, Bellevue, Washington

Database/Application Design Engineer/ DBA

Responsibilities:

• Implemented a SQL process engine for daily and weekly job activities using Stored Procedures and SSRS. The Process Engine allows stored procedures, direct T-SQL and SSIS packages to run at defined time daily or weekly. The Process Engine activities could be monitored using SSRS reports.
• Implemented SSAS cubes and Data Warehouse models Star Schema models for Supply Chain reports.
• Implemented several ASP.NET, C# web pages to control configuration of data by Confidential support team.
• Implemented smart AutoBackup and AutoRestore projects using configuration tables, SSIS and SQL Stored Procedures to automatically backup many large sized production databases and restore them in Dev and QA environments. The solution included load balancing, configured, retry features.
• Implemented ETL, SSIS and Stored procedure.

Confidential, Seattle, Washington

Database Engineer/ Business Intelligence Developer / Web Developer

Responsibilities:

• Converted legacy “Vendor Holdback” MS Access database into SQL 2008 R2 Database.
• Implemented SQL 2008 R2 ETL to transfer business data into SQL database.
• Implemented VS 2010 ASP.NET with Ajax support to build new web presentation layer for legacy VendorHoldBack MS Access forms and reports.
• Implemented C# client application using Windows Presentation Foundation (WPF) and Linq and Windows Communication Framework (WCF).
• Implemented Stored Procedure and SQL scripts.
• Architected a new “Vendor Holdback” database model.

Confidential, Bellevue, Washington

Database Engineer/ Business Intelligence Developer

Responsibilities:

• As a one person team analyzed and documented business requirement and specification for Metric Automation Project (MAP).
• Architected and Implemented OLTP and OLAP databases for Metric Automation Project (MAP) in SQL. These databases provide 130 different Metric reports for Confidential GSO teams.
• Implemented SSAS cubes for Metric reports.
• Implemented Data extraction solutions using C# and Web services.
• Designed and implemented SQL Server Integration Services ETL packages to automate and calculation GSO metric reporting data from multiple heterogeneous sources from SQL databases to Excel files.
• Designed SQL SSAS cubes and provided MDX and T-SQL support.
• Implemented SSRS reports using Stored Procedures.

Confidential, Redmond, Washington

Database Engineer/ Business Intelligence Developer

Responsibilities:

• Architected and Implemented Dev Live Analytics monitoring data warehouse. This database provides reports for several Confidential team including Dev Live Analytics team and Flash team.
• Architected and Implemented SQL 2008 data warehouse.
• Implemented advanced SQL Server 2008 Integration Services ETL packages with delta transformation features to update data warehouse.
• Implemented SQL 2008 Analysis Services cubes.
• Implemented several SQL Server 2008 Reporting Services reports using relational and cube datasets.
• Sustained SQL code for performance enhancements and corrections.
• Fixed .NET and SQL related bugs.
• Implemented advance deployment DOS batch files.
• Implemented Octopus Console deployment solutions.
• Provided SQL technical support for team members.
• Implemented Advanced SSIS .NET scripts.
• Implemented XMLA to Manage SQL Analysis Services cubes.
• Worked on MS Performance Point dashboards.

Confidential, Seattle, Washington

Database Engineer/ Business Intelligence Developer

Responsibilities:

• Implemented delta transformation logics in SQL 2005 SSIS packages to populate SnapVillage Reporting database.
• Implemented SQL 2005 reporting stored procedures for reporting applications.
• Implemented report for SQL 2005 Reporting Services.
• Sustained SQL code for performance enhancements and corrections.
• Provided SQL technical support for team members.