Sr Manager Business Intelligence
Fossil
Total years of experience :10 years, 1 Months
Fossil - Dallas, Texas March 2012 - Till Date
BI Manager
In his role as Manager, Global Business Intelligence - Successfully completed multiple projects within budget with varying team sizes of up to 15 members - including Onshore, Offsite combinations.
In his role as Manager, Global Business Intelligence - Lead a Major Retail Mobile Analytics solution Rollout implementation for the company’s store manager group.
In his role as Manager, Global Business Intelligence - Lead Technical BW 7.3 upgrade, Retail Executive Dashboard, Automate Validation Projects.
ShaneCo - Denver, Colorado April 2010 - March 2012
Lead: Sr SAP BI Consultant
In his role as Lead Sr. BI consultant for a Major Retail client- Initiated and Lead establishing key BI guidelines, Knowledge base and Data governance across the Enterprise.
In his role as Lead Sr. BI consultant for a Major Retail client- Fully Automated the Manual reporting process of all key Management reports. Customized the BEx reporting environment to flush out report with a single click of a button. Optimized Performance and Cleanup of key BI reports.
In his role as Lead Sr. BI consultant for a Major Retail Client - Identified GAPS in the data warehousing architecture which lead to consistent reporting errors. Lead a team with short and long term corrective measure correction and redesign.
In his role as Lead Sr. BI Consultant for a large Electronics Client, Installed & Customized FI Business content as strategic Initiative reducing FI reports runtime from 3 days to couple of hours.
Sumco - Phoenix, Arizona.USA Feb 2009 - March 2010
Sr SAP BI 7.0 Consultant
In his role as Lead Sr. BI Consultant for a large Electronics client, customized multiple FI, SD, MM Extractors to Reporting additions suiting end user requirements and Enhancements.
In his role as a Lead Sr. BI Consultant for a large pharmaceutical client, kicked off major initiatives on Purchasing, Inventory and Sales reporting initiatives. This included Requirement gathering, Work packages and technical specifications for design, development, testing and Roll out strategy.
GlaxoSmithKline-UK Jan 2008 - Dec 2008
Lead: Sr SAP BI 7.0 Consultant
In his role as Sr.BI Consultant across industry clients, Extensively worked on BW ETL components Cubes, ODS, Multiproviders, Config/lookup tables, Programs, process chains, reporting agent, process chains, , Custom emailing, Aggregates, Partitioning, Indexes, queries, web templates, download scheduler, Hierarchies, Nav. Attributes etc.
In his role as Sr.BI Consultant across industry clients, Worked across Direct data sources within LO Cockpit, Generic Data Extractors. Installation of FI, SD, MM business content and customized cubes to suite the end user requirements. Solid experience in SAP BW reporting working on different aspects of the presentation layer such as Business Explorer, Analyzer, Query designing, Filters, Variables, Conditions, broadcasting and working with WAD. Created summarized reports which includes display of Plan/Actual variance measures, analysis of full cost by cost center, overdue analysis, and analysis of payment history. Developed and Tested Web Reports for drill down functionality including updating rules and transfer rules & verifying queries.
Nissan, Japan April 2007 - Dec 2007
Lead: Sr SAP BI Consultant
• Gathered business requirements and defined deliverables along with functional analysis and worked with SAP R/3 functional consultants in business areas.
• Development of data model to satisfy the various functional requirements by implementing queries and cubes using business content. The main cubes developed are Customer (0SD_C01), Sales Overview (0SD_C03), Delivery Service (0SD_C04), Purchasing Data (0PUR_C01) and Vendor Evaluation (0PUR_C02)
• Worked with functional consultant for mapping the source data (R3/non R3) to target Data Sources in BI. Defined the initial sizing requirements based on source data volume estimates. configured Custom cubes, Transfer rules, Transfer Structures, Update Rules, ODS, Cubes, Aggregates, queries and workbooks.
• Worked with all development activities in BW - Cubes, ODS, Multiproviders, Config/lookup tables, Programs, process chains, reporting agent, process chains, , Custom emailing, Aggregates, Partitioning, Indexes, queries, web templates, download scheduler, Hierarchies, Nav. Attributes etc.
• Direct experience using data sources within LO Cockpit, and LIS extractors, Generic Data Extractors
• Installation of FI, SD, MM business content and customized cubes to suite the end user requirements.
• Solid experience in SAP BW reporting working on different aspects of the presentation layer such as Business Explorer, Analyzer, Query designing, Filters, Variables, Conditions, broadcasting and working with WAD. Created summarized reports which includes display of Plan/Actual variance measures, analysis of full cost by cost center, overdue analysis, and analysis of payment history. Developed and Tested Web Reports for drill down functionality including updating rules and transfer rules & verifying queries.
• Prepared BW architecture for BW FI, HCM community to understand the data architecture at Functional / Technical detail level.
• Monitoring and implementing the solutions to the errors in the Production System. Worked on performance of queries and performed various tuning techniques using Compression, Aggregates and Multiproviders.
Planman Consulting- India Aug 2005 - Mar 2007
SAP BW SEM Consultant
• Worked on a new BW implementation, Information gathering from business analyst for Data Modeling, Business Content, Granularity, and Performance Tuning Identifying the Key Figures, Strong Entities, and Attributes of the entities, Archiving, Time Frame for Loading etc.
• Responsible for design, development and extraction from R/3 Source system and flat files to BW for FI & CO. Worked with functional consultant for mapping the source data (R3) to target datasource in BW.
• Generated Export DataSources to transform data from one InfoCube to other InfoCube. Scheduled Daily/Weekly/Monthly data loads. Managed and monitored data loads with full upload and delta mechanism. Created Infoset for master data to enabling querying on data.
• Created summarized reports which includes display of Plan/Actual variance measures, analysis of full cost by cost center, overdue analysis, and analysis of payment history. Developed and Tested Reports for drill down functionality including updating rules and transfer rules & verifying queries.
• Solid experience in SAP BW reporting working on different aspects of the presentation layer such as Business Explorer, Analyzer, Query designing, Filters, Variables, Conditions, broadcasting and working with WAD.
HMCo Dec 2004 - Aug 2005
SAP BW Consultant
• Worked on developing the following projects: BW day-to-day Data Load Support
Management Reports
• Handled the tickets of priority 1, 2 and 3 by following (SOP) Standard Operating Procedures and never missed the (SLA) Service Level Agreement.
• Involved in performing Production Support activities like Ticket Analysis report, Resource Utilization Report, Time sheet maintenance of the support team.
• Supported the client by providing long-term solutions to the tickets by doing Root cause Analysis.
Actively and regularly involved in Load Monitoring of Daily, weekly, and Monthly, Data Loads using Process Chains.
• Actively Involved in Rectification of Load Failure errors like Master Data Loads, Transaction Loads.
Monitoring of info packages and analyzing the reasons for frequent failures of infopackages.
Farnam Companies Sep 2003 - Dec 2004
SAP BW Consultant
• Worked on Supporting the following: BW day-to-day Data Load Support
Management Reports
• Maintaining Work History for all the tickets until it is closed down.To communicate with the customer who post the ticket.
• Interacting With the clients from time to discuss open issues.
• Handled the tickets of priority 1, 2 and 3 by following (SOP) Standard Operating Procedures and never missed the (SLA) Service Level Agreement.
• Involved in performing Production Support activities like Ticket Analysis report, Resource Utilization Report, Time sheet maintenance of the support team.
• Supported the client by providing long-term solutions to the tickets by doing Root cause Analysis.
Actively and regularly involved in Load Monitoring of Daily, weekly, and Monthly, Data Loads using Process Chains. Actively Involved in Rectification of Load Failure errors like Master Data Loads, Transaction Loads.
• MBA (Finance & Marketing Dual Specialization) - International Management Institute, Belgium.
• Bachelor of Engg (Computer Sc.) B.S. - Viswesvaraya Technological University - India