PROFESSIONAL SUMMARY

• 10 Years of experience in the field of Information Technology with an emphasis on Business Intelligence concepts like Data Reporting, Data Analysis, Design, Development, Data Migration, Implementation and Testing of Database/ Data Warehousing applications using Data Modeling, ETL and Reporting tools.
• Expertise in SAP Business Objects Enterprise products Universe Designer, InfoView, Web Intelligence, Desktop Intelligence, Supervisor, Broadcast Agent, Central Management Console, Central Management Server, Crystal Reports and ZABO installation
• Worked on various development platforms Windows NT 4.0/2000/98/95 and RDBMS like Oracle 10g/9i/8.x/7.x, SQL Server 2005/2008.
• Managed and delivered large and complex assignments within time/cost and service level parameters.
• Experience in building Business Objects Universes, Free Hand SQL methods and creating complex canned and ad-hoc reports using SAP Business Objects reporting application like Web Intelligence / Desktop Intelligence
• Strong expertise in creating reports using the Business objects functionalities like Prompts, Hierarchies, Slice and Dice, Drill Mode, Filtering. Have working experience with Static, Dynamic and Cascading prompts accompanied with a good grasp on sub-reports, Cross Tab Reports and Reports with Charts.
• Experience designing universes SAP Business Objects XI R2/R3/3.1 using Designer
• Working experience of Oracle/SQL Server/MS-Access and strong SQL skills.
• Used CMC Central Management Console for user management, content management, and server management tasks and CCM Central Configuration Manager to manage local and remote servers.
• Proficient in translating report requirements into detailed report specifications, confirm report design with business users and creating reports using SAP Business Objects XI R2/R3, 6.5.1
• Experience in migration of Business objects 6.5. To XI R2 using Import Wizard and worked with business groups in migrating Universes, Deski/Webi reports.
• Good knowledge of Xcelsius Dashboard concepts using 2008/4.5 / SAP Business Objects XI 3.0 / 3.1
• Good understanding of Star Schema, Snowflake modeling for Business Objects Universe from Dimensional data mart / data warehouse.
• Good working experience with SQL Server 2005/2008, SSIS SQL Server Integration Services , SSRS SQL Server Reporting Services
• Possess SharePoint knowledge, up-down loading and maintaining documents on shared site.
• Prioritizing delivery of multiple reporting requests to internal and external requestors
• Extensive experience interacting with Functional Business Analyst, Department Managers and different levels of users and developers. Involved in Business and functional requirement gatherings with the business for various projects.
• Excellent communication interpersonal and analytical skills to bridge Client Interaction and Team Management. Has a strong ability to perform as part of a team.

TECHNICAL SKILLS STRENGTHS

BI Tools: SAP Business Objects XI 4.0, BOXI 3.1, BO 6.5.1 CMC, CCM, Designer, Reporter, Desktop Intelligence, Supervisor, Web Intelligence, Broadcast Agent, Info View , Crystal Reports XI, Cognos 8.4 Query Studio, Report Studio ,

Xcelsius 2008/4.5 Dashboard

Databases: Oracle 11g/10g/9i/8i/8.0, SQL Server 2005/2008, MS Access 98/2000/2003.

Applications IDE: Business Intelligence Development Studio, MS Office

Languages: Visual Basic 5.0/6.0, SQL, PL/SQL, SQL Loader, T-SQL, Toad 9.1

ETL Tools: BODS Business Objects Data Services, DTS, Informatica Power Centre, MS- SSIS

Data Modeling Tools: ERWin 4.0

Platforms: MS Windows 2000/NT/98/XP, Windows 2000/2003/2007 Server, UNIX.

WORK EXPERIENCE

Confidential

Sr. Business Objects Developer

Work Description:

• Provide support to end users in creating new Webi based reports. Used functionalities like drill down, breaks, sorting, filtering, alerters and sections. Reports were based off multiple data providers
• Support users with enhancements/improvements to the existing fleet of Webi reports
• Created reports containing several blocks and graphs in the same tab in either tabular or cross-tab layouts
• Worked with ETL team to develop/enhance the new/existing mappings to develop processes based on user needs.
• Tuned reports to optimize the run-time by adding indexes to the table structures or by breaking the standard data provider into multiple sets.
• Interacted with Business Users in gathering requirements for new reports and enhancements
• Documented the requirements and published it into the TPM portal
• Interact with business users to analyze and resolve data and application issues
• Modified existing reports developed in Crystal Reports XI as per the user requirement and migrated to Crystal Reports Enterprise.
• Enhanced existing reports with parameters, sub-reports by using Crystal Reports XI.
• Installed Crystal Enterprise and Published reports on Crystal Enterprise Server and got involved in Crystal Enterprise administration.
• Experience in Scheduling the Reports using Crystal Enterprise solution.
• Published Reports in Crystal Enterprise via Crystal Publishing Wizard and Crystal Management Console.

Environment: Windows 7, Oracle 11g, SAP Business Objects XI 4.0 CMC, UDT, Webi Rich Client, InfoView , Business Objects Data Services, Crystal Reports XI.

Confidential

Sr. Business Objects Developer

Work Description:

• Built 2 universes as per business specifications by leveraging the DW tables for canned and ad hoc reporting needs for the Sales/Order Management and Cost Management team.
• Defined Cardinalities and created Aliases and Contexts for resolving Loops in the universe. Used BO functions like Prompt, Select, Variable and Where using IDT tool. Performed Check Integrity checks before migrating universes.
• Created Web Intelligence reports using Webi Rich Client. Used functionalities like slice and dice, drill down, breaks, sorting, filtering, alerters, and sections.
• Created complex reports containing several blocks in the same document with multiple tabs, and graphs. Reports were displayed in either tabular or cross-tab layouts.
• Created Webi reports with multiple data providers.
• Supported the existing fleet of Deski/Webi reports for enhancements and improvements.
• Interacted extensively with the ETL team to develop/modify processes based on the reporting needs of the users.
• Tuned reports to optimize the run-time by adding indexes to the table structures or by breaking the standard data provider into multiple sets.
• Interacted with Business Users in gathering requirements for new reports and enhancements
• Documented the requirements and created functional design documents
• Interact with business users to analyze and resolve data and application issues
• Worked with the Oracle apps team in understanding the underlying data that acts as a source to the Data warehouse

Environment: Windows 7, Oracle 11g, SAP Business Objects XI 4.0 CMC, UDT, IDT, Webi Rich Client, InfoView , Xcelsius 2008, Toad, Business Objects Data Services.

Confidential

Sr. Business Objects Developer/Business Systems Analyst

Work Description:

• Built universes as per business specifications by leveraging the Datamart tables for canned and ad hoc reporting needs for the financial compliance team FCT stakeholders and users.
• Created Aliases and Contexts for resolving Loops and defined Cardinalities in the universe and have embedded several BO functions like Prompt, Aggregate Aware, Select, and Where using Designer tool. Performed Check Integrity on new and existing universes before migration.
• Created Web Intelligence reports using Webi Rich Client. Used functionalities like slice and dice, drill down, breaks, sorting, filtering, alerters, and sections.
• Created complex reports containing statistical TPV data with multiple tabs, and graphs. Reports were displayed in either chart, tabular or cross-tab layouts.
• Created Webi reports with multiple data providers.
• Supported the existing fleet of Deski/Webi reports for enhancements and improvements.
• Created Dynamic customizable data visualization dashboards as POC using Xcelsius 2008. Used QaaWS as data source and embedded Webi reports into the Dashboards.
• Interacted extensively with the ETL team to develop/modify the existing Datamart structure for reporting needs and to improve run-time of the reports by adding indexes and hints.
• Interacted with Business Users and BSAs in gathering requirements for new reports and extracts
• Worked directly with functional analysts and business users in understanding their needs of the business in developing BI functionalities or tools to meet their objectives/requirements
• Lead a team of developers and testers in supporting the day-to-day enhancements and new developments
• Worked as SME to roll out the finished product i.e., reports/applications to the business users as part of new initiatives, projects and product launches
• Interact with business users to analyze and resolve data and application issues
• Worked with third party vendors TPV in resolving the data relate issues.
• Support the business users with their operational needs providing data extracts, trouble shooting reporting issues and providing access to the Datamart
• Support existing data warehouse reporting platform SAP Business Objects XI and IBM Cognos 8.4 and applications to ensure operational availability and scalability

Environment: Windows XP, Windows 7, Oracle 11g, SAP Business Objects XI R3 CMC, CMS, Designer, Desktop Intelligence, Web Intelligence , SQL Toad, Informatica PowerCenter, SQL Loader, SQL Server 2008, SQL Server Integration Services, UNIX Scripting, Cognos 8.4 Query Studio, Report Studio and Analytical Studio .

Confidential

Sr. Business Objects Developer/Sr.Systems Analyst

Work Description:

• Built universes as per user requirements by identifying the required tables from Data warehouse and by defining universe connections.
• Created Aliases and Contexts for resolving Loops and defined Cardinalities on the tables from the database. Checked Integrity of the universe using the Check Integrity function of the universe.
• Handled embedded functions like Prompt, Aggregate Aware, Select, Where, and Variable in the Designer to handle business requests for canned and ad hoc reporting.
• Used Custom LOV's functionality in the Universe for performance improvement on the Prompt values.
• Created Deski and Webi reports using Business Objects functionalities like slice and dice, drill down, breaks, sorting, ranking, filtering, alerters, and sections. Have also created complex reports for multiple sales forces and franchises with various tabs, and graphs using complex formulae's and VBA add-in. Reports were displayed in either chart, tabular or cross-tab layouts.
• Designed reports with complex variables, multiple breaks, and sorts to meet the user requirements. Created ad hoc reports per business specifications.
• Created Dynamic customizable data visualization dashboards using Xcelsius 2008. Used QaaWS, Live Office and Designer Universe tools to provide data as source to the dashboards.
• Sourced the Webi reports using Live office and QaaWS in Microsoft excel and used Excel formulae to calculate/trim the data to feed into the Xcelsius Dashboards.
• Deployed the universes, Webi reports and the dashboards from the local machine to the development environment by recreating the Webi reports and updating the connections in the dashboard.
• Used the Broadcast Agent console for auto scheduling of Business Objects Documents.
• Involved in migrating Business Objects Universes and reports from Version 6.5.1 to Version XI R2 using the Import Wizard and migrated full-client reports to Web Intelligence reports using the Report Conversion Utility.
• Interacted with the data warehouse team and suggested ideas to improve the model of the database in order to fine-tune the SQL queries and improve the performance of the reports at run-time.
• Interacted with Business Users and Business Systems Analysts in gathering the requirements for new reports and extracts
• Lead a team of developers and testers in supporting the day-to-day enhancements and new developments. Worked as SME BO subject matter expert on various projects.
• Developed POC on Microsoft Business Intelligence stack for business users to support their Ad-hoc needs.

Environment: Windows XP, Oracle 10g, SAP Business Objects XI R2 CMC, CMS, Designer, Desktop Intelligence, BO 6.5 Reporter, Designer, Supervisor, BCA , Web Intelligence, Xcelsius 2008, SQL Toad, Informatica PowerCenter, SQL Loader, MS SQL Server 2005/2008, MS SQL Server Integration Services, MS SQL Server Reporting Services, EQM Noad version control tool .

Confidential

B O Developer

Work Description:

• Interacted with the Users and Business Analysts to gather the requirements.
• Involved in Installation and Configuration of all Components of Business Objects.
• Designed new Universes and modified the existing Universes based on the report requirements.
• Uses Designer Module to implement Universe, Joining the Tables, Create Prompts and queries, parsing the Objects, apply Contexts and Alias to remove cyclic dependencies.
• Assisted in synchronizing databases and in creating new schemas.
• Created, modified, and maintained complex Reports using Business Objects Reports module that comprised multiple data providers. It also involved creating complex queries and sub-queries within the same report
• Tuned the queries to improve the Performance of the existing Reports for various functional areas.
• Extensively used calculations, variables, filters, conditions, breaks, sorting, drill down, slice and dice, Master/Detail, Cross Tab, Charts and alerts for creating Business Objects Reports.
• Applied security features of Business Objects like report level object level security in the universe so as to make the sensitive data secure.
• Involved in resolving the loops, fan traps, chasm traps using contexts and aliases, checked the cardinalities, Integrity of the Universes.

Environment: Windows XP, Oracle 10g, BO 6.5 Reporter, Designer, Supervisor, BCA , SQL Toad, Informatica PowerCenter, SQL Loader, SQL Server 2005, SQL Server Integration Services, SQL Server Reporting Services, EQM Noad version control tool .

Confidential

Application Programmer/Analyst

• Development of automated banking management system for HDFC.
• Developed a well-defined graphical user interface for the client to enter loan transactions using visual basic as front end with oracle 9i database as backend.
• Developed many crystal reports to retrieve loan transaction data with oracle 9i database as backend.
• Designed and created tables with Integrity constraints. Also created packages, indexes, sequence, views, Export/Import Scripts
• Create custom design Views on user demand.
• Developed some of the complex SQL Loader Control Scripts to upload data from MS-Excel sheets into oracle database.