Summary

• More Than 8 years of experience in analysis, Design, development, Testing and implementation of Data warehouse (Business Objects/Crystal Reports Reporting Tools).
• Good Experience in the field of Business Intelligence tools using Business Objects XI Enterprise suite using Desktop Intelligence, Designer, Web Intelligence reporting.
• Expertise in working with all the modules of Business Objects like Supervisor, Designer, BO User, BO Reporter, Web Intelligence , Desktop Intelligence, Info view, Data Integrator, Broadcast Agent ,Auditor, EPM, Zero Admin BO(ZABO),Import Wizard, Report Conversion, Report Bursting, Migration from 6.5.1 to BOXI R2, Xcelsius, Live Office. CMC and Crystal Reports XI.
• Hands on experience with Crystal Xcelsius in developing Dash Boards and Scorecards.
• Experience in creating customized and Complex Reports using Business Objects. Worked on projects involving SAP to BO interface, Data Stage to BO interface and Informatica to BO interface.
• Involved in testing universe and reports for correct mapping of the objects and data correctness. Did performance tuning for efficient report generation.
• Strong experience in Data Warehousing projects and familiar with all areas of Data Warehouse like Reporting and ETL.
• Proficient in gathering the business requirements and creating source to target Mappings.
• Good Knowledge in using Data Stage 7.5, Informatica Power Center.
• Proficient in creating stored procedures using PL/SQL for ETL Process.
• Good Knowledge in tuning the performance of SQL queries and ETL Process.
• Developing complex queries using SQL, PL/SQL.
• Knowledge in writing UNIX Shell Scripts.
• Understanding the business rules and creating reports according to user's requirements.

Education: B.S in Electrical Engineering

Post Graduate Diploma in computer Science (PGDCS)

Skills:

Oracle 8i/9i/10g, MS SQL Server 2000/2005, DB2, MS Access, Sybase 11.x, Business Objects 5.1/6.5/XI, Crystal Reports 10/XI, TOAD, SQL, PL/SQL, SQL*LOADER, IMPOERT/EXPORT, Informatica Power Center 5.1/6.2/7.1, Power Mart 4.7/5.0, Data Stage 6.x,JD Edwards One world, Erwin, Developer/2000, Unix Shell Scripting, Perl, HTML, XML, Autosys, Unix Cron, Windows Server 2003/200, Unix ( AIX, Sun Solaris and HP-UX).

Confidential, Sep 2006 - Till Date
Syracuse, NY

Job Title: Senior Data Warehousing Designer.

Software Environment:Oracle 9i/10g, Sybase, MS Access, UNIX Shell Script, Business Objects 6.x/XI R2/ R3, Data Stage 7.5, Windows 2000, UNIX Sun Solaris. Business Objects XI R3 Suite (Desktop Intelligence, Central Management Server, Central Management Console, Auditor, Import Wizard, Universe Designer, Dashboard Manager, Xcelsius,Live Office).

Responsibilities and Achievements:

• Extensively involved in requirements gathering, Analysis, Design, Coding, Development, Testing and Deployment.
• Supporting BO Reporting Infrastructure, Interacting with the client and solving the Clients Issues.
• Work with clients on designing entire business sub processes essential to overall functionality proto-typing.
• Designed complex universes by using advanced features like aggregate awareness and prompts.
• Developed critical reports and tested universes and reports for user acceptance, written many queries.
• Created reports like financial reports, HR reports, canned and ad-hoc reports, and universes.
• Created users and assigned roles to the users, maintained scheduling the documents by using the CMC.
• Converted Desktop Intelligence Reports to Web Intelligence using Report Conversion Tool.
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
• Created webi reports and deployed reports on Web Intelligence and intensively worked on report and performance activities.
• Involved in day to day business objects administration activities by using CMC.
• Closely worked with the team during the upgrade of the Business Objects and migration of old version components to the new version.
• Worked on conversion projects from MS Access reports and IBM Mainframe Focus reports and Actuate reports to Business Objects reports (Including universe design). During this phase closely worked with end users and gathered all the requirements and created Functional and Technical design document.
• Created linked sub reports (regular and On-demand) as well as unlinked Sub-Reports along with the primary reports.
• Created Dashboards for Managers by using the dashboard manager with application functions such as metrics, which prompt alerts which plants products are selling faster than expected.
• Involved in Xcelsius dashboard design and development.
• Responsible for User Acceptance, Functionality Tests to ensure successful integration with existing products.
• Created defect analysis report for Regression Test and UAT bugs.
• Involved in Coding and testing, writing stored procedures and database triggers as well as in development of common sub routines.
• Involved in SQL queries performance issues to reduce the execution time in Oracle database.
• Involved in Business Objects Production Support and Data Integration support.

Confidential, Aug 2005 - Sep 2006
Sanjose, CA

Job Title: Consultant.

Software Environment:Business Objects 6.5/5.1, web Intelligence 6.5/2.5, Broadcast Agent, Dashboard Manager, Oracle 9i,
TOAD, PL/SQL, Windows 2003, HP-UX.

Responsibilities and Achievements:

• Design, developed and tested the reports based upon data generated by enterprise transaction, Email Marketing, Purchase, Inventory and Order information systems using Business Objects 6.5.1. Connected to multiple Oracle 9i data sources.
• Worked with end-users from requirements gathering, development and testing phases.
• Created and Developed Stored Procedures and Packages for Oracle 9i Database using PL/SQL.
• Involved in the design and building of Universe, Classes and Objects (MARS Universe - Partner Data Information).
• Modified existing Universes with pre-calculated aggregates from summary tables.
• Exported the universes to the repository to making resources available to the users.
• Created test plans for various Portfolios using the Universes as the main Data Providers.
• Created the reports using Business Objects functionality's like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae's etc.
• Setup groups and users for Business Objects deployment. Managed user profiles using Supervisor.
• Created Business Objects Repository while building Business Objects solution.
• Created, Managed and formatted standard reports, master/detail reports and cross tab reports using Report Manager.
• Given Upgrade and production support for Business Objects 6.5.1 (Trouble shooting report errors, performance Issues).
• Created user documentation for universe and also created upgrade procedure documentation.
• Given end user training and preparing power point presentation to educate end users.

Confidential, Jan 2005 - July 2005
Milpitas, CA

Job Title: System Analyst.

Software Environment:Business Objects 6.5/5.1, web Intelligence 6.5/2.5, Broadcast Agent, Dashboard Manager, Oracle 9i,
TOAD, PL/SQL, Windows 2003.

Responsibilities and Achievements:

• Designed, developed and tested the reports based upon data generated by enterprise transaction, financial and customer information systems using Business Objects 6.1a connected to multiple Oracle 9i and MS SQL Server 2000 data sources.
• Involved in the designing and Building of Universes, Classes and Objects.
• Created Cardinalities, Contexts, Joins and Aliases for resolving loops and checked the Integrity of the Universes.
• Exported the universes to Repository to making resources available to the users.
• Worked on conversion of existing MS Access and Actuate reports to business objects. Involved in creating the technical design document by interacting with the users. By going through the existing reports logic and converted into business objects universe logic and constructed business objects reports on top of that.
• Created reports for various Portfolios using the Universes as the main Data Providers.
• Created the reports using Business Objects functionality's like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and formulae's etc.
• Created Schedulers to monitor Broadcast Agent.
• Created Full client and webi reports. Provided OLAP functionality and worked extensively with data warehousing.

Confidential, Feb 2003 - Dec 2004
Racine, WI

Job Title: Programmer Analyst.

Software Environment:Informatica 6.x/7.x, Business Objects 5.x, Broadcast Agent, Publisher, Web Intelligence 2.6, Reporter, Info view, Crystal Reports, SQL Server, PL/SQL, Oracle 8i, Windows NT.

Responsibilities and Achievements:

• Involved in loading the data from Source Tables like Oracle 8i and
• SQL Server 2000 to ODS (Operational Data Source) Tables using Transformation and Cleansing Logic using Informatica.
• Designed and maintained logical and physical enterprise data warehouse schemas using Erwin.
• Forward and reverse engineering using Erwin data model.
• Configuration of Informatica repository to connect to database through ODBC.
• Design and developed complex aggregate, join, look up transformation rules ( Business Rules) to generate consolidated (fact/summary) data identification by dimensions using Informatica ETL (Power Center ) Tool.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository manager.
• Created sessions, database connections and batches using Informatica Server Manager.
• Used trigger files to run the batches as per the specified time
• Generated PL/SQL reporting and Unix scripts to notify process failure/success using Informatica repository.
• Integrated with End-Users and Business Analysts to identify requirements and responsible for solutions.
• Involved in Installation, Configuration of Business Objects modules.
• Created/Designed Universes for reporting using the Business Objects Designer.
• Created complex reports, Sub Reports and Drill through Reports used to show details from the cubes created shell scripts to manipulate Oracle data.
• Formatted the reports to the Users requirements using all the requirements in Business Objects like slice and dice, Drill Down, @Functions and Formulas etc.
• Used universe, stored procedure and personal data files as source for the Business Objects querying, analysis and reporting.
• Designed and developed extensive Business Objects reports, including complex reports using multiple queries, combination chart and tables, setting up Business Objects Universe for each reporting group and assisted in establishing a Business Objects environment.
• Helped in development of VB modules and Publishing complex reports on webi.

Confidential, Feb 2002 - Jan 2003, NOIDA, INDIA
System analyst

Software Environment:Informatica Power Center 5.1, Oracle 8.x, SQL Server 7.0, Business Objects 5.1, Crystal Reports 9,Web Intelligence 2.5.4, Unix, Windows NT.

Responsibilities:

• Involved in Data Warehouse development, maintenance and support for the Sales Department.
• Worked with Power Center Designer tool to develop mappings and mapplets to extract, transform and load the data from flat files and Oracle sources to Oracle Targets.
• Developed Workflows for mappings using workflow Manager to load data from source flat files and RDBMS table to target tables.
• Created different transformations to load data into targets using various transformations like Source Qualifier, Joiner, Lookup, Rank, Expression, Aggregator, Sequence Generator etc.
• Used copy/paste functions to reuse mappings to use in multiple mappings.
• Implemented performance tuning logic on targets, sources, mappings and sessions to provide maximum efficiency and performance.
• Scheduled Sessions and Batches on the Informatica Server using Informatica Server Manager/Workflow Manager.
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Analysis of database, requirement gathering, designing and development of Universe in Business Objects based on the data warehouse on Sales and Orders module.
• Developing complex universe by using advanced features like aggregate awareness and prompts.
• Developed critical reports and tested universes and reports for user acceptance, written many queries.

Confidential
NOIDA, INDIA Feb 1999 - Jan 2002

Job Title: Programmer

Responsibilities:

• Worked on maintenance of a Payroll, Marketing and Material Management Systems and managing data processing activities and system development.
• Modules of master maintenance, bill of materials, material requirement planning, purchase order, receiving report, internal transactions and reports.
• System analysis, design, coding, testing and implementation.
• Coding of programs for Marketing Information System. Modules of order dispatch and report namely orders, pending orders, dispatch details, invoices, outstanding statements, target Vs actual sales.
• Coding of programs for payroll and personnel information system.
• Coding of programs for Material Management System.