We provide IT Staff Augmentation Services!

Senior Business Intelligence Developer Resume

Jersey City, NJ

Professional Profile:

  • Total IT: 6+ years of IT experience in Analysis, Design, Development and Implementation of Data Warehousing and other applications using Object Oriented Analysis, Design and Methodologies.
  • Business Objects:5 years of Business Objects experience with complete life cycle Implementations using all the client and server products in XI 3.1,XI R2/6.5/6.1/6.0/5.1 (Central Management Server, Central Management Console, Central Configuration Manager, Desktop Intelligence, Live Office, Import Wizard, Report Conversion Tool, Dashboard Manager , Performance Manager, Supervisor, Designer, InfoView, Web- Intelligence XI R2, 6.5, 6.1, WebI SDK, Broadcast Agent, Publisher, BO Set Analyzer, Application Foundation 6.0 ).
  • Extensive experience and solid understanding of Data Warehousing, Data Marts, Star Schema, Snow Flake Schema Modeling, Dimensional Modeling, Data modeling, Entity-Relationship Modeling, OLTP and OLAP concepts.
  • 2 years of experience in application foundatation, performance management, dashboard manager, analytics, Xcelsius.
  • Data Integrator: 3 years of experience using BO Data Integrator, Informatica ETL, Informatica Power Mart/Center 6.2/5.1/4.7/1.7, Informatica Power Connect.
  • 2 years of experience in crystal reports, business views, crystal xcesius.
  • Database: 4 years of strong database experience in Oracle 10g/9i/8i,MS SQL Server 2000/7.0, MY SQL, (database triggers, materialized views, In-line views Packages, stored procedures, functions, and database constraints), SQL Loader, SQL*Plus, PL/SQL and oracle DBMS Packages, oracle supplied utilities, Developer 2000 (Forms 6i/5.0, Reports 3.0/2.5), TOAD, Rapid SQL.
  • Personal skills include- Strong analytical and problem solving skills, decisive with solid leadership qualities, quick learner and team player with excellent communication and interpersonal skills.

Education:

  • Masters Degree in Computers.
  • Bachelor Degree in Computers.

Technical Skills:

  • Business Intelligence: Business Objects XI 3.1, XI R2/6.5/6.1/6.0/5.1, Central Management Console, Desktop Intelligence, Web Intelligence XI R2/6.5/2.x (WEBI),WEBI Rich client, Performance Manager, Import Wizard, Data Integrator, Report Conversion Tool, Designer, Supervisor, Broad Cast Agent, ZABO, Application Foundation 6i, Business Objects Reporting, Crystal Reports XI, Live Office, Microsoft Reporting Services.
  • Data warehousing: Data Integrator, Informatica Power Center 7.1.x/6.5, Repository Manager, Designer, Erwin 4/3.x
  • Databases: Oracle 10g/9i/8i, MS SQL Server 2000, MYSQL (Database triggers, materialized views, In-line views, Packages, stored procedures, functions, and database constraints), SQL Loader, SQL*Plus, PL/SQL and oracle DBMS Packages, oracle supplied utilities, Developer 2000 (Forms 6i/5.0, Reports 3.0/2.5), TOAD, Rapid SQL
  • Programming/Web Technologies: Visual Basic 6, PL/SQL, Visual InterDev 6.0, HTML, ASP.Net, VBscript, JavaScript, Crystal Reports, TOAD, MS Front Page, Apache Web Server, IIS 5.0/4.0
  • Web & App Servers: Java, JSP, HTML, ASP.NET, XML, VBScript, and JavaScript, IIS, Tomcat Jakarta, iPlanet, Weblogic, Web Sphere
  • Languages: C, C++, VB.net, SQL, PL/SQL, Java, ASP.Net
  • Environment: Netscape Directory Server 4.2, MS Windows, Microsoft .Net, MS- Dos 6.22, Unix, Sun Solaris.

Professional Experience:

Confidential,
Jersey city, NJ,
Senior Business Intelligence Developer. Dec'08 - Current

Confidential is the most-widely circulated daily newspaper in the U.S with a large daily circulation and also the first U.S. daily printed in tabloid form. Worked in Tech-ops department not only as a business intelligence developer but also actively involved in various multiple projects.

Responsibilities:

  • Interacted with clients gathered functional and technical requirements for report specifications.
  • Installed XI 3.1 and migrated and tested all the data from xi r2 to 3.1.
  • Used Import wizard to import existing User accounts, Groups, Categories, Universes, Reports (FC and Web I), Connections and Universe restrictions from BO XI R2 to BO XI 3.1 environment.
  • Involved in developing, designing and maintaining new and existing universes by creating joins, cardinalities Classes, Objects and Conditional Objects.
  • Created Aliases and Contexts to resolve the Loops and chasm traps, fan traps.
  • Used Index awareness, Analytical functions, Short cut joins to optimize the performance of universe.
  • Created complex reports Linked Summary report with Detail report in Webi using Info view in order to obtain detail information contained in summary report.
  • Involved in production support by modifying and correcting production reports.
  • Created Data Flow Diagrams (DFD) to define the data element and translate data requirements for ETL processing
  • Worked with ETL Data integrator team to build data warehouse.
  • Developed reports from a number of internal and external data sources like Oracle, SQL Server, and MYSQL.
  • Used Business Objects Central Management Console in creating and managing the users.
  • Created derived tables written many SQL queries, procedures, Cursor, Triggers.
  • Tuned Report Performance by using Oracle's new built in functions and rewriting SQL statements.
  • Very strong in Client/Server Architecture, Relational Databases (RDBMS), Data Modeling, Data marts using Star Schema and Snow Flake Schema for faster and effective Querying.
  • Trained end users in understanding the reports. Functionalities such as Slice and Dice, Prompt, Drill mode and Ranking were used for Multidimensional Formatting.
  • Created How-To-Guide documents for the end users on training Webi and universe designing.
  • Worked extensively with the major functionality of BO like Breaks, Ranks, Variables, Alerter, Variables, Formulas, Calculated data items, Filters, Sorts, and Query prompt and Drill filters.
  • Created reports include formatting options such as Charting, Mapping, Grouping, Sorting, Alerting, Field highlighting, Drill-down Parameter prompts, custom hierarchies and scheduled the reports through publications.
  • Worked with application architects & data architects to tune queries and to ensure performance.
  • Worked as a Team and also acted independently to get the work done.

Environment:
Business Objects XI R 3.1/3.0/XIR2(CMC, CMS, CCM, Designer, Desk I, Web I Rich Client, Info View, Performance Manager, Import Wizard), Crystal Reports XI, Web services, Oracle 10g, SQL Server 2008,MY SQL, TOAD, PL/SQL, T-SQL, SUN Solaris, UNIX, SharePoint WSS 3.0.
// if (window.showTocToggle) { var tocShowText = \"show\"; var tocHideText = \"hide\"; showTocToggle(); } //

Confidential
Morton Grove, ILSept'08 - Dec'08
Business Objects/ETL Developer

Confidential is a vibrant part of the global economy, High-technology engineering and manufacturing, fluid Technology, Defense Electronics and services, Motion & Flow control portfolio of businesses is aligned with enduring, global growth drivers, and meeting the needs of the people who buy and use Confidential products and services in all the markets they serve.

Responsibilities:

  • Study the business process and gathered the client requirements interacting with Business Users to know the Business logic in developing and modifying Universes and Reports accordingly.
  • Installed and configured the Data integrator.
  • Designed projects, Workflows, jobs, Data flows, to load data from source to target in Business Objects Data Integrator.
  • Worked extensively with flat files and imported them to the SQL server tables and views.
  • Extensively Used most of the transformations to get the data from source to target tables.
  • Worked on Meta data reports to analyze the data in data integrator repository.
  • Worked on metadata integrator to collect the data from CMS to Data integrator repository.
  • Scheduled Data Integrator jobs using Data Integrator Administrator and BOE Scheduler.
  • Performance tuning of Business Objects including testing and modification of universe structure and reports.
  • Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies
  • Created graphical representation of reports such as Bar charts, Pie charts as per End user requirements. Created reports for various Requirements using universe as the main data provider and also worked with external data providers.
  • Worked Extensively on Universe Development and Reporting.
  • Worked on Creating Groups, Folders and set rights to users.
  • Worked on Row level and Object level security in the universe.

Environment: Business objects XI/R2, Data integrator 11.7, Desktop Intelligence, Web Intelligence, Infoview, Designer XI/R2, Crystal Xcelsius, Central Management Console, Central Management Server, Toad 8.0, SQL Server 2000, Data Integrator 11.7, Data Integrator Admin.

Confidential,
Knoxville, TN Feb'08-Jun'08
Senior Business Intelligence/Business Objects Developer

Confidential is comprised of the lifestyle television brands Confidential. Confidential is the dominant media and marketing company in the home, food and lifestyle categories, developing content for television and the Internet, where on-air programming is complemented with an array of broadband video, social media areas and e-commerce components on companion Web sites that attract more than 18 million unique visitors each month.

Responsibilities:

  • Gathered Functional and technical requirements from the clients and delivered the product on time.
  • Configured XI R2 and trained small set of end users on crystal enterprise architecture.
  • Interacted with the Informatica and data base Developers to understand the Data load process to resolve the data quality issues to support the universe.
  • Set up groups and users for Business Objects deployment using the Central Management Console and assigned the access rights based on their profile.
  • Worked on universe development with complex objects , joins, aggregate tables, derived tables, cascading list of values, resolved loops using contexts,
  • Worked on implementing security features like row level & object level in the universe also worked on universe performance issues exported the universe to the CMS repository.
  • Extensively worked on reports with complex queries open doc function, combining queries, multiple data providers used complex variables, breaks, sorting, calculations, and alerts.
  • Created most of the canned, adhoc reports in webintelligence. Published reports on a daily, weekly and monthly basis through infoview.
  • Migrated the universe from dev to testing and prod in XI R2 using the import wizard.
  • Converted .rep documents to webi using the report conversion tool for the testing purpose only.
  • Validated the data by running SQL queries against data base.
  • Extensively worked on Oracle SQL tuning, complex joins and materialized views to optimize database performance.
  • Worked with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
  • Worked with Cognos and developed some of the proof of concept reports.

Environment: Business objects XI/R2, Data integrator 11.7, Desktop Intelligence, Web Intelligence, Infoview, Designer XI/R2, Crystal Xcelsius, Central Management Console, Central Management Server, Toad 8.0, Oracle 10g

Confidential, STAMFORD, CT May'07- Jan'08
Senior Business Objects/Business Analyst.

Confidential intends to reduce the marginal cost of new business through more effective use of our existing application infrastructure and facilities as well as the use of new and more cost efficient technologies. The program is organized into six major areas that work together to avoid $500MM in infrastructure costs over 5 years and improve the way we manage the firm's application computing estate and facilities. These areas include: Capacity Planning and Management, Tech Refresh, Storage, Grid, Virtualization, and Reporting and Communications.

Responsibilities:

  • Installed Business Objects XI R2 client products worked on both administration and development.
  • Gathered requirements directly from end users and converted them in to technical specifications.
  • Every day interaction with the data modelers and data base developers to implement logical and physical data model which supports the universe.
  • Developed a complex Universe with joins, classes, objects, resolving loops with alias, contexts.
  • Created graphical representation of reports such as Bar charts, Pie charts as per End user requirements. Created reports for various Requirements using universe as the main data provider and also worked with external data providers.
  • Worked on ad-hoc and complex reports using multiple data providers, drill down, cross tab, master-detail, combined or Union Queries saved them to public folders using webintelligence.
  • Actively participated with the Testing team to create the test plans to test the Business Intelligence Reports.
  • Involved in dealing with Production Support issues.
  • Involved partially in multiple teams under multiple projects and worked with dashboard manager, Performance manager, crystal xcelsius, Data Integrator, crystal reports.
  • Involved in Crystal Xcelsius implementation and reporting.
  • Worked on Dashboard reports compared with the crystal xcelsius for the internal purpose.
  • Worked closely with crystal enterprise team and developed some reports in crystal XI R2.
  • Performance tuning of Business Objects including testing and modification of universe structure and reports.
  • Installed XI R2 on sun Solaris for testing purpose.
  • Migrated from 6.5 to XI R2 both testing and production environment.

Environment: Business objects XI/R2, Data integrator XI, Desktop Intelligence, Web Intelligence, Infoview, Designer XI/R2, Crystal Xcelsius, Crystal Reports XI/R2, Central Management Console, Central Management Server, AIX, Toad 8.0, Oracle 10g.

Confidential, CHICAGO, IL Feb'07 - May'07
Senior Business Objects / Data Modeler

Confidential application is to provide a reporting environment that satisfies the business requirements for Policy Center SP2. The project is intended to build a reporting model and environment to support mainly Small Business Operational reports defined as High & Medium priority. Create Universes to acquire the data necessary to support the defined reports and create a reporting model that will support both Small Business (SP2) and new business once it moves into Policy Center in a future release.

Responsibilities:

  • Worked on most of the Data warehousing concepts to design the star schema data model.
  • Converted functional specifications to technical and designed development specifications.
  • Got trained in insurance domain to understand the policy centre data.
  • Involved in BO system migration from version 6.5 to XI R2.
  • Prepared the migration specs and finalized the documents on migrating users, BO reports, files and universes from 6.5 to XI R2.
  • Developed Universes on aggregated and the detailed tables (star schema) exported them to the repository to available for end users.
  • Checked Cardinalities, Joins and created Contexts, Aliases for resolving Loops and checked the Integrity of the Universes.
  • Designing, developing, deploying & testing the universe for report generation.
  • Created reports for various portfolios using universe as the main data provider.
  • Created & tested reports using Business Objects functionality like Queries, Slice and Dice, Drill down, @Functions, charts, alerts for the measures etc.
  • Worked on ad-hoc and complex reports using multiple data providers, drill down, cross tab, master-detail, combined Queries.
  • Created reports like Transaction Summary report, Assignment History, Policy Detail, Productivity Policies Issued & Non Issued, and Policies Renewal& Non Renewal Reports.
  • Tested the Created reports and modified the relevant objects in the Universe.
  • Actively participated with the Testing team to create the test plans to test the Business Intelligence Reports.
  • Created charts, used complex variables, breaks, sorting, calculations and alerts in the reports.

Environment: Business objects XI/R2, Desktop Intelligence, Erwin, Web Intelligence, Infoview, Designer XI/R2, Crystal Reports XI/R2, Central Management Console, Toad 8.0, Oracle 10g.

Confidential, NEW YORK, Aug'06- Jan'07
Senior Business Objects Developer/Business Analyst

Involved in a project to support the Business Objects application that has 3 BO universes in use, which are pointing to various data warehouses ORACLE & SQL Server databases. Also, necessary training is provided to the users in creating the BO reports. Flat files were transformed according to the Data Model of Data Mart using the ETL designer tool, Informatica and loaded into relational tables.

Responsibilities:

  • Helped in installing Business Objects Client V6.5 locally and created repository, users, user groups and assigned profiles to users using Supervisor module.
  • Interaction with end users and senior business analysts to identify and develop business requirements (functional specifications) and transform them into technical requirements and ultimately will be responsible for delivering the solution.
  • Analyzed the database design, understanding the relationships between database objects and building Universes for deployment.
  • Customized reports using Web Intelligence SDK, WIBEAN using JAVA (JSP).
  • Customized Business Objects and Designer using Business Objects SDK
  • Involved in creating reports with full client, thin client.
  • Resolving Loops, Chasm Traps and Fan Traps in the process of building Universes.
  • Extensively used complex variables, breaks, sorting, calculations, and alerts for creating Business Objects Reports.
  • Analyzed and exported reports in different perspectives using Slice and Dice and Drill mode.
  • Applied Security Features of Business Objects like row level, object level and report level to make the sensitive data secure.
  • Created graphical representation of reports such as Bar charts, Pie charts etc, Drilling, Combined queries, created report level variables with many calculations.
  • Performed SQL Queries. Scheduled and distributed reports using BCA.
  • Deploying Business Objects Reports over Web and Testing of Reports.
  • Written VB sripts for manually scheduling the full client reports.
  • Trained and mentored the user community to work with Universes and Reports.

Environment: Business Objects XI R2, Business Objects 6.5, Web Intelligence 6.5, Broadcast Agent 6.5, oracle 9i, PL/SQL, Windows 2000, VBA for Macros.

Confidential, INDIA Sept'03 -Dec'05
Programmer/Analyst:

Policy Inquiry website sign up project is a web-based application for agents or customers. This project involves in developing the website with Registration and Sign-up process for the Agents online. It also gives provision for the registered users to view the Account details adds additional information, view activity, and export transactions.

Responsibilities:

  • Reviewed the Software Requirements for clarity and testability.
  • Reviewed unit test cases against software design.
  • Designed and executed System test cases.
  • Responsible for defect tracking and analyzing the test data
  • Wriiten VB code for the insurance website.
  • Interacted with the end users and developers.
  • Used Backend as Oracle to store the data.
  • Developed reports using business objects.

Environment: ASP, VB, Oracle, Win runner, Test Director.

Hire Now