Summary

• Over 7+ years of IT experience in Data warehousing and Business intelligence with emphasis on Business Requirements Analysis, Application Design, Development, Testing, Implementation,trainingand maintenance of client/server Data Warehouse and Data Mart systems in the Financial, Insurance, Pharmaceutical and Telecom industries.
• BusinessObjects XI 3.1/XI 3.0/XI R2/XI R1/6.5.1/5.1.5 (Designer, CMC, Reporter modules, Info view, SDK’s)
• Web Intelligence XI 3.1/XI R2/R1, Delta Webi from R2/Xl 3.1,Advanced Webi R2, Advanced Webi Xl 3.1, Crystal Reports 2008/XI R2, Live Office, Xcelsius 2008, Data Integrator 11.5/XI 3.0.
• Well versed with Business Objects XI 3.1/XI 3.0/ XI R2, Universe Designer, Info-view/ Web Intelligence, Crystal Reports, and Universe Design with SAP BW data source.
• Experience in building and retrieving data using Universes, Personal data files, Stored procedures, Free hand SQL methods and creating complex ad-hoc Reports using the Business Objects and Web Intelligence modules.
• Build Business Object (BO) Dashboards using tools: Universe, Xcelsius, Qaaws, Live Office, Webi and Crystal Report.
• Experience and Strong understanding of SAP BW integration with Business Objects.
• Experienced in with Business Explorer (BEx) and publishing the reports on web using Web Reporting tools.
• Strong database experience in using Oracle 10g/9i/8i/7.x, MS SQL Server 2000/7.0/6.5,MS Access7.0/2000, SQL, PL/SQL, SQL*Plus, SQL*Loader and Developer 2000. Hands on Working knowledge in Writing the Stored Procedures, Packages, Functions and Triggers.
• Experience in migrating Business Objects Older versions to newer versions.
• Extensive knowledge in all phases of Software Development Life Cycle SDLC (Requirement Analysis, Design, Development, Testing and Documentation).
• Strong knowledge of Data Warehouse techniques and practices, including dimensional data modeling, OLAP, implementing Relational Database(OLTP) and Database performance tuning.
• Have good Experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using ETL.
• Excellent understanding of Dimensional Data modeling- Star Schema modeling, and Snowflake modeling.
• Outstanding communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high compliance to new technologies and tools.

EDUCATION

Bachelor’s in Computer Science Engineering.

CERTIFICATION

SAP, Business Objects Certified for Universe 3.1, Web-Intelligence XI 3.1, Crystal Reports 2008 &Xcelsius 2008.

TECHNICAL SKILLS

Business Intelligence:Business Objects XI 3.1/3.0,XI R1/R2,Web Intelligence XI 3.1/3.0/XI R2, XI 3.1/3.0,XI R2,Designer XI 3.1/3.0,XI R2, Data Integrator 11.5/XI 3.0, Live Office, Xcelsius 2008, Crystal Reports 2008/ XI R2, BO SDK (JAVA), MS Access Reports.

Databases:Oracle 10g/9i/8i/8.0/7.x, MS SQL Server 2008/2005), SQL Loader, SQL*Plus, PL/SQL and Oracle DBMS Packages, DB2, Siebel, Sybase, Teradata.

WindowUtility Package:Windows 95/98/2000/XP/NT, MS DOS, Unix and Linux.
MS-Word, MS-Excel and MS-PowerPoint.Programming/Web

Technologies:Visual Basic 6, SQL, PL/SQL, SQL Plus, Transact SQL, ANSI SQL, SQL Scripting, Visual InterDev 6.0, HTML, DHTML, XML, C, C#, ASP, .NET, VB-script, JavaScript, Unix Shell Scripting, Kernel Programming, PERL Programming, MS Front Page, Apache Web Server, IIS 5.0/4.0.

PROFESSIONAL EXPERIENCE

Confidential Phoenix/AZ Jan12 – present
BO Developer

BCBS is leading health insurance company, having world wide clients. This project was mainly on Production supportand BO admin.

Responsibilities: 

• Mentoring and hands on guidance of development team for delivery of Business Objects Reporting solution
• Lead Project management, and deployment recommendations across various business groups
• Coordination Communication and handoff of various project phases to pilot and subsequent users
• Installed and deployed BO XIR2
• Setup and configured clustered fault tolerant clustered environment
• Administered BO environment using Central Management Console
• Managed Re-write of Deski reports
• Deployed Development, Staging, QA, and production environments
• Managed development of universes and reports (team of 7 direct reports)
• Executed performance and capacity planning tests for full BO deployment
• Worked on Infoburst to schedule reports and monitor those reports.
• Worked on creating PreformanceMatricsto monitor team development.

ENVIRONMENT: Business Objects XI R3.1/R2, SQl server,

DOMAIN
: OARS (MetaVance) , CDW, CORRDW.

Confidential. Phoenix,Az AUG 11- DEC 11
Sap BI developer

FMI is one of the leading international mining company operates large, long-lived,
geographically diverse assets with significant proven and probable reserves of copper, gold and
molybdenum. The FMI system is responsible for various Business Intelligence activities within the
organization. This system deals with the development and maintenance of various universes, reports
and handling of a large number of users.

Responsibilities

• Working with HR Management customers to gather/develop requirements,interacting with the users to analyze the changes for improvement they need in existing
  reports and develop the reports to satisfy their needs and requirements.
• Working on the new requirements and creation of Functional document as per userrequirement.
• Used Erwin tool for data model development.
• Development of multiple Universes & various Reports under Teradata environment.
• Testing of reports based on SAP ECC system.
• Trained end users in developing ad hoc reports through Web Intelligence.

Lead a team of 4 members

• Developing and Maintaining Universes and Reports in BOXI R3.1/R2
• Migrating of existing BO universes and reports from BOXI R2 to BOXI R3.1
• Involved in administration of all Business Objects Enterprise reporting environments forpublishing, configuring, scheduling of Report content.
• Developed and maintained standard and ad hoc reports based on business and technicalrequirements.
• Expertise in using Info View, Central Management Console (CMC), Import Wizard,
• Publishing Wizard, Schedule Manager, Instance Manager and Business View Manager.
• Used Infoburst for scheduling of reports.
• End User Interaction for collecting the requirements & specifications of the reports.
• Implemented Security Features of Business Objects like row level, object level and reportlevel to make the data secure.
• Performance tuning of Reports and Universes
• Version Management of the reports and the Universes Using Version Manager Tool.
• User Coordination for User Acceptance Testing (UAT)
• Production Deployments & Maintenance of the system

ENVIRONMENT: Business Objects XI R3.1/R2, Teradata, Oracle 10g
DOMAIN

Finance/Supply Chain Management

Confidential Marshall, MN Dec ‘09 – May 11
Business Objects Consultant

The Schwan Food Company is the major player in frozen food manufacturing & delivery, offering everything from pizza and appetizers to crispy vegetables. Overall Schwan offers around 400 brands. Schwan is number one frozen food company in the United States and number 2 in the world. My role involved working in Financial Business Analysis for providing a better solution in terms of their business forecast for the current and upcoming projects. The role involved working in all modules of BO for price comparison among different food items produced by Schwan.

Responsibilities:

• Interacted with business analysts and end users to understand technical and functional requirements.
• Actively participated in Data Modeling team meetings and helped in generating the star schemas required for reporting.
• Designed Complex Universes for supporting reporting requirements.
• Created Classes, Subclasses, Dimensions, Details and Measures in the Universe as per the requirements.
• Used derived tables to create the universe for best performance, and use context and alias tables to solve the loops and traps in the Universe.
• Responsible for creating Derived Tables, Aggregated Tables using Aggregate Awareness concept, creating Indexes, views to increase the performance of the universe.
• Created Complex reports using User defined functions like @prompt, variable, condition objects and Aggregate awareness functions for SQL Enhancement.
• Linked two universes sales and customer using kernel approach.
• Created various reports using Business Objects functionalities like Sub-Queries, Slice and Dice, Drill Down, Functions, Cross Tab and Formula\'s.
• Embedded Webi reports in to Microsoft Excel using Live Office.
• Performance Tuning on SQL for Snowflake and Star Schema structures. Utilized Oracle Materialized Views, PL/SQL functions, Oracle pivot table, Oracle Stored Procedures, etc. to facilitate data structure for simpler universe design and/or performance.
• Designed and built reports for KPI’s, AR Aging, Purchasing order, Sales Reports, Cost Analysis, Supply Chain Planning, Financial Focus.
• Create reports include formatting options such as Grouping, Sorting, Drill-down, Parameter prompts.
• Worked on complex Crystal Reports that require running totals, sub-totals, sub-reports, prompts,cross-tab,multiple groups, hierarchical grouping and conditional display of groups, fields and messages.
• Responsible for creating complex crystal reports (On demand, Ad-hoc Reports, Frequency reports, Summary Reports, Sub Reports, Drill-down, dynamic grouping, Cross-Tab, graphical, aging reports etc)
• Scheduled recurring daily, weekly and monthly reports (Webi, Deski and Crystal Reports) in Info View and used Calendar based scheduling for the reports custom dates.
• Involved in the creation ofMacros to save the reports as Excel and send them to usersinbox.
• Created critical visualization using Business Objects Crystal Xcelsius 2008 for the Business Dashboard.
• Used Crystal Reports to feed data to Crystal Xcelsius Visualization an XML file as a data source.
• Optimized the Teradata database for better query response time.
• Designed Calendar, Metrics, analyticsDashboard reports.
• Designed Dashboard reports&Score Card.
• Created Excel-based interactive visual analytics, dynamic charts and groups and business presentations with Crystal Xcelsius.
• Build Dashboards using various connections such as Qaaws, web service, SAP NetWeaver BW, xml.
• Scheduled recurring daily, weekly and monthly reports (Webi, Deski, and Crystal Reports) in Info View and used Calendar based scheduling for the reports custom dates.
• Developed Interactive Dashboards, analytics in Crystal Xcelsius using Live Office.
• Customized Info view with Java SDK and Webi SDK.
• Created a multi provider and virtual key figures and characteristics to populate fields in the BEx queries and web reports.
• Developed Queries and workbooks, using conditions, Exceptions, structures and reporting variables in BEx.
• Build reports with BEx Query Designer and Web AppI. Designer and assisted the Portals consultant to publish reports on web.
• Responsible for migration of universes & reports into Production environment.
• Added/modified Users, Groups, folders and rights using Central Management Console (CMC).
• Trained end users to generate reports and other features of Reporter Module.

Environment: Business Objects XI 3.1/ XI (R2) (Designer ,BO Full Client, Web Intelligence, Live Office, Info View, Qaaws, CMC),Xcelsius 2008 ,Crystal Reports, SAP BW, SAP ECC,BEx Analyzer, SQL Server 2005/2008,Teradata, Oracle 10g/9i

Confidential TX
Aug ’08- Nov’09
Business Objects Consultant

Celanese is a global, integrated producer ,specialty focused on satisfying its customers and delivering growth & value. The project was to build a DATAMART for order management, customer relationship management and to provide sales support based on customer data. I was responsible for KPI reports, Fact Utilization reports etc.

Responsibilities:

• Involved in system analysis and design of the Data warehouse.
• Prepared Business model, logical & Physical models.
• Designed and maintained logical and physical enterprise data warehouse schemas, developed and deployed new data marts along with modifying existing marts to support additional business requirements.
• Designed universes for the data Marts.
• Customized Business Objects Universes for Accounting, HR & Payroll modules.
• Created filter objects, and formatted objects and measures within the universe for faster report generation.
• Strong knowledge and experienced in handling the data integration using informatica.
• Identified the needs of the users and prepared of data flow diagrams, data modeling, entity relationship diagrams, normalization, user, interaction, designing tables, user interface, and processing.
• Resolving the loops, fan traps, chasm traps using contexts and aliases, checking the Cardinalities and Integrity of the Universes.
• Created Derived tables and also aggregate awareness in order to reduce query response time.
• Responsible for Universe Designing for Data Analysis and applied conditions in Business Objects.
• Created universe and reports by extracting data SAP BEX Query.
• Worked on Powerful business objects functionalities like @prompts, @functions, UserResponse and formulae. Responsible for creating simple and complex reports in Business Objects.
• Created Web Intelligence reports with multiple data providers like Universes, Personal Data Files and free-hand SQL.
• Developed various complex WebiandDeski reports which involved use of combined queries and sub queries from multiple data providers.
• Developed various KPI, Fact Utilization and Purchasing Reports.
• Extensively involved in SQL coding, creating complex queries, views, Stored Procedures, Stored Functions to give better results for Crystal Reports.
• Designed Criteria to handle the customer’s request from Tables, Stored procedures, Views and Command objectsusing Crystal Reports XI R2.
• Created Agency reports like, Reports by Region, Reports by Agency, Reports by Sales Manager, Reports by Segment, Reports by Carrier and Baseline Completion reports etc.
• Designed Universes & developed standard CAN reports & crystal reports.
• Added sorting, grouping and summarizations to Crystal Reports.
• Created different categories in the repository and published full client reports corporate documents to their respective categories.
• Designed, developed, tested and maintained reports using multiple data providers.
• Migrated reports from 6.5 to XIR2 using Import Wizard.
• Prepared Unit test cases using Quality Center and developed detail design documents for each report.
• Used Enterprise SDK for developing Java web portal applications to view all report types.
• Created complex Xcelsius dash boards by connecting directly with existing Crystal Reports and XML files.
• Migration, upgrade, Xcelsius dashboards, security setup and more…
• Created Xcelsius Dashboard Functional and Technical Design Specification Documentation.
• Used Crystal Xcelsius to Visualize and to enhance the data presentation along with developing dynamic charts and graphics.
• Used Qaaws connection, SAP NetWeaver BW Connection for building dashboards from various data sources.
• Trained users on crystal reports, deski&webi(infoview) with ad-hoc query functionalities.

Environment: Business Objects XI 3.1,R2/R1 (Designer, Xcelsius 2008, Web Intelligence, Deski Intelligence, Live Office, Info View, CMC, Crystal Reports, BO SDK), SAP BI 7.0, SAP BW 3.5, ECC 6.0, BEx Analyzer/Browser, Oracle 9i, 10g.

Confidential , RI Sep ’06 - Jul ‘08
Business Objects Consultant

This project was called EPA (Enterprise Pricing Analytics) and was aimed towards providing an enterprise wide solution to CVS’s effort in measuring and comparing prospective and existing competitors and their respective pricing sales figures. My role involved working in sales department. The role involved in building data mart and linking universes and working on reporting tools in order to create different sales reports like purchase orders etc for different pharmaceutical products produced and marketed by CVS.

Responsibilities:

• Developed ETL processes to populate Data Warehouse and Data Marts.
• Installed and configured Business Objects Data Integrator (BODI) in a multi-tier environment.
• Designed and developed several Data Integrator(BODI) ETL batch and real time jobs for various clients with sources and target systems such as Oracle, SQL Server, SAP, XML and flat files.
• Set up ETL Best Practices and frameworks as developed by ETL center of excellence and automated BODI ETL batch jobs for nightly run.
• Used DI to load data from different sources to the target database and created local repository and associated job server to it.
• Linking the Universes to share common objects. Updating and maintainingUniverses based on changing user requirements and data source changes.
• Designed Universes for Financial Billing system and Order processing.
• Created reports using Business Objects functionality\'s like Queries, Slice and Dice, Drill Down, Functions, Cross Tab, Master Detail and Formula\'s etc
• Created custom reports like Gross Margin, Account Query, Aging, Balance Sheet, Income Statement, Bad Debt and Payment Reports in response to user needs.
• Created Period reports: shift or daily report, weekly, monthly and annual reports.
• Tested the Created reports and modified the relevant Objects in the Universe.
• Extensively used Business Query for Excel in creating reports as per the Business Users Requirements.
• Involved in creating Parameters and Record Selection Formulas to allow the users to filter the Data.
• Designed Complex reports using sub reports, manual cross tabs using Crystal syntax with extensive usage of Local, Global, and Shared variables at report formulas.
• Created a wide variety of charts like pie chart, 2d and 3d charts.
• Trained IT Department staff on Universe Designer.

Environment: Business Objects 5.1/XI, Data Integrator XI 3.0,Business Objects Designer, Web Intelligence, Crystal Reports, CMC, SAP BW, Oracle 9i, Siebel, Visual Basic 6.0 and Windows 2000/NT/98.

Confidential OH Oct ’04 - Jul ‘06
Business Objects Consultant

The Progressive Corporation is an insurance holding company. The Company owned 58 subsidiaries and had one mutual insurance company affiliate. Its insurance subsidiaries provide personal and commercial automobile insurance, and other specialty property-casualty insurance and related services throughout the United States. The Commercial Auto segment business writes primary liability and physical damage insurance for automobiles and trucks owned by small businesses.

Responsibilities:

• Familiarized the business, its strategy and implementation.
• Developed functional requirements and data specifications for the reports and corresponding data providers (Universe queries and Flat files).
• Setup hierarchies in the Universe for providing drill down options in the reporting environment.
• Built Powerful Queries by creating and applying complex conditions and sorts, User Objects, LOV’s, Combined Queries, Free Hand SQL and semantically dynamic calculations using context method, organized data in the reports by using Filters, Sorting, and Ranking and highlighted data with Alerters.
• Created complex reports using user-defined functions like @variables, @prompt, condition Objects and Aggregate Awareness Functions for SQL enhancement.
• Developed complex reports, graphs and other data analysis solutions on cutting-edge business intelligence technical platforms (businessobjects).
• Exported the Business Objects reports to Webi to be viewed by all users on the Intranet using Webi SDK with JSP plug-in.
• Extensively involved in SQL coding, creating complex queries, views, Stored Procedures, Stored Functions to give better results for Crystal Reports.
• Created graphs/charts for the reports, Created Master Detail and Cross Tab Reports.
• Performed Unit Testing for Reports.
• .Environment: Business Objects XI/6.5/6.1,Webi 6.1, Crystal Reports, Application Foundation 6.0, Business Analysis, Oracle 8i/9i, PL/SQL, Windows 2000/NT.

Confidential Feb’03 - Jun’04
Report Writer

Responsibilities:

• Designed, developed and managed Business Objects Universes and Reports in both Development and Production environments.
• Created and tested classes and objects to organize the universe.
• Use of Designer Module to create universes, linkages between tables, creating prompts, parsing the queries, applying contexts and alias tables to remove loops.
• Exported the universes to the Repository to making resources available to the users. Created reports for various Portfolios using the Universes as the main Data Providers.
• Writing Stored Procedures in SQL to be used in the reports
• Generating reports involved continuous interaction with the users/analysts to get the business knowledge of the company.
• Generating reports using multiple data providers, Free hand SQL, Pie charts, Alerts, Formulae.
• Testing reports before posting them to the repository (query optimization & performance).

Environment: Business Objects 5.1, Webi, Desktop Intelligence, Designer, Supervisor, Server 2000, PL/SQL, Windows NT, Windows 2K