SUMMARY:

• Overall 14+ years of experience in IT and around 7+ years solid Expertise in Creating Complex Reports using SAP Business Objects Tools. Excellent data - analysis skills and ability to translate specifications into a working universe and/or report.
• Worked on different versions of Business Objects BO 6.x/XI R2/XI 3.1/XI 4.0
• Worked on Desktop Intelligence, Web Intelligence(webi), SAP BO Analysis for Office Edition, SAP BO for OLAP Edition, Universe Designer Tool(UDT), Information Design Tool(IDT).
• Expertise in planning, designing, developing, distributing and maintaining Universes.
• Worked on both SAP & Non-SAP backend.
• Creating complex query reports using Oracle, SQL server, MS Access and various RDBMS.
• Very strong in Client/Server Architecture, Relational Databases (RDBMS), Data Modeling and Design and build the Data Warehouse, Data marts using Star Schema and Snow Flake Schema for faster and effective Querying for the Metadata Management solutions
• Created complex Ad-hoc reports using Business Objects and Web Intelligence tools.
• Worked with Business Users to analyze the business process and made necessary changes to schema objects to cater their reporting needs.
• Hands on experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions, packages.
• Created users & groups using Central Management Console(CMC)
• Involved in Full life cycle (analysis, design, networking, design, development and deployment) of Business Objects reporting Applications with Web Intelligence
• Experience in creating Regulatory, Customized, Ad hoc and canned reports using Business Objects.
• Experience in Business Objects Administration and building universes, Retrieving Data using Universes, Personal data files (MS-Excel), stored procedures and Free hand SQL methods.
• Knowledge on Migration from one version to another.
• Excellent team player at all levels with ability to perform independently with exceptional communication, analytical, presentation and problem solving skills. strong reporting skills with MS Access, MS Excel, SQL Server, Oracle PL/SQL, Crystal Reports to meet report auditing requirements.
• Experience in designs security levels for groups and individuals. Creates role types and user accounts.
• Experience in office management, client database, client paper files, paperless office systems, inventory, production control, maintenance scheduling, customer service and billing.
• Management skills and techniques.
• Practice consistent follow-up procedures. Work well with co-workers even under the duress of Stressful job requirements and short deadlines. Consistently complete projects on or under time and budget.
• Progressive development of excellent communication and verbal skills for client presentation and concept interpretation.
• Experienced in observing and analyzing current data capturing and reporting methods and further automating and streamlining the process.
• Can proactively and intuitively gather business requirements and determine business needs for data gathering and presentation.
• Experience with UDB, EEE, Net Commerce and IBM’s Websphere Studio environment.
• Experience in administering DB2 version 5, 6.2 and 7.1, Oracle, SQL server, MS ACCESS and 2000 databases.
• Experience in SQL queries, and developing Triggers.
• Experience in performance and tuning.
• Experience in application driven data modeling and database design.
• Knowledge and experience in project content and organization.
• Knowledge and experience in Oracle8I.
• Demonstrated high performance standards, including attention to deadlines, quality of work, detail oriented.
• Implementation of logical and physical databases; experience with online transaction processing.

TECHNICAL SKILLS:

BOBJ Versions: Business Objects 6.x/XI R2/3.1/4.0 SP5

BOBJ Client Tools:, Desktop Intelligence, Web Intelligence, Crystal Reports 2008, Xcelsius 2008, BO Analysis MS edition, SAP BO Analysis for OLAP Edition, Information Design Tool(IDT),QAAWS, LiveOffice,QlikView

Administration: CMC (Central Management Console)

ERP: SAP BI

Operating System: AIX 5.3/LINUX, Windows NT/ 2000/2003/2008 Server

Database: Oracle 9.x/10g/11g, SQL Server 7.0/2000, Netezza, MS Access

Languages: Visual Basic, .NET, C/C++, SQL, and PL/SQL

WebTechnologies: ASP, HTML, DHTML, JavaScript, and VBScript

Web/Application Servers: IIS, Apache v2, Tomcat 4.1, IBM Websphere, Weblogic 10

PROFESSIONAL EXPERIENCE:

Confidential

Sr.Report Developer

Responsibilities:

• Interacted with Business Users to know their Business needs to effectively develop and modify Universes and Reports.
• Prepared Business/Technical Requirements, Design Templates, Development Standards document and Detailed Design documents
• I worked on different versions of BO 6.5/XI R2/XI 3.1/XI4.0
• I was involved in Migration of all previous versions of Business Objects
• Created Webi Reports on SAP BW Queries Using BICS Connectivity for Finance, Sales, Procurement and Supply Chain Management.
• Performed data validation by creating ad hoc reports.
• Worked with SAP to resolve BO/BW issues
• Created Analysis reports using SAP BO Analysis for MS Office Edition, using BICS Connection
• Performed End to End Scenario getting the data from SAP BW and creating universe, building Reports and Created Dashboards using Xcelsius.
• Involved in gathering, analyzing, documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Migrated Business Objects XI R2 content in to Business Objects XI 3.1 environment using the Import Wizard.
• Designed and developed Universes and reports according to the user requirements.
• Used Designer to create Universes and resolve loops utilizing contexts and Alias Tables.
• Developed Complex Reports that involved multiple data providers, Master/Detail charts, cross tab, bar charts, pie charts, complex variables and calculation contexts.
• Created Prompts, Conditions and Filters to improve the report generation. Also used Alerts to improve the readability of the report.
• Scheduled Business Objects Documents and Metrics for automatic refresh and to different destinations.
• Created Analytics and Dashboards using Performance Management tools to enable executives get a bird’s eye view of the business performance
• Created access Restrictions to secure data based on users’ access levels.
• Created reports using Business Objects functionalities like Slice and Dice, Drill up/down, Cross Tab, Master/Detail, Formulas and variables etc. Generated pictorial views in the form of 2D, 3D & Pie Charts from existing Reports and Chart Wizard etc
• Extensively used Calculation contexts, Variables, Drill down, Slice and Dice, Breaks, Sections, Ranks and Alerts in the creation of reports.
• Created Drill-Through Reports to provide users with more detailed information and query linking.
• Accessing data from the database to cross check the data accuracy and creating reports on the same if needed by business
• Implemented and given session to train Power Users/Managers in BO functionality and to use the reports in Web Intelligence.
• Provided extensive support for the users on application usage and trained users in the functionality of the software.
• Documented all the changes made to the Universes and Reports for future s.
• I have very strong reporting skills with SQL SERVER, MS Access, MS Excel, and Oracle PL/SQL’.
• Expert in SAP BO Reporting Tools to meet reporting requirements. I am seasoned professional, with outstanding project planning, execution, monitoring and resource balancing skills with ability to support multiple simultaneous projects in a matrix organizational structure Excel at communicating with stakeholders to provide accurate reporting and information regarding the ongoing projects and initiatives.
• During my tenure, defined Reporting Standards and naming conventions.

Confidential

Sr. Database Administrator

Responsibilities:

• Installation of UDB server, front-end tools like Control center, Command line processor, Script Center, Alert Center and DB2 Database Directories. Also included setting up of DB2 user accounts and password, Database and instance Creation, Database Space management, table partitioning, distributing the tables, redo logs, archived redo logs, and rollback segments on different disks to optimize the data retrieval.
• Performance tuning & monitoring of the applications.
• Backup and Recovery, monitoring data replication with snapshots and conflict resolution and establishing Client server connectivity. Run daily runstat and reorg on tables.
• Setting up of replication Environments.
• Establishing Connectivity between remote Databases.
• Creation of Databases, tablespaces, bufferpools, tables, and triggers.
• Creation o production Database Recovery Procedures with fully documented.
• Creation of scripts, which performs the maintenance, functions such as Runstats, Reorgcheck, Reorg, Backup, and Bind applications after Reorg.
• Experience as DB2 Application DBA, with responsibilities like upgrade, migration, implementation, maintenance, general administration, and performance tuning of DB2 and other 3rd party tools.