SUMMARY:

• An articulate, straightforward communicator and collaborative team member.
• Translate across technical and business requirements.
• Build strong relationships across business functions and organizational levels.
• Design intuitive and comprehensive user experiences.
• Give consumers autonomy, authority, agency to self - maintain deliverables.
• Self-directed professional with a passion for integrating technologies and tool design, to synergistic effect.

SKILLS INCLUDE:

VB.Net, SQL Server 2008 Management Studio, Visual Basic, Microsoft Visual Studio 2008, Microsoft Excel, Access, Visio, Word, SharePoint; Adobe Captivate 4.0, Oracle, SQL Navigator and TOAD data analysis tool, Outlook VBA, Pivot Tables, EssBase Queries. SSIS (Integration Services) for data warehousing and SSAS (Analysis Services) for drag-and-drop analysis tools stakeholders can govern themselves.

TECHNICAL SKILLS:

Key qualities: Transparency, Accountability, Scalability, Versatility, Collaboration.

VBA, VB6, VB.Net: Microsoft Certified Solution Developer (MCSD) Visual Basic 6.0

PL-SQL, T-SQL; BI stack: SSAS, SSIS, SSRS, HTML, JQuery, CSS, Java Scripting, Python Scripting.

PROFESSIONAL EXPERIENCE:

Confidential

VBA, VB.Net programming: Business-Process Management

Responsibilities:

• Architect data and programming solution to transfer manually entered input from engineers on the field (laying pipes, welding, etc.) to formal presentation document.
• Replace manual copying procedure with VB-coded automation procedure.
• Eliminate manual data-migration errors.

Confidential

VBA Developer

Responsibilities:

• Migrated high-profile general ledger data from Microsoft Access to SQL Server.
• Delivered translation instructions to ETL (Extract, Transfer, Load) team.
• Designed mapping and transformations, translating Jet SQL (Access) to T-SQL (SQL Server).
• Built lookup tool to track transformations of individual fields across multiple queries.
• Provided ETL team with crucial information for migrating individual fields from Access to SQL Server, with perfect parity.

Confidential, San Francisco, CA

Responsibilities:

• Automated extraction and validation of Basel III capital calculation data from Oracle to Excel, which enhanced functionality, closed gaps, and removed shortfalls of previous application.
• Designed data dictionaries to achieve 6X reduction in execution time.
• Provided tools to pinpoint weaknesses and make considered, deliberate, effective corrections.
• Leveraged predecessor’s work in new contexts, delivering greater versatility and value-added features. Empowered BAs to configure tool and save formulas to own strategic locations.

Confidential, San Francisco, CA

Responsibilities:

• Analyze reporting, identify variances with more than .5% tolerance levels, and implement solutions to improve Risk Management.
• Fully automated a complete suite of predictive analytics and “stress test” reports, providing Portfolio Managers with the tools needed to mitigate potential shocks to funds.
• Created robust, versatile and easy to use Excel-based workbooks and distributed them to key stakeholders, maintaining adherence to a tight regulatory deadline.
• Developed and delivered on-demand report and email generation, scalable content, and fully documented report calculations, with a focus on reliability, transparency, and speed.

Confidential, San Francisco, CA

Consultant

Responsibilities:

• Translated regulators’ pseudo-code into actual code to build a validation analysis process to meet Basel III regulatory compliance regarding schedule values.
• Created SQL Server functions and Excel worksheets that centralized development and automatically applied corrections to all other functions, which minimized overall development time and maximized effectiveness of any and all changes.
• Built a one-stop VBA tool to migrate Oracle SQL queries directly to an Excel pivot table, creating a streamlined and synergistic analysis tool that combined data from multiple streams into a unified data set.
• Evaluated Line of Business (LOB) variances on a quarter-by-quarter basis and reviewed changes over time, based on user-defined tolerances. Provided precise and comprehensive feedback for tracking each variance, resulting in faster turnaround time with faster error detection and deliberate, effective error correction.
• Designed tools for gap analysis: interpreting datasets that should be equal and discerning where datasets converge and diverge. Designed a technological template for comparing a wide array of datasets.

Confidential, San Francisco, CA

Consultant, .Net Programming, SSIS/SSAS Development, Data Warehouse Maintenance

Responsibilities:

• Spearheaded the development and use of interactive VB.Net dashboards to extract key data from Excel and upload into data warehouse, providing full discretion of data sources.
• Molded the combined sources into one uniform format, and configured SSIS packages to create a seamless transition from data extraction to data warehouse accrual.
• Utilized SSIS to accrue more than one million records and SQL Server Analysis Services (SSAS) for analysis and cross-referencing purposes.

Confidential, San Francisco, CA

Business Intelligence Developer

Responsibilities:

• Effectively utilized SQL Server Business Intelligence tools to facilitate tracking of company’s multimillion-dollar funding projects.
• Developed scheduled retrieval of daily data feeds, using SQL Server Integration Services (SSIS) to migrate daily Excel files into SQL Server tables.
• Converted over 50 Crystal Reports to more flexible and robust SQL Server Reporting Services (SSRS), creating a beneficial “downstream” effect that maximized code efficiency and saved time and cost.
• Transitioned VB6 and VBA code to VB.Net to supplement SSIS development, streamlining the upgrade process, providing convenient user interfaces, and facilitating data migration. Provided documentation for SSIS and SSRS-related procedures.

Confidential, San Francisco, CA

Data Analyst / Automation Developer

Responsibilities:

• Developed new database application to track Marketshare and Flowshare of all major cell phone companies in Confidential .
• Facilitated the isolation of “problem” data and delivered research-worthy data to Operations team, which vastly improved the data cleaning process.
• Consulted with Operations team on key decisions regarding calculations, metrics, and content.
• Wrote and delivered an elegant program to design PowerPoint presentations comprising an exhaustive list of meaningful Excel Pivot Table configurations. Skillfully integrated the strengths of disparate software applications to facilitate quick analysis and strategic planning; easily identified problem areas for use in reports to appropriate stakeholders.
• Designed a comprehensive SQL Server Cube, combining individual time snapshots under one “umbrella.” Applied SQL Server Analysis Services (SSAS) to cubed dataset, which significantly improved tracking and analysis capacity.

Confidential, San Francisco, CA

Automation Tool Developer / Oracle Developer

Responsibilities:

• Developed high-profile, Oracle-based data migration engine to convert several billion dollars worth of Wachovia customers as Confidential patrons. Built sophisticated data-scrubbing processes, wrote SQL code and created Excel pivot tables for extensive quality control.
• Drove Search Engine Upgrade and User Interface elements (VBA) within the Program Management Database. Streamlined database navigation, eliminated redundancy, and significantly enhanced data retrieval and performance.
• Designed test cases for end users, ensuring that upgraded elements functioned properly. Wrote functional manuals of all upgraded materials.
• Built and implemented an interactive dashboard that provided greater flexibility and capacity to users in executing, refining and organizing macros and queries.
• Performed meticulous SharePoint database management, organizing shared resources into logical groupings and correcting invalid hyperlinks, improving accuracy and usefulness.

Confidential, Corte Madera, CA

Excel Developer / VB Dashboard Interface Developer

Responsibilities:

• Developed push-button tools to maintain open-to-buy, divisional daily sales, and top-down planning applications, reducing planning time from two hours to 30 seconds.
• Expedited cross-referencing and analysis by migrating data from 27 spreadsheets into a single data source.