Summary




A dynamic professional with 14 plus years of rich experience in the areas of Information Technology comprising of Business Intelligence Reporting, EDP operations and Software Development working with Reliance Infosolutions Pvt Limited. as BI Reporting Team Lead
Industry Exposure with Retail, Telecommunication, FMCG and Manufacturing.
A proactive initiator believes in innovation with problem solving ability.
Demonstrated abilities in devising customized solutions to smoothen the business processes.
An effective communicator with excellent relationship building and interpersonal skills, strong analytical, problem solving and organizational abilities.


Over 5.9 years of experience in Business Intelligence Reporting.
Over 1.2 years of experience in Client Server development
Over 7 years of experience in EDP Operations, Database Management and Customized solution for data capturing and Reporting


Business Intelligence : Business Objects XI R3 Suit, WEBI, DESKI, Universe Designer, CMC, Business Objects 6.5, BO Auditor, BCA, Crystal Reports or 2008, Business Views, Cognos-8
Dashboards : Xcelsius 2008, Performance Manager and Dashboard Manger.
Databases : MS-SQL Server 7, ORACLE, SQL, PL/SQL, MS-Access, MS-FoxPro,
GUI : MS-Visual Basic,
Reporting Tools : Crystal Reports, Visual Basic Data Reports, MS-FoxPro, MS-Access
WEB :. Net, HTML, DHTML, XML, VB Script, CSS and IIS
Programming : VBA coding, PL-SQL




Employment

June, 2009 -  Present
As BI Reporting Project Lead

Project Execution and follow the SOPs
Technical assistance to the development team
Developing and Implementing Dashboard requirements.

August, 2006 -  June, 2009
As BI Reporting Team Lead

Analyze Business Requirements and decide appropriate Business Object Component or mix.
Reports requirements gathering and designed technical and functional specifications.
Interacting with BO Support Team for Technical Deadlocks.

Imparted Training of Business Objects Suit to new Team Members.
Writing Macros in Reports using VBA
Customized Auditor Universe and created custom reports to track user activity
Extensive analysis to design the Universes to assure the reusability of the universe with linked universe concept.
Created few Business Views for Crystal Reports 2008
Implemented WEBI reports based on multiple universes based on SAP-BW queries and Oracle database as a source.
Involved in full life cycle of Business Objects reporting Application.
Extensive use of VBA coding in Excel macro and created Excel based User Interface for Data Entry on Infoview Based on entered data and datamart WEBI reports were created.
Created Complex Views to Overcome Loops and contexts.
Documented Meta data definitions.
Developed physical and logical Modeling.
Designed and developed reports with drill down options.
Trouble shooting and tuning of the reports.
Created various Dashboards in Xcelsius for Reliance group of companies. Ensured minimum hits on the database by mix of scheduled reports and on demand reports with Query as a Web Service QAAWS and Live Office as source. Use of extensive Xcelsius support Excel functions to filtered data to be mapped to Xcelsius components.
Data authorization is implemented at Universe level to various user groups depending on their regional and functional roles.

Reports are pushed to Inbox or Email with Publication based on the profiles assigned to the BO enterprise users. And for Dynamic users outside BO users it is pushed to their Email.
Formulated Report designing standards.
Implemented Business Objects Mobile reports for Blackberry.
Event Based Report Scheduling based on the dependent ETL job completion.
Developed WEB utility for internal users using ASP.net and IIS.
Managed and Worked on COGNOS-8 Business Intelligence POC.

July, 2003 -  August, 2006
As Senior Business Object Developer

Understanding Database architecture and studying application database.
Designed various Universes and Reports.
Functional analysis and requirement gathering.
Involved in full life cycle of Business Objects reporting Application.
Designed and developed reports with drill down options.
Created DESKI reports with VBA as source.
Created DESKI reports on stored procedures as source.

June, 2002 -  July, 2003
As Developer

Client : Training Ship Rahaman TSR since 1910
Project : Cadets DATA Center Database Design/Developer
Environment : Windows NT 4.0, Visual Basic, Sql Server 7, Visual Basic Data Reports.

Training Ship Rahaman is into training of Cadet and Merchant Navy Crew in various courses. System is developed to capture the Cadets information and their Course information and generate the Fees Receipts and Various Course Certificates as per the courses.
Interacting with User for system understanding and drafting requirement specifications
Involved in designing of database design.
Developed GUI using Visual Basic and Reports in Visual Basic Data Reports.

Training conducted for the users regarding the new application.

involved to co-ordinate activities
Client : Galvano Casting Private Limited
Project : Reporting Solution Database Design/Developer
Environment : Windows NT 4.0, Visual Basic, Sql Server 7 and Crystal Reports.

Client is into casting and forging. They were having an existing system with VB as front end and MS-SQL server as backend. Problem was that they were not having the source code but only installable compact disk. They were not ready to part with the system. Challenge was to understand the entire database and the relationships between the tables. And develop reporting solution for the client.
Involved in understanding the existing database design and its relationships. Created couple of tables for the reporting solutions.
Developed GUI using Visual Basic.
Developed Reports using Crystal Reports.
Involved in documentation and ER diagram of the database.

June, 1995 -  May, 2002
As EDP Officer

Designed the database to store the data from heterogeneous subsystem sources.
Migrated old data from FoxPro or Access into Sql Server with Data Transformation Services.
Interacted with Sales Personnel for manual system understanding and drafting requirement specifications for various applications for Sales and Sales Administration Team of western region.
Automated report generation tool in FoxPro win and MS-Access.

Education

Training

Three-day training course on MS-SQL Server 2005 at Microsoft , Mumbai 2008
Eighteen-day training course on Business Objects by Business Objects XI R2 at Reliance , Mumbai 2007
Ten-day training course on COGNOS at Reliance from COGNOS , Mumbai 2007 .
Five-day training course on Project Management Professional at Reliance , Mumbai 2006 .
Ten-day training course on SAP BW Data warehouse and Reporting at Reliance from SAP , Mumbai 2006 .
Three-day training course on Business Objects at Business Objects , Mumbai 2003
Education and Personal Details .
Passport Details
Passport Number : H4566779
Date of Issue : 14th May , 2009
Date of Expiry : 13th May , 2019
Place of Issue : Thane
Nationality : INDIAN


Miscellaneous

Was engaged in Supervising, guiding and training a team of EDP operators.
Coordinated with Users towards installation and trouble shooting of various Applications
Designed and Developed Reporting Tool in Crystal Reports and Visual Basic as front end and MS-SQL Server as backend.
Application developed for Stock Adjustment Note Instrument for timely reimbursements of Fresh Stock across Western Region in MS - Access
Responsible for smooth functioning of all Software Application catering Sales and Stock Data of entire Western Region.