Sql Server Power Plant

Jiping Wang – Software Engineer

San Ramon, CA ***83 903-***-**** **************@*****.***

Profile - https://www.linkedin.com/in/jipingwang/

QUALIFICATIONS & SKILLS

10+ years’ software development skills using C#, SQL, LINQ, HTML, XML, JavaScript, Node.JS, CSS, Java. Good understand of .Net Framework/EFCore, NHibernate; good knowledge of OOP design patterns, data structures and algorithms; asynchronous, multi-threading programming experience.

Microsoft Certified MCPD, hands-on projects using Visual Studio with .NET Framework 2.0/4.0/4.5 to develop Web and WinForms desktop and ASP.NET MVC/Web API applications, and Restful services, Razor syntax, ADO.NET or Entity Framework OR/M model for N-tier application or micro-service.

HTML5, CSS3, JavaScript, and frameworks/libraries of Bootstrap, jQuery, AngularJS/Angular 2+ and libraries to build web front-end MVC, responsive, single page application (SPA) applications.

Experience in SQL Server database of stored procedures/functions/views/CLR UDF, T-SQL query optimization, database partitioning, index optimization, familiar with SQL Server string, time functions, window functions, pivot/unpivot operations. Knowledge of SQL BI stack, SSIS, SSRS, SSAS components.

Knowledge of Microsoft Azure Cloud services of Azure Fabric, Table/Blob storage service, Azure App Services, Deployment, Monitoring and App Insights.

Amazon Certified AWS Solution Architect Professional and DevOps Professional; familiar with AWS cloud core services, EC2, S3, RDS, CloudFormation, SQS, SNS, CloudWatch, Knowledge of virtualization, container, Lambda serverless services and continuous delivery pipeline on AWS cloud.

IBM Certified Cognos BI Solution Expert, knowledge of statistical analysis, predictive analysis/machine learning, ETL data integration.

Familiar with IDE tools Visual Studio, Eclipse and develop and debug skills; Visual Studio Team Foundation System (TFS), Git/GitHub for source control, JIRA.

Employment History

Pugna Technologies, Iowa, IA May 2016 – Current

Web Developer

Work with the project manager to draft Online Interview Project high level Product Requirement documents, to provision the hardware and development resource in Project Charter document;

application architecture using 3-tier (Web + App + Database) distributed and cloud-aware structure; develop Consume-UI using ASP.NET Core MVC + Razor Pages; develop Business-UI using Web API + Angular for SPA; design Code-First model with Entity Framework Core to persisted data to SQL Server database.

Setup Dev and Test environment using Visual Studio Team Service to manage code (Git-engine), setup AWS Redis as Session service for the application cluster, set up SQL Server as database server, define and build ASP.NET Core Docker container image.

Develop common modules, Authentication and Authorization module to manage user registration, identities, and external user accounts from Facebook, Google Accounts, etc.; Coding Convention document; XUnit for testing;

Technical Trainer for Ames IT Solutions

Technical training of AWS Introduction about core services, EC2, S3, RDS, CloudFormation, SQS, SNS, CloudWatch, etc.

Technical training of ASP.NET Web Development and C# programming basics – Introduction of C# language, Class, Interface, Generics, data structure.Net Framework ORM, Visual Studio.

Part IT management, setup business email, document, calendar system using Google G-Suite; Migrated websites from Godaddy to AWS Beanstalk service.

AsiaInfo International, Sep. 2012 – April 2016

Developer on Coal Mining Data Center Project, China

Designed system architecture in coal mining monitoring data center project to consolidate real-time data from 35 data sources to the data center, cache data in memory, save data to the SQL Server database and provide multiple methods to present data as lists, excel, charts formats.

Developed Data Transformer module using WinForms(C#) multi-threading technology to convert, clean data, and to persist data to SQL Server for querying, to cache data in .Net objects for real-time dashboard and alerts.

Implemented Ajax style real-time monitoring dashboard using ASP.NET Web Forms and JavaScript, ActiveX chart object.

Built web services for other applications using .Net 4.0 WCF, ADO.NET objects, such as Data Adapter, Command Builder, Data Reader, and Dataset.

Supervised the software group, mentoring and training junior members.

Senior BI Developer on Telenor Optimus Prime project, Europe (Denmark and Hungary)

Led Business Analytics requirement analysis, working with key stakeholders to analyze their analytic requirements of KPIs and DataMart definitions. Setup BI Application with Microsoft Active Directory (AD) as LDAP source to implement Single-Sign-On(SSO).

Conducted Data Modeling, responsible for low-level highly normalized atomic layer and high level de-normalized dimensional layer of the Data Warehouse schema. Improved the data warehouse data model to align with TM-Forum telecommunication industrial standards.

Frontier Consulting Inc. Boston, MA June 2010 – July 2012

Developer at Massachusetts Department of Education

Modeler, responsible for design dimensional data model using IBM Cognos Framework Manager, the model supporting business users to do ad-hoc query in a simple drag-and-drop way.

Cognos security policy designer, responsible for design Cognos authentication/authorization policy and data level security policy, to ensure absolute data security in system level, report level.

Realized security vulnerability in Legacy system and gave safe solution. Developed a Cognos Custom Java Authentication Provider module that integrated Cognos API seamlessly with corporate authentication source to implement single-sign-on(SSO) in a real-time way.

Designed reporting security policy in design and administration phases. Report Author, responsible for authoring the reports, burst batch reports.

System Administrator, responsible for data warehouse system administration, monitoring system healthy, using auditing reports, dashboard; upgrades Cognos from version 8 to 10.

Beijing ChangCheng M&C Inc. June 2000 – July 2008

Windows Application Developer - Coal Mine Monitoring & Controlling System project, to Design and develop components for a MIS software product devices management in power plant industry, using .Net WinForms, Microsoft SQL Server database and FastReport for reporting.

Windows Application Developer – in Power Plant Management Information System project, to develop components for a MIS software product devices management in power plant industry, using Borland Delphi/C++ Builder, Oracle database system and FastReport for reporting.

ASP Web Developer – in HSE Management System project, to design and develop web application providing services nationwide in China in oil production industry, using Visual Studio InterDev, classical ASP with Dreamweaver and Microsoft SQL Server database, Enterprise Manager, SQL Profiler, Visual SourceSafe, Windows Server, IIS.

CERTIFICATES

MCPD (MCSD): Microsoft ASP.NET Developer

AWS Certified Solutions Architect - Professional

AWS Certified DevOps Engineer - Professional

IBM Certified Cognos BI Solution Expert

EDUCATION

09.2008 – 05.2010

Master of Science in Physics, University of Massachusetts, Dartmouth

09.1996 – 07.2000

B.S. in Physics, University of Science and Technology Beijing

Contact this candidate