SUMMARY

• Technical Data Analyst - Programmer wif 10+ years experience in Software Development and Business Analysis
• Experience wif MS office (Excel, Access etc), VBA, Macros, MS SQL Server 2012, Crystal reports, SAP BO etc.
• Hands on experience in retrieving backend data from SQL Server, Oracle into Excel, Access for reports.
• Created stored procedures, triggers and queries dat supported data integrity checks during importing / exporting into Access, Excel and SQL Server -- using VBA and T-SQL.
• Demonstrated project management, computer programming, reporting and database management skills.
• Dedicated self-starter wif a record of taking new developments from analysis through execution.

TECHNICAL SKILLS

• MS SQL Server 2012 SSIS
• SSRS
• SSAS
• BIDS
• ASP.NET 2.0
• ORACLE 11g
• FileNET
• Remedy / Excel 2013 / Access 2013 / Web programming
• SQL queries & reports
• VB
• User training
• Customer support at remote sites
• Oral presentations to clients
• SAP BusinessObjects
• OneNote
• Technical writing
• Crystal Reports
• HTML
• JAVA
• SQL
• VBA
• Macros
• FTP
• TOAD
• HTTP
• T-SQL
• Business Intelligence Developer Certification
• Riskmaster
• Essbase
• SAS
• SAP BI

PROFESSIONAL EXPERIENCE

Confidential, Petaluma, CA

Database Programmer/Analyst

Responsibilities:

• Prepared and integrated SAS data sets from multiple data sources using SQL / SAS / Excel.
• Collected, collated, compiled, reviewed and distributed reports to internal and external audiences.
• Assisted wif all Adhoc Analysis assignments, deliverables and Special Projects.
• Data mining, manipulation & analysis using SAS/SPSS/SQL, Excel, Access, Data Warehouse / RDBMS.
• Responsible for daily, weekly and monthly reports.
• Automated daily tasks using SAS Macro Steps.
• Created Report Management System in OneNote for tracking, processing and logging Reports.
• Ad hoc queries in SAP Business Objects.

Confidential, Petaluma, CA

Database Programmer/Analyst

Responsibilities:

• Created a prototype ticketing system and a prototype mentor/mentee matching system in Access.
• Created stored procedures to provide a data source for web development.
• Created SQL Server testing databases for web development containing unique manufactured false data -- 60k.
• Created automated reports using SQL Server jobs, stored procedures, proxies, credentials, excel, SSIS.
• Provided support for intranet web pages.

Confidential, San Rafael, CA

Technical Analyst / Programmer

Responsibilities:

• VBA Developer for Pricing Operations containing Pricing, Accounting, Financial Reporting and SAP.
• Maintained consistent coding standards, code quality and architecture: VBA code, SQL, vb script and databases.
• Development on the integration between Excel templates, Access and SharePoint Tables.
• Perforce, OneNote, Virtual Machines, Windows Server 2012, SharePoint, Access, Excel, Macros, Rally.
• Repaired and improved Access and Excel applications based on instructions in Rally.
• Maintained windows server vb. script task of daily backups.
• Created Tools to improve the development process i.e. Developer's Synopsis.

Confidential, San Francisco, CA

Information Analyst / Programmer

Responsibilities:

• Managed Access databases ensuring data reliability, quality and security.
• Reversed engineered an 'exe' SAP import program. Created a successful replacement application wif VBA Code.
• Validated operators’ database entries, client job costs, and adjusted costs via Microsoft Access and SAP.
• Provided monthly and ad hoc reports as needed for management and clients using T-SQL, VBA, Access, Excel.
• Provided IT support for users of both depts., computer/printer/plotter systems and the Employee Time-clock.
• Began Design and Development of a SQL Server Replacement for all Access database systems.
• Documented and schema-mapped all Access databases.
• Developed enhancements to all databases and conducted a daily backup of 20 Access databases.
• Uploaded images to FileNet from six different sources. Verified uploads and corrected import errors.

Confidential, San Francisco, CA

Technical QA Data Analyst / Programmer

Responsibilities:

• Documentation, testing and verifying data integrity using SQL to identify / resolve data issues
• Responsible for 'Data QA' activities for systems dat do not has user interfaces.
• Provided guidance to database users recommending options for automating 'Data QA' testing.
• Business analysis; data mapping; performance tuning of SQL scripts.
• Informed developers of defects. Log, track, verify resolution of software and specification defects.
• Documents all phases of the Systems QA process.

Confidential, San Francisco, CA

Technical Data Analyst / Programmer

Responsibilities:

• Riskmaster Support: Manage RM mailbox containing automated RM reports, User issues, Customer complaints, verify DB CPUC events and contact appropriate entities during production failures. Inform users of data issues in need of correction illustrated by daily RM automated reports. One on one user training, fix Executive Summary, Mail Merge errors, etc. Manage and track open user error issues.
• Riskmaster Admin: Add and subtract users and privileges. Modify RM Production DB depicted by automated RM email reports and unpredicted DB issues
• SAP BusinessObjects: Bus. Intelligence Reports: Modify / create reports to support user needs.
• SQL: Create Ad Hoc reports to address issues regarding the RM DB.
• Major SQL Project: Entity Clean Up Tool: Created SQL dat removes duplicates from the RM DB. Provides data integrity reports and automatically handles index errors and data integrity checks. Documentation provides detailed requirements. Ran in production successfully as a proof of concept.

Confidential, San Francisco, CA

Technical Data Analyst / Programmer

Responsibilities:

• Retrieved data from an IBM AS400 into SQL Server, which was then downloaded to Access resulting in an Excel report, using SQL for the AS400 and T-SQL for the SQL Server and VBA
• Created an automatic csv export of data from an IBM AS400 linked server using a stored procedure, a SSIS project, SQL Agent, credentials, proxies and an Access DB.
• Automated the process of creating a current local cube of data from an IBM AS400 linked server using a stored procedure, SSIS, SSAS, a SQL Agent, credentials, proxies, SSMS, CmdExec, SQLcmd and MDX.

Confidential, Mill Valley, CA

Technical Data Analyst / Programmer

Responsibilities:

• Automated Excel Spreadsheets, provided user interfaces, data analysis, pivot tables -- using VBA.
• Automated user tasks, reports, workbook integration and designed data structure.

Confidential, San Francisco, CA

Technical Data Analyst / Programmer

Responsibilities:

• Gatheird and documented the business requirements for the business functional units dat would provide data from the field to the company database system.
• Created stored procedures, triggers and queries dat supported data integrity checks during importing/ exporting into Access and the SQL database -- using VBA and SQL.
• Created automated reports (viewed using the web / excel) by combining SSIS, SSRS, SQL Agents, triggers and Access -- using VBA and SQL.
• Designed, created and implemented a database structure wif code dat was used to import the field data from different world sites into the main SQL Server -- using VBA and SQL.
• Created an ASP.NET 2.0 website interface to allow users to enter data directly into SQL Server 2005.
• Wrote the Documentation dat describes the Dataflow configuration and steps necessary to set up the system.

Confidential, San Francisco, CA

Technical Data Analyst / Programmer

Responsibilities:

• Loan amortization integrity of 60 spreadsheets using Essbase, Access, VBA, SQL, created algorithms
• Replicated Excel spreadsheet functionality and formulas wifin an Access database. The project contained 60 spreadsheets dat track the amortization of loan products for the life of the loan.
• In Excel, modified and created VBA code to Model data from backend Hyperion Essbase.
• Created SQL queries – to download data from Essbase and Oracle into spreadsheets and analyzed data using pivot tables -- using VBA,SQL and Access.