Summary:
Develop the process of implementing Business Objects. Worked on RFP and
provided solution to the client which in turn got the project to the
organization. Analyzed the client Business Intelligence system and
recommend the solution.
. Dedicated and Team oriented professional with nearly 10 of IT
experience and 9 years of Data Warehousing technologies.
. I have worked as a Developer, Administrator role for business
objects
. Implemented Database & Data warehouse projects end to end through
Analysis, designing, development, testing, deployment and support
& maintenance.
. Have extensive experience in analysis, design, development,
testing and architecture of data warehouse and data mart systems;
including installing, configuring, administering and supporting
Business Objects Enterprise suite in high performance business
systems.
. Have been responsible for various Software Development Life Cycle
(SDLC) Phases in database and Data warehouse projects including
Planning, Analysis, Design, Build, Unit Testing, SIT, UAT and
production deployments with short term and long term support.
Achievement:
. Received Award for creating process.
. Received appreciation email from Client.
Technical Skills:
Business Intelligence Tools Business Objects
ETL Tools Informatica
Database SQL Server and Oracle
Programming HTML
OS Windows and Linux
Projects:
Company Name: ZENSAR Technologies
Client Name: Cisco
Role: Team Lead
Duration: April 2012 till Date
Environment: Unix, Business Object XI Release 3.1 and 4.1, Oracle 10g,
Teradata, Xcelsius, Live Office
Sr. Business Objects Administrator April 2012 - Present working as Sr
Administrator of Business Objects client. Creating the process for the
client to make sure best practice should be used by the developer and to
make sure changes should not happen without any approval. Enhance system
performance through load balancing, performance tuning, capacity
monitoring, Plan backup & recovery procedures, handle performance tuning
and conduct regular system checks. Ensure technical and functional designs
meet business requirements. Remotely resolved the issues for the developers
of different MNCs. Head the review calls to check the developer codes.
Testing the code of developers and suggesting to implementing the best
practice solution for development.
Company Name: Accenture
Client Name: DuPont
Role: Team Lead
Duration: July 2010 to Oct 2011
Environment: MS Windows 2000 Server, Business Object XI Release 3.1,
Sql Server 2005, SAP BW, Informatica, Xeclsius, Live Office
Responsibilities:
. Establish SLA's & adhere to the change management, incident
management and problem management policies of the organization.
. Provide technical support, guidance and documentation to end
users; provide immediate fixes remotely on critical issues.
. Developed ETL Mapping between source systems and warehouse
components.
. Interacted with report developers and experts to understand the
reporting requirements and formulated the ETL designs and mappings
accordingly.
. Allocated project work to team members and regularly check the
progress of team members on projects.
. Extensively used various stages like File, Joiner, Lookup, Change
Capture, Change apply, Modify, Transformer, Build Ops, Oracle
Enterprise, Oracle OCI, Teradata API, Teradata Enterprise,
Surrogate Key, Sort, Remove Duplicate, Aggregator etc.
Company Name: Minacs Aditya Birla
Client Name: NBK (National Bank of Kuwait)
Duration: Sep 08 to Jul 2010
Environment: MS Windows 2000 Server, Business Object XI Release 3.1,
Sql Server 2005
Responsibilities:
. Design & Implement systems that meet the information needs of
business intelligence systems; perform technical and advisory
functions in the development of business objects architecture and
the creation of frameworks for reporting, scheduling and object
retention policies for complex information systems
. Work with the business management to ensure business objects are
appropriately utilized for all required management and adhoc
reporting.
. Design and coordinate or build universes, classes and objects;
Create cardinalities, contexts, joins and aliases. Setup row level
or column level security on universe to restrict data access to
certain users or user groups.
. Ensure Business Objects Enterprise content security by creating
custom access levels BO_DEVELOPER, Delegated Administrator Support
User and Basic User roles in all dev, test, pre-prod and
production environments.
. Deploy Business Objects content from legacy Business Objects
6.5/Business Objects XIR2 systems using Import Wizard and promote
content from development to test to pre-production to production
environments using life cycle manager to XI R2 systems.
Company Name: Sierra Atlantic
Project: MI Reporter
Client Name: Brunswick Boat Group
Duration: Jul 06 to Sep 08
Environment: MS Windows 2000 Server, Business Object XI Release 2, Data
Stage 8.0, Location Intelligence for Business Object
Description:
The Marine Group has identified the need for a system that will enable
Business Intelligence
Around the distribution network, market share and sales information, across
the organization.
We believe that by consolidating our distribution network, market share and
sales data, and
Providing robust reporting and analytics capabilities, we can provide
strategic and tactical
decision support for the distribution network optimization strategy and
sales force. Market
Intelligence (MI) Reporter is designed to provide a single, timely,
accurate view of the truth
About distribution, market share and sales, throughout the enterprise, in
order to take the
next best action with each customer or consumer.
Responsibilities:
. Conducted and facilitated JAD sessions and brain storming sessions
with key business user groups within legal department in
emphasizing the scope of the Matter Management Reporting Project
in order to provide key initiatives in working with users in
identifying and defining the project and system requirements.
. Involved in the Data warehouse implementation to meet
business/reporting needs and performed gap analysis between legacy
systems, data mapping, and data validation and was involved in
complete analysis of the data from the reporting perspective.
. Documentation of procedures, architecture and define standards for
maintenance of the Business Objects portal.
. Creating Universe, new connections, access restrictions, check
integrity, check cardinalities, resolve loop by adding aliases &
contexts, speedup query time by applying aggregate awareness
within designer.
. Responsible to migrate the Business Objects Universes/Reports
across the servers/repositories.
Company Name: KPIT Cummins
Project: Americas Information Warehouse (AIW)
Client: HP
Duration: Jun 05 to Jul 06
Environment: MS Windows 2000 Server, Business Object 6.5, DTS, Sql
Server
Description: The purpose of this project is to provide consolidated
Financial, Revenue Generation, Sales for America and Asia pacific reports
for Pre-Merger Compaq PMC) and Pre-Merger HP (PMH) Americas Sales
Operations data. It will include combining the data from PMC LAIW (Latin
America Information Warehouse) and NAIW (North America Information
Warehouse) with data from PMH order Management applications liche D700,
FUSION etc.
Responsibilities:
. Ensure Business Objects Enterprise content security by creating
access levels for Developer, Super User and Basic User roles in
all dev, test, pre-prod and production environments.
. Assign top level security within cmc for developer group, super
user group and basic user group using the custom access levels in
all enterprise deployments.
. Assisting end users with reporting requirements gathering,
designing and developing webi and deski reports along with
resolving access related issues.
. Creating new connections, access restrictions, check integrity,
check cardinalities, resolve loop by adding aliases & contexts,
speedup query time by applying aggregate awareness within
designer.
Company Name: KPIT Cummins
Project : Supply Chain Visibility Tool
Client: Cummins
Role: Team Lead
Duration: Feb 05 - May 05
Environment: MS Windows 2000 Server, Oracle 9i, Business Objects 6.1b,
Visual Basic 6, ASP, Pl/Sql
Description: Supply Chain Visibility Tool (SCVT) from KPIT Cummins Info
systems Limited is a pre-built Solution that provides decision support
through various Key Performance Indicators (Kips) based on widely
recognized SCOR model, for ensuring a healthy Supply Chain Process. This
greater Visibility enables more proactive supply chain management, allowing
businesses to improve Efficiency, better manage costs and inventory, and
enhance customer relationships. In many cases, it allows managers to
identify small problems and to correct them before they become big ones.
Supply chain management through SCVT also provides supervision and
direction for the various Parts of the distribution system including
production scheduling and inventory control, Transportation, warehousing,
etc. It encompasses all industry sectors.
Responsibilities:
. Design & Implement systems that meet the information delivery
needs of business intelligence systems; perform technical and
advisory functions in the development of business objects
architecture and the creation of frameworks for reporting,
dashboards, delivery, scheduling and object retention policies for
complex information systems
. Work with the business management to ensure business objects are
appropriately utilized for all required management and adhoc
reporting, as well as data extracts for shared data agreements.
. Oversee the Maintenance of Business Objects Enterprise &
coordinate the continued development and enhancement of Business
Objects Universes and upgrade of all BOE deployments from BO 6.1b.
. Assign top level security within cmc for developer group, super
user group and basic user group using the custom access levels in
all enterprise deployments.
Company Name: Infinite
Client: GE Energy
Duration: Aug 04 to Jan 05
Environment: Oracle 9i, Business Objects 5.1, Informatica 6.0 and MS
Windows 2000server
Description: GE ENERGY SERVICES (PARTS) is a business that deals with the
Foreign exchange of goods and material. This business is used to track the
goods that purchase and sales in foreign exchange currency by the customer.
ERP application is used for tracking the order booked by the customer.
Hedge Application is used for tracking through which currency the order is
purchase and sales are made
Responsibilities:
. Using Informatica to Extract, transform and load the data into
data Warehouse
. Using transformation in mapping according the business logic in
Informatica designer.
. Creating Universes using Business Objects Designer.
. Creating Alias, Hierarchies, Context and predefined condition in
Designer
Duration: JAN 04- Aug 04
Environment: Oracle 9i, Informatica 5.1, and Business Objects 5.1, MS
SQL Server 2000
Responsibilities:
. Using Informatica to Extract, transform and load the data into
data Warehouse
. Creating Mappings and Mapplets, and tuning them for better
Performance
. Creating connections to sources and target in workflow manager.
. Used workflow manager to create workflow and monitor
Company Name: Orbit Technologies
Client: Malaysia Govt
Duration: Jun 03 to Dec 2003
Environment: Oracle 9i, Data Stage, and Business Objects 5.1, MS SQL
Server 2000
The MITTI system provides with the Information to monitor international
trade and industry of Malaysian govt. entering the long distance market.
The MITTI is a data- warehousing project designed to Extract data from the
legacy systems and provide processing of the data in order to Provide
mandatory reporting the Data Mart concept and is designed to support the
Reporting and analytical requirements of the long distance entry effort via
automation of Regulatory reporting.
Responsibilities:
. Extensive experience in creating Jobs, Transformer, expression,
filter, aggregator, Link connector, link partition, join, funnel,
lookup, sort, merge in parallel jobs.
Personal Details:
Name: Khaja Mohammed Amjad Siddiqui
Education: B.Com (Computer's)
Contact Number: 91-996*******
Passport Number: H8464109
Visa Status: B1
Visa Valid: 30-Aug-2016