SUMMARY

• Over 8 years of IT experience including both the functional and technical sides of Data warehouse engagements and Expertise with Business Intelligence Tools like SAP Business Objects, Crystal Reports and Business Objects Dashboards
• Expertise in Creating Complex Applications using SAP Business Objects Business Intelligence 4.1/4.0, Business Objects XIR3 deployment using IDT, UDT/Universe Designer, Web Intelligence (WEBI), Desktop Intelligence (DESKI), Dashboard Manager, Performance Manager
• Expertise in Business Objects Enterprise Architecture (Web component server, Automated process scheduler, File repository server, Event server, Page server, Cache server, Job server) and hands - on experience in working and implementing Crystal Reports 2008/XIR2/10/9/8, Crystal Xcelsius, Broadcast Agent, Report conversion tool, Migration Wizard
• Expertise in Application Development & Programming with substantial exposure to Quality Assurance Methodologies, and contributed in all phases of the Software Development Life Cycle (SDLC) including Analysis, Design, Coding, Testing, Implementation and Maintenance on various platforms like UNIX, Windows NT/2000/XP/98
• Experience in designing Business Objects Universes using Aggregate awareness, derived tables and linked universes, generating complex reports, business views, ad-hoc reports, dashboards, list of values (LOV) along with user acceptance test (UAT)
• Extensively used Business Objects Reporting functionalities like Slice and Dice, Ranking, Sections, Drilling methodology, Hyperlinks/Master Detailed, Filters, Graphs and Breaks
• Expertise in using Promotion Management and Import Wizard between different environments like development, testing/quality and production to migrate reports and universes
• Extensively used Central Management Console (CMC) in setting up security in Business Objects, creating users and user groups, folders, publishing reports, providing restricted access to the users as needed and also managing security configuration for various reports and universe in both development and production environment
• Working knowledge in transforming data from various data sources to a Data warehouse using Informatica Power Center/Power Mart (8.5, 8.1, 7.1, 6.2/6.1/5.1) as the ETL (Extraction, Transformation and Loading) tool in UNIX/Windows environment
• Experience in publishing the reports on web using Web Reporting tools and working with Business Explorer (BEx)
• Expertise in creating and designing the Dashboards with Crystal Xcelsius (Live Office, QAAWS) and Business Objects Dashboards for complex user requirements and experience using Dashboard Manager, Report Writer, BO Set Analyzer
• Strong understanding of the Repository Manager, Server Manager, Data Integrator Designer, local repositories, and central repositories
• Involved in developing Star-Schema Modeling, Snowflake Modeling, Logical and Physical Data modeling Dimension tables and Dimensional modeling using Erwin tool
• Extensive experience in Performance Tuning Measures like using of Aggregate Tables, and Shortcut Joins to improve performance of SQL queries and ETL process
• Expertise in writing and implementing packages, triggers, stored procedures, functions, views, materialized views, indexes at Database level using PL/SQL and oracle
• Expert in SQL Server 2008/2005 (database triggers, materialized views, In-line views, Packages, stored procedures, functions, and database constraints) and Oracle 10g/9i/8i
• Tested business objects reports for data validation and compared results with TOAD
• Worked independently and lead teams in the areas of Business Intelligence
• Ability to understand long-term project development issues at all levels, from interpersonal relationships to the details of coding scripts
• Experience in dealing with customers especially in Business Analysis and Production Support Phase
• Aptitude for analyzing, testing, identifying problems and creating solutions, excellent time management skills, good team player with excellent communication skills

TECHNICAL SKILLS

Reporting Tools: SAP Business Objects Business Intelligence 4.1/4.0,XI R3/R2, Xcelsius 2008, Crystal Reports 2008/XI/10/9/8, Web-Intelligence, SQL Server Reporting Services, CMC Performance Management.

ETL Tools: Informatica Power Center 6.2, 7.1, 8.1.

Operating Systems: WINDOWS 98, 2000, UNIX, Sun Solaris, HP-UNIX

RDBMS: ORACLE 10g/9i/8i, MS SQL Server 2008/2005 and MS- ACCESS2000, DB2.

Data Modeling: Dimensional Data Modeling (Star Schema, Snow-Flake, FACTDimensions), Physical and Logical Data Modeling, Entities, Attributes, Cardinality, ER Diagrams, ERWIN 6.1/4.5/3.5,MS Visio, DB Designer

Web Technologies: ASP.NET, Java script, XML, XSL, HTML, DHTML, JavaScript

Scripting Languages: UNIX shell scripting, Perl, PHP, AJAX, Java Script, XHTML

GUI Tools: Visual Basic 6.0, JSP, ASP, SQL Navigator, Toad.

Programming Languages: SQL and PL/SQL, C, C++, Data Structures, ASP.NET, Java.

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Sr. SAP Business Objects Developer/Team Lead

Responsibilities:

• Interacted with Business Analysts and end users to design Standard and Ad-hoc reports according to functional specification
• Involved in day to day Business Objects Server maintenance
• Responsible for maintaining Development, Testing and Production Repositories and providing round the clock support during Production stage
• Involved in conversion/up gradation of Reports from SAP Business Objects XIR3 to SAP Business Objects BI 4.0 and 4.1
• Created complex Universes and Reports and tested the Universes for Integrity and exported them to the Repository to make resources available to the users and groups
• Created classes and objects to organize the Universe
• Built queries to retrieve data through a Universe and set up query conditions in SQL using SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies
• Resolved issues like loops by creating aliases and contexts as required removing the cyclic dependencies
• Applied row level and object level securities to different groups to restrict the data in Supervisor module
• Developed General Ledger, receivable/payable, trial balance, bank/cash book reconciliation reports and all financial statements
• Generated monthly/weekly/daily sales statement by using SAP Business Objects XIR3
• Extensively used Business Objects Reporting functionalities like Filters, Graphs, Ranking, Sections, and Breaks
• Responsible for Creating Complex and Multi-Dimensional WEBI reports using Master/Detail, Cross Tab, Slice and Dice, and Sub Queries using Info view tool
• Created complicated formulae and running totals for business measure calculations based upon various end user requirements
• Created many formulas on date function, Created cascading prompts for different date range and for different location where each report can view data for one/selected/all locations
• Use open doc () functionality to pass parameters to the linked reports and open them in a new window
• Created shared variables to pass data from main report to sub report and vice versa
• Created separate commands to show LOV’s for each parameter and even used dynamic process to create list of values
• Generated sub reports, linked and unlinked reports, reports on demand
• Used prompts to generate Parameterized reports allowing the user to limit the reports to particular cases
• Created reports based on stored procedures, base tables and commands
• Developed Parameterized reports, Cross tab reports and Sub Reports involving complex formulas
• Involved in CMS setup, admin activities and configured user rights and security
• Created ICESA format of the reports where the state of SC will use this export file to get there amounts for each employee
• Raised report alerts when certain conditions are met as requested by the user
• Involved in managing users, groups, folders and published reports using Lawson Business Intelligence, in deploying and scheduling of reports using Lawson and generated WEB Reports by using Reporting Portal
• Developed WEBI and DESKI reports for GL Account Data and migrated to BOXI environment
• Deployed the reports developed using the Crystal Reports to the Repository
• Used Microsoft Visual SourceSafe to deploy the report to be published
• Worked as Lawson Business Intelligence Administrator deleing data settings, giving permissions to view/print/export data and created different user groups
• Worked on data filtering by maintaining the bursting options, Customize selection formulas, maintaining parameters, checked report actions for different users of that report
• Created all the documents for each report and deployed it in Microsoft Visual SourceSafe for further use
• Developed, tested and implemented new PL/SQL Packages, Functions and Stored Procedures, Triggers, Views etc. and written complex SQL Queries
• Created complex reports using user defined functions, condition objects and aggregate awareness functions for SQL enhancement
• Developed various Charts and Graphs like Bar Chart (Side by Side, Stacked), Line graphs, Pie Charts etc. by using Chart expert of Crystal Reports 2008
• Worked on crystal complex reports that require running totals, sub-totals, sub-reports, hierarchies, multiple groups and conditional display of groups, fields, and messages
• Used Xcelsius to create reports containing complex charts to present the end users with a better graphical representation of the data
• Extensively used various techniques in Xcelsius like Ranking, Filtering, Slice and Dice to develop the reports
• Created complex dashboards using Crystal Xcelsius 4.5 for managers and supervisors enhancing decision making
• Involved in Unit testing, System testing and User Acceptance Test (Reports) throughout the migration process
• Trained end users in basic and advanced ad hoc reporting skill
• Created Unix Shell scripts for automating the execution process
• Developed automated notification of Emails using UNIX shell script, to the users in case of failure in the process from time to time

Environment: SAP Business Objects BI 4.1/4.0/XIR3,Crystal Reports 2008/XIR2, SQL Server 2008/2005, Designer, Desktop Intelligence, Web Intelligence, Crystal Xcelsius, Info View, CMC, CMS, Informatica 8.1, SAP ECC, BeX Designer, BeX Analyzer, Oracle 9i/10g, SQL, PL/SQL, TOAD, Windows 2000/XP.

Confidential, Houston, TX

Sr SAP Business Objects Developer

Responsibilities:

• Participated in the full software development life cycle
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications about the financial system for Business Objects Universes and Reports
• Created logical and physical data models using Erwin data modeler
• Responsible for Installation of Business Objects product suite depending on business user requirement
• Created complex Universes and Reports and tested the Universes for Integrity and exported them to the Repository to make resources available to the users and groups
• Created classes and objects to organize the Universe
• Extensively used Business Objects Reporting functionalities like Master Detailed, Slice and Dice, Drilling methodology, Filters, Graphs, Ranking, Sections, and Breaks
• Created repository and security domain with user groups and security implementation
• Extensively worked in migrating SAP BO XI R2 to BO XI R3
• Maintained new and existing Business Object users
• Created many Business Objects new reports after gathering the requirements from business user or modifying the existing ones using Business Objects XI R3
• Worked on reports involving Business Objects functionalities likeAddQueries (Command), Drill down, Cross-Tab, Formulas, Parameters along with Dropdown listsetc.
• Responsible for creating the Complex Business Objects Reports (on demand, Ad Hoc Reports, Frequency Reports, Summary Reports, Drill-Down, Dynamic Grouping, Cross-Tab, Graphical, Aging Reports)
• Provided support and guidance to users, especially in creating Ad-hoc reports
• Built queries to retrieve data through a Universe and set up query conditions in SQL using SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies
• Resolved issues like loops by creating aliases and contexts as required removing the cyclic dependencies
• Applied row level and object level securities to different groups to restrict the data in Supervisor module
• Created New Universes and modified the existing Universes and used @functions like @select, @where and @prompt in the process of building the universes
• Created different types of complex reports such as Cross Tab and Charts
• Created dashboards and graphs using Crystal Xcelsius
• Design Security forCrystalXIReportsusingBusinessViews
• Published Reports in Crystal Enterprise via. Crystal Publishing Wizard and Crystal Management Console
• Developed, tested and implemented new PL/SQL Packages, Functions and Stored Procedures, Triggers etc.
• Responsible for SQL tuning and optimization using Explain Plan, TKPROF, Indexes and optimizer hints
• Created Web Intelligence and Desktop Intelligence reports with multiple data providers like Universes, Personal Data Files and free-hand SQL
• Responsible for optimization of Report queries, designed complex formulated metric objects with aggregate awareness; defined contexts for different aggregate fact tables; defined cascading prompts, created predefined filters, created user defined objects and built custom dynamic LOVS
• Tested the created reports and modified the relevant objects in the Universe
• Debug and fix production fallouts due to code glitches on a daily basis
• Worked with Central Management Console (CMC) to manage groups, users, set security levels, Publish and schedule reports
• Worked on writing time-dependent data-fix scripts to handle critical production issues
• Installing, configuring and Supporting Web Intelligence (WEBI) Server in the Windows environment
• Laid out the Text objects on the Business Objects in a visually appealing fashion using special fonts and graphics

Environment: SAP Business Objects XIR3/XIR2, Crystal Reports 2008/XI, Crystal Enterprise XI, Crystal Xcelsius, Designer, Desktop Intelligence, Web Intelligence, Info View, CMC, CMS, Informatica 8.1, Oracle 9i/10g, SQL, PL/SQL, SQL Server 2008, SAP ECC, BeX Designer, BeX Analyzer, TOAD, Erwin 6.1, Windows 2000/XP.

Confidential, Minneapolis, MN

SAP Business Objects Developer

Responsibilities:

• Created Universes using Designer according to the business requirements in BO XI R2
• Created various User defined objects including Dimensional, Detail, and Measure objects and tested them to ensure correct mapping of data
• Worked on legacy applications and modified existing Hierarchies in the universes to meet drill analysis of the user’s reporting needs
• Created new classes, objects and made structural changes to universes in Designer
• Defined Alias and Contexts to resolve loops and also tested them to ensure that correct results are retrieved
• Exported the universe to repository to make resources available to the users
• Created reports using business objects functionalities like drill down, @functions, cross tab, chart, master/detail, formulas. Created objects using case statements
• Created custom hierarchies to support drill down reports
• Responsible for designing the reports according to client’s requirement using Business Objects 6.5 suite
• Scheduled and monitored reports at the server level
• Supervised the business objects environment by monitoring /granting permissions and rights to users for viewing, creating and publishing reports and implement row and object level restrictions
• Involved in working with different database environments and in migrating the universes and reports between Production, Development, and Test
• Participated in unit testing and user acceptance testing of reports developed under UAT environment
• Involved in Unit testing, System testing and User Acceptance Test (Universes and Reports) throughout the migration process
• Created variables for user response functions, metric calculations in various web intelligence reports
• Applied security features of Business Objects like row level, report level & object level security in the universe so as to make the sensitive data secure
• Maintained universes and Object Oriented Universe Design Techniques, working knowledge of Linked Universes
• Defined Report Level Ranking, Database Ranking and Alerts in Reports based on the specifications
• Synchronized queries from multiple data providers by linking the common dimensions using merge dimensions option in WEBI
• Created Report Level Variables, Objects and Formula to create new columns based on the result set
• Created the complex WEBI reports such as Cross Tab and Master Detail Reports using the Java Report Panel
• Created a set of Adhoc reports with Business Objects and finally deployed them in Web Intelligence
• Worked closely with the end users and user decision makers to develop the transformation logic to be used in Reports
• Written test cases for the reports developed to help UAT team and end users
• Identified system errors and bugs and, reported the fixes before the deadline
• Worked with performance tuning tools to improve the performance
• Involved in preparing detailed documentation for reports, migration of reports as well as universes developed

Environment: Business Object XIR2/6.5.1, Crystal Reports XI, Crystal Enterprise XI, Designer, Xcelsius 4.5/2008, Desktop Intelligence, Web Intelligence, Info View, Informatica 7.1,CMC, CMS, Oracle 10g,SQL,PL/SQL,SQL Server 2005, Erwin 4.5, TOAD, Windows XP.

Confidential, Sarasota, FL

Business Objects Developer

Responsibilities:

• Created complex Universes and Reports and Checked the Universes for Integrity and exported them to the Repository to make resources available to the users and groups
• Created classes and objects to organize the Universe
• Managed the user, groups, repositories and the documents through Supervisor
• Created the reports using Business Objects functionality's like Queries, Slice and Dice, Drill Down, Functions, Cross-Tab, Master Detail and Formulae etc.
• Created charts, and Cross-Tab Reports using Business Objects
• Created two dashboards, one operational and another Executive dashboard
• Created a button component to refresh the QAAWS on click
• Managed 102 KPI’s and 52 metrics in the first phase of the project
• Created Master/Detail Reports, Cross-tabs, Matrix and Charts etc
• Translated business reporting requirements into data warehouse architectural design
• Tested the created reports and modified the relevant objects in the Universe
• Installed and Administered Business Objects in a Client Server Environment Developed Complex Reports
• Implemented and written the packages, triggers, stored procedures, functions, views, materialized views and indexes at database level and form level
• Created a wide variety of Charts from the table
• Built queries to retrieve data through a Universe and set up query conditions in Oracle 9i
• Used Configuration Manager to configure the server settings and to start/stop the services
• Laid out the Text objects on the Business Objects in a visually appealing fashion using special fonts and graphics

Environment: Business Objects 6.5, Business Objects Designer, Business Objects Supervisor, Info View, Web Intelligence 2.6, SQL, Oracle 9i, TOAD.

Confidential

PL/SQL Developer

Responsibilities:

• Implemented all the business requirements by writing PL/SQL stored procedures and triggers
• Involved in fine tuning stored procedures by making use of PL/SQL Collections and its Bulk Fetch and Bulk Insert features
• Created tables, views, indexes, sequences and constraints
• Involved in design and development of data validation, load process, error control routines
• Involved in gathering customer requirements and functional requirements and converting them to technical requirements
• Optimized various SQL and PL/SQL statements using Indexes, Hints and Explain Plan
• Worked on database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies
• Used SQL loader and external tables to load data from text files into the database
• Made use of the Cursors in stored procedures for report generation
• Involved in the creation and modification of different PL/SQL object like Packages, Stored Procedures and Triggers
• Extensively worked with DML Triggers
• Created UNIX shell scripts to invoke the SQL scripts which run daily
• Created stored procedures and packages with Dynamic SQL
• Performed data manipulation using basic functions and Informatica transformations
• Used workflow Monitor to monitor the performance of the Jobs
• Participated in the DBA role like creating users, granting and revoking privileges on database objects and taking backups
• Worked on application Testing, Deployment, and Production Support
• Compared Production data with Test data for identifying and cleaning corrupted data

Environment: SQL Server 2000, PL/SQL, Flat Files, TOAD, MS Visio, Windows 2000