EXPERIENCE SUMMARY

• About 7 Years of total experience in Information Technology Industry with an of expertise in Reports Designing, Database Designing, Data Modeling, Performance Tuning, ETL - BODI, Datastage, Business Intelligence and Data Warehouse applications, Worked extensively on Oracle, MS-SQL.
• With Strong Knowledge in all phases of Software Development Life Cycle (SDLC) such as developing Reports, testing, Migrating, Administrating, security management and production supporting.
• Technical hands-on expertise using OLAP tool Business Objects 6.0 /XIR2(Reports, Designer, Web Intelligence, Info view, and Supervisor)
• Hands on experience on Performance Tuning of SQL queries, Scheduling Reports and Migration issues in BO framework
• Experienced in interacting with business users to analyze the business process and requirements and transforming requirements into screens, designing database, documenting and rolling out the deliverable
• Sound knowledge on BO XI3.1 Architecture and new features, Knowledge on BOXI 4.0
• Worked in Universe designing, developing and generating complex, dashboard Reports, List of values along with User Acceptance Test (UAT) and data accuracy test
• Developing the Reports as per the requirement
• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Alerts, Filters, Ranking, Graphs and Breaks
• Design, development and coding with ORACLE 10g/SQL Server 2000
• Worked in production support project so can execute development and support at different levels as per the necessity
• Hands of experience in Crystal Reports Report creation
• Experience in Analysis in Pricing and discount module
• Experience Designing Xcelsius Dashboard
• Experience as a Data analyst and worked on building the business requirement.
• Understanding the functional document and writing the technical documents.
• Excellent communication and interpersonal skills working within multi-diverse teams

TECHNICAL SKILLS

Domain Knowledge: Healthcare, Manufacturing alcoholic Beverage, Human Resource

Tools: Business Objects XIR2/6.X, Business Objects Data Integrator 11.7, Informatica 8x

Database: Oracle10g, SQL Server 2000, Teradata

Languages: PL/SQL, C, C++

Operating System: Windows XP/2000/98, Vista

PROFESSIONAL EXPERIENCE

Confidential

Senior Developer

Responsibilities:

• Translated the Functional Document into the Technical Document by understanding the Business requirement and then developing the reports out of it
• Designing and building of Universes, Classes and Objects based upon revenue, costs, and performance and customer management systems.
• Designed the Universe by creating the Business Objects data model, selecting/joining tables, Indicating cardinalities, created aliases to resolve the loops, used Aggregate function and created the objects which are grouped into classes based on Business Functionality.
• Writing the Code Review checklist and the Unit test cases for the Reports
• Created various types of reports/sub-reports and drilldown reports, standard and crosstab reports with bar chart, pie-chart and line-chart graph representation reports using Business Objects.
• Analyze the requirement and suggest improvements to business users
• Resolution of loops, fan traps, chasm traps using contexts and aliases and its combinations, checking of cardinalities, maintaining integrity of the Universes

Confidential

Analyst

Responsibilities:

• Designed and implemented Dashboard for the pricing and discount team for their daily and monthly analysis.
• Participated in project planning sessions with project manager, business analysts and team members to analyze business requirements and outline the proposed solution.
• Sourced the Webi reports into Microsoft excel and used Excel formulae to trim and manipulate data.
• Performed various operations like scheduling, publishing and retrieving reports from corporate documents using the business objects reporter
• Responsible for numerous decisions in respect to business policies, procedures, methods for implementation
• Designed and implemented Pricing and Discount System to automate hedging of various bookings, cycle time, Discounts.
• Providing solutions in the form of Graphs like Bar graph, Pie chart of the analysis and presenting to the client in order for them to understand the trend in a easy graphical ways.
• Conducting meetings with users, developers, and database design team to deal with backend synchronization issues
• Used MS-Access to manipulate the data fetched from different sources and do calculations. In later part I have automated the system by using the Macros.
• Created reports using Business Objects using functionalities like slice and dice, drill down, @functions, cross tab, master/detail tables, formulas and etc.
• Performed analysis-using Excel as per the requirements for the sake of Understanding for the managers
• Trained Business users in creating Web Intelligence reports
• Used Desktop version (DESKI) to create Reports and to pull out the data to do some analysis.

Confidential

Developer

Responsibilities

• Creation of the pilot reports and then the live reports in crystal reports
• Created crystal reports 2008 by directly connecting through ODBC to the database.UsedCrystal Reports 2008 SDK for generating customized reports
• Analyzed the existing database and designed the Universes using the BusinessObjects Designer Module. Defined Business Objects Classes and Objects
• Used Excel as backend and created dummy reports for client and get necessary approvals.
• Working on the bug fixing
• Regular change requests from the client
• Created Dashboard using Xcelsius.
• Used advanced SQL queries to investigate possible solutions.

Confidential

Developer

Responsibilities

• Analysis of the functionality of the Report using Report screen shot provided by the client
• Prepared Functional and technical specification for the Resources management Observer and request management system modules
• Provide security levels by giving limited access.
• Developed reports on monthly and weekly basis for RMO
• Developed the Complex Dashboard Report
• Responsible for overseeingtheTesting at different stages-Unit testing and integration testing
• Performed ETL jobs using BODI for generating reports
• Performed scheduling of the jobs
• Worked on Post production support for RMO and RMS
• Testing of Business Objects and Reports which Includes
• Worked in creating technical Documents like Report Requirement specification (RRS), Unit test cases, Test Log, RRD (Report Requirement Design)
• Migrated reports from BOXI R2 to BOXI R3 and worked on fixing the bug.
• Porting the reports to the production environment
• Monthly scheduling the reports to over 150 clients
• Working on Regular Change Request CRs
• Testing Reports after porting from development server to Production Server

Confidential

Developer

Responsibilities

• Analyzing the original reports
• Testing of Business Objects and Reports which Includes
• Database Connectivity
• Tested objects in the Universe to ensure the correct mapping of the objects
• Tested the Universe Structure to ensure that tables are properly uploaded
• Tested the aggregate Universe to ensure the query is pulling correct level of Aggregation.
• Preparing the functional and technical document
• Movement of Entire Database to ORACLE from SQL server2000
• Creating jobs using BODI
• Development of reports
• Perform unit testing for the reports.
• Created Alerts using Business objects to highlight columns based on business criteria.
• Created variables, @Prompt objects, formulas, @aggregate and worked with multiple Universes at a time (Multiple Data Providers).