Project Customer Service

Tarek S.Aly

615-***-**** (Home)

615-***-**** (Mobile)

************@*******.***

Professional History

Parallon Business Solutions - Aug 2012 – Feb 2013

Microstrategy BI Architect/Developer

TeraData, MS SQL Server 2008, Microstrategy BI V9.2.1

General Responsibilities

Perform maintenance and updating the warehouse catalog and meta data .

Perform Creating the project wire-frame and schema objects such as facts, aggregate facts,Logical Views, updating schema objects such as attributes, hierarchies, in addition to configure application objects for the project.

Responsible for developing required project's supporting templates,documents, analytic reports, multilayer-ed dashboards, scorecards using the MSTR applied services such as Report documents service, OLAP, Drilling, selectors, Prompts..etc.

Work closely with the DBA to achieve the maximum performance tuning at the data base level through refining the data model/ integrate MSTR capability solutions .

Apply the technical techniques to tune the performance at the Project VLDB settings.

Participate in ETL batch process and warehouse update cycle.

Develop the required security filters/project access/user and groups privileges and define object ACLs.

Develop and apply complex SQL queries and query optimization techniques.

Integrate data mining application as part of tends and forecast features into dashboards.

Projects Accomplishments

Convert the DMR (Data Management Revenue) web Dashboard into Iphone/Ipad analysis dashboard.

Designed and developed a full real time, centralized write-back/Transaction Services app for HCA - HSC hospitals corporate which provides them with interactive staff schedules and provide dynamic forecast analysis for the backlog/ hours needed to complete the charts for various patient's units.

State Of tennessee Dept of Children's Services - Dec 2004 - July 2012

Project Team Leader/Sr.Systems Analyst

Oracle 10g, PL-SQL, SQL Oracle Discoverer, 10G Data warehouse,

Crystal Report Ver.10/11, TOAD,

Enterprise MicroStrategy Business IntelligenceV8.1/V.9.0.2

General Responsibilities

Translate business requirements using complex methods and models to determine appropriate system solutions.

Work with end users, business analysts, technical staff, and project team members to plan, design, develop, implement, and enhance business analytic capabilities using MicroStrategy.

Support all phases of project life-cycle (design, build, test, and implementation), including business process change and enhancements

Provide technical leadership on complex projects by devising approach and cohesive solutions

Partner with Data Model and ETL teams to convey enterprise data needs for reporting requirements

Perform gap analysis on business requirements and technical design, recommend adjustments if necessary

Participate in ETL and physical data model design and reviews

Collaborate with cross-functional teams in creating optimal, maintainable, and scalable architecture

Owns and manage enterprise BI application environment strategies for (Development, QA, and Production environments)

Perform migrations of objects between project sources

Provide support for development issues related to architecture and/or performance

Support user, performance and regression testing efforts

Mentor, coach, and train fellow associates in technical and business competency growth

Data warehousing & Microstrategy Accomplishments:

Technical Team leader/Senior Architect for Microstrategy Projects such as (Resource homes/Placements/CFTM/Health Services) modules.

Participated in gathering and analysis with the stakeholders and various business units’ requirements that served the current and the future reporting needs from the data warehouse.

Partially represented DCS agency in the negotiation of defining the data warehouse architecture, specifications and final applied design such as (Basic, staging, staging with data marts) models.

Carried-out the creation/ maintenance of the applied DCS End Users/ Business/Developers(Web/Desktop) groups defining Roles, Security and access privileges in Microstrategy BI Tool.

Conducted Creating/Updating Microstrategy’s project Meta Data objects foundation such, Microstrategy Tables’s Catalog and connecting the WH schema to Microstrategy Projects environments(Development/Testing/Production) and responsible for the migration among the environments.

As an Architect’s role, I was responsible to Create/Maintain The Microstrategy’s Schema objects such as logical tables, Look-up tables, relationship tables, attributes and hierarchies and the fact tables), with a robust definition of the relationships

As an Architect, I have conducted The Creation/Marinating of The application/Configuration Objects needed for the desktop developers.

Assisted the development team in developing many reports and provide them with the technical support and solutions.

As a developer, I have created/maintained a comprehensive full-featured Dynamic Dashboard that incorporated 5 sub-dashboards, applied top-down modular approach that utilized most of the Microstrategy techniques and features That answers The high management, various Business Units needs.

Created numerous Hyper-linked dynamic detail documents that were driven from the summary graphs with multiple drill paths features to provide the users with an over viewed and detailed level.

List of attended Training by Microstrategy

Microstrategy Architect :Project Designer

Microstrategy Architect: Advanced Project Design.

Microstratgy Desktop : Reporting Essentials.

Microstrategy Desktop: Advanced Reporting 200 – Case Studies.

Microstrategy Desktop: Advanced Reporting 200.

Microstrategy Document Essentials.

MicroStrategy RportServices: Advanced Documents for MicroStrategy DeskTop.

MicroStrategy Report Services: Dynamic Dashboards 100.

MicroStrategy Report Services: Advanced Dynamic Dashboards 200.

Microstrategy : Engine Essentials.

Microstaregy Advanced Data warehouse.

Microstrategy Data Mining Services and advanced Analytics.

Microstrategy Administrator.

Microstrategy Web Administration and Tuning.

Microstrategy Intelligence Server Tuning and Advanced Administration.

Microstrategy Enterprise Manager Essentials.

Microstrategy Engine Tuning and VLDB Properties.

Microstrategy Transaction Services for Dashboards and Mobile App.

Microstrategy SDK Customization Essentials.

Microstrategy SDK Visualization.

Microstrategy Web Professional.

Microstrategy Mobile For Apple@ Ipad and Iphone@.

Microstrategy Free Form SQL Essentials.

Microstraregy Web SDK: API Essentials.

Microstrategy Web SDK: Customizing Security.

Certifications:

MSTR – Certified Project Designer CPD 2012

MSTR – Certified Reports Developer CRD 2013.

MSTR – Certified Documents Developer 2013.

The National Commercial Bank - April 1994 - Oct 2004

Project Team Leader/Sr.Systems Analyst

DB2, CICS, JCL, VSAM, COBOLII,TSO,ISPF,PDF, ORACLE, PL-SQL,

1.Managed and implemented ARAMCO Cash Management System for Treasury dept, which included user requirements gathering, analysis, design, developing, prototyping and implementation phases.

2.Responsible for remodeling the customer information business process with related accounts and programs migration process.

3.Participate in managing and analyzing the Pool rate project For treasury Dept.

4.Responsible for General Ledger accounts enhancement and implementation.

5.Conducted preparing the cost-benefit analysis and added-functions for the account statement project.

6.Managed and designed the development of the Credit/Debit Advices.

7.Supervised and developed Phase-1 of the proposed E-brokerage system.

8.Assisted in planning Migration project for the Core-System from NCR9800 to UNIX.

9.Was chosen as a committee member for Strategic planning concerning Y2K problem project’s phases, schedule tasks, staff resources assignments.

The Investment Bank - Jan 1990 – Feb 1994

Team Leader/Systems Analyst

COBOL/400, DB2/SQL/400, CL/400,RLU, SDA, DDS

1Supervised large team (Business/Technical) in the delivery of The International module which included (Import/Export letter of credits, Outward/Inward transfers, Check remittance and import/export bill of collections modules).

2Managed, developed and implemented in-house Letter of Guarantee Control system.

3Supervised, analyzed and designed vacations, sick leave and end of service compensation modules for the legacy Pay-Roll system.

4Redesigned and developed the Account statement enhancements project.

5Conducted the analysis and design phases for the creation of General Ledger subsidiary accounts.

6Managed and developed the consolidated profit & loss and Balance sheet enhancements project (Analysis, design, developing, testing and documentation phases).

7Supervised the implementation phase of the Trial Balance reporting amendments.

8Developed the Teller proof reporting system for 500 branches.

9Defined the project scope, phases, cost-benefit analysis, time-line schedule for the End of Year audit confirmation status module, along with G/L opening balances correction module.

10Conduct analysis and the design of parameterized utility payments system.

11Maintained the Share system (ESISNET) in corporation with S.A.M.A – Saudi Arabia Monetary agency).

Egypt Arab African Bank - May 1986 – December 1989

Sr.Analyst/Programmer

CICS, VS/COBOL, VSAM, JCL, DB2, BMS, ICCF, BMS

1.Responsible for the implementation of the VISA Card System, documenting the functional specifications and technical specifications (Data Flow Diagrams, Management Overview Diagrams, Action Diagrams, Process definition and system structure charts).

2.Developed and implemented the G/L interface module for the VISA transactions, provided the system familiarization sessions, customization and training for the users.

CITIBANK- August 1984 - April 1986

Application Developer

CICS, VS/COBOL,VSAM, JCL, DB2, BMS

1.Extensively involved in developing, data conversion and customizing the distributed bridge systems (Mainframe/PC server) for Ad hock reporting system.

2.Prepared comprehensive Test plan, created Test criteria, Test scripts along with regression and parallel run for the customer service utility modules.

3.Supported the operational implementation work plan for the production and Pilot-branch.

Education

BA, Int. Trade, Faculty of Commerce & Business Administration 1983.

Contact this candidate