We provide IT Staff Augmentation Services!

Bi Developer Resume

Minneaolis, MN

SUMMARY:

  • 8+ Years’ Solid expertise in Creating Complex Applications using Tableau 10.2/9.1/8.1 , SAP BusinessObjects BI 4.1/4.0/ XI 3.1, Crystal Enterprise 2011/2008/XIr2/10/9/8.5/8.
  • Designed and developed Work books and interactive Tableau Dashboards to provide detailed and enhanced visualization of data using key features available as per the requirement of the users.
  • Excellent understanding of Application Development LifeCycle and expertise in Data modeling and Data Warehousing using Agile Methodology.
  • Experience in Business Objects BI4.1/BI4.0/XI3.1/XIR2/6.x/5.x (Business Objects SDK, Desktop/Web - Intelligence 4.1/ 4.0/ XI3.1/ XIR2, CMC, CCM, CMS, Launch pad, Info view).
  • Experience in designing Universe, Web Intelligence, Desktop Intelligence, creating ad-hoc reports and archiving reports along with performing User acceptance testing and Data accuracy test.
  • Extensive experience in Designing and Developing Reports such as List reports, Parameterized, Mail Label, Cross tab Reports using the base tables, Views, Commands, involving Formulas, Subtotals, running totals and Sub reports using Crystal Reports 2011/2008/XIR2/10/9/8.5/8.
  • Developed complex report and Dashboard using PowerBI and migrated an existing crystal report into PowerBI.
  • Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
  • Developed visualization reports using DOMO as an alternative to Tableau.
  • Experience in Database Applications with Oracle, SQL Server, MS Access and very efficient in tuning the SQL queries and using several tools & utilities.
  • Experience in writing and debugging Stored Procedures, Views and triggers using T-SQL Script.
  • Good Knowledge of installation, configuration of MS SQL Server 2005, 2000 and 2008.
  • Hands on experience in Performance Tuning, Query Optimization, Client/Server Connectivity.
  • Working experience in Relational Database Management systems (RDBMS), Star Schema and Multidimensional Data Modeling.
  • Experience in coding using SQL, SQL*Plus, PL/SQL Procedures/Functions, Triggers and Packages. Extensively involved in installation of Oracle database, performance analysis, tuning, and capacity planning.
  • Strong experience in single and multi-dimensional data warehousing applications using Business Objects Enterprise and Business Intelligence Products.
  • Strong skills of writing SQL Queries using SQL Server /Oracle Databases.
  • Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Extraction, Data Transformation and Data Loading ETL.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, C, HTML, DHTML, Java, JavaScript

Databases: Oracle 8i/9i/10g/11g, SQL Server 2000/05/08, Teradata, Sybase, IBM DB2, MS Access

Tools: Business Objects 4.1/XIR3/R 2/6.5/6.0/5.1, Crystal Reports XI/10/9/8, Tableau 10.2/9.1/8.1, Power BI, SSRS, DOMO, WebFocus.

ETL: Informatica Power Center 6.2/7.1/8.6/9.5, Business Objects Data services, SSIS, IBM DataStage 8.0.1DW Methodologies: Data Warehousing Design, Data Modeling, Logical and Physical Design

Others: ERWIN 4.1.2/4.x/3.x, Excel, version control, SQL Navigator, SQL Developer, TOAD

PROFESSIONAL EXPERIENCE:

Confidential, Minneaolis, MN

BI Developer

Responsibilities:

  • Being part of Modernization Team, involved in understanding existing reports in various platforms and coming up with the best way to recreate those reports in new platforms that are available as part of Modernization of the reports.
  • Followed Agile methodology, Scrum process for Modernization of reports.
  • Developed simple to complex visualization reports using Tableau as well as DOMO.
  • Involved in Tableau Administration to schedule reports and assign rights to the users to view the reports.
  • Involved in conversion of existing reports in Tableau and WebFocus to DOMO and DataStream,
  • Self learnt new tools like DOMO, DataStream, GreenField by myself and implemented various reports and projects using these new tools.
  • Used Teradata SQL Assistance to implement SQL logic later used in DataStream to perform ETL jobs or to create simple Excel reports.
  • Used DOMO reporting tool to develope various reports and converted existing Tableau reports into DOMO based on the requirements using the available features in DOMO.
  • DateStream is a proprietary tool used for ETL related jobs and for creating simple excel reports.
  • Implemented various features like creating ETL jobs to transform and Load Data from DB2 to Teradata, and to Push Data over to DOMO to create reports and also generating excel reports using DataStream tool.
  • Recreated WebFocus reports in DataStream to replicate the Excel reports generated in WebFocus.
  • GreenField is also a proprietary tool like Tableau and DOMO developed within Confidential to develop Visualization reports.
  • Improved existing WebFocus reports as per the new Requirements and converted few WebFocus reports to either DataStream reports or DOMO reports.

Environment: Tableau, DOMO, WebFocus, Teradata, SQL assistance, DB2, DataStream, GreenFiled, Windows 7.

Confidential, St. Paul, MN

BI developer

Responsibilities:

  • Involved in meetings to understand the acquisition process between Hoya and Confidential and solely responsible for the migration of reports from Confidential to Hoya making sure all the changes are made as per requirement before the migration is complete.
  • Worked extensively with both the company users to understand the business and involved in the development, enhancements and migration of reports as per the requirements from both Confidential and Hoya using Business Objects, Tableau and Crystal.
  • Conducted meeting with the users at Hoya to understand and migrate the existing crystal reports on Confidential server to Hoya Server.
  • Scheduled reports using VB script on Hoya server on Daily, Monthly, Quarterly, Half-yearly and Yearly basis.
  • Responsible for research and introduction of crystal report scheduler CRD to the team and trained
  • Involved in all the meetings and discussed the best approach possible for the existing reports to be migrated and new reports to be developed.

Environment: Tableau 10.2, Crystal 11, Crystal Reports XI R2, Crystal Info View XI R2, Oracle PL/SQL, Microsoft Access 2007/2016, Windows 7.

Confidential, Minneapolis, MN

BI Developer

Responsibilities:

  • Developed huge number of reports using Business Objects as part of CluePoints reports requirement for different studies like EVOLVE II, EVOLVE Short DAPT against Keystone database to generate different types of reports like Protocol Compliance, Visits, Visit Compliance, AE (Adverse Events), Enrollments etc.
  • Used tables and added new derived tables to the existing BO Universe as per the requirement and published to create new reports and improve existing reports.
  • Worked on a very critical issue where a standard Business Objects report (AE Coding report) used by all the Studies was populating duplicate records for only 1 Study (Longevity) to figure out what was wrong and responded back to the user in very short period.
  • Worked extensively as part of Clinical IT team to understand the business and involve in the development of the reports based on the requirements of users from various departments in BSC like RM (Rhythm Management), IC (Interventional Cardiology) using Tableau.
  • Reviewed and involved in obtaining the Business requirement documents along with business analysts and developed complex reports based on the requirements and going through multiple discussions with the team.
  • Created a Tableau Dashboard to compare types of treatments called SOLYX and OBTRYX II, where units like Enrollments, Subject Retention, Queries, AE’s, Deviations are compared which are interactive and can be filtered for desired time periods and Studies Involved in the program.
  • Developed Interactive dashboards for RM (Rhythm Management) and IC (Interventional Cardiology) departments to visually evaluate different scenarios by adjusting key variables using Tableau.
  • Imported Views from RAVE database, improved and Enhanced according to the Keystone Database to access all the required Data.
  • Developed report on various studies including sub-reports, Maintained and enhanced existing Crystal reports as per the requirement changes and moved to production.
  • Mapped various Studies to GUI RULES which are part of overnight Keystone run to insert new data (new studies) into keystone.
  • Initialized and documented on the Source to Confidential Mapping of each study in the GUI RULES for easy access and clear understanding of the source and Confidential of each study being accessed for various purposes.
  • Very good understanding of Data Warehousing Design Methodology, Data Warehouse Concepts, Database design/architecture including both OLAP & OLTP data and complete lifecycle of project from design to development and implementation.
  • Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
  • Worked with Informatica team to perform FULL Load of the database whenever required
  • Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
  • Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using Informatica.
  • Worked on the existing Materialized views used for Catalyst reports to enhance and make changes eliminate an existing issue.
  • Created and enhanced Materialized views, involved with team in making necessary changes to Keystone Rave Body and Study Specific Packages for new studies and to improve performance of the reports of existing studies.
  • Used Tortoise SVN for version control and coordinated with team on the latest version of any existing code or which is under development.
  • Used BOX tool to save and update documentation on different processes and sprint Deployment related files and notes online which can be accessed by all the team members. Updated as soon as the development work is finished.
  • Used JIRA tool during sprint and daily Stand-up to track progress on the projects assigned and bug fixes.
  • Extensively followed Agile methodology, especially Scrum process and Extreme programming for software development.

Environment: Tableau 10.1, Business objects 4.1, IDT, Crystal Reports 11, Info View, BO Web Intelligence 4.1, Tortoise SVN, JIRA, BOX, Informatica, Oracle 11g, PL/SQL, TOAD 12.10, SQL Developer, Win SQL and Windows 7.

Confidential, Rochester, MN

BI Developer

Responsibilities:

  • Worked extensively with the team to understand the business and involve in the development of the reports based on the requirements from various clients working with Confidential .
  • Reviewed Business requirements documents from business analysts and prepared functional specification documents and completed the report application development.
  • Used Business Objects to develop complex reports based on the requirements provided and going through multiple discussions with the team and responsible for scheduling reports to higher officials on Monthly Basis.
  • Included Report Design and Coding for Standard Tabular type reports along with Drill Down, Drill through Functionality and Graphical presentations such as Charts and Dashboard type metrics for effective analysis.
  • Applied security features of Business Objects like row level, report level & object level security in the universe to make the sensitive data secure.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau Desktop.
  • Developed few sample dashboards using Tableau to present the data with excellent visualization and got the approval from users.
  • Interactive dashboards were developed using Tableau for executives to visually evaluate different scenarios by adjusting key variables.
  • Developed ad-hoc reports along with static reports using Crystal reports and scheduled them to run on monthly/quarterly basis as per the requirement.
  • Developed complex reports using drill down, slice and dice, master/detail for analysis purpose and headcount.
  • Developed dashboards using Xcelsius and Crystal reports for Health Living Online Analysis, Health Assessment, Risk Stratification, Lifestyle Risk Factors, Medical Risk Factors and Various other factors.
  • Developed very crucial reports using SSRS with complex formulas and queried database to generate different types of reports like MCTQ ( Confidential Tobacco Quit), CallitQuits and Stratification Billing Reports.
  • Expertise in using global variables, expressions and functions for the reports with immense experience in handling sub reports in SSRS.
  • Created UNIX shell scripts, JCL mainframe procedures, and processes to extract data from various sources such as DB2 and Oracle.
  • Coding using BTEQ SQL of TERADATA, write Unix scripts to validate, format and execute the • SQL's on UNIX environment.
  • Created, tested, and documented Teradata Multiloads for moving data into Teradata.
  • Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.
  • Strong Data Warehousing ETL experience of using Informatica 9.1/8.6.1/8.5/8.1/7.1 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools, Informatica Server, Repository Server manager.
  • Worked with Match Transforms, Address Cleanse and Data Cleanse Transforms for US Data Cleansing in Data Quality.
  • Worked on Change Data Capture on both Source and Confidential level for SCD (Slowly changing Dimension) Type 1, Type 2 and Type 3.
  • Used TFS as a tool to keep track on the progress of work assigned and for the version control of the development.
  • Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
  • Documented and updated bugs/defects along with workaround solutions using Quality Center.
  • Extensively involved and was part of the team in developing reports and dashboards using POWERBI (SSRT).
  • Helped in providing all the required metrics and calculations along with the required fields for creating a cube for the development of a report called AMCO using POWERBI.

Environment: Tableau 10.1, Business objects 4.0, IDT, Info View, CMC, Crystal Reports XI R2, POWERBI, Xcelsius, SAS, SSIS, SSRS, Teradata, Oracle 11g, PL/SQL, TOAD, SQL Developer, Win SQL, Windows 7.

Confidential, Nashville, TN

BI Developer

Responsibilities:

  • Involved in gathering requirements from the users, creating spec and layout of the report.
  • Worked with the team to understand the Business Rules and Process of Logistics.
  • Interacted with the ‘Operations’ Team in understanding the requirement and the data mapping of the reports.
  • Modified and developed new reports and few dashboards using Tableau tool with enhanced visualization of the data.
  • Involved in tuning the SQL Queries for better report performance.
  • Developed Tableau workbooks from multiple data sources using Data Blending.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Designed multiple reports which include ‘Bill of Lading Report’, ‘Packing List Report’, ‘Open Orders Report’, ‘Inventory Adjustment Report’, ‘Stock Status Report’ etc. using Tableau.
  • Worked in ‘Application Reporting’ team for designing new reports using Tableau & Crsytal along with production support of the existing reports.
  • Developed universes as per the requirement and migrated from one environment to other.
  • Created Sub-reports to implement the UOM Conversions for the Items from eaches to Cases or from Cases to Pallets as per the report requirements to the existing Crystal Reports.
  • Responsible in moving the reports from TEST to PRODUCTION folders after Customer's approval and scheduled reports on CMC Server on daily/weekly/monthly to be sent to the customers.
  • Effectively designed reports using Views, Stored Procedures, Sub-Reports, Cross-Tabs, Drill - Down, Running Total Fields and Shared Variables using Crystal reports.
  • Expert in generating Sub Reports, Standard, Mailing Labels, Cross Tab Reports and Graph Reports including shared and global variables by using Chart expert of Crystal Reports.
  • Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
  • Sound understanding of end to end Data Migration process including Extraction, Data Profiling, Transformation and Generation of Load ready data files.
  • Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems and to export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2005/2008.
  • Developed database triggers and stored procedures using T-SQL cursors and tables.
  • Gathered requirements for shipping labels and designed customer specific labels using Loftware.
  • Extensively used different fonts and symbologies in printing the Barcodes on the reports.
  • Responsible for the support and development of new and existing shipping and packing labels.
  • Used Cherwell ticketing system for version control of the reports and to know the status of the report.

Environment: Tableau, Crystal reports, SSIS, Oracle 11g, PL/SQL, SQL Developer, Windows.

Confidential, Buffalo, NY

BI Developer

Responsibilities:

  • Involved in gathering requirements from the users, creating spec and layout of the report.
  • Developed Tableau visualizations and dashboards, created action filters, parameters and calculated sets for preparing dashboards and worksheets from multiple data sources using Data Blending. using Tableau Desktop.
  • Modify and developed many existing reports as per the requirement changes by adding new logics and removing existing logics and by creating new Parameters, Formulas etc., as the line of Business changes periodically using Tableau.
  • Used Footprints tickets for version control of the reports to know the status of the report.
  • Schedule the reports using Infoview to run at specific times in a day/week as desired by the Business Users.
  • Designed and developed Crystal Reports, the Cross-Tab Reports for displaying vital data and summary reports with drill-down capabilities.
  • Expert in generating Sub Reports, Standard, Mailing Labels, Cross Tab Reports and Graph Reports by using Chart expert of Crystal Reports.
  • Applied Agile Methodology for all BI Reporting and Security project.
  • Creating reports using SQL SSRS 2008 and perform maintenance of existing reports
  • Designed and developed stored procedures, queries and views necessary to support SSRS reports
  • Using Informatica PowerCenter Designer analyzed the source data to Extract & Transform from various source systems (oracle 10g, DB2, SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
  • Used ETL (Informatica) for Creating Jobs, Work flows, data flows and scripts in Data Integrator to pull data from the legacy systems and load the data into Confidential database.
  • Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
  • Responsible for creating mapping and transformation specifications based on the business requirements from various business teams and implemented in Data Integrator jobs.
  • Used advanced features of T-SQL to design and tune T-SQL to interface with the Database and other applications in the most efficient manner and created stored Procedures for the business logic using T-SQL.
  • Created Database Objects - Tables, Indexes, Views, Stored Procedures and User defined functions according to the requirements of the project.
  • Create various database objects like Tables, Views and Stored Procedures by using Toad.
  • Assist UAT team in testing the reports using SQL queries in TOAD, SQL developer and Win SQL and advise them with necessary changes.

Environment: Tableau 9.1, BO Web Intelligence 3.1, UDT, Info View, Business Objects Designer, Crystal Reports XI R2, Oracle 10g/9i, PL/SQL, SSIS, SSRS, TOAD, SAS, Rapid SQL, SQL Developer, Win SQL, UNIX, Windows 7.

Confidential, Chicago, IL

BI Developer

Responsibilities:

  • Reviewed Business requirements documents from business analysts and prepared functional specification documents and completed the report application development.
  • Design and Development of Business Objects Universes per user requirements, considering all possible business scenarios to drive static, analytical and ad-hoc reports.
  • Defined Contexts, created Joins and Aliases for resolving loops and traps in the universe.
  • Developed ad-hoc reports along with static reports and scheduled them to run on monthly/quarterly basis using Infoview as well as CMC to measure the performance of the marketing campaigns using Business Objects.
  • Developed Web Intelligence reports using Business Objects universe as data source.
  • Developed complex reports using calculations, variables, breaks, sorting, drill down, slice and dice, master/detail for analysis purpose and headcount.
  • Developed Interactive visualization dashboards for Profitability Analysis, Locational Rental Analysis, Monthly Rental Analysis, Forecasted Rentals and Revenue and what if analysis using Xcelsius.
  • Interactive dashboards were developed for executives to visually evaluate different scenarios by adjusting key variables.
  • Developed dashboards as per the requirements using Tableau Desktop to explore new features and visualization techniques available.
  • Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
  • Used different transforms such as Query, Case, Table Comparison, Key Generation, Merge, Data Generation, Pivot transforms and functions like ifthenelse(), substr, lookup, lookup ext etc.
  • Provided support to CDES (consumer data enhancement services) reports and extensively involved in report bug fix.
  • Created summarized views and involved with database team in reporting data mart development to improve the performance of the reports.
  • Created User Prompts, Conditions and Filters to improve the quality of report generation.
  • Extensively involved in using Formula fields, parameter Fields, Group Selection and Record Selection in Webi Reports.
  • Developed very complex Active reports in a multidimensional environment using Transformer Cubes using Cognos reporting tool.
  • Developed various reports like List reports, Cross Tab reports and Drill through Reports using Cognos Report studio.
  • Developed several complex reports using cascaded prompts, Drill Through, master-detail relationships, Page sets, Joins, Unions using Cognos report studio.
  • Created Requirements and Wireframe design documentation for BOBJ projects using Agile Methodologies
  • Extensively used Team Foundation Server (TFS) as a version control tool.

Environment: Tableau, LifeCycle Management Tool (LCM), Cognos BI, Active reports, Oracle 11g, Toad for Oracle, MS Access.

Confidential, Monterey Park, CA

Business Objects/Crystal Reports Developer/ Web Intelligence

Responsibilities:

  • Participated in project planning sessions with project managers, system analysts and team members to analyze business requirements and outline the proposed solution and prepare functional specification document.
  • Extensively worked on Webi reports for Elections and Addendums in modifying the existing templates and in creating new ones and worked on the functionality to reduce the number of Webi reports needed to a minimum.
  • Applied security features of Business Objects like row level, report level & object level security in the universe to make the sensitive data secure.
  • Designed and maintained complex Universes, resolved loops by creating aliases and contexts using aggregate strategies to aggregate data, sorting and joining tables.
  • Developed Stored procedures, User defined functions, Views, T-sql scripting for complex business logic. Optimized the database by creating various clustered, non-clustered indexes, index views and complex SQL queries in SQL Server.
  • Created the WEBI Report and used Events for Daily/Weekly /Monthly Scheduling of the reports.
  • Implemented security using Active Directory groups in Crystal Enterprise and assigned rights to the groups for providing access to the folders for various departments
  • Designed and developed Crystal Reports such as Parameterized Reports, Cross tab Reports based on base tables, views, involving Formulas, Sub Totals, Running Totals, and Sub Reports.
  • Developed various types of Charts and Graphs like Bar Chart (Side by Side, Stacked), Line Graphs, Pie Charts, etc by using Chart expert of Crystal Reports.
  • Created reports that show various calculated values like OCC index, ADR index and RevPAR index, along with % changes compared to last year, for the time periods like Last month, YTD (Year to Date), Running 3 months and running 12 months.
  • Extensively involved in using Formula fields, parameter Fields, Group Selection and Record Selection in Crystal Reports.
  • Good understanding of Software Development Life Cycle(SDLC), Agile Methodologies.
  • Created SSIS packages to perform ETL, data profiling, data quality, data cleansing and data extraction from various sources like Flat Files, Excel Files, and OLEDB and load to Data mart.
  • Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
  • Developed a Tabular Reports, ad-hoc reports using SSRS Report Designer.
  • Expert in tuning the performance of SQL queries.

Environment: Business Objects XIR3.1, WebI, Xcelsius, Universe Designer, Oracle 8i/9i, PL/SQL, Crystal Server 10/XI, SQL Server 2005/2008, T-SQL, Xcelsius, SSIS, SSRS, Windows

Confidential, Nashville, TN

Business Objects/Crystal Reports Developer

Responsibilities:

  • Involved in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
  • Involved in documenting the changes to the universe and reports functionality.
  • Designed and developed Business Objects Reports such as Parameterized Reports, Cross tab Reports, Mail label, List reports based on base tables, views, involving Formulas, Sub Totals, Running Totals, and Sub Reports.
  • Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks
  • Developed various types of Charts and Graphs like Bar Chart (Side by Side, Stacked), Line Graphs, Pie Charts, etc by using Chart expert of Crystal Reports.
  • Extensively involved in using Formula fields, parameter Fields, Group Selection and Record Selection in Crystal Reports.
  • Generated Reports using the BO Universe as the main Data provider and using the personal data files provided by the users and Free-hand SQL as data provider.
  • Created New Classes and User Objects according to the requirements.
  • Created Joins, Contexts, and Aliases for resolving Loops and Universe Tuning and checked the Integrity of the Universes.
  • Expert in tuning the performance of SQL queries.

Environment: Crystal Reports XI, Business Objects XI r2/65, Web Intelligence, Xcelsius, SQL Server 2005, T-SQL, Business View Manager.

Confidential

Business Objects/Crystal Reports Developer

Responsibilities:

  • Worked with business process owners in collecting Project specifications and their Analysis.
  • Generated Reports using the Universe as the main Data provider and using the personal data files provided by the users and Free-hand SQL as data provider using Business Objects.
  • Designed reports using Crystal Reports including Formulas, Parameters, Selection Criteria, Sub reports to handle Report Requests
  • Extensive experience in creating reports with Charts (Bar Charts, Pie Charts, etc), Cross tabs and Sub reports using multiple data providers for building reports.
  • Analyze Requirements and write technical specifications with the business analysts to develop Reports that conform to the enterprise standards.
  • Access multiple different OLAP sources in the same report to get a comprehensive view of the business and the cross-impact that one trend may have on another.
  • Used Xcelsius to create interactive Dashboards and provides the ability to create management charts, which are at-a-glance displays that show the status of business metrics.
  • Extensively participated in the development of the Universe based on underlying relational (data structures) star schema. Resolved several issues with regards to the contexts, predefined conditions, same prompts handling multiple data sources etc.
  • Created/Administered users/user groups/Security in Supervisor/CMC.
  • Imported existing users, groups, categories, WebI documents, connections, universes and restrictions to BO XI environment using Import Wizard.

Environment: Crystal Reports 10, Business Objects 6.5.2/ XI R2, Xcelsius, Web Intelligence, 6.5, Infoview 6.5, SQL Server 2005, Microsoft Visio, Windows XP, ASP.Net, MS Access 2003, MS Excel 2003, Autosys.

Confidential

Crystal Reports Developer

Responsibilities:

  • Worked with business process owners in collecting Project specifications and their Analysis.
  • Designed Crystal Reports using Crystal Reports 10, Formulas, Parameters, Selection Criteria, Sub reports to handle Report Requests
  • Extensive experience in creating reports with Charts (Bar Charts, Pie Charts, etc), Cross tabs and Sub reports.
  • Analyze Requirements and write technical specifications with the business analysts to develop Reports that conform to the enterprise standards.
  • Access multiple different OLAP sources in the same report to get a comprehensive view of the business and the cross-impact that one trend may have on another.
  • Use a comprehensive range of business and time calculations.
  • Using Xcelsius created Dashboards and provides the ability to create management charts, which are at-a-glance displays that show the status of business metrics.
  • Extensively participated in the development of the Universe based on underlying relational (data structures) star schema. Resolved several issues with regards to the contexts, predefined conditions, same prompts handling multiple data sources etc.

Environment: Crystal Reports 10, Business Objects 6.5.2/ XI R2, Xcelsius, Oracle 9i/10g, Web Intelligence, 6.5, Infoview 6.5, SQL Server 2005, Teradata v2r6, DB2, Microsoft Visio, Windows XP, ASP.Net, MS Access 2003, MS Excel 2003, Autosys.

Hire Now