Summary

Access Database Developer: excellent computer and analytical skills. Hand on experience in MS Access Database, SQL Server 2005 maintenance and Implementation. Strong skills indesign database in MS Access ,SQL Server 2005, creating reports and executing SQL Reporting Service, Crystal Reports, VBA, T-SQL, MS Excel, SPSS and other Database report writer software tools. With advanced knowledge and technical skills in data management processes.

Education And Training
Master of Software Systems (MSS); 
Master of Business Administration (MBA); 
Bachelor of Arts (English)
Microsoft Certified Professional: Microsoft SQL Server 2005, Windows NT Server and Workstation 

Professional Experience

Confidential 
Guest Data and Analytical Services (Contractor) Jun 2011 – Jan 14, 2012

• Designed Access databases, wrote procedures and functions in modules.
• Created function and procedure to copy records to an Excel spreadsheet.
• Designed table relationships diagram and created documents.
• Created tables, forms, sub-forms, queries, reports, sub-reports.
• Created VBA to insert data from unbound form into bound form.
• Created VBA to copy selected data value on main form and sub-form to tables.
• Created VBA to delete unwanted data value on forms.
• Created Error handler to track and send out error message.
• Created VBA to roll back or commit transaction.
• Updated codes and troubleshoot errors in Access Database.
• Created database to analyze financial, marketing and sales data for DVM or GDAS group.

Confidential– ITSB (Contractor) Mar 2011 – Jun 2011

• Using MS Excel skills to organize the data and utilizing Cargill Connects to look up and identify appropriate manager for each billing group, communicating to managers list of Remedy users and tracking overall lists of users audited.
• Using VLOOKUP function to search for value.
• Created spreadsheet with formulate and charts.
• Created PivotChart Reports.

Confidential- Business Bank Support Group (Contractor) Dec 2010 - Jan 2011

• Created SQL scripts to retrieve financial data from different data sources into temporary tables
• Created crystal reports with complicated formulas codes to analyze financial data
• Created tables, views, reports in SQL Server database based on the financial data analysis requirements
• Created repots using SQL codes to compare current month balance with previous month balance in SQL Server report services
• Migrated data from MS Access, MS Excel to SQL Server database or converted data from SQL Server database to MS Access, MS Excel for reports creation purpose
• Designed MS Access database, created tables, complicated queries, reports to analyze financial data
• Created MS spreadsheet for data analysis

Confidential, (Consultant) Feb 2010 – Nov 2010

• Provided local and physical database design, implementation and management of all clinical data collection and management systems.
• Worked directly with clinical research team to gather, define, and document reporting requirements
• Created crystal reports with complicated SQL codes to analyze clinical data.
• Designed, developed, tested report solutions using Clindex, MS Access and SQL Server report services.
• Connected data sources from SQL Server database or MS Access database to create Crystal Reports.
• Edited check programming and created reports in Clindex.
• Worked with clinical research teams to define, create, validate accuracy, and maintain clinical study reports to meet business needs.
• Created procedures in forms or reports in MS Access to generate data.
• Wrote queries for data search or advanced queries to union different tables for reports analyst.
• Created VBA code behind forms, reports or in module to generate data
• Created ad-hoc reports as required by users for data analyst
• Created link data or imported data from external data sources to current database system

Confidential, (Consultant) Dec 2008 – Sep 2009

• Designed shipping database for Inventory Control and management.
• Used Business Intelligence Development Studio to create SQL report server projects.
• Deployed reports to webpage for users to use
• Designed tables, forms, reports using MS Access, VBA for clinical data collection
• Tested applications using MS Access, VBA, Visual Basic
• Created procedures in forms or reports in MS Access to generate data
• Created special reports using statistics to analyze data
• Created VBA code behind forms, reports or in module to generate data
• Created ad-hoc reports as required by users for data analyst
• Created link data or imported data from external data sources to current database system

Confidential– Bloomington, MN Sep 2000 – Aug 2008

• Using Business Intelligence Development Studio to create report server project.
• Analyze data and provide crystal reports from existing SQL Server 2005, MS Access, Clindex and MS Excel.
• Perform ad-hoc reporting with complicated SQL codes to analyze data as needed by clinical research team.
• Create MS Excel spreadsheet and chart.
• Evaluate and modify SQL queries to generate reports in existing SQL Server 2005 Reporting Services and crystal reports with MS Access, Clindex databases to track and analyze missing data information.
• Validate reports for clinical data accuracy and completeness from existing MS Access database and Clindex to support administrative team.
• Design, test, maintaining database application using MS SQL Server 2005, MS Access and Clindex in support of studies being conducted by clinical trial team.
• Evaluate and update SQL code in Clindex Application and VBA in MS Access databases.
• Developing and analyzing tables, queries and reports in Clindex, MS Access database supporting studies being conducted by clinical trial teams.
• Work closely with clinical research team members to clearly understand the business needs and objectives.
• Track, document and analyze relevant business strategies and actions.