Post Job Free

Resume

Sign in

Developer Crystal Reports

Location:
Danville, CA
Posted:
April 21, 2016

Contact this candidate

Resume:

Radha Krishna Cell: 669-***-****

Email: acuf7n@r.postjobfree.com

Radha Krishna is a Business Objects developer with a rare combination of excellent communication skills, deep technical knowledge and broad SAP functional experience. His passion is designing and implementing technical solutions that enable companies to significantly increase the value derived from their investment.

Skills:

Over 8 years of experience as a Business Objects Developer.

8+ years of IT industry Experience.

With strong knowledge in all phases of Software Development Life Cycle (SDLC) such as developing, testing, Migrating, Administrating, security management and production support on various platforms like UNIX, Windows NT/2000/XP/98.

Worked with End-to-End implementation with Data warehousing team and Strong understanding of Data warehouse concepts OLTP, OLAP, Star Schema, Snowflake Schema and Multi-Dimensional Models for query and analysis requirements.

Experience in designing Universe using Universe Design Tool & Information Design Tool.

Experience in developing reports using Web Intelligence, Crystal Reports and Dashboard design tools.

Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.

Experience in Optimization and Performance tuning of new and existing Business Objects universes, reports.

Data Modeling using Star Schema and Extended Star Schema for Data reporting.

Strong Knowledge of RDBMS and SQL.

Expert in tuning the performance of SQL queries and ETL process.

Ability to work under pressure with cross-functional, cross geographic and cross-cultural teams

Excellent communication skills both verbally and written.

Proactive and self-starter with the great ability of leadership.

TECHNICAL SKILLS

Tools Business Objects (4.0/XIR3.1/XIR/6.5), BODS 4.0, Designer, Crystal

Reports 2008/XI/Enterprise, Xcelsius Data Visualization, Central

Management Console, Central Configuration Manager, Desktop

Intelligence, Web intelligence, Webi Rich client, Live Office,

Import Wizard, Report Conversion Tool and Services.

Databases Oracle 10g/9i/8i, MS SQL Server 2000/2005/2008/2012, Sybase 11,

SQL *Plus, PL/SQL, IBM, DB2, MS Access, SAP BW, SAP ECC 6.0, SAP ERP

Languages C, C++, SQL, PL/SQL, XML, HTML, Perl, Shell

Operating Systems Windows 2000/XP/NT, MS DOS and UNIX

Utilities MS Word, MS Excel, MS PowerPoint

Work Experience:

Role: Sr. Technical Lead April 2015 – Present

Client: Cyient Inc., Arlington, TX

Responsibilities:

Provide technical support in creating new Web Intelligence reports as per blue print provided.

Need to do performance tuning for faster update of reports.

Guide and Train new engineers in developing reports.

Drive client level meetings. Need to address all client quires related to reports generated.

Modify or update reports as per client request.

Perform address and data cleansing using BODS before report generation as per the client guidelines.

Create required aggregate tables using BODS as per reporting requirement.

Environment: SQL Server 2008/2012, SAP BOBI 4.1, Web intelligence, BODS 4.0, CMC, BI Launchpad, Information Design Tool.

Role: Sr. BO Developer April 2013 – April 2015

Client: AMD, Sunnyvale, CA

Responsibilities:

Work with Project Manager to gather Business user requirement before generating reports.

Manage enterprise business intelligence solution based on BI 4.0 platform.

Interact with Senior Business Objects Consultants as well as Business users to identify the reports for developing and modifying as per Business user requirements.

Optimize and perform tuning of new and existing business objects universes and reports.

Export the universes to the repository to make resources available to users for ad-hoc reporting needs.

Migrate universes from development to production environment.

Work with Date Modellers and ETL team to resolve data issues.

Test the reports developed to ensure that the date is accurate and valid.

Perform data verification comparing the existing reports against the new reports.

Work with BO administrator to resolve security issues.

Create ad hoc dash board reports as per Business User requirement.

Train Business Users to interpret and modify reports as and when needed.

Develop universe user document guide for end users reference.

Environment: MS access, SQL Server 2012, SAP ECC, SAP BOBI 4.0, Dashboard Designer, Information Design Tool, BODS 4.0, CMC, BI Lauchpad.

Role: Sr. BO Developer Nov 2011 – March 2013

Client: Advanced Micro Devices, Austin, TX

Responsibilities:

Participate in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.

Build the new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.

Used Derived tables to create the universe for best performance, and use context and alias tables to solve the loops in universe.

Exported the universes to the repository to make resources available to users for ad-hoc report needs.

Create reports containing all information using web intelligence.

Created custom dashboard reports as per the requirement.

Created complicated reports including sub-reports, graphical reports, formula base and well-formatted reports according to user requirements.

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

Developed universe user documentation guide for end users reference.

Involved in full life cycle of Business Objects Reporting application.

Created Multiple Universes in Designer in secure connection as well shared connection.

Trained users to use interpret and modify reports as and when needed.

Environment: Information Design Tool, CMC, SAP ECC, SAP CRM, SQL Server 2008, Crystal Reports for Enterprise, WebI.

Role: Report Developer Nov 2010 to Oct 2011

Client: Advanced Micro Devices, Orlando, FL

Responsibilities:

Provide technical support in designing and development for Universe.

Creating universes by defining connections and retrieving data from database

Generated reports for web users using Web Intelligence.

Extensively used designer to design various universes for different business groups.

Generated various reports on daily, weekly, monthly and yearly basis.

Imported/Exported the universes from/to repository to make them accessible to end users.

Created charts to display summary data using universe as main data provider.

Monitored and solved the issues encountered in universes and reports while migration and tested before moving to production.

Developed universe user documentation guide for the end users reference.

Provided training for end users for generating their own report including complicated report.

Environment: Universe Design Tool, Information Design Tool, SAP BW, SAP ECC, BI Launchpad, WebI, Live Office.

Role: BO Developer April 2010 to Oct 2010

Client: Black Watch Data, Atlanta, GA

Responsibilities:

Worked with Safety Directors and PM’s to gather user requirements.

Documented the user requirements into Functional and Technical Specifications.

Analyzed database tables for report requirements and developed Hierarchy Table for Organization Hierarchy.

Created Derived Tabled for Multiple Incidents Employees (MIE) who were involved in more than 1 incidents for a given time period.

Created Prompts in the MIE derived table, so that users can enter certain criteria for MIE.

Created Cascading LOVs for the Organization Hierarchy in Hierarchy Prompt.

Used Contexts and Aliases to resolve Chasm Traps and Fan Traps.

Built complex formulas in the Desktop Intelligence documents to accommodate business rules and the report formatting.

Created several standard reports Desktop Intelligence Documents for the Safety Department, which uses Refresh On Open so that each time prompts are presented to the users to select the report Criteria.

Created various condition objects as prompts so that users can use these objects in their Ad-Hoc reporting.

Environment: Oracle 10g, Universe Design Tool, Desktop Intelligence.

Role: Sr. Report Developer July 2009 to March 2010

Client: Intercontinental Exchange, Atlanta, GA

Responsibilities:

Involved in Analyzing and Documenting End user requirements, Business requirements and data specifications for Business Objects reports.

Involved in the creation of Universes, Classes, Objects and Hierarchies for Multidimensional Analysis for Loans, Checking Accounts, Saving Accounts, Accounts Balances and Revenues Generated.

Created and setup Universes for each reporting group and established a BO Environment.

Created Derived Tables in the Universe to create frequently used reports.

Work with staff to upload Crystal Reports to server.

Created graphical representation of reports such as Bar Charts, Line Charts as per end user requirements.

Involved in full life cycle of Business Objects reporting application.

Trained users to use interpret and modify reports as and when needed.

Created Executive Level Dashboards using Xcelsius.

Created custom dashboards using Xcelsius as per the requirement.

Environment: Universe Design Tool, Xcelsius 2008, Crystal Reports, SQL Server 2008

Role: Report Developer Aug 2008 to June 2009

Client: UCB, Atlanta, GA

Responsibilities:

Interacted with teams to gather their Business requirements in developing and modifying Universes and Reports accordingly.

Involved in designing and building of Universes, Classes and Objects.

Designed, Developed and Maintained Universes by defining joins, cardinalities between tables, applying context and alias tables to remove cyclic dependencies.

Importing/Exporting the Universes from/to repository to make them accessible to end users.

Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab etc.

Used @functions like @select, @where and @prompt function to create prompts which helps the user to select the values dynamically.

Customized the list of values (LOVs) which helps the end users to select the values.

Created many Crystal reports after gathering the requirements from business user.

Exported the reports in to PDF and Excel format.

Worked with Data Modelers and ETL team to resolve data issues.

Migration of Universes and reports from development to Production environment.

Environment: Universe Design Tool, Crystal Reports, Desk Top Intelligence

Role: Jr. Developer July2007 to Sept 2008

Client: Oldcastle, Atlanta, GA

Responsibilities:

Development of the existing reports in Excel and Oracle8i, now in Crystal Reports.

Data verification comparing the existing reports against the new Crystal Reports.

Be part of the team for the implementation of Business Objects Crystal Enterprise.

Attend to the training of the Business Objects Crystal Enterprise.

Creation of database objects like tables, views, procedures using PL/SQL, SQL.

Prepared program specifications for PL/SQL Procedures and Functions to do the data migration and conversion.

Optimize SQL queries for better performance.

Run batch jobs for loading database tables from flat files using SQL loader.

Provided occasional IT support by configuring servers and desktop systems.

Environment: Oracle 8i, MS Excel, Crystal Reports, SQL

Education:

Master of Science in VLSI Engineering

Bachelor of Technology in Electronics and Communication Engineering

References:

Available on request



Contact this candidate