SUMMARY

TOTAL IT / SDLC:

• Eight Plus (8+) years of total IT and Data Warehousing experience teamed with Business Intelligence Reporting and Analysis across Various Verticals.

BUSINESS INTELLIGENCE / BOBJ EXPERIENCE/ BO UNIVERSE DEVELOPMENT & OLAP CUBES / DASHBOARD / SCORECARDS

• Six Plus (6+) Years of Strong Business Intelligence experience usingSAP BOBJ 4.0/3.1, Business Objects XI R3/ R2 / R1 6.5
• Experience in working with Oracle 10g/9i SQL and PL SQL, DB2, Teradata V2R6, Flat files, MS SQL Server 2008/2005/2000.
• Experience with Business Objects tools (CMC, Designer, Supervisor, Reporter, DESKI, WEBI, CMC, Dashboard Manager, Broadcast Agent, Infoview and Import Wizard)
• Developing, testing, Migrating, Administrating, security management and production supporting on various platforms like UNIX, and Windows environments.
• Excellent Experience in Universe Design,Desktop Intelligence Reports and Web Intelligence Reports.
• Excellent OLAP Cube Building experience using Business Objects Designer.
• Expertise in planning, designing, developing, distributing and maintaining Universes.
• Extensively worked on designing and developing complex universes, which has several hundreds of objects, contexts, and aliases, aggregate aware functions and cascading prompts.
• Strong knowledge in building queries on different types of Data Providers, Universes, Personal data files, Stored Procedures, Free-hand SQL, and Web connect.
• Developed several Dashboards and Scorecard using Dashboard manager.

BO ADMINISTRATION:

• Strong experience as Business Objects Administrator including installation, configuration of BO tools, set up and maintenance of Business Objects Enterprise environment, creating and managing groups and user profiles.

CRYSTAL REPORTS /CRYSTAL XCELSIUS EXPERIENCE:

• Crystal Reports Expertise in creating Business Views (Creation of Connections, Dynamic Data Connection, Data Foundation, Business Elements and Business view) and Reports using Business Views.
• Created complex reports using Crystal Reports XI R2.
• Created Linked Sub Reports, Unlinked Sub Reports and On Demand Sub Reports.
• Used Crystal Reports to create Complex Reports to receive the data from the Stored Procedures.
• Used Crystal Reports to create Reports to use direct SQL as a data source.
• Expert to create parameterized reports.
• Created and used Formulas, Filters in Crystal Reports.
• Implemented Section Formatting and Objects formatting in Crystal Reports.
• Created Analytics and Dashboards using Performance Manager and Xcelsius to enable executives track progress and compare current and historical performance against established targets. Worked with InfoBurst XCelsius add in.
• Used QaaWs (Query as a Web Service) and Live office to feed data into Xcelsius.
• Created Complex Dashboards using Crystal Solutions Dashboard and Visualization (XCelsius)
• Used Crystal Dashboard design and Crystal Presentation Design (both in-built templates and customized templates) to transform complex data in a more consolidated and powerful interactive dashboards
• Used XCelsius products to create most complex presentations

DATA WAREHOUSE / DATA MODELING / DATA BASES / DATA ANALYSIS/ REPORT VALIDATION

• Worked with Business Users to analyze the business process and made necessary changes to schema objects to cater their reporting needs.
• Experience interacting with Business users to analyze the Business Process requirements and transforming them into project documentation, universe specification, report specification and issuing out the deliverables.
• Experience with Dimensional Data Modeling experience using Data modeling, Star Schema/Snowflake modeling, FACT & Dimensions tables, Physical & logical data modeling, ERWIN. Experience in deciding suitable data model for Data warehouse by creating prototype i.e. Star Schema & Snowflake Schema to fit reporting, query and business analysis requirements.
• Experience using Oracle 10g/9i, DB2, SQL Server, Teradata.
• Extensive SQL and PL/SQL Coding for BO reporting, Data Validation, Data Analysis, Source-to-Target Mappings and Report Validation.
• Experience working with Informatica PowerCenter 9.0/8.6 for ETL Purposes.

PROFESSIONAL SUMMARY

Confidential, KALAMAZOO, MI
FEB 2010 - TILL DATE
SR. SAP BOBJ /CRYSTAL XCELSIUS DEVELOPER

The main purpose of the project was to build a DW on Sales and Marketing to measure sales growth and calculate market share and enhance the business strategy and operations for the Sales and Marketing Department, thus increasing sales. This datamart also served as one of the key sources for the R & D division to observe new trends in the market with regard to new products.

Primary Objective of the project was to create a DW where sales managers can get reports which will help them in making decisions pertaining to

• Sales force alignment
• Sales growth
• Strategic targets
• Performance index measures
• Forecast product sales (Geographically for product or group of products)
• Design comprehensive sales force compensation packages
• Creating sales force size/patient capture & revenue generating applicants
• Online call reporting physician prescription tracking system
• Training on drugs for sale - Medical reps

Responsibilities:

• Gathered the requirements from the business users and built the functional requirement specification documentation.
• Designed and developed universes as per the requirements by carrying out the dimensional data modeling for the data warehouse
• Developed dashboards and score cards using Xcelsius.
• Generated Several reports in Sales Force alignment, Sales growth, Strategic targets, Performance index measures, Forecast product sales (Geographically for product or group of products).
• Some reports were generated to help the Sales managers to design comprehensive sales force compensation packages, Create effective, sales force size/patient capture methods & revenue generating application strategies
• The reports were also used to generate Online call reporting physician prescription tracking system
• Created Analytics and Dashboards using Performance Manager and Xcelsius to enable executives track progress and compare current and historical performance against established targets. Worked with InfoBurst XCelsius add in.
• Used QaaWs (Query as a Web Service) and Live office to feed data into Xcelsius.
• Created Complex Dashboards using Crystal Solutions Dashboard and Visualization (XCelsius)
• Used Crystal Dashboard design and Crystal Presentation Design (both in-built templates and customized templates) to transform complex data in a more consolidated and powerful interactive dashboards
• Used XCelsius products to create most complex presentations
• Created New Classes and User Objects in designing the universes.
• Created and modified the Crystal Reports for various financial groups using the Universe as a main data provider.
• Uses an XML Data as a one of the connections in the Xcelsius to export the data out of an xcelsius.
• Created a xcelsius dashboard - Claims Approval Dashboard by the using the Query as a web service.
• Created a drill down at the report level in crystal reports as well as in the web intelligence.
• Created a 3 level of drill down in the xcelsius dashboard, and build the functionality in the dashboard to export the data from the .swf file into excel sheet by using the xml data connection.
• Designed, developed, modified and maintained Business Objects universe using Designer 6.5 for ad hoc and canned reports.
• Created joins, indicating cardinalities, checked integrity of the universe and resolved loops and traps using aliases and contexts.
• Created Hierarchies, complex objects using various @functions, Aggregate objects in the universe.
• Designed cascading prompts in the universe to filter the list of account names based on the business units.
• Import and export universes and reports to and from Repository using Import Wizard.
• Extensively used Report Conversion tool to convert Deski reports to Webi reports
• Created users, users groups and maintained user access rights for BO universes and reports using supervisor.
• Scheduled pre-canned reports through Broad Cast AgentServer for distribution and printing.
• Created reports and compare the daily sales using both tabular reports and 3-D graphical chart reports (bar graph & pie charts).
• Created variables, formulae and objects at report level.
• Generated reports using prompts, filters and conditionsand testing these reports with all possible data for consistency.
• Defined Metrics, Rule, Alerts, Analytics & Created Dashboard using Dashboard Manager.
• Monitoring Business Metric.
• Worked on Informatica Transformations.
• Created and maintained Business Objects reports in Web Intelligence Info View.
• Created queries to extract data from database for multi-dimensional analysis using Slice & Dice and Drillup/down functionality.
• Provided training to end users to use various functionalities of Business Objects thick and customized thin client.
• Created scripts for Oracle Tables, Indexes, Users, Roles, views and Stored Procedures and Functions.
• Designed and developed PL/SQL stored procedures to increases the performance.
• Developed UNIX shell scripts to automate applications.
• Various daily and monthly Unix ksh scripts are created or modified to include the new enhancements, accordingly Oracle stored procedures, functions and packages are either created or modified to meet to the business user\'s expectations.
• Executing, monitoring various Unix ksh scripts, escalating and bug fixing the related issues as required, providing solution\'s, implementing code logic as per functional, adhoc requirements.
• Optimized the Oracle PL/SQL queries.
• Fine tuning PL/SQL stored procedures
• Created Logical and Physical models for Staging, Transition and production Warehouse using Erwin 3.0
• Extensively created Complicated Formulas and used functions like InRepeatedGroupHeader, WhilePrintingRecords, WhileReadingRecords, EvaluateAfter etc.
• Responsible for creating the Complex Crystal Reports (on demand, AdHoc Reports, Frequency Reports, Summary Reports, Sub Reports, Drill-Down, Dynamic Grouping, Cross-Tab, Graphical, Aging Reports).
• Created Complicated Formulas and Running Totals on Summarized Totals for Business Measure Calculations based upon various End-User Requirements Worked on various backend Procedures and Functions using TSQL.
• Created Parameter driven reports to restrict volume of data and to make the report user friendly so that user can retrieve data according to their needs.
• Created various SQL scripts for verification of the required functionalities.
• Created multiple complex canned reports and ad-hoc reports using Deski and webi
• Used import wizard to migrate the BO content from XI R 3.0 to R 3.1 and also from Dev server to Production Server.
• 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.
• Worked on SQL tuning to enhance the reports' performance.
• Wrote SQL queries for Data Validation and Report Validation.
• Wrote PL/SQL Code for BO report Generation.
• Provided training to the business users for basic and advanced reporting skills.
• Used BO Explorer to create information spaces on the universes.
• Setting up object level and row level securities on the universes to various groups and users.
• Resolved issues like loops by creating aliases and contexts as required to remove the cyclic dependencies
• Created reports as web services using QAAWS & LIVE OFFICE.
• Used Informatica to develop and implement coding for the mappings at different stages of ETL
• Developed complex mappings in Informatica to load the data using different transformations like Source Qualifier, Look up, Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router transformations
• Worked closely with Infrastructure groups to identify and resolve system problems.
• Created New Users in CMC as per the Business requests.
• Involved in creating the Security model for the Business User's.
• Used Unix shell scripting to schedule various BO jobs.

Environment:Business Objects XI 3.0 and 3.1 (Designer, Business Objects Full Client), Xcelsius 2008, Webi Rich Client, Webi, Import Wizard, Oracle 11g, SQL Server 2005, DB2, SQL, PL/SQL, XML, Flat Files, SAP BW, Windows 2000, Informatica 9.0, MS Office, Business Objects Explorer, QAAWS, Live office, UNIX / LINUX.

Confidential, WARREN, NJ
MAR 2008 - JAN 2010
SR. BO REPORT DEVELOPER

This DW was built for CITI (CMB-IT) MARKETS & BANKING. The purpose was to integrate the data for Loan applications for further analysis and reporting. To achieve this objective a Datamart was created to integrate data from multiple platforms to analuze data and create reports to process the loan applications.

Responsibilities:

• Worked with Functional Managers / Business Analyst's / End Users to gather Universe Design and Reporting requirements to implement business logic for successfully implementation of reporting system for HLMS.
• Analyze the requirements with the business users and come up with the technical specifications and Functional specification.
• Played an active role in the data modeling and Architecting the new BO environment.
• Designed and implemented the New Universes and in making relevant changes for existing universes.
• Creation of the Universe with Classes, Objects and Condition objects using Designer.
• Resolved universe issues like loops by creating aliases and contexts, traps, joins, hierarchy, lov's, parameters and connection issues.
• Worked with Business Objects Security Viewer to create and view existing security setup
• Installed and Configured Business Objects Enterprise Suite, Business Objects Data Integrator XIR2 and Business Objects Data Quality & Data Insight with proper IQ and OQ documentation
• Experience in migrating BO Universe, reports, dashboard reports, ETL jobs from one environment to another environment
• Created Period reports shift or daily report, weekly, monthly and annual reports and financial reports
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports
• Tested the reports thoroughly created by other developers, as per the report specifications
• Wrote requirement document and design documentation for Universe and reports
• Created Object Packages to schedule group of reports
• Setup the row level security for better management of users' data access.
• Worked on Developing Deski and Web Intelligence Reports using features like Drills, filters, Sort, Rank, Sections, Breaks, Alerts, merge Dimensions, Sub Quires and Multiple Data Providers.
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @Functions, Cross Tab and Formulas etc.
• Key person to create Reports/manipulating data through various presentation styles such as charts, crosstabs, standard tables and synchronization reports using both Desktop Intelligence and Web Intelligence tools.
• Created user prompts, conditions and filters for various reports to specify the reporting parameters as per the business rules and the requirements of the end user.
• Develop the reports (including Dashboard reports) based on the new enhancements and interpret the data (Business Intelligence Report writing).
• Generate reports like Customer personal data rpts, Customer Loan details rpts, Customer DSA/DSR rpts, Customer Credit bureau rpts, Customer Loan tax rpts, Customer Equiry list rpts, Customer Condition rpts, and Customer interest rate rpts.
• Created Analytics and Dashboards using Performance Manager and Xcelsius to enable executives track progress and compare current and historical performance against established targets. Worked with InfoBurst XCelsius add in.
• Used QaaWs (Query as a Web Service) and Live office to feed data into Xcelsius.
• Created Complex Dashboards using Crystal Solutions Dashboard and Visualization (XCelsius)
• Used Crystal Dashboard design and Crystal Presentation Design (both in-built templates and customized templates) to transform complex data in a more consolidated and powerful interactive dashboards
• Used XCelsius products to create most complex presentations
• Exported the Business Objects reports to BO repository to be to be viewed by all users on the intranet using Web Intelligence.
• Worked on creating Derived Tables, Aggregated Tables using Aggregate Awareness concept, creating Indexes to increase the performance of the universe.
• Worked on creating stored procedure for Business Objects Reporting.
• Extensively used SQL and PL/SQL scripts to test the reports and create the reports.
• As a Team member was involved in BO XI R2 Migration for Marketshare Report - (Converting Deski reports to Webi Reports).
• Interact with the regional managers to identify the most important metrics and conduct meetings to define the philosophy and data flow for the dashboard.
• An Excel Data Template was designed and distributed to the regional Managers. The regional managers then populated this data sheet which was embedded into a Crystal Xcelsius Dashboard model to generate the first manual version of the dashboard.
• Analyzed data to see whether Data matches to user Expectations.
• Involved in Functional Acceptance testing (FAT) and User Acceptance testing (UAT) Created Test cases, reviewed and maintained test scripts, analyzing bugs, worked with development team and ETL team members in fixing defects and validating the solutions.
• Added users, user groups and managed the access privileges of the user community using the CMC module of Business Objects XIR3.
• Migrated the Users, Groups, Universes, Personal Folders, Connections, Reports (DeskI & WebI), Excel, pdf and Instances to Production, Development and Test Environments using Import Wizard from BO XIR2 to BO XI R3 Environments.
• Support and train the users on the reporting tools and the business logics.
• Worked and coordinated with Off-shore team in design and development.
• Periodical Scheduling for Reports to run automatically. Implementation and periodic maintenance.
• Performance tuning of BO reports and universe and maintaining the universes and reports.
• End user Training and system Documentation.

Environment: Business Objects XI R3/R2, XCelsius 2008, Informatica 8.6, Toad, Crystal reports XI, Oracle 10g, DB2, SQL Server, SQL and PL/SQL, MS Word 2007, MS Excel 2007.

Confidential, NEWARK, NJ
AUG 2006 - FEB 2008
SR. BUSINESS OBJECTS DEVELOPER

This project was implemented to integrate member eligibility, member information, policy, customer and claims information and to calculate premiums, maintain policy information and process claims.

Responsibilities:

• Project Management, tracking & ensuring timely deliveries
• Understanding business requirements and preparing Business Requirement Specification (BRS) doc
• Interacting with the business users to finalize the BRS and get user sign off on it.
• Preparing the system requirement specification document (SRS) based on BRS and user inputs.
• Developing Business Objects universe based Design documents
• Developing Business Objects reports based on report Design documents
• Worked with Import wizard to move the objects between DEV, QA and Production systems, to create users in bulk.
• Installed the Business Objects version XIR2.
• Generated Custom variables, groups and formulas in Business Objects.
• Generated Reports on different data sources such as Business Objects Universes, Stored Procedures etc
• Created user groups/folders and managed access privileges using Business Objects CMC.
• Responsible for Business Objects repository and Audit repository..
• Extensively used Designer to design various universes for different business groups. Created complex reports using cascading prompts, decode objects etc.
• Customized Business Objects web interface (intranet) to access the enterprise reports.
• Responsible for managing the Business Objects repository.
• Created Analytics and Dashboards using Performance Manager and Xcelsius to enable executives track progress and compare current and historical performance against established targets. Worked with InfoBurst XCelsius add in.
• Used QaaWs (Query as a Web Service) and Live office to feed data into Xcelsius.
• Created Universes on top of both RDBMS systems and SAP-BW (Multi-providers, InfoCubes and BEx Queries) sources.
• Created 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.
• Resolved fan traps and chasm traps in the schema using optimal solutions accordingly.
• Developed new BO documents against existing universe including universe-based full client report and free hand SQL reports.
• Created a report like all the individual policies that covered childrens 19 & under at anytime during the last five years and this is was created in Crystal Reports.
• Effort estimation and providing it to the client.
• Assigning the tasks to offshore team members and helping them to complete it.
• Exported the Universe to the Repository using designer for users to develop their own personal reports.
• Support the development and production environment.
• End User Training and System Documentation.
• Business objects universes were modified based on the modification of oracle database.
• New reports were created based on the business requirements in Business objects and crystal reports
• Business Views were used in creation of new reports.
• Trained the new users on Business objects reports usage.
• Created Cardinalities, Contexts, Joins and Aliases for resolving loops and checked the integrity of the Universe.
• Involved in Creation of Alerters with various conditions.
• Created Dashboards using Dashboard Manager.
• Developed ad hoc and full client reports using deski and webi.
• Created Master Detail and Cross Tab reports to view the data in an analyzed way.
• Used Informatica ETL to load flatfiles data into target database(Oracle)
• Managed business objects servers
• Managed rights for business objects users in CMC.
• Maintenance and modifications in CMC
• Interact with the Business users and gather the requirements.
• Documentation of requirements and solutions.
• Created crystal reports for the finance users.
• Used Business views to develop Crystal reports

EnvironmenT: Business Objects XI R2, Crystal reports XI, XCelsius, Oracle 10G/9i, Informatica, WEBi, PL/SQL, Windows NT

Confidential, MICHIGAN
JUL 2004 - AUG 2006
DATABASE DEVELOPER

Responsibilities:

• Migrated large volumes of data from legacy systems to Oracle database.
• Extensively used SQL Loader for Data loading
• Enhancements and Functional Specifications.
• Consolidation, Cleansing, Integration, and customization of data.
• Performed Data Analysis
• Optimized Query Performance, Session Performance and Reliability.
• Created complex procedures.
• Database connectivity was done using ODBC.
• Preparation of Unit Test Plans.
• Verification of functional specifications and review of deliverables.
• Complex SQL queries were used for data retrieval.
• Involved in Data Modeling using Erwin.
• Developed Packages, Procedures and function to maintain the Business logic using PL/SQL.
• Creating Database objects including Tables, Indexes, Views, Sequences, Synonyms and granting Roles, and Privileges to the system users.
• Creating sql scripts for deployment of database objects on Production.
• Fine tuning of sql query to achieve good performance.

Environment: Oracle 8.x, PL/SQL, VB 6.0, VBA, ASP, COM (VB), HTML, JavaScript, VBScript, IIS 4.0, Visual Interdev 6.0, MS Project