ResumeLogin
Search for: Jobs   Resumes
Keywords or title City, state or zip code
Sr. Business Objects Developer Post Job For Free
Posted by: Name is not set.
Posted date: 4/17/2009
Contact Info: ******.***@*****.*** ** *****...
Show Contact Info
Salary: 80000
Country: United States
State: Texas
City: Irving
ZIP: 75039
Email: tysw2n@r.postjobfree.com
Resume Text: NAVEEN MEDAVARAPU
(Senior Certified DW BI Business Objects Developer)
tysw2n@r.postjobfree.com Ph. (201)686-****

PROFILE:
• 8 years total IT experience
• 7 years of Business Objects experience
• 3 years of Xcelsius experience
• 5 Years of Crystal Reports experience
• 4 years of Data Modeling
• 8 years of SQL/PL-SQL Experience

Summary
• IT Experience: 8 Years of total IT experience in implementing Full Life Cycle Data Warehousing from Business Requirements Gathering & Analysis, Dimensional Data Modeling, Design, Development, Testing and Production support in all industry verticals exclusively Telecom, Financial, Pharmaceutical, Insurance Industries.
• BO Experience: 7 years of Business Objects XI R3/R2/R1/6.5/6.1/6.0/5.1,CMC, Designer, Info view, Web-Intelligence XI/6.0/2.7,Supervisor, Auditor, Application Foundation Dashboard Manager, Application Foundation 6.0/2.5 & Dashboard Manager), Crystal Reports, Crystal Xcelsius 4.5/3.5/3.0, Business Objects Reporting Business Objects SDK, Web-I SDK, Broadcast Agent, Publisher.
• Data Modeling: 4 Years of Data Modeling experience using Dimensional Data Modeling and Relational Data Modeling, SQL Tuning,Star Join Schema/Snowflake modeling, FACT & Dimensions tables, Physical & Logical Data Modeling, Oracle Designer & Visio.
• Data Cleansing: 4 Years of experience in using Firstlogic for the data cleansing and profiling purposes
• ETL Experience: 3 Years of Data Warehousing experience using Informatica PowerCenter 7.x/6.x/5.x, Powermart, Powerconnect, Power Exchange, Power Plug, Data Integrator XI/11.5, OLAP, OLTP, Datamart.
• Database: 8 Years of database experience using Oracle 10g/9i/8i, DB2, SQL Server 2005/2000, SAP ECC 6.0/5.0, SAP BI 7.0,SAP BW,Oracle Applications 11i (Financials,Manuafacturing),AP,AR,GL,OM, PeopleSoft, Java, J2EE, IBM DB2 UDB 8.0/7.0, Teradata V2R5/V2R4/V2R3, Sybase 12.x/11.x, MS Access.
BO Summary:
• Created complex reports by linking data from multiple sources, using functionalities like Combined Queries, Slice and Dice, Drill Down, Master Detail, etc.
• Excellent understanding of relational databases and client/server applications.
• Extensive knowledge in Business Objects Full Client & Thin Client reports.
• Trained Users in report development and running ad-hoc queries in business objects.
• Convert Business and Data requirements into conceptual and logical data models.
• Creating, Developing, distributing, migrating and modifying Universes in Business Objects.
• Extensively worked on Designer module and involved with creation of complex universes
• Managed the resources, granted permissions to BO product users, WEBI users, managed the connections, the Universes and repository domain.
• Working Knowledge in WebI administration and Info View.
• Tested business objects reports for data validation and compared results with TOAD.
• Analytical and problem solving skills in Business Objects with ability to assess user requirements.

Education & Certifications:
• B.S. in Engineering
• Business Objects Enterprise Professional Certification.
• BO crystal reports certified professional certification.
• Oracle Certified Associate Certification (OCA).

TECHNICAL SKILLS:
Business Intelligence: Business Objects XI R3/R2/R1/6.5/6.1/6.0/5.1,CMC, Designer, Info view, Web-Intelligence XI/6.0/2.7,Supervisor, Auditor, Application Foundation Dashboard Manager, Clarity 8.1, Application Foundation 6.0/2.5 & Dashboard Manager), Crystal Reports, Crystal Xcelsius 4.5/3.5/3.0, Business Objects Reporting Business Objects SDK, Web-I SDK, Broadcast Agent, Publisher.
Database: Oracle 10g/9i/8i, DB2, MS SQL Server 2005/2000, SAP ECC 6.0/5.0,Oracle Applications 11i (Financials,Manuafacturing),AP,AR,GL,OM, PeopleSoft, Java, J2EE, IBM DB2 UDB 8.0/7.0, Teradata V2R5/V2R4/V2R3, Sybase 12.x/11.x, MS Access.
ETL Tools : Data Integrator XI, Informatica Power Center 8/7.x/6.2, Data Qualifier, Powermart, Powerconnect, Power Exchange, Power Plug, ETL, OLAP, OLTP, Datamart.
Operating Systems: Windows NT /2000/XP, Win 95/98/3.x,MS-DOS, UNIX, Solaris
Tools: SAP Integration Kit, Discoverer 10g/9i/4i,Developer 2000, Designer 2000, Ervin 4.1/7.1 (Data Model), Developer Suite 10g, Oracle SQL*Loader, SQL*Plus.
Database languages & Tools: TOAD9.0.1.8/9.0/8.6.1/7.2, Pl/SQL Developer, SQL*PLUS, SQL* LOADER,VBA,JAVA, SQL, PL/SQL, SQL*Loader, Stored Procedures,Explain Plan, TKPROF Functions, Ref Cursors, Constraints, Triggers, Indexes-B-tree Index, Bitmap Index, Views, Inline Views, Materialized Views, Database Links, Export/Import Utilities


PROFESSIONAL EXPERIENCE:

Sony Electronics Inc., San Diego, CA Nov’ 07 to Current
Sr. Business Objects Developer
Sony Electronics comprised of business units that are supported by a sales platform targeting consumer sales, consumer systems and applications, commercial IT sales, corporate, education and A/V reseller channels. The project view is to gather specifications, build the universes and deploy the reports using Business Objects XI.

Responsibilities:
• Designed and exported universe for standard/ad hoc reporting requirements for end users. Linked Universes and modified the Budget Universe for the purpose of generating ad-hoc reports. Involved in Writing Detailed Level Documentation for reports and Universe design.
• Installation, migration, configuration, maintenance, technical support and troubleshooting of Business Objects and Xcelsius implementation in a shared environment.
• Created and involved with creation of complex universes
• Effective use of advanced reporting and formatting functions in Business Objects reporting.
• Developed crystal reports based on Client’ requirement using group functionality.
• Establish core architecture and development environment for all web development and integration with SAP.
• Map SAP data to reports and universe specifications.
• Involved in the installation of SAP integration Kit with BO XI R2 environment.
• Developed Signle and multiple dashboards and scorecards using business objects.
• Developed live office functionality, presentation layer and worked on navigation.
• Created Master/Detail Reports, Cross-tabs, Charts and Applied slice-and-dice, implemented different level of hierarchies for drill techniques.
• Automated document Scheduling, Publishing and Distribution for WebI and Info view clients, using Scheduler.
• Demonstrated skills in performance tuning optimization with reference to cube design OLAP queries Knowledge of the technical suite in use within the application
• Developed LDAP security model for security publications and involved in Development of OLAP data structures using Microsoft Analysis Services tools.
• Created and worked on Row level security, Object level security and various predefined security settings depending upon users and group needs using CMC.
• The major data providers used are Universes, Personal data files, Free Hand SQLs. Involved with the Enterprise Data Warehouse project and involved in part of Data analysis, modeling the schema and generation of star schema model.
• Created metrics and dashboards using Application Foundation.
• Designed dashboards (single and multiple dashboards) using Performance management.
• Developed universes, reports using Designer, Desktop Intelligence.

Environment: Business Objects XI R3/R2, Designer XI, Web Intelligence XI, Data Integrator XI, Crystal Reports XI R2,Clarity 8.1 , SAP Integration Kit, SAP BW, SAP ECC 6.0,Desktop Intelligence,CMC, Xcelsius 2008, Dashboard manager,ZABO,SDK, OLAP,BO Live office, Performance Management, Application Foundation, Windows NT,Solaris,UNIX Shell Scripting,Autosys, TOAD,LDAP,IBM DB2,RDBMS,VBA, SQL Server 2005/2008 ,Oracle10g,Data Modelling,ASP.Net ,Ervin7.1, SAP Business Objects suite.

FedEx World Tech Center, Memphis, TN May’ 07 to Oct’ 07
Business Objects Developer
The project scope is to Create ,Test and to fix production issues for different kind of analytics and metrics in FedEx services such as Kinko’s, Ground(domestic and International),Freight, FCIS and services using Business objects XI/R2.

Responsibilities:
• Involved in gathering, analyzing, and documenting business requirements and data specifications for Business Objects Universes and Reports for Express and Ground Damage claims denied, loss claims denied.
• Implementation of full SDLC and configuration planning, documentation to meet the client’s specific requirements.
• Develop Universes to support report development and ad-hoc use for creating end user reports. Used all the methodologies in the Universe designer like aliases, contexts, derived tables, aggregate awareness, multiple universes, linked universes.
• Effective use of advanced reporting and formatting functions used in Business Objects reporting.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.
• Designed universes and used various methods to optimize queries on database, universe and reporting level.
• Prepared various metrics for Express and Ground using Metric Id’s starts from E1 to E11 and G1 to G10.
• Created and tested classes and objects to organize the universe.
• Exported the universes to the Repository to make resources available to the users. Created reports for various Portfolios using the Universes as the main data Providers.
• Created the reports using Business Objects functionality’s like Queries, Cross Tab, Master Detail and Formulae’s etc. Applied slice-and-dice, drill-up and drill-down techniques in master detail reports for multi-dimensional analysis of retrieved data.
• Handled all the change requests to the existing universes requested by reporting team.

Environment: Business Objects XI R2, Designer, SDK,Web Intelligence XI, Desktop Intelligence, Xcelsius, Crystal Reports, Xcelsius, BO Live office, Dashboards, Performance Management, SQL Tuning, Unix shell scripting, Autosys,SQL Server 2005 ,Teradata, OLAP, Oracle 10g,RDBMS, SQL, PL/SQL, Windows 2000/XP, SQL plus, Data Modelling,LDAP security model,Teradata SQL assistant 7.1,ASP.NET,SAP Business Objects suite.


Ernst & Young Inc, Lyndhurst, NJ Sep’ 06 to May’ 07
Business Objects Developer
The project is to design and build Universes and associated reports for decision support using Business Objects XI R2 for the huge HR and PEOPLESOFT data warehousing.

Responsibilities:
• Designed universes and used various methods to optimize queries on database, universe and reporting level.
• Worked towards optimal development of universes by removing loops through the use of aliases and contexts, Creating Universe with number of Classes, many objects, Derived Tables using inner/outer and equiv. joins as per requirement.
• Exported the universes to the Repository to make resources available to the users. Created reports for various Portfolios using the Universes as the main data Providers.
• Effectively used BO functions like cross tab, master detail, sorts, alerters, drill methodology, slice and dice, breaks, formatting reports, templates creation, linking multiple data providers, grand totals, charts etc.
• Modified the peoplesoft Universe for the purpose of generating ad-hoc reports. Created Single, multiple Dashboards using Dashboard Manager.

Environment: Business Objects XI R2, Designer, Web Intelligence XI, Data Integrator XI,SDK,Desktop Intelligence, Crystal Reports, Dashboards, Xcelsius,OLAP, Performance Management, peoplesoft, Lotus notes Data warehousing, SQL Server 2005 Oracle Applications 11.7,Supply Chain Management(SCM),Order Management(OM),Account payable(AP),Account receivable(AR),Oracle 10g,Peolplesoft, SQL, PL/SQL, Windows 2000/XP, SQL plus.

Citigroup Inc., Warren, NJ Jun’ 06 to Sep’ 06
Business Objects Developer
The project was to design and develop Universes and deploy concerned reports using Business Objects 6.5.1 and upgrade reports using Business Objects XI R2.

Responsibilities:
• Designed different Universes as per the requirements for different Business user groups for canned and ad-hoc querying.
• Created number of classes and objects, table aliases, contexts, pre-defined conditions and defined hierarchies to organize the universe.
• Used shortcut joins for optimal use of Universes and fast retrieval of data from Summary tables.
• Exported the universes to the Repository to make resources available to the users.
• Developed various canned Reports that involved use of Prompts, Customized LOVs, Multiple data providers, Master/Detail, Alerts, Cross tab, filters and variables.
• Developed weekly and monthly Company Turnover Reports as per the requirements.
• Created Single, multiple Dashboards using Dashboard Manager.
• Published Documents to Corporate repository for access to authenticated users via Info View.
• Wrote documentation that includes Design details of Universe and Reports.
• Helped various user groups with any Business Objects related issues
• Created Business Objects Repository while building Business Objects solution
• Modified the Budget Universe for the purpose of generating ad-hoc reports..
• Helped the migration team for the universe update to export repository and modification of reports. Created matrices, Dashboards and worked on Deski and Designer.

Environment: Business Objects XI R2/6.5.1, Designer, Web Intelligence 6.5.1, Data Integrator, Data mart Enterprise/7.4.1,OLTP, OLAP, SQL Server 2005/2000, Oracle 9i/10g, PL/SQL, Windows 2000/XP, SQL plus, Toad 9.0.1.8

Pfizer Inc., Groton, CT Feb’ 04 to Jun’ 06
Business Objects Developer
Pfizer is a leading provider of fully integrated pharmaceutical services. Current project was to analyze and develop pharmaceutical production and paramedical regulatory reports using designer and webi 6.0.

Responsibilities:
• Involved in creation of Universes, Classes, Objects and Hierarchies for multi dimensional analysis of database using Business Objects 6.0 for technical and sales departments.
• Paramedical regulatory and pharma production information reports can be generated both on Webi as well Deski.
• Created master detail reports using drill up and drill down functionalities
• Built Powerful Queries by creating and applying complex conditions and sorts, User Objects, LOV’s, Combined Queries, Free Hand SQL and Semantically dynamic calculations using context method
• Worked extensively with @functions including @aggregate aware, select, prompt and @where to overcome database integration issues
• Organized data in the reports by using Filters, Sorting, Ranking and highlighted data with Alerter. Scheduled reports on daily/weekly/monthly basis using Broadcast agent
• Used SQL against the database to check retrieved data integrity
• Exported universes to the repository for making resources available to users
• Was actively involved in planning, documentation .Developed 12 reports over a 3 week deadline
• Setup Application Foundation operational metrics and analytics for marketing decision analysts. Migrated universes between repositories for access to a wider audience.

Environment: Business Objects 6.0, Designer, OLAP, Web Intelligence 6.0, SQL Server 2000, Oracle 9i/10g, PL/SQL, Windows 2000, SQL plus, Toad 9.0

Satyam computer services ltd., India Jan’ 01 to Jan’ 04
BO Reports Developer
This project involves developing and analyzing reports for one of its clients in banking industry, which will facilitate the customers of that Bank with the ability to keep track of their account information and Investment Information.

Responsibilities:
• The project involved generating reports using Discoverer and reports 4i.
• Customization of Discoverer End User Layer involved creating customized folders, building robust business layers, customized joins and granting privileges.
• Created complex reports in Inventory and Account balance summery reports by combining various Descriptive flex fields (Attributes).
• Created approximately 12 new Discoverer desktop reports.
• Created reports using Report builder and Report wizard by defining various data models.
• Customization of Discoverer End User Layer (EUL) involved creating customized folders, building robust business layers, customized joins and granting privileges.
• Customized the Oracle Payables Sales Tax Processing bringing several separate programs into one with the selection/calculation logic for the invoice creation.

Environment: Discoverer 4i,Oracle Applications 11i,General Ledger, Supply Chain Management (SCM),Account Payable(AP),Account Receivables(AR),Order Management(OM), Business Objects 5.1, Reports2.5/4i, OLAP, MS SQL Server 2000, SQL, PL/SQL, SQL*Loader, UNIX, SQL plus, Toad 7.2




Similar resumes:
warehouse - 6450
java - 2627
asp.net - 724
sap - 3182
java developer - 1076

Similar jobs:
warehouse - 805
sales - 10158
marketing - 4965

Jobs vs Resumes









Support

PostJobFree

Become
a

Premium
Recruiter


$20/month

©2009  PostJobFree.com - Home - Fresh Resumes - Post Job