Developer Data Oracle .Net Sql Project Experience
Resume:
Mr. London Jones **********@*****.***
Washington, DC
Overview
Access/Excel Developer with 8 years of experience in data analysis,
statistical analysis and database administration
Skilled in developing macros, queries, scripts and models to analyze data
and automate information processing
Proven problem solver, accustomed to working independently and to
collaborating in a team environment
Seeking a position in database development, process automation, data
analysis, reporting, or data mining
Technical Skills
Database Proficient in the use and design of relational databases including
Oracle 10, SQL Server 2005, and MySQL
Productivity Highly proficient in Microsoft Excel (import/export, macros, charts,
pivot tables, vlookup, formulas)
Highly proficient in Access ( automation using VB modules,
table/query design, report design )
Highly proficient in SQL and SAS
Proficient in Teradata, Crystal Reports, Infopath, and MicroStrategy
Programming Highly Proficient in VBA, VB.NET, Python, and Web Programming (HTML,
JavaScript)
Proficient in ASP.NET, C# and Objective C
General Proficient in Microsoft Word, PowerPoint. Proficient in Windows and
UNIX,
Highly computer and internet literate
Experience
IC Training Group 05/2010
- Present
Database Developer
. Extensively using SQL to extract data from the Oracle databases into
Microsoft Access to be able to utilize data in a presentable form by the
end users
. Developing Microsoft Access databases including customized macros,
queries, forms and reports using VB.NET
. Developing databases, process automation, data analysis, reporting or
data mining and conducting ad-hoc research for the end user needs
Freddie Mac (Collabera, Inc.) 12/2009
- 01/2010
Reports Developer
. Generated analytics reports using PeopleSoft reporting tools and
Microsoft Excel for yearly employee performance reviews
. Automated the generation of division performance analytics reports using
Excel VBA for the end of year employee performance analysis
Sprint Nextel (Modis, Inc.) 08/2007
- 07/2009
Commissions Data Analyst
. Implemented complex Microsoft Excel formulas, and queries in Microsoft
Access and Oracle to access corporate financial records and records
. Analyzed data from enterprise databases and applied complex rules to
resolve appeals for commissions from dealers in the North-East United
States, using advanced Excel and Access techniques
. Increased productivity by implementing VBA programs in Microsoft Access
and Excel to automate the analysis of commission requests using the
Microsoft Object Model
. Assisted in leading a team of 8 analysts with responsibilities for
implementing and modifying the appeals resolution process, providing
instruction and ensuring the accomplishment of short term (1-2 weeks)
team productivity goals
Independent Contractor 02/2004 -
06/2007
Database Developer
. Collected data and created statistical models of health trends in
Northern Virginia and wrote technical reports on public health trends
using multiple regression analysis, clustering, and ANOVA using SAS and
Excel
. Prepared public health data by merging/converting existing databases
and creating new databases using Access and SQL Server
. Ensured compliance with technology based business requirements and with
government regulations including GRPA, DFARS, and FISMA for local and
federal government contracting firms
. Constructed complex statistical analysis procedures for Microsoft Access,
and SAS including regression models and ANOVA to sample, calculate
weights, and infer missing data for public health surveys
. Developed tools for to automate common tasks in SAS Database
Administration and XP computer systems administration using C# with the
.NET Framework
Sociometrics Inc. 10/2002
- 12/2003
Database Administrator
. Developed and designed Access databases with over 200,000 records,
requiring customized SQL expressions
. Utilized Visual Basic and SQL to create dynamical reports that
automatically adjusted the fields to correspond to geographic area of the
data
. Implemented VBA scripts to imports hundreds of policy evaluation
spreadsheets into Access databases from Excel
. Planned quantitative portions of projects, ensuring compliance with
project requirements and researching software solutions
. Created project specific macros to perform qualitative and quantitative
analysis and to process data into custom formats according to client
requirements
Contact this candidate