IBM Planning analytic TM1 Business requirements gathering, analysis, coding and support - Finance, budget and forecasting. Use of Cubewise tools Arc and pulse. Use of TM1py.

Data conversionTransfer of customers into new POS system while interfacing with data extraction team, finance and pricing on the what and who to transfer. Heavy use of SSIS, SQL(SQL server) and C#.

•Created Microstrategy reports using Web Professional.•Tested Microstrategy report in the pre-UAT phase by pulling data from the staging area using SQL and running production report in Cognos.•Translated internal and external client information requests (vague or not) into deliverables including creating reports with Cognos Reporting studio either from the model or using direct SQL, automating reports, scheduling report, creating and modifying jobs, creating scheduled report views, burst reports and the like. •Created Access database to format complex data and calculate earned premiums reducing time spent from 5 days to a few hours. Prepared the COR (a customer metric) report quarterly using Excel, Access and Cognos.•Managed daily errors for a specific client using Excel, Word, Access, Cognos and Outlook.•Did the weekly and monthly quality checks on files for another specific customer.•Created visual user instructions and did a quick Cognos user training using Word and PowerPoint. •Extracted and created customized Google analytics reports. •Supported the ETL developer with technical details of existing reports for migration purposes (Cognos --> Microstrategy) using Excel, Management Studio (SSMS), SQL Developer (Oracle), DB visualizer and Word.•Created the SQL code needed to transfer the daily data for a specific customer.•Updated rates table and revamped a policy management excel file using VBA. •Proposed and adopted naming convention for reports. •Documenting in Word most of the above tasks.

•Evaluated and built ad-hoc reporting using different data sources including Application System on Mainframe, ODBC driver to SQL replica in Access, Cognos, BI Hummingbird and other in-house ftp sites. Validated and analyzed data with Access, Excel or Minitab to determine improvement opportunities. •Prepared monthly customer KPI Implemented survey procedures for Service desks using Survey Monkey and Excel. Developed new KPIs using raw data to formulate yearly baselines for performance improvements using Excel, Cognos, Access, Word and PowerPoint.•Attended and presented during bi-weekly management conference calls using Excel and PowerPoint. •Completed Six Sigma project on one of the top 10 yearly projects to mitigate penalties. Effectively stopped all penalties paid. Tools used: Minitab, PowerPoint, Excel and an in-house project management software. Six Sigma is a data driven approach (Statistics) in problem solving requiring tenacity, data analysis, problem solving (symptoms versus causes), keeping all actors involved in the process up to date on progress by providing a dashboard all the while meeting deadlines. •Taught and coached Six Sigma using Excel, Visio (process maps and data maps), Powerpoint, Word and Minitab. •Supported the MS Access database, built during tenure as Head of VAS, for extraction of billed back orders from ordering systems. •Assisted the local Master Black Belt in evaluating Six Sigma coursework to provide efficiency and retention for introduction course and Green belts 4-day training using PowerPoint, Minitab, the in-house project management system and Word. •Developed, coordinated and executed successful remote training for a large delivery group using PowerPoint.

Head of VAS Data Validation & VAS Data Validation Data Analyst(VAS=Value added services which was messaging)• Managed eight staff members, primarily located in Cairo, by providing training, setting objectives and supporting as needed. Tools used: PeopleSoft, Excel and Access.• Did mostly data analysis of billing trends and data quality using Application System on Mainframe, ODBC driver to SQL replica in Access, BI Hummingbird, Excel and other in-house ftp sites. Produced a 16% accuracy increase in IP ordering to billing data in six months (81.8% to 97%).• Handled data incidents pertaining to routers using in-house incident management system or Remedy. Significantly decreased the incident closure time from 3+ days to 1.35 days. • Transferred all MTN and VAS tasks to Cairo staff. • Built the Access database utilized for extracting billed back orders from the ordering system.• Prepared and delivered timely billing data, meeting all SLAs (EDI, X400, SMTP, FDS, BFAX, IPFAX, and IP).• Collaborated with data providers to resolve issues and meet deadlines

Supported end users in identifying and creating solutions to complex issues, and executing alternative methods when needed. Prepared and presented documentation on budgets and solutions, and created web pages. Key Accomplishments:• Identified and developed alternate solutions for complex issues. • Created customized databases for specialized solutions. • Participated in the integration of third party software development.