Chandra Bo

Chandra Mobile: 302-366-8991 Email: [email protected] Summary:

 Around 6+ years of total IT experience in the Design, Modeling, Development and Testing of     

      

Data warehouse applications. 4 years of strong experience in Business Intelligence and Data Ware housing applications in design, development and implementation. Extensively utilized Business intelligence Reporting Tools such as Business Objects 5.X/6.X. Strong working knowledge of Business Objects Application Foundation 3.0, Web Intelligence, Full Client, thin client, ZABO, Dash Board Manager, Designer, Info view, Broad Cast agent Excellent OLAP Cube Building experience using Business Objects Designer. Strong exposure to Software Project Development full life. Working knowledge and proficiency with Business Objects XI-R2. Expertise in dimensional data modeling, star schema modeling, snow flake modeling, fact and dimensional table design, physical and logical data modeling using Erwin Strong Exposure to SQL, PL/SQL, and RDBMS: Oracle 7.1/8.0/8i/9i, and MS SQL Server 6.5/7.0/2000. Knowledge in architecture design of Extraction, Transformation & Loading environment using Informatica, Power Mart and Power Center, Ascential Data Stages 7.5, Data Integrator. Possess Excellent Communication and Interpersonal skills. Technically sound, Result-Oriented with strong Problem Solving skills. Innovative & efficient. Capable of working as a Team Member or Individually with minimum supervision. Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.

Technical Skills: Data Modeling Tool:

ERWIN 3.5.2/4.1, Star-Schema Modeling, Snowflake Modeling, FACT & Dimensions ETL Tools: Informatica, Ascential Data Stage Database: MS SQL Server 2000/7.0/6.5, Teradata, Oracle 9i/8i/7.x, MS Access 7.0 Business Intelligence: Business Objects XI-R2/6.X/5.1, Business Objects Universe Developer, Business Objects Reporting, Info View, Web Intelligence, Broadcast Agent, Dash Board Manager, ZABO, Full Client, Thin client. Reporting Tools: Crystal Reports XI-R2, COGNOS Report Net Operating Systems: Windows NT 4.0, Win 95/98/2000/XP, UNIX Languages: SQL, PL/SQL, XML, HTML Education: Bachelor of Engineering (Computer Science), India

Engel Hard Corp, NJ Role: Business Objects Developer

Jan’06 to till date

Engel Hard Corp is one of the leading chemical suppliers in the world producing a wide range of chemicals in integrated production plants. The most important customer industries for their products are the pharmaceuticals, construction, textile and automotive industries. This project mainly focuses on the financial aspects. The reports created are scheduled using Broadcast Agent for refreshing on the guidelines provided by the client like Daily, Weekly and Monthly. Helping the client in finding and analyzing the data problems or bad data. Responsibilities:

 Designed, Created and Managed the Business Objects Universes.  Generated Canned Reports using BO Universe as the data provider against multiple Data  

 

   

providers Meeting extensively with end users/customers to understand report requirements. Testing reports before posting them to the repository (query optimization & performance). Weekly Production moves made to the universe. Created Dimension, Detail, as well as complex Measure objects, adding tables, revalidating joins. Ensured the smooth flow of application in development, test and production environments. Creation and implementation of ad-hoc reporting system using Business Objects. Universe tuning by creating Joins, Contexts and Aliases for resolving Loops and checked the Integrity of the Universes using Business Objects Designer. Generated reports using complex SQL queries and multiple data providers. Created Master-Detail reports using Calculations, Variables, Breaks, Sorting, and Alerts for creating Business Objects reports Drill down/up functionality related to the company’s Marketing, Sales, Accounting and financial planning design and implementation of reports.

Information was provided to the client by generating reports using Business Objects tools. Business Objects Repository was created on oracle database to hold the reports process objects using Supervisor tool. Designer tool was used to create measures and Dimensions. Business Objects reports were viewed using info view and Browser. Environment: Business Objects XI-R2/6.5.1/6.1b, Oracle, Web Intelligence6.5, Windows 2000, MSAccess 2000, Microsoft Excel 2000. Flag Star Bank, Troy, MI Role: Business Objects Consultant

Jan’05 –Dec’05

Flagstar Bancorp, Inc. operates as the holding company for Flagstar Bank, a federally chartered stock savings bank. Flagstar is the largest publicly traded savings bank headquartered in the Midwest United States. Flagstar is also a leading mortgage lender and a national leader in the wholesale mortgage business. Business Objects was used to power Flag Star Bank’s customer extranet, accessible anytime, anywhere, and by any device with a web browser. This system was built with an objective to help toplevel management in decision making. Also, used Business Objects Web Intelligence as one of its internal reporting standards to create and distribute reports to the company's employees.

Responsibilities:

 Designing and developing universes for reporting generation.  Created user objects including Dimensions, Details and Measures.  Detected cardinalities, loops, and checked the Integrity of Universes.  Interaction with Business Users, Database Team to know their requirement in developing and updating universes.  Developed complex reports using features like slice and dice, Drill capabilities, Complex freehand SQL queries, @Functions, Master Detail, and Cross Tab tables with multiple breaks.  Generated several Canned Reports using BO Universe as the data provider against multiple Data providers  Used Dash Board Manager for Monitoring business performance & alerts.  Created the reports using the universes as the main Data providers.  Publishing reports using Infoview, and training users for ad hoc reporting.  Created various user profiles, set their access permissions to create the various user groups.  Created variables, @Prompt objects, formulas and etc.  Customization and modification of both existing Universes and Report.  Migration of universes and documents from one domain to another like (DEV-QA, QA-PRD)  Performed Web reporting using Web intelligence and Info view.  Implemented Row level and Object level locking data access.  Disabling and enabling the documents published to corporate documents for users who were not authorized.  Enabling and Disabling Universes for un-authorized users and periodic Password maintenance.  Involved in configuring and installing Business Objects 6.5, Web Intelligence 2.6.1  Exporting the Reports to the Broadcast Agent Server.  Designed and developed mapping, transformation logic and processes in Informatica for implementing business rules and standardization of source data from multiple systems into the data warehouse.  Involved in various discussions with end user to analyze Meta data.  Involved in data cleansing and loading.  Worked with Teradata SQL to extract data to Validate.  Documenting procedures and processes for BO Products support and training.  Responsible for Creating and Maintaining Users/Groups, Repositories, Connections and Security Policies using Supervisor. Environment: Business Object 6.5, Broadcast Agent Server, Web Intelligence, ZABO, Dash Board Manager, Erwin, Teradata, PL/SQL, Informatica 6.1

Pactiv Corporation, IL

Feb’04 - Dec’04

Role: Business Objects Developer Pactiv Corporations is advanced packaging solutions. Pactiv has a unique ability to deliver multiple products through multiple channels to meet multiple customer needs in an integrated manner. Pactiv Corporation has data in different databases, different data staging areas, OLTP (Online Transaction Processing), we have extracted data from different data sources and then we have created different Data Marts to answer different query reports using Business Objects. Responsibilities:

 Installed Business Objects.  Used different Data Warehouse techniques like Star-Schema.  Creation of different types of reports, such as Master/Detail, Cross Tab and Chart (for trend analysis). Use of filters, conditions, calculations, etc.  Created various data marts from data warehouse and generated reports using Business Objects.  Analyzed and Created Fact and Dimension Tables.  Developed Object Fields Attributes, Functions, Triggers Using Object Designer.  Creation of reports like, Reports by Product, Reports by Customer, Reports by Period, Demographic reports and Comparative reports.  Generated reports using Business Objects Report Designer.  Analyzed the Specifications and identifying the source data needs to be moved to data warehouse.  Involved in various discussions with end user to analyze Meta data.  Involved in admin tasks like analyzing Table Space requirement, load balancing and Performance.  Extracted data from different systems into Source.  Developed different Transformations to load the data into target.  Loaded data into target database from source database using Server Manager.  Use of Designer Module to implement Universes, linkages between tables, creating prompts and queries, parsing the Universes, and applying contexts and alias tables to remove cyclic dependencies.  Use of Dash Board Manager in business activities.  Writing PL/SQL procedures for processing business logic in the database. Tuning of SQL queries for better performance.  Use of Analyzer and Explorer to view reports from different prospect (Slice and Dice and Drill down).  Presentation of the advanced features of Business Objects to users and developers to enable them to develop queries and reports easily. Environment: Business Objects 5.1, WebIntelligence2.6, Broadcast Agent, Business Objects, Supervisor, BO Designer, ZABO, Dash Board Manager, Java Script and Oracle8i, Win 2k Catalina Finance Corp., FL Role: Business Objects Developer

Aug’02 - Jan’04

Investment Management System Involved in designing and developing programs for the Investment Management System at Catalina Finance Corp., using Business Objects as front-end and Oracle as backend. The system was primarily written to provide reports for our Portfolio Managers who could use these reports to provide our clients with the highest total rate of return consistent with their performance goal, cash flow requirements, need for liquidity, and preservation of capital. The reports also provided our Portfolio Managers the unique objectives of each client with due regard to tax consideration, preferences toward quality and market risk. The reports also provided our Portfolio Managers information to help our clients identify investment opportunities that provide above average potential for price appreciation and total return. Reports were created using the Reporting Tool Business Objects. Responsibilities:  Involved in the designing and building of Universes, Classes and Objects for Investment Management System.

 Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.  Exported the Universes to the Repository to making resources available to the users. Created reports for various Portfolios using the Universes as the main Data Providers.  Created the reports using Business Objects functionalities such as Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae’s, etc.  Exporting the Reports to the Document Agent Server and used the Doc Agent server to Schedule and Monitoring the Reports.  Involved in production Support and gave training to the users. Environment: Business Objects 5.1.4, WebI 2.5, Oracle 8.0.5, Windows NT, Unix Apollo Microsystems Pvt LTD., INDIA Client: Apollo Hospitals

Jul’01-Jun’02

Role: Programmer Analyst Project dealt with the medical equipment and drugs given to the customers/Patients, claiming the bills from the insurance companies, used by the medical service providers. The system had four modules: Customer Details, Data File Management, Inventory and Accounts. The customer module deals with the customer details and insurance related Medicare med claims. Inventory module deals with Drugs and equipment flow from the vendors, supplies to the customer and on-hand availability. Accounts module deals with bills and claims with various insurance companies. Responsibilities:  Several reports generated regarding customers, doctors, inventory and billings  Involved in designing and implementing several forms for each module  Designed user interface screens  System incorporates all the user-friendly functionality’s like pop-ups, list boxes and other object oriented events.  Developed the user interface and menus using triggers, functions and procedures. Also took active part in testing.  Carried out detailed study of business, data analysis and configuring the materials management module to user specification. Also involved in developing E-R Diagrams. Environment: SQL*Plus, PL/SQL and Developer 2000 (Forms 4.5, Reports 2.5), Oracle 7.1, Windows 95, Shell Scripting, UNIX (sun Solaris). Karur Vysya Bank, Karur Role: Programmer

Mar’00-Jun’01

KVB offers a wide range of banking products and financial services to corporate and retail customers through a variety of delivery channels and through its specialized subsidiaries and affiliates in the areas of investment banking, life and non-life insurance, venture capital and asset management. The system issues computerized registration of customer accounts and view the accounts online and submitting mails for clarifications. It gives online information of the customers account details. Strategic Decision Support System providing complete Transactional Information of all types of accounts of their Branches Nationwide. Keeps a Track of the account related information. Responsibilities:  Involved in designing the database model.

 Designed and developed forms for the user interface using Oracle Forms.  Wrote PL/SQL Scripts to create alter and drop database objects likes tables, views, sequences, procedures and functions.  Wrote stored procedures and functions to retrieve the data from the database using PL/SQL.  Different database triggers Oracle 7.0 with SQL*Plus, PL/SQL in both UNIX and WINDOWS environment.  Triggers were created and stored in the database and fired off when contents of database were changed.  Involved in performance tuning of the application.  Designed and developed matrix reports using Oracle Reports for the analysis of the data. Environment: Oracle 7.0, UNIX, Windows