Sr Bi / Technical Analyst
Boston, Massachusetts, Us
Senior BI Analyst/Architect analyzing, developing and maintaining numerous systems for Finance, Inventory, Editorial, Marketing and Sales departments of a $1.8 billion enterprise, providing effective solutions for executives, management, local users and 500 sales reps nation- and worldwide• Sales Ops Data - Executive summary to rep detail, star schema data source, Oracle based materialized views, USA/International• Dashboarding in MicroStrategy for the Trade Sales Division on top of a dimensional datamart• Acquired company data integration - Processed, mapped & matched millions of rows of disparate data into corporate systems• CRM development - Added functionality & enhanced a PowerBuilder CRM system, Sybase ASE/ASA data replication• Built and implemented a Reverse Product Kit Tree resulting in enhanced Inventory control and Kit comprehension• Produced an interactive Opportunity Pipeline/Forecasting system, including Order to Opportunity cross referencing• Sybase, Oracle, PowerBuilder, SAP/BW, BEx, BOE/Crystal Reports, Microstrategy, dashboards, star schemas, dimensional modeling, entity relationships• Agile Scrum/Sprint work environment