Software Engineer Data

Mohsin Khan

[pic]

SAP BI - BO-Hana Consultant

Email : **************@*****.***

Mobile: +966-*********

Professional Summary

V Over 3 years of IT experience in developing Business Intelligence and

business objects applications and Hana 1.4 implementation.

V End-to-end implementation of Hana database with all migration and

deployment with Rapid analytics.

V Was involves in Hana database Data provising RDS and landscape

transformations.

Having knowledge on Architecture, Landscape of SAP HANA.

V Having knowledge on Data Provisioning for how to bring table

structures from source systems like SAP and Non-SAP ERP, SAP BI, MSSQL

V Having knowledge on Data Replication methods ETL(Data Services),

Trigger Based and Log-Based Replication

V Having knowledge on how to create Column based views like Attribute

views, Analytic Views

V Having knowledge on how to create Advanced Views like Graphical

Calculated Views and Script Based Calculated Views

V Work on Information Composer, Loading data into HANA Data Base through

IC cleansing and Modeling in IC

V Having knowledge on how to create repots on Information models

V Having knowledge on creation of WEBI, Crystal, Explorer, Dash Boards

and Excel Reports on HANA Information Models

V Technical hands on Hana Business Intelligence (HANA analytics &MS office

2010).

V BIBW upgradation to BW 7.3 & installation HANA BI content.

V Very good hand on HANA optimization, and HANA Database Business Modelling

(Information Composer).

V HANA replication with BODS, SAPLT, SYBASE.

V HANA DATA provising with RDS, DS, LT and SYBASE.

V Hana client tools installation and configuration

V Technical hands-on expertise using OLAP tool Business Objects

5.x/6.x/XIR2/XIR3/4.0(Reports, Designer, Web Intelligence, Info view,

and Info objects).

V Expertise in working and implementation of Crystal Reports

7.0/8.0/9.0/10/XI/XIR2.

V Well Experience in creating Dashboards and Analytics using Xcelsius 2008

and Dashboard builder.

V Exposure to Data Integrator/Services, Rapidmarts in SAP-BO.

V Experience in tuning the performance of SQL queries and ETL process.

V Experienced in tuning and designing database Tables, views, stored

procedures, cursors, triggers using Oracle and SQL Server 2005/2008.

V Expertise in creating Xcelsius Dashboards using UI Controls

V Experienced in interacting with business users to analyze the business

process and requirements and transforming requirements into screens,

designing database, documenting and rolling out the deliverable.

V Involved in Performance tuning of Universes and Webi report development

and Databases.

V Strong Knowledge in all phases of Software Development Life Cycle (SDLC)

such as developing, testing, Migrating, security management and

production supporting on various platforms like Windows NT/2003/XP, UNIX.

V Expertise in Universe designing, developing and generating complex,

Adhoc, dashboard Reports, Business views, List of values along with User

Acceptance Test and data accuracy Test.

V Proven abilities in creating complex reports by linking data from

multiple data providers, using free hand SQL, stored procedures and

functionalities like Combined Queries.

V Managed CMC, Repository, Web Intelligence, Desktop, Destination, Program

Job and Event Servers and Designed security model for users to access the

report

V Hands on Experience in Scheduling, Working with LOV Objects and Deploying

a System and Hands on Experience in Migrating BO 5.x & 6.x to BO XIR2

Using Import Wizard Workshop

V Hands on Experience in Creating Batch Job, Data Flow and Validating,

Tracing and Debugging Batch Jobs using Data Integrator XI.

V Designed Performance Management metric universe, Metric, Analytics,

Personal Dashboard and Corporate Dashboard using Dashboard Manager and

Created Goals, Goal Analytics, Published Goals to Corporate Dashboard

using Performance Manager and Created Charts with a date range, Value-

based alerts and setting up Drill down in charts using Crystal Xcelsius

V Worked with Crystal Report XIR2 for creating complicated reports

including sub-reports, parameter based reports, graphical reports,

formula based, well-formatted reports, drilling reports, analysis

reports, data reports along with LOV.

V Well experienced in writing Complex queries, stored procedures,

functions, cursors and packages using PL/SQL Programming.

V Excellent knowledge in Implementation of Relational Database (OLTP) and

Data warehousing systems (OLAP) and Data Marts.

V Good Knowledge about dimensional model (Star Schema and Snowflake Schema)

V Exposure to Rapid marts and Data federator in creating OLAP Universes.

Technical Skills

OLAP Tools Business objects 6.5.2 / 5i, BO XIR2, XIR3.1, Crystal

reports XI, Crystal 2008, Xcelsius 2008,SAP BEX,SAP BI/BO

4.0, Hana Studio, Webi 4.0, Live office 4.0, Dashboard and

workspaces,.

Operating Systems Ms-Windows, Unix, Linux

ETL Tools BODI/DS

Data Bases Oracle, Ms SQL, DB2, MS- Access 2000

Languages C++, JAVA, VB, SQL/PLSQL,UML, UNIX Shell Scripts

Education

* Bachelor of Engineering Degree in IT from OU,AP

Client: SHPS, USA JAN12 -

Till Date

Role: Software Engineer

Description: SHPS is the source for greater cost control and efficiency in

the health care solutions, administrative, clinical, and financial aspects

of benefits and health care delivery. It is a leading, independent provider

of integrated health solutions that improve personal health and reduce

spending. By integrating traditional health management and benefits

administration services, SHPS delivers people-centric solutions that

empower individuals to make wise healthcare choices. SHPS is top most

health care solutions company. The company headquarters are in Louisville,

Kentucky, USA.

Environment: SAP BI, Business Objects XIR3,BOBI 4.0, Web Intelligence

XIR3,Xcelsius 2008, Crystal Reports 2008, Data services, Oracle 9i

(PL/SQL),SAP BI 7.0,TOMCAT 4.1, Windows Server 2003, UNIX, Hana Studio.

Responsibilities:

. Hana Server / client installation & configuration and done Provising

with RDS, LT and Sybase.

. Implement Hana ETL using BODS and SYBASE and done replication with

Rapidmarts.

. Participated in project planning sessions with project managers,

business analysts and team members to analyze business requirements and

outline the proposed solution.

. Build the new universes as per the user requirements by identifying the

required tables from Data mart and by defining the universe connections.

. Used Derived tables to create the universe for best performance, and use

context and alias tables to solve the loops in Universe.

. Created complex reports stating revenue generation per year using

cascading and user objects like measure objects by using

@aggregate_aware function to create the summarized reports.

. Performed changed data capture and incremental load using Data Services

in Oracle database.

. Created Universes from SAP BW Source and applied Custom hierarchies.

. Used Source as Infocubes and Bex queries created Crystal reports and

webintelligence reports.

. Created users, groups and maintained user access rights by using CMC.

. Created Webi reports using SAP Infocubes and operational data sources

. Created SALES UI control Dashboards using Xcelsius.

. Created reports containing all the information regarding the publishers,

distributors and retailers using crystal reports XIR3.

. Generated Reports using the Universe as the main Data provider and also

using the personal data files provided by the users.

. Developed critical reports like drill down, Slice and Dice,

master/detail for analysis of parts benefits and headcount.

. Created complex reports using the multiple data providers and

synchronized the data providers by linking the common objects to create

the common report for the analysis of revenue generation from different

regions.

. Created different reports containing charts showing revenue and

operating income by different divisions, market share of newspaper by

circulation.

. Created complicated reports including sub-reports, graphical reports,

formula base and well-formatted reports according user requirements.

. Involved in creation of performance management metric Universe, Metrics,

Analytics and personal and corporate dashboards.

Client: Mincom, AU

aug11- DEC '11

Role: Sr software Engineer

Description: Mincom is a global software and services provider that

delivers solutions critical to businesses in asset intensive industries

such as mining, defence, oil and gas, energy, and public infrastructure.

Leveraging 30 years of deep experience in these industries, Mincom thrives

on helping our customers successfully optimize the performance of their

assets, their people, and their businesses as a whole. Mincom solutions run

some of the world's largest private and public enterprises

Environment: Business Object 6.5.1/ XI R2, Broadcast Agent, Web

Intelligence (CMC, CCM, Designer, DeskI, InfoView), Crystal Reports 10.0,

MS-Excel, Windows NT/2000 Professional, Oracle 9i, DB2 UDB, VB 6.0

Responsibilities:

. Involved in Creating Users and User Groups and assigned different

privileges to them depending on their profile.

. Installed and configured Broadcast agent server, Web Intelligence 6.x

server for use with Zero Administration Business Objects (ZABO) clients

and created interfaces using Web Intelligence 6.x.

. Analyzed the required data elements, Source Applications reporting

package group in different departments like operations, Management.

. Created Different Universes for separate reporting requirements which

run against Oracle 9i Database.

. Created classes and objects and gave business names and logically

grouped them together.

. Resolved issues like Loops, Fan Traps & Chasm Traps by creating Aliases,

Derived Tables and Contexts as required in removing the cyclic

dependencies.

. Used different business objects @functions like @select, @where,

@prompt.

. Created Full Client reports using different Data providers like Oracle,

Excel sheets, SQL server.

. Extensively used slice and dice for generating master/detail and tabular

reports.

. Created Reports from Excel files using Business Objects through Personal

data files.

. Utilized various crystal reports features including conditional

formatting, use of multiple groups and group sorting, parameter passing

using dynamic and cascading prompts and complex formula usage.

. Created the connectivity to business Objects from Oracle Production Data

base.

. Published the Reports generated by the user in InfoView for reusability

by different users.

. Created metrics and included them in the dashboards in Webi by using

predefined analytic templates.

. Created Detail Design Documents & Trained users at different levels of

Report Creation.

. Exported reports into various formats like PDF, HTML, EXCEL, and WORD

for user.

Client: Resource Interactive, Columbus, OH

jan11 - aug11

Role: Software engineer

Description: Resource Interactive is one of the nation's preeminent digital

marketing agencies; helping Fortune 500 companies thrive in the evolving

internet economy with award-winning digital strategy, creative and

technology solutions. Known for its revolutionizing consumer insights,

leading edge interactive design and technological innovation, Resource

Interactive is ranked among the top ten independent interactive agencies in

the nation

Environment: Business Objects 5.1.4/6.5 and with Web Intelligence 2.6,

Oracle8i, SQL, PL/SQL, MS Access.

Responsibilities:

. Gathered, analyzed and documented business requirements, functional

requirements and data specifications for Business Objects Universes and

Reports

. Utilized Designer functions like @Select, @Prompt and @Aggregate Aware

with summary tables for query optimization.

. Defined hierarchies to facilitate multidimensional analysis and set up

custom hierarchies to prevent dimension rift

. Resolved Loops using Contexts and/or Aliases in the Universe and checked

the integrity of the Universe. Created custom LOV's

. Created/checked Joins and detected cardinalities.

. Created/Classified of classes and different objects as per the user

requirements

. Exported Universes to the Repository to facilitate access to the

universes

. Linked different universes using Kernel/Master approaches

. Assisted in documenting Meta data definitions for the universes and

reports

. Involved in migrating reports and universes from 5.x to 6.5

. Used Slice and Dice to format Master/Detail, Cross Tab reports and

charts

. Complex reports involving the use of complex queries(Sub queries,

Unions, Intersects)

. Extensive use of calculations using Variables, Formulae and in-built

functions to calculate costs, revenues generated and profitability of

customers

. Apply Breaks, Sorts, Alerts and Ranking to ease readability in Business

Objects reports

. Exported reports to the corporate documents, and scheduled/monitored the

reports via Broadcast Agent server

. Provided production support by solving problem tickets issues and

updated the problem tracking database

Client: Kraft Foods, Illinois, US

JULY '10 - dec10

Role: Software Engineer

Description: The client is a leading player in the food products industry,

with a dominating presence. Involved in designing Supply Chain Management

System at Kraft Foods in Chicago in existing Data warehouse, for all types

of users using Business objects as front end including Supply Chain and

Transportation Analysts. The business-intelligence solution we designed for

the client enabled them to do enhanced analysis of, Revenue by brand,

geography, business unit, date/time and top customers

Environment: Business Objects 6.1, Web Intelligence, Oracle 8i, Windows

2000.

Responsibilities:

. Collecting user requirements and specifications for project development.

. Moving the report objects (Deski, WEBI, Crystal) from Dev to Stage to

Prod Environments.

. Data extraction and Loading in to reporting databases.

. Development of Universes and reports using User Module and Web

Intelligence based on user requirements.

. Report development involves exploring features of Business Objects

features, to make the project user friendly as much as possible.

. Used Oracle sub queries, unions in reports.

. Supervisor activities and supporting documentation for ongoing user's

maintenance.

. Maintenance of Repository Domains, Users and User groups, user

privileges, Categories.

. Installation of Business Objects on different servers for User Testing

purpose.

. Worked with Oracle DBA to optimize the Query performance of the Business

Objects reports.

. Analytical and Detail level of Documentation work to educate the users

about the requirement of Web Intelligence depending on user

requirements.

. Development is designed to take away ongoing maintenance of table or

views creation as fiscal year changes and to support User-friendly ad-

hoc querying.

Client: Edison Properties, LLC

july09- JUN '10

Role: Trainee Software Engineer

Description: Edison Properties, LLC, is a diversified family-owned real

estate company that owns and operates 40 Edison Parkfast facilities in New

York, New Jersey and Baltimore, MD, 16 Manhattan Mini Storage stores in New

York and the Hippodrome building at 1120 Avenue of the Americas, a 650,000

sq. ft. Edison also owns and operates Workspace, which are various office

options including informal offices, executive offices and pre-built suites

in Manhattan.

The main objective of the project is to analyze the sales data and also

data of Sales made through Promotion campaigns of the various real estate

properties. The customers through the promotion campaigns organized at

different locations place the orders. The system allows marketing and sales

persons to maintain targets for various Properties. It also aids in

analyzing sales over multiple promotional cycles, sales channel and

increase profits.

Environment: Oracle 8i, PL/SQL, java, JSP and servlets

Responsibilities:

. Was involved in front end designing which was done in JSP.

. Created the database objects such as Tables, Views, Database Triggers,

PL /SQL procedures, Packages etc.

. Created of Database schema as per the requirement definition.

. Performance tuning, SQL tuning

. Optimized SQL queries.

. Involved in designing and coding screens for transaction, information

and administrators modules.

. Design screens for displaying all users requests for the administrator.

. Developed interface for the purchase entry screens.

. Reports are generated on daily, weekly, monthly, yearly and in between

any two given dates

. Involved in Performance Tuning and Scheduled Maintenance of the

application.

Professional Summary

Current Company Naman Technology june12- Feb. 13

Designation Sr. Software Engineer

Previous company Jubail energy services company mar. 12- June. 12

Designation SAP Consultant

Previous Company INFOTECH ENTERPRISE july.10- Feb.11

Designation Software Engineer

Personal Details

Full Name Mohammed Mohsin Abubaker Khan

Cell # +966- 569872510

E-mail **************@*****.***

Marital Status Single

Nationality Indian

Languages English &Hindi &Arabic

Date of birth 11-12-1987

Iqama status Transferable

Contact this candidate