SUMMARY

• 8+ years of IT experience in analysis, design, development, and deployment of various software applications in client - server environment including 7+ years of Experience in SAP BusinessObjects XI 4.0/XI3.1/XI3.0/XIR2/XIR1 (Designer, InfoView, DeskI/WebI, BusinessObjects Reporting, Broadcast Scheduler, CMC, Crystal Reports, and Xcelsius)
• Having over 2 years of experience using SAP Lumira, Design studio in conersion of existing WebI reports to Visualizations anlaytics.
• Recent experience includes designing large universes and creating complex WebI, Dashboards, and Lumira in version 4.1.
• Experience in BO Analysis for OLAP for highly interactive and multisource data.
• Have substantial exposure to the entire project life cycle (SDLC) requirements collection and other project management activities and providing training to the end-users
• Extensive experience in using multi sourced Data Providers from Universes, Free Hand SQL, Stored Procedures, QaawS, and Flat Files for retrieving data and development of Complex Reports
• Extensive experience in database design for data warehouses with strong understanding of Dimensional Modeling, Star and Snowflake Schemas, Dimension and Fact tables.
• Substantial experience in data integration across disparate platforms including DB2, Oracle (Unix), SQL Server (Windows) and other non-standard data sources (flat-files, etc)
• Experience in migrating Business Objects X13x applications to BO 4.1.
• Proficient in performance tuning the reports and database SQLs.
• Lead the team in all phases of reports/Universe objects deployment from Development / Post production to Production environment.
• Followed the best practices in implementing the Access level Securities manage access restrictions.
• Worked with Microsoft Live Office, Query as a Web Service as sources in creating analytics and dashboards.
• Proficient with SQL Server 2008/2005/2000 , Oracle 11g/10g/9i/6.5.1 and Teradata 11/v2r6/v2r5
• Active team player, independent problem solver, Excellent Communication skills, Interpersonal skills, self-motivated fast learner, and a good listener

TECHNICAL SKILLS

Business Intelligence Reporting Tools: SAP Business Objects 4.1/4.0/XI 3.1/XIR2, Desktop Intelligence / Web Intelligence, CMC, Crystal Report 2008/2011, Lumira/ Explorer /Crystal Dashboard Design, Dashboard 4.0

Operating Systems / Application Servers: Windows Server 2008/2003/NT/2000, Windows 7/XP, UNIX, WebLogic 10.3

Data modelling: Erwin, Power Designer - CDM,LDM,PDM

Databases: Oracle 11g/10g/9, SQL Server 2008/2005/2000 , Teradata 12.x, IBM DB2

Analytic Tools: Tibco spotfire 6.0/5.5, Tableau

ETL / Warehousing Tools: Data Stage 8/7x, Informatica 7x, DTS 2000/2005, Data Integrator 6.5, SAP Data Services, OWB 10.x

Database Utility Tools: SQL Profiler, SQL Query Analyzer, Management studio SQL Agents, SQL Alerts, SQL Jobs.

Programming Tools: PL/SQL Stored procedures, ABAP, Cobol, .Net, ASP, HTML, XML, Dream weaver, BO SDKs using Java /COM objects

Version Control: Documentum, VSS, Serena Dimensions and Data Stage Version Control

PROFESSIONAL EXPERIENCE

Confidential, Richmond VA

Sr. SAP Business Objects Consultant

Responsibilities:

• Involved in project planning, gathering requirements from the users, creating spec and layout of the report.
• Regularly discussed with DBAs and data architects to understand the data architecture
• Updated existing universes to fulfill the reporting needs of Commercial department on a weekly basis
• Developed new universes for Commercial,Treasury and Underwriting departments on XI 3.1 and XI 4.0
• Resolved universe join problems including traps and loops with aliases and contexts and derived tables to solve join problems.
• Enhance/modify existing reports by creating new Parameters, Formulas etc, Schedule the reports using Info View to run Confidential specific times in a day/week as desired by the Business Users.
• Assist BO administrator in setting up security for various reports on Enterprise
• Exported universes and assigned appropriate access rights to specific user groups from CMC
• Collaborated with an offshore development team to optimize their universe designs
• Regularly met with Financial Analysts to translate the business requirements into SQL, and eventually to universe models
• Created moderate to advanced WebI reports per user and departmental requirements in XI 3.1 and XI 4.0
• Optimize various SQL queries to make the reports run faster. Used SQL extensively in command objects of Crystal reports.
• Modify the existing reports by adding new logic and deleting existing logic as the line of Business changes periodically.
• Helped Crystal Xcelsius, Crystal XI, and Dashboard designers to resolve performance issues
• Scheduled the reports with the appropriate events for optimal performance
• Created WebI reports with aggregate awareness functions and variables for what-if ratio analyses
• Collaborated with an offshore development team to make their reports design in conformance
• Removing bugs in the report by validating the report data against the business data by running the SQL queries against the teradata and oracle.
• Building unix scripts and automizing the process to upload from Teradata to KL using a scheduler.

Environment: Business Objects 4.1 SP3, IDT, Lumira, Explorer, Crystal Reports 2011, Teradata 12x, Oracle 11.2, MS office products.

Confidential, Norwalk - CT

Sr. Business Objects Consultant

Responsibilities:

• Hands-on experience in the design and development of Universe sourced from legacy system
• Reporting-off of relational and OLAP universes
• Administered the Servers, User Groups, Users, Categories and Users Content including Reports, Universes, Publication, Program, Objects and Servers
• Involved in upgrade of BOBJ XI 3.1 to BO 4.x universes and reports.
• Migrated over 45 reports from Crystal to Webi.
• Extensively worked with SAP security team on authentications and inheriting roles and access levels in BOBJ groups/users
• Created Xcelsius dashboards analytics sourced from WebI reports / Crystal reports using live office connector and involved in deploying the reports on corporate portals.
• Design and Development of Business Objects Universes using Information Design Tool (IDT), which suits the standard, analytical and ad-hoc reporting requirements.
• Created Cardinalities, Contexts, Joins and Aliases for resolving loops and checked the integrity of the universes.
• Customized LOV’s in universes for quicker performance of reports.
• Implemented Security features of Business Objects like row level, object level and report level to make the data secure.
• Supported Business Users and Developed new and Maintained the existing Universes
• Created Multi Dimensional Reports(Full Client Reports) as per Client Requirements.
• Developed reports by building the data from Hyperion Essbase.
• Exported the Universe to the Repository to make resources available to the Users
• Created complex Reports, Sub Reports and Drill through Reports used to show details from the Cubes Create shell script to manipulate Oracle data .
• Developed extensive Business Objects reports, including complex reports using multiple queries, combination chart and tables, will setup Business Objects Universe for each reporting group Assist in establishing a Business Objects environment.
• Data Mining with Business Miner.

Environment: Business Objects 4.0/XiR3, Web Intelligence Thin/Rich client, Crystal Reports, Teradata 11x, Business Explorer 7.x, Oracle 11, ERWIN, MS-Office, Outlook, Windows NT .

Confidential, Madison

Business Objects Designer & Development

Responsibilities:

• Requirements gathering with project stakeholders and creating dataflow diagrams, functional specifications, technical specifications, security requirements and other related project management documents.
• Design and development of new Universes for sales reporting and enhancements to existing universes
• Created and maintained complex web intelligence reports for the sales team, analysts and senior management. Assisting mature reporting analysts to troubleshoot report/data issues and introducing new functions/capabilities for sophisticated reporting
• Data Analysis, and Business Objects Universe development and support
• Defined analytics for sales growth, performance, market share, price in local currency and US dollars and sales growth and market share trends
• Created advanced queries using Query as a web service. Applied Query as a web service to create Xcelsius reports from BO universe.
• Deployed dashboards in InfoView portal and also embedded as PowerPoint. Defined and implemented end user security in dashboard and in Universe.
• Worked on Corporate Analytics, Corporate Dashboards, speedometer gauge, Key Performance Indicators (KPIs), Scheduling and monitoring the jobs
• Generated Web Intelligence and Desktop Intelligence Reports using the Universe as the main Data provider.Applied Sections, Graphs,Breaks, Calculation, Report Filters and Query Filters and displayed the information in different Blocks
• Created Macros using BO SDK (VBA) to generate PDF, EXCEL files using Business Objects reports
• Used the CMC to manage the XI R3 system by creating users and groups and assigning them appropriate access rights for various BO Applications as well as documents and universes
• Creating migration cutover plan document and coordinating with the database admin team for DEV to TEST and PROD migrations
• Involved in Business Objects Clustering and performance tuning of BO XI 3.0 system
• Drafted support documents and operational manuals for post-implementation support team
• Provided training for end users for generating their own report including complicated report

Environment: Business Objects XI R3, Designer, Crystal Reports XI, InfoView, Web Intelligence, Import Wizard, CMC, BODI, SQL Server 2000, Oracle, Windows XP

Confidential, CA

Business Objects Consultant

Responsibilities:

• Requirements Gathering and Business Analysis
• Checked the integrity of the enhanced universe by analyzing additional joins, defining cardinalities, and resolving cyclic dependencies and traps
• Implemented Aggregate Awareness to enhance query performance
• Creating, maintaining and modifying the universes using Business Objects designer
• Created LOVs, cascaded, nested prompts and set up hierarchies for multidimensional analysis
• Linked different data sources to display in a block for data comparisons
• Documented and created different Canned and Ad-Hoc reports for Delinquency Reports, Reports by Period, Demographic reports and other Comparative reports in Full Client and Web Intelligence
• Involved in performance tuning of Business Objects Report which are running significantly slower
• Formatted data through various presentation styles such as charts, cross tabs, master-detail, breaks, sorts, ranking and alerter
• Implemented Slowly Changing Dimensions (SCD) methodology to keep track of historical data
• Created reports with Drill functions for multi-dimensional analysis of billings, costs, income and profitability to analyze them geographically, periodically and product wise
• Exported reports to the corporate documents, and scheduled/monitored the reports via Broadcast Agent server
• Designed various crucial reports on Billing Analysis and Accounting report etc
• Installed and configured the Tomcat / Apache web server.
• Directed migration of Reports and Universes from 6.5 to XI 3.0 using the Import Utility and conversion of .Rep (full client) reports to WEBI reports in XI 3.0 using the Report conversion tool.
• Attended user meetings to collect the data to develop reports

Environment: Business Objects XI 3.0/6.5, Designer, Reporter, Web Intelligence, Broadcast Agent Server and Publisher, Toad, Oracle 9i, Informatica, Win XP

Confidential

Business Objects Consultant

Responsibilities:

• Gathered Business Requirements, developed universe in the designer, connected to the database, Created classes and objects, joins and predefined conditions
• Created Aliases and Contexts for resolving Loops in the Universes to improve performance
• Extensively used filters, conditions, list of values (LOV), calculations, etc
• Resolved issues like Loops, Fan Traps & Chasm Traps by creating Aliases and Contexts as required in removing the cyclic dependencies
• Created Dash Boards Using Crystal Designer
• Designed Visual Display models Like Graph, Gauges Using Crystal Designer
• Used Business Objects EPM for accurate estimation of the call waiting and network traffic thereby removing the bottlenecks in the network, also used for controlling cost for new phone promotion
• Developed most of the reports with Crystal Reports tool using complex formulae with Running Totals based on Grouping, Parameters (Dynamic and Cascading prompts) and Sub-reports

Environment: Business Objects X1R2, Web Intelligence XI, Informatica PowerCenter 7.2/6.1, PLSQL, Oracle 8i, Windows NT, MS SQLServer2000, MS VISIO, MS-Office, Outlook, Shell Scripting, UNIX-HP, Windows NT 4.0

Confidential

Data Analyst/ Programmer

Responsibilities:

• Involved in Design Plan and creating logical data marts in Warehouse for Site Manager Application reports.
• Involved in modelling the tables to implement Star and snow flex schemas in the Data Marts.
• Involved in modeling the tables to implement Star and snow flex schemas in the Data Marts.
• Participated in Requirement Analysis, Design and Specifications.
• Developing SQL’s & adhoc Reports.
• Written shell scripts to EXPORT/ IMPORT data from the database.
• Developed SQL’s to load the data into UDB tables.
• Written configuration files for AUTOLOADER in UDB EEE environment.
• Created reports in Deski/WebI sourced from multiple data providers with complex queries like Unions, Intersect and sub queries.

Environment: Unix AIX, Shell scripting, Oracle 9i, UDB (Universal Database), Mainframe, MVS, COBOL, DB2, JCL, VSAM.

Confidential, Minneapolis

Mainframe Developer

Responsibilities:

• Involved in understanding the changes to be made in the programs and to carry out the changes and coding new programs.
• Analyzing the requirements of Work requests and Documentation analysis
• Development / Testing of new modules or programs
• Development of documentation for the existing or new modules
• Review the code and doing Test plan
• Problem solving on existing modules
• Performance improvement of existing functionality.

Environment: VS COBOL II, DB2, JCL, IBM 370, MVS, VSAM, FILEAID, Changeman, OS390.