JALEES AHMED

Phone: addg5c@r.postjobfree.com

+91-994*******)

Seeking assignments in Project Management /Data Warehousing with an organization of repute

Professional Synopsis

oAround 22 years of fruitful experience in the field of information technology.

oExtensive experience in design, development and implementation of Data Warehouse in a multi-platform environment.

oExcellent Project Management skills.

oAdept in end-to-end development of system from requirement analysis to system study, designing, documentation and implementation.

oAn out of box thinker with experience in resolving several critical Code optimizations, data-warehousing, and scalability related problems.

oComprehensive knowledge of Oracle, SQL Server. Data-warehousing /BI-Tools,ETL Tools,OLAP etc.

oAn effective leader with proven abilities in leading teams during the project phase, recruiting and training team members and enabling knowledge sharing among the team.

oA keen communicator with exceptional analytical and relationship management skills. Ability to work under cross-cultural and multi-lingual environments.

Specialities business intelligence, client/server, data modeling, database design, delivery

Managerial

Project Management

Project effort & cost estimating, scheduling, tracking and reporting.

Project planning and Risk tracking.

Supervising adherence to quality processes over complete SDLC.

Managing and providing technical and functional guidance/support to the project team.

Coordinating on onsite-offshore, multi-locational projects with multiple involved parties.

Adhering to agreed Service Levels and involved in Sub-contract management.

Delivering and implementing the project as per scheduled milestones.

Functional

Data Warehousing

Designing, developing, testing and deploying custom data warehouse systems; defining data requirements and designing databases to satisfy client business objectives.

Participating in design reviews and assisting with allocation of functionality to specific system components.

Designing page sizes for different database to achieve optimum resource utilization.

Developing data models, implementing databases and writing stored procedures.

Analyzing content and quality of databases, recommending data management procedures, etc.

Application Development

Interacting with clients for system study, requirements gathering and analysis.

Designing, Developing and Coding

Designing and developing of the work flow diagrams.

Participating in application development as well as Unit, Integration and System Testing.

Debugging and troubleshooting of the application.

Managing smooth implementation and testing of the application at client location.

Extending post go-live and application maintenance support to the client.

Employment Scan

From May 2015 to till sep 2018 working as a Sr. Hyperion Consultant in Banjara Systems.

Senior Consultant

Led support team of upto 11 people that included onshore offshore model.

Power point presentation of Monthly reports and status update to clients.

Scheduled outages and downtown times - for routine maintenance and patching activities.

Excellent with Change Management Process.

Did requirement gathering and prepared detailed Design document outlining Goals, Scope, Risks, Architectural & Database Structures and Database Design.

Good knowledge and understanding of ETL process involving informatica. Overlooked night processes of extraction of Metadata from sources - People Soft, Ingress and load into Hyperion.

Played key role in Performing Disaster Recovery annual testing.

Extensive work on Security.

Helped Design and Create Reports using FR Studio, Excel Add-in and Smartview.

Did extensive code review of the application

Extensively reviewed application to improve performance optimization.

Did Unit testing of the application.

Part of the UAT testing team.

Organization: SATYAM HYDERABAD INDIA Duration: Jul’06 – Mar’10

Designation: Hyperion Competency Head

Competency Head Led a team of architects and about 100 associates executing multiple projects in BI Hyperion globally. Owner of an initiative for the conceptualization, design and development of a platform independent, data base independent, meta-data driven framework for building business intelligence solutions based on enterprise applications. Responsible for asset-building activities in BI as well as execution of special architectural assignments in various clients.

working in diverse technical domains as well as vertical domains, in the delivery of services to marquee global clients, in product development and in setting up and growing a practice to a position of leadership.As a member of the BI practice at Satyam Computer Services, played a key role in building it into a formidable group, anchoring Delivery, Pre-sales, Architecture, Competency and Operations in the subsequent years.

As Head of BI Hyperion Competency, developed a keen understanding of various technologies and

Recommended appropriate hardware & software solutions to clients for achieving their business goals. The role also involved peer group mentoring on various aspects of DW & BI technology like ETL, OLAP, Analytics, etc..

Integrating delivery and competency.Recruitment and Training, Resource Co-ordination. Responsible for initiatives that drive cost optimization, profit margins and achievement of bottom line.

Architecture and Competency, BI Group

The Architecture Group focused on solution architecture, new and niche technologies in BI, competency development, data modeling, estimations, framework building, creation of reusable components, conceptualization and design of new service offerings in the area of DW and BI.

Project Name :Oracle Hyperion Beta Testing

Client : Oracle Corporation

Role : Manager

Organization : SATYAM COMPUTER SERVICES Ltd.

Project Description:

The new versions for Hyperion products such has Hyperion System 9.5BI+ (11.2), have been tested in Oracle Hyperion Beta testing. The project involves Installation and Configuration of the specified tools, Designing the Database, building cube and loading data into the Cube, Generating of reports and testing them.The testing of enhancement of System 9.5 BI+ (11.2) with New Calculations user interface that supports advanced expressions, format members based on column or row references instead of specific member selections, creating calculation based on column or row references instead of specific member selections. Tested printing of all documents that are opened in the Web Analysis Studio and tested the new and improved Formatting user interface.

As a Project Manager my responsibilities are as follows:

Create a Test Plan & Test Cases

Prepare a Project Plan

Interacting with the Vendor

Execute the Test Plan involved in Integration and System Testing

Involved in Creation of reports based on the Workshops provided

Involved in Execution of Workshops provided and tested the expected

oKey projects handled: CBA, GE Oil & Gas Italy,etc using DW/BI- Tools, Hyperion, BO, Cognos etc.

oPreparing RFP’s For various SATYAM Clients like CBA (Australia), Logitec(US),GE Oil & Gas Italy, CISCO etc and helping SATYAM Vertical Business Units, Regional Business Units, SSU and Various SATYAM Clients

oManaging Various SATYAM Clients for DW/BI in Hyperion, Cognos, ETL-Informatica

oSteered the implementation of DW/BI Solutions for the streamlining of operations.

oAssisted in the preparation of High Level Design/Detail Design for OLAP Solutions and in DW/BI Project bidding.

oHandling a Team of around 50 people around the globe.

oManaging a team of >50 throughout the globe

Organization: XANSA LONDON -UK Duration: Oct’05 – Jul’06

Designation: Consultant

oEntrusted with the responsibility of spearheading projects for niche’ clients such as British Telecom in London using DW/BI-Tools (Hyperion) for Implementation of their BI Solutions.

oUndertaken DW/BI Solutions of BT for the Release Management Dept.

oAdopted the best practice for DW/BI For Release Management TEAM @BT London.

oMigrated their entire Application from 6.x to 9.x

Organization: (Software Data India Ltd) OKLAHAMA –USA Duration: Jan’05 – Oct’05

Designation: Consultant

oAdministered Migrated Transition Projects for IBM-U.S Clients such as Williams in Oklohama –U.S.A using DW/BI-Tools - Hyperion, Cognos, ETL-Informatica to IBM-India@Kolkatta.

oSuccessfully migrated the Transition Project from IBM –Client Williams to IBM-India and given the best technical solution for optimizing the OLAP Models.

oOptimized their entire cubes around 18 cubes

Organization: ETISALAT (DUBAI TELECOM)-ABU DHABI - U.A.E Duration: Nov’97 – Aug’04

Designation: Sr. Analyst

oSpearheaded the development and implementation of Telecommunications Software's using BI Tools - Hyperion Essbase(OLAP) as the backend and VB/VBA, Hyperion Analyzer, Decision(Comshare), ASP(Using Java Script & VB Script), Crystals Reports, Congnos(Impromptu) as the front end . for loading Data From RDBMS (Oracle,Ingres) data,Oracle.

oKey projects handled:

Payroll Admin & Payroll Finance

Fixed Assets

Manpower Analysis

Overtime Analysis

Accounts Receivables

Volume of Activity

Service Orders (Issued, Closed,Cancel)

SAPS(Subscriber Applications Processing) & SAPS -LC(Leased Circuts)

STOCKS(Marketing, Engineering & Customer)

National Phones & International Phones (Incoming, Outgoing, Transit)

GSM Range & GSM Statistics

Customer Profile Analysis

Service 9000(International Business Relations-IBR 9000)

Al-Wasel & Al Mersal Application

Cashpay, Cashout, Cashtransactions( Interbranch Transactions)

Customer Line Status Informations

Mobile Equipment Statistics

Equipment Forecast

Capital Work Projects

Billing & Collection, Revenue Analysis

Organization: AL-BABTAIN Industries Inc. Riyadh –Saudi Arabia Duration: Jul’94-July’ 97

Designation: Programmer/Analyst

oGoverned Software development of Calibration of Instrument System, Machine Management System, File Management System, Steel Structure System, Security Alarm System, Travel Management System using Oracle, Access, VB & C.

oSaved millions of Riyals in Implementing the above Applications and successfully running the above applications without having any problems

oRecipient of Appreciation from the respective Departments Mgrs.

Organization: Digitek Business Systems. –ALKHOBAR –Saudi Arabia Duration: Jan’93-Jun’ 94

Designation: Programmer/Analyst

oAnalysis of the specifications provided by the clients.

oDesign and Development

oResponsible for overseeing the Quality procedures related to the project.

oClient site for implementation.

Contact this candidate