SUMMARY:

• Accomplished Sr. BO Developer/Lead/Architect with 14 years of professional experience and demonstrated success designing and implementing solutions that improve business functionality and productivity with diverse technical background and proven ability to design, develop and implement technology on an enterprise level. Approach all projects with passion, diligence, integrity and exceptional aptitude. 
• Extensive experience in Software Development Life Cycle (SDLC) including Analysis, Design, Development, Implementation, Deployment, Testing and Maintenance of Business Intelligence applications.
• Experience in the documentation of system and business requirements and specifications, step - by step technical and user manuals, design and development of use and test-case scenarios and root-cause analysis, developing test plans, conducting user acceptance testing, training, and implementing new processes and technology.
• Proficient in translating report requirements into detailed report specifications, confirm report design with business users and creating reports using Business Objects 4.1, 4.0, XIR3, XIR2, 6.5.x/5.x, Crystal Reports XI, 2011 and 2013.
• Expertise in Business Objects Products (Universe Design and Information Design Tools, BI Launch Pad, InfoView, Desktop Intelligence, Web Intelligence and Rich Client, Supervisor, Version and Promotion Management, LCM, CCM & CMC) and its deployment.
• Expertise in identification of Business and Data requirements and converting them into conceptual and logical data models.
• Very good understanding of Data Warehousing Design Methodology, Data Warehouse Concepts, Database Design/Architecture including both OLAP & OLTP data.
• Experience in designing the Dashboard with Dashboard (Xcelsius) (Live Office, BIWS and QAAWS) and Tableau.
• Experience in creating Folders, user groups and setting user rights and managing the security using CMC and Supervisor.
• Strong working knowledge in implementing the Best practices for Business Objects Enterprise.
• Experience in Optimizing and tuning of universe and SQL to improve the performance of the Reports.
• Expert in mentoring/training/assisting business users on Business Objects Products.
• Experience in ETL with Business Objects Data Integrator/Data Services.
• Possess excellent communication, decision-making, Problem Solving, Analytical, and Interpersonal skills with result oriented dedication towards goals.
• Experience in Migrating/Upgrading Business Objects XIR2 to XIR3.1, XIR 3.1 to 4.0 and XIR3.1 to 4.1
• Possess leadership qualities of managing the Onsite/Offshore teams.
• Experience in Customization of Infoview/WEBI using BO JAVA SDK.
• Strong Knowledge of Business Objects Integration with SAP BI 7.0.
• Experience in SAP BI, BW and ETL.
• Strong Knowledge on BO 4.2 Architecture, Installation and Configuration.
• Knowledge in Planning, Designing, Developing and Deploying Data warehouses/Datamarts.

TECHNICAL SKILLS:

BI Tools: Business Objects 4.1 and 4.0, XI 3.1,R1/R2,6.5.x/5.x, Supervisor, CMC, Universe and Information Design Tools, Broad Cast Agent, Desktop Intelligence, Web Intelligence and Rich Client, Dashboard/Performance Manager and Xcelsius 4.5/2008/4.1 , Live Office, BIWS, QAAWS, Infoview, Report Conversion Tool, Import Wizard, Crystal Reports XI; Life Cycle and Upgrade Manager Tools, Cognos 8 BI Suite, Report/Query Studio, Framework Manager

Third Party Tools: Infoburst 2.6

Databases: Oracle 11x,10x, 9x, SQL Server 2000, 2005, 2008, 2012, Sybase,  DB2, Microsoft Access 2010, Visual Foxpro 9.0, Teradata,

Data warehousing: Star-Schema Modeling, Snowflakes Modeling, FACT, dimension tables

Operating Systems: Windows NT, Windows 2003, 2005 and 2008 Server, Unix

Development Tools: Developer 2000, Forms 6.0

Programing Languages: SQL, PL/SQL, JAVA, HTML, XHTML, C, C++, C #, COBOL

Modeling Tools: Erwin R7.3, Visio

ETL Tools: Business Objects Data Services/Data Integrator XI 4.0/11.7

ERP: Movex 12, ECC 6.0, SAP R/3 4.7

PROFESSIONAL EXPERIENCE:

Confidential, Jersey City, NJ      

Sr. Business Objects Developer/Lead/Analyst

• Involved in the complete life cycle of FATCA, GDS (Trading Application), Reconciliation (Client Statements) Projects from Requirement, Development, Deployment and Testing.
• Enhanced CLM Project as part of Customer Relationship Management System(Know Your Customer) user interface changes.
• Provided estimation for FATCA and CLM Projects.
• Business Analyst - Frequent interaction with Data Architect and Business to review requirements and results.
• Provide the team with a vision of the project objectives.
• Motivate and inspire team members.
• Ensure deliverables are prepared to satisfy the project requirements, cost and schedule.
• Worked in onsite-offshore Model.
• Developed Universes using UDT & IDT.  
• Designed and Developed FATCA and GDS (Trading Application) Universe from Scratch.
• Interacted with FATCA/GDS (Trading Application) users for Reporting Requirements.
• Designed, Developed and Implemented Complex WEBI reports.
• Created Scheduled reports as per user needs.

Confidential, Bridgeport, CT 

Sr. Business Objects Developer/Lead

• Involved in the complete life cycle of Anti Money Laundering and Loan Quest Projects from Requirement, Development, Deployment and Testing.
• Provided estimation for AML and Loan Quest Projects.
• Frequent interaction with SAS and Mortgage Flex Vendors, Data Architect and Business to review requirements and results.
• Performed Code review of other Team Members.
• Developed Universes using UDT & IDT.  
• Designed and Developed Anti Money Laundering, Loan Quest Operational OLTP and Loan Quest Data Ware House Universes from Scratch.
• Interacted with the various departments like AML, Loans, Deposits, Mortgage and Sales and for Reporting Requirements.
• Designed, Developed and Implemented Complex WEBI reports.
• Worked extensively with the major functionality like Breaks, Sections, Pre- defined conditions, Calculations and Ranking, Context Operators (For all, For Each and In).  
• Created Custom Calendar’s to satisfy end user needs for Report Scheduling.
• Worked on different Business Change Requests to satisfy user needs.
• Developed Dashboard’s for AML and Loan Quest User groups.
• As part of Loan Quest Project, Created New Crystal Reports from scratch, and recreated Crystal Reports in WEBI.
• Installed, Configured and Administered BO 4.1.
• Provided estimate and roadmap for the Migration and Upgradation from Business Objects XI3.1 to 4.1.
• Implemented Business Objects Best Practices.
• Carried on Migration and Upgradation from Business objects XI3.1 to 4.1.
• Converted Universes from 3.1 UNV to 4.1 UNX as part of Upgradation.
• Assisted Team by converting Reports from 3.1 to 4.1.
• Converted DESKI to WEBI Reports using Report Conversion Tool.
• Resolved the Reporting issues as part of Upgradation Project.

Confidential, Parsippany, NJ 

Sr. SAP BO Developer/Architect/Administrator

• Frequent interaction with Functional Analysts and Business to review requirements and results.
• Provided sizing/scalability recommendations for current and proposed deployments to ensure compliance with overall Business intelligence Strategy.
• Design of Architecture to support to full Lifecycle Development of Universes and Reports.
• Installed and Configured BI 4.0, patches and upgrades.
• Administration of servers, Tomcat Webservers, Windows Active directory SSO.
• Provided estimate and roadmap for the migration from Business objects XI3.1 to 4.0.
• Performed the migration from Business objects XI 3.1 to 4.0 using Upgrade Management Tool.
• Migrated the Security, Universes and Reports from XI 3.1 to 4.0.
• Migration of Universes from one Domain to another like DEV-STG-PROD.
• Validated the Installation by checking the Public Folders, Reports, Groups and by Running Reports.
• Performed Regression testing after Migration.
• Implemented Business Objects Best Practices.
• Developed and Created classes with Dimensions, Detail and Measures Objects.
• Defined Hierarchies in Universe to provide the users with drill down option in Reports.
• Used Lifecycle Manager to promote Jobs from DEV-STG-PROD.
• Developed Universe user Documentation guide for the End Users reference.
• Preparing the Project Plan and update the status of the project to the client with progress and achievements.
• Involved in the entire Software Development Life Cycle of the Project on multiple Enhancements.
• Involved in Requirement Analysis and effort estimation for Report Development and Deployment.
• Designed Reports in Web Intelligence for reconciliation in Sales and Finance.
• Worked closely with Controller, Finance Director and Executive for Auditing and Sales Revenue reports.
• Designed simple to complex reports using different data providers like Universe, Stored Procedures and Free Hand SQL.
• Scheduled the Daily, Weekly and Monthly publications.
• Developed complex reports using features like slice and dice, drill capabilities, Smart Measures, Input/Output Contexts, @Functions and Cross tab tables.
• Developed a Sales Book report which shows the entire Sales history of Customers at Account Manager Level through Web Intelligence. This report is emailed to all of the Account Managers of DSI in PDF format on first Business day of the month.
• Trained end users on using Business Objects.
• Responsible for preparation of Detail Specification Documents and Training Guides.
• Designed the Dashboards using Tableau for the Sales and Finance departments.
• Written SQL queries for data level and Business Logic testing.
• Created New Crystal Reports for Finance Department.
• Involved in modifying the Stored Procedures, which were used for Reports.
• Worked as an IT Support to solve issues/tickets related to Business Objects using Track It.
• Created, Tested and Executed Jobs using Designer to Transfer data from source to target.
• Created Scripts, Jobs, Workflows and Dataflows using Designer.
• Created, Monitored sessions and workflows in the Work Flow Manager.
• Worked on various Transforms like Query, Case, Merge, Date Generation, History Preserving, Table Comparison and Map Operation.
• Experience in debugging execution errors using Logs (trace, statistics and error) and by examining the Target Data.

Confidential, Livingston, NJ 

Sr. Business Objects Developer/Administrator/Data Services

• Managing the Business Objects Servers using Central Management Console and Central configuration Manager.
• Setup the Security at the Folder level using Central Management Console.
• Created user accounts and resolved the user account issues.
• Designed the Security Architecture in Business Objects XI 3.1.
• Converted few reports from DESKI to WEBI by using Report Conversion Tool.
• Developed Universe using Designer Module.
• Extensively worked on the maintenance of complex universes.
• Interacted with Business Analysts, SME’s, Technical Leads and Data Architects for Design finalization.
• Created File based events to trigger the scheduled WEBI reports. Scheduled the Daily, Weekly and Monthly reports.
• Designed simple to complex Reports using Web Intelligence and Rich Client.
• Designed the Dashboards using Xcelsius and Dashboard Manager for the different Hospital clients.
• Converted few reports from DESKI to WEBI by using Report Conversion Tool.
• Customized EMARS Application to meet the needs of end users using BO JAVA SDK.

Confidential, Boston, MA

 Sr. BO Developer/Administrator/Team Lead/Architect

• Installed and Configured BO 3.1, patches and upgrades.
• Designing the security using CMC.
• Managing the Business Objects servers using CMC and CCM.
• Setup the security at the Folder Level in the CMC.
• Row level security is implemented with different user groups.
• Administer and maintain Business Objects XI 3.1 on Development, Testing and Production regions.
• Implemented the CMS clustering for load balancing.
• Performed the migration from Business objects XIR2 to XI 3.1 using Import Wizard.
• Migrated Users, Categories, Reports Folders, Universes, Security Model from XIR2 to XI3.1.
• Migration of Universes from one Domain to another like DEV-STG-PROD.
• Gathering and analyzing the requirements.
• Involved in understanding the end user requirements and business processes in creating and designing Universes, Queries and Reports.  
• Maintained the universe by creating the Joins, aliases and contexts.
• Optimizing the Universe to improve the performance.
• Extensive universe testing and conducted UAT in multiple sessions with the end users.
• Created reports which involve complex Financial calculations, linking data from multiple data providers.
• Used Business Objects functionalities like Breaks, Sorts, Alerters, Filters, Data Tracking, Quick Display, Optional Prompts and Conditions.
• Tuning the SQL to improve the performance of the reports.
• Validated the Data in the Reports with the Databases.
• Enhanced the Existing reports using Sub queries.
• Worked on VBA Macros to email the Reports in PDF Format to relevant Sales Agents.
• Installed the Infoburst on the server to create the reports and email them to the relevant Users in PDF format for the Sales Agents.
• Provided Training to Business Users about the Business Objects Reports.
• Documenting the production and development environment changes made on the WEB servers.
• Designed the Xcelsius Sales Dashboard.
• Created New Reports in Cognos, Converted all Cognos reports to WEBI as part of Conversion Project.
• Involved in the entire Software Development Life Cycle of the Project on multiple Enhancements.
• Installed and Configured Business Objects/Data Integrator on Development, Testing and Production Regions.
• Implemented Business Objects Best Practices.
• Provide guidance to Business Customers on Sources.
• Provided sizing/scalability recommendations for current and proposed deployments to ensure compliance with overall Business intelligence Strategy.
• Provide technical oversight and subject matter expertise to BI team on key initiatives.
• Managed customer expectations to ensure strong customer satisfaction by meeting the Business needs for IT systems in timely manner.
• Leading the team of 3 by motivating the team to complete the tasks on time with appreciations.
• Developed Source to Target ETL BODI extract Jobs.
• Created and Enhanced several BODI extract Jobs.
• Used different Data Integrator transforms like Query, SQL, Key Generation, Table Comparison and other transforms available.    
• Scheduled and Configured the Jobs so that concerned groups will be notified through email when a Job fails.

Confidential, Cranbury, NJ 

 Sr. Business Objects Developer

• Analyzed the existing OLTP system, which is a Claims Management application with back-end Oracle.
• Involved in project planning sessions with Project Managers and Business Analysts to analyze business requirements and outline the proposed solution.  
• Design, Develop and Test complex Universes with Features like Aggregate Awareness, Contexts, Joins and Derived tables.
• Resolved loops by creating Aliases and Context.
• Optimizing the Universe to improve the performance.
• Created Web Intelligence and Business Objects full client reports.
• Experience in creating various types of Reports like Cross tab Reports, Drill through Reports.
• Created User Prompts, Conditions and Filters to improve the report generation.
• Tuning the SQL to improve the performance of the reports.
• Linked the Universes to share the common components between the Universes.
• Created Objects with Hints at the Universe to improve the performance of the Reports.
• Provided Training to Business Users about the Business Objects Reports.
• Conducting periodic training for business users on reporting techniques.
• Extensive universe testing and conducted UAT in multiple sessions with the end users.

Confidential, Naperville, IL 

Sr. Business Objects/BI/BW Developer

• Created and Loaded Master and Transaction Data from SAP R/3 as well as Flat File Source Systems into BW.
• Worked on Info Providers Design (DSO, Info Cubes, Info Objects), Data sources, Transformations, DTP’s, Info Sources, Multi providers, Info Sets, Process Chains.          
• Worked extensively in SAP BEx Query Designer, BEx Analyzer, Report Designer, Web Application Designer.
• Experience in Designing the BW Reports from Infocubes using different characteristics and keyfigures.
• Designed Universes using SAP BI Queries and Infocubes as Data Sources.
• Extensively worked with PSA in monitoring the Data Transfer from Source Systems into BW and debugged when required.
• Worked on Data Mapping Fields between R/3 and BW for Info Cubes.
• Analysis of the requirements and lots of interaction with the end users to get to the report templates approved.
• Designed a universe to support all identified enterprise reporting data and possible ad-hoc reporting with all subject areas of the warehouse.
• Created reports in XIR2 Web Intelligence with the lot of hyperlinks to provide guided analysis.
• Created reports which involve complex calculations, linking data from multiple data providers, using free hand SQL, stored procedures.
• Created User Prompts, Conditions and Filters to improve the report generation.
• Created Refresh on open and Scheduled Reports.
• Designed the Supply chain Corporate Dashboards.
• Provided Training to Business Users about the Business Objects Reports.
• Responsible for conducting UAT sessions with the end users.

Confidential, Chicago, IL  

Sr. Business Objects Developer

• BO universe and report developer.
• Gather and analyze the requirements.
• Installing and Configuring of BO Suite of products in Development, Production and QA environments.
• Design and develop universes.
• Performance optimization through implementing aggregate awareness.
• Created multiple complex objects in the universe to facilitate easy reporting.
• Created Web Intelligence and Business Objects full client reports.
• Designing Corporate Dashboards with automated rules and Dimensional Analytics.
• UAT with large group of users across the country.
• Extensive universe documentation and system documentation.
• Extensively involved in using of Formula fields, Parameter fields, Group and Record selection in Crystal Reports.
• Created queries using Add command objects in Crystal Reports XI.