We provide IT Staff Augmentation Services!

Sr. Report Developer Resume

4.00 Rating

CA

SUMMARY

  • Over 8 years of experience in Enterprise Data Warehousing and proven expertise in implementation of Business Intelligence & Datawarehouse tools/applications.
  • Excellent knowledge in Analysis and Development of Business Intelligence reports using SAP Business Objects XI R2/XI 3.1, SAP Business Objects 4.1 & Tableau software.
  • Well versed with Onsite - Offshore model, And ability to communicate techinical and functional requirements in a clear and easy manner.
  • Worked extensively in Business Intelligence using SAP Business Objects XI R2,3.1&4.0 (Integration Designer Tool, Universe Designer Tool, Universe Designer, Web Intelligence, CMC, Live Office, QAAS, Xcelsius 2008,Crystal 2008,Live Office, Import Wizard Tool, Report Conversion Tool).
  • As a Solution designer, worked with business users closely to effectively capture and define business requirements.
  • Expertise in writing SQL queries, PL/SQL programming using Oracle, SQL Server & DB2
  • Strong knowledge in Data warehouse, Data modeling concepts and Star Schema/snowflake schema.
  • Good exposure towards understanding of SAP BW systems, Bex queries and worked on BO reporting using BW system.
  • Extenstive experience in creating/enchancing Business Objects Universes, complex web intelligence reports, crystal reports, Xcelsius dashboards.
  • Experience in Installation, Configuration and administration of Tableau Server in a multi-server and multi-tier environment
  • Extensive experience creating canned and ad-hoc reports in Tableau Desktop.
  • Worked as Business Objects Adminstrator and provided user level access restictions and created new users & groups.
  • Extensive experince to convert business objects content from one region to another region(Dev, QA & Prod) and upgrade from one vesion to another(From SAP Business Objects 3.1 to 4.1).
  • Worked as Tableau developer and created sample demo reports using large databases.
  • Expousure in ETL process and data loads from source to target using SQL Server Integration Services & Informatica.
  • Ability to debug data from mutliple sources and troubleshoot reportings issues.
  • Entensive experience in direct client interaction for requirements gathering, analysis and implementation of BI Solutions.
  • Good interpersonal & communication skills which lead to excellent customer support on a day to day basis and helping the customer in using software to maximize the efficiency and strong problem solving skills.
  • Provided trainings to Business Users to understand BO environment and usage of the adhoc reports.
  • Extensive experience in streamlining support and operational activities for BO environments.
  • Excellent understanding of Software Development Life Cycle principles and worked on end-to-end applications.
  • Proficient in capturing & representing data in MS Excel.
  • Expertise in understanding data and played a key role as a data analysit.
  • Created dynamic dashboards using xcelsisus thourgh live office and QAAS connections.
  • Provided support to testing team in Integration, Funcational and User Acceptence testing phases and resolved defects raised in Quality Center.
  • Excellent knowledge in root cause analysing and resolving production incidents, capture and follow these soultions in future requirements.
  • Ability to work in a team environment, meet deadlines and handled tasks independently.

TECHNICAL SKILLS

BI Tools: SAP Business Objects 4.0, XI 3.1, R2, Crystal Reports 2008, Xcelcius 2008, Information Design Tool, Universe Designer, Info view, BEx Query, Web Intelligence, Business View Manager, Live Office, QAAS and Tableau

ETL Tools: Informatica, SSIS

Platforms: Windows, Unix

Databases: SQL Server 2008, Oracle 10g, 9i, MS-Access, DB2

Languages: C,SQL, PL/ SQL

Products: SAP BW 7.1, Microsoft Office, HP-Quality Center

Others: MS-Office, SAP BW

PROFESSIONAL EXPERIENCE

Confidential, CA

Sr. Report developer

Responsibilities:

  • Meeting extensively with end users/clients to understand requirements.
  • Clarified client requirements, business needs and project objectives, via feedback sessions and client meetings, in collaboration with all stakeholders.
  • Strategized project scoping and specifications documents, to clearly communicate the project roadmap.
  • Created one complex dashboard which consists of 5 years of data through live office feed.
  • Designed, Created and Managing Business Objects Universe.
  • Created Solution requirements Specification documents as per project requirements.
  • Ensure other team members would understand requirements and make sure they created high level design & low level design documents.
  • Provided project deliverables status to client on weekly basis.
  • Monitored offshore team members work on daily basis.
  • Ensured the smooth flow of application in development, test and production environments.
  • Provided impact analysis to Project management based on user requirements.
  • Creation and implemented adhoc reporting system using Business Object Universe. Tested objects in the universe, to ensure the correct mapping of the objects.
  • Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
  • Created user defined @prompts and complex conditions at Universe level for better performance.
  • Resolved table-joining problems like Chasm trap and Fan trap using context and Alias
  • Worked with Multiple data providers including Personal Data files, Stored Procedures and Freehand SQL to create reports.
  • Created & tested reports using Business Objects functionality like Queries, Slice and Dice, Drill down, @Functions. Created graphical representation of reports such as Bar charts, Pie charts as per End user requirements and inserted Breaks in designing reports.
  • Created alerters, report filters and query filters, thus user can identify significant changes.
  • Creating and Formatting the Reports as per the Users Requirements using the features in BOBJ like Master/Detail, Charts, Cross tabs, Slice and Dice, @functionsandFormulaeto analyze the data.Creating and distributing Report Templates to Users andMain Data Providers for creating these reports are - Universe
  • Ensure deliverables has been completed in time with superior quality.
  • Played a key role in mapping out timelines, milestones, and communication process.
  • Created web intelligence reports through Business Objects Universe and published in repository.
  • Participated in report migration activity from Dev - Test - Production environments using import wizard.
  • Verified and validated test cases designed by testing team.
  • Provided application support and defect fixing in test region.
  • Provided end user training to understand business objects environment.
  • Created Tableau desktop dashboard with 5 years of data.
  • Modified existing webi intelligence reports to make work in mobile/Ipad.

Environment: Business Objects XI 4.1, SSIS, SQL Server 2008, Dashboard Designer, Tableau Desktop

Confidential, San Francisco, CA

Tableau Developer

Responsibilities:

  • Interacting with business stakeholders to understand their decision making parameters, analyzing the available data to build Tableau Dashboards and managing the delivery
  • Participated in regular Technical Reviews, Defect review and walkthrough meetings with important project & business stakeholders throughout the project life cycle.
  • Mainly dealt with sales and networking team to analyze the sales which lead to the increase and decrease in the sales region by region.
  • Administered user, user groups, and scheduled instances for reports in Tableau.
  • And with networking team, built dashboards about the outages and network loss in each and every region around the globe.
  • Used Tableau Desktop 8.2 to build dashboards and PostgreSQL as a data source to analyze and build the visualization for the networking team
  • Defined and created procedures to install Tableau desktop in silent mode. Defined best practices for Tableau report development.
  • Deployed Tableau Server in clustered environment by mapping server nodes to primary machine. Provided 24/7 production support for Tableau users.
  • Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues
  • Developed Complex Reports (Used multiple data providers, Union, Intersection, minus and Master/Detail, cross tab, Charts).

Environment: Tableau Desktop 7.0, SQL Server Integration Services, SQL Server 2008.

Confidential, Pleasanton, CA

Analyst / Lead

Responsibilities:

  • Interacted with the Business Users to analyze the business process, gathered the requirements and made necessary changes to schema objects to fulfill their reporting and business needs.
  • Analyzed the source data and work with Data Warehouse team in developing Relational Model.
  • Designed and Developed Universes by adjusting parameters, defining joins, cardinalities and implementing features like predefined filters and Conditions.
  • Created different classes, sub classes by assigning dimensional, detailed and measure objects according to the requirements.
  • Created contexts and Aliases to resolve the loops problems in universe, derived tables using inner/ outer and equal joins as per the requirement.
  • Assigned privileges according to their profiles based on CMC.
  • Developed custom hierarchies in universe level and Scope of analysis in report level to drill up and drill down the reports.
  • Used Report Conversion Tool to convert Desktop intelligence reports to Web intelligence reports.
  • Worked extensively with PL/SQL, TOAD for writing user defined queries, stored procedures, views, Indexes.
  • Worked very closely with ETL team to have necessary Views and data loaded for the creation of Reports.
  • Involved in UAT and also in Unit testing.

Environment: Business Objects XI-R2, Informatica 7.1, DB2, Crystal Reports 2008

Confidential, St.Louis, MO

Business Objects Developer

Responsibilities

  • Implemented Aggregate, Filter, Join, Expression, Lookup and Update Strategy transformations.
  • Executed sessions, sequential and concurrent batches for proper execution of mappings and sent e-mail using server manager.
  • Created multiple Universes using Business Objects and resolved Loop and Join problems by creating Aliases and Context.
  • Used Aggregate Awareness feature of Business Object Universe for better performance and smooth execution of BO reports.
  • Worked on WEBI in developing and publishing thin client reports.
  • Migration of Universes and reports from development to Production environment.
  • As a part of BO Universe development:- have created classes, different kinds of objects, cardinalities, strategies, resolved loops using Aliases and Contexts as well as used various functionalities like:- Default and Custom Hierarchies, conditions on list of Values (LOV), calculations, functions and derived tables for improved performance.
  • Created several ad-hoc reports using functionalities such as use of: multiple data providers, merge dimensions, master/detail, cross-tab, multi-dimensional analysis, drill analysis, scope of analysis, filters, charts, alerts, breaks, section, ranking, sub-queries and combined queries(Union, Minus, Intersection).
  • Developed Slowly Changing Dimension mappings (Type 1 and Type 2) to capture deleted as well as inserted records in the source systems.
  • Implemented Aggregate, Filter, Join, Expression, Lookup and Update Strategy transformations.
  • Executed sessions, sequential and concurrent batches for proper execution of mappings and sent e-mail using server manager.
  • Created multiple Universes using Business Objects and resolved Loop and Join problems by creating Aliases and Context.
  • Used Aggregate Awareness feature of Business Object Universe for better performance and smooth execution of BO reports.
  • Worked on WEBI in developing and publishing thin client reports.
  • Migration of Universes and reports from development to Production environment.

Environment: Business Objects XI-R2, Informatica 7.1, Oracle 9i

Confidential

BI Developer

Responsibilities:

  • Played a key role in the development of reports using Webintelligence.
  • Involved in the creation of Hyperlink reports, drilled reports, summary reports and used the various components of table formats and templates.
  • Played a key role in the Universe development .
  • Migration the project using BO import wizard tool.
  • Involved in the development of dashboards using Xcelsius-2008
  • Played a key role in testing of reports.

Environment: Business Objects XI-R2, Informatica 7.1, Oracle 9i, Xcelsius

Confidential

BO Developer/Support

Responsibilities

  • Played a key role in the source level discussions and in the universe development life cycle.
  • Provided access level restrictions at the row level, universe level, folder level.
  • Created diversified reports such as Cross tab, Drill reports Summary reports.
  • Used the formatting techniques such as Breaks, sections, and implemented alerts in reports.
  • Applied Advanced Query techniques such as Combined queries, sub queries and the implementation of
  • Calculated Contexts methodologies.
  • Created and maintained documentations such as Universe Design and Report design as per standard templates.
  • Created Derived Tables in the universes.
  • Linked Universes to share the Universes which had common dimension tables and the classes and objects.
  • Involved in Writing Detailed Level Documentation for reports and Universe design.
  • Created a logical representation of the data model in the Designer module.
  • Using the merge dimension feature in Webi linked appropriate dimension objects at the report level.
  • Created Cascading prompts in the universe as per the user requirements, Customized LOV’s(List of Values) as per the user requirement
  • Created hyperlink WEBI reports using opendoc function and created some drill down and drill up reports
  • Involved in Business meeting with the Business users for requirements gathering, business analysis and making technical specifications for the reports.
  • Responsible for analysis of the systems, meeting with end users and business units in order to define the requirements.

Environment: Business Objects XI-R2, Informatica 7.1, Oracle 9i

We'd love your feedback!