Contract Systems Analyst Resume San Francisco, CA - Hire IT People

SUMMARY

Data driven technologist: skilled at using an array of developer tools to glean outliers, anomalies, and business intelligence from accumulative data sets.
Passionate about transforming raw data into metrics. Seasoned designer/writer of reports which demonstrate big picture data with detailed data drill downs.

TECHNICAL SKILLS

Databases: SQL Server 2012/2008/2005/2000 , MS Access

Languages: T - SQL, VB.NET, VB6, VBScript, MS Access VBA & MS Excel VBA, XML/HTML, CSS

Reports: SQL Server Reporting Services 2012/2008

IDEs: Visual Studio 2013/2010/2008/2005

PROFESSIONAL EXPERIENCE

Contract Systems Analyst

Confidential, San Francisco, CA

Database and Application Developer

Confidential, Fairfield, CA

Programmed/published two Intranet applications using Visual Studio 2010/ASP.NET 4/VB.NET 2010 and SQL Server 2008; supported 80 concurrent users, document management, and call center metrics
Designed and developed a new SQL Server database after defining functional specifications to derive a normalized data model in Visio 2010
Optimized SQL queries with indexes and code refactoring
Performed SQL query writing, stored procedure and UDF programming to support the ASP.NET Database application and ad hoc requests throughout the department
Wrote and deployed SQL Server Reporting Services 2012 reports and underlying SQL objects
Built and deployed SQL Server Integration Services 2012 extract, transform load packages for data processing in the SQL Server database

Database Developer

Confidential, San Francisco, CA

Performed SQL query writing, stored procedure and UDF programming and documentation for the SQL Server 2008 (2005/2000) database for internal and external clients
Programmed and published to the Internet an online survey application of 30 web forms with data validation controls throughout to enforce business rules using Visual Studio 2008/ASP.NET 3.5/VB.NET and SQL Server 2008 to capture clean and consistent data and report users' information
Built Extract, Transform, Load (ETL) procedures to extract large data files using Integration Services for import into the SQL Server database
T ranscribed user requirements into new database objects and coding procedures; programmed Excel VBA to calculate point-bi-serial correlation coefficients along with other supporting educational statistics for in-house psychometricians
Wrote database export procedures to dynamically generate XML as specified by clients
Built Access Forms applications with numerous business rules and exception handling coded into the user interface to prevent end users from entering faulty data
Migrated Access databases to SQL Server database and modified code as needed
Programmed OLE Automation code modules to extend MS Office Applications to call and execute remote MS Office Applications from native MS Office Application

Information Analyst Portfolio Group

Confidential, Mill Valley, CA

Translated Mortgage Backed Securities (MBS) Prospectus' into code to model bond cash flow structures of MBS to ensure a matching of risk profiles
Built numerous Excel spreadsheet and Access database files to perform a variety of financial calculations to back out missing info from MBS issuers’ periodic statements to fill in needed pieces of portfolio data points (WAL, Duration, IO premium, YTM etc.)

Application Development Contractor

Created Accounting, Finance and Office Automation database applications in Access
Designed and tested database at all phases of production; researched and tested new, emerging technologies to evaluate for inclusion into array of development tools

Research Analyst; Programmer

Confidential, San Francisco, CA

Adapted and built a Markowitz portfolio optimization model that maximized a 2 Billion USD portfolio of real estate assets across 15 different Western metro markets; conducted qualitative research and statistical tests to measure the reasonableness of the assumptions and the model’s fit to reality
Created and maintained an Access database that tracked economic info for 15 metropolitan areas as drivers for economic returns for new class A apartment development
Developed detailed spreadsheets to identify trends and impute forecasts or conduct further research

Financial Analyst Internship

Confidential, San Mateo, CA

Debugged and documented Lotus 123 code which was a database application written in a spreadsheet program
Wrote Visual Basic programs that automated financial and HR functions in Access and Excel.