TECHNICAL SKILLS:

Databases: SQL Server, Teradata, mySQL, postgres, SQL Server Integration Services (ETL)

Analytical Tools: Crystal Reports, Business Objects, SAP, SQL Server Reporting Services/Visual Studio 2008, Tableau

Programming languages: VBA, PHP, Visual Basic 6.0, Perl, C++, Java

Microsoft Office: Access, Excel, PowerPoint, Visio, Word, Outlook

PROFESSIONAL EXPERIENCE:

Confidential

Brand Risk Management - Program Intelligence Manager

Responsibilities:

• Coordinated with database engineering teams to build out various DB structures for analytics.
• Developed and presented reports to internal legal teams, and external groups including FBI and Interpol.
• Leveraged SAP finance system to conduct financial audits and coordinated results with Accounting.
• Created ad hoc presentations with recommendations for leadership.
• Designed ETL processes (SSIS) to import from Teradata, Oracle, mysql and SQL server databases.
• Engaged with various functional teams throughout the US, Ireland, India and APAC to develop regional insights.
• Built out new metrics portal and delivered insights for leadership team using Tableau.
• Developed GFC dashboards for executives, managers and investigative staff.
• Ad hoc metrics gathering and qualitative analysis for C level management.
• Worked with senior leadership to develop quarterly and yearly development roadmaps and plans.

SQL Server Database Architect / Manager

Responsibilities:

• Worked with executive team to establish KPIs for the payments org.
• Designed and implemented new SQL Server architecture and web front end to house secure data.
• Designed ETL processes (SSIS) to import from Teradata, Oracle, mysql and SQL server databases.
• Engineered and built slack bot and email notification system to distribute metrics and alerts.
• Built out new metrics portal for leadership team using Tableau.
• Built interactive portal for leadership to input information for regular metrics updates.
• Ad hoc metrics gathering and reporting for periodic reporting.
• Tableau power user and beta tester.
• Managed AWFs assisting in the build out.

Tableau Reporting / SQL Server Migration -

Responsibilities:

• Built entirely new reporting environment for PayPal/eBay split.
• Migrated existing Tableau reports/dashboards to new Tableau Environment.
• Translated managerial requests for metrics into Tableau Visualizations.
• Built automated scheduling tool for Tableau report distribution.
• Created Ad hoc reports as required for upper management.
• Ad hoc building of complex SQL Scripts and Stored Procedures to access data.
• Migrated existing reporting database to new SQL Server environment.

Confidential

Tableau Reporting / SSIS

Responsibilities:

• Worked with management stakeholders to develop metrics to help management team.
• Built SSIS intake process to handle large volume of csv and text files from client FTP servers.
• Cleaned data files using SSIS data flow transformations to fit in SQL Server 2008 R2 reporting system.
• Translated managerial requests for metrics into Tableau Visualizations.
• Trained end users (Account Managers / Sales Team) to use Tableau reports to help run the business.
• Used Tableau and Sql Server Reporting Services (SSRS) to create mailing lists for Account Managers.
• Used SSRS to create a series of automated weekly and monthly reports for managerial team.
• Managed and prioritized internal requests thru Microsoft Dynamics CRM tool.
• Maintained Tableau online reporting environment.

Confidential

Software Developer / SSRS Analyst

Responsibilities:

• Determined requirements for tool that allowed the team to rate, rank and grade apps for the Windows Phone 8 store.
• Developed Project plan for delivery of new Application Rating Tool.
• Used .NET to create a front end rating tool console for data validation and error checking.
• Implemented Ext.Net libraries on top of .NET to make functional and sleek looking front end for rating tool.
  • Worked with management to create and design reporting software for Phone team using SSRS.
• Created a series of dashboards for team managers using SQL Server Reporting Services / Visual Studio 2008
• Developed ETL tools using SQL Server/SSIS to load and aggregate data as well as to report results.

Business Analyst / SSRS Developer

Responsibilities:

• Created and developed internal metrics/KPIs using data from internal ticketing systems SQL Server 2005.
• Defined strategic goals with Silicon Valley Operations Center manager in order to create effective daily reports.
• Created daily/weekly/monthly reports using SAP/Business Objects.
• Created ad-hoc reports using Visual Studio 2008.
• Deployed a web-based SSRS reporting environment.
• Created and maintained SSIS packages to load data for reporting environment.
• Trained employees for several new properties including Skype and TellMe.
• Leveraged Sharepoint (Nintext Workflow) to notify management and employees of pending changes.
• Increased productivity of Operations Center employees by providing detailed business metrics.
• Determined requirements for transitioning Skype Finance tools to in house Microsoft ERP system.
• Developed Project plan for design, development, delivery and maintenance of new Finance Forecasting tool.
• Designed and built Rating Tool and Management Console (VBA) based on agreed upon design.
• Created front end forecasting tool in Excel for data modeling.
• Used SQL Server/SSIS to ETL data from various data sources.

Confidential

Billing Support Contractor

Responsibilities:

• Created automated PERL/Python scripts to act as ETL to pull down clickthru/impression data from several 3rd party ad servers. Primarily google AdWords.
• Designed and implemented MySQL database schema to store billing data.
• Developed a series of internal billing reports.
• Worked with managers to create invoices for external stakeholders.
• Replaced entire legacy Excel 3rd party billing system with scalable database driven billing system.
• Evaluated several reporting solutions and presented findings to management.

Confidential

Senior Financial Analyst

Responsibilities:

• Created and developed internal metrics for finance team and CEO.
• Evaluated several reporting solutions and database technologies and presented findings to management.
• Implemented a SAP/Crystal Reports setup to facilitate creation of reports and dashboards.
• Periodically audited reporting environment to ensure security and integrity of system.
• Worked with teams from T-Mobile and other external stakeholders to ensure delivery of accurate and timely data.
• Extensively used PERL scripts as ETL tool to maintain and update MYSQL and SQL Server databases.
• Designed, created and distributed physical SAP/Crystal Reports to a variety of stakeholders.

Confidential

Business Analyst

Responsibilities:

• Created and developed internal metrics within eBay Operations.
• Recognized every quarter as a top performer in Operations.
• Supported the Process Engineering staff with data analysis, report creation, distribution, and .
• Implemented a 300 user Crystal Enterprise Premium environment with an average of 10,000 reports running weekly.
• Designed over 200 different reports / dashboards focusing Operations process improvement.
• Contributed numerous ideas for process improvement and quantified improvement opportunities.
• Regularly reviewed plans and provided options for tool design and data capture.
• Met with all Operations and Customer Management to gather reporting needs.