SUMMARY

• Around 8 years of total experience, of which, 5 yrs of IT experience with strong background in Business Objects as a developer and a business analyst. I have extensively worked on various versions of Business Objects including 4.0/XI3.1/XIR2,Web Intelligence4.0/XIR3/XIR2, Business Objects Designer 4.0/XIR3/XIR2 and also the new Information Design Tool (IDT) in 4.0.
• 3 years of experience of dynamic, result oriented experience in development, testing and implementation as a PL SQL developer and a business analyst. I have hands on experience in Procedures, Triggers and free hand SQL
• Extensive Experience in Creating Web Intelligence/Full Client/Desktop Intelligence/Dashboard Reports in Business Objects 4.0/XIR3/XIR2
• Worked on Web Intelligence to develop and publish thin client reports.
• In - depth knowledge in creation of WEBI reports using Crystal Reports
• Expertise in retrieving data using Business Objects Universes, personal data files, stored procedures and free hand SQL methods.
• Knowledge in Data Modeling using Dimensional Data Modeling, Star Schema Modeling, Snowflake Schema Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling
• Utilized all business objects tools including CMC, Supervisor, Designer, BO Reporter, Web Intelligence, Broadcast Agent, BCA Publisher, Configuration tool, Performance Manager, Dashboard Manager, Import wizard, Data Integrator, Upgrade Management Tool in various projects
• Good Experience in maintaining and scheduling reports in production environment and supporting users in creating Web Intelligence reports and administering the BO activities
• Accomplished several projects governed by full SDLC model, from Requirement gathering, Analysis, Planning, Designing, Development, Test and deployment to production.
• Experienced in gathering, analyzing and documenting business requirements, functional requirements, and data specifications for Business Objects Universes and Reports.
• Experienced in understanding user requirements and develop reports using Crystal Reports in a Web Environment.
• Experience in creating Repositories, designing Universes, Full Client/WebI reports, publishing and scheduling using Broadcast Agent for publisher and scheduler
• Experience in user trainings and gathering user requirements, Working with executives and providing technical support to users by directly interacting with Business Objects technical support team.
• Experience in using Oracle 10/9i/8i, DB2, SQL Server and Basic UNIX commands
• Hands on experience in creating Tables, indexes, Primary /Foreign keys, Procedures, Triggers, Views, Materialized Views
• Strong analytical, problem solving skills.
• Experienced in deployment of Business Objects & Web Intelligence from various data sources such as MS SQL Server, Oracle, DB2, Flat files and MS Access.
• Extensive experiences in developing Stored Procedures, Views, Functions, Triggers and complex queries on Oracle and SQl Server.
• Efficient in Optimizing, Debugging and testing SQL queries and stored procedures
• Experience in tools like Toad, Eclipse, PL SQL developer, Citrix, WINSCP, SSH Tectia, Putty, SOAP UI
• Excellent communication skills, strong decision making skills, organizational skills, and customer service oriented
• Unique ability to understand long-term project development issues at all levels, from interpersonal relationships to the details of coding scripts. A strong team member with good Communication and Analytical skills.
• Experienced in conducting requirement analysis, designing test plans
• Ability to gather business and technical requirements from both formal and informal sessions utilizing a variety of software tools including, Use Cases and the Rational Unified Process.
• Skilled in various MS Office tools including MS Visio and MS Project, Sharepoint.
• Experience in assisting user acceptance/end to end testing and user training for customers.
• Modelled requirements managed and communicated requirements throughout the project life cycle, performed Gap and Impact Analysis against requirements specifications to determine fit.
• Experience in working with Informatica Power Center 9.5 Client tools
• Experienced in loading data, troubleshooting, debugging mappings, performance tuning of Informatica (Sources, Targets, Mappings and Sessions) and fine-tuned transformations to make them more efficient in terms of session performance.

TECHNICAL SKILLS

Business Object (BO) Tools: SAP Business Objects 4.0/XI R3.1, Web Intelligence 4.0/XI R3,Designer, Desktop Intelligence XIR3, Crystal Reports 2008/2011, Dashboard Design(Xcelsius) 2008/2011

Languages: SQL, PL/SQL, SQL Server, HTML, XML, DB2, Basic commands in UNIX

Database/ Database Tools: Sybase, Oracle, DB2, Pl/SQL developer, Toad, Rational Clear Case, Mercury Quality Center 9.0, Oraxcel, Test Director, RFT, Putty, WINSCP, RFHUTIL, SOAP, Teradata,, Informatica Power Center 9.5

Operating Systems: Windows9x/NT/XP/Vista/7/Unix

PROFESSIONAL EXPERIENCE

Confidential, Enfield, CT

Business Objects Developer

Responsibilities:

• Created new reports after gathering the requirements from business user or modifying the existing ones using Business Objects XI R2
• Developed several complex reports (detailed, summary reports, on-demand, drill down, Top N, Adhoc reports, sub reports, dynamic grouping, Cross-Tab, graphical reports including parameter fields, formulas and retrieving data from more than one database) using Deski and Webi
• Tested the aggregate awareness to ensure the query is pulling correct level of aggregation.
• Worked with the testing team to derive test cases for efficient Data reporting.
• Created user Prompts, conditions, and filters for various reports to specify the reporting parameters as per business requirements.
• Was Responsible for preparing the User Requirement Specifications, Design Documents, Technical Specifications.
• Performed Unit testing and System testing of the developed reports.
• Tuned and Enhanced Universes with SQL Queries for the Report Performance.
• Engaged in daily team meetings to review the status of the reports being developed.
• Responsible for SQL tuning and optimization
• Created JILs for Autosys migration of the reports
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target in Informatica.
• Used Informatica Designer to create mappings using different transformations.
• Created Queries in Teradata as per the mapping requirement
• Perform Gap analysis and Data Gathering for business functional elements to assess the behavior patterns of the customers.
• Initiated group meetings, for High Level Design (HLD), IS Review and Business Review.
• Conducted JAD Sessions and interviews with stakeholders and business users
• Designed, gathered and analyzed user report requirements, meeting business for gathering user requirements.

Environment: Web Intelligence XIR3, Designer, Desktop XIR3, Putty, Toad, FTP Pro, Informatica, Unix, Teradata

Confidential, Charlotte, NC

Business Objects Consultant /Analyst

Responsibilities:

• Perform Gap analysis and Data Gathering for business functional elements to assess the behavior patterns of the customers.
• Initiated group meetings, for High Level Design (HLD), IS Review and Business Review.
• Conducted JAD Sessions and interviews with stakeholders and business users
• Worked on different Software Development Life Cycle Methodologies like Agile (Rapid Application development) and Waterfall model
• Designed, gathered and analyzed user report requirements, meeting business for gathering user requirements.
• Created new reports after gathering the requirements from business user or modifying the existing ones using Business Objects XI R2 and Crystal reports.
• Worked on installation and configuration of Business Objects XI Rel2 Enterprise Suite (Desktop Intelligence, Central Management Server, Central Management Console, Auditor and Dashboard Manager).
• Developed several complex reports (detailed, summary reports, on-demand, drill down, Top N, Adhoc reports, sub reports, dynamic grouping, Cross-Tab, graphical reports including parameter fields, formulas and retrieving data from more than one database) using Crystal Reports2008.
• Created the new Views and Aggregate tables for report performance.
• Designed Business Views using Business View Manager.
• Created complex reports and user objects like measure objects by using @aggregate aware function to create the summarized reports.
• Tested the aggregate awareness to ensure the query is pulling correct level of aggregation.
• Worked extensively with @functions (@aggregate aware, @select, @prompt, @where) in the creation of dimensions, measures and conditions and setup Hierarchies for Multi-dimensional Analysis
• Worked with the testing team to derive test cases for efficient Data reporting.
• Created user Prompts, conditions, and filters for various reports to specify the reporting parameters as per business requirements.
• Developed crystal reports for deployment at departmental level for the easy of end user.
• Was Responsible for preparing the User Requirement Specifications, Design Documents, Technical Specifications.
• Performed Unit testing and System testing of the developed reports.
• Tuned and Enhanced Universes with SQL Queries for the Report Performance.
• Engaged in daily team meetings to review the status of the reports being developed.
• Worked with Central Management Console (CMC) to manage groups, users, set security levels, Publish and schedule reports.
• Responsible for SQL tuning and optimization using Explain Plan, Indexes and optimizer hints.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-
• Schema Modeling, Snowflakes Modeling, fact and dimension tables, Pivot Tables, modeling of data at all the three levels: view, logical & physical
• Experience in SQL server Reporting services

Environment: Intelligence SAP BusinessObjects 4.0/XI R3.1/R3.0/R2, Web Intelligence 4.0/XIR3/ XIR2, Designer, Desktop XIR3, Crystal Reports 2008/2011

Confidential, Charlotte, NC

Business Objects Consultant

Responsibilities:

• Migrated universes, reports and security domain from 6.5 to Business Object XIR3 Using Import Wizard
• Produced technical document and user manual for migration from one built to another built of Business Object
• Converted Deski (Desktop Intelligence) reports to Webi (Web Intelligence) reports using Report Conversion Tool
• Used Crystal Report XI Enterprise to design the front end reports
• Created complex Xcelsius dash boards to reflect User Adoption Metrics.
• Used Web connector in Xcelsius to import data from QaaWs.
• Maintained business and process metadata collected for data related Work Flow Enhancement projects within Bank tools Business Objects, and or designated bank database.
• Configured the Webi, Deski Server. Configured Apache Tomcat, IIS 6.0, VM Ware.
• Created different CMS clusters and also different server groups to gain performance.
• Set up LDAP and NT authentication for Crystal and Business Objects users.
• Analyzed specs and database model to generate the reports for the sign-off specs
• Wrote procedures for the complex reports and list of values for the parameters
• Established user groups and users and assigned privileges.
• Wrote functions to reduce code in procedures like Address, Full Name, Active members
• Created Business Objects Web Intelligence & Desktop Intelligence reports and published on the INFOVIEW.
• Involved in migration and deployment of the universes and reports across multiple repositories.
• Published report to Enterprise server, to get the report access from INFOVIEW.
• Used Team Track to track the status of the report by developer, state and comments.
• Created reports using Crystal Reports with Standard, Summary, Cross Tabs and Grouping.
• Worked in Crystal Reports including creating reports from various formats including: Access, SQL, Oracle, XML, Txt files etc. Optimized Crystal Reports performance for large reports(reduced page generation time)
• Prepared user documentation for hands on training for end user community
• Created alerts, breaks, filters and ranks in the report
• Actively worked with the ETL team on tools like Informatica and Business objects Data integrator

Environment: SAP BusinessObjects 4.0/XI R3.1/R3.0/R2, Web Intelligence 4.0/XIR3/XIR2, Designer, Desktop Intelligence XIR3, Crystal Reports 2008/2011

Confidential

Business Objects Developer

Responsibilities:

• Designed and implemented oracle based security in Business Objects
• Resolved Loops using Aliases and Context, Addressed chasm trap and Fan Trap using Multi Parse SQL
• Created Crystal Reports using Crystal Reports formulas, grouping, parameters and Static/Dynamic Cascading prompts to handle the customer’s requests from tables, stored procedures, and views.
• Developed Complex Reports that involved multiple data providers, Master/Detail charts, cross tab, bar charts, pie charts, complex variables and calculation contexts.
• Created Custom Hierarchies for several groups
• Was involved in Star Schema customization / Design session
• Oversee daily activities of the project SDLC process and coordinate activities of team members, ensuring that module goals are met within predetermined time frames. Provide the first level support to approximately seven groups
• Design and develop the best practices
• Implemented the minimal customizations of Info View in XI R2
• Co-ordinate with MSI team on Business Objects full client deployment
• Developed reports in Desktop Intelligence & Web Intelligence XIR2
• Participated in designing the Oracle to Business Objects XI R2 Security Bridge.
• Wrote a full functional specification document for the security to be implemented in Business Objects XI R2.
• Acquired an excellent understanding and work experience of EXCEL functions in Xcelsius
• Developed reports in Web Intelligence. Created complex Universes and reports to the management
• Designed and Developed Xcelsius dashboards / analytics and exported to several formats
• In Xcelsius used single value, selector, mapped, chart, background, collaboration and text components
• Migrated repositories from Development, System Test, Performance Test, UAT, Production, SLA and to Disaster Recovery using migration tool by creating BIAR files and moved it to the Destination System
• Help client to deploy Business Objects XI 2.0 on 7 different environments (Development, System Test, Performance Test, UAT, Production, SLA, Disaster Recovery)
• Used Data Integrator to Import data from various sources into data warehouse

Environment: SAP Business Objects 4.0/XI R3.1/R3.0/R2, Web Intelligence 4.0/XIR3/XIR2, Designer, Desktop Intelligence XIR3, Crystal Reports 2008/2011

Confidential

Business Analyst, Team Member, Project Leader.

Responsibilities:

• Handling Change Requests (Gathering Requirements, Impact analysis, Design, Testing and Implementation).
• Coding for the requirements specified through the CRs.
• Feasibility analysis and Implementation of New Functionalities.
• Develop new Procedures, Triggers, tables
• Usage of Indexes on existing tables
• Create relational tables using Foreign keys
• Create views and Materialized views
• Promotion of code to different environments once it is reviewed and checked in Clear case
• Create and modify tables in Teradata
• Modify procedures, triggers to implement enhancements
• Manage production tickets based on severity and priority
• Peer review the modified code
• Support test teams during execution period
• Creating Cron scripts regularly.(required for batch process)
• Performing Causal Analysis and providing permanent solutions to the problems identified.
• Improved the performances of Critical Processes in TTSL.
• Preparation Test Plan and Test Cases. The software is tested as per the test plan and the results are documented.
• Supporting Quality and UAT activities.
• Conducting Quality reviews of test plans
• Design and implementation of a standard testing process that is repeatable, traceable, measurable
• Effort estimation within the team
• Perform Feasibility analysis on the requirements

Environment: Oracle PL/SQL, SQL server, UNIX Shell Scripting, WINSCP, Putty, Eclipse, SOAP UI, Rational Functional Tester, SSH Tectia, Teradata, PL/SQL Developer, Tool for Oracle Application Developers, Rational Clear Case for version control, Mercury Quality Center 9.0