PROFESSIONAL SUMMARY:

• Over 14 years of experience in SDLC 8 years' experience withBusiness Intelligence Tools like SAP Business Objects Reports, Crystal, Xcelsuis and Oracle BI reports. Worked in different domains which include Pharmaceutical IT Security Identity Access Management , Supply Chain Retail, Financial/Banking, Logistics, Insurance and manufacturing sectors. I've an excellent communication interpersonal skills, ability to work effectively as team member as well as individually, project result oriented team player with good leadership qualities, organizational abilities and time management skills. Highly motivated and driven to succeed.
• Expertise in Reporting Tools such as SAP BI4.0 and Business Objects Webi, Deski, Universe Designer, Central Management Console Administration.
• Experienced in Universe Reports Migration to newer version and documenting entire process in project life cycle.
• Implemented Complex Business Audit Reports that involves multiple views, tables, procedure functions using DB data modeling design and exposing objects to universe
• Worked extensively in leading, developing and implementing various reporting solutions.
• Implemented Derived Tables, Aggregated Tables using Aggregate Awareness concept in the Universe and responsible for creating Indexes, views to increase the performance of the universe.
• Expertise in design and implementation of Xcelsius Dashboards using QaaWs, Live office and XML sources.
• Experienced in BO Administration Console by creating users and user groups, restricted access to users as per request using Central Management Console CMC . Involved in managing users, groups, folders and published reports using Central Management Console.Create many ad-hoc reports, dashboards list of values LOV along with user acceptance test UAT .
• Extensively used Business Objects Reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Grouping, Graphs and Breaks, Formulae.
• Experienced in SAP Business Objects BI4.0 Enterprise XI Release 2, Webi, Deski, Universe Designer, Universe Builder, Info View, Xcelsius, Crystal Reports 10 and Evaluated Qlikview
• Expertise in designing Database models, applicationsdevelopment and reporting tools.
• Experienced in ETL tools like Oracle Data Warehouse, Data Stage MS SQL Server DTS packages
• Expertise in OracleSQL, PL/SQL, Forms Reports, TSQL, MySQL, UNIXShell Scripts.
• Experienced in interacting with business directors, managers, users and analysts on multiple projects.Experienced in preparing report specifications, database designs documents to support the reporting requirements.
• Comprehensive understanding of the techniques used to analyze and specify data structures within an application system that provides operational, ad hoc, OLAP analysis, and reporting functions.
• Implemented reusable report components, standard scheduled reports that runs daily, weekly, monthly, quarterly and annually.Worked extensively in dynamic interactive reports instance schedules.
• Expertise in writing and implementation of the packages, triggers, stored procedures, functions, views, materialized views, indexes at Databaselevel usingoracle PL/SQL.
• Experiences in converting excel spreadsheets data into analysis reports for use with Xcelsius dashboards and then basic components of Xcelsius charts, buttons, and labels .
• Experienced in migrating reports from Oracle to Web based Reports using Business Objects Suite of products.
• Worked on Live Office objects and QueryAsAWebservice WSDL's while developing BO Executive Dashboards.
• Created Excel Dashboards using QwaaS, Live Office.
• Active team leader player with excellent communication, interpersonal skills, self-motivated fast learner, good listener.

TECHNICAL SKILLS:

Reporting Tools: Business Object suite XI R3.1/R2/6.x/5.x , Business Objects BI 4.0, SAP BW ,Web I XI/6i/2.6, Designer, Reporter/Desktop Intelligence/Web Intelligence Rich Client 3.1 , Supervisor, Broadcast Agent, Info view, Crystal Reports 2008/XI/10, Crystal Enterprise, Central Management Console, Xcelsius, QaawS, Live Office, Xcelsius 2008/4.5. OBIEE Oracle Discoverer Report Oracle Designer tools

ETL tools: SQL Loader, Data Stage Informatica Power Center 8.1, 7.1, 6.2.

Databases: Oracle 11g/10g/9i/8i/7.3, SQL Server 7.0/2000/2005, Sybase, MySQL, DB2, Teradata and MS Assess.

Data Modeling Tools: ER Studio, VISIO, Dimensional Data Modeling Star Schema,

Snow-Flake, FACT Dimensions , ERWIN 6.1/4.5/3.5. ,iGrafx

Languages: SQL, PL/SQL, C, C , JAVA, J2EE, HTML, XHTML

Operating systems: UNIX, LINUX, Windows 98, XP, 2000/NT.

Application Servers: Web Logic, Web Sphere, Tomcat.

Software Packages: MS OFFICE

PROFESSIONAL EXPERIENCE:

Confidential

Role: Operational Report Analyst Project Lead in IT Security domain IAM - Identity Access Management Business Technology Infrastructure

Responsibilities:

• Designed many challenging Business Objects XI R2 Enterprise Reports and delivered to multiple users via email and ftp folder.
• Involved in designing multiple Universes and migrating existing ad-hoc from Deski, Crystal Reports Webi and Xcelsius reports.
• Participated in requirement gathering, analysis and structuring of Business Intelligence objects reports based on user requirements and conducted meetings every month for group of Directors to help them understand how their units are doing
• Modifying the existing universes, adding new objects and changing existing objects
• Worked as an administrator in creating users, folders and managed the access privileges in Windows.
• Responsible for creating file based events and scheduling various Webi reports to different business users on daily, weekly and monthly basis.
• Created multiple breaks, sorts and complex variables in the reports.
• Created reports using Business Objects using functionalities like drill down, functions, cross tab, master detail tables and formulas, etc.
• Used Prompts in the reports as well as the Universe to create more interactive reports for the users
• Trained the power users/end users in Business Objects
• Implemented breaks and sections in the reports for white spaces and better navigation.
• Extensively used Designer to design various universes for different business groups.
• Created Contexts and Aliases for resolving Loops, and synchronization problems in the SQL and created cascading prompts in the universe. Created complex reports using cascading prompts, decode objects etc.
• Created dashboards, graphs using Crystal Xcelsius. Personalized the dashboards to reflect user-specific alerts and metrics to track critical Key Performance Indicators KPI .
• Expertise in creating executive Dashboards using Crystal Xcelsius by importing data from excel file to create the visualization using Live Office.
• Extensively used Web Intelligence Info view, reporter and explorer for querying, reporting and analysis tasks.
• In Info view, implemented customized logins at application level and provided password-reset options to the users.
• Involved Design, Development and Implementation of Reports using Crystal Reports Developer XI. Created Sub reports called from the main report to implement the business logic.
• Developed reports containing Crystal Formulae, SQL Expressions, Selection Criteria, and Sub Reports etc.
• Tested and implemented SMTP email and FTP scheduling feature of BO Reports.

Environment: SAP Business Objects XI 4.0 Desktop Intelligence, CMC, CMS, Application Foundation, Data Integrator, Web Intelligence, Designer, Universe Builder, Import Wizard , Oracle 10g, BI 4.1,Xcelsius Dashboards, Crystal Reports 2010, MS SQL Server 2000/2005, AD LDAP.

Confidential

Responsibilities:

• Designed many challenging Business Objects Reports Scheduled and Monitored OEM Data Load jobs and report jobs.
• Involved in designing reports for retail sales Data Warehouse ETL tool support.
• Responsible for daily, weekly data load operations completion, bug fixes schedules in OEM.
• Involved in creating the SRS / BRS for 'Reporting' which included enhancements to existing ad hoc reports.
• Leading a team of Report Developers ad-hoc reporting projects
• Responsible for supporting issues in reports on the BI enterprise environments Development, UAT, Test and Production .
• Responsible for Sign-Off on the BI Reports after release
• Performed unit, regression and functional testing of the created reports.
• Wrote Complex SQL Queries for Data validation.
• Worked on RDBMS like Oracle, SQL server.
• Exported reports into various formats like XML, PDF, HTML, EXCEL, and WORD for user.
• Managed customer expectations to ensure strong customer satisfaction by meeting the business needs for IT systems in a timely manner.
• Create and maintenance of PL/SQL packages.
• Day to day communication with client related new requirement, support and development

Environment: Business Objects 5/6i, XIR2, Oracle SQL, PL/SQL 10g, 9i, Oracle Reports 9.0, Crystal Reports 2008, DB2, Oracle Enterprise Manager, Oracle Internet Directory, and Data Mart, HP Unix, IBM AIX Unix, Oracle Application Express, Oracle Discoverer, Oracle Report Server, TOAD Oracle APEX

Confidential

Responsibilities:

• Worked on Data Migration, Oracle Crystal report, Scheduled jobs Used Java XML for designing the reports
• Developed deployed various new reports for client
• Actively involved in data processing using Oracle PL/SQL and scheduled reports
• Used Java XML, Excel calculations pivot tables charts
• Supported Incident Management
• Change Management

Environment: Oracle SQL, PL/SQL 10g, 9i, Oracle Reports 9.0, Crystal Reports 2008, DB2, TOAD, Java XML

Confidential

Description: This is one of the top financial institutions in India. The scope of this project is to process auto loans, customer analysis, calculate the interest and repayment amounts. I was involved in system registration, master data and transactions systems processing I was also involved in the development of new modules for CRM from the design thro' implementation phase. Experienced in system migration of LGF acquisition Merger financial institution and successfully completed transition of their entire system data to the respective modules in SSL Deposit Systems.

Responsibilities:

• Designed system modules, created HLDs LLDs based on the SRS.
• Worked with Development team to get the development done along with unit testing and final scope verification UAT
• Managed a team of 3members in various development activities of this project life cycle.
• Developed many challenging UIs and reports required by the project Business Clients
• Worked on Testing UAT
• Used Documents Version Control tool
• Developed reports using Discoverer Reportstool
• Created Tables, Views, Functions, Procedures, Packages, Triggers Jobs etc., at database level
• Used Oracle Forms trigger events logic to implement business functions

Environment:Oracle 9i 8i , Oracle Forms6i and Reports6i, UNIX, OEM, TOAD Oracle Designer 6.0 and BI Discoverer Reports

Confidential

Responsibilities:

• Developed and Maintained Piton Financials ERP Standard Accounting, Payments, Collections, Budgets and Assets system.
• Developed complex entry forms and reports for General and Analytical ledger and Journal entry screens. This ERP contains a complete set of financial reports, which has several dimensions and almost all the fields would by dynamically selected by the user
• Developed Modules based on the specification given for UI Reports in Oracle Designer and Reports.
• Involved in analysis of individual modules, assigning and scheduling the modules to the developer, explaining and clarifying the issues unit testing the entire module.
• Managed a team of 3 members in various development activities of the project life cycle
• Developed integrated Dynamic Reports using Oracle Reports using Oracle Designer UIs

Environment:Oracle 8i, Oracle Designer 6.0, Forms and Reports, TOAD SQL Loader