Untitled Document

PROFESIONAL SUMMARY:

• Over 15 years of experience in analysis, design, development, production and maintenance of SAP Business Intelligence Applications.
• 13Years of experience in providing BI (Business Intelligence) Solutions to Telecom, Retail, Financial, Manufacturing, Insurance and other industries.
• Over 11 years of experience in Architecture Design, Development and installation & configurations using Business Objects suite of Products (5.x/6.x/XI R2 and XI R 3 and BI 4.0)
• Strong experience in Performance Tuning, Server sizing, Capacity Planning and deploying Business Objects applications to single and multi server (Clustered) environments
• 1 year of experience in Designing and Developing Mobile BI 4.0(Reports and Dashboards) for Black Berry Devices Applications.
• 3 years of experience in SAP BW integrating with SAP Business Objects/Crystal Reports.
• 6 years of experience in migration of Business Objects Reports, Universes and other Objects from BO 5.x/6.x/Crystal 9.x/10.x to XI R3.x/R2 environment using BO Import Wizard and Life Cycle Manager
• Expert in Trouble shooting various Reports and Universes issues occurred during development and migration of BO Legacy environment to BO XI R3/R2.
• 3 years of experience in Configuring and developing Crystal, Xcelsius Dashboards using Query as a Web service (QAAWS), Live office connector and XML Maps.
• Strong Experience in all phases of the project life cycle and Train End users in various Business Intelligence Tools.
• Strong ability in translating business requirements into technical solutions
• Identify the Business requirements from the Business units and prepare system design specifications

Technical Skills:

Architecture:

Client-Server, Data Warehouse , Business Objects Product Suite, SAP BW

Database:

Oracle 7.x/8.x/9.x/10g/11g, Teradata V2 R5/R6, HP Neo View 2.0, MS SQL Server, Red Brick 6.x, Netezza, Sybase, SAP BW 7.x

GUIs/Reporting Tools 
/CASE Tools:

Business Objects Product Suite, Crystal Reports 2008, Oracle Reports, Cognos, SAP GUI, Xcelsius, BEx Query Designer

Methodologies:

Dimensional Modeling, DW Methodologies

Operating Systems:

Windows 2000/ NT/2008, UNIX

Warehousing Tools:

Informatica, Data Integrator, Ab Initio, Erwin Data modeling

PROFESSIONAL EXPERIENCE:

Confidential Sept 2009 – Till Date
Role: SAP Business Objects Administrator/Sr. Report Developer

Research In Motion (RIM) is a leader in the worldwide mobile communications market and the company behind the award-winning BlackBerry® solution.

As a Business Objects Administrator/Sr. Developer, my responsibilities include

• Migration of Business Objects universes, reports, Crystal reports and Xcelsius Dashboard content to various environments (Dev, QA and Production)
• Perform Health check of the environment and perform server sizing, capacity planning when required
• Install and Configure Server Components and Client Components
• Planning and migration of the Business Objects environment from XI R2 to XI 3.1 and BI 4.0
• Perform the Backup of the system content, maintain and install Fix packs
• Setup the Security model for accessing the Business Objects content based on the project requirements
• Review and approve the development content (Universes and reports) before migrating to Production
• Work with Business Units and Development team in resolving the system issues.
• Train End users in using SAP Business Objects Suite of Products
• Install and configure Business Objects Mobile solutions to Black Berry devices
• Work with DBA’s and ETL developers to define the Data models and performance tuning.
• Implemented SSO and Windows AD and SAP authentications

Technical solutions included SAP Business Objects XI R2/3.1/BI 4.0, HP Neo View 2.0, Tera data v2 R6, Oracle 10g/11g, SAP BW 7.x

Client: Confidential, GA Nov 2007 – May 2009 
Role: Business Intelligence Consultant
Affinity is the new Macy’s application developed for centralizing Order Management after the merger of Federated Units. This is replacement with legacy system. 3000 Business Users use affinity Reports.

• Responsible for adhering to the project plan and ensuring successful implementation of Business Object solutions.
• Provide support for capacity planning, server sizing and performance tuning
• Designed and Leaded Construction for Targeted Ad-Hoc, Canned Reports and Universe Development Process.
• Designed and Constructed Complex Reports Which Change their Layout/Structure Based on Prompts Selection.
• Analyzed requirements from Business Users.
• Document Reports & Universe specifications and design.
• Designed and developed, maintained and Tested UNIVERSES for supporting Adhoc and canned reports.
• Interacted with DBA’s and Analysts for Universe and Reporting Query costs.
• Tuned universes and reports for better performance.
• Created Dynamic Hierarchies for providing drill down options for the end-user.
• Made the Reports user friendly by implementing user prompts, conditions and filters.
• Extensively worked on Defect Analysis and Construction (UAT and Internal Testing).
• Involved in Publishing of universe and reports across Dev, Test and Pre-Prod.
• Developed functional Specification and Component Test plans from Business and Technical user use cases

Technical solutions included Business Objects XI R2/R3, Perfomance Manager, Erwin and SQL server 2005

Client: Confidential, CA Nov 2006 – Oct 2007

Meesala assumed responsibility for developing and deploying comprehensive enterprise Data Warehouse Reporting solutions for various business divisions at City National Bank. 
As an Business Intelligence Architect his responsibilities included

• Architect, design and develop Deployment strategies.
• Provide User support and administer Business Objects product migrations from BO 6.5 to BO XI R2
• Oversee the development activities and mentor the developers in building the Universes and Reports.
• Create User groups and implement Row Level and Rule based Security
• Create Proof of Concepts and turning them into real time solutions
• Define and Implement development standards for Universe design, Report development and BI Dashboards
• Plan and Manage upgrade and migration of projects
• Gather requirements for Canned Reporting , Ad hoc querying and also for Dashboard creation
• Developed Customized Information Portal for CNB using SDK (Java Scripting)
• Developed Infoshare information portal for CNB employees to access the various reports like Loan Summary, Customer Account Details etc.,using Crystal Xcelsius
• Worked Extensively in BEx Analyzer in building Queries, saving it in Workbooks (Excel work Sheets) and WEB Application Designer (WAD) and Query as a Web service
• Lead a team of Designers and Report developers
• Data Validation between R/3 and old Production system
• Developed mappings using different transformations to transform the data and load it to Target Database
• Created and configured Sessions to load the data from source to target database using Server Manager
• Created the batches to run several sessions sequentially and concurrently
• Implemented Windows AD authentication

Technical solutions included Business Objects 6.5/XI R2/Perfomance Manager/SDK (JSP), Erwin and Oracle 10g and SQL Server 2003, SAP R/3, ECC 6.0, BEx Reporting, WAD, Crystal Xcelsius

Client: Confidential June 2005 – Oct 2006

Role: Information Delivery Architect

Meesala assumed responsibility for developing and deploying comprehensive Data Warehouse Reporting solutions for various business domains with in BellSouth. 
As an Information Delivery Architect his responsibilities included

• Architect, design and develop Deployment strategies.
• Primarily responsible for providing End user support to the Business Objects customers in trouble shooting Business Objects, Web Intelligence products and other integrated applications
• Provide support for capacity planning, server sizing and performance tuning
• Oversee all the development activities from architecture standpoint.
• Define and Implement development standards for Universe design and Report development
• Plan and Manage upgrade and migration of projects
• Managed Business Objects Product migrations from BO 6.5 to BO XI R2
• Manage multiple projects, maintained project status score card
• Gather requirements for Canned Reporting and Ad hoc querying
• Lead a team of Designers and Report developers
• Implemented single sign-on LDAP site minder authentication
• Technical solutions included Business Objects 6.5/XI R2, Informatica , Erwin and Oracle 9i and Teradata v 2.0 R5.0, Site Minder

Client: Confidential Apr 2002 – May 2005

Role: Senior Report Developer/Lead

Meesala worked as a senior Report developer at America Online. He is responsible for gathering requirements for Canned Reporting and Ad hoc querying. Installing and configuring Business Objectsproduct suite,

• Repository setup and Administration, Creating the user groups and defining their security and creating Business Objects universes and Reports.
• Installed Business Objects XI R1 and migrated the existing universes and Reports from BO 6.5 to BO XI R1
• Developed Onramp dashboard to navigate BO reports using SDK
• Involved in defining the Reporting strategies and development standards for Enterprise Reporting.
• Mentored a team of developers and provided the on-going support to the Business Objects End Users.
• Implemented LDAP authentication

This system included the following technical components. Business Objects 5.x/6.x/XI R1, Web Intelligence 2.x, SDK, JSP, iPlanet 4.1, Ab Initio, Red Brick 6.1, Sybase, Windows 2000 Server, Netezza, Weblogic, Siebel 7.5

Client: Confidential Jan 2001 - Feb 2002

Role: Sr. Support Engineer/ Consultant

• Meesala worked as a Senior Technical Support Engineer/Consultant with Business Objects Americas.
• Was engaged into multiple projects for implementing Business Objects Product solutions to various clients like GEPS, Solectron Corporation, Actano Corporation etc.,.
• Primarily responsible for providing on-site support to the Business Objects customers in trouble shooting Business Objects, Web Intelligence products and other integrated application and also to provide support for capacity planning, server sizing and performance tuning