PROFESSIONAL SUMMARY:
Around 6 years of IT experience in Analysis, Design, Coding, Testing, Implementation, Production
support and Data Warehousing.
Around 5 years of strong Data Warehousing experience in Business Objects XIR2/R1/6.5/6.0/
5.1 (Designer, CMC/Supervisor, Desktop Intelligence, Business Objects Developer Suite) Web
Intelligence XIR2/6.x/ 2.x, Broadcast Agent.
Experience in Designing and Linking Universes for query, reporting, and analysis using Designer
Module.
Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of
the Universes.
Experience in migrating the reporting system across the environments like Integration and
Production.
Involved in scheduling and publishing report to BO repository.
Proficient in using different databases like Oracle10g/9i/8i, MS SQL Server and MS Access 2000,
IBM DB2.
Ability to read and interpret Complex Data Models, and Data Modeling.
Expertise in Designing FACT Tables, Dimension Tables, Summary Tables.
Good knowledge of new features of Business Objects XI including Index awareness, Derived tables,
Single sign on support, Central management console
Strong testing and debugging skills and knowledge of ETL procedures and strategies to extract data
from different source systems.
Proficiency in SQL and PL/SQL programming to develop Stored Procedures/Functions.
Aptitude for understanding business environment and translate business requirements into technical
solutions. Exceptional analytical and problem solving skills. Team Player with the ability to
communicate effectively at all levels of the development process.
TECHNICAL SKILLS:
Reporting Tools: Business Objects XI R2, 6.5, 6.1, 5.x, Reporter, Designer, CMC, Supervisor, Web
ETL Tools : DataStage7.5 (Administrator, manager, designer, Server jobs, Parallel jobs,
Intelligence, Crystal Reports XI, Hyperion Essbase 9.3.1 , Hyperion Planning 9.3.1.
Transformations (Active & Passive).
Informatica Power Center 7.1.3/7.1.1/6.2 (OLAP, Workflow Manager, Workflow
Monitor Worklets, Source Analyzer, Warehouse Designer, Mapping Designer,
Transformations).
Databases : Oracle 9i/8i, SQL Server 2000, DB2, Sybase, MS Access 2000, Teradata.
Environment : Windows95/98/2000/XP/2003, Unix-AIX 5.2/4.3, WinNT4.0.
Programming : SQL, PL/SQL, HTML, XML, C, C++ and ASP.NET.
PROFESSIONAL EXPERIENCE:
Stanford Hospitals and Clinics, Palo Alto, CA
Feb'07- Till date
Business Objects Developer
Stanford Hospital & Clinics is known worldwide for advanced patient care provided by its
physicians and staff, particularly for the treatment of rare, complex disorders in areas such as cardiac
care, cancer treatment, Neurosciences, Surgery, Organ transplants. As a BO developer I was involved in
migrating the universes and reports from Business Objects 6.5 to XIr2, developed complex Universes and
Reports.
Responsibilities:
• Interacting with Business Users and Business Analysts to understand and document the requirements
and Built Universes for end user reports generation using Business Objects (Desktop Intelligence) 6.5
and XIR2 Suite.
• Migrated Universes and Reports from Business Objects 6.5 to XIR2.
• Good experience with CMC/Supervisor in creating users/groups and assigning privileges.
• Created users and groups and applied row level and objects level securities using Supervisor.
• Defined various Contexts and aliases in Universe to resolved fan traps and chasm traps and loops.
• Implemented various Schema Modeling techniques like star and snowflake schemas.
• Created various Object hierarchies to allow users to perform multidimensional analysis.
• Used derived tables.
• Used various functions like @Aggregate_aware, @prompt, @select in designing the universe.
• Created various complex and adhoc reports using Desktop Intelligence and Web Intelligence.
• Done enhancements to the existing reports like linking the reports in the repository at the universe
level.
• Carried out the performance monitoring and tuning of reports.
• Defined analytical functions for the function groups like ranking, accumulative aggregation.
• Developed several Complex Reports, various features include multiple groupings, drilldowns,
parameter fields, functions, Type Conversions, formulas.
• Developed Summarized Cross-Tab, Master/Detail Reports by implementing various functionalities
like Custom Filtering, Creating Alerts, Date and String functions.
• Visualized Data and enhanced reports using different types of charts like Histogram charts, Bar
charts and Funnel charts.
• Generated SQL scripts for validating and testing reports.
• Trained users in scheduling reports in BOXI server.
Environment: Business Objects (Desktop Intelligence) 6.5, XI R2, Designer, Supervisor, Web
Intelligence, IIS Server, ASP.net, ERWIN, Oracle 10g, SQL, and PL/SQL.
Smart & Final - Los Angeles, CA
Jan’06 to Feb’07
Business Objects Developer
Smart & Final Inc. operates more than 235 non-membership warehouse stores for food and foodservice
supplies in California, Oregon, Washington, Arizona, Nevada, Idaho, and northwestern Mexico. Different
Universes was built to capture Buying, Stores, Finance, and Warehouse information. Different business
units are able to build their own reports.
Responsibilities:
• Involved in assigning the privileges to the users using Supervisor module of Business Objects.
•Involved in the Creation of Universes, Classes, Objects, and Hierarchies for Multidimensional
Analysis of the Database Using Business Objects 6.5.1 for Buying, Stores, Warehouse, and Finance
Departments of the Company
• Created Multiple Universes in Designer in secure connection as well as shared connection
• Created Joins, Contexts, and Aliases, for resolving Loops, and Checked the Integrity of the Universes
• Exported the universes to the Repository making resources available to the users
• Worked extensively with @Functions ( @Aggregate Aware, @Select, @Prompt, @Where ) to
overcome the problem with Database when Integrated with Business Objects
• Extensively used the Major Functionalities of BO like Breaks, Alerter, Filters, Sorts and Query
Prompt and Drill Filters
• Customized the reports with graphical representation using Line and Bar Charts as per end User
requirement.
• Customized the reports by using Open Document syntax to create a hyperlink in one Document that
opens another Document containing related information.
• Created complex reports and published on Web using Web Intelligence 6.5.1
• Created PL/SQL Procedures for processing business logic in the Database
• Used Broadcast Agent Server to refresh Daily / Weekly / Monthly Reports and send to users in
Production Environment.
• Deploying Reports from Development Server to Production Server.
• Training InfoView and Power Users for Business Objects tool Usage
• Trained end users in generating Ad-hoc Reports.
Environment: Business Objects 6.5.1 , Web Intelligence 6.5.1, ZABO, Broadcast Agent Publisher, PL/
SQL, Oracle 9.2, Windows Server 2000, Unix, TIBCO Portal.
Banco Popular, Rosemont, IL
Sep’04 – Dec‘05
Business Objects Developer
Banco Popular North America (BPNA), the largest Hispanic bank in the United States, with a rich history
and strong institutional values, is creating an extraordinary legacy in North America. BPNA models the
future and looks to transform and redefine community banking in the United States.
Responsibilities:
• Created and managed Universes in the Designer.
• Created the reports using universes as the main data provider.
• Created Aliases and Contexts for solving the join problems in Business Objects.
• Created charts to display summary of the data.
• Used various join methods like Equi-join, Theta-join, Outer-join, when creating Universes.
• Created Hierarchies and Predefined Conditions using Business Objects.
• Created various Reports by pulling the OLAP data from Data Warehouse like Sales of Product, By
Region wise and reports based on time like Year, Quarter, Month, Week, Geographic location and
Comparative.
• Created new Classes and user Objects in designing the Universes.
• Published reports using Info view, and trained end users for ad hoc reporting.
• Involved in various discussions with end user to analyze Meta data.
• Extensively used Calculations, Variables, Break points, and Sorted inputs. Drill Down, Slice and Dice,
Alerts for creating Business Objects reports.
• Planned, coordinated and executed Business Objects deployments for end-users and documented the
entire process.
• Created Drill-Through reports to provide users with more detailed information and query linking.
• Created user Conditions and Filters to improve the report generation. Also used Alerts to improve the
readability of the report.
• Worked simultaneously on Crystal Reports (as per the user needs) as the reporting environment was
being converted to Business Objects Suite.
• Involved in creating the Reports on the web using the Web Intelligence 2.0.
• Formatted the Reports to the Users Requirements using all the requirements in Business Objects like
Slice and Dice, Drill down, @ Functions and Formulas etc.
• Exported the Reports to the Broadcast Agent Server.
Environment: Business Objects5.1.7, Oracle 8i, DB2 UDB, SQL Server 7.0, PL/SQL, Erwin, TOAD,
SQL*Plus, SQL*Loader, Windows, UNIX.
Zurich Financial Services, Schaumburg, IL
May’03 – Aug‘04
Business Objects Developer
xxxxxxx is an insurance-based financial services provider with a global network of
subsidiaries and offices in North America, Europe, Asia Pacific, Latin America and many other markets.
The project involved three different sub-projects. The first part consisted of upgrading the Business
Objects universes and reports from Business Objects 5i to Business Objects 6.1 and checking for factual
errors. The second part involved meeting with the portfolio managers and asking for their business
requirements, making separate universes with the newer tables and linking them to the already upgraded
universes. The third part was to generate Business Objects reports.
Responsibilities:
• Designed Business Objects universes and reports.
• Created variables, formulae and detail objects at report level.
• Designed, developed, maintained and tested universes for supporting ad-hoc queries.
• Created, and optimized Business Objects universes using Designer.
• Created universe classes, objects, measure objects, conditions and joins.
• Resolved chasm and fan traps.
• Used aggregate awareness in universes.
• Created reports using Business Objects functionalities such as queries, slice and dice, drill down,
@functions, cross tab, master/detail, formulas, etc.
• Created and deployed WebIntelligence reports through InfoView.
• Customized configuration of Business Objects WebIntelligence by fine-tuning and optimizing for
good performance.
• Troubleshot any problems and customized the application according to the specific requirements put
forward by the analysts.
Environment: Business Objects 6.1, MS SQL Server 2000, Windows 2000, WebIntelligence and
InfoView.
JPMC WAREHOUSING (JPMorgan Chase, NY) (Off Shore)
2002 Feb – 2003 April
ETL Data Stage Developer
JPMorgan Chase is a major participant in the strongest, most vibrant capital markets in the world,
operating across various businesses and geographies. They are leading global financial services firm with
assets of $742 billion. The firm is a component of the Dow Jones Industrial Average. Major functional
areas of JPMorgan are Investment Bank, Research, Private Equity, Investment Management, Private
Banking, Treasury and Securities Services and Middle Market. Worked for Syntel India.
Responsibilities:
• Involved in design analysis implementation and support of ETL Processes and prepared ETL
standards Naming conventions and wrote ETL flow Documentation.
• Interacted with Management to identify key Dimensions and Measures for business performance.
• Designed the workflow process to migrate the data between departments.
• FTP Link Collector Sorter and Sequential file stages and extensively wrote Routines and Transforms.
• Extensively ran Batches on the Data Stage using Data Stage Director and Created and Monitored
sequences using Data Stage sequencer.
• Extensively used Ascential's Data Stage Manager Designer Administrator Director and Integrity for
creating and implementing jobs.
• Extensively worked with Data Stage and their components for Data cleansing and Conversion and
loaded data into target database.
Environment:
Ascential Data Stage 6.0 (Designer, Director and Manager) Parallel Extender, Oracle , SQL PL/SQL
EDUCATION:
• Masters in Business Administration (MBA)
• Bachelor of Engineering in Computer Science.
visit us at :http://www.onlinetrainingsexpert.com/businessanalyst-online-training.html
Around 6 years of IT experience in Analysis, Design, Coding, Testing, Implementation, Production
support and Data Warehousing.
Around 5 years of strong Data Warehousing experience in Business Objects XIR2/R1/6.5/6.0/
5.1 (Designer, CMC/Supervisor, Desktop Intelligence, Business Objects Developer Suite) Web
Intelligence XIR2/6.x/ 2.x, Broadcast Agent.
Experience in Designing and Linking Universes for query, reporting, and analysis using Designer
Module.
Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of
the Universes.
Experience in migrating the reporting system across the environments like Integration and
Production.
Involved in scheduling and publishing report to BO repository.
Proficient in using different databases like Oracle10g/9i/8i, MS SQL Server and MS Access 2000,
IBM DB2.
Ability to read and interpret Complex Data Models, and Data Modeling.
Expertise in Designing FACT Tables, Dimension Tables, Summary Tables.
Good knowledge of new features of Business Objects XI including Index awareness, Derived tables,
Single sign on support, Central management console
Strong testing and debugging skills and knowledge of ETL procedures and strategies to extract data
from different source systems.
Proficiency in SQL and PL/SQL programming to develop Stored Procedures/Functions.
Aptitude for understanding business environment and translate business requirements into technical
solutions. Exceptional analytical and problem solving skills. Team Player with the ability to
communicate effectively at all levels of the development process.
TECHNICAL SKILLS:
Reporting Tools: Business Objects XI R2, 6.5, 6.1, 5.x, Reporter, Designer, CMC, Supervisor, Web
ETL Tools : DataStage7.5 (Administrator, manager, designer, Server jobs, Parallel jobs,
Intelligence, Crystal Reports XI, Hyperion Essbase 9.3.1 , Hyperion Planning 9.3.1.
Transformations (Active & Passive).
Informatica Power Center 7.1.3/7.1.1/6.2 (OLAP, Workflow Manager, Workflow
Monitor Worklets, Source Analyzer, Warehouse Designer, Mapping Designer,
Transformations).
Databases : Oracle 9i/8i, SQL Server 2000, DB2, Sybase, MS Access 2000, Teradata.
Environment : Windows95/98/2000/XP/2003, Unix-AIX 5.2/4.3, WinNT4.0.
Programming : SQL, PL/SQL, HTML, XML, C, C++ and ASP.NET.
PROFESSIONAL EXPERIENCE:
Stanford Hospitals and Clinics, Palo Alto, CA
Feb'07- Till date
Business Objects Developer
Stanford Hospital & Clinics is known worldwide for advanced patient care provided by its
physicians and staff, particularly for the treatment of rare, complex disorders in areas such as cardiac
care, cancer treatment, Neurosciences, Surgery, Organ transplants. As a BO developer I was involved in
migrating the universes and reports from Business Objects 6.5 to XIr2, developed complex Universes and
Reports.
Responsibilities:
• Interacting with Business Users and Business Analysts to understand and document the requirements
and Built Universes for end user reports generation using Business Objects (Desktop Intelligence) 6.5
and XIR2 Suite.
• Migrated Universes and Reports from Business Objects 6.5 to XIR2.
• Good experience with CMC/Supervisor in creating users/groups and assigning privileges.
• Created users and groups and applied row level and objects level securities using Supervisor.
• Defined various Contexts and aliases in Universe to resolved fan traps and chasm traps and loops.
• Implemented various Schema Modeling techniques like star and snowflake schemas.
• Created various Object hierarchies to allow users to perform multidimensional analysis.
• Used derived tables.
• Used various functions like @Aggregate_aware, @prompt, @select in designing the universe.
• Created various complex and adhoc reports using Desktop Intelligence and Web Intelligence.
• Done enhancements to the existing reports like linking the reports in the repository at the universe
level.
• Carried out the performance monitoring and tuning of reports.
• Defined analytical functions for the function groups like ranking, accumulative aggregation.
• Developed several Complex Reports, various features include multiple groupings, drilldowns,
parameter fields, functions, Type Conversions, formulas.
• Developed Summarized Cross-Tab, Master/Detail Reports by implementing various functionalities
like Custom Filtering, Creating Alerts, Date and String functions.
• Visualized Data and enhanced reports using different types of charts like Histogram charts, Bar
charts and Funnel charts.
• Generated SQL scripts for validating and testing reports.
• Trained users in scheduling reports in BOXI server.
Environment: Business Objects (Desktop Intelligence) 6.5, XI R2, Designer, Supervisor, Web
Intelligence, IIS Server, ASP.net, ERWIN, Oracle 10g, SQL, and PL/SQL.
Smart & Final - Los Angeles, CA
Jan’06 to Feb’07
Business Objects Developer
Smart & Final Inc. operates more than 235 non-membership warehouse stores for food and foodservice
supplies in California, Oregon, Washington, Arizona, Nevada, Idaho, and northwestern Mexico. Different
Universes was built to capture Buying, Stores, Finance, and Warehouse information. Different business
units are able to build their own reports.
Responsibilities:
• Involved in assigning the privileges to the users using Supervisor module of Business Objects.
•Involved in the Creation of Universes, Classes, Objects, and Hierarchies for Multidimensional
Analysis of the Database Using Business Objects 6.5.1 for Buying, Stores, Warehouse, and Finance
Departments of the Company
• Created Multiple Universes in Designer in secure connection as well as shared connection
• Created Joins, Contexts, and Aliases, for resolving Loops, and Checked the Integrity of the Universes
• Exported the universes to the Repository making resources available to the users
• Worked extensively with @Functions ( @Aggregate Aware, @Select, @Prompt, @Where ) to
overcome the problem with Database when Integrated with Business Objects
• Extensively used the Major Functionalities of BO like Breaks, Alerter, Filters, Sorts and Query
Prompt and Drill Filters
• Customized the reports with graphical representation using Line and Bar Charts as per end User
requirement.
• Customized the reports by using Open Document syntax to create a hyperlink in one Document that
opens another Document containing related information.
• Created complex reports and published on Web using Web Intelligence 6.5.1
• Created PL/SQL Procedures for processing business logic in the Database
• Used Broadcast Agent Server to refresh Daily / Weekly / Monthly Reports and send to users in
Production Environment.
• Deploying Reports from Development Server to Production Server.
• Training InfoView and Power Users for Business Objects tool Usage
• Trained end users in generating Ad-hoc Reports.
Environment: Business Objects 6.5.1 , Web Intelligence 6.5.1, ZABO, Broadcast Agent Publisher, PL/
SQL, Oracle 9.2, Windows Server 2000, Unix, TIBCO Portal.
Banco Popular, Rosemont, IL
Sep’04 – Dec‘05
Business Objects Developer
Banco Popular North America (BPNA), the largest Hispanic bank in the United States, with a rich history
and strong institutional values, is creating an extraordinary legacy in North America. BPNA models the
future and looks to transform and redefine community banking in the United States.
Responsibilities:
• Created and managed Universes in the Designer.
• Created the reports using universes as the main data provider.
• Created Aliases and Contexts for solving the join problems in Business Objects.
• Created charts to display summary of the data.
• Used various join methods like Equi-join, Theta-join, Outer-join, when creating Universes.
• Created Hierarchies and Predefined Conditions using Business Objects.
• Created various Reports by pulling the OLAP data from Data Warehouse like Sales of Product, By
Region wise and reports based on time like Year, Quarter, Month, Week, Geographic location and
Comparative.
• Created new Classes and user Objects in designing the Universes.
• Published reports using Info view, and trained end users for ad hoc reporting.
• Involved in various discussions with end user to analyze Meta data.
• Extensively used Calculations, Variables, Break points, and Sorted inputs. Drill Down, Slice and Dice,
Alerts for creating Business Objects reports.
• Planned, coordinated and executed Business Objects deployments for end-users and documented the
entire process.
• Created Drill-Through reports to provide users with more detailed information and query linking.
• Created user Conditions and Filters to improve the report generation. Also used Alerts to improve the
readability of the report.
• Worked simultaneously on Crystal Reports (as per the user needs) as the reporting environment was
being converted to Business Objects Suite.
• Involved in creating the Reports on the web using the Web Intelligence 2.0.
• Formatted the Reports to the Users Requirements using all the requirements in Business Objects like
Slice and Dice, Drill down, @ Functions and Formulas etc.
• Exported the Reports to the Broadcast Agent Server.
Environment: Business Objects5.1.7, Oracle 8i, DB2 UDB, SQL Server 7.0, PL/SQL, Erwin, TOAD,
SQL*Plus, SQL*Loader, Windows, UNIX.
Zurich Financial Services, Schaumburg, IL
May’03 – Aug‘04
Business Objects Developer
xxxxxxx is an insurance-based financial services provider with a global network of
subsidiaries and offices in North America, Europe, Asia Pacific, Latin America and many other markets.
The project involved three different sub-projects. The first part consisted of upgrading the Business
Objects universes and reports from Business Objects 5i to Business Objects 6.1 and checking for factual
errors. The second part involved meeting with the portfolio managers and asking for their business
requirements, making separate universes with the newer tables and linking them to the already upgraded
universes. The third part was to generate Business Objects reports.
Responsibilities:
• Designed Business Objects universes and reports.
• Created variables, formulae and detail objects at report level.
• Designed, developed, maintained and tested universes for supporting ad-hoc queries.
• Created, and optimized Business Objects universes using Designer.
• Created universe classes, objects, measure objects, conditions and joins.
• Resolved chasm and fan traps.
• Used aggregate awareness in universes.
• Created reports using Business Objects functionalities such as queries, slice and dice, drill down,
@functions, cross tab, master/detail, formulas, etc.
• Created and deployed WebIntelligence reports through InfoView.
• Customized configuration of Business Objects WebIntelligence by fine-tuning and optimizing for
good performance.
• Troubleshot any problems and customized the application according to the specific requirements put
forward by the analysts.
Environment: Business Objects 6.1, MS SQL Server 2000, Windows 2000, WebIntelligence and
InfoView.
JPMC WAREHOUSING (JPMorgan Chase, NY) (Off Shore)
2002 Feb – 2003 April
ETL Data Stage Developer
JPMorgan Chase is a major participant in the strongest, most vibrant capital markets in the world,
operating across various businesses and geographies. They are leading global financial services firm with
assets of $742 billion. The firm is a component of the Dow Jones Industrial Average. Major functional
areas of JPMorgan are Investment Bank, Research, Private Equity, Investment Management, Private
Banking, Treasury and Securities Services and Middle Market. Worked for Syntel India.
Responsibilities:
• Involved in design analysis implementation and support of ETL Processes and prepared ETL
standards Naming conventions and wrote ETL flow Documentation.
• Interacted with Management to identify key Dimensions and Measures for business performance.
• Designed the workflow process to migrate the data between departments.
• FTP Link Collector Sorter and Sequential file stages and extensively wrote Routines and Transforms.
• Extensively ran Batches on the Data Stage using Data Stage Director and Created and Monitored
sequences using Data Stage sequencer.
• Extensively used Ascential's Data Stage Manager Designer Administrator Director and Integrity for
creating and implementing jobs.
• Extensively worked with Data Stage and their components for Data cleansing and Conversion and
loaded data into target database.
Environment:
Ascential Data Stage 6.0 (Designer, Director and Manager) Parallel Extender, Oracle , SQL PL/SQL
EDUCATION:
• Masters in Business Administration (MBA)
• Bachelor of Engineering in Computer Science.
visit us at :http://www.onlinetrainingsexpert.com/businessanalyst-online-training.html
good article thank u oracle training in chennai
ReplyDelete