Summary: 

§      Over 8 years of total IT experience in the Analysis, Design, Development and Implementation of Relational Database (OLTP) and Data Warehousing Systems (OLAP) using Oracle, Business Objects, Informatica and Datastage

§      Around 5 years of Business Objects, Brio,Actuate,Cognos experience using Business Objects Administration , Web-Intelligence , BO Developer Suite using SDK, Application foundation,.Broadcast Agent, Auditor, Web Admin tool, Supervisor, Designer, Web Intelligence/Info view

§      Around 3 years of experience with ETL tools such as Data Integrator,Data Stage Informatica(Power Mart/Power Center)

§      Strong in conceptualizing and communicating enterprise data architecture frameworks for global enterprises for inter operation of data warehouses, middleware, and web applications.

§      Around 6 years of high-end programming experience using PL/SQL,SQL*Loader, ODBC, SQL Navigator , Toad , Developer 2000, Visual Basic, Korn Shell, Unix Shell Scripting Win NT and Sun Solaris.

§      Provided 24X7 support to the users.

§      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 skills.

Technical Skills:

Reporting Tools             Business Objects XI/6.5.1/6.1b/5.x/4.0 (Desinger,Reporter,Supervisor) ,Web Intelligence/ Infoview 2.x ,Broadcast Agent, Auditor,Application Foundation 6.51,Webi SDK,BO SDK using ASP and JSP,Actuate,Brio,Cognos

ETL                                Datastage 4.x/5.x/6.x/7.x, Informatica 6.0(Power Mart & Power Center)

RDBMS                       DB2,Oracle 9i/8i/7, MS SQL Server 2000, DB2, MS-Access.

Internet                         J2EE, XML, Java Beans, Servlets, JSP, ASP, VBScript, JavaScript, Visual Studio 2003

Languages                       Java2, PERL, C++, C, VB, Shell Scripting

OS                                  Sun Solaris UNIX, Windows NT/2000.

Servers                         WebLogic Application Server 6.1 / 5.1 / 4.5, WebSphere 4.0.2/3.02, TOMCAT 3.2.1.

Tools                               ERwin 4.1/4.0, MS Project, Jbuilder4, Clearcase,TOAD 6.5 and SQL Navigator 4.1

Work Experience

XXXXX, Chicago, IL                                                                 Jan 06 to Present

Sr.Business Objects Developer

• System study, interaction with users & management, performance of analysis, designing, coding, and testing & implementation of the system.
• Involved in implementation of SDLC Life Cycle.
• Implemented Best Practices for Using Business Objects Suite of Products.
• Conducted meetings with management and user community to understand there requirements and convert Business requirements into technical specifications.
• Facilitate with tech Support to Formulate a Strategy for Implementing good User support.

• Responsible for designing Data warehouse schemas using Erwin.
• Developed Functional (Business terms) and Technical Design documents.
• Involved in developing Logical and Physical Data Models.

• Installation & Configuration of Business Objects XI/11 Enterprise Suite of Products.
• Installed & deployed Business Objects crystal Integration Pack.
• Imported data from Business Objects 6.5 & Crystal Enterprise to Business Objects Enterprise XI
• Installed and set the Central Management Server, Processing Servers & Report Application Server.
• Worked on Business views and Universes to Business Objects XI.
• Worked on Universes and Connection management process.
• Edited reports in interactive view format.
• Designed crystal reports with dynamic content & Custom UI.
• Defined Business Views for crystal reports development.
• Scheduled crystal reports and Implemented dynamic cascading prompts.

• Configuring BO Server Products  like WebI and BCA Publisher & Auditor on different nodes in Distributed Environment.
• Defined business standards, data standards, data mining patterns with Business Objects Miner.
• Instrumental in Starting the Dashboard Reporting structure to visualize KPI’S.
• Designed architecture & set up for development, production & test repositories.
• Trained the user community in making use of universe to create and publish reports.

·         Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate     conditions, parsing of objects and hierarchies. 

·         Designed Test cases for UAT of Reports for end users.

·         Implemented application foundation with dash board manager.

·         Designed dashboard reports and scorecard formats with process analytics.

·         Defined metrics with goals for predictive analysis and set analysis.

• Designed set analytics, Process Analytics & Performance Analytics.

·         Prepared user documentation for hand on training for en user community.

·         Designed Production System support and handling opened user cases.

·         Tuning of SQL queries for better performance.

·         Implemented Clearecase front office tool for customer tracking customer problems on daily basis.

·         Creation of different types of reports, such as; Master/Detail, Cross Tab and Chart (for trend analysis). Use of filters, conditions, calculations, etc.

·         Written VBA Macros for certain business validations and data verifications.

·         Use of Analyzer and Explorer to view reports from different prospect (Slice and Dice and Drill down).

·         Defined ASP pages and integrated with webi reports.

·         Macro coding using VBA for scheduling of documents thru BCA Server and BOSDK.

·         Scheduled reports to run and refresh daily using Broadcast Agent Server.

·         Testing of Reports and deploying over web.

Environment: Erwin 4.0,Business Objects XI r1/r2/6.5.1(Designer, Reports, Supervisor,Miner), Web Intelligence, ZABO, Broadcast Agent Server, Crystal Enterprise,AIX 5.1,TOAD, Clearcase ,Oracle 9.2, VBA, PL/SQL., WEBI SDK, ASP, Application Foundation 6.51, SQL Navigator 4.1

XXXXX "Westren" XXXXX,WI                                                                                                    Sep 04 – Jan 06

Sr.Business Objects Developer

• Created Universes (Classes and Objects)
• Created users using BO Supervisor.
• Involved in development of reports like Balance Sheet Reports, Income Statement Reports, Account Analysis Reports, Cost-Detail reports, Executive Reports and Web-Part Reports.
• Involved in Writing the Detail Level Documentation for most of the report families.
• Used Data Providers like Freehand SQL and Universe for development of the Reports.
• Involved in developing both static and dynamic reports.
• Defined data patterns and data mining methodologies with business objects miner.
• Involved in Developing the WebI Dynamic Reports and WebI Static Reports.
• Used cam star live view reporting tool for agency CAN reports.
• Designed reports against MS access data base.
• Exported data from BO to excel sheets and automated with VBA code
• Involved in deploying the reports to the Repository through Broadcast Agent Server.
• Defined the Custom Scope of Analysis for the Development of Drillable Reports.
• Analyzed and Explored reports using Slice and Dice and Drill Down functionality.
• Automated document Scheduling, Publishing and Distribution for Web I and Info view clients, using the Broadcast Agent for Web-Part Reports.
• Applied breaks on Balance Sheet reports to get appropriate results.
• Applied Sectioning on Income Statement reports to get the required result.
• Involved in Writing the Unit Test Plans, System Test Plans for most of the Reports.
• Tracked the issues and comments of the reports through Mercury’s Test Director.
• Involved in resolving issues relating to pre implementation of Reports.

·         Involved in Business Objects reports query optimization.

·         Modified Universe for Ad-hoc reporting.

·         Installed webi & BCA on sun solaris machine.

·         Customized webi interface with java, JSP with WI BEAN component.

·         Implemented report bursting.

Environment: Business Objects 6.1b/5I,MS Access, Excel, Miner,SQL*Plus,  Web Intelligence 2.7 , DB2 , AIX 4.3.3/5.1, Orchestrate Data stage 6.0/7.0, Meta stage 6.0/7.0, Toad 6.5 , Java, JSP & WI BEAN.

XXXXX, MO                                                                                                  Jun’02 to Sep 04

Title : Sr.Business Objects Developer

• Set up & architectured for ETL load process.
• Designed Star schema for DB2 data ware hose & Marts.
• Designed Informatica mappings and sessions for batch loading of data to DB2.
• Set global informatica repository on DB2 for whole enterprisewide.
• Developed Repositories for Business Objects set up.
• Maintained Meta data in the repository.
• Optimized the DB2 database for better query response time.
• Documented all meta data dictionary
• Developed Complex Security set up for end users with Supervisor.
• Defined categories of documents for different level of groups.
• Installed the BO&WEB Intelligence on cluster environment.
• Installed & configured cam star live view on Unix Server.
• Integrated cam star with Business Objects reports data.
• Designed universes against MS access data base & designed Reports against MS Access data base.
• Developed several Oracle stored procedures and functions for reports.
• Installed BCA server on distributed environment
• Used UML diagrams
• Implemented report bursting feature.
• Designed Universes for Financial Billing system and Order processing.
• Worked on Linked Universes by kernel approach.
• Designed Universe for Ad-hoc reporting.
• Exported data from BO reports to excel sheets and Ms Access database for data validations
• Implemented application foundation for dash board reporting.
• Developed dash board reports with application foundation.
• Developed Full client reports and webi reports.
• Customized webi by using WIBEAN component.
• Written java code and designed JSP & servelets for webi portal integration.
• Linked webi reports for different hierarchies.
• Development, Testing & QA for all reports.

Environment: Informatica 5.x/6.x, cam star live view,Business Objects 5.1.7, Web Intelligence 2.7.2, Application foundation,JSP,JAVA, SERVELETS, DB2, Visual Studio 2003,MS Access, Ms Excel & VBA

XXXXX,CT                                                                                    Jan ’01 – Jun ’02

Title : Sr.Business Objects Developer

• Conducted JAD sessions for end user for requirements.
• Involved in system analysis and design of the Data warehouse.
• Prepared Business model,logical & Physical models.
• Designed ETL process , architecture & specifications.
• Used Data Stage tool for ETL data loads to DB2 data mart.
• Implemented security structures with data stage administrator.

• Developed Functional (Business terms) and Technical Design documents.
• Involved in developing Logical and Physical Data Models.

• Developed Repositories for Business Objects set up.
• Maintained Meta data in the repository.
• Documented all meta data dictionary
• Developed Complex Security set up for end users with Supervisor.
• Defined categories of documents for different level of groups.
• Installed the BO&WEB Intelligence on cluster environment.
• Developed several Oracle stored procedures and functions for reports.
• Installed BCA server on distributed environment.
• Designed & developed cam star live view reports
• Implemented report bursting feature.
• Designed Universes for Financial Billing system and Order processing.
• Worked on Linked Universes by kernel approach.
• Developed reports agains MS Access Data Base universe.
• Exported data to Excel sheets & validated reports.
• Written VBA code for automation of reports & data validation rules.
• Designed Universe for Ad-hoc reporting.
• Maintenance of development & Production environments.
• Developed Full client reports and webi reports.
• Scheduled full client reports and webi reports.
• Customized webi by using WICOM component.
• Linked webi reports for different hierarchies.
• Development, Testing & QA for all reports.

Environment: Oracle 8.1.6, MS Access, Ms Excel, VBA, ,DB2,AIX, Business Objects 5.0,5I, ZABO, SQL*Plus, PL/SQL, Web Intelligence 2.5/2.6 & Data Stage 4.0, Toad 6.5 & SQL Navigator 3.2, Erwin 3.0, WICOM & ASP

XXXXX, India

Systems Analyst                                                                                                                          May ’98 – Jan 01

Material Requirement Planning

Material Requirement Planning Converts Master Production Schedule and Item Requirements into a material plan. This tells when and how much to produce or procure to achieve the production plans. Major Reports include MRP Action Report, MRP Exception Report, Pegging Report, and Inquiries.

·         Developed Models for Manpower and Ground Equipment Planning

·         Assisted in developing Detailed Functional Specification for a state-of-the-art Resource Management System

·         Developing a Deterministic Optimization Model based on resource constraints

·         Proposed Mode of Operations based on results from Optimization Model

·         Presented recommendations to Senior and Line Management

·         Designed and developed front end applications by using Developer/2000

·         Developing stored procedures and database triggers and used user exits and PL/SQL interfaces to access foreign functions.

·         Using triggers for block processing, interface events, master-detail relationships, message handling, mouse events, navigation, query-time processing, transactional processing, validation and key processing.

Environment: Oracle 7.x, Sql*Plus, PL/SQL, Developer/2000.