| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateJenna HuEmail: EMAIL AVAILABLE Tel:PHONE NUMBER AVAILABLEtechnology professional, specialized in database development, administration, data processing, data analysis, data visualization, data governance, data science, data SECURITY, PROJECT management with strong leadership, a fast learner, eager to embrace new technology.Proven track record of leading software development and project management. Expert in database administration, data management and software development life cycle. Specialized in multi-billion records database data processing and data security. Skilled in identifying and prioritizing problems and creating strategic solutions to meet company objective and business requirement. Excellent decision-making skill, problem solving skill and communication skill with critical thinking, detail oriented and a good team player.Expert in database design, development, database administration.Expert in data processing, data warehouse, Star/Snow Flake Schema, Data Mart, Data Lake.Expert in Business Intelligence, QlikView Report, PowerBI, Information Builder WebFocus.Microsoft SQL Server 2016 & 2019. SSRS, SSIS and SSAS, high availability.PostgreSQL 14Expert in stored Procedure, function, view, table partitioning, query optimizing, performance tuningAzure DevOps, AWS S3JIRA, Docker - Container technology, Confluence, TFSETL with SQL SSIS, DMExpress, SyncSortPowerShell Scripting, Python, C#, Net, VB/VC, C, Java, JSON, XML.RedGate, SolarWinds DPA, ElasticSearch, Secrete Server, Splunk.Windows and UNIX,Software Development Life Cycle (SDLC).PROFESSIONAL EXPERIENCEWisEngineering LLC 11/2023 9/2024Senior DBA PostgreSQL 14, Java, Liferay, Docker, DevOps, Git, Viso.Created database E/R diagram and narrative document by reverse-engineering.Conducted research and evaluation on reporting tools for a mission critical JAVA application.Developed and enhanced the process of initializing docker development environment by using PowerShell script.Performed database update to meet changing business requirement.Identified root cause for errors in production by analyzing logs, reproducing issues in a fresh installed environment, and fixed the issues.Created database object naming convention.Participated in data migration and data consolidation.Created and performed test plans and test cases in Azure DevOps.Nationwide Insurance Company/ERISK Division 10/2018 11/2023Senior SQL Database DBA (Team Leader) SQL Server, PowerShell, Python, Oracle. DevOps, Git.Lead the team support companys daily operation to ensure sensitive and important data are available, safe, secured and accurate 24X7 throughout years.In charge of database backup/restore, developed procedure for disaster recovery.Installed and configured SQL Server 2019, optimized tempdb, file groups and filesDesigned and created a SQL database replication to synchronize the reporting database to a production transactional database.Migrated database servers from SQL 2012 to SQL 2019 in Dev, Preprod and Production environment.Customized Ola framework for database maintenance tasks, including backup/restore plan, integrity check plan, index optimization.Implemented Azure DevOps pipeline by using Red Gate Flyway.Designed and developed a comprehensive F990 data model and process to integrate public data into companys system, increased business revenue significantly, using SSIS, PowerShell, Python.Designed and implemented a data archive framework which dramatically increased system response time and saved computer resource.Performed performance tuning for a companys mission critical application BAM40 which significantly shortened time for clients to get their insurance application submitted and quoted.Developed a robust ETL data transfer mechanism to synchronize data on preprod from production periodically.Performed database security management by creating roles, policies, user logins and permissions.Created database programing guideline and standard for IT department.Created and implemented replications for database tables using SQL Server Replication feature.Create and monitor jobs in third-party tool JAMS Scheduler to make sure that dozens of mission critical business jobs execute as expected.Implemented servers and database audit framework by utilizing SQL Server Audit functionality.Developed dashboards and alerts by leveraging Audit Log data and Elastic to closely watch for any abnormal activities occurred in daily operation.Used Python scripts to scan website to find information needed for the company business.Use Solar Wind DPA and Redgate database monitor to perform daily database monitoring tasks.As a team manager, built the SQL team from only 2 people to 7. Played key role in hiring new employees, including interview process and training program.Preferred Freezer Services Inc. 01/2016 -- 09/2018Business Intelligence Analyst-SQL Server, PostgreSQL, Sybase, Oracle.As a group leader, in charge of company BI group, designed and implemented enterprise BI framework. Designed and implemented BI data model and data transformation, set up enterprise data governance regulation and methodology.Worked closely with operational team and business users to optimize the business procedures, streamlined reporting system. Helped to bring the entire company's reporting system to a new higher level. Redesigned and developed Pulse reporting system which serves key report for business decision on daily basis.Lead member of the team working on Excel and Power BI dashboards for senior staff, membership department and governance.Designed and developed a centralized databank by integrating data from Oracle database, PostgreSQL database, Sybase Active Directory and other dispersed data sources by using SSIS.Gathered and analyzed business users need, designed and developed highly intelligent reports by using SSRS and Power BIRedesigned and developed Daily Sales system which is being used by 39 freezer facilities across the county to monitor daily sales activities by using SQL server technology.Performed daily database administration tasks, created backup and recovery plans, monitored database performance, and performed query tuning.Hipercept Solutions Inc. 302 West 37th Street, New York, NY 10/2013 12/2015Business Intelligence Developer-SQL Server in AWS EC2Performed database maintenance in EC2, database backup, restore, performance tuning.Participated in design, development and maintenance of commercial real estate data warehouse Hipercept model - by using SSIS, SSAS and SSRS in AWS EC2 environment.As a team leader, in charge of data governance project. Developed and streamlined the data analyze procedure. Helped client identify data issues and proposed solutions in data cleanup.Communicated with clients to collect business requirements, to present solutions, and to report project progress status.Being a leader role in system migration. In charge of creating various documents data mapping document, metadata document, deployment/migration plan, procedure and backup plan, etc.Translated business operation model into data model in databases. Completed and expended the BI architecture to reflect the business operation model accurately.Developed complex data transformation procedure to transfer data between SharePoint, file system and AWS cloud SQL Server instance, in cloud computing environment by using SQL SSIS.In charge of production deployment management, change request management.Troubleshooting issues under different environment, including development, test, stage and production.Analyze and investigate various types of data discrepancy, perform data reconciliation.Perform system monitoring, deployment and upgrade.Syncsort Inc. 50 Tice Blvd, Woodcliff Lake, New Jersey 02/2013- 9/2013Software EngineerPerformed technical support to DMExpress an ETL tool, the companys product to customers.Took service requests from customers via phone or email on daily basis, answered questions, provided solutions, and performed trouble shooting the issues reported by customers. Hands-on ETL application development with DMExpress on different platforms.WhiteCloud Analytics Inc. Boise, Idaho (work from home office) 11/2011 9/2012Business Intelligence ConsultantAs a team member, participated in BI dashboard applications design and implementation by using SQL Server SSIS, SSAS and SSRS.Developed complex reports involving tables, graphs, drill down, and drill up functions, and interactive sub-reports by using SQL SSRS.Constructed complex MDX queries and SQL stored procedures retrieving data from cubes and tables.Created ETL process to transform data by using SQL SSIS 2008.Worked closely with clients to convert business requirement to system specifications.Heavily engaged in project management, documentation and presentation.Rockport Ltd., New York City 7/2011 11/2011Database DeveloperParticipated in developing and maintaining CMBS (Commercial Mortgage Backed Security) management application (Rockport) reporting system by using SSRS.Developed stored procedures, triggers and functions to manipulate and retrieve data in SQL Server 2008 database.Customized database applications for clients to meet their specific business needs.Piers Division, UBM Global Trade Inc., Newark, New Jersey 6/2006 7/2011Programmer Analyst (Production Group)As a key member of team, participated in development and maintenance of BI application---MyPiers, an industry leading business intelligent system by using SQL 2008.Performed ETL data transformation of millions of records of data.A key member in a dashboard application development-- the companys milestone product by using WebFocus.Developed ETL packages by using SSIS, created job in SQL Server to perform scheduled ETL process.Created data model for a reporting system.Participated in database design, creation and maintenance, created stored procedures and functions.Participated in configuration of SSRS reporting server.Participated in SQL Server SSAS cube designWork closely with customer support specialists to provide technical support and troubleshooting. Working independently to create operation procedure and other management document.TISI (USA), Inc. Staten Island, NY 8/2002 - 5/2006Software EngineerDeveloped and conducted technical support to Group-Zero Balance Service supporting system by using VB 6.0, MS Access 2000, and MS Excel. The application was to create daily and monthly reports, and to generate tickets for Group-Zero Balance customers.As a team leader, developed an inter-banking transaction reconciliation supporting system by using VB 6.0, MS Access 2000. The application was to transfer data from other offices via FTP, then to import data to UDB2 database. In charge of maintenance of the application and oversee the daily operation.Developed Reimbursement Database Management System by using SQL2000 and VB. The application is to improve reimbursement process.Worked with Cash Management Service team, performed account analysis, created reports for customers.Created User Manual and Guide of the Web Application---Cash Management System (CMS). Participated in user training and technique support.Provided technique support on Government Regulatory Reporting System, Payroll Management System and other business applications.Soft Work Co Ltd., Tokyo Japan 1998 2002Application DeveloperParticipated in the development of Telecommunication Calling/Traffic Information Management System by using C and UDB2 for a major telecommunication company of Japan (KDD). Participated in System design, module design, coding, unit test and system test. Developed Shell scripts. Designed and developed common functions and created related document.As a key developer, participated in Data Fusion software development by using VC++ and Map Object (Third party software). Participated in business requirement analysis, system design, class design, coding, unit test, and system test.EDUCATIONMS, Macro Economics (Foreign Trade), Saitama University, JapanMS, Planning Economics (Pricing), Renmin University, Beijing ChinaBS, Information Management Science, Renmin University, Beijing China |
