SUMMARY

• Around 05 years of hands on IT experience specializing in analysis and various Business Intelligence tools such as 4.0/BO XI R3.1/R3/R2, (Desktop Intelligence, Web Intelligence, Universe Designer, Crystal Reports, Xcelsius, Import Wizard, CMC, CCM and Report Conversion tool), SSIS, SQL server and Oracle.
• Good Knowledge in all phases of Software Development Life Cycle (SDLC) Development, Testing, Migration, Administration, Security Management and specializing in implementing Change management ITIL practices.
• Good Knowledge of data warehouse concepts. Involved in integration project.
• Extensive experience working with cross - functional teams using the applications such as Informatica, Oracle database and SAP BI/BW for addressing the needs for end users and IT business stake holders.
• Experience in Software Analysis & Design, Gathering Functional and Business Requirements Specifications, User Interface Specifications, Technical Design, Test Cases and Test Plan.
• Implemented and followed standard policies and procedures, maintaining the version control number of each released version of application based reports before production move.
• Analyze business requirements and segregated them into high level and low level Use Cases, activity diagrams / State Chart Diagrams using UML methodology thus defining the Data Process Models.
• Prepared Business Requirement Documents (BRD), process flows, business and system use cases, entity relationship diagrams, business process diagrams, and activity diagrams pertinent to initiatives.
• Used MS Office extensively (Word, Excel, Visio, Power Point, Project) for calculations, graphs, analysis, presentation and documentation throughout the project.
• Familiar with the current industry improvement standards like Six Sigma (6σ), Capability Maturity Model (CMM), Waterfall and Agile Methodology.
• Knowledge of databases like Oracle 9i/10g, MS SQL Server 2008, MS Access.
• Working Experience in Pharmaceutical, Consulting and Mechanical engineering Industries.
• Extensive experience in administrating and supporting Business Objects servers, client tools and services.
• Experience in Production and Technical Support activities and managing production rollouts.
• Involved in testing reports in the Pre-Prod/QA environment.
• Experience in creating Canned/Ad-hoc Reports using Web intelligence and Desk intelligence reports.
• Extensively migrated reports/dashboards and universes from Dev, QA to Prod using Import wizard and Life cycle manager in BI 4.0.
• Experience in performing backups of reports and universes to BIAR file and restoring the older version of the same in the repository using Import Wizard.
• Converted Desktop Intelligence report to WEB Intelligence reports using Report Conversion Tool.
• Validated the reports/ report structure developed by the offshore team.
• Experience in Production and Technical Support activities and managing production rollouts
• Good Knowledge of Dimensional Modeling like Star Schema and Snow Flake Schema to fit Query, and Reporting and Analysis requirements.
• Good knowledge in overall BO XIR3 and BOBJ 4.0 application architecture.
• Good Experience in creating Universes with Classes, Objects, Joins, Filters, LOVs, Cascading LOVs, Aliases, Contexts, Aggregate functions.
• Addressed the issues of Fan trap and Chasm trap in Universe
• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks for addressing user requirements.
• Possess excellent interpersonal skills, effective written & oral communication, and presentation skills.
• Extensive experience working with business users as well as senior management. Proven ability to work in team-environment as well as independently.
• Fast learner and able to adjust in any kind of work environment.

TECHNICAL SKILLS

BI Tools: Business Objects XI3.1/BI 4.0, UDT/IDT, WEB Intelligence, BI Workspace, BO Data services, Desktop Intelligence, CMC, CCM, Import Wizard/Repository migration wizard, Life Cycle Manager, Data Integrator, Report Conversion tool, Upgrade management tool, Excel Add-in, and MS SSIS.

Others: Project Management knowledge

Database: SQL Server 2008, Oracle 9.x/10.x/11.x and MS Access

Dimensional Modeling: Star Schema (ROLAP), Snow flake schema

Applications: MS Office, TOAD 9.5, SQL DBX, MS Share point.

Operating Systems: Windows 7/XP/2003

PROFESSIONAL EXPERIENCE

Confidential, Southborough, MA

Sr. BI Consultant

Responsibilities:

• Involved in GDW Integration/enrichment project, for different acquisitions in the organization.
• Involved in analyzing the requirements and help developers to create Star Schema for Multi-Dimensional modeling within an enterprise wide Data warehousing effort.
• Requirements gathering, drafting functional specifications, design and development of BRD’s for Sales GDW enrichment/integration project.
• Worked in Sales department to analyze and create reports.
• Performing quality checks on the deliverables before they are migrated to production.
• Created Unit test documents while developing the reports and get the approval for release.
• Involved in project management by following up with the developers and business stakeholders.
• Validate the reports/ report structure developed by the development team.
• Requirement gathering and analyzing to fulfill the need to create automation process of the reports to different business users.
• Created data mapping documents for smooth integration.
• Assisted in creating row level security to different stake holders depending upon their role in OBIEE platform.
• Identifying mapping source columns and creating documents for data modeling prior to code building.
• Created data flow diagrams in MS Visio to assists data architect and developers to understand and build the ETL codes with proper mapping of the destination columns.
• Creating tests cases and performing unit testing on ETL codes prior to go live.
• Creating ad-hoc reports in OBIEE environment for testing the accuracy of data.
• Tested the reports in Development environment before migrating to test and perf environment.

Environment: SAP BI 4.0, Crystal Reports, Informatica 9.1, OBIEE, SQL Developer, Oracle 11g and MS office tools.

Confidential, Memphis, TN

SAP BO Consultant

Responsibilities:

• Gathering Requirements, Drafting specifications, Design, Development, User Acceptance Testing and Production Roll Over.
• Strong Business knowledge in Transportation, Sales, Accounts Payable and Receivable, Freight Rate System, HR Data.
• Facilitating requirements meetings with project teams
• Perform gap analysis of current-state and future-state
• Developed technical documents for creating complex universes, custom and canned Web Intelligence reports and Multi Tab Dynamic Dashboards.
• Propose solutions/approaches for scope of to-be state.
• Created Web intelligence reports with manual SQL using derived tables.
• Created two new BO Universe in star schema and snow flake schema with Oracle as data source for commercial team.
• Resolved loops and assigned row level security for different users.
• Extensively migrated the reports within the repository (test environment and Production) using Import wizard.
• Interacting with end users, regularlyin order to generate the reports required for moving to production.
• Critically evaluated information from multiple sources, reconciled conflicts, decomposed high-level information into details, abstracted from low-level information to a general understanding, and distinguished user requests from the underlying true needs.
• Create and maintain visual models, activity diagrams, data flows, etc. where necessary.
• Interacted professionally with a diverse group of executives, managers, and subject matter experts for gathering requirements.
• Worked effectively in a cross-team environment to solve business problems and/or develop new solutions.

Environment: Business Objects XI 3.1 SP2, Oracle 11g, SQL server, Teradata, TOAD and MS office suite tools.

Confidential, Lexington MA

Lead BO Consultant

Responsibilities:

• Provide Production Support and maintenance services in Business Objects.
• Available on call during non-working hours and during weekends.
• Develop and gather requirements from business users and management.
• Provide Support to Business users in Business Intelligence Reporting.
• Ensuring that the delivered test artifacts confirms to the customer requirements and agreed quality standards.
• Coordinated with Supply chain, Manufacturing, Finance and Cost accounting teams for gathering specific requirements and created Desktop Intelligence and Web Intelligence reports on Business objects platform.
• Gather and document requirements for Business Process related to Data Governance and Business Intelligence.
• Prioritize the requests on weekly basis, assign and share the workload with offshore resource.
• Followed the required standard operating procedures (SOP) for documenting all the change control process for production move.
• Performing quality checks on the deliverables before they are released it to the client.
• Created several users and user groups and assigned them with required access levels, configured servers, created profiles, added principals in CMC.
• Involved in creating reports such as Daily Sales Report, Monthly Sales Revenue, Purchase Order with Terms, SPIL Delivery Note, SPIL Credit Note and other reports.
• Created Periodic, Demographic and Comparative Reports. All the reports were scheduled on a Daily, Weekly, Monthly and Yearly basis.
• Created several users and user groups and assigned them with required access levels, configured servers, created profiles, added principals in CMC.
• Involved in planning strategies for upgrading Business Objects from R3.1 to BOBJ 4.0
• Involved in unit testing the new BI 4.0 platform with its latest functionalities and capabilities.
• Unit tested Web intelligence reports in BI 4.0 environment with BEX as data source.
• Experience working on ERP systems such as ROSS and SAP.
• Production and Non production server restarts during the respective maintenance weekends.
• Coordinate with ETL and DB teams to address different internal mini projects.
• Created the new connections as per the user requests
• Manually run the SSIS jobs for Commercial team for daily shipments to external vendors.

Environment: Business Objects XIR3.1/BI 4.0 (Designer, CMC, Webi, Deski, CCM, Import Wizard, LCM, Report Conversion tool, Info View, BI Launch pad, BI workspace and upgrade management tool), SSIS, Oracle 10g/11g, SAP BW and Windows Server 2003.

Confidential, Deplanes, IL

SAP BO Consultant

Responsibilities:

• Created test scenarios, coordinated UAT and resolved issues during UAT
• Created CAPA document to address the critical incidents occurring during the maintenance weekends.
• Responsible for the Production and Non Production deployment by coordinating with other teams.
• Involved in the production support issues and assigned the tickets using the JIRA and CTRAC ticketing tools respectively to the related BI teams.
• Coordinated with Developers to create Multi-Dimensional analysis using Slice and Dice and Drill through methods to organize the data along a combination of “Dimensions” and “Drill-Down Hierarchies” giving the ability to the end-users to observe data from Heterogeneous viewpoints.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications about the IT incident system for Business Intelligence applications like SSIS, Informatica and Business Objects.
• Gathered the detailed requirements and identified the impacts.
• Track and monitor changes and projects through the ITIL Change Management lifecycle.
• Ensured that each Change Request had the appropriate supporting documents for each assigned
• Production release and extensively used L2G form for the same.
• Reviewed and discussed Changes and Rollback Procedures.
• Coordinated identifying the downstream impacts with various downstream data warehousing applications.
• On Call for any technical issues for Operations or Change control approvals.
• Created Business objects Universes and created Desktop intelligence and web intelligence reports as per the user requirements.
• Created dashboards and charts as per the requirements using Xcelsius 2008.
• Created profiles and added users and scheduled the publications as per requirements given.
• Created new objects in Universe and maintained the version control process.
• Migrated the reports and Universes from one environment to another using Import wizard.
• Created Business objects Enterprise Users and assigned the security as per requirements.
• Coordinated with developers to create calendars and used it in the publications to users that schedules daily, monthly basis.
• Trouble shooting the reporting/server issues that arise during the month end activities.
• Restarted the Business objects servers and used CCM for carrying out maintenance activity extensively.
• Extensively used multiple applications generally used such as MS Office, MS Outlook, Share point site and SQL developer.

Environment: Microsoft - Word, Excel, PowerPoint, Visio and Access, Business Objects XIR2, Universe Designer, WEBI, Desktop Intelligence, Administrator, CMC, CCM, Import Wizard and Report conversion tool.

Confidential, Secunderabad, AP

TSA - MIS Consultant

Responsibilities:

• Prepared daily, weekly, monthly KPI Report Publish regular dashboards for Operations performance and business review decks for review at different levels.
• Provided complete documentation, presentation and training for the end-users.
• Designed, developed and managed Universes in Business Objects Designer for generating the pay roll reports manufacturing and R & D group users.
• Interacted with customer support regularly, in order to generate the reports required and to resolve the existing issues.
• Created Universes by defining connections and retrieving data from database.
• Creation of reports like Reports by Period, Demographic reports and Comparative Reports.
• Created New Classes and User Objects in designing the universes.
• Created and modified the Desk intelligence and Web intelligence reports for various financial groups using the Universe as a main data provider.
• Modified the Universes by creating the measure objects and filters.
• Created a report in web intelligence like transaction detail, Ops Manager.
• Modified a universe for transaction detail, Financial Approval, Ops and BI Universe and assign the security at the universe level to Users.
• Provide Support to Business users in different issues.
• Provide onsite support to the customer during the initial usage phase, ironing out issues, tuning the solutions and implementing customer-requested changes.
• Performing quality checks on the deliverables before they are released it to the client.
• Involved in testing the performance of the report before moving it to production using Import Wizard.
• Provided complete documentation, presentation and training for the end-users.
• Worked in ISO Certified department and followed all the standard procedures.
• Worked with BI apps team to establish security structures that protects company's data and information networks.
• Designed strategies that implement computer network systems such as how business gathers and processes data, the ability to upgrade systems as technology changes.
• Coordinated with different BI apps team to review the company's allotted IT budget, assesses requirements for equipment, software and hardware.
• Created new connection strings like ODBC, SQL Server and MySQL connections as per user requirements.

Environment: Microsoft - Word, Excel, PowerPoint, Visio and Access, Business Objects XIR2, Universe Designer, WEBI, Desktop Intelligence, Administrator, CMC, CCM, Import Wizard and Conversion tool.