Gia Newman Email & Phone Number

Portsmouth, Nh, Us

Newburyport, Ma, Us

1. DBA work responsibilities: monitored and administrated about 20 database servers and near 100 databases, including database backup and restore, Maintenance Plans, Page Index or corrupt data repairs, log file management, SQL performance tuning, troubleshoot of ERP, CRM, MES applications errors, troubleshoot of issues of the SSIS packages, SSRS reports, and SQL Agent Jobs, Replication creation and maintenance, and upgrading the SQL Server 2008 to 2012 and 2014.2. ETL Development work responsibilities: created and managed almost 100 SSIS packages, including extracting, transferring, and loading data between external FTP servers and enterprise databases, between intranet file systems and enterprise databases, or between enterprise databases and different intranet application systems, such as ERP to CRM, or ERP to MES.3. .Net ASP VB/C# application development: developed Parts Search Tool for Product Marketing department to search and match inventory data, by integrating over 40 business rules into the application programming. 4. SSRS reports creation and management for Finance, Sales Operation, Marketing, and Administration departments, meanwhile, supported over 200 business reports by providing or modifying SQL query statements, Stored Procedure, or trouble shoot the issues in the SSRS report server.

Summary: 1) Solely accomplished updating MS SQL Server 2005 to 2012. 2) Successfully developed /managed BI dashboards & enterprise reporting portal. 3) Developed 20 ETL process transfer external data files into databases, or delivery data from database into file system, other database server, or network FTP Server. 4) Successfully delivered database maintenance, and copied with several hardware and network-caused database disaster recovery. 5) Provided BI OLTP and OLAP solutions integrating web applications development.

Us

1) Working in Headquarter of Uniprise/UnitedHealthCare as a IT consultant, made significant contribution to Division of Operational Controller and Devision of Business Intelligence respectively by effectively applying my skills and experiences of data warehousing and database development2) Performed complex analyses, Migrating legacy MS Access databases of Claims Processing and Metrics Reporting into SQL Server 2000/2005, and effectively improving quality data quality. Significantly shortened cycle of business reports and speeded up the process time of the reports from weekly report to daily report3) Solely and successfully taking responsibility of designing and implementing data warehouse named Performance Guarantee data Warehouse for the business unit, the data warehouse consists of about 30 Fact tables and Dimension tables4) Took over responsibilities from reporting analyst, rapidly learned and produced daily, weekly, and monthly reports to national-wide senior executives reflecting business activities over 400 million claims per year and 50 Million calls per year, by utilizing the databases and data warehousing I created.5) Took full responsibility of developing and maintaining automated ETL system for the project MyMetrics6) Implemented data quality approaches and techniques to improve data quality for all databases owned by both division of Business Intelligence and Operational Controller.

New York, Ny, Us

1) Programmed several applications using Excel VBA /Access VBA to facilitate data management, including Customer Credit Info Track, electronic Credit Approval Process, and Debt Service Automation Process. And converted Access database to SQL Server 2000. 2) The applications reduced bankers’ work load and saved considerable time they used to spend on.

Doctorate Student, Ph.D Program In Business, Marketing

Master'S Degree, Computer Science

Emba, International Marketing

Bachelor'S Degree, Economics

Continuing Education, Private Equity And China Nasdaq

Continuing Education, Investment Analysis