System and Business Analysis and Implementation of Client Server Application Sample Resume Format in Word Free Download

Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download

SARAH

 Chicago, IL 60001
US
Home: 734-437-1230

Mobile: 734-437-9876

sarah@gmail.com

SUMMARY OF EXPERIENCE

·         10 years of professional IT experience in the areas of Business Intelligence, Data Modeling, Data Warehousing, RDBMS, System and Business Analysis and implementation of Client/Server applications

·         Extensive knowledge SAP Business objects XI 3.1/XIR2/XIR1 (Business Objects Designer, Desktop Intelligence, CMC, Import Wizard, CCM, Query As A Web Service, Web Intelligence, Thin Client and all versions of Crystal Report

·         More than two years of experience building dynamic dashboards using Xcelsius 2008.

·         Proficient in translating report requirements into detailed report specifications, confirm report design with business users and creating reports using Business Objects XIR3, XIR2

·         In-depth knowledge in working and implementation of Crystal Reports 2008/XI/10.0/9.0.

·         Strong knowledge on DBMS Concepts and databases Oracle, Netezza, DB2 & SQL Server, MS-Access.

·         Good Knowledge in SQL, PL/SQL, views, indexes, stored procedures and other components of database applications.

·         Extensive experience and solid understanding of Data Warehousing, Data Marts, Star, Snow Flake and Star Flake Schema Modeling, Dimensional Modeling, Entity-Relationship Modeling, OLTP and OLAP concepts

·         Extensively worked on implementation of Physical and Logical Data warehouses and Data Marts

·         Profound knowledge of Extract, Transformation and Load (ETL) process using Informatica

·         Knowledge of complete software development life cycle including Requirement Analysis, Requirement Gathering, Cost Estimation, Project Management, Design, Development, Implementation and Testing

·         Strong leadership, good communication, analytical, design and development skills, good working experience with customers, end users and colleagues. Demonstrated ability to work in both individual and team environments

·         Development experience across several functional business areas such as Finance, Insurance, Retail, Supply Chain, Order Management, Inventory, Marketing, Sales and Manufacturing covering Oil/Energy and Telecom Sectors

·         Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.

 

CERTIFICATIONS

·         BOCP - BOE (Business Objects XI 3.1 Certified)

• Informatica Administration Certified

TECHNICAL SKILLS

BI/Query Tools:                  Business objects XI 3.1/XIR2/XI, Xcelsius 2008/4.5,  Web I and all versions of Crystal Report, BO SDK, QaaWs, Live Office         

Data Modeling Tools:           Erwin 4.0, MS Visio 2002

ETL Tools:                            Informatica 7.x, Data Integrator 6.5

RDBMS:                                Oracle 10g/9x/8x, MS Access, SQL Server, DB2 V 8/9.2, Netezza 4.6, Teradata

Programming Languages: SQL, PL/SQL, T-SQL, SQL*Loader, Macro VBScript

Operating Systems:            UNIX (SUN Solaris 10/8), Win XP/2003/2000/NT,

Web Application Servers:  Tomcat, Apache, Web Sphere, Sun java Server

Miscellaneous Tools:           MS Office, TOAD, MS Project, Flex Builder

PROFESSIONAL EXPERIENCE

Duration:         Dec 2009 - Till Date

Customer:       Financials & Insurance giant, IL

Role:                Business Objects Architect

Client is one of the world's largest insurance groups, offering general and life insurance productions and services for individuals, small business, mid-sized and large companies and multinational corporations. Company operates from 80 global locations.

Responsibilities:

·         Lead a Team of 5 Developers and supported numerous other BI projects which include but not limited to RI-Canada - Implementation of new Data Mart for Canadian External Users of this Insurance Company, U2Z - Migration of heterogeneous platform data to the centralized North America Warehouse, Z-Center - Created Complex Crystal Reports using multiple Sub-reports, OpenDoc passing Multiple Parameters.

·         Supported multiple Business Objects landscapes with a user base of 6000 each. supported Business Objects versions include BOBJ XIR2, BOBJ XIR3.1

·         Development effort includes universe creation, maintenance, WebI /Deski / crystal reports creation and development of Live dashboards using QAAWS and Live office. Supported customized reporting applications built on Enterprise SDK, Universe SDK and Web I SDK

·         Strengths include development of audit plan and customized audit reports for BOBJ reporting infrastructure and Data analysis on DB2, SQL server, Netezza databases

·         Hand's on experience in multiple migration projects, which includes application and system migration of BOBJ environment from XIR2 to 3.1 and DB2/SQL server based universe and crystal reports to Netezza. Significant level of experience managing Business Objects servers and related content administration.

·         Used functionality in Designer like creation of universe based on stored procedure using multiple parameters , creation of customized LOV's based on security and delegate search , creation of customized dynamic cascading prompts , table level row-level security for user groups with different functionality requirements , combining database functions / UDF in universe objects.

·         Extensively worked on the maintenance of complex universes.

·         Proposed, reviewed and assisted in implementation of dynamic dashboards using QAAWS. These queries are used in Xcelsius to dynamically fetch the data from DB2 database.

·         Liaison with SAP Business Objects technical support on product limitations and configured the product as per the capabilities and expectations of end user's.

·         Supported customized Business Objects SDK's to fetch user's information, report's information directly from repository and display in a managed Web Application.

·         Designed, Implemented and managed the User groups and formalized the process of creating corresponding groups for each new application and the process of creating new users in Business Objects CMC.

·         Setup the Security at the Folder level and at the Group level in the Central Management Console. Managed Row Level Security at the universe level using designer.

·         Created File based events to trigger the scheduled WEBI reports. Scheduled the Daily, Weekly, Monthly reports.

·         Gathered requirements from users and created documents to let the users understand the Business Objects interface and steps to make changes to their profile.

·         Worked with ETL team to understand the details of load process, so that we can build reliable and efficient reports.

·         Worked on personal lines audit reports explaining their user activity and session activity for higher management.

·         Created many Web Intelligence reports and Desktop Intelligence reports.

·         Created Crystal Reports based on Universes. Used functionalities like sub report's and open Doc, shared variables.

·         Verified that the key columns have the indexes. Redesigned the model with data modelers by creating aggregate tables, materialized views... as necessary, if the performance is still poor after creating corresponding indexes.

·         Involved in writing SQL's to validate the data coming in to the reports/dashboards.

Environment: SAP Business Objects XI 3.1/XIR2/XI, Xcelsius 2008, Crystal Reports 2008/XIR2, QAAWS, DB2 9.2, SQL Server 2000, Windows XP/2000/2008.Netezza 4.6

Duration:         Dec 2008 - Nov 2009

Customer:       Financials & Insurance giant, IL 

Role:                BO Technical Lead

Client is one of the world's largest insurance groups, offering general and life insurance productions and services for individuals, small business, mid-sized and large companies and multinational corporations. Company operates from 80 global locations.

Responsibilities:

·         Created universes by adding new objects, conditions, Custom LOV's and Hierarchies to fulfill the user requirements.

·         Worked with data modelers to create Aggregate tables and used Aggregate Awareness to enhance the performance of SQL transactions.

·         Worked with DBA to estimate the space required based on the volumes of the data.

·         Created Template for standardizing the Structure of Corporate Documents.

·         Implemented row level restrictions according to different business group requirements.

·         Created many complicated Full Client reports using major functionalities of BO like Drill Down, Cross Tab, Charts, Breaks, Sorting, Alerter, Variables, Global/Block filters, Combined Queries, Merged Queries etc.

·         Developed complex reports with multiple data providers with each data provider having multiple Union Queries.

·         Exported the Business Objects reports to repository to be viewed by all users on the intranet via Infoview.

·         Involved with end user training in Business Objects Reports.

·         Involved in writing the SQL Queries to validate the Reports.

·         Created Crystal Reports using Business View Manager as semantic layer

·         Tuned the reports and SQL's for better performance.

Environment: Business Objects XI R2 (Designer), Web Intelligence, Crystal Reports, Deski, InfoView, DB2 9, Windows 2000 Server.

Duration:         Jun 2007 - Nov 2008

Customer:       Financials & Insurance company, CA

Role:                Business Objects Lead

            Client is one of the largest insurance groups in the USA, offering general and life insurance productions and services for individuals, small business, mid-sized and large companies and multinational corporations.

Responsibilities:

·         Experience with Installation and Configuration of all Business objects modules.

·         Responsible for Creation of the Universe with Classes, Objects, Condition objects, Hierarchies and Custom LOV's and resolved Loops, Fan traps and Chasm traps by creating Aliases and Contexts.

·         Linked the Universes to share the common components.

·         Implemented row level restrictions according to different business group requirements.

·         Created Crystal Reports using Universes.

·         Set up Aggregate Awareness to enhance the performance of SQL transactions.

·         Developed Hierarchies to support drill down reports.

·         Created the reports using Business Objects functionalities like Slice and Dice, Cross Tab, Master/Detail and Formulas etc.

·         Created user defined objects in the reporter for ad hoc reporting and exported them to the corporate repository

·         Involved in creating reports on the web using Business Objects Web Intelligence.

·         Involved in formatting the reports to the user requirements.

·         Extensively used the Drill mode and the Slice and Dice tools to modify the reports accordingly.

·         Developed Full client reports and Web Intelligence reports with various complex features.

·         Involved in design for the Login page, Document List Page and Results using JSP's.

·         Extensively involved with end user training in Business Objects Reports.

·         Created Crystal Reports using Business Object Universe and Business View Manager as semantic layer

·         Used Informatica Power mart 6.0 to extract data from many source systems and Flat files and loaded it to the target data warehouse which was DB2 8.

·         Created Source Qualifier, Filter, Expression, Router, and Update strategy transformations.

Environment: Business Objects XIR2, Web Intelligence, Crystal Reports XIR2, Deski Report, Informatica Power Centre 6.2, PL/SQL, DB2, SQL Server 2000, Windows 2000 Server.

Duration:         Mar 2006 - May 2007

Customer:       Financials & Insurance company, CA

Role:                Business Objects Developer

            Client is one of the largest insurance groups in the USA, offering general and life insurance productions and services for individuals, small business, mid-sized and large companies and multinational corporations.

Responsibilities:

·         Created User Groups, Users and assigned profiles that match to their responsibilities.

·         Created Universes, Classes and Objects for management system based on the warehouse schemas.

·         Created Crystal Reports using Universes.

·         Developed Complex Reports (Used multiple data providers, Union, Intersection, minus and Master/Detail, cross tab, Charts).

·         Improved the performance and reduced the coding with the use of @functions (@select, @where).

·         Implemented complex joins, created derived tables in the Universe.

·         Created complex reports using different data sources residing on DB2

·         Created user variables with the use of Variable Editor.

·         Worked extensively with the major functionality of BO like Breaks, Alerter, Filters, Sorts, Query Prompt and Drill filters.

·         Analyzed the reports using the Drill Through, Slice and Dice.

·         Created reports on web using Info View Portal distributed the reports to different users.

·         Fixing the UAT issues raised by the client

·         Involved in the progress of migration the universe and crystal reports from Development region to QA and then to Production.

Environment: Business Objects XIR2, Web Intelligence, Deski, Crystal Reports, InfoView, DB2 8, Windows 2000 Server.

Duration:         Jul 2005 - Mar 2006

Customer:       Telecommunications giant, Sweden 

Role:                Business Objects Developer

Description:    It's a Sweden based Company. It is the leading supplier of carrier grade products for Over-the-Air (OTA) management of SIM services and Mobile Devices. These products are used in the solutions areas to enable operators to save time, save money and grow revenue through high-performance management of SIM cards, mobile terminals and value added services. We have developed the Reports for them by using Business Objects Enterprise XI with Crystal Reports XI.

.

Responsibilities:

·         Requirements Study, analysis and documentation, which provides framework to the Software development Team.

·         Involved in creation of ER Diagrams, Schema Design and Universe Design.

·         Created Universes from various data sources coming from various databases including Oracle

·         Created Crystal Reports using Universes.

·         Created Drill-Down Hierarchies and their effective and optimal use in Reports.

·         Creating standard full client reports and Web Intelligence reports.

·         Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail, Alerter and Formulae etc.

·         Scheduled full client reports and Web Intelligence Reports.

·         Responsible for the maintenance of Test and Development Repositories.

·         Designed Universe Classes and Objects, such a way that isolates end users from the Technical issues of the database structure.

·         Created contexts, aliases to remove Loops, Chasm traps, and Fan traps.

·         Worked with multiple Data providers in a report and added slice and dice capabilities.

·         Planned and coordinated for ongoing administration and Trouble Shooting for the Business Objects 5.1 environment.

Environment: Business Objects XIR1, Oracle 8i, SQL Server 2000, MS Access 2000, Informatica PowerCenter 5.1, Erwin4.1, Windows 2000 Server, Unix.

Duration:         Nov 2003 - Jun 2005

Company:        Dimexon Solutions, India

Role:                Report Developer

Description:    As the name specifies the project gives complete information about Kirtilal Kalidas Groups of Company, involving various areas like Production, Productivity, Inventory, Quality, HR, Stores and Finance & Costing. This project is purely a reporting tool developed for solving the purpose of regular reporting as well as acting as a decision making tool of top level management. The concept of auto generation of a report & then feedback about it are some of the highlighting features of this project.

.

Responsibilities:

·         Requirements Study, analysis and documentation, which provides framework to the Software development Team.

·         Created Reports from various data sources coming from various databases including Oracle, SQL Server

·         Created Crystal Reports using stored procedures.

·         Created Drill-Down Hierarchies and their effective and optimal use in Reports.

·         Created the reports using VS Flex Grid functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail etc.

·         Responsible for the maintenance of Test and Development Environment.

·         Designed Reports Design in such a way that isolates end users from the Technical issues of the database structure.

·         Created sub-reports using User defines function in the Crystal and export to the Crystal repository.

·         Live Report on the Flex Grid on the data Inventory of the company

·         Worked with multiple Data providers in a report and added slice and dice capabilities.

·         Planned and coordinated for ongoing administration and Trouble Shooting the Production Environment.

Environment: Oracle 8i, VS Flex Grid, SQL Server 2000, MS Access 2000, SQL Server, Crystal Reports X, Windows 2000 Server.

Duration:         May 2002 - Sep 2003

Company:        Edison & Company, India

Role:                Report Developer

Description:    This project has been developed for M/s Edison & Company located in Tuticorin Project includes maintenance of Accounts & Inventory of the company. This Project Submitted as my Final Year Project in MCA. I was involved in System Designing, Coding & Implementation areas. The modules involved in this project are: 1. Master Module 2. Material Inward Module 3. Conversion Module 4. Material Outward Module 5. Accounts 6. Inventory 7. Reports

.

Responsibilities:

·         Requirements Study, analysis and documentation, which provides framework to the Software development Team.

·         It's pure a Accounting Software created using Visual Basic, Crystal Reports & VS Flex Grid.

·         Created Reports from various data sources coming from various databases including SQL Server, Access

·         Created Crystal Reports using stored procedures, UDF.

·         Responsible for the maintenance of Test and Development Environment.

·         Designed Reports Design in such a way that isolates end users from the Technical issues of the database structure.

·         Created sub-reports using User defines function in the Crystal and export to the Crystal repository.

·         Worked with multiple Data providers in a report and added slice and dice capabilities.

·         Planned and coordinated for ongoing administration and Trouble Shooting the Production Environment.

Environment: Oracle, VS Flex Grid, SQL Server, MS Access, SQL Server, Crystal Reports, Visual Basic & Windows 2000 Server.

Download Resume Format