SUMMARY

• Having 7+ years of IT experience in Analysis, Technical Design, Development, Testing and Documentation including 6years in BO, Xcelsius, BI/BW, Crystal Reports, 2.6 years of experience in .NET, ASP, JSP, Java
• Expert at managing multiple projects simultaneously.
• Knowledge of reporting via Business Object XI R2, XI3, XI4, Oracle Discoverer.
• Expertise in Business Objects XI4/XI3/XIR2/6.x/5.x - Administration, Designing and Development.
• Expertise in universe designing, linking, developing and generating complex, adhoc, dashboard reports, business views, list of values along with user acceptance test and data accuracy test.
• Experience in migrating Business Objects Reports and Universes from 6.5 to XIR2, XI3, XI4.
• Experience in creating Crystal Reports using Crystal Reports XI/10 with expertise in developing standard, graphical, formula based, drill-down, sub-reports, cross-tab.
• Worked extensively with dimensional database modeling, data migration.
• Experience in installation, administration and upgrading versions of Business objects desktop and server products.
• Having good exp in Java, SDK, API’s, JDBC
• Experience in using various data providers for retrieving data and creating simple and complex reports
• Experienced in querying, creation and maintenance of database objects, stored procedures, PL/SQL, dynamic SQL and SQL* Loader.
• Having good experience as Business Analyst - Requirements gathering, Business requirements writing, Functional specifications writing, Use Case development, Analysis & Organizational skills.
• Extensively worked on End-user support, production support experience
• Determined user/business/functional requirements. Created vision, scope, and use case documents; business process models, use case diagrams, activity diagrams, and state chart diagrams
• Very good experience of SAP BW Components like InfoCubes, MultiCubes, InfoSource, InfoObjects, ODS Objects, Update Rules and Transfer Rules.
• Undergone complete life cycle implementation of BW, which includes Data-Modeling, Data Extraction, Generic Extraction, Data Loading, Scheduling, Monitoring, LO Cockpit, CO-PA and BEx Query.
• Experience in Report Generation in BEX Analyzer in building Queries and saving in Workbooks (Excel work sheets) and created Custom Queries using Conditions, Exceptions, Variables & Structures and created Aggregates for frequently used Queries.
• Unit, integration, performance testing and Participated in design reviews

TECHNICAL SKILLS

Business Intelligence: Business Objects XI3/XIR2/6.5/6.0/5i, Dashboard Manager, Crystal Reports, Crystal Xcelsius, Siebel Analytics

ERP: SAP - ABAP, Cross Applications, BDC

Data Warehousing: SAP - BW 3.5, BEx Analyzer/Browser, BI 7.0

ETL Tools: Informatica 6.0

Programming Languages: Java 1.2, C++, C, J2EE

Client Server Technologies: VB 6.0, Crystal Reports 9.0

Web Technologies: ASP, JSP, HTML, Java Script, VB.NET, ASP.NET, C#, XML

Back End: Oracle 8.0, MS SQL Server 2000, MS Access 2000

Designing Tools: Rational Rose, MS Visio

Data Modeling Tools: Erwin

Operating Systems: Windows 98/NT/2000, UNIX

Packages: MS Office, MS Project

PROFESSIONAL EXPERIENCE

Confidential, NH

BO Admin/Developer

Environment: Business Objects XI3/XI4.0 (Designer, Web Intelligence, Performance Manager, Reporter, Xcelsius), Infosol - Infoburst, 360View, HANA, Oracle 10g, SQL, PL/SQL, SQL Server management, SQL query analyzer, TOAD, Informatica, Erwin, Visio, HP Quality Center 10.0, Tomcat

Responsibilities:

• Requirements gathering, Analysis, Designing, Technical documents preparation
• Installed XI3 and updated patches and upgrades
• Created of user and user roles, and scheduling jobs and bursts
• Working on Administration, Security groups, users creation and trouble shootings
• Resolved connection issues which are created problem to access of Webi reports
• Troubleshooting production issues which related to Webi, Deski, Xcelsicus
• Scheduled & monitored reporting jobs and distributed the reports
• Did rerun failed jobs and identified the root cause for jobs fail
• Migrated Universes, Webi, Deski report from QA to Prod
• Resolved user login issues with LDAP, SAP authentication
• Created Bursts, Schedulers in Infoburst and created Cmd files to run the jobs
• Extensively worked on performance tuning and maintain system stability
• Created Universe connection in CMC; provided User roles, row & object level security and Privileges.
• Worked on designing data model for Forward/Reverse Engineering using Erwin and generated scripts
• Extensively worked on Universe creation and inserted new tables, created joins
• Created a wide variety of advanced reports of varying complexity including slice and dice, drill down
• Worked on Xelsius dashboards by using QAAS and Live Office connections
• Extensively used Scorecards, Gauges, Progress Bars, Pie charts to represent data in user friendly manner
• Extensively worked on production support, go-live activities and coordinate guide the offshore team
• Involved in Unit, Integration Testing

Confidential, Washington DC

Business Objects Developer/BO Admin

Responsibilities:

• Requirements gathering, Analysis, Designing, Technical documents preparation
• Migrated Universes, documents from XI2 to XI3
• Upgraded Business Objects server, Cluster Business Objects servers, Installed and configured Broadcast Agent (BCA)
• Tuned the performance of Business Objects system, Perform auditing and trace logging
• Implemented patches, performance tuning and capacity management
• Converted Deski reports to Webi reports
• Worked on designing data model for Forward/Reverse Engineering using Erwin and scripts generation
• Extensively worked on Universe creation and inserted new tables, created joins created more than 200 objects, created universe level filters

Confidential, Chicago, IL

Business Objects Admin/Developer

Environment: Business Objects XI3/4.0 (Designer, Web Intelligence, Performance Manager, Reporter, Xcelsius), Oracle 10g, SQL, PL/SQL, SQL Server management, SQL query analyzer, SQL Server 2008, JDBC, Java SDK, TOAD, Informatica, Erwin, Visio, HP Quality Center 10.0, Tomcat, Citrix, UNIX

Responsibilities:

• Requirements gathering, Analysis, Designing, Technical documents preparation
• Created with Business Objects repositories and universes
• Managed users with Business Objects Supervisor
• Migrated documents from a development to a production environment
• Migrated Universes, documents from 6.5 to XI3/4.0
• Installed Apache web, Tomcat application servers and BO-SharePoint integration
• Installed, configured, and administer Business Objects server
• Upgraded Business Objects server, Cluster Business Objects servers, Installed and configured Broadcast Agent (BCA)
• Tuned the performance of Business Objects system, Perform auditing and trace logging
• Implemented patches, performance tuning and capacity management
• Extensively worked on customer support environment to generate related reports
• Created reports on Customer orders and referrals, dealing with complaints, enquiries as well as sales promotions and new deals
• Converted Deski reports to Webi reports
• Knowledge of designing data model for Forward/Reverse Engineering using Erwin
• Installed the Business Objects components on UNIX and Windows OS.
• Created Users and User Groups using CMC Administrator Launchpad.
• Experience installation of Business Objects service packs SP2 and higher versions BOBJ.
• Checked MDM according to the functionality and checked the data
• Involved in creating Universes with the Dimensions and Measures for standard reporting, ad hoc query, general business users and advanced business users
• Web Application Server and Web Component Adapter installed in Web Sphere Environment.
• Designed and Developed the Physical model and logical model.
• Implemented Single Sign-On in windows Active Directory Groups.
• Created Content plans for Security.
• Involved in Unit, integration, performance testing, test cases preparation

Confidential, Charlotte, NC

BO Administrator/Xcelsius Developer

Environment: Business Objects XI3 (Designer, Web Intelligence, Performance Manager, Reporter, Xcelsius), Oracle 10g, SQL, PL/SQL, Java API, JDBC, Java SDK, Informatica, TOAD, Erwin, Visio, HP Quality Center 9.2, Weblogic, UNIX

Responsibilities:

• Involved in Requirements gathering, Analysis, Designing, Technical documents preparation
• Implemented patches, performance tuning and capacity management
• Extensively worked on customer support environment to generate related reports
• Created reports on Customer orders and referrals, dealing with complaints, enquiries as well as sales promotions and new deals
• Converted Deski reports to Webi reports
• Knowledge of designing data model for Forward/Reverse Engineering using Erwin
• Installed the Business Objects components on UNIX and Windows OS.
• Web Application Server and Web Component Adapter installed in Web Sphere Environment.
• Designed and Developed the Physical model and logical model.
• Implemented Single Sign-On in windows Active Directory Groups.
• Created Content plans for Security.
• Extensively worked on WEBI reports and designed for Xcelsius Dashboards
• Created QAAS and Live Office connections
• Created Users and User Groups using CMC Administrator Launchpad.
• Experience installation of Business Objects service packs SP2 and higher versions.
• Done Unit, integration, performance testing, test cases preparation and participated in design reviews

Confidential, Austin, TX

Business Objects /Crystal Reports Admin

Environment: Business Objects XI3 (Designer, Web Intelligence, Performance Manager, Reporter, Xcelsius), Oracle 9i, SQL, PL/SQL, SQL Server management, SQL query analyzer, Crystal Reports 2009, SQL Server 2008, Java API, JDBC, TOAD, Erwin, Visio, HP Quality Center 9.2, Weblogic, UNIX

Responsibilities:

• Requirements gathering, Analysis, Designing, Technical documents preparation
• Added Row level Security to restrict data to the groups
• Created with Business Objects repositories and universes
• Managed users with Business Objects Supervisor
• Migrated documents from a development to a production environment
• Installed Apache web, Tomcat application servers and BO-SharePoint integration
• Installed, configured, and administer Business Objects server
• Upgraded Business Objects server, Cluster Business Objects servers, Installed and configured Broadcast Agent (BCA)
• Tuned the performance of Business Objects system, Perform auditing and trace logging Implemented patches, performance tuning and capacity management
• Extensively worked on production support, end user training and help doc’s development
• Unit, integration, performance testing, test cases preparation and participated in design reviews

Confidential, Moline, IL

BO Administrator/Developer

Environment: Business Objects XI3 (Designer, Desktop Intelligence, Web Intelligence, Performance Manager, Reporter, Xcelsius), SAP BI 7.0, BEx Analyzer, SAP ECC 6.0, Oracle 9i, SQL, PL/SQL, SQL server management, SQL query analyzer, DB2, Crystal Reports 2008, Crystal Enterprise 10, Teradata, Java API, JDBC, Visio, TOAD, Erwin, Weblogic, Instance Manager, Change Control, Version Control, Security Models, Citrix, SMTP, FTP, JIRA, AIX, Solaris, Weblogic, UNIX

Responsibilities:

• Involved in preparing the Change information document by coordinating with the Custom Development team, Architecture and Effort estimation, capacity planning activities
• Install and Configure Business Objects on the servers & Create Users and Users Groups.
• Providing user access to Reports, Universe between Environment
• Adding Row level Security to restrict data to the groups
• Strong logical and physical data modeling skills including ER modeling, Relational modeling concepts and implementation of * NF, * NF, * NF and BCNF.
• Installed the Business Objects XI 3.0 service packs.
• Created with Business Objects repositories and universes
• Managed users with Business Objects Supervisor
• Migrated documents from a development to a production environment
• Installed Apache web, Tomcat application servers and BO-SharePoint integration
• Installed, configured, and administer Business Objects server
• Upgraded Business Objects server, Cluster Business Objects servers, Installed and configured Broadcast Agent (BCA)
• Tuned the performance of Business Objects system, Perform auditing and trace logging
• Implemented patches, performance tuning and capacity management
• Extensively worked on customer support environment to generate related reports
• Created reports on Customer orders and referrals, dealing with complaints, enquiries as well as sales promotions and new deals
• Conducting meetings with customers to determine requirements Translate requirements into database and universe design Maintain documentation on universe and related environments Creation of ad-hoc queries and reports (Documents);
• Oracle PL/SQL coding Familiarity with Unix command line environments, esp Solaris and AIX Microsoft Office
• Expertise in data modeling using Er-win for OLTP and OLAP system.
• Knowledge of designing data model for Forward/Reverse Engineering using Erwin
• Excellent exposure to ETL architecting including incremental, full and historical load
• Installed the Business Objects components on UNIX and Windows OS.
• Created Users and User Groups using CMC Administrator Launchpad.
• Experience installation of Business Objects service packs SP2 and higher versions.
• Checked MDM according to the functionality and checked the data
• Involved in creating Universes with the Dimensions and Measures for standard reporting, ad hoc query, general business users and advanced business users
• Having good experience on Star Schemas, Snowflake Schemas, Fact tables, Dimension tables design
• Web Application Server and Web Component Adapter installed in Web Sphere Environment.
• Designed and Developed the Physical model and logical model.
• Expert in Windows 2003 Server/IIS administration, Web Infrastructure - Firewalls, WebServer and Application Servers
• Implemented Single Sign-On in windows Active Directory Groups.
• Created Content plans for Security.
• Resolve customer support issues by phone and done client support
• Created and modified the Crystal Reports for various groups using the universes and stored procedures as main data providers
• Extensively worked on production support, end user training and help doc’s development
• Identified software defects and interfaced with developers to resolve them and provided full support to the Test team.
• Taken part in Change Management (CM) meetings, Systems patching policy, pre-deployment checklist, Disaster Recovery, Clustering
• Ability to manage multiple concurrent projects and drive completion of deliverables
• Unit, integration, performance testing and Participated in design reviews, metric’s preparation

Confidential, Atlanta, GA

BO Administrator

Environment: Business Objects XIR2(CMC, Designer, Desktop Intelligence, Web Intelligence, Info View, Performance Manager, Import Wizard, Web Intelligence, BO Voyager, Xcelsius), Business Objects 6.5.1, Crystal Reports X, Crystal Reports, Oracle 10g, PL/SQL, Oracle Discoverer, Visio, TOAD, Erwin, Erwin, Instance Manager, Change Control, Version Control, Security Models, SMTP, FTP, HP Quality Center 9.0, UNIX

Responsibilities:

• Successful execution of project preparation and business blueprint phases including sign off of project charter, creation of detailed (task by task) project schedule, completion of requirements gathering workshops, creation and sign off of blueprint/design document, architecture and prototype
• Extensively worked on Customer support / Call center environment - Created reports on Customer orders and referrals, dealing with complaints, enquiries
• Requirements gathering, Analysis, Designing, Technical documents preparation, Tasks identification
• Prioritized outstanding defects and system problems, ensuring accuracy and deadlines were met.
• Performed GAP analysis of business rules, business and system process flows, user administration, and requirements and project plan tracking
• Worked in a production support role where in typical issues have been intelligently resolved.
• Created reports using SAP data source.
• Fine tuning the performance of Universe and reports.
• Design and development of universe, reports and dashboards
• Performance and data quality testing
• Migrated reports, universe, users, user groups XI R2 to XI 3.0
• Moved the data from different environments like Test and Production Environments.
• Implemented best practices for developing and optimizing reports.
• Created universes, classes and objects by retrieving the data from various data sources and defining the necessary connections.
• Executed volume and stress test to capture data for capacity planning and recommended the sizing and maintenance required for BO XIR2 repository
• Performed analysis of queries and resolved query performance problems.
• Taken part in Change Management (CM) meetings, Systems patching policy, pre-deployment checklist, Disaster Recovery, Clustering
• Extensively worked on production/client support, end user training, help doc’s creations.
• Unit, integration, performance testing, participated in design reviews and also worked on Mercury Quality Center.