SUMMARY:

• Ability to work in diverse environments, on multiple platforms, integrating data into useful solutions.
• Good communication skills with technical and non - technical people.
• Ability to manage and prioritize multiple projects.
• Ability to manage and work well with vendors and clients.

WORK EXPERIENCE:

Confidential

Technical Lead

Responsibilities:

• Build data integration of telemetry data for the Confidential Teams product from Aria and Interana into SQL Server, Azure Data Lake, SSAS, and Azure Data Warehouse
• Manage the day to day operations for the data pipelines
• Educate the Subject Matter Experts on best practices and capabilities of the various platforms
• Technical Lead for three onshore and 10 offshore team members

Confidential

Responsibilities:

• Lead a BI team of 2 onshore and 2 offshore BI developers
• Manage the daily Power BI refresh schedules, Azure Data Factory Pipelines, and production issues
• Developed and managed over 300 Power BI reports
• Extract data from SQL Server, Azure Data Warehouse, Azure HDInsights, Azure Data Lake Storage, and SSAS databases for use in reporting
• Advised the Confidential and Confidential team members on BI Best Practices
• Migrated on-premises SQL Server and SSAS cubes to Azure technologies including Azure Data Warehouse, HIVE/HD Insights, and Azure Data Lake, reducing costs and increasing availability

Confidential

Sr BI Solutions Developer

Responsibilities:

• Developed budgeting, forecasting, and planning systems in BPC
• Built the integration between Oracle, SQL, and external systems into BPC.
• Build interfaces with Oracle EBS to upload and download data from EBS to various ERP and BI applications.
• Support the user community in its use of BPC and BI applications and interfaces with EBS. Including ongoing training, best practices, and capabilities
• Managed projects to upgrade BPC and Business Objects that were completed on time and under budget. Was a key individual contributor on the projects in addition to managing the projects.
• Develop Analytics solutions to support the sales, supply chain, finance, and operations departments in OBIEE, Business Objects, and Power BI
• Developed BI Solutions in SQL Server and Oracle using SSIS, REST/SON, Web Services, and Informatica as ETL Tools. Exchanged data with internal Oracle EBS, Sales, manufacturing, and Milk Billing systems. External data was pulled from several service providers.
• Developed dashboards and analytics in BO Voyager, SSRS, Power BI, Power Query/Power Pivot for Office products.
• Wrote C# code to interface data with HR Vendor.

Confidential

BI Analyst

Responsibilities:

• Manage Deployments
• Manage SQL Infrastructure
• Coordinate with offshore resources to maintain 24/7 support
• SSIS, SSAS, SQL Server, TFS, and Visual Studio

Confidential, Bellevue, Washington

SR BI Analyst

Responsibilities:

• Manage the day to day operations of both Enterprise Data Warehouses, one in SQL Server and SSAS and the other in DB2 and Business Objects
• Informatica and SSIS ETL tools
• SQL Server and DB2 database servers
• Business Objects Administration
• Worked on the project to migrate from SSAS cubes to a DB2 data warehouse environment.
• Key in implementing offshore agreement to add resources to the team to extend support to 24/7. Coordinated the team efforts after implementing the agreement.

Confidential, Bothell, Washington

Responsibilities:

• Siebel Analytics data warehouse for Philips Medical sales force.
• Lead for SAP data warehousing for North America Sales and Service
• Informatica ETL from the Siebel CRM product to Analytics.
• Oracle & SQL Server
• C# .NET programming to extend functionality.
• Analytics Repository development.
• Responsible for implementation of the FCO Tracking system after converting from a legacy system to SAP for Work Order management.
• Oracle & SQL Server
• Responsible for implementation of the data warehouse after converting from a legacy system to SAP.
• Managed various upgrades to the infrastructure of the data warehouse components
• Technical lead on a project to publish data warehouse data with Business Objects

Confidential, Redmond, Washington

ASP Developer

Responsibilities:

• Developed an Intranet site for the Confidential eBook division. Used SQL Server 2000, Windows 2000, SharePoint document management system, ASP, and JavaScript.

Confidential, Bothell, Washington

I/S Supervisor promoted to Manager

Responsibilities:

• Led a team in the implementation of a new billing and revenue accounting system to replace an in-house custom developed system that was no longer meeting the business needs. The project brought together people from offices around the country and a dozen technical resources.
• The project was completed on time.
• Used SQL Server, Visual Source Safe, DTS, VB, 4D, VB Script, VBA, ASP and Oracle on NT and UNIX platforms.
• Confidential Office products including Word, Excel, Access, Project, and Power Point.
• Supervised a team of five Programmer/Analysts, and later managed a team of 10 including programmers, documentation specialists, analysts, and System. Administrators. The team maintained the billing, revenue accounting, commissions, and AR systems.
• Members of the team were also responsible for interfaces between those systems and Oracle Financials, the commissions system, and print production systems.
• Worked with company management to identify and prioritize development and maintenance projects.
• Helped to advance the teams knowledge and skills in Client/Server application development using Visual Basic, ASP, Oracle and SQL Server.

Confidential, Tacoma, Washington

Sr Developer/Team Lead

Responsibilities:

• Form and lead a team of five other Programmer/Analysts with varying amounts of experience to support production applications.
• Worked with IT management to hire team members.
• Managed small to large development and maintenance projects.
• Developed or enhanced applications to support all lines of business.
• Coordinated turnover from vendors or internal development staff to the support staff.
• Implemented change and configuration management.
• Coordinated priorities for development and maintenance projects with business unit and IT management.
• Coordination within IT when resources were required from outside my group.
• Evaluation, implementation, and management of third party software including the integration with other systems.
• Project management and technology leadership on projects to add major functionality to Legacy and Client/Server systems.