Sales Manager
Resume:
ERIC H. SOUARE
Charlotte, NC 28273
i9358c@r.postjobfree.com
B.S., Business Management
Embry Riddle Aeronautical University; Daytona Beach, Florida
1996
M.S. Information Systems Technology Candidate
Depaul University,Chicago, Illinois
2013
CERTIFICATIONS
• Microstrategy Certified Project Design
• Microstrategy Certified Report Developer
• Microstrategy Certified Platform Administrator
• Cognos Impromptu User and Administration
• Certified Annuity Specialist (CAS)
CLEARANCE:
Active DOD Secret Clearance.
TOOLS & TECHNOLOGIES
BI Tools:
Microstrategy 9.0 : Desktop, Architect, Web, Enterprise Manager, Administrator, Object Manager, Narrowcast Administrator, Cognos Impromptu User 7, Business Objects XIR3, Crystal Reports
Databases:
Oracle 9i, 10g, MS SQL Server 2008, MS Access 2007, Teradata, Netezza.
Development Languages:
SQL, SQL+8
Operating Systems:
Windows NT/XP/2000, Unix
Data Modeling Tools:
MS-Project, SDLC, Visio
Languages:
Native French, Conversational Spanish
PROFESSIONAL EXPERIENCE
Senior Application Developer (Contract)| Board of Governors of the Federal Reserve Bank of the United States|, 2-201*-*-****. Washington D.C.
Environment: Microstrategy 9, Sql Server 2008.
• Serve as enterprise reporting consultant for the Bank Supervision Department. Conducted a Proof of Concept on management and activity executive reports related to bank audit and compliance to federal guidelines, using Microstrategy 9.2.1
Business Intelligence Architect | Bank of America, Charlotte, NC | 9/2009-1/2012
Environment: Business Objects RX3I, Microstrategy 9.01, Oracle 10g
• Perform information systems needs assessment, information collection, and recommend appropriate business solutions and IT infrastructure for the Microstrategy platform. Plan, conduct and direct the definition and analysis of business intelligence data requirements & needs on behalf of individual business stakeholders. Meet service level agreements.
• Design summary data models, reports and dashboards for desktop, web and mobile platforms.
• Gather requirements from account manager and principals, establish timelines, deliverable deadlines, and project scope, negotiate sizing and delivery. Liaise with backend developers on table load schedules, data values etc…
• Develop enterprise reports related to BOFA wealth management performance, risk management and fraud related cases. Develop Balance sheets and Income statements categorized by bank Associate and bank reporting hierarchies. Report on bank products such as loans, deposits, capital markets performance, fixed income and derivatives performances, and mortgages.
• Develop reports for distribution using Microstrategy/Business Object XRI3 desktop, web, and MSTR mobile. Integrate Microstrategy report functionalities such as filters, prompts, thresholds; report limits etc. Migrate reports from DEV, UAT to Production within Bank of America user distribution and approval channels and conduct handover sessions with concierge services for ongoing support.
• Design and manage report folders and row level security access for US and EMEA users.
• Contribute to knowledge capital via project documentation and best practice solutioning.
Microstrategy Architect | Fnac; Ivry sur Seine, Paris, France | 5/2009-9/2009
Environnement : Microstrategy 8.12, Oracle 10G
• Develop sales and retail store performance related dashboards.
• Gather requirements from department and regional store managers.
• Model and create tables to accommodate the business needs in terms of fact and dimensions.
• Develop reports for distribution using Microstrategy desktop and web.
Microstrategy Architect | Belgacom; Brussels, Belgium | 1/2009-4/2009
Environment: Microstrategy 8.12, Business Objects RXI2, Teradata .
• Data modeling and Report development for a Telecom Group, Migration from Business Objects 6.1 to Microstrategy 8.11.
• Analyze the Business Objects universe to determine table keys, parents-child relationships, single and composite keys. Analyze BO reports to identify the reports architecture and components: drills, prompts, filters, data type, and metrics.
• Create SQL scripts and views to model the business model architecture. Import these views into the Microstrategy environment.
• Develop schema objects, facts, attributes (joint child, compound, grouped ID), prompts and configuration objects to replicate the Business Objects reports.
• Develop reports with desired functionalities to include prompts, drill maps, thresholds, grouped sub totals, etc.
• Improve query performance using index on where clauses, privileging “parent to child” relationships versus “fact to look up table.”
• Migrate from development, to UAT, the production upon client validation.
• Document the project design, SQL scripts, the data model and reports as required by the customer.
Enterprise Reporting Consultant | Bouygues Telecom; Velizy, France | 8/2008-9/2008
Environment: Microstrategy 8.12, Business Objects XRI2, Oracle 9
• Proof of Concept Business Objects and Microstrategy.
• Use a grading matrix to compare the two tools with a focus on architecture, system/resources usage during operation, screen functionalities and the needs of the Bouygues Telecom.
• Evaluate BO universe creation against MSTR warehouse catalog and embedded functionalities, schema displays/manipulation, reporting competency, Security, Cache technologies and Administration, IS usage and capacity.
• Coordinate load and stress tests on BO and MSTR using HP Loadrunner.
• Test against Oracle and Teradata. Tested reporting competency, Security, Cache technologies and Administration, IS usage and capacity.
• Write final report and recommendations to client.
Microstrategy Consultant | Computer Sciences Corporation; Charenton Le Pont, France | 5/2008-8/2008
Environment : Microstrategy 8.11, Oracle 9
• Data Modeler/Report Developer using Microstrategy and Graphtalk AIA.
• Report developer role for the creation of schema objects and reports for the French Insurer Groupama. Determine schema objects, configuration objects, objects prompts and metrics on reports.
• Capture requirements from business users and data modelers, documentation of the project, reports description, schema information and dependencies.
• Debug and Migrate SQL scripts into Graphtalk IAI as an ETL process and data retrieval thru Graphtalk IAI.
•
Microstrategy Lead | Tata Consulting Services; Columbus, Ohio | 1/2008-4/2008
Environment: Microstrategy 8.11, Teradata.
• Report Developer and Business Analyst for Nationwide policies reporting division.
• Report developer role for the creation of schema objects and reports for Nationwide Insurance policy rules. Design and develop schema objects, configuration objects, objects prompts and totals on reports.
• Capture requirements from business users and data modelers, documentation of the project, reports description, schema information and dependencies.
• Migrate final reports and objects from DEV, UAT and to PROD.
Microstrategy Consultant | Lancet Software Development; Burnsville, MN | 3/2007-11/2007
Environment: Microstrategy 8.11, Oracle 9.
• Various Architect and Report Developer roles in banking, medical, and manufacturing sectors.
• Created complex queries and design reports using requirements from internal customers.
• Fulfilled weekly, monthly, quarterly and other time based business performance metrics and requests.
• Provide trending, customer and product, multi dimensional reports or analysis.
• Coordinated with departmental analysts for designing, testing, and delivering approved reports.
• Data modeling to render the tables structured for Microstrategy queries thru re-mapping columns id’s in de-normalized tables. Creation of hierarchies, MSTR partitioning, etc.
• Provide analysis and recommendation for MSTR applications upgrades or additions.
• Install applications and mappings to relevant databases; administer security roles/security filters on reports or other objects.
Systems Analyst | Boeing; Mesa, AZ | 7/2006-1/2007
Environment: Cognos 7, Microstrategy 8.0, Oracle 9
• Financial data warehouse deployment, and Sales/Pricing/Performance Metrics Reporting.
• Support the transition from mainframe to a relational database environment for the Finance Division
• Identify facts, attributes, hierarchies and relationships thru the Configuration Wizard. Renaming of catalog columns to solve heterogeneous naming discrepancies.
• Identify tables and related columns for the warehouse catalog, generated advanced reports with filters, customs prompts, level metrics, custom groups, and consolidations for business analysis and performance management dashboards with BI enhancements.
• Test, validate, and insert calculations or scripts for re-designed new metrics reports.
• Assist business analysts to navigate through BI tools and generate reports through live demonstrations or one on one coaching.
• Assist with Microstrategy navigation, schemas and report design.
• Creation of personalized services and distribution through narrowcast administrator to emails and files locations for various management levels.
• Define summarized/aggregated data to be loaded at target source by ETL team using Informatica. Administer the I-server and seek cache opportunities to improve query performance.
• Participate in JAD, JAR sessions, gather requirements, interview users, and liaise with development teams. Document processes with production/activity diagrams.
Business Analyst | American Express; Phoenix, AZ | 4/2006-7/2006
Environment: MS Access, Excel.
• Develop and Manage MS Access database to support Enterprise E Commerce.
• Support multiple e-commerce projects for the Finance Dept-Global Procurement organization, Enterprise Money Movement, American Express Card Technology platforms and e-commerce. Insure financial systems performance, reliability, and scalability. Follow SDLC methodologies and guidelines.
• Assemble, analyses, and represent internal customer business requirements, perform feasibility analysis and scope evaluations. Manage an Access database with joins, parent-child relationships, analyze, extract/import data to and from the database for varied purposes.
• Extensive financial and ad hoc reports generation and processes documentation.
• Recommend alternative solutions, project strategy and deliverable prioritization.
• Develop high level implementation plans. Produce data and process models.
• Act as team leader/liaison and facilitate JAD, RAD, and DRP sessions.
Consultant, Air Transport Demand Planning, Eustis, Florida, 7/2002-11/2005
• Developed sales revenue, route profitability and growth forecast for various carriers using business intelligence tools. Querying, mining and reporting tools. Create performance indicators and reports for corporate executive planners and sales force.
• Reporting Activities: Advanced reports objects such as filters, prompts, level metrics, custom groups and consolidations, and report limits. Used report services to customize enterprise templates for scorecards/dashboard, and operational reports. Undertook extensive data mining, demand and price analysis, variances and critical cost drivers. Identify social economic factors which can impact revenue growth. Seek under-serviced markets and evaluate appropriate capacity to deploy critical to prevailing competition.
Senior Analyst, Air Afrique, Abidjan, Cote d’Ivoire, 6/2000-6/2002
• Airline network planning, aircraft allocation and alliances.
• Develop mid-term aircraft allocation, route planning and traffic/revenue forecasts for 11 member countries. Route profitability planning to USA, Europe, Middle East & Africa sector. Corporate financial planning preparation.
• Forecast passenger demand for various markets based on multiple pricing levels.
• Flight and frequency evaluation, aircraft up-gauge/down-gauge scenarios.
• Insure Arrival/departures banks, sloping and separation, block times updates, and maintenance constraints.
• Initiate alliances/interline agreements where revenue opportunity are identified or on challenged sectors.
Schedule Planner, United Airlines, Elk Grove Village, Illinois, 5/1999-5/2000
• Airline Schedule planning, aircraft allocation and maintenance scheduling.
• Formulate the current domestic and international schedule plans for Dulles IAD, Denver DEN, Atlanta ATL, and 30 airports in the Midwest & East Atlantic region. Evaluate new routes, P&L alternatives.
• Formulate fleeting strategy, capacity changes driven by demand and/or fares, seek through flight numbering opportunities and insure departure/arrival bank integrity to maximize flight connectivity.
• Solve operational problems such slots, turn time, and block time updates. Proficient with the Sabre planning and scheduling/querying tools (Airflite, FAM, APM, Brio, SAS).
• Coordinate schedule implementation with marketing, sales, airport operations, in-flight, and code share/alliance partners. Provide input for the planning and enhancement of future schedules and strategic/tactical integration of Star Alliance partners.
Flight Systems Controller, Trans World Airlines, Saint Louis, Missouri, 3/1998-4/1999
Airport Operations Supervisor, Greater Orlando Aviation Authority, Orlando, Florida, 11/1995-12/1996
US Citizen
Contact this candidate