Senior Engineer

• Nov 2009 - Present

• Quantifies risk factors using forecasting techniques using Access and SQL Server • Removes redundant and irrelevant variables in the data by use of feature selection techniques • Developes novel pattern recognition algorithms for prediction analysis • Constructs SQL and Access reports to check for accuracy in accounting data. • Analyzes data for redundancy and accuracy via cross checks from one internal and two internet databases to prepare data migration of accounting system to a client/server environment. • Assists team members with SQL statements and Access reports. • Creation of a life cycle client server Microsoft Access database (Access front end/SQL Server back end) using VBA code to track testing according to OSHA standards. • Gathers specifications and helps to create the business rules and processes involved in the creation of the database. • Imports existing data from multiple Excel workbooks and spreadsheets into the database. • Conversion of multiple Access 97 databases to Access 2003 and Access 2007. • Creation and maintenance of databases using Microsoft Access and Visual Basic (including a life cycle project for an annual report). • Conversion of databases from DataEase and Paradox to Microsoft Access and redesigning of programs. Including creating manuals and teaching use of the converted databases. • Creates SQR reports to track insurance trends and display current policy statistics. • Writes SQL statements to check for duplicates on Sybase Database. • Maintains MS Access reports for parallel testing of Payroll system to ensure data accuracy. • Designs, develops and maintains Microsoft Access database to track the business operations of group benefits. Technologies used: VBA, MS Access, SQL, Sybase, SQL SQR, Peoplesoft, Visual Basic 6.0, DAO, XP Encryption, Security Client/Server Development Local Area Networking Clients Include: Barney & Barney, Nordstrom, DPR Construction, Synthetic Genomics, KBM, Scripps Show less