Professional Summary:

• Around 7+ years of experience in Data warehousing and Business Intelligence applications using OLAP Crystal Reports XI R2/10.0/9.0/8.0, Business Objects XI R3/R2/R1/6.5/6.1/6.0/5.1, Crystal Xcelsius 2008/4.5, Designer, Info view, Desktop Intelligence, SAP BO Data service Designer (Universe Design), Web Intelligence, Import wizard, Report conversion tool, Central Management Console (CMC) and Central Configuration Manager (CCM).
• Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star Schema, Snowflake Schema, Fact and Dimension Tables, Physical and Logical data modeling usingErwin 7.2/4.0/3.5, Toad Data Modeler, Microsoft Visio.
• Experience in Information Technology, Banking/ Finance, Insurance and Health Care domains.
• Development experience using Oracle, SQL Server, Business Objects Web Intelligence, Desktop Intelligence, Designer (Universe Design), Xcelsius or Dash sap board Designer, and Crystal Reports, UNIX, Windows.
• Worked on building Universe and QAAWS for the dash sap board.
• Expertise in all phases of Software Development Life Cycle (SDLC) such as Developing, Testing, Migrating, Administrating, security management and production supporting on various platforms like UNIX, Windows NT/2000/XP/98.
• Strong experience defining and maturing the SDLC
• Knowledge of the tables and business processes of the OLTP system and experience to describe tables and determine their indexes with the ability to guess foreign key relationships based upon
• column names Query tuning skills
• Successful participation in the design, deployment and support of a complex data warehouse/data mart.
• experience in developing SAP BO Reporting tools
• Working knowledge in Java based SAP BO and Webi SDK resource
• Understanding of various BI related concepts such as ad-hoc reporting, dash sap boarding and multi-dimensional analysis
• Used SAP Business Object Dash sap boards as users to create models with an unlimited number of data sources and deploy them as standalone models to Business Intelligence platform (the "BI platform"), Business Objects Edge Series, or Net Weaver BW environments.
• Experience in implementation of complete development life cycle including Design, Develop and Deployment of SAP BusinessObjects( SAP BO) reporting tools
• Experience with one or more of the following tools: SAP BO Webi (Web- Intelligence), xCelcius, Crystal, Live office integration and Advance Analysis Office tools of which Webi is ]
• Familiarity with SAP BW architecture and experience in working with SAP BW as backend
• Experience analyzing data in source systems, documenting data requirements, process flows, data cleansing and data validation rules.
• Working knowledge of data modeling (conceptual, logical and physical) as well as database design.
• Skilled in dealing directly with customers
• SAP BOBJ experience in dash sap board/Xcelsius
• Experience in creating WebI reports on SAP BW / BEx as data source
• Familiarity with ETL and/or data modeling tools.
• Proven ability to understand client’s business intelligence requirements and create solutions addressing the current and future needs of the organization.
• ExperienceinBusiness Objects Data Integrator / Data Services.
• Experience in AUTOMATION of jobs through Management console and Creating Batch jobs. 
  • Client Side Experience.
• Proven ability to design and develop universes & reports
• Proven ability towrite/create Crystal Reports
• Strong SQL query skills, Strong Data warehousing and data migration skills.
• Experience with all modules of Business Objects and Crystal Reports tool kit and Data warehousing/modeling concepts.
• Proven Metadata Management using SAP BO SDK
• Familiarity with Teradata.
• Strong verbal and written communication skills with the demonstrated ability to develop written applications that include requirements, functional specifications, testing, application deployment plans and user guides for the developed applications.
• Quick learner and excellent team player, ability to meet tight deadlines and work under pressure, highly committed to responsibilities and result-oriented.

Technical Skills
OLAP/BI Tools : SAP Business Objects XI 4.0/3.1/XIR3, XIR2/6.x/5.x Suite (Desktop/Enterprise Server products suite), CMC, CMS, Broadcast Agent, Designer, Web Intelligence XI/6.x/2.x, Crystal Enterprise 10/9.0, Xcelsius 2008, Performance Management, Import Wizard, Business View Manager, Web Intelligence Rich Client, QaaWS, Oracle Developer 2000, Cognos 8.4 ReportNet1.x, PowerPlay Transformer 7.3.
Security : Active Directory Server, Netegrity Siteminder, Netscape LDAP Server Modeling : Erwin, Visio, Framework Manager 8.4.
ERP Modules : SAP R/3 (4.7) FICO, SD & MM.
ETL : Informatica Power Mart 8.0/4.6/5.1, SAP BODS 3.0, SAP BW 3.5,
Abinitio 1.15 & Other load utilities.
Operating Systems : Windows 98, Windows2003 and Windows NT, XP, AIX, UNIX
Database : Oracle 10g, 8i/9i, SQL Server 2008/05/00, MS-Access, DB2 V6, Sybase
IQ, Teradata V2R5.1/5.0, Siebel CRM 8.1/7.7
Languages : C, C++, HTML, XML, Java, JavaScript, Visual Basic, TOAD 10.0/ 9.6/9.0

Professional Experience:

Confidential, Camp hill, PA Jun 2011 – Till date
Sr. Business Objects Developer

Description: The Workers Compensation Automation and Integration System (WCAIS) project implements an integrated technology solution for services delivered by L&I’s three Workers’ Compensation program areas, namely Bureau of Workers’ Compensation (BWC), Workers’ Compensation Office of Adjudication (WCOA) and Workers’ Compensation Appeal sap board (WCAB). The application handles all the claim requests that are filed by injured workers, employers, insurance companies who pay the workers injured on work location. It also handles all the petitions filed by any of these parties and schedules hearings to resolve these conflicts.
Responsibilities:

• Created, maintained and enhanced Crystal Reports for an Enterprise reporting system.
• Developed parameter, cross-tab and sub reports.
• Writing stored procedures utilizing T-SQL/SQL Server 2005 and had a thorough
  understanding of Java/ SAP BO SDK, Microsoft SQL Server databases.
• Participated in requirements gathering, analysis and structured Business Intelligence platform based on user requirements.
• Run reports and performed independent validation and verification (IV&V) against data and ticket information.Documented, modified and enhanced existing Java based SAP BO and Webi SDK resource and Crystal Reports.
• Interpreted scope and delivered reports in a timely manner.
• Produced accurate technical documentation of all projects\\tasks including specifications and testing documentation.
• Ensured that developed solutions are secured, easily supported, and adhere to standard reporting best practices.
• Worked with the Data Management team (Business Analyst and Business Objects Developers) to gather, analyze, and docu
• ment business requirements, functional requirements, and data specifications for Business Objects universes and reports.
• Developed Business Objects Universe, Webi/Deski and Crystal Report Development , ensured defining and maturing the SDLC
• partnering with sap both business and IT management
• Supported business power users and application developers in the creation of Web Intelligence reports, Crystal Reports and Live Office reports.
• Worked with internal business customers to analyze information requirements needed to support business processes and business goal achievement and work with other IT team members to deliver targeted solutions.
• Troubleshooted report issues, researches data quality problems and reconciles information between systems as needed.
• Provided end user support as assigned through Work Order system.
• Followed all prescribed standards as defined by client Information Technology Team.
• Supported the end-to-end reporting process.
• Documented business definitions of data and conducting end user training.
• Familiarity with project management, portfolio management, and resource management processes.
• Analyzed user-developed reports for compliance with reporting standards and develop recommendations to tune queries or otherwise optimize report design.
• Involved in the full software development life cycle.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications a sap bout the financial system for Business Objects Universes and Reports.

Environment: Crystal Reports, SQL Server 2005, Business Objects XI R3/R2 Suite (Desktop Intelligence, Central Management Server, Central Management Console, Import Wizard), Business Objects 6.5.1, Supervisor, Reporter, Web I, MS Access 2000, Windows 2003 server/XP, UNIX.

Confidential, Pittsburgh, PA Mar 2009 – May 2011
Sr. Business Objects Analyst

Description:Confidentialis a research-based, global Pharmaceutical Company involved in discovery and development of innovative medicines. Spectrum is involved in pioneering developments in pharmaceuticals and biotechnology. The Project includes creation of Business Intelligence application to monitor the sales of the various products by region and analyze historic data from the EDW (Enterprise Data Warehouse).
Responsibilities:

• Participated in requirements gathering, analysis and structured Business Intelligence platform based on user requirements.
• Migrated Business Objects XI R2 version reports to Business Objects XI R3 with proper pre and post migration plans.
• Worked with the Data Management team (Business Analyst and Business Objects Developers) to gather, analyze, and document business requirements, functional requirements, and data specifications for Business Objects universes and reports.
• Supported business power users and application developers in the creation of Universes, Web Intelligence reports, Crystal Reports, Xcelsius dash sap boards, and Live Office reports.
• Worked with internal business customers to analyze information requirements needed to support business processes and business goal achievement and work with other IT team members to deliver targeted solutions.
• Created and modified Universes, including classes (subclasses), objects, prompts, and predefined conditions and user defined objects for custom hierarchies.
• Troubleshooted report issues, researches data quality problems and reconciles information between systems as needed.
• Researched and presented information/data regarding how other companies in the clients industry are using specific application products to improve business performance (Business).
• Managed client expectations and balances the needs of the company and the client to ensure satisfaction for sap both (Relationship Management).
• Administered SAP BOBJ Security settings and setting up user, user groups and application security.
• Worked on Promoting, migrating and upgrading content between multiple Business Objects environments.
• Acquired extensive Universe Design experience - OLAP and relational databases.
• Experienced designing /building using Crystal.
• Supported the end-to-end reporting process.
• Documented business definitions of data and conducting end user training.
• Familiarity with project management, portfolio management, and resource management processes.
• Analyzed user-developed reports for compliance with reporting standards and develop recommendations to tune queries or otherwise optimize report design.
• Involved in the full software development life cycle.
• Migrated several reports/universes from SAP BO XIR2 to XIR3 using Import Wizard and converted them to WEBI reports using Report Conversion tool.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications a sap bout the financial system for Business Objects Universes and Reports.

Environment: Business Objects XI R3/R2 Suite (Desktop Intelligence, Central Management Server, Central Management Console, Import Wizard), Business Objects 6.5.1, Supervisor, Xcelsius, Designer, Reporter, Unit Test, Crystal Report, Web I, BCA, Oracle 10g, MS Access 2000, Windows 2003 server/XP, UNIX.

Confidential, Chicago, IL Feb 2008 – Mar 2009 
Sr.Business Objects Consultant

Description:Confidential provides full-service retail and commercial banking operations regionally and nationally. This project includes developing data warehouse to understand customer behavior to market programs and identify critical customers in support of improved decision-making across the organizations and development of reports for the management. 

Responsibilities:

• Installed and configured the Business Objects environments for sap both development and production.
• Involved in Migrating Business Objects system from version Business Objects XI to Business Objects XI R2.
• Involved in developing, testing and implementing new PL/SQL packages, functions, Triggers and stored procedures.
• Scheduled reports through Broadcast Agent for automation on timely fashion.
• Created new reports after gathering the requirements from business user or modifying the existing ones using Business Objects XI R2.
• Analyzed SQL code to ensure Business Objects queries to correct data from the database.
• Created Web Intelligence documents and published them to corporate documents to share the resources between the user communities.
• Trained the end users in working with the Business Objects user module and provided technical expertise.
• Involved in installation of Business Objects version XIR2.
• Migrated content from legacy reporting system to Business Objects platform and extensively used report conversion tool for report conversion.
• Created the Audits for Failed and Partly Converted Reports during the Conversion of Web Intelligence Reports.
• Used Business Objects XIR3 extensively and Involved in Full SDLC (software development life cycle) rules are followed for designing new components.
• Interacted with Business Users to understand their Business needs to effectively develop and modify Universes and Reports. Worked on Linked Universes by kernel approach.
• Worked on various Data Integrator jobs to change the current mapping of the existing tables or adding new table in the database creating data flow for them.
• Performed integrity testing of the Universes (Universe Structure checking, Object parsing, Joins parsing, Conditions parsing, Cardinalities checking, Loops checking and Contexts checking) after any modifications to them in terms of structure, classes, and objects.

Environment: Business Objects XI / XIR2 (CMC, Designer, Desktop Intelligence, Web Intelligence Rich Client, Info View, Voyager), BW, Java SDK, SSIS, Crystal Reports XI, Windows NT, Oracle 10g.

Confidential, Hartford, CT Feb 2007 – Jan 2008 
Business Objects/ Crystal Reports Developer

Description:The project was developed for Auto Insurance. The project was divided into various phases, which included creating and modifying the database, designing the business intelligence systems, which included designing universes, report development phase. Reports were developed to help the agents to calculate monthly insurance for the cars and the revenues generated.

Responsibilities:

• Interacted with Business Owners to know their Business views in creating/modifying Reports accordingly.
• Developed reports using Crystal Reports 10 Various Report Formats developed include Sub Reports, Cross Tab Reports, Standard Reports, OLAP Reports, and Master/Detail Reports and also developed reports in MS Access and Excel.
• Extensively worked on Data Warehousing Design Methodology, Data Warehouse Concepts.
• Gained experience in designing, implementing, distributing and maintaining Universes.
• Assisted clients to provide reporting solution and develop/maintain universes against their R/3 warehouse using WebI, Business Objects and Designer.
• Analyzed the reporting requirements with the business users and come up with the technical specifications.
• Developed various canned Reports that involved use of Prompts, Customized LOVs, Multiple data providers, Master/Detail, Alerts, Cross tab, filters and variables.
• Supported and lead developers in creating reports using Universe, Stored Procedures and Excel files as Data Sources.
• Initiated DBA interactions for resource requirements and modifications.
• Modified the universe, created classes and objects by retrieving the data from various data sources.
• Worked on Business Objects Reporting and analysis functionalities such as Filters, Ranking, Sections, Sorts, Master Detail Reports, Slice and Dice, Drilling methodology, Cross Tabs and Charts.
• Created Customized Lov’s (List of Values) in the Universe Dimension Objects.
• Checked the integrity of the Universe.
• Resolved loops using contexts and aliases to remove the cyclic dependencies.

Environment: Business Objects 6.5.1(Supervisor, Designer, Reporter), WebI, Crystal Report, BCA, DB2, MS Access, Windows 2000 Server, Unix, Oracle 9i, SQL*Plus, PL/SQL, TOAD, Tkprof, Erwin 3.1.

Confidential, Dallas, TX Apr 2006 – Jan 2007
Business Objects Developer

Description: Confidential is one of the leading Airline Ticketing Companies in US. The project deals with the Sales & Marketing Data collected from various sources. The System was primarily designed to provide canned reports for our Performance Analysts who could use the Daily Operational Reports to investigate discrepancies, thereby creating a streamlined and efficient process.

Responsibilities:

• Worked closely with Business Analysts to produce reports based on the requirements.
• Converted high-level design specifications to detailed functional and technical specifications.
• Worked on creatingUniversesusing the Business Objects Designer and connected to the database using ODBC.
• Created queries for multidimensional analysis using Slice and Dice, Drill Down, Drill ByandDrill Through.
• Submitted and presented the reports in user-defined formats likeTabular, Master Detail,andCross Tab.
• Upgraded Business Objects Universes, User groups, and reports from Version 5x to 6x.
• Made the Reports user friendly by implementing user prompts, conditions and filters.
• Created the Repository structure to manage the security and deployment options throughout the installation.
• Performed release management of Business Objects reports using Broadcast Agent Server.
• Created Add-Ins and Macro\'s based on the end users requirement using SAP BO SDK.
• Customized the user interface using Web Intelligence SDK and ASP.
• Designed, tuned and optimized the Star Schema to implement core database.
• Scheduled and monitored different session of loading data using Power Mart Server Manager.
• Trained end users in basic and advanced ad hoc reporting skill.

Environment:Business Objects 5.x, 6.x, SAP BO (Designer, Business Objects, BCA), ERWIN, MS SQL Server, Windows NT.

Confidential May 2004 – Mar 2006
Programmer Analyst

Description:Confidential was the first Indian Bank to open a branch outside the country. Confidential has been in the forefront of introducing various innovative services and systems. Business has been conducted with the successful blend of traditional values and ethics and the most modern infrastructure.

Responsibilities:

• Conducted user interview to gather requirements.
• Designed, Developed new universe and maintained existing universes.
• Developed and maintained very complex reports consisting of several data providers, variables and tabs within the document.
• Migrated reports from Development to UAT and to Production.
• Setting up users and groups in Supervisor for all environments.
• Optimization of complex Reports/SQL, which has more than 40 Data providers.
• Resolved performance issues on Web Intelligence Server.
• Resolved API Errors on Web Intelligence Servers.

Environment: Business Objects 5.1.2,Oracle 8i, PL/SQL, Sybase, DB2, Oracle Forms 6i, Reports 6i,jsp, structs, HTML, XML, Windows NT