EXPERIENCE SUMMARY

• Having 10years of experience in BI reporting, as a software developer involved in teh design, development, maintenance and support of SAP Business Intelligence Applications including SAP Business Objects XI 4x/3x/XIR2/6.x, Xcelsius, Dashboard Designer,SQL,Microstrategy 9.4.1 and Tableauas a part of teh Decision Support Systems (DSS) initiatives.
• Proficient in all phases of teh Software Development Lifecycle(SDLC(Water Fall &Ageilmethedology)) including Requirements gathering, Analysis, Design, System Implementation, Performance Tuning, Testing and Support.
• Excellent experience wif DW Concepts such as Star schema, Snowflake Schema, Fact, Dimensional tables, physical andLogical data modeling.
• Well versed in SAP Business Objects XI 4x/3x/XI R2 Enterprise Suite (Universe Designer, Information Designer tool (IDT), Web Intelligence, LCM, Central Management Console (CMC), Central Configuration Manager, Central Management Server, Import Wizard, Publishing Wizard, Report Conversion Tool.
• Experience in building Universes, Free Hand SQL methods and creating Complex and Ad - Hoc Reports using SAP Business Objects.
• Experienced working wif Universe Designer and Information Designer Tool.
• Experienced in Migration process of teh SAP Business Objects 3.x to 4.x.
• Extensive experience in interacting wif business users, business owners for requirements gathering, analyzing business process and making necessary changes to schema objects to fulfill reporting needs.
• Experience in using various RDBMS like Oracle 11g/9i/8i, SQL Server 2005/2008.
• Involved in designing Databases and data marts on Oracle/Access. Widely used TOAD (Oracle) and SQL Server Management studio to write complex queries to check for data quality, performance of reporting queries and tweaked them to reduce run time.
• Created Indexes, Partitioning tables and executed teh explain plan to check teh statistics.
• Extensive experience in Data ware housing technologies wif hands on Experience in Microstrategy 9.4.1.
• Experience in Business Analysis, Data Migrations, Data Processing, Quality Analysis and Project Management.
• Responsible for creating teh On demand, Ad-hoc, Informational, Operational, Analytical, Summary, Hyper linking, Cross-Tab, Graphical, Drill, Comparison Reports, Documents and Dashboards.
• Experience in Design, Developing, Testing, Distributing, Maintaining and Performance Tuning of Reports.
• Extensively worked in creating and integrating Microstrategy reports and Objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidations, Custom Groups, Drill Maps, Transformations, etc.), Intelligent Cubes.
• Well versed in developing Dashboard designer and Xcelsius.
• Extensive experience in designing/Supportfor Tableau dashboards.
• Expertise in configuring Distribution Services to enable Subscriptions to be delivered to file/e-mail.
• Hands-on experience working wif Query optimization and Performance.
• Involving in Estimates and project plans.
• Excellent analytical, problem solving, communication and interpersonal skills, wif ability to interact wif individuals at all levels.
• Experience in giving training to teh teams.

TECHNICAL SKILLS

Business Intelligence: XI 4.1 and 4.0/3.1/XI R2/6.5 (Supervisor, Designer,Info view(Launch Pad),Universe Designer(UDT), Information Designer tool (IDT)Import Wizard,Life Cycle Manager (LCM),CMC,CMS, Dashboard design,XcelsiusLiveOffice,Broadcast Agent, Publisher), Tableau 8.2, Microstrategy 9.4.1Microstrategy Developer, Architect, Web, Visual Insight, Intelligence Server, Cubes, Integrity Manager, Object Manager,CommandManger,System ManagerEnterprise Manager,Report Services, Distribution Services.

Reporting Tools: Vermillion Reporting Suite, Actuate reporting Tool, Crystal Reports XI/2013.

ETL Tools: Informatica 8x, Ab Initio

RDBMS: Oracle 8i/9i/10g/11g, SQL Server 2005/2008,Teradata

Tools: SQL * Loader, Toad 7.1, Erwin 3.5.2,SQL Developer.

Languages: SQL, HTML,Actuate Basic.

Operating Systems: Windows 2003 Server, Windows2000/XP and Windows7.

PROFESSIONAL EXPERIENCE

BI Reporting/Analytics Consultant

Confidential, Plano,TX

Responsibilities

• Gather requirements by interacting wif usersand Business consultant systems for design of reports.
• Developed teh prototype reports for end users in Business objects to get sign off for actual designing and for presentation.
• Managing of all BO universes and standard reports in BO XI 4.1 which is used by Home Loan Origination users.
• Providing support for Tableau dashboards.
• DevelopTableaumodule deliverables such asworkbooks, packageworkbooks, buildingdata views manually and automatically using different charts, graphs.
• PerformedTableautypeconversion functionswhen connected to relational data sources.
• CreatedTableauscorecards, dashboardsusingstack bars,bar graphs,scattered plots,geographical mapsusing show me functionality.
• Converted teh Cognos reports (60+ reports)into BOBJ reports.
• Provided BOBJ reports to Community Mortgage,Home Equity and Mortgage teams based on their requirements.
• Design and create teh reporting data structures.
• Prepare teh technical documents and provide teh pseudo code.
• Created and modified universe(.unv)objects for canned reportsbasd on business needs.
• Create standard reports using Web Intelligence functionalities.
• Schedule teh reports as requested by users on daily, Weekly,Monthly, Quarterly basises.
• Preparation of Unit test plans & Unit test results for teh reports.
• Performed in data validation and testing process.

Environment: SAP Business Objects 4.1 suite tools (WebI, IDT,UDT, BI Launch Pad), Tableau 8.2/9.1, Teradata,SQL Server 2008,Windows 7.

WFHM Statement ReportingBI Consultant

Confidential, Charlotte,NC

Responsibilities

• Understand teh reporting Requirements.
• Design and create teh reporting data structures.
• Provide teh Mapping documents for ETL team.
• Prepare teh technical documents and provide teh pseudo code.
• Create global universes(.unx and .unv) for ad hoc reporting for business needs.
• Create standard reports using Web Intelligence / Crystal Reports wif Drill Down and Slice & Dice analysis functionalities.
• Implemented teh custom schedule business logic in query level in Crystal Reports.
• Developed OLTP reports using Crystal Reports XI wif embedded sub-reports.
• Design, development oftableaureports.
• Generation ofTableauextracts and implementation of different calculations, visualizations in thetableaulay out design.
• Preparation of Unit test plans & Unit test results for teh reports.
• Created teh POCs and demo to Business Users and Business Managers.
• Involved in data validation and testing process.
• Prepare teh user documents and provide teh user trainings.

Environment: SAP Business Objects 4.1 suite tools (WebI,IDT and Universe Designer, BI Launch Pad), Crystal Reports 2013,SQL Server 2008,Windows 7.

BI Consultant

Confidential, Tampa,FL

Responsibilities:

• Interacted wif teh client during analysis and documented teh requirements and Gathering teh report requirements from teh users.
• Developed teh prototype reports for end users in Business objects to get sign off for actual designing and for presentation.
• Managing of all BO universes and standard reports in BO XI 4.0 which is used by Regulatory reporting users.
• Involved in installation and configuration of BO Enterprise XI 4.0 components, BI Launch Pad, Dashboard Design, Live Office, Webi, Advanced Analysis for Microsoft office and OLAP.
• Created Connections for Information Designer tool IDT (.UNX) and exported to BOE server.
• Setting up integrated common reporting Environment using Business Objects XI 3.1 suite.
• Created user objects including Dimensions, Details and Measures
• Interacted wif teh users to analyze teh changes for improvement they need in existing reports and developed teh reports to satisfy their needs and requirements.
• Developing complex universes by using advanced features like aggregate aware and Conditions.
• Implemented Index awareness to improve teh performance.
• Created Indexes, Partitioning tables and execute teh explain plan to improve teh performance.
• Created various reports like Cross Tab reports, slice and dice reports, and drill down reports, Charts using Universe as teh main data provider and also Personal data files as data providers.
• Involved in creation of Reports, formatting reports, generation of charts, bars etc as per user requirements.
• Developing of reports as per teh requirements using Business Objects Web Intelligence
• Implemented object level security and incorporated Unified security for Row level security.
• Preparation of Unit test plans & Unit test results for teh reports.
• Drill down reports using Opendoc functionality.
• Designed complex reports based on discussions wif user groups and created various objects using built-in @functions (like @prompt, @select, @where, @aggregate), complex SQL queries and joins
• Develop user interactive dashboards wif KPI measures using Dashboard designer for business performance management.
• Promoting teh tested content form Development to IT, QA and Production using Life-Cycle Manager (LCM).
• Implementing cascading LOVs, Drill data and linking of reports functionality
• Preparation of Unit test plans & Unit test results for teh reports.
• Scheduling of reports and monitoring reports performance.
• Worked on teh Production issues and provided teh report fixes,universe fixes.
• Worked wif support team for environmental issues.
• User/Groups and user Folder creation and applying access restrictions. Migrations across teh environments DEV, UAT and PROD.
• Worked on Production support issues (SNOW tickets)/L3 Support and timeline solutions for teh same.
• Worked collaboratively wif ETL team and Data Warehouse team.

Environment: SAP Business Objects XI 3.1/XI 4.0 SP4, Info view(Launch Pad), Universe Designer (UDT), Information Designer tool (IDT), Import Wizard, LCM, Crystal Reports, Dashboard design, Oracle 9i/11g, Ab-Initio, PeopleSoft

SQL server

Confidential

Responsibilities:

• Teh project involves development of reports and dashboards for regulatory reporting.
• Gather requirements by interacting wif senior managers and Business consultant systems for design of reports.
• Created Public/Schema Objects such as metrics, prompts, filters, reports, and documents, attributes, facts, hierarchies and defined relationships between attributes. Designed Simple Metrics and Compound Metrics to use in reports.
• Designed Adhoc Reports, used prompts and trained/assisted end-users to navigate reports.
• Intelligent Cubes were created to enhance teh performance of dashboard/reports rendering capabilities available in MicroStrategy 9.
• Designed Customized Templates to facilitate teh end users to create customized reports by choosing Filters Metrics and Report Attributes.
• Used System Hierarchy, User Hierarchy, and Drill Maps as per client requirements.
• Created Base formulas, Deals, and Allowances to use wif teh Metrics. Involved in Functional Testing and Tuning of MicroStrategy Reports.
• Used Report Cache sharing and Data mart reports to enhance report response time.
• Created Email/File based Subscriptions to deliver reports to business users.

Environment: MicroStrategy 9.4.1, Oracle 11g, Crystal Reports 2013,Windows 7.

Analyst Programmer

Confidential

Responsibilities:

• Interacted wif teh client during analysis and documented teh requirements and Gathering teh report requirements from teh users.
• Developed teh prototype reports for end users in Business objects to get sign off for actual designing and for presentation.
• Developing of reports as per teh requirements using Business Objects Web Intelligence.
• Scheduling teh BO reports and make it available for VRS reports data source.
• Scheduling of reports and monitoring reports performance.
• Worked wif Vermilion product team for pioneer Dublin - Equity, Fixed Income reports and specific client reports - CNP Monthly, SANLAM, Invensys Pension, InvensysAllocation Analysis, Invensys Quarterly, Quarterly Pension reports, 2 Daiwa reports, Fact sheet reports, Performance Excel report andSG Quarterly.
• Estimating and designing teh Dublin new reports as client requested and providing teh implementation documents and release notes for teh production releases as per client branding guidelines.
• Estimating and analyzing teh change request requirements for Boston and Milan client reports.
• Deploying and releasing teh production releases.
• Importing and exporting bulk requirements from one environment (Dev, QA, and UAT) to production environment.
• Create/modify teh Styles, Components, Reports, data sources and record sets.
• Create/modify teh commentary or other manual data using commentary module.
• Create/modify Reference Data (Entities).
• Re-branding teh Milan Annual report.
• Worked on UAT Sierra report Changes for Boston Pioneer and released teh all Sierra reports (12 Reports) from UAT environment to Production Environment.
• Place teh java files in server folder structure and after bouncing teh JBoss server and checking teh server log files if VRS system files to generate or preview teh reports.
• Conducted Trainings on Vermilion Reporting Suite (VRS) Concepts for Boston and Dublin QA team’s and prepared teh Training material.
• Involved in upgrading teh VRS tool from lower version to latest version (2.7.3).
• Responsible to support teh issues wif reports on teh BO environments (Development, UAT, Test and Production).
• Develop and implement test scripts for evaluating service packs and future releases
• Evaluate and design web services access points for data access in multiple and dynamic user interfaces.
• Designed, developed and tested teh reports based upon data generated by enterprise transaction, financial, and customer information systems usingBusinessObjectsXI connected to Oracle data source.
• Set up groups and users forBusinessObjectsdeployment in CMC.
• Developed WebI Reports as per thebusinessrequirements

Environment: Business Objects XIR2 (Info view, Universe Designer, WebI, Crystal Reports, Publication Wizard, Import Wizard), Vermilion Reporting Suite (VRS), JSP, Jboss, Eclipse, Toad 9.1, Oracle9i, Windows 2000/XP.

Confidential

Analyst Programmer

Responsibilities:

• Involved in Business user requirements gathering, analyzing, and documenting business requirements, functional requirements and data specifications.
• Created reports using web Intelligence tools whereas Business Objects Universe as teh Data Provider.
• Specified teh Joins and checked teh cardinalities.
• Implemented Contexts, Joins and Aliases for resolving Loops and Checked teh Integrity of teh Universes and exported teh universes to teh Repository making resources available to teh users using Designer.
• Check Integrity of teh universe.
• Exporting teh Universes to repository to make it available to teh users.
• Created reports using web Intelligence tools whereas Business Objects Universe as teh Data Provider.
• Hands on creating Alerter, filters, variables, Prompts.
• Format teh reports as per teh business requirements.
• Creating teh Folders using Central Management Console.
• Copying teh Reports from one folder to another in infoview.
• Scheduling teh Reports as per business needs through Infoview.
• Preparation of Unit Test Cases for reports.
• Performing Unit Testing.
• Prepared ad hoc supporting documentation for senior financial management.
• Exported reports into various formats like PDF, HTML, EXCEL and WORD for end users.

Environment: Business Objects XIR2 (Web Intelligence, Info view, Xcelsius 2008 &QaaWS), Crystal Reports, Publication Wizard, Import Wizard, Dashboard Manager, SQL, Windows 2000/NT, Oracle 9i.

Confidential

Analyst Programmer

Responsibilities:

• Created list and cross tab reports using Business Objects Web me.
• Worked wif Business Objects Designer to modify teh existing universe as per teh Reporting and Sales Dashboard needs.
• Defined Classes & Objects of teh universe and organized teh data along dimensions and hierarchies to perform multi dimensional analysis (Slice &Dice and Drill).
• Created complex reports do display charts, alerts using Web Intelligence.
• Worked on different data sources such as Oracle, SQL Server, XML, MS Access.
• Designed reports by using different functionalities like drill down, using calculations wif variables, comparing wif previous year data to get change % etc.
• Exported Reports to Excel based on User requirements.
• Worked wif a Team to develop a complex universe and generated reports exclusively using Full client.
• Developed user friendly Universes usingBusinessObjectsDesigner for variousbusinessneeds.
• Created teh reports using Universes as teh main data provider.
• Worked on resolving some of teh WebI issues which users had faced
• Created and modified Universe by using @functions, Short-cut joins, Hierarchies and wrote custom SQL in derived tables.
• Provide teh Mapping documents for ETL team.
• Created ETL process for different ETL modules based on teh requirement.
• Worked wif various transformations like Query, Lookup, Pivot, Reverse Pivot, Hierarchy flattening and Merge transformations.
• Designed ETL modules to implement security by creating User Role Hierarchy.
• Used Informatica Designer tools to design warehouse using source definition, target definition and transformations.
• Prepared UTP documentation and tested teh Jobs, Workflows and mappings for each scenario as per teh document.
• Documented all teh changes made to teh Universes and Reports for future references.

Environment: BusinessObjects6.5, Web Intelligence, Informatica 5.1/6.x, Oracle 8i & Windows 2000.