| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateYang, RuijuStreet Address PHONE NUMBER AVAILABLE EMAIL AVAILABLEPROFESSIONAL SUMMARYDatabase development skill: Expertise in SSMS (SQL Server Management Studio), ETL tools, T-SQL query, Business Intelligence tools SSIS (Integration Services), and SSRS (Reporting Services). Expertise in creating numerous, complex and various types of SSRS reports. Extensive 11 plus years database administration and database development experience. Designed, implemented, managed and maintained very large SQL Server (2005-2020) databases, security, performance, database analysis and programming, backup to ensure the database integrity.Web application development and project management skill: Over eight years software lifecycle development experience as Senior Application Developer in ASP.net, C# and VB.net. Delivered a series of software applications including web applications, window applications, web services and 3rd party software customization.Working experience skill with customers, coworkers and vendors: Analyzed and developed business solutions to meet customers quality standards. Detail-oriented and collaborative IT professional to be able to recognize changing needs and effectively modify systems while maintaining work flow for seamless transitions.Proven problem-solving skill: Disciplined with a strong work ethic. Managed multiple complex projects. Strong business and technical vision work with customers to solve problem and deliver projects on time.Active communication skill: Highly self-motivated with positive communication and working relationships at all business levels. Engaged listening, managed stress in the moment, explained effectively, communicated ideas and bridged the technology to business.TECHNICAL SKILLSLanguages: ASP.net, VB.net, C#, Web Services, T-SQL, VB, C/C++/VC++(MFC), ASP, Java, Javascript, VBscript, CGI, HTML,CSS, XML,XSLT, ADO.Database: Microsoft SQL Server 2000/2005/2008/2012/2018/2020, MS Access, Excel.ETL Tools: SQL Server Integration Services (SSIS)Database Tools: SQL Profiler, SQL Query Analyzer, SQL Management Studio, DTS Import/Export, SQL Agents, SQL Jobs, Visual Source Safe and GitHub source control.Reporting Tools: SQL Server Reporting Services (SSRS), Crystal reports 8.0/9.0Development Environments: Microsoft Visual Studio 2003/2005/2008/2010/2012/2019. Microsoft Visual Studio Business IntelligencePROFESSIONAL EXPERIENCESSQL Server (ETL/SSIS, SSRS) Data/Database Report DeveloperComputer Services in Lincoln Public Schools, Lincoln NE 05/2016-presentResponsibilities:1. Working on SSMS and Microsoft Visual Studio. Developing the complex query, stored procedures, user-defined functions, triggers, and views per requirement using T-SQL, linked server, CTE, temp table and dynamic SQL.2. Writing various complex reports, drill down reports, linked reports, sub reports, matrix, charts, flat file and data driven subscription reports using SSRS and SSIS.3. Building, publishing customized interactive reports and dashboards, reports scheduling using SSRS or SQL agent job.4. Working extensively in performance tuning, multi-tasking, optimizing queries and strong in problem-solving skills.5. Performing documentation for all kinds of reports and SSIS packages.6. Self-motivated to accomplish tasks independently or work with team together.Senior Data/Database AnalystIT in Nebraska Department of Banking and Finance, Lincoln, NE: 04/2015-05/2016Responsibilities:1.Update Department of Banking and Finance website information with generated data information from database using T-SQL.2.Develop and customize web application reports, SSRS reports and Access reports using complex T-SQL, SSIS, SSRS and Visual Studio. Reports were published and sent to users from visual studio or published on 3rd party software application.3.Change the employee timesheet system totally to new concept. Create a standalone C# .net Windows application for employee billing document (timesheet).4.Work with vendor to resolve 3rd party software issues and make suggestions effectively.5.Plan and coordinate about the procedure of SQL server upgrade to 2012 version and help solve the issue of SSIS package.6.Mentor and help troubleshooting the problems with database, reports, VB6 application, vendor application, department of banking website, etc.7.Provide IT support for the review, analysis, troubleshoot and repair database issues, also include end users computers problem.8.Research, develop and deploy innovative productivity applications such as working on database warehouse solution.9.Initiate and develop OBIEE reports.Senior Database AdministratorBTSD (Business Technology Support Division) in Nebraska Department of the Roads, Lincoln, NE: 04/2009-04/2015Responsibilities:1.Database administration and maintenance, performance monitoring and tuning, backup and recovery database across the entire database application infrastructure. Maintain the integrity and consistency of database.2.Database implementation and design. Install, upgrade new SQL Server and DBMS. Migrate, convert and replicate database among SQL Server 2005/ 2008/ 2012, DB2 (Mainframe), and ACCESS.3.Database Security Management: Users, Roles, Profile, and Groups.4.Design, debug, implement and tune of queries, triggers and stored procedures to help developer finding solutions.5.Analyze business and technical requirements and develop database applications. Work with customers to identify, design and develop business solutions for extraction, database manipulation, transaction analysis and integration of data to and from multiple data sources for the purposes of reporting, decision support and analysis of application bugs.6.Provide customers technical support for SQL client software installation, database integration, SQL functions training and desktop support, etc.7.Work with network system administrator to ensure high, overall database performance.8.Work on multiple projects database related as a data lead, such as converting crystal reports to reporting services reports.Senior Developer/ContractorRR Donnelley, Logan, UT: 09/2008-03/2009Responsibilities:1.Design, develop and implement the Material Management and Material Movement module of InfoShare System (web application) using VS 2005, C#, SQL Server 2005, Javascript and AJAX.2.Work with business manager to analyze and debug the existing system.3.Advise developers on the most efficient database designs to improve performance on the system.4.Conduct SQL server learning sessions for developers. Suggest to rework on resource-intensive queries on the SQL server by adding index, none-cluster key or monitoring the performance to find solution.5.Work with customers to understand the business working procedure and modified InfoShare system.Senior DBA/SQL Developer /Senior Software Application DeveloperBTSD (Business Technology Support Division) in Nebraska Department of the Roads, Lincoln, Nebraska: 11/2004 09/2008Responsibilities:Senior DBA/SQL Developer1.Manage, monitor and maintain MS SQL server and system performance. Make the maintenance plan such as back-up and restore the database, replication, agent job setup and scheduling, security, etc. Ensure and improve system performance and reliability.2.Develop, support, test and maintain the stored procedures, triggers, functions, and used T-SQL to implement the needs.3.Help customers to analyze the big data and provide solutions for data transfer from different platforms or manipulate the data to fix the application errors.4.Mentor the development staff on new SQL Server technology and procedures, such as new features of SQL Server 2008, Microsoft Business Intelligence Development studio and other tools.5.Database administration and database development using SQL Server 2005 Management Studio, SQL Profiler, Performance Monitor, Microsoft Business Intelligence Development Studio (Analysis Services, Reporting Services and Integration Services projects) and Microsoft Visual Studio 2003 and 2005 or write T-SQL script, VBscript.6.Support existing web applications projects, schedules, estimates and project status reports.7.Use project management methodologies to assist with planning, controlling, executing and closing projects; ensuring the balance of time, cost and scope.Senior Software Developer1.Design, implement and maintain the following web applications:a)Nebraska Highway WebCams System using C# .net. Provide users online access all live web cameras installed on Nebraska Highways. System management site allows remote management of camera information and status.b)Vertical Clearance Data Services System (VCL) on intranet using C# .net 2003 and SQL Server 2005 and DB2. Provide speedy performance and ease of use via a friendly web interface to view, update and analyze the heights and related info for Nebraska Bridges & Signals along the state highway. This system was for internal users, consultants and 3rd party software (Nebraska Truck Permit System).c)NDOR Hydraulic Data Management System (HDM) using VB.net 2003. Provide search and access to hydrology related information and reports. Allow management people to update and transfer data from DB2 to SQL database.2.Design and develop data warehouse unit site using C#.net 2005 on BTSD intranet.3.Analyze, customize and maintain 3rd party software.4.Coordinate with customers and project manager to use project management methodologies to assist with managing projects.5.Research and learn new technology to share with manager, colleagues, business partners and BTSD staff.Software DeveloperIT Department, Heritage Insurance Company, Lincoln, NE: 06/2002 11/2004Responsibilities:1.Manage, design, and implement ContraX site for clients by using C#, SQL server and Crystal Report 8.5 to provide data, reports and other web services and support them.2.Develop and transform internal site from ASP to VB.net, including debugging, tuning, testing and documentation.3.Design and implement windows-based applications for internal users using VB.net and Visual Basic, such as uploading images, XML web services and inventory control.4.Program, maintain and provide support on internal site by using ASP, Visual Basic or VB.net, including all kinds of technical support for internal users, such as creating Crystal Reports, SQL Server Reporting Services and Access reports.5.Maintain and work on MS SQL Server.EDUCATIONMasters Degree - Computer ScienceUniversity of Nebraska-Lincoln (GPA:3.8/4.0), May 2002Bachelors Degree - Biophysics and MeteorologyBeijing Agricultural University (GPA:3.9/4.0), 1988 |
