Candidates About

Farha Tarannum

Senior BusinessObjects SME

·         Certified SAP BusinessObjects Professional with Over eleven years of professional experience as a software developer in designing and development of Data warehouse, Reporting, SAP BusinessObjects 4.2/4.1/3.1/XI R2/Crystal Reports XI, Xelsius, Design Studio 1.6/1.4, Lumira Oracle, SAP BW and SQL Server.

·         Experience with the complete Project development life cycle including System Analysis, Design, Development, Testing, Deployment and End User Training.

·         Extensive experience installing desktop and enterprise server products of SAP BusinessObjects in single and distributed environments on Windows.

·         Highly proficient at creating SAP BusinessObjects universes using SAP BusinessObjects Designer.

·         Experience in Creating SAP BusinessObjects Dashboards using BO Performance Management.

·         Expert in working with all the modules of SAP BusinessObjects 4.2/4.1/3.1/XI R2/6.5/5.x such as: Central Management Console (CMC), Central Management Server (CMS), Crystal, Xcelsius, Desktop Intelligence (Deski), Web Intelligence (Webi), Scheduler, Supervisor, Designer, and Application.

·         Expertise in training and supporting end-user reporting needs using SAP BusinessObjects.

·         Worked extensively with new features of BusinessObjects XI including Derived tables and Central management console.

·         Solid team player with the interest and ability to learn new technologies quickly. Ability to learn new technologies and challenging concepts quickly and implement them.

Business Intelligence:  SAP BusinessObjects 4.2, 4.1, 4.0, XI R3.1/XI R2 BusinessObjects XI 6.5/6.1/6.0/5.1 (Supervisor, Designer, Info view, SAP BusinessObjects Enterprise Reporting, Web-Intelligence 6.0/2.7/2.6/2.5, Broadcast Agent, Designer, Supervisor, Auditor, Performance Management & Dashboard Manager, Report Writer), IDT, UDT, Analysis For Office 2.2 sp2 , Design Studio 1.6/1.5/1.4, Lumira, SAP Crystal Reports 10/XI, Crystal Enterprise, Central Management Console, Tableau 8, 9, 10, Tableau Desktop, Tableau Server, CA Clarity PPM (v13/12.1/12.0, XOG), Acqua Studio, TOAD 8.5, SQL Navigator, Info-burst, Bex query, Data Federator.

Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERWIN 4.0, Visio.

Databases: SAP, Oracle 10g/9i/8i/8.0/7.x, MS SQL Server 2000, SQL Server 2005, Teradata, MS Access, Rapid Mart.

Programming: SQL, PL/SQL, SQL Plus, VB, C, C++.

Environment: MS-Windows 9x, Windows NT 4, MS-Windows 2000/XP.

·         Bachelor of Technology in Electronics and Communication from JNTU, Hyderabad, 2004.

·         PG Diploma in Embedded Systems from Cranes Software International, Bangalore, 2005.

BP, Wayne, NJ                                                                                        April 2016- Till Date

Lead Application Admin & Developer SAP BusinessObjects  

We provide fuel for transportation, energy for heat and light, lubricants to keep engines moving and petrochemicals used to make everyday items. BP delivers energy products and services that people around the world need. Our Upstream segment is responsible for oil and natural gas exploration, field development and production. Our Downstream segment is focused on the refining and marketing of fuels, lubricants and petrochemicals.

Responsibilities:

• Hands on experience with implementation on installations on windows environment 
• Implemented SAP BusinessObjects on multiple servers performing load balancing and clustering in order to have high availability all the time to the clients. 
• Installation of SAP BusinessObjects XI 4.1 sp4 in all phases of environment i.e. Sandbox, Development, Testing and Production.

Administration, Maintenance and Troubleshooting of SAP BusinessObjects XI R4.1 platform. 
• Installed new service pack and fix pack sp5 and fix pack 5.3) on top of sp4 in all servers 
• Installation of SAP BusinessObjects Client Tools XI 4.1 sp4 and corresponding Patches.
• Working Extensively with SAP Customer Support for the BO 4.1 Issues & Bugs 
• Involved in Weekly Meetings with SAP to review the Users Issues, SAP Tickets 
• Discuss Integration and Road mapping for future SAP BOBJ products. 
• Review an Architecture Assessment Analysis (Sizing Analysis). 
• Review and discuss and assess the current Security Model 
• Experienced in promoting SAP BusinessObjects environments through development, QA, UAT, DR and production using Process management tool. 
• Experienced in scheduling the reports,in CMC. 
• Experienced in LADP configuration. 
• Configuration of various database connectivity (SAP, oracle, DB2, Sql Server) 
• Set up the projects, roles, users, privileges in different 
• Set up the users and groups and folder in SAP environments 
• Provided support to the client and server issues (production support). 
• Resolved the developer issues and Incident (Incident management) tickets as per business time line. 
• Deft in preparation of change ticket and Standard Operating Procedures (SOPs) documents for Production support activity for SAP BusinessObjects 
• Resolving Trouble Ticket/Change requests logged by business user via remedy, ITSM 

Environment: SAP BusinessObjects XI R4.1 sp4, Webi, IDT, UDT, Informatica 9.1, Windows 2012, Windows 7, SQL

Astellas Pharma Inc. Northbrook, Illinois                              March 2014- April 2016

Lead SAP BusinessObjects Admin & Developer           

Astellas Pharma Inc. is a Japanese pharmaceutical company formed on 1^st April 2005.  ---The United States subsidiary of Astellas is Astellas US LLC. Some of the key products of Astellas are Prograf, Xtandi, Tarceva, Mycamine etc.

Responsibilities:

• Designed BusinessObject Universes and designed security for the Business groups. 
• Consolidated data packages and ran quarterly metric reports using SAP BusinessObject Financial Consolidation. 
• Extensive data validation and testing reports using SQL. 
• Worked with SAP BusinessObject BI 4.0 Suite tools (IDT, Dashboards 4.0, Explorer, BI Launch Pad) 
• Created complex webi reports with multiple queries, custom sql, using complex functions, merging dimensions at report level, drill down, drill up, drill across, complex filters etc 
• Developed reports using query designer, BEx analyzer, Webi and xcelcius. Converted Desktop Intelligence reports to SAP BI4 Interactive Analysis Reports. 
• Involved in analyzing and designing the data flow from ECC to BI and responsible for deployment. 
• Applied Restrictions, Object Level Security and Row Level Security at Universe Level. 
• Developed Derived Tables and Aggregate Tables in Universe to satisfy the Business User's Report Requirements. 
• Developed Stored Procedure Universes in Business Objects 3.1 
• Resolved Loops, Fan and Chasm Traps arisen due to Joins and Cardinalities in the Universe to resolve Cartesian products. 
• Performed Administrative tasks like Setting up user profiles, assigning rights and privileges for groups, setting up categories using CMC, and maintain Bo servers 
• Used the Projection function Database Delegated for Non-Additive Measures (Smart Measures) in the Universe 
• Created reports using various versions of Crystal Reports to satisfy the Business Report Requirements from Transactional Database. 
• Developed Sub-reports, Formula Fields, Parameter Fields, Running Total Fields and Group Fields while developing Crystal Reports. 
• Developed Group Selection and Record Selection Formulas to display the desired data in Crystal Reports. Understand user problem and recommend changes to the code and also train the user with Teradata knowledge which he/she lacking. 
• Very complicated SQL Query optimization (explains plans, collect statistics, data distribution across AMPS, primary and secondary indexes, locking, etc.) to achieve better performance. 
• Create reports on system usage analysis. 
• Written complex oracle SQL queries with complexity to gather the data from several sources and load into upstream Oracle database. 
• Create complex PL/SQL stored procedures, functions and packages for data extraction and data manipulation as per the Data Migration Mapping logic. 
• Suggest indexes on the tables for faster retrieval of the data to enhance the overall migration performance. 
• Create database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL developer and SQL* plus. 
• Coordinate with different level of team members and report to manager on the daily tasks. 
• Have mentored junior developer & worked independently or collaboratively. 
• Have knowledge of software development life cycle. 
• Create and update technical and functional scope documents. 
• Created and modified PL/SQL package stored procedures functions as per business requirements. 
• Involved and Coordinated with the modeling team to provide them with the necessary information and insight into data for creating tables, triggers, sequences, Indexes.

 • Familiar with Agile software methodologies (scrum). 

Environment: SAP BusinessObjects 4.1 sp5 patch 6, Design Studio 1.4, Crystal Reports 2008, SAP BW on HANA, Bex Query, Data Services.

IBM India Pvt. Ltd.                                                                          March 2012- Feb 2014       

Assigned to the following client projects:

Arla Foods Amba, Hyderabad, India

Arla Foods Amba is a farmer owned Diary Company. The Principle has always been at the heart of everything and going strong over 100 years after Arla first started. Arla Focus on balancing incremental and radical innovation across the business with a primary target that 10% of our tournover should come for new product development. Dairy Products innovation keeps Arla on the top priority.

Responsibilities:

·         Resolving all the Application level issues for SAP BusinessObjects in AMS.

·         Promotion of Reports from Development to Production.

·         Done test case for webi and Dashboard on each server after HANA Migration.

·         Created Dashboard and webi reports and maintained them.

·         Multi Tab dashboards has been build and performance of the Dashboard has been take care by loading only those objects in the tab we are in.

·         Trained User on SAP Lumira, SAP BOD310.

·         Involved in Requirements gathering for making a Standardization SAP BusinessObjects SOP.

·         Helped users to improve Performance of the reports.

·         Had a much appreciation for my AMS activity from Client side.

·         Dashboards are build using a BICS connections.

Environment: SAP BusinessObjects 4.1 sp2, Design Studio 1.3, SAP BW on HANA, Bex Query, Data Services.

ICL Harmonization, Hyderabad, India

ICL Harmonization. Is an Israel Chemical Limited company ICL is a leading provider of potash, phosphate fertilizers and technology-rich specialty fertilizers – critical inputs that farmers need to increase their yields and improve the quality of their crops.

Responsibilities:

·         Developed Twelve large Universes (UNX) Using Information Design Tool 4.0SP2 with Single & Multi Source data sources .

·         Converted Universe (UNV) to Universe(UNX) using the IDT Tool 4.0 SP2

·         Extensively worked with new designer tool IDT 4.0 using Projects/Shared Projects, Data Foundation, Business Layer and Security Profiles.

·         Created Complex Webi Reports using new functionalities of Webi Intelligence 4.0

·         Designed Webi Report based on BEX Queries & OLAP Cubes

·         Created Security Groups, ACL, Users & Groups.

·         Working Extensively with SAP Customer Support for the BO 4.0 Issues & Bugs

·         Involved in Weekly Meetings with SAP to review the Users Issues, SAP Tickets & Product Bugs.

·         Extensively worked and designed Dashboard Using QAAWS & with the Universe Query

·         Installation of Business Objects XI 4.0 SP2 in all phases of environment i.e Sandbox, Development, Testing and Production.

·         Installation of XI 4.0 SP2 Patches and upgrades to ensure the SAP Portal and Business Objects systems are up to date with latest bug fixes.

·         Installation of Business Objects Client Tools XI 4.0 SP2 and corresponding Patches.

·         Designed the Designed Dashboards with Drill Down and Multiple Components and gadgets.

·         Involved in working with new XI 4.0 Tools (BI Workspaces, Modules. Dashboard,

·         Crystal Reports, BI Mobile, Explorer)

·         Involved in Working with the Windows AD Team for SSO Setup for BO 4.0.

·         Installed and Setup the BI Mobile 4.0 & Explorer.

Environment: Business Objects XI 4.0 SP2/SP4, FP(1.x/2.x), BO 4.0 Client Tools, Information Design Tool 4.0, Webi Intelligence 4.0.Upgrade Management Tool,SQL Server 2008. Windows 2008, Red Hat Linux , Tomcat 6.x, Apache 2.x ,Mobile & Explorer 4.0,Dashboards 4.0 SP2.

2Wire Development Center, Pune, India                                   August 2009 – Feb 2012

Sr. SAP BusinessObject Admin & Developer

Pace is a world leader in technologies, products and services for the broadcast and broadband industries. 2Wire media solutions deliver managed broadband entertainment services to the television, along with satellite, cable, digital antenna, or Internet TV programming. 2Wire media solutions enable a variety of entertainment services such as multi-room digital video recording, video place-shifting, media on demand, music management and photo sharing.

Responsibilities:

• Involved in interacting with Business users, gathering and analyzing requirements, logical and physical design of the reporting Requirements.
• Maintained & Modified Universes using BO Designer and exported to the CMS Repository.
• Prepared Business Requirement Document and then converted Business Requirements into Functional Requirements Specification.
• Wrote the Requirements and Functional Specification documents.
• Identified, researched, investigated, analyzed, defined opportunities for business process improvement, documented business processes and initiated efforts to Make best improvements
• Interviewed business users to gather requirements and analyzed the feasibility of their Needs by coordinating with the project manager and technical lead.
• Actively Involved in Installation of Business Objects XI 3.1 SP3 and Life Cycle Management (LCM) in all phases of environment i.e Sandbox, Development, Pre-Production and Production.
• Actively Supported with Database Team, Application Team and Network Team for Installing SAP Business Objects Supported Components and Requirements.
• Preparing the project plan and system architecture design and implementation with complete documentation with reporting applications proposing recommendations to client.
• Implement patches and upgrades to ensure the SAP Portal and Business Objects systems are up to date with latest bug fixes and security patches.
• Coordination and communication of planned upgrades, enhancements and maintenance outage window in collaboration with the infrastructure teams. This includes scheduling, coordination of testing and production readiness planning.
• Configuring the server setting to communicate with client tools such as live office, X-Celsius and query web server.
• Performing troubleshooting amd tuning CMS and server tuning parameters for Business Objects XI R3 environments.
• Meetings and Communications with SAP Team every Bi-weekly on Issues and Upgrades.
• Co-ordinated and Supported with SAP Team for the Technical Integrity Check on BO XI 3.1 SP3 Infrastructure and Performance of the Current environment for End- User.
• Co-ordinated and Monitored with SPT Testing Team for Average Performance and Refresh Time of Reports in Pre-Production Environment
• Involved in data Migration from Business Objects XI R 2 SP3 to XI R 3.1 SP3 and 6.5 SP3 to XI R 3.1 SP3
• Involved in SQL Queries and report performance
• Testing the Performance of Reports in BO XI 3.1 SP3 after Migration
• Created a High Level Security Frame Work and Access Levels according to Client Specifications.
• Manage objects, reports, universes and database connections within Business Objects, Report Job Scheduling
• Auditing of the application usage of reports and security through the repository or auditing features
• Involved in Designing Universes.
• Designed and developed dashboards Xcelsius 2008 .
• Maintaining procedures and perform tests for Business Contingency Planning/Disaster Recovery.

Environment: Business Objects 6.5,XI R2,XI R 3.1 SP3,CMS,CCM,INFOVIEW, BEA WEBLOGIC 10.X, Apache 2.X, Tomcat 6.x, Oracle 9i/11G, DB2 ,SQL,SQLServer,Solaris Sparc 10, IBM AIX, Windows Server 2003,LCM,Crystal reports 2008, Xcelsius 2008.

Globaltek, Inc., South Plainfield, NJ                                       August 2006 – June 2009

Senior Business Objects Consultant

Responsibilities:

• Gathered requirement from the Business/End Users through JAD and Interviews. Gathered requirement from the Business/End Users through JAD and Interviews.
• Analyze the source data and work with Data Warehouse team in developing Relational Model.
• Installed, Configured and Deployed SAP BusinessObjects Enterprise XI R2 on Windows 2003 Server and on UNIX.

·     Created and modified universes as per user requirements.

• Maintained & Modified Universes using BO Designer and exported to the CMS Repository.
• Migrated existing 6.5 to SAP BusinessObjects Enterprise XI R2.
• Created canned and Ad-hoc reports as to the user requirement in SAP BusinessObjects Enterprise XI R2 environment.

·         Used various functionalities like Breaks, Sorts, Ranking, Report Filtering, Query Filtering, Alerts, Sections, Slice and Dice.

·         Created custom Functions and exported them to the repository and used them in other reports.

• Created Joins and resolved loops using aliases, contexts to remove cyclic redundancies and improved performance issues in the universe.
• Access the full range of OLAP data sources with in the organization with the help of BOE Voyager to analysis and advance user interface and enables them to interrogate, analyze, compare and forecast Business drivers.
• Designed VBA Macro to implement a specific user requirement in Scheduling.

·         Maintaining the existing Universe ACBSDM and creating the targeted 150 Reports Created another Universe over SQL Server and creating the targeted 20 reports.

·         Created Asset Reports, Commitment Increase and Decrease by Customer and Office Reports, Facility Status, Margin and Fee Past Due Reports, Staff Past Due and Loan Past Due Reports, High Risk reports and Watch Reports – Total Portfolio vs. Watch etc.

• Within organization generated sub reports in SAP Crystal Reports as per ad hoc purpose.
• Designed Dashboards using Crystal Xcelsius Designer (with Live Office and QAAWS) taking the source from Excel.   
• Perform UAT testing on reports that were created in Development area.
• Performed both Unit and System integration testing of the Data marts.
• Execute Test Scripts on each build, identified the mismatches and logged defects in QC.
• Analyzed and trouble-shoot issues with Scheduling reports.
• Used Publication to schedule reports to more than one destination.

Environment: SAP BusinessObjects Enterprise XI R2/ Business Objects XI/6.5, SAP Crystal Reports XI, Xcelsius 2008/4.5, Desktop    Intelligence, Web Intelligence, Scheduler, Publication, Data Integrator, Oracle 10g/9i, TOAD, Info Burst, VBA Macro.