Michael Seger

Michael Seger Email and Phone Number

RESULTS-DRIVEN, HANDS-ON DATA / BUSINESS ANALYST @ Wellington, FL, US
Wellington, FL, US
Michael Seger's Location
Wellington, Florida, United States, United States
Michael Seger's Contact Details

Michael Seger personal email

n/a
About Michael Seger

RESULTS-DRIVEN, HANDS-ON SENIOR DATA / BUSINESS ANALYST WITH VERSATILE SKILL SET Data Analytics, Business Intelligence, Dashboards, Reporting, Data Migration• Deep experience in complex analytics, dashboards and reporting - see Gartner, Diageo, Tory Burch and Merck.• Solid hands-on experience in SQL and relational data models complemented with certification by NYU.• SQL Server Transact-SQL (T-SQL) certification by Microsoft including complex queries and stored procedures.• Data Analysis certification by Microsoft with in-depth Power Query, Power Pivot, DAX and cube functions.• Data Science certification by Microsoft including in-depth Power BI and Azure Machine Learning Studio.• Applied Data Analytics certification by Microsoft including analytics storytelling and data legal issues.• Adept at data-driven insights and identifying key trends to drive business results – the "headline" in the data.• Deep hands-on experience in all aspects of data migration – see Bloomberg.• Well-honed skills and deep expertise in data mapping, cleansing, modeling, validation and quality assurance.• Extensive experience in extracting data from disparate sources and creating usable, actionable summaries.• In-depth hands-on knowledge of data warehousing including star and snowflake schemas. Business Analysis / Project Management• Well-honed business analysis and project management skills - six years as a Big Four (E&Y) consultant.• Deep financial services experience – see Bloomberg, Morgan Stanley, Citi and Futures Industry Association.• Extensive, wide-ranging CPG experience including PepsiCo, Diageo, Playtex, and Tory Burch.• Excellent oral and written communication skills with the ability to explain complex issues to all levels.• In-depth experience in requirements gathering, analysis and documentation including BRDs, FRDs and DFDs.• Well-developed collaboration and facilitation skills – can build key relationships across an organization.• Deep hands-on project planning know-how – well-grounded in both Agile and Waterfall SDLC methodologies.• Demonstrated capability to deliver under pressure and manage competing priorities.• Proven tenacity and resiliency in delivering first-class solutions - on-target, on-time and on-budget. Technical Expertise and Experience• Heavy Excel/Access/VBA development including Microsoft Office integration/automation/re-engineering.• Up-to-date certification in Python 3.x by Microsoft including an introduction to Python for Data Science.• In-depth technical acumen allows effective partnering with development teams.

Michael Seger's Current Company Details
Global Hedge Fund

Global Hedge Fund

RESULTS-DRIVEN, HANDS-ON DATA / BUSINESS ANALYST
Wellington, FL, US
Michael Seger Work Experience Details
  • Global Hedge Fund
    Global Hedge Fund
    Wellington, Fl, Us
  • Global Hedge Fund
    Consultant, Investment Engine Technology
    Global Hedge Fund Apr 2019 - May 2019
    As a technology operations engineer supporting the Investment Research function of a world-renowned hedge fund, resolved incident reports and service requests using both proprietary and third-party tools including SQL Server Management Studio (SSMS), Apache Subversion (SVN), TeamCity, ActiveBatch, HP SiteScope, and Axway SecureTransport. Incident reports and service requests are reviewed in daily scrums and tracked using Jira; documentation and run books are maintained in Confluence
  • Bloomberg Lp
    Consultant, Data Analytics And Integration
    Bloomberg Lp Feb 2018 - Feb 2019
    New York, Ny, Us
    As a technical business analyst for the Data Analytics and Integration group of Bloomberg, the preeminent provider of financial technology and market data, played a key role on the global migration and on-boarding team for the POINT-to-PORT (P2P) project, including liaising with client-facing account teams and engineering. This project is the largest data migration undertaking in Bloomberg's history, following the firm's $800 million acquisition of Barclays' portfolio analytics and indices products.
    View
  • Tory Burch
    Consultant, Business Intelligence And Analytics
    Tory Burch Nov 2017 - Feb 2018
    New York, Ny, Us
    As an Excel developer for the Business Intelligence and Analytics group of Tory Burch, an iconic global lifestyle brand, designed and implemented a complex KPI (Key Performance Indicator) dashboard application with data sourced from multiple datasets via the MicroStrategy Excel plug-in. The Excel/VBA application uses Microsoft Office automation to build, consolidate, validate, and distribute detailed metrics and analytics by channel, product area and geographic region to the firm's executive operating team in both tabular and graphical formats. The application makes extensive use of named ranges, VBA and Outlook automation.
    View
  • Russell Reynolds Associates
    Consultant, Global Human Capital
    Russell Reynolds Associates Jun 2017 - Aug 2017
    New York, Ny, Us
    As a Microsoft Office developer for the Global Human Capital group of Russell Reynolds, a preeminent global search and leadership advisory firm, designed and implemented a complex, integrated Excel / PowerPoint application. The application makes extensive use of pivot tables, vlookups and named ranges to produce over fifty highly-formatted presentation decks containing multiple customized data visualizations per slide. Decks are created for the Firm, regions, departments, industry sectors and over forty offices worldwide and are distributed globally via SharePoint. Application is being ported to SQL Server Analysis Services.
    View
  • Gartner
    Consultant, Marketing Strategy And Operations
    Gartner Aug 2016 - Mar 2017
    Stamford, Ct, Us
    As a senior analytics consultant for Gartner, the world’s foremost information technology research and advisory company, revamped, enhanced and expanded a mission-critical reporting and analytics system for the firm's annual calendar of over sixty events worldwide including the Gartner Symposium series, the most important global gathering of CIOs and senior IT executives. The system generates strategic dashboard reports for senior stakeholders companywide and cascades immediately actionable information twice weekly to sales teams designed to drive lead conversion, track pipeline opportunities and maximize profits. Using extracts from several sources including Oracle BI Publisher downloads from the firm's analytics warehouse, the system produces complex Excel pivot tables with slicers using VBA code and dynamic parameter-driven vlookup functions. Output is uploaded to an Alfresco enterprise content management (ECM) system for report distribution globally. Additionally, created complex PowerPoint chart decks for senior management presentations using Think-Cell, the premier Excel data visualization tool.
    View
  • Marsh
    Consultant, Global Service Delivery
    Marsh Feb 2016 - Aug 2016
    New York, New York, Us
    As a senior Excel VBA developer for Marsh, the world’s leading insurance broker and risk management advisory firm, completely re-engineered the Qualified Solutions Group (QSG) Specification Generator Tool. The QSG is an elite industry leading placement center built to drive a more effective process and outcome for property, casualty and FINPRO placements for the firm's global clients. This re-engineering project eliminated thousands of lines of VBA code and greatly improved the ease of maintenance, extensibility and scalability through the use of structured, reusable and modular VBA code. Using data-driven parameters stored in approximately 600 named ranges, the tool dynamically generates over 700 ActiveX controls and produces highly-formatted output
    View
  • Citi
    Consultant, Treasury Investments Asset Allocation
    Citi Mar 2015 - Dec 2015
    New York, New York, Us
    As a senior member of the Solutions, Analysis and Modeling team, played a pivotal role in a critical reverse-engineering project to port an existing Excel-based integrated portfolio analytics system to a new Java/Oracle environment. The current system, used for the aggregation and analysis of Citi's fixed income holdings and related hedging instruments, contains over 30,000 lines of complex Excel VBA code, including over fifty classes, and makes extensive use of indexed collections for in-memory processing designed to optimize performance. Data is sourced from over forty feed files from multiple product processing systems and output is produced as complex pivot tables and graphs (to be replaced by MicroStrategy). A proprietary analytics library, written in C#/C++ and implemented as an Excel add-in, is used to calculate present value and risk measures such as DV01 and CR01.
    View
  • American Express
    Consultant, Asset-Backed Securitization (Abs)
    American Express Oct 2014 - Feb 2015
    New York, Ny, Us
    Totally re-engineered a large, complex Excel-based application underpinning the asset-backed securitization (ABS) accounting operations for the $29.5 billion American Express Credit Account Master Trust. This transformational project has the twin goals of enhancing maintainability and improving auditability for both internal and external parties, including regulatory authorities. The application automates the creation of both month-end and distribution journal entries for upload to an Oracle-based general ledger and produces servicer documents to facilitate filings with the Securities and Exchange Commission (SEC). Complex lookups, named ranges and VBA macros are used extensively throughout the application.
    View
  • Futures Industry Association
    Consultant, Fia Tech
    Futures Industry Association Oct 2013 - Oct 2014
    Washington, Dc, Us
    Designed, built and supported several mission-critical applications for the Futures Industry Association (FIA), the world's leading trade association for the futures, options and cleared swaps markets. These applications include:• Data-mining tool used to collect, summarize, and format market volume data from the web sites of approximately twenty Swap Execution Facilities (SEF), a new type of trading venue registered with the Commodity Futures Trading Commission (CFTC) and mandated under the Dodd-Frank Act to introduce transparency in derivatives trading. The data collected is aggregated and published in both tabular and graphical formats in FIA's SEF Tracker. Implemented in Excel, Access, VBA and Acrobat API. • Prototype data collection tool designed to facilitate implementation of the CFTC's Account Ownership and Control Reporting (OCR) directive to collect certain ownership, control, and related information for all futures trading accounts to enhance regulatory compliance and transparency of futures and swap market participants. Implemented in Access and VBA.• Data collection and aggregation tool used to gather monthly market volume and open interest data for futures and options traded and/or cleared at more than 80 exchanges worldwide. Data is published by FIA in tabular and graphical formats both monthly and as an annual report on global volume trends. Implemented in Excel, Access, Word, VBA and Acrobat API.• Excel-based downloadable standard rate schedule for FIA's Electronic Give-Up System (EGUS). EGUS allows brokers, traders and customers to electronically execute the FIA uniform give-up agreements and the FIA-ISDA Cleared Derivatives Execution agreement. Implemented in Excel and VBA.
    View
  • Diageo
    Consultant, Business Analytics
    Diageo Nov 2012 - Aug 2013
    London, Gb
    Played pivotal role on the Actuals/Results analytics team, a key element of the Commercial Planning System (CPS) project, at one of the world's largest and most successful consumer products companies. Designed and developed business intelligence (BI) tools to support in-depth analysis at a granular level of over a billion dollars in planned versus actual advertising, promotional and trade investment spending, enabling timely fact-based decision-making and more effective future program targeting. Employing Agile rapid deployment tactics and techniques, developed, implemented and supported Excel analytical tools and dashboards using complex pivot tables, slicers, lookups, and VBA, including bi-directional data transfers to/from an Oracle / SAP data warehouse.
    View
  • Merck
    Consultant, Workforce Analytics
    Merck Jun 2010 - Aug 2012
    Rahway, New Jersey, Us
    Designed, built, and administered systems used to validate, analyze, align, and aggregate employee job structure data collected in disparate formats from approximately ninety countries to support the post-merger global integration of Merck and Schering-Plough. This re-engineering effort culminated in the successful transition by the newly combined firm to a band/pathway/level-based compensation and career framework. Also provided analytical and reporting support for job mapping validation, market assessment, and impact determination. Additionally, furnished ad hoc reporting, metrics, and analytical assistance including modeling support for the annual total compensation planning cycle. Tools used were Access and Excel in an SAP HCM / SQL Server environment.
    View
  • New York Life Insurance Company
    Consultant, Human Resources Information Systems
    New York Life Insurance Company Jul 2008 - May 2010
    New York, New York, Us
    Re-engineered the executive compensation process from a collection of Excel spreadsheets into an integrated VBA/Access/Excel application - recently implemented phase II enhancements and extensions, including business scorecard modeling and an interface to firm's SAP Business Information Warehouse (SAP BW) via ODBC. Also designed and implemented a large, complex diversity reporting system, including goal setting, workforce tracking, and AAP reporting, using Access and VBA. This system has yielded not only more timely and flexible reporting, but also substantial recurring out-of-pocket cost savings. Additionally, played key role in the conversion of several deferred compensation plans between two outside vendors using VBA, Access, and Excel.
    View
  • Bear Stearns
    Consultant, Human Resources Information Systems
    Bear Stearns Oct 2006 - May 2008
    Spearheaded the initial analysis and design of a Human Capital Management (HCM) data warehouse to be complemented with cutting edge business intelligence (BI) tools (IBM Cognos v8) for the entire firm. In addition, provided metrics and analytical support to the Global Head of Human Resources and her staff in the areas of headcount tracking, turnover, diversity, recruiting, talent management, and career progression. Technology used was PeopleSoft HRMS (migrating to version 9), Access, and Excel.
  • Morgan Stanley
    Consultant, Private Equity Group
    Morgan Stanley Feb 2004 - Oct 2006
    New York, Ny, Us
    Played key role in the design and development of an integrated reporting platform to afford both investor relations and accounting groups easy access to key data from several "silo" systems. Architecture was a C#.NET/Infragistics front-end and a SQL Server reporting repository. Additionally supported a large, complex system used by the firm's private equity unit to track over $5.8 billion of investments and to report results to both firm management and the funds' limited partners. The system calculated cash flows, terminal values, and IRR for each investment vehicle using Access, Excel, and VBA. Also supported a contact relationship management (CRM) system, implemented in ASP.NET and SQL Server, used by the venture capital group for deal flow tracking.
    View
  • Citi
    Consultant, Corporate Compensation And Benefits
    Citi Sep 1994 - Mar 2003
    New York, New York, Us
    Designed, built, and supported several large, complex Access/VBA systems used to collect, validate, summarize, and report incentive compensation data for Citigroup's 260,000 employees worldwide. These systems supported the annual bonus process, a sweeping benefits program re-design, and several very large stock option programs. Data ranged from massive extracts from both legacy mainframe systems and client-server databases to Excel spreadsheets and text files from business units in a wide range of formats. Also played pivotal role in the client-server implementation of Citibank's global compensation system using PeopleSoft and Oracle, including design review, conversion of legacy system data, and creation of complex reports using Crystal Reports.
    View
  • Morgan Stanley
    Consultant, Human Resources Information Systems
    Morgan Stanley Mar 1994 - Sep 1994
    New York, Ny, Us
    Designed and implemented several Access applications to migrate critical incentive compensation data from mainframe systems. In addition, designed and implemented a detailed executive compensation analysis which summarized all cash, stock, and option awards in both tabular and graphical presentation-quality formats. Other projects included the design and implementation of a comprehensive incentive compensation system consolidating key data from disparate sources to facilitate rapid ad-hoc query.
    View
  • Lehman Brothers
    Consultant, Core Systems Division
    Lehman Brothers Feb 1993 - Mar 1994
    Us
    Played key role in the migration of a large mainframe application to a Sybase/C++ client-server environment using iterative prototyping and object-oriented analysis and design (OOAD) techniques. Also supported a legacy mainframe application that provided round-the-clock on-line access to over six million daily transactions to Lehman's three major global trading centers.
    View
  • Pepsico
    Project Manager, Controller'S Group
    Pepsico Jun 1991 - Jan 1993
    Purchase, New York, Us
    Spearheaded the analysis, design, and implementation of an integrated financial reporting and consolidation system. This full life-cycle project replaced an outmoded custom mainframe system with a client-server solution, yielding not only strategic benefits through improved access to critical data, but also increased reliability and substantial recurring out-of-pocket cost savings.
    View
  • Ernst & Young
    Senior Manager, Northeast Management Consulting Group
    Ernst & Young Jan 1987 - May 1991
    London, Gb
    • Engagement manager at PepsiCo for the design, development, and implementation of a lease accounting system. This system tracked approximately five thousand leases and performed all lease accounting functions in full compliance with FAS 13.• Team manager at Sony Music for the design, development, and implementation of an international royalty accounting system. • Team manager for the Mayor's Private Sector Survey. Led a team in the exploration, identification, and recommendation of strategies to improve the effectiveness and efficiency of the New York Police Department by the use of information technology.• Manager of a litigation support engagement in the defense of ExxonMobil against an allegation of patent infringement. The engagement required complex analyses under tight deadlines of sales, cost, and product specifications over a ten-year timespan.
    View
  • Computer Task Group
    Technical Services Manager
    Computer Task Group Jul 1985 - Dec 1986
    Amherst, New York, Us
    Managed unit of thirty individuals which provided design and programming services to major clients in the New York metropolitan area, including Pfizer, Mobil, Citicorp, and Merrill Lynch. Increased revenue 65% on an annual basis. Also served as technical consultant and data architect at American Express for the design, development, and implementation of a fixed assets system.
    View
  • Ernst & Young
    Manager, National Decision Support Services Group
    Ernst & Young Sep 1983 - Jul 1985
    London, Gb
    • Technical consultant and data architect for the office of General Counsel of General Motors. Advised on the design, development, and implementation of an integrated system including case management, outside counsel fee tracking, and document indexing.• Technical consultant at Marion Laboratories, a division of Sanofi-Aventis. Consulted on the use of prototyping in the design and implementation of an integrated system to support the preparation of new drug applications to the Food and Drug Administration.• Technical consultant at the New York City Department of Environmental Protection. Designed, developed, and implemented financial models for the analysis of several multi-billion dollar projects for the largest municipal public works venture in history. • Project manager at ExxonMobil for the design, development, and implementation of a contract abstract database designed to provide both improved administration and business intelligence (BI) in an environment of increased competition and federal deregulation. The system was successfully implemented under tight deadlines using iterative prototyping.• Technical consultant at US West (now Qwest), a Bell regional operating company, on the use of rapid application development (RAD) techniques and iterative prototyping in the design and implementation of a federal tax reporting system for fixed assets.
    View

Michael Seger Skills

Design Leases Accounting Technical Consultant Fas Compliance Management Consulting

Michael Seger Education Details

  • Princeton University
    Princeton University
    Bachelor Of Arts
  • Nyu Stern School Of Business
    Nyu Stern School Of Business
    Dual Major In Information Systems And Accounting

Frequently Asked Questions about Michael Seger

What company does Michael Seger work for?

Michael Seger works for Global Hedge Fund

What is Michael Seger's role at the current company?

Michael Seger's current role is RESULTS-DRIVEN, HANDS-ON DATA / BUSINESS ANALYST.

What is Michael Seger's email address?

Michael Seger's email address is mc****@****ine.net

What schools did Michael Seger attend?

Michael Seger attended Princeton University, Nyu Stern School Of Business.

What skills is Michael Seger known for?

Michael Seger has skills like Design, Leases, Accounting, Technical Consultant, Fas, Compliance, Management Consulting.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.