Phil Weiler Email & Phone Number

Jacksonville, Fl, Us

Niles, Il, Us

• Assisted with the source research, query programming, and preparation of legacy mainframe data to be initially loaded into a new enterprise-wide SAP ERP rollout.• Created SSIS packages to move data between databases and to transform data based on business rules.• Enhanced MS-SQL databases to accommodate additional columns and relationships.• Created SQL tables, views, procedures, and functions to load stagging data• Primary Tools: MS-SQL Server, SQL, SSIS, MS-TFS, Visual Studio

Chicago, Illinois, Us

• Responsible for the development, support, reporting and analysis of enterprise level dental and insurance related data and processes.• Created forecasting report preview mode within an existing complex legacy system.• Reduced data duplication and processing speed within key insurance reports.• Primary Tools: MS-SQL Server, SQL, SSIS, SSRS, MS-TFS, Visual Studio

Minneapolis, Mn, Us

• Code development and maintenance of US Bank’s custom-built mortgage-backed securities tracking and client deliverables system, used by ~170 active users at London, Boston MA, Irvine CA, Chicago IL, and other remote US offices.• Responsible for the development and maintenance of ETL processes.• Responsible for development and support of internal/external reports and user interface forms/processes.• Internally recognized/thanked by business side - (New business loading, new reporting, and additional projects), Bronze Shield Award, 9/11/2020 - Tax reporting project.• Agile/Scrum/Kanban environment.• Primary Tools: MS-SQL Server 2016, SQL, SSIS, SSRS, Crystal Reports, MS-TFS, Visual Studio 2019

Chicago, Illinois, Us

• Design, development, and support of key data marts and ETL processes.• Analytics/Business Projects - Ad-hoc support.• Developed customer segmentation model using R and various databases.• Provided End-User SQL query and data mart guidance.• Agile/Kanban/Scrum environment.• Primary Tools: MS-SQL Server 2016, SQL, MySQL, SSIS, SSRS, R Graphics, GitHub, SourceTree, Jira (for Project Management), MS-Office, HipChat.

Basking Ridge, Nj, Us

Finance National Operations - Compliance Team: Internal and external fraud and outlier activity detection. Left due to reorg / office move to NJ & GA.• ETL and BI Reporting/Analysis Development - Implemented ETL improvements and new analytical dashboards using Tableau.• Primary Tools: MS-SQL Server, SQL, SSIS, SSRS, Tableau 9.3, Teradata, Excel VB, SharePoint

Chicago, Il, Us

Analytics & Operational Excellence Team Member (12/2015):• Preformed role of team lead and project manager on a regular basis. • Recognized for database migration, data validation, data quality improvement project (2/16/2016).• Developed ETL for aircraft installation planning and tracking (created custom SSIS slowly changing dimension) • Performed aircraft route Analysis• Inventory validation analysis• Implemented EDI/ETL data capture for FedEx shipments tracking and analysisService Assurance team (9/2013-11/2015):• Implemented/designed the analytical and reporting solutions used to support the team’s quality assurance and engineering related requests.• Design and implementation of automated analysis and reporting solutions (Mean-time-between-failure, Equipment Duration, Return Rate Details).• Preparation and analysis of in-depth quality assurance data (return rates, no trouble found). • Accomplished systems integration, end-user data accessibility, database design and implementation, data quality improvements.• October 2013 Bronze Star Award: For collaborating across BA and CA in order to successfully define and deliver a solution to support quantitative nonconforming product data analysis.• Primary Tools: MS-SQL Server, SQL, T-SQL, SSIS, SSRS, VB.Net, Python, Perl, MySQL, Tableau, Excel/VB, Power BI, Jira (for Project Management), GitHub, Microsoft Navision (ERP), Service Now (Ticketing System), Office 365. Training with: Microsoft Azure and Azure ML, KNIME, Cloudera Hadoop Stack.

Boca Raton, Fl, Us

• Maintained and enhanced the CTCA's primary marketing database.• Supported the analytical and reporting requests made to the marketing analytics team.• Automated key analytical and reporting processes.• Maintained the team's servers, including jobs, general security, views, tables, links to other servers, functions, procedures, and queries.• Assisted with ad-hoc analysis projects involving advertising media data, patient statistics, and geographic marketing changes.• Provided End-User SQL query and database guidance. • Primary Tools: MS-SQL Server, SQL, SSIS, Microsoft Dynamics CRM, Cold Fusion, CCS, HTML

Chicago, Illinois, Us

• Marketing Analytics Team Member (Newark/Element14)• Design and support of the North American marketing databases and modeling systems.• Integration of international data. • Responsible for the automation of cleansing, transformation, and loading of marketing related data.• Design and support of key marketing, call center, campaign reports, segmentation models, and various finance/marketing automation projects.• Assisted with database projects that enabled the transition to new e-commerce platform. • Primary Systems/Tools: SSIS 2005/08, MS-SQL Server 2005/08, MS-Access 2007, SSRS 2005/08, PinPoint, Siebel Marketing, Oracle/Toad, Visual Studio (BIDS 2005/08), MS-Access and Excel VB/VBA programming, SQL, and a few projects in SSAS 2005/08.

Chicago, Illinois, Us

Enterprise Reporting / Business Intelligence Team:Completed enterprise systems development/business intelligence projects using Oracle, Microsoft SQL-Server, SSIS, Informatica, and/or VB. Provided Business Objects data warehouse, ETL, and reporting/analysis enhancements while simultaneously providing support, training, and business improvements to end-users.* Researched and resolved reporting, database warehouse, and ETL programming issues for Finance, Accounting, Human Resources, Interactive Media, and Marketing departments.* Implemented data warehouse/data mart universe enhancements to support business analytics and reporting needs.* Developed and supported financial systems to perform monthly data loads and report results.* Assisted with SharePoint Enterprise reporting portal development and support.* Provided first and second level support to Business Objects end-users at all levels of the company.* Implemented customizations to key CRM and SSRS reports.* Gathered, researched, and documented end-user requirements for new data warehouses, and data cubes (SSAS) for analysis and reporting.* Primary Tools: Business Objects XI R2, Informatica 8.1, 7.1, MS-SQL Server 2008, MS Visual Studio 2008/BIDS, SSIS/SSRS 2008, some work in SSAS 2008, Oracle tables (Financials, HR), SharePoint, Toad, Putty, Unix, SVN, Windows Server 2008

Milan, Italy, It

Business Analyst - 2006-2008, Business Intelligence TeamSr. Systems Developer - 2002-2005* Consulted with end-users/mangers and designed, programmed, and implemented highly customized software solutions for the finance and accounting teams.* Provided enterprise wide reporting and analysis for Luxottica Retail North America.Earned an internal “World Class Achievement” award for development and support of a database application. (2003)* Primary Systems/Tools: Business Objects 6.5, SSPS: Clementine, Dreamweaver, MS-Access/VBA, Excel/VB, Acxiom, Oracle tables (Financials), PeopleSoft HR

Nuremberg, Bavaria, De

Implemented a terabyte sized database and SAS based computing environment on a very limited budget. Made substantial database and automation improvements that improved the speed and accuracy of consumer market behavior research. Managed a team of 2 IT and 5 operations team members. Managed IT projects, budgets, staff development, and corporate technical training.

Stamford, Ct, Us

* Sales and marketing team member.* Used SPSS and mapping/database software to analyze consumer behavior.* Produced key reports and analysis for the Cincinnati sales and marketing division. * Automated manually intensive reporting processes.

Cincinnati, Oh, Us

* Installed the company’s local area network, email system, and overall computing infrastructure.* Provided company wide technical training and IT support.* Programmed a simulation of a new manufacturing process that enabled the company to gain greater confidence in proceeding forward with a multi-million dollar plant and equipment innovation.* Held accounting/finance responsibilities including the coding of intra plant transfers, and the monthly production of the P&L reports, including P&L questions and follow-up analysis.Treasurer’s award for outstanding work during the local area network installation, and for end-user support. (1995)

Responsible for the development and maintenance of Cincinnati Bell’s customer records information reporting system and revenue and products information reports system. Field engineers and sales analysts depended on the results of these systems.

Collaborated with over a dozen different consulting firms to build a very large custom system for Grumman Data Systems/USAF. After recently graduating from college this was a great hands-on experience to learn the methods and techniques used by other teams and their senior experts.

Worked as a salesman during two college winter breaks (6-weeks each). Learned to assess customers, meet quotas, close sales, use pos system, and assist with inventory audits.

Mba, Business

Bba, Majors: Finance And Management Information Systems