Friday, 5 December 2014

qlikview sample resume


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


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


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,


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.


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,


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.


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



• 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


• 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,, 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.


• 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


• 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.


• 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


• 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.


• 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


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.


• 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.


Ascential Data Stage 6.0 (Designer, Director and Manager) Parallel Extender, Oracle , SQL PL/SQL


• Masters in Business Administration (MBA)

• Bachelor of Engineering in Computer Science.

visit us at :

No comments:

Post a Comment