SUMMARY

• Over 7 years of IT experience in software analysis, development, implementation and administration of various Data warehouse and Business Intelligence projects. Well experienced in delivering full life cycle of business intelligence projects in Pharmacy and Retail domain.
• Working as a Senior Business Analyst with good understanding of all the phases of Software Development Life Cycle (SDLC), from inception phase to production and experienced in different methodologies like Rational Unified Process and Agile with good understanding of Business Requirement gathering, Business Process Modelling, Business Process Flow, and Business Analysis.
• Business Intelligence: 7+ years of Business Intelligence experience using Business Objects XIR3.1/XIR2/6.0/5.0 (Web - Intelligence XIR3.1/XIR2/6.0/5.0, Infoview, Broadcast Agent, Publishing wizard, Import Wizard, Designer, Supervisor, Auditor, Crystal Reports XI R2, Xcelsius 8, and Dashboard Manager).
• Databases: 6 years of experience using Oracle 10g/9i/8i, Oracle Report Writer, SQL, PL/SQL, SQL*Plus, MS Access 7.0/2000 and Teradata V12.
• ETL: Data Warehousing experience on ETL (Extraction, Transformation & Loading) using Abinitio and Data Stage.
• Experience in developing universes, reports design, development and optimization (DESKI, WEBI and Crystal reports).
• Strong knowledge of Data warehousing concepts such as OLTP, OLAP, Star Schema, Snowflake Schema and Multi-Dimensional Models for query and analysis.
• Expertise in building Business Objects Universes, using personal data files, database tables and free hand SQL methods.
• Experience in resolving path problems in joins like Loops and Traps in the universes using concepts of Aliases and Contexts.
• Strong experience in designing and implementing universes using Business Objects Designer by creating essential database structures, resolving loops, creating classes and objects, conditions and joins, Filters, LOV’s, Aggregate Awareness and testing the integrity of the universe.
• Experience in developing dynamic dashboards using Xcelsius using QAAWS and LiveOffice.
• Used CMC to schedule canned webi reports on monthly and quarterly frequency and created user groups and database credentials to burst the webi reports for the desired user group.
• Working experience in the data analysis, design and development, implementation and testing of data warehousing using data conversions, extraction, and transformation and loading (ETL), Datastage and sql server and oracle.
• Expert in providing business intelligence solutions using SAP Business Objects, Universe Designer, Desktop Intelligence, Import Wizard, Info View, OLAP intelligence, and Crystal Reports.
• Experienced in Authentication and Authorization of BOXI environment in setting up User Accounts, and Groups using Central Management Console (CMC) .
• Scheduled and Monitored Reports using CMC. Training to end user and power users.
• Well experienced in providing Detail Design Documents, Developer Guide Lines (Universes), peer review checklists, and peer review documents.
• Well experience in quality testing of various reports and coordinates systems integration testing and user acceptance testing.
• Well experienced in quality testing of Business Objects Reports as per Reporting standards.
• Very good hands on experience in promoting reports to various environments (DEV/TEST/PROD) and troubleshooting.
• Project-oriented team player with solid communication, problem resolution and leadership skills and the ability to develop creative solutions for challenging client needs.

TECHNICAL SKILLS

BI Tools: Business Objects XI 3.1 Web Intelligence, Desktop Intelligence, Import Wizard, Report Conversion Tool, Dashboard Manager, BO XI, Supervisor 6.x/5.x, Designer 6.x/5.x, Business Objects 6.x/5.x, Web Intelligence 6.x, Info View, Central Management Console 3.1/XIR 2,Query Builder.

ETL TOOLS: Business Objects Data Services 3.1, Data stage v 8.0

Reporting Tools: Crystal Reports 10

Database: Oracle 9i/10g, MS Access

Database Tools: TOAD, Teradata SQL Assistant v 12.0

Operating Systems: Windows XP/98 and Linux

Packages: MS Office 2010/2008(Excel/Word/Power Point) Microsoft Project Plan and MS Visio

PROFESSIONAL EXPERIENCE

Confidential, Chicago

Business Analyst

Responsibilities:

• Performed requirements analysis, feasibility study and prototyping for the acceptance of specifications. This involved participating in meetings and discussions with the users in the department.
• Involved in Inception Phase and prepared Logical Data Models that contains set of diagrams and BRDs (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.
• Gathered specific requirements and prepared standard and robust requirement documents.
• Oversee the entire data warehouse life-cycle from ETL to end-user reports.
• As part of requirements gathering, conducted meeting with the business users on a regular basis to avoid any gap in understanding.
• Created and maintained Requirement Traceability Matrix to see if the current project requirements are being met.
• Created detailed Business Requirement Document and Functional Requirement Document with the possible business/data assumptions.
• Performed Quantitative and Qualitative risk analysis to avoid/minimize the impact of the risk.
• Worked in an offshore-onsite model and ensured that offshore resources are leveraged efficiently.
• Worked on demand management tools like - Planwell and Integrated Project Management Systems and used these tools for Forecasting and Cost management of projects.
• Reviewed weekly status reports from the leads and addressed the issues. Prepared Gantt chart with the start and finish dates for different project activities.
• After the project’s scope is defined, created WBS for the overall scope and divided into project activities.
• Monitored the project activities on the defined critical path to avoid any delivery slippage.
• Continuously monitored the health of the project during execution phase by talking to the team members and resolving the challenges if there are any.
• Focused on delivering the quality solution by following the quality standards.
• Prepared lesson learned document after delivering each milestone and shared with different teams.

Confidential, Chicago

Business Objects Designer/ Business Objects Developer

Responsibilities:

• Co-ordinate with Business Users and Business Systems Consultants to understand the business requirements.
• Design and develop various reports using SAP Business Objects, Web Intelligence, and Xcelsius design and development, and crystal reports.
• Designed universes for canned and adhoc reporting needs. Created design documents for Universe and Reports design.
• Created Dashboards using Dynamic data from data source options such as query as a web service and live office.
• Worked with support team to establish policies relating to business objects tickets.
• Upgraded universes, WEBI and deski reports from Business Objects 6.5 to version 3.1.
• Created and maintained Universe supporting multiple levels of hierarchies for drill reports.
• Created Joins, Contexts, and Aliases for resolving Loops and checked the Integrity, Cardinalities of the Universe.
• Created Derived Tables in the Universe using views and stored procedures to meet the Reporting Requirements
• Created prompts, nested prompts and universe filters as per the reporting need of the users.
• Developed unlinked, on-demand sub reports and linked sub reports using shared variables and complex reports like cross-tab, drill down and hierarchical reports. Also created hyperlinked detailed sub reports .
• Developed complex reusable formula, parameter reports and reports with advanced features such as conditional formatting, built-in/custom functions and stored them in repository explorer.
• Wrote Formulas to calculate the Percentages and Summaries based on the group levels.
• Interacted with users in resolving the Help Desk Tickets (Remedy Tickets, Service Desk).
• Implemented security of data by using row level security and user level security.
• Worked with offshore team to develop reports/ resolve issues

Confidential, Indianapolis

Business Objects Developer

Responsibilities:

• Extensively worked with onsite team to understand the reporting requirements and also the current usage and future expansion of existing applications.
• Creating Folder and subfolders for different categories of reports and which will help in providing access to the users.
• Maintained more than 4 Universes for supporting Adhoc and canned reports.
• Debugged the universes, contexts and the various BO reports for conversion to equivalent BI Web reports.
• Created Filters (Condition Objects) to improve the report generation
• Created Hierarchies from providing drill down options for the end-user
• Created Linked, Unlinked, Parameterized and On-demand sub reports for various business needs, reports scheduled for different file based / schedule based events, distributed in email, PDF and HTML format.
• Modifying the existing universes, Adding new objects editing joins, mapping the existing objects with renamed tables
• Creating new Connections and editing existing to run the report in different database environments like test, development
• Formatted the Reports as per the Users requirements using Business Objects, which allows the users to analyze the data.
• Created business user reports per the reporting requirements - complex reports having multiple data providers, created complex variables, debugging of reports, formatting of reports, liking of reports, scheduling of reports to business users.