SUMMARY

• Experience with most databases and visualization tools primarily in the cloud environment. Comfortable with Tableau desktop/server, Spotfire, Crystal, OBIEE, Xcelsius, and SAS.
• Experience with Data Warehouse design and evolution as well as ETL to support. Confidential Cisco, worked with 10s of billions of dollars, Confidential Verisk, worked with billions of records.
• Experience gathering requirements, collaborating with both technical and business teams, defining processes, creating test plans, developing training, and driving adoption of new business requirements.
• Experienced Data Analyst to support business needs and drive measurable results.
• Successfully managed large - scale, complex projects with business and technical components through project management lifecycle.
• Proven track record in reducing costs and inefficiencies through systems implementations and process optimization.
• Strong leadership and communication skills. Established strong relationships with both business and technology teams to solve business needs.
• Architected accurate and scale-able DataMart and assisted with Spotfire dashboard resulting in over $5M in new business across many customers. (Verisk)
• Participated in the data development of a more complex customer segmentation model. Aggregated and enriched larger datasets to provide a summary for finance’s review and adoption of Transformational Customer. Process transitioned into WW Sales Dashboard. (Cisco)
• Third group to attempt migration of EDW to Teradata for finance. Completed successfully as accuracy was confirmed throughout the various classes of information. (Cisco- DCT)
• Rescued a chronically failing Star Wars subproject by systematically analyzing, locating, and resolving critical production errors, taking components from prototype to production, and significantly increasing monthly shipment volume. ( Confidential )
• Architected and developed a next gen view of the sales funnel interlock reporting. (Cisco- BI)
• Data / reporting lead for various interlock reporting initiatives involving Finance, Sales, Engineering. (Cisco- BI)
• Technical Lead for larger team engaged by Cisco Sales Finance to assist with highly visible troubled sales incentive program. Calculations and reporting results distributed to over 4000 sales personnel weekly. (Cisco- GSCO)

TECHNICAL SKILLS

Applications: Tableau, Spotfire, SSIS, SSAS, SSRS, Business Objects, Infoview, OBIEE, MS Access, MS Excel, MS Project, Visio, Power Point, Crystal, Salesforce

Databases: Oracle, SQL Server, Teradata, MySQL, PostgreSQL, Mongo, MS Access

PROFESSIONAL EXPERIENCE

Confidential

Data Architect

Responsibilities:

• Designing solutions for large Global data warehouse involving over 1 billion transactions each day.
• Created mapping documents, High Level Designs and performed testing on new releases
• Work extensively for Confidential trading business with Equities, Fixed Income, Foreign Exchange, Options, Futures, and Swaps

Environment: Oracle, Toad, Informatica, Actimize and NASDAQ Smarts

Confidential

Solution Architect, BI Analyst, BI Developer

Responsibilities:

• Architect for new data warehouse project involving 1 billion claims and related info.
• Conducted interviews, determined requirements, designed solutions, implemented new visualizations, environments, and processes.
• Supported Sales, Compliance, and company initiatives to increase current business and drive new revenue.
• Architected ETL, stored procedures, and cubes to support new Claim Search Data Warehouse using SSIS and SSAS including multiple new supporting DataMarts.
• In Scrum/Agile style with daily standups, developed numerous DataMarts and Spotfire visualizations to support business needs including Fire Marshal, DecisionNet, Claim Director, CSLN, OCSE, MAIS, and visual Runsheets.

Environment: DB2, SQL Server, SSIS, SSAS, FTP, SAS, Spotfire, WinSQL, SSRS, Excel, MS Access, Salesforce

Confidential

Solution Architect, BI Analyst

Responsibilities:

• Tech Lead for cube creation supporting new distributor rebate programs. Conducted interviews, consolidated and presented findings, developed and tested requirements on new platform for this growing portion of business.
• Assisted in the operationalizing of newer service models for distributors. Prepared estimates for changes and communicated project updates.
• Supported various ad- hoc metric requests. Developed visualizations in Tableau and Excel.
• Assisted in the requirements gathering, creation, and handoff of operational management reporting package needed to support system gaps within service.

Environment: Power Point, SSAS, SQL Server, Business Objects, Tableau, Oracle, TOAD, Excel, MS Access

Confidential

BI Analyst / Developer

Responsibilities:

• Assisted in monitoring various aspects of Cisco’s $10B+ B2B business as Next Generation quoting and ordering platform was adopted.
• Developed visualizations within Tableau and Excel.
• Assisted with B2B adoption forecasting between Sales and IT team leads.
• Produced and distributed partner specific daily reports to various team leaders.
• Developed reporting calculations for internal touch rate metric.
• Automated the updating of Excel output used on WebEx Social and in multiple communications.
• Provided ad hoc support on issues/theories from IT Managers.

Environment: Power Point, Excel, WebEx Social, Business Objects, Oracle, TOAD, Tableau desktop, VBA, MS Access

Confidential

Analyst

Responsibilities:

• Developed and presented BRD needed to correct issue caused by a view used in 34 places within CSCC.
• Documented and presented various smaller monthly improvements for CSCC.
• Provided support and research on multiple other potential improvements.

Environment: Oracle, TOAD, Word, MS Access, Excel, Power Point

Confidential

BI Analyst /Architect

Responsibilities:

• Data SME for IT, finance, and offshore personnel.
• Provided ad hoc support on issues/discrepancies from the field and business leaders related to data quality and modelling.
• Provided validation for finance as data uploaded to EDW for Essbase cube and BO Universe.
• Improved and managed source files from theater leads for global restatement process.
• Worked with IT and business leaders representing finance in the release of improvement of a new dimension within in BO Universe.

Environment: Virtual Machine, Business Objects, Essbase, SQL Server, PL/SQL, MS Access, Excel, VBA, Power Point

Confidential

BI Analyst / Architect

Responsibilities:

• BI representative on service provider reporting for finance. Collaborated on numerous projects with various appointed department leads.
• Transformational Accounts - collaborated with finance and sales leads to agree on next generation of customer reporting/planning representing Cisco’s largest customers and over 50% of annual revenue.
• Developed visualizations leveraging Tableau and Excel.
• Whole Offers - SP Wi-Fi, VXC, BYOD Collaborated with various teams including engineering to agree on mechanisms for report automation.
• Scaled, enhanced, and maintained DataMart for Customer Use Case reporting.
• Collaborated, developed, automated, and handed off WW SP Architecture reporting package.
• Assisted in the development of product family level funnel reporting for finance.
• Performed data quality testing on new dimensions prior to release into production.
• Developed and supported BI Best Practices for Data Quality and overall business value.
• Collaborated and developed data center reporting for finance.

Environment: Tableau desktop, Tableau Server, Virtual Machine, Salesforce, Business Objects, Essbase, PL/SQL, SQL Server, SSAS, MS Access, Excel, Power Point

Confidential

Manager / Analyst

Responsibilities:

• Designed and implemented Oracle custom application as middleware between WebEx and Cisco’s Sales Management Systems.
• Trained and developed multiple OBIEE dashboards used for sales purposes.
• FDEV APAC-Performed data quality analysis on migration of FDEV into APAC.
• Member of team to gather requirements and develop proof of concept for Cisco Global Promotions Council. The team delivered a proof of concept and requirements, which were used in implementing an enterprise solution for channel partners.
• Deal Management Simplification- Dropped in late in project. Developed and implemented automated analytic tool to support core business metrics using DMAIC calculations within the non-standard portion of business. Results of calculations mentioned on various earning calls.
• Involved with data warehouse improvements. One of the global super users improving Deal Reporting BO Universe (>$10B approved quarterly).
• Foundation Advantage- Technical Lead supporting new operational model for sales incentive programs. Foundation Advantage Program was the first program to provide on demand reporting across four different performance dimensions. A $1.3B program and a Cisco top 10 initiative.
• SMB Hard Deck Analysis- Technical Lead and Architect for this Sales Finance project analyzing SMB customers leveraging D&B business attributes.
• Revenue Assurance- Technical Lead for this second generation system development for Cisco Revenue Recognition process. Architected databases and process. Presented a Proof of Concept to the Cisco director, and coordinated 4 developers to deliver the full implementation in 5 weeks.
• Developed Global Competitor /Technology reporting package. Included deep analysis of discounts by technology group and customer.
• MS POS Data Capture- Increased the scope of market intelligence by capturing more data attributes from Cisco’s service providers, including Confidential & Confidential, SBC, BellSouth, Sprint, and Verizon.
• Coordinated with the Cisco team to determine business needs and implemented creative solutions that delivered above and beyond expectations and increased future business between Confidential and Cisco.

Environment: Power Point, Salesforce, Business Objects, Essbase, OBIEE, Informatica, MS Access, Excel, VBA, Xcelsius

Confidential

Project Manager / Analyst

Responsibilities:

• Worked directly with founder to develop scalable solutions for the various departments with the company by increasing automation and self-service processes.
• Designed and implemented new processes and services for a startup firm specializing in verifying, processing, and reporting express parcel shipping credits with FedEx, UPS, and DHL.
• Provided automatic and standardized report generation, web-enabled data entry, and centralized, online data storage by streamlining and improving numerous, firm-wide business processes.
• Devised and implemented an automated credit submission process with UPS and transformed the credit submission process infrastructure.
• Added a new revenue stream by designing a Rate Auditing service that attracted the attention of Amazon.com and played a key role in securing a strategic contract with this major shipping company.

Environment: SQL Server, DTS, Crystal Reports, Power Point, MS Access, Excel, VBA

Confidential

Director of Operations and Business Development

Responsibilities:

• Expanded service offerings for a day trading company by researching, analyzing, and integrating strategic industry technologies into an existing operations infrastructure.
• Increased trading capabilities by introducing improved stock chart and order entry technologies, integrating a stock analysis tool with the order entry system, and implementing trader auto-entry.
• Improved management visibility into account activity and delivered trade data reporting capability by designing and implementing electronic order entry and customer sales reporting systems.
• Standardized training methods and documents and developed a knowledge database to support standardized trading processes and procedures.
• Environment: MS Access, Excel

Confidential

Manager, Technology Department

Responsibilities:

• Implemented and supported a modular software package used by HRMS and Payroll departments.
• Managed the full life cycle for PeopleSoft, SAP, and Oracle integration, development, and implementation projects, from design to rollout, for clients such as Raytheon, Lucent, MCI, Confidential & Confidential, Schering Plough, CSFB, Avon, AIG, Kodak, and Best Foods.
• Managed system integration consultants, developed a knowledge database, and collaborated to design training classes and lead training for all implementation projects.

Environment: SQL Server, VBA, Crystal Reports, Power Point, MS Access, Excel, VBA

Confidential

Product Manager

Responsibilities:

• Identified production inefficiencies and implemented design improvements as the hands-on Program Manager for government and commercial contracts for Harris Semiconductor, Raytheon, and Lockheed.
• Re-engineered processes in manufacturing, purchasing, shipping, and sales, and designed and implemented Microsoft Access databases to support procedural changes.
• Reduced user error and improved data gathering methods by installing a network and a bar code system.
• Resolved all production problems as Program Manager on a Raytheon classified military project.
• Managed a team of four engineers and seven assemblers to deliver on aggressive production schedules.

Confidential

Project Engineer

Responsibilities:

• Played a key role in developing quality control standards and collaborating with the Head Engineer to achieve ISO 9000 certification.
• Performed product quality tests utilizing automated testing equipment developed on UNIX and DOS platforms and managed a five person staff in manufacturing and testing of fiber optic photo detectors.

Confidential

Manufacturing Engineer

Responsibilities:

• Conceived, developed and installed quality control system using Lotus and Harvard Graphics.
• Managed and developed a four-person division responsible for surface mount assembly and testing.