Farhat Ara Email & Phone Number

 Effectively administering GEICO MicroStrategy environment since Fall 2010. Responsibilities include I-server, MicroStrategy web server, user/license management, Narrowcast, Enterprise Manager. Create and maintain MicroStrategy configuration objects (projects, DB Instance, security roles, users, etc) in the production environment. Independently architect MicroStrategy schema objects (basic to high complexity) to reflect the entire data model in the data warehouse. Build application objects (basic to high complexity) and manage projects through entire application development life cycle. Performed MicroStrategy upgrade (I-server, metadata, web server, Narrowcast). Configured Enterprise Manager and Narrowcast system. Developed actionable and intuitive dynamic executive dashboards, using various widgets and selectors. Developed from the scratch event-based services in MicroStrategy Narrowcast server. Researched and formulated a performance testing proposal for another MicroStrategy group within GEICO. Jointly work with DBAs to troubleshoot performance issues in the data warehouse. Act as MicroStrategy Tech Support liaison. Communicate with the end user in order to gather business requirements and create technical design documents (report specification forms). Provide BI work breakdown structure and corresponding BI estimate. Proactively communicate with management about issues and corresponding possible solutions during development and testing phase. Interview potential candidates when necessary, and mentor newer members in the team. Act as the ambassador for the EDWBI team and demonstrate MicroStrategy functionalities to business groups within GEICO. Viewed as the “go to” person of the EDWBI team, who has strong technical skills, will follow up, and take action quickly.

Washington, Dc

 Extract, organize and distribute data (using SAS, SQL) to support CALG process reviews, and other GEICO initiatives. Produce balanced scorecards (using MicroStrategy), thereby, providing a tool for monitoring the effectiveness of GEICO processes and for making more informed decisions. Build InfoPath forms to facilitate data collection process as part of process reviews.

 Complete data retrieval (using SAS), and diagnostic compilation in order to monitor and analyze operational areas of the company, and thus identifying issues and opportunities. Make appropriate recommendations.  Analyze the performance of various pilot initiatives that are undertaken to improve customer experience. Provide management and external groups with tools and information to assist them in making business decisions and also to understand financial impact of their decisions, thereby, expediting the decision making process.

 Use actuarial techniques to analyze pricing indications and rating factors (that may influence state specific pricing strategy), in order to ensure profitability at state level. Determine, recommend and implement appropriate changes to the state product design.  Independently create final documentation on rate revisions for the DOI. Assist management in both mechanical and theoretical training, peer reviews, and mentoring Pricing Analysts, and thus enhancing efficiency at both individual and group level. Participate in regional and/or countrywide ad hoc analysis (to help resolve issues) and process improvements (to increase efficiency). Act as a liaison with other functions, such as product management and IT.

Master Of Arts (M.A.), Economics

Master And Bachelor Of Social Science, Economics