Abi Singh

Ph 817-***-**** dcueg9@r.postjobfree.com

CORE COMPETENCIES

• Over 8 years of experience in the IT industry with extensive skills dedicated to business systems analysis, database development, and Reporting.

• Strong Experience in building Reports retrieving data using Universes, Personal data files, Free hand SQL methods and creating complex reports, ad-hoc Reports using the Desktop Intelligence and Web Intelligence tools. Proven ability to effectively handle multi-task levels of project management responsibility with minimal direction from superiors while supervising personnel, providing team leadership, motivation, and development.

• Well versed in Business Objects (XI R3.1, R2 and 5.1) with experience in CMC, CCM, Infoview, Desktop Intelligence, Import Wizard, Supervisor, Designer, Reporter, Web Intelligence, Dashboards, and Scorecard.

• Expertise in migrating from version XI R2 to XIR3, Business Objects Universes, Users, Report Objects, Personal Data Files.

• Experienced in implementing reporting applications using Crystal Reports, Crystal Enterprise, Xcelsius, Business Objects Enterprise, SAP Business Explorer, Oracle SQL and PL/SQL.

• Experienced in publishing reports, maintaining users using Crystal Enterprise/Business Objects Enterprise.

• Experienced in accessing Enterprise Resource Planning (ERP) data for reporting purpose.

• Excellent SQL, PL/SQL coding, Triggers, Stores procedures, Views development skills.

• Involved in troubleshooting, Optimizing, and fine-tuning the SQL Queries for efficiency.

• Experienced in hyper linking the objects from crystal reports and webi reports in Business Objects Enterprise.

• Experienced in performance tuning of WEBI reports and involved in crystal reports debugging.

• Experienced using Xcelsius Dashboards, which are used in determining the performance and progress of the business.

• Strong RDBMS concepts and working experience using database Tables, Views, Stored Procedures, Functions, and Packages using SQL and PL/SQL.

• Good knowledge of Dimensional modeling (Star Schema and Snow-Flake schema Design) techniques of data warehouses.

• Great exposure of ETL AND INFORMATICA.

• Trained in Business Object 4.0

• Experienced in documenting Functional & Technical Specifications as required by SDLC.

• Experience with Central Configuration Management (CCM), change control and source control systems.

• Capable of working as an individual and also as a part of team.

• Quick learner, possess excellent analytical and technical skills, excellent team player.

• Ability to adapt to new technologies very quickly.

TECHNICAL SKILLS

Operating System Windows XP/ Enterprise Server 2003 and 2008/NT, UNIX

Languages SQL, PL/SQL, SQL Plus

Database SQL Server 2008, 2005, Oracle 10g/9i, IBM DB2, MS Access.

Tools Business Objects XI 3.1, R2, 6.5, 5.1; Web Intelligence (WEBI); Desktop Intelligence (5.1 Business Objects), Crystal Reports XI and 2008, Xcelsius 2008 and Visio.

Packages OLTP; OLAP, ODBC/API, ADO, DAO, OLE DB, XML, SSRS, SSIS CSS,CCM,CMS,CMC,ECC,SDK, Ajax; Forecasting, Trend Analysis, Full Life-Cycle Development, Star and Snowflake Schemas, Executive Dashboards, Oracle SQL Developer 1.5.1, SQL Plus, SQL Loader, Microsoft Visual Source Safe, MS Office, Server studio, Data Integrator 11.

PROFESSIONAL PROFILE

JP Morgan Chase. Dallas TX Sept ’09 to Present

Sr. Business Object Developer

Description: JP Morgan Chase & Co is one of the oldest and major providers of financial services behind Wells Fargo and Bank of America. It has its corporate headquarters in New York and retail & commercial headquarters in Chicago.

Business Objects was widely used across the bank in the various fields like Consumer Banking & Credit Cards wherein most of my work was related to. The major objectives of the projects were to build and maintain the universes & reports pertaining to the customer banking and credit details. The data was obtained from the back end Oracle databases.

Responsibilities:

• Involved in gathering, analyzing and documenting business requirements, functional requirements and data specifications for business object universes and reports.

• Created Universe level objects and measures using the business rules provided.

• Setting up the security levels to the users in universe module like row level and object level security.

• Designed and developed the Functional Analysis and Technical Design like Joins, Shortcut Joins, Contexts, and Cardinalities of the tables and structures of the Universe.

• Use of BO Designer Module to implement Universes, linkages between tables, creating prompts and queries, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies.

• Importing and Exporting the Universes to repository to make it accessible to end users.

• Extensively used QAAWS to retrieve the SAP BI data from the universe objects.

• Interacted with the Business Analysts to gather the requirements and developed prototypes in the form of PDF’s or Power Point Slides of the Dashboards for the initial presentation to the users.

• Developed extensive client side scripts and validation functions using JavaScript for OPS.

• Developed WEBI reports in Business Objects XI R3.1and Xcelsius Dashboards in Xcelsius 2008.

• Developed multiple dashboards so that the user can navigate from one dashboard to the other.

• Expertise in developing drill down reports and hyperlinked reports.

• Created simple and complex reports including dynamic calculations involving Contexts, Queries, Hierarchies, List of Values (LOVS), local variables, Alerts, Ranking and multiple data.

• Created the reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae’s.

• Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.

• Created reports in table, cross table, 2-D, 3-D Column, Line, Area and Pie charts.

• Created multiple Flash variables in Xcelsius and used them to pass data from one dashboard to other.

• Resolved the production tickets within specified time lines.

• Used multi value components like line charts, bar charts, stacked column charts and combination charts, and single value components like gauge, slider, dial and progress bars in the development of the Dashboards.

• Extensively used slice and dice, filtering and ranking to create cross tab and master/detail reports.

• Involved in formatting sections, tables, inserting and organizing multiple breaks.

• Used the formatting options like cross tab representation, section breaks, data sort options, calculations, font, colors.

Environment: Windows Enterprise Server 2008 Apache Tomcat, BOXIR3.1 SP3, Crystal Reports 2008, Oracle 10g, TOAD, Teradata. Designer XI, Web Intelligence XI, Info View, Designer, CMC, CMS, Xcelsius 2008, SQL, PL/SQL. OLAP, BO Live office, SAP Business Objects suite.

Allstate Insurance Corporation, Dallas, TX Sept ’08 to Aug ’09

Sr. Business Object Developer

Description: Allstate, founded in 1931 is the second-largest personal lines insurer in the United States behind State Farm. Allstate sells 13 major lines of insurance, including mainly auto insurance, home insurance, life insurance and commercial insurance. Business Objects was widely used in-order to generate customer, sales and marketing reports. Several Universes and reports were built to address complex reporting needs and help in analyzing transactions across different divisions of Allstate like life insurance, property and casualty, real estate

Responsibilities:

• Gathered Business Requirements from the end users and clients.

• Involved in designing Universe and migrating existing Deski Reports to Webi.

• Responsible for supporting issues with reports.

• Prepared project Documentation based on requirements such as BRD.

• Designed universe with 4 different contexts and applied aggregate navigation for Shared dimensions.

• Passed parameters from Summary report to Detail report via OpenDoc syntax.

• Created Prompts filters in the Universe using complex SQL to filter specific data based upon on user input.

• Created Crystal Reports used in key Factoring Reports.

• Resolving loops in universes using Aliases and Contexts.

• Efficiently designed multiple analytical WEBI reports utilizing key WEBI features including but not limited to Drill Down, Alerts, Input Control and Open Doc.

• Developed Hierarchies to support drill down reports.

• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @Functions, Cross Tab, Master/Detail and Formulas etc.

• Created Daily weekly monthly, annual and forecasting Reports for fiscal and calendar years.

• As an iterative process updated the modifications suggested by the Client.

• Resolved the testing issues related to the Dimensions, Contexts and Joins in the Universe.

• Fine-tuned the universe objects in order to improvise the Query Performance.

• Extensively worked on creating contexts for the Universe based upon the Business Flow.

• Updated the Joins and applied shortcut joins where ever necessary.

• Created filters to drag in the reports as per user requirement.

• Created the measure objects as per the reports requirement.

Environment: Windows Enterprise Server 2003 Apache Tomcat, BOXI XI 3.1, Oracle 10g and TOAD. Supervisor, Designer, Reporter, Desktop Intelligence, Web Intelligence, CMC & Info View, Crystal Reports, Xcelsius, SQL, PL/SQL.

El Paso Energy, Houston, TX Apr ’07 to Aug ’08

Business Object Developer

Description: Client is a premier natural gas and related energy Products Company which is organized around two core Businesses – pipelines and exploration. It owns the North America's largest interstate natural pipeline system. The project is about the scheduling of the pipeline systems based on Flowing Gas and Contracts.

Responsibilities:

• Excellent use of graphs and charts with named groups and formula fields.

• Involved in upgrading from Business Object 6.5 to XI R2.

• Analyzed Business Objects old Universes and Reports. Designed and developed new Universe and Reports as per the requirements.

• Designed and developed Business objects reports using Designer and Reporter XI R2 Version.

• Responsible for analysis of the systems, meeting with end users and business units in order to define the requirements.

• Created various dashboard reports to measure the performance.

• Responsibilities included imparting training to the end-users and doing the knowledge transfer for reporting needs.

• Created Crystal reports using the Universes as the main Data Providers.

• Good Business analysis and Application development lifecycle experience.

• SQL tuning of reports to increase performance.

• Solid experience in creating application schema as tables, view and indexes.

• Experience in writing scripts to drop the index before and recreating indexes after the data load to increase the performance.

• Created various reports related to Insurance products and Customer preferences using complex SQL queries.

• Generated various numbers of reports on a daily, weekly and monthly basis using Business Objects Report module.

• Created Dashboard reports in Xcelsius to measure the performance.

Environment: Business Objects XI R2, Web-Intelligence, Xcelsius 4.5, Desktop Intelligence, Actuate, CMC, Designer, Toad, Oracle10g, SQL, PL/SQL, Windows 2000 and Windows XP, Crystal Reports 10, Informatica.

Abbott Laboratories, Abbott Park, IL Dec ’05 to Mar ’07

Business Object Developer

Description: A diversified healthcare company with the focus on advancing medical science in the areas of pharmaceuticals, nutrition’s and diagnostics. The project involved generating reports on billing exceptions, project planning, user requirements study, data analysis and business analysis. Worked on the development of the complex business reports in BO as well as CR also taken active part in the universe design related issues.

Responsibilities:

• Worked with business users, higher management for gathering and analyzing requirements.

• Created Universes using Business Objects and resolved loops and Join problems by creating Aliases.

• Responsible for analysis meeting with end users and business units in order to define the requirements

• Controlling Reports data by working with Universe and queries. Using Filters, Sorts and Rankings.

• Used various @Functions like @Prompt (for user defined queries), @Where (For creating conditional filters), and @Select.

• Developed reports using complex formulae with Running Totals based on Grouping and parameters (Dynamic and Cascading) and sub reports.

• Migrated existing reports from Crystal Reports 10 to Crystal Reports XI.

• Created sub-reports and hyperlinked the objects to sub-reports and to dynamic parameters.

• Developed and published webi reports in Business Objects Enterprise XIR2 environment.

• Wrote complex SQL Queries to be used as Command Object in Crystal Reports development.

• Used SQL for designing, modifying, and maintaining the Tables, Views and Stored Procedures.

• Involved in troubleshooting, Optimizing, and fine-tuning the SQL Queries and Crystal Report debugging for efficiency.

• Created Dash Boards Using Xcelsius Designer 4.5.

• Used Business Objects Enterprise to perform administrative tasks related to users accounts, groups, folder management, server settings, report publishing, etc.

• Experience in translating business requirements in to technical/data element requirements.

• Involved in gathering the requirements for reporting from the end users

• Following Spend Analysis Created reports Inventory management and Budget analysis.

• Used Broadcast Agent to schedule the reports.

• Migration of Universes and reports from development to Production environment.

• Modified Universe after analyzing areas of business and user requirements.

• Use of slicing and dicing for generating master/detail, Cross-tabs, Matrix, Charts and tabular reports.

• Experience in creating application schema as tables, view and indexes.

• Created Full Client Reports making use of Business Objects functionalities, like Multiple Data Providers, Prompts, Slice and Dice, Drill Down/Up.

• Created Crystal reports using the Universes as the main Data Providers.

• Scheduled and monitored using Broad Cast Agent.

• Supported end- users in UAT/Production Issues.

Environment: Business Object 6.5, Web Intelligence, Windows Server 2003, VB Script, SQL Server 2005, T-SQL, Oracle 10g/9i, TOAD, T-SQL, Business Object (Client Tool), PL/SQL, Crystal Reports XI/10, Xcelsius 4.5, Business Objects Enterprise XI R2, Visual Studio 2005, MS Source Safe.

Handi-foil Corporation, Wheeling, IL July ’04 to Nov ’05

Business Object Developer

Description: Handi-foil Corporation is a manufacturer of recyclable aluminum products committed to quality, convenience and innovation. It offers a complete line of foil containers and dome lids including traditional, high-end and seasonal bake ware items. The project provided users with the ability to make intelligent business decisions, so as to assist in comprehending and predicting the organization growth based on the available historical data. Various reports were developed to analyze consumer behavior of customers

Responsibilities:

• Worked with Functional Managers / BA’s / End Users to gather reporting requirements to implement business logic for successfully implementation of reporting system to satisfy the needs of Business Units and Supplier Partners.

• Extensively worked on Administration of Business Objects 6.5/XI R2 Environments (Supervisor and CMC)

• Worked on Business Objects Desk I and Web I Reports of BO 6.5 and BO XIR2 Environments.

• Worked on User Management, Server Management and Content Management of BOXI.

• Migrated the Users, Groups, Universes, Personal Folders, Connections, Reports (DeskI & WebI), Excel, PDF and Instances to Production, Development and Test Environments using Import Wizard from BO 6.5 to BOXI R2.

• Converted the DeskI Reports to WebI Reports using Report Conversion tool.

• Customized the BOXIR2 Infoview by modifying the JSP pages, XML files and Jar files for daily updates, replace the BOXIR2 Logo and banner using Java SDK and API.

• Applied the hyperlinks to Info view home page using customizing the Java SDK.

• Added users, user groups and managed the access privileges of the user community using the CMC module of Business Objects XIR2 and Business Objects 6.5.

• Enhanced the Exiting Universe to speed up the performance.

• Designed Crystal Reports with formulas, Grouping, Parameters, Selection criteria to handle the report request.

• Worked on Crystal reports with using features like Cross-tab, Conditional, Top and Drill-down.

• Worked on Implementing the Lovs, Hierarchy’s, Pre-Defined Conditions, Resolving Data Base Connections, Adding new objects to the Universes.

• Worked on Developing Standard & Multi-Dimensional Web I Reports using features like Drills, filters, Sort, Rank, Sections, Breaks, Alerts, merge Dimensions, sub quires and Multiple Data Providers.

• Experience in working and managing in Different Environments simultaneously.

• Worked on creating Derived Tables, Aggregated Tables using Aggregate Awareness concept, creating Indexes, views to increase the performance of the universe.

• Extensively worked on Audit Reports and Activity Universe tuned up the performance issues.

Environment: Oracle 9i, PL/SQL, Business Objects 6.x, Crystal Reports 8.5, BO Supervisor 6.0, Web intelligence 6.0, Broadcast Agent, Windows 2000.

Delphi Corporation, Troy, MI May ’03 – June ‘04

Business Objects Developer

Delphi is one of the world's largest automotive parts manufacturers. Delphi designs, engineers and manufactures a wide variety of components, integrated systems and modules on a worldwide basis. Business Objects was extensive used in preparing internal reports, annual reports and branch wise sales reports.

Responsibilities:

• Maintained Universes by defining joins cardinalities between tables applying contexts and alias tables to remove cyclic dependencies.

• Checked the Integrity of the Universes and exported the Universes to Repository for making available to users.

• Interacted with users to know their approach and assist in developing and modifying Reports accordingly.

• Created different types of reports such as Master/detail, Cross Tab and Charts.

• Created graphical representation of reports such as Bar charts, 3D charts and Pie charts etc.

• Defined Alias and Contexts to resolve loops and also tested them to ensure that correct results are retrieved.

• Developed Web Intelligence reports making use of several Queries (Union, Intersection, Minus)

• Used Prompts, Conditions to restrict the data returned by Query and used Filters to restrict the unwanted data to be displayed on the report.

• Exported reports into EXCEL, PDF, CSV and XML formats as per the client requirement.

• Used features such as functions and parameters, conditional formats to develop highly formatted Reports.

• Involved in Business Objects Support, Problem Solving, Trouble shooting and developing End user Notes.

Environment: Business Objects 5.x, Crystal Report, Web Intelligence, Info view, Designer, Supervisor, Broadcast Agent, Oracle 8.x, PL/SQL, UNIX, SQL Server.

EDUCATION:

BBA Finance University of Texas Arlington

Contact this candidate