SUMMARY

• A self motivated professional with more than 12 years of experience in Information Technology with skills in Report Writing and extensive Software Application Development.
• Worked in full cycle implementation of Business Intelligence projects in various capacities such as Architect, Lead and also Hands Developer.
• Experienced in interacting with business users to analyze the business process and requirements and transforming requirements into proto types, designing database, documenting and rolling out the deliverable.
• Technical hands-on expertise in Reporting and OLAP tools such as Business Objects Legacy/ XI (Designer, Web Intelligence, Info view), Crystal Reports 7/8/9/10/XI/2008, Xcelsius, Sql Server Business Intelligence Studio.
• Proficient knowledge in BO XI Architecture, Security, Authentication and new features.
• Expertise in Universe designing, developing and generating complex, Adhoc, dashboard Reports, Business views, List of values along with User Acceptance Test and data accuracy Test.
• Versatile in both Functional and Technical Fields. Can double up as a BO Administrator/Report Universe Developer/ Buss Analyst and a Tech Lead.
• Proficient in InformaticaPower Center, Business Objects 5.1.6/6.1/6.5/XI Rel2, 3.1 Data Integrator, WebI, WebiSDK, ASP, HTML and Oracle.
• Good knowledge in the field of Analysis and Design using OLAP Tools in BusinessObjects and Web Intelligence.
• Work done includes system analysis, data warehouse design and creation, Universe creation.
• Strong ability to work individually and manage the tasks based on business requirements.
• Configuration of Apache/Tomcat servers on XIR2, XIR3.1
• Excellent communication, analytical, interpersonal and presentation skills.
• Deployed to UK to support users during the go-live/production support.

SKILLS:

OPERATING SYSTEMS : UNIX, Windows NT/2000/XP, MS-DOS.
SOFTWARE : WebiSDK, VB, ASP, C, Fortran, PASCAL, HTML,
DOCUMENTUM, Test Director.
DATA WAREHOUSING : Informatica, Business Objects5.1x/6.x/XI Rel2, 3.1,
WebI, App Foundation, Dashboards, Crystal Reports
2008 & Crystal Xcelsius 4.5
SQL*Loader, Erwin 3.5.2.
DATABASES : Oracle 8i/9i/10g, DB2, SQl Server 2005, 2008
GUI/TOOLS : VB6.0, D2K.
LANGUAGES : ASP, SQL and PL/SQL
WEB : HTML, DHTML, CSS, JAVASCRIPT, XML.

EXPERIENCE:

Confidential, Austin, TX Mar 09 - Present
Sr. Bo Developer / Administrator / Architect

• Created Multiple Universes for new assignments that were being developed for different projects throughout the agency.
• Developed a macro for a single report to run for multiple account and customers and e-mail it to them as a PDF using the scheduler.
• Created customized Ad Hoc reports using the Activity Universe.
• Single point of contact for all Business Users and a mentor to the other members of the team for Dashboards, Xelcius and Devised and documented security model for Business objects.
• Created High Level Analytics for the Management Reports.
• Managed users and groups using the CMC and also used Import Wizard.
• Created Custom Access levels for different groups in CMC.
• Configured and set up the accounts to log in using SSO and WIN AD.
• As a Administrator set up security of 5000+ users and 90 + groups most of which were Win AD accounts.
• Responsible for upgrade from R2 to 3.1 and also for Migrating Users, Reports, Universes, connections from XIR2 to 3.1.
• Installed patches and was responsible for fine tuning the application for Performance.
• Troubleshoot the issues arising out of Business Objects and resolved issues on scheduled reports.
• Created and Implemented Workflows, Dataflows, develop Transformations in dataflows for the ETL process using Data Integrator.
• Worked on GL, AP, AR and AM modules of Rapid Mart and integrated the People Soft reports with the Customized Universes delivered by Rapid Mart.
• Extensively used Crystal Repots 2008. Expert in Creating Sub Reports and using various features on the tool.
• As a Business Analyst on one of the project, collected the specifications for the assignment and translated then to Technical requirements for the uses as well as doubling up as a Technical Lead.
• Worked on design documents for universe and Webi reports assigned the work to offshore and extracted quality work from them

Environment: BusinessObjects R3.1, Web Intelligence, Rich Client, Crystal Reports 2008, Dashboards, Rapid Marts, Xcesius 2008, Data Integrator, Oracle 10g, SQL Server 200/20085, IBM DB2, Windows XP/2003 server

Confidential, San Antonio, TX May 08 - Dec 08
Sr. BO Developer

• Created Dashboards using Metrics, Analytics. Designed rules for Dashboard Metrics for Call Center Metrics Analysis assignment.
• Created prototypes in Crystal Xcelsius for Business users for a high level design of Reports and Dashboards for CMS, Referrals, IEX, ACM Data sources.
• Created Universes for both Dashboards and Reports
• Worked on Hierarchies and Drill Downs.
• Used Aggregate Aware, Cascading Promtps/LOV's.
• Created reports using "Open Document" syntax to link reports and pass parameters from Master to Child Report.
• Used Encyclopedia option in WebI.
• Resolved Loops using Context and Aliases.

Environment: BusinessObjects XIR3, Web Intelligence, Dashboards/ Application Foundation, Xcelsius 2008, DB2, SQL Server 2000, Windows XP/2003 server.

Confidential, Cleveland, OH Sep 07 - May 08
Sr. BO Developer

• Created Dashboards using Metrics, Analytics. Designed rules for Dashboard Metrics.
• Proficient in Metric Universes.
• Responsible for overlooking the developing of the reports, Universes and its deliverables.
• Responsible for leading the BI team of 4.
• Responsible for collecting User requirements and translating them into reports.
• Troubleshoot rouge reports and provide solutions to them.
• Trained business users on BO.
• Performed root cause analysis on data quality issues.
• Retested corrections to ensure problems are resolved.
• Analyze and communication of data quality results to project team.
• Configured Apache 5.5 to work with XIR2 servers.
• Identify, recommend and implement process improvements to enhance data quality initiatives.
• Responsible for tuning of Universes and doing Query including performance Management.
• Used Crystal Reports in conjunction with Universes, for a few reports that we not possible using WebI.

Environment: BusinessObjects 6.5. XIR2, CMC, Web Intelligence 6.5.x, BCA, Publisher, Dashboards/ Application Foundation, Xcelsius 4.5, Crystal Reports XI, SQL Server 2000, Informatica 7.1, Oracle 9i/10g, Windows XP/2003 server.

Confidential, Wayne, IN Mar 07 - Aug 07
BO Administrator/ Systems Analyst

• Responsible for managing around 195 Universes for over 1600 users.
• Responsible for granting, revoking users privileges with a General Supervisor Profile.
• Created a Company platform for Dashboards, Universes for Dashboards, Metrics and Analytics.
• Responsible for creating Metric Universe for Dashboards
• Assisted end users in resolving errors in reports and creating Universes and performance issues.
• Managed Auditor, BCA and Admin Console for all users and reports.
• Worked on Linked Universes.
• Troubleshoot BO Admin issues.
• Responsible for 'firing' and Maintain Batch reports using Data Integrator
• Troubleshoot Publishing and scheduling the reports using BCA Scheduler.
• Adding and Maintaining External users to receive BO reports per schedule.
• Installed and Configured BO 6.5.1 International Version.

Environment: BusinessObjects 6.5., Web Intelligence 6.5.x, Data Integrator, BCA, Publisher, App Foundation, Dashboards/Application Foundation, SQL Server 2000, Windows XP/2003 server.

Confidential, Cleveland, OH Sept 06 - Mar 07
Sr. Developer

Responsibilities:

• Extensive Experience in Business Objects XIR2 (Desktop Intelligence, Central Management Console, Import Wizard, WebI XI, Report Conversion Tool and Designer)
• Created Universes, Web Intelligence, Desktop Intelligence, OLAP reports in Business Objects XIR2.
• Custom based Dashboards for reports on XI R2.
• Migrated Desktop Intelligence reports into Web Intelligence reports in Business Objects XIR2.
• Providing the facility to export the data from WEBI and Business Objects to Excel
• Created OLAP Business Objects Reports connecting to OLAP Cubes (Microsoft Analysis Services).
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @Functions, Cross Tab, Master/Detail and Formulas, Predefined filters etc
• Responsible for creating multiple Document Domains/ Universe Domains.
• Worked on Free Hand SQL Reports.
• Responsible for creating Applications, Dashboards, Metrics, Menus, Rules, Alerts and Analytics using Application Foundation 6.5/6.1b and Performance Management XIR2
• Developed reports using Crystal Reports XI with Parameters and Sub Reports/Embeded reports.

Environment: BusinessObjects 6.5.1/XI Rel 2, Web Intelligence 6.5/XIR2, App Foundation, Crystal Reports XI, Oracle 9i, Windows XP.

Confidential, Indianapolis, IN Dec 04 - Sept 06
Associate Systems Analyst

Responsibilities:

• Created classes and Objects (Dimension, Detail and measure Objects).
• Designed Universes.
• Modified Universes with pre-calculated aggregates from summary tables.
• Set up groups and users for Business Objects deployment. Managed user profiles using Supervisor.
• Unit Tested the applications using Test Director.
• Designed and Documented the Functional and Technical specifications.
• Used DOCUMENTUM for version control and uploading the Technical and Functional Specifications into the global system.
• Extensively worked in Creating and Maintaining Users and User Groups based on roles and permissions with Supervisor on both Dev and PRD environment.
• Extensively worked with Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Worked on various transformations like Lookup, Aggregator, Expression, Router, Filter, Update Strategy, and Stored Procedure.
• Used workflow monitor to monitor the jobs, reviewed error logs that were generated for each session.
• Created Dashboards, Analytics, Metrics using Application Foundation.
• Solely responsible for support for European users during go-live.

Environment: BusinessObjects 5.1.2/6.5.1/XI Rel 2, Web Intelligence 6.5, App Foundation, Informatica 7.1, Oracle 9i, VBA, WEBI SDK, Broadcast Agent Server, Test Director, Documentum, Windows 2000/NT 4.0.

Confidential, MD Feb'04 - Nov 04
Programmer Analyst

Responsibilities:

• Extensively worked on requirement analysis and preparation of System Requirement Specification (SRS) by having the interaction with the client
• Responsible for the installation of Business Objects (Desktop Products and Enterprise server products).
• Done restructuring the database.
• Involved in transforming the data from the different data sources in the target database by using Informatica (PowerMart / PowerCenter).
• Extensively worked in Creating and Maintaining Users and User Groups based on roles and permissions with Supervisor.
• Created and maintained the Universes using Designer and distributing the universes to end-users.
• Involved in creating classes and Objects (Dimension, Detail and measure Objects).
• Resolved the Loops by creating Joins and Aliases and checked the integrity of the Universe.
• Providing the facility to export the data from WEBI and Business Objects to Excel
• Developing stored procedures triggers to get the data from the database to the reports.
• Customizing the Business Objects by Using VBA (Visual Basic for Applications).
• Extensively worked in the preparation of Test Plans, Test Cases, and Test data.
• Worked extensively with Source Analyzer, Warehouse and Mapping Designers.
• Analyzed the source data, deciding on appropriate extraction, transformation and loading strategy.
• Extensively worked with Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Worked on various transformations like Lookup, Aggregator, Expression, Router, Filter, Update Strategy, and Stored Procedure.
• Used workflow monitor to monitor the jobs, reviewed error logs that were generated for each session.

Environment: BusinessObjects 5.1.6/6.1, Web Intelligence 2.6, Oracle 8i, Informatica (Power Mart/ PowerCenter) 6.1, VBA, WEBI SDK, Broadcast Agent Server, Windows 2000/NT 4.0.

Confidential, NJ Mar 03 to Dec'03.
Programmer Analyst

Responsibilities:

• Generated various reports as per the client's requirements
• Used Business Objects 5.1 for developing reports
• Creation of the Universe with Classes, Objects and Condition objects
• Developed complex queries using different data providers in the same report
• Produced Reports and exported to Excel based on the user requirements.
• Exported the Business Objects reports to WEBI 2.6 to be viewed by all users on the intranet
• Plan, coordinate and execute Business Objects 5.1.6 deployment for End users Documented the entire project.
• Scheduled Reports using Broadcast Agent and used the Business Objects Server Administration Tool.
• Worked with supervisor module in creating users and users groups for different areas and setting privileges to them.
• Used ETL using Informatica ( Power mart) to load data from MS SQL Server 6.5 to the target Oracle 8i.
• Created Informatica mappings with PL/SQL procedures/functions to build business rules to load data.

Environment: Business Objects 5.1.6 Designer, Supervisor, SQL, PL/SQL, Informatica PowerMart 5.0, Web Intelligence 2.6, Broad Cast Agent 2.6, IIS Server5.0, Webi SDK, MS SQLServer6.5, Shell Scripting, Windows NT 4.0.

Responsibilities:

• Used Business Objects Designer for designing new Universes, Modifying the existing Universes, using features like Cardinalities, Aliases, Loops, Contexts, Joins and finally creating the Objects which are grouped into Classes
• Worked on Business Objects for creating reports using various features like Master/Detail, Charts, Cross tabs, Slice-Dice and Drill Down.
• Used Business Objects Supervisor for creating and managing the users, user groups, also giving access permissions for Business Objects Reports.
• Scheduled the jobs in Broadcast Agent server.
• Modified workflow for prompted reports to change prompt presentation and appearance.
• Worked on VBA Macro's.
• Tested fully all the generated reports to make sure the data accuracy and meeting the specifications given by users.
• Extensively used Business Object functionality at Universe as well as Reporting Module Level. Responsible for publishing & Migration of reports in Dev /Test to Production Domains

Environment: BusinessObjects5.1.2, Web Intelligence 2.6, Oracle 8.0, ERWin3.5.2, VBA, Broadcast Agent Server, Windows NT 4.0 and Internet Information Server (IIS), Visual Source safe

Confidential, CA Aug 01 - April 02

Responsibilities:

• Installed and Administered Business Objects 4.0 in a Client-Server Environment. Developed Complex Reports.
• Created Charts, and Cross-Tab Reports using Business Objects.
• Created, managed and formatted standard reports, master/detail reports and cross tab reports using Report Manager.
• Setting up groups and users for a Business Objects deployment, organizing and changing user properties using Supervisor.
• Implemented complex Formulas and Business Logic in Business Objects 4.0
• Designed Business Objects repository for building a Business Objects solution.
• Worked extensively on Designer and Supervisor modules of Business Objects.
• Published and scheduled Business Objects Reports to users using Scheduler.
• Implemented complex Formulas and Business Logic in Business Objects 4.0.
• Developed test plans, test cases, test requirements, test scenarios and test data for use during system, platform and upgrade test phases.
• Performed automated and manual testing against our products.
• Developed Functions and Procedures using PL/SQL.
• Modified and wrote Packages in PL/SQL 8.0.

Environment: Windows NT, Oracle 8 and MS SQL Server 6.5, Business Objects 4.0.

Environment : Visual Basic 6.0, ASP, Oracle8.0, HTML, DHTML, Java Script, C.S.S,
M.S.Access, XML and XSLT, Clear Case, Crystal Reports 7.0 and IIS.

This is an on line shopping cart project developed for the leading store in women's apparel. Shopping can be done in two modes namely anonymous or as a registered user. It is during the checkout process that we can identify if the user is registered or is logged in as an anonymous user. Checkout is not possible unless the user registers him.

• Designed front-end Screens end using HTML and DHTML and Cascading Style sheets.
• Client Side validation using Java script.
• Design and Development of COM Objects.
• Retrieving the data from the back-end by writing PL/SQL queries and Stored Procedures.
• Development of Active X Controls.
• Developing Internet Applications using ASP and Visual InterDev.
• Access of database applications using Oracle, ADO and ODBC.
• Created complex data warehousing reports using Crystal Reports.7.0.

Web Based Financial Investment Apr '00 - Dec '00
Client:Confidential, N.Y.

Environment : Visual Basic 6.0, HTML, Dream Weaver, Crystal Reports7.0, JavaScript,
M.S.Access, SQL Server6.5, ASP, ADO, IIS, Visual Interdev.

This is a site where entrepreneurs, investors meet and exchange ideas. The basic aim of the site is to target the angel investors, who provide the initial funding when the projects are in the nascent stages. The entrepreneur, when he has an idea and does not have the required amount of funding puts his idea up in the site for the investors to look at it. The investor is asked to sign a confidentiality agreement before he gets to see what is known as the elevator pitch. When any accredited investor likes the site he forms a group of his own and sends an invitation to other members of his group through an email. Depending on the size of the project and the funding, the initiator can extend, as may invitations he would like to. Complete security is provided for the entrepreneur who has to safeguard the plan.
Active Server Pages (ASP) were developed for creating interactive web pages. JavaScript was used for data validation

• Designed front-end Screens end using HTML and DHTML and Cascading Style sheets.
• Client Side validation using Java script.
• Design and Development of COM Objects.
• Retrieving the data from SQL Server by writing PL/SQL queries and Stored Procedures.
• Development of Active X Controls.
• Developing Internet Applications using ASP and Visual InterDev.
• Access of database applications using SQL Server, ADO and ODBC.
• Generation of reports using Crystal Reports 7.0.

Web Based Application Development Sep '97 - Feb '00.
Client : Confidential, INDIA

Environment : Visual Basic6.0, Oracle, ASP, HTML, ADO 2.0, M.S.Access, JavaScript,
VBScript, Windows NT.

This is a Web Site for Sequel Soft, a company dealing in Software development. The Main Idea of this Web Site is to give Vast Information on the Company, its operations and services. A user can browse through the site and he/she can get Information about the services provided and he/she can take. A page has been provided for the job opportunities in the company. Each individual page of the company tells about the unique feature of the company. The user can leave behind a resume and a mail address for the company to contact the respondent.

• Designed front-end Screens end using Java Applets and DHTML and Cascading Style sheets.
• Client Side validation using Java script and Server Side validation using VB script.
• Developing Internet Applications using ASP and Visual InterDev.
• Access of database applications using Oracle, ADO and ODBC.

Environment : Oracle 7.1, M.S. Access, C++ and Visual Basic 4.0

This project calculates loss or gain in daily production plan for each product. This project also generates product wise report. It maintains master file for production details and a transaction file for day plan.

References:
Available upon request.