I

Mohammed Imran

M o b i l e : + * * - 838***-****

E m a i l : m a l a k . i m r a n @ o u t l o o k . c o m L a s t R o l e : A V P

P R O F E S S I O N A L E X P E R I E N C E

ASSISTANT VICE PRESIDENT: BI REPORTING FOR TRADE AND TREASURY SERVICES : CITI BANK Area of Expertise:

SAP BO Lead experience in Financial BI Reporting end to end implementation solution with enterprise products like SAP Business Objects XIR2, 3.1, BI 4.1 & 4.2. Forecasting and usage Analysis for reports with performance improvement plan in collaboration with third part UI. Rich experience in atomization, various BI requirements. Career Summary:

Seasoned financial analyst with experience in financial reporting and BI Infrastructure development and support. Responsible for corporate expansion of past and current employer. Key Strengths:

Ability to communicate and present complex concepts in plain English. Lead complex, cross functional initiatives and deliver results.

CITI BANK (TTS) TREASURY AND TRADE SOLUTIONS - ASSISTANT VICE PRESIDENT 09/2015 – 08/2018 TREASURY AND TRADE SERVICES

Citi's Treasury and Trade Solutions meets the complex needs of the world's leading organizations with a breadth of services, solutions and global expertise that is unmatched in the industry. Citi provide innovative solutions to address the requirements of corporates from all sectors with more than a century of experience, Citi has the expertise to handle any financial transactions around the world. Citi Treasury and Trade Solutions offers the industry's most comprehensive suite of treasury and trade solutions. With a full range of digital and mobile enabled platforms, tools and analytics, Citi Treasury and Trade Solutions continues to lead the way in delivering innovative and tailored solutions to its clients. BI Reporting Lead, Business Applications (CitiDirect BE and Classic, TTS- Trade & Treasury Services)

Worked with TTS (Trade and treasure services) for cooperate banking solution for various fortune 500 clients II

Coordinating with various Vendors and teams to deliver SAP Business Objects, Crystal reports, BOXI 3.1 & BOXI 4.x Administration, Report Developments and enhancement projects as BO BI Architect.

Guidance to the team for designing Financial / Banking Enterprise reporting architecture in a global scale.

Expert advice in Crystal Reports, customization, advanced knowledge in reports design with HTTP and HTTPS web services data source and solving problem in various technical issues.

Business requirement review (BRD, FRD) and help the team to successfully convert them into technical design and implementation.

Working closely with Data Modular team Oracle, SQL, Stored Procedures, for Report / SQL performance turning requirements.

Mentoring report development Monthly/Quarterly patches for new requirement and fixing existing bugs entire year activity with various releases. These patches are not only for reports but also for the CD BE portal (UI) and framework

Collaboration with BA team for functional and business requirement and timelines for delivery.

Coordinate/reconcile with vendor team for portal changes/Patches and few of report change assignment and follow-ups.

Conduct presentation to Vice Presidents and Senior Vice president and with other executives for Kibana POC and new tool (CitiDirect EagleView) features and solution.

Communication with Management as to project status and completion deadlines.

Extract, evaluate, analyze and interpret appropriate financial and statistical data as per requirement and track them in HPQC and ALM to keep the tickets updated with target fixed date.

Guide the team to Develop and document technical steps to conduct special deployments in case there are issue while normal deployment process. Prepare Deployment guide and demo to the stake holders team for following deployment steps.

Help and guide and mentor Vendor and direct deportees to deliver quality code within given timelines.

Conduct financial and business related analyses and research including the preparation of any new requirement which has to be delivered with given environment and time frame.

Provide reasoning for month to month and YTD variances and make recommendations relative to the production reports failure and send the queries to data modeling team for performance tuning to improve performance.

Advise management of expected outcomes, and recommend ways to improve the outcomes for any new approach.

Independently pursue fundamental problem solving and documents the recommendations to management. Compile and prepares reports, graphs and charts of data for production incidents and fixes Ad Hoc reporting and analysis.

Working closely with Java framework team for report framework components and BO SDK implementation (for custom interfaces, scheduling and related activities) and to solve issues by providing Operational support

(Including severity 1 issue in production).

Mentoring Grad through Grad program and presently proposed a solution for daily failure, successful ratio Analysis for various reports like (Account statement, Leger Balance, Reject reason, interest statement etc.)

There are more than 650 financial banking reports that are deliver to clients as per requirement. The total number of statement generated every days are cross to 1 million.

Handling of high volume reports daily basis for various clients across the globe, in terms of failures and issues. III

Interaction with various stake holders across geographical areas to implement the reports as per business requirements.

Currently working on migration project of reports from Asia countries to our Citi direct portal. We are migrating 17 reports from Asian countries to our portal from 13 countries like China, Japan, Vietnam, Philippine, Thailand Malaysia, Indonesia.

Project management for BO 3.1 SP7 migration and BO BI 4.1 implementation and migration Project for our in- house clients.

Maintain and enhance BO report deployment tool (In-house developed) with Java developer to Auto deploy the report in BO environment.

Complete POC for Kibana and elastic search for BO server log analysis and Dashboards for daily issues

Successfully completed POC for connection Crystal 2008 connection to HTTPS web service with java 1.5 with the help of external jar files.

Currently working on Crystal report requirement for Asian countries for one of the migration project from Java portal to CD portal.

Additional accomplishments include:

Worked closely with senior management to create an application with IIT Grad. Leading the team guidance to the grad for new app, which was one point troubleshooting app for quick response time in production environment. Morgan Stanley Advantage Services Manager – BI Engineering Sep 2010 – Sep 2015 Client: GWM Technology

Handled BO BI 4.0 implementation and migration Project for our in-house clients.

Prepared BI 4.0 project plan and procured new 64 bit Hardware for BI servers and Web tier (Web Sphere).

Installation and configuration of SAP BusinessObjects BI 4.0 DEV servers with cluster.

Preparation of Morgan Stanley BO Architecture diagram with multitier architecture.

Prepared various technical documentations like Cook Book, Run Book, BCP plan Guide, BO Backup Guide.

Used various tools like MS one note, SnagIt, MS Project Plan and MS Excel to create documents.

Successfully Migrated Twenty thousand plus users from BO XI R2 to BO XI 3.1 on all the environments

(DEV,QA,UAT,PE,JVC,BCP and PROD)

Prepared Project plan and strategy to migrate BO XI R2 to 3.1 and dress rehearsals.

Tracking errors/issues and propose solution to the issues reported by APP DEV Teams during implementations of BO 3.1 and BI 4.0.

Created Backup and recovery plan for BOE 3.1 and BI 4.0 also created strategy for housekeeping activities.

Partnered with Operations team to run backups in BIAR files and use of RoboCopy for File Store backups.

POC for new Department replacing Actuate Reporting tool with BusinessObjects Enterprise 3.1.

Created Universe and Reports for few Application Development teams.

Guidance to Implement BusinessObjects Enterprise XI 3.1 Clustered machines to operations team.

Provided Training on administration and design to Application user team on BusinessObjects XI 3.1.

Prepared Migration Information Delivery Diagram for side by side upgrade and fresh upgrade. IV

Guidance to Configure LDAP with Siteminder with SSO on BI 4.0 and BOE 3.1

Guidance to implement BO on WebSphere 7 for 3.1 and 4.0 with the EAR file creation and step to follow.

L3 engineer for Operation team (TCS), handled production down issues and various critical issues.

Noad EQM and TWS implementation and configuration with BO 3.1

Used BOE 3.1 Java SDK to extract various imp housekeeping ant information from BOE.

Slice and dice with BO Audit reports get daily activity reports.

Used various macros with BusinessObjects Enterprise 3.1 and BI 4.0

Used Query builder to get day today activities of BO plant.

Guidance to implement BO data restriction method’s like (Row Level Security, @BOuser and Profile & Pub) HEWLETT-PACKARD MUMBAI TECHNOLOGY CONSULTANT – BI PRACTICES AUG 2009 – SEP 2010 CLIENT-1: HDFC BANK.

Implemented BusinessObjects Enterprise XI 3.1 on Windows Clustered machines.

Administration Console and security.

Preparing Information Delivery Diagram and Architecture document for Implementation.

Configured SSO with .Net Infoview and JAVA Infoview.

Created Database Repository on MS SQL server 2005 Database.

BusinessObjects clustering and horizontal scaling on four machines.

BusinessObjects XI 3.1 backup procedure and strategy document.

Setting up the entire security of BO 3.1

AD configuration on IIS and Tomcat application server.

Understanding of requirement and developed universe.

Involved in designing of web intelligence reports.

Developed Voyager workspace against Essbase cubes 9.3.1 IDECISIONS CONSULTING PRIVATE LTD MUMBAI SENIOR DEVELOPER – BI PRACTICES JAN 2009 – JUNE 2009 CLIENT-1: SAUDI TELECOM, SAUDI ARABIA SAP BUSINESSOBJECTS 3.1 IMPLEMENTATION

Implemented BusinessObjects Enterprise XI 3.1 on HP UNIX machine.

Configured SMTP to schedule reports for email destination.

Provided training on Business Objects Enterprise, Infoview, Universe Designer, Desktop Intelligence, Web Intelligence Administration Console and security.

Installed Crystal Reports 2008 client and BusinessObjects client on user machines.

Created Database Repository on Oracle Database.

Administration of BusinessObjects XI 3.1 on UNIX.

BusinessObjects XI 3.1 backup procedure and clustering.

Involved in the analysis of the report development and universe development. V

Client-2: Saudi Hollandi Bank, Saudi Arabia.

PERFORMANCE TUNING FOR EXISTING BUSINESSOBJECTS XI R2 ON IBM AIX

Detailed System Study conducted for performance improvement.

Web Intelligence reports were running very slow under customize application specifically used by the bank to preview the reports.

Changes in java codes were required for some reports.

Tested Network performance with BO XI R2

Tested Web Intelligence reports and universes through integrity check.

DWH testing with various fields.

Suggested system requirement and customization of InfoView instead of customize application. KPIT CUMMINS INFOSYSTEMS LTD PUNE SENIOR ENGINEER ARCHITECTURE JUNE 2006 – JAN 2009 CLIENT: BUSINESS OBJECTS AN SAP COMPANY

Provide high-end technical troubleshooting to Business Objects Partners in resolving issues related to the implementation, deployment, functionality, and usage of enterprise Business Intelligence Software suite versions XI and XI R2

Configuring Java/ IIS AD authentication (BO XIR1, BOXIR2).

Business Intelligence tools worked on: Crystal Enterprise 9, 10, Crystal reports XI, Crystal report server XI R1, Crystal report server XI R2, Business objects Crystal Decision, Business Objects XI R1 and Business objects XI R2

Business Objects Enterprise, Infoview, Universe Designer, Desktop Intelligence, Web Intelligence Administration Console and Mentor new Engineers for Business Objects Products BO XI R1, XIR2 & 3.1

Responsibilities range from assisting customers in resolving simple to intermediate issues by troubleshooting critical problems on mission critical deployments.

Deployed DST patch, Live Office for multiple client’s workstations.

Configuring Tomcat SSL on BOXIR2 Environment.

Setting up SMTP to schedule reports to email destination.

Assisting through complex client-server multi-tier deployments, deploying web based applications on a variety of operating systems platforms, databases (SQL Server, Oracle 9i), and application and web servers(IIS, Tomcat- Apache).

Migration from BO 5x, 6x to BOXIR2/ CE10 to XI R2/ CE9 to XI R2 and XI R1 to R2 and XI R 3.1.

Identifying and resolving bottlenecks in application performance issues.

Assisting with server issues related to Universes, Reports, and architectural problems encountered in a variety of combinations of databases, web application servers, and Operating systems.

Identifying and reporting bugs detected in the product to Product Group for hotfix generation based on severity of the problem. Deployed clustered environment (XIR2, 3.1) for multiple clients.

Communicate with Clients through People soft CRM/E-mails and outbound calls.

Creating Database Repository on various Databases (SQL Server, Oracle, and MySQL)

Responsibility to write knowledgebase articles for future reference VI

E D U C A T I O N

M.C.A. - Master of Computer Applications.

Dr. Baba Saheb Ambedkar Marathwada University Aurangabad. B.Sc. - Bachelor of Science.

Dr. Baba Saheb Ambedkar Marathwada University Aurangabad. S K I L L S

Servers RedHat Linux

Windows Servers

Suse Linux

Tools Import Wizard

Security Viewer 2.2

Report Conversion Tool

Central Configuration Manager

MySQL Administrator.

Hardware & Installation Sound Knowledge of Computer Hardware, Assembling and Troubleshooting.

Expert in Installation & Configuring of Various

Operating Systems like: Active Directory

MICROSOFT LINUX

Windows 2010 RedHat Linux

Windows 8 Suse Linux

AD Configuration, LDAP Configuration Installation of BusinessObjects Products like BO XI R2, Crystal report server XI R2,

BO XI 3.1 and SAP BI 4.1 with Clustering

Application servers IIS, Tomcat, Weblogic 8.1, WebSphere 7 CRM PeopleSoft CRM, SAP BCP

Security Setup With BO SunOne Directory server and Active Directory Configuration and setup with BO Enterprise Software’s Database Repository setup MS-Access, MySQL server, MS SQL server, Oracle 11G Networking Proficient In LAN and WAN setup and Troubleshooting VII

R E W A R D S & R E C O G N I T I O N S

Silent Warrior, You Have Done It and Wow Award received from KPIT Cummins Limited

Appreciation for outstanding efforts received from HEWLETT-PACKARD GlobalSoft Pvt Ltd

Citi – Treasury and trade solutions Global Recognition Award 2018 P E R S O N A L I N F O R M A T I O N

Name Mohammed Imran

Personal Email adl32g@r.postjobfree.com

Cell +91-838*******

Present Address Sobha Orion, Flat No A-3011, 1th Floor, Off NIBM Kondhwa Link Road, Opposite Sai Service,

Next to Nirman Assamant, Parge Nagar,

Kondhwa Buduruk Pune – 411048

Date of birth On Request

Nationality Indian

Pan Number On Request

Passport Number On Request

Marital Status Married

Languages Known English, Hindi, Marathi and Urdu

Hobbies Share Market analysis, Computer Games

Assets Sincere Optimistic, Enthusiastic and hardworking Methodologies Commitment to quality, Value & excellence, Frequent Value Addition.

Contact this candidate