Warren Lineman
Redmond, WA 98052
E-Mail: ac68yh@r.postjobfree.com
Summary of Qualifications:
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:
Wipro/Microsoft March 2017 to Present
Technical Lead
Teams Telemetry Project
Build data integration of telemetry data for the Microsoft 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
Global Supply Chain
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 Wipro and Microsoft 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
Darigold, November 2011 to February 2017
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.
Microsoft Devices Division, May 2010 to November 2011
BI Analyst (Contract)
Responsibilities:
Manage Deployments
Manage SQL Infrastructure
Coordinate with offshore resources to maintain 24/7 support
SSIS, SSAS, SQL Server, TFS, and Visual Studio
Expedia, Bellevue, Washington, April 2007 to March 2010
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.
Philips Medical Systems, Bothell, Washington: July 2001 to April 2007
Positions:
Siebel Analytics data warehouse for Philips Medical sales force.
Lead for SAP data warehousing for North America Sales and Service
Responsibilities/Accomplishments:
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
Microsoft through Metro IS, Redmond, Washington: April 2001 to June 2001
ASP Developer
Developed an Intranet site for the Microsoft eBook division. Used SQL Server 2000, Windows 2000, SharePoint document management system, ASP, and JavaScript.
United Advertising Media, Bothell, Washington: March 1999 to March 2001.
I/S Supervisor promoted to Manager in 2001
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. Microsoft 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.
Frank Russell Company, Tacoma, Washington:
Sr Developer/Team Lead 1991 to 1999.
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.
Education:
Seattle Pacific University, Seattle, Washington: 2004 to 2007. Enrolled in the Masters of Information Systems Management program in the School of Business and Economics. Did not complete.
University of Washington, Seattle, Washington: 1993 to 1996, Bachelor of Arts in General Studies. Maintained 3.5+ grade point average while working full time.
Philips Medical Systems, Bothell, Washington: 2005. Completed course work for Green Belt certification.