HIGHLIGHTS:

• Over Twelve plus years of experience in client/server and web technology, including around 10 years of experience in OLAP/OLTP/DSS Data Warehousing presents distinctive competency in Oracle Database Administration, SQL, PL/SQL, Microsoft SQL Server 2005,2008 , and other Business Intelligence tools such as Business Objects, Cognos, Qlikview, Tableau.
• Extensive experience as a Team lead in designing and building BO Universes under Data warehouse environment, developing complex canned reports and maintaining Security with Business Objects and directing the team in a right way and mentoring the team.
• Experienced with various Data Warehousing activities includes right from gathering business requirements, conceptual designing, doing logical data modeling, creating approved data model as a Database, mapping from source to target includes ETL design , Designing Universes in Business Intelligence, creating Reports, development, testing and deployment.
• Expertise in all modules of Business objects suite comprising the BO Reporter, Designer, Supervisor, Web Intelligence XIR2, Desktop intelligence, Central Management console, Life Cycle Manager, Import Wizard, Publishing Wizard, Report conversion tool and Performance Management
• Commendable knowledge in resolving FAN Traps and CHASM Traps and resolving Loops in both OLTP and Data warehousing environments.
• Configured BO to get data from SAP BI 7.0 with SAP BO Integration kit.
• Developed and designed BO universes with Classes and Objects using SAP BW Info Cubes to generate WEBI Reports.
• Experienced to work with various version control tools like PVCS and Clear case.
• Highly experienced in implementing Dashboards using Dashboard Management / Performance Management in Business Objects 6.5/ XI R2.
• Experienced with various Data warehouse schema techniques like STAR, Snow flake, Hybrid, Multi STAR etc. and implementing techniques for slowly changing dimensions SCD .
• Willing to work hard to meet intensive schedules and having excellent communication, presentation and interpersonal.
• Received several prestigious awards in GMAC/Ditech from Business world for implementing Business Objects Best practices.

TECHNICAL SKILLS:

Operating Systems: UNIX Solaries 2.x , IBM AIX 5.2, and Windows95/98/NT/ 2003 Server

Languages: SQL Plus, PL/SQL, XML, JAVA script, HTML DHTML VB Script and Visual Basic 5.0 6.0

RDBMS: Oracle7.x 8.x/9i/10g SQL Server, DB2 UDB, MS Access.

Software Packages: MS - Excel, PowerPoint, Word, TOAD, PVCS.

ERP Packages: SAP R/3, SAP BW 3.5, SAP BI 7.0

ETL: Datastage vers 5.x,6.x,7.x ,8.x- Designer, Director, Manager, Administrator, Informatica Power Center 8.x

OLAP/ DSS Applications: Business Objects 4.1.4 5.1.2,6.5,Xi R2 /R 3.0 - Designer, Supervisor, Business objects use module, Broadcast Agent, Central Management Console, Set Analyzer, BO Auditor and Report Conversion Tool, Import wizard, Xcelsius, Life Cycle Manager, BO SDK Web Intelligence2.5, 2.6, Xi, Info view, ZABO, Performance Manager and Crystal Xi., Cognos Impromptu, Cognos Transformer, Power Play, Report Net 8.x

EXPERIENCE:

Confidential

Senior SAP Business Warehouse

• Involved in interacting with various Module leads in identifying the BW Reports which currently being used.
• Involved in LIPA Regression Testing, analyzing the BW Reports for HCM, FI-CO, Procurement and Fleet modules.
• Involved in interacting with Offshore team in getting the deliverables and updating the management about the work status.
• Involved in Blue printing, Business requirements discussion, and developing business requirements document as per PSEG template.
• Developed Power point presentations and prototypes in SAP BO and BW functionalities and capabilities in transforming the data from other data sources and integrating into SAP BW and generating the reports using Business Objects.
• Involved in SAP BW and BOBJ Run books review and suggesting the changes to the development team.
• Creating and loading the data in to PSA and testing the results against Bex Query.
• Loading and monitoring the data in DSO and infocube and testing the data with source in the process of unit testing.
• Writing Unit Test documents as the process of Change Management.
• Designing queries in Bex Designer and executing the Bex queries in Bex Analyzer for test results.
• Involved in Crystal Reports Unit Testing, as part of Enterprise Change Management and test the results for any errors or any data mismatch.

Environment: SAP Business Objects 3.1, Crystal Reports, SAP Business Warehouse BW , Informatica

Confidential

Senior SAP Business Warehouse

• Involved in SAP BI backend support as well as converting Bex queries to Webi reports and involved in report enhancements from minor to major changes in the existing reports or to new project development.
• Creation of new universes and reports for various SAP modules and involved in migration of Business Objects platform 3.1 to Business Intelligence 4.0
• Responsible for interacting with clients and other Business stakeholders in getting their reporting requirements completed.
• Involved in Production support and ticket resolution.
• Creating Dashboards using Xcelsius.
• Worked on Advanced Analysis reports created based of BEx queries.
• Analyzed Infocubes, MultiProviders, DSOs, and Infoobjects in process of developing the reports based on BEx queries as the data provider.
• Preparing Technical Design documents and Time Estimations for the L4- RAD projects.
• Analyzed BEx Queries and underline base queries in the resolution of the production tickets.
• Refreshing the Universe structure when the Base Queries are changed or enhanced to Multiproviders at the BW side.
• Involved in testing of DB2 database upgrade on DB1 system.
• Created various Complex reports using Business Objects Universes and SAP BW BEx as the data providers.
• Interacting with Business Analysts and also various functional teams like Finance GL, AP, AR, CO-PA and Logistics SD, and MM in understanding the client requirements and resolving the production issues.
• Involved in Webi Report Development of the Ticket status reports.
• Provide time and resource effort estimation for any new development.
• Involved in creating new universes base of BeX queries.

Environment: SAP Business Warehouse 3.x, SAP Business Intelligence 7.3, ABAP Customer Exits, User Exits, SAP Business Objects 3.1, SAP Business Objects 4.0, MS Advanced Analysis, Business Objects Explorer, Crystal Reports, SAP Business Warehouse BI 7.3

Confidential

Senior SAP BI/Business Objects Architect

• Infoburst schedules, Monitoring bursts, Re-run the failed jobs, Analyzing the failed bursts.
• Security Administration and maintenance of users and folders: Providing the folder access to users depending on their role viz, Analyst, Editor, Refresher, Viewer.
• Tasks include: Report Migration, Universe Migration, 24X7 on call production support, Break fixes, new Projects / Enhancements.
• Analysis of Business Requirements and documentation of Technical Design Document.
• Involved in development of enhanced requests and defects resolution.
• Interacting with Business Analysts and also various functional teams like Finance GL, AP, AR, CO-PA and Logistics O2C, and MM in understanding the client requirements and resolving the production issues.
• Involved in Process Definition and Release Management Process/Version Management for the BI Reporting for the organization.
• Worked on SAP Business Objects BOBJ and SAP BI reporting applications for Hasbro Managerial Services.
• Server administration, monitoring slow running jobs, start up and shutdown the servers.
• Report Performance and Production Issues.
• Validation of the WEBI Reports post-migration 4.0.
• Working on On-Shore and Off-Shore Model.

Environment: SAP Business Objects 3.1, SAP Business Objects 4.0, HANA, ABAP USER EXITS, Crystal Reports, SAP Business Warehouse BW , Informatica Power Center 9.1, SQL Server

Confidential

Senior BI/ETL Analyst

• ous stages of the project to increase the performance by pushing the transformation logic to Source/Target/Full.
• Worked on SAP Business Objects BOBJ and SAP BI reporting applications for Chase Global Finance Technology.
• Extensively used parameters for Connection names, Schema names and File names. Parameter name and values are stored in a table and Parameter file is dynamically created using the shell script and extensively used Push Down Optimization on vari
• Prepared MACRO and MICRO design documents.
• Effectively used Teradata Parallel Transporter connection to load the data into Teradata tables.
• Working on On-Shore and Off-Shore Model.
• Involved in Reverse Engineering process from Abinitio graphs to Informatica mappings.
• Developed ETL mappings and transformations for complex requirements using Informatica Power Center 9.1
• Worked extensively on different transformations like source qualifier, Expression, Filter, Aggregator, Router, Update strategy, Unconnected Connected lookup, Normalizer, SQL and Sequence generator.
• Developed generic reusable Mapplet to validate control file with the data file for Record Count and Hash Amount check.
• Extensively used Informatica client tools Source Analyzer, Mapping Designer, Mapplet Designer, Transformation Developer and Informatica Workflow Manager.

Environment: Ab Initio, SAP Business Objects, Crystal Reports, BEX, SAP Business Warehouse BW , Informatica Power Center 9.1, Teradata, SQL, Flat files, DB2, UNIX Shell Script, Taradata SQL Assistant, Windows XP, Cognos Profile Tool, Abinitio

Confidential

Solution Architect-

• Solutions architecture and consulting Architecture and designing solutions meeting the technical and business needs of an enterprise, and participating in consulting engagements for conducting enterprise architecture assessment and /or roadmap studies.
• Research and Innovation exploring latest technical trends in BPM, BI, Open source Business intelligence applications, and evaluating various BI tools and frame works.
• Business Development providing technical inputs to business proposals, participating in consulting or pre-sales engagements and other project management activities.
• Reviewing the technical architecture and design for various projects.

Environment: Informatica Power Center 9.1, SQL, SAP Business Objects XI 3.1, Qlikview

Confidential

SAP Business Objects Module Leader

• Developed DWBIS reporting solutions using Business Objects.
• Involved in report design document and sign off from the client and in preparing request for proposal.
• Interacting with the client for gathering requirements and freezing the scope of the requirements.
• Involved in designing the universe with multiple fact tables, aggregate tables with minute level granular data.
• Influencing the data model team as per the reporting requirements.
• Developing the Brokerage, Client analysis reports for survillence process
• Involved in TOP N Broker, Client and Security across all exchanges, Trade details and Order Details reports, with aggregate and second level granular data for the client and Broker reports.
• Implementing security across the SEBI Users for Survillence and Investigation departments.
• Involved in QA and UAT teams facilitating with BO Dev team in resolving defects encountered during QA and UAT.
• Primary contact in interacting with SEBI for any report mockups/technical issues/user training.

Confidential

Senior Business Objects/ETL Analyst

• Developed and maintained data and reporting applications including design, development and maintenance of Business Intelligence, data distribution and reporting functions directly accountable to over 1500 users.
• Business Objects Best practices have been strictly followed while designing Universes as well as creating BO Reports.
• Created and administered various universes for the Consumer Lending Services division and financial data mart universe for the financial division of the company.
• Design, Develop and maintained very complex monthly Compliance reports to determine the Loans that are out of compliance in each channel. Highly visible since loan officers can be terminated if violation occurs more than three times.
• Handled Incident Management through USD and involved in Change Management policies and procedures for promoting universes / reports in to different environments.
• High interaction with Business Users, Business Owners, ETL/data base team to know their Business views in developing and modifying Universe accordingly.
• Modified existing Universes by rectifying with appropriate techniques to meet all reporting requirements.
• Maintaining the production and development environments.
• Created aggregated tables and materialized views in the oracle database for Business Objects reporting and created SQL scripts and PL/SQL stored procedures for HMDA reporting.
• Involved in major Migrations of Business Objects from 5.1/6.5.1/XI R2 and in migration from Business Objects XI R2 to XI 3.1.
• Used Import wizard to import all the content from XI R2 to XI 3.1
• Configured CMS database on XI R3.1.
• Automated Document Scheduling, Publishing and Distribution of Webi and Deski reports to various users.
• Involved in creation of Xcelcius loan-level dashboards for the senior management.
• Extensively worked with CMC Central Management Console in implementing various levels of security for users and user groups.
• Participated in Disaster Recovery planning, Standard operating procedures, and Architecture of GMAC Busobj environment.
• Experienced with all Administration tasks of Business Objects Enterprise using Central Management Console of BO XI R2/R3.0
• Most complex Universes and WEBI Reports were created to meet the users reporting Requirements.
• Loops, Different Traps issues have been resolved while designing BO universes.
• Both Functional and Technical design documentation were created and conducted inspections for Business Approvals.
• Installed and implemented different patches like SP1, SP2 AND SP3 to take the advantage of new capabilities.
• Created profiles in conjunction with publications to personalize the content that users see while viewing Desktop Intelligence documents.
• Involved in writing stored procedures and sql scripts for the reporting purposes and involved in ETL process for Enterprise Customer Repository ECR .
• Extensively worked on Datastge Designer, Director and Manager Components of the Ascential Datastage.

Environment: Business Objects XI R2, Business Objects XI R3.1, Xcelcius, Microsoft Office, Crystal Reports, Desktop Intelligence, Web Intelligence, Dashboard Builder, Business Objects Designer, Central Management Console, Crystal Reports, Oracle 10g, Microsoft Excel, Microsoft Sharepoint Portal, Visio 5.0, Datastage Designer, Datastage Director, Datastage Manager 8.x

Confidential

Application Team Lead

• Involved in the implementation of Real time data on to the Portal for the real time metrics and involved in the preparation of the technical document from the user requirement Specs.
• Assigning the tasks to different BO users and Portal Developers.
• Coordinating with different teams viz, Data team, Data Model Team and also with Infrastructure team while deploying the applications in different environments.
• Meeting with the BO Development Team and Portal Development Team for the status updates etc.
• Involved with Portal Development Team in deploying the code on different environments and involved in understanding of Reporting Requirements for Loan Operations Reporting.
• Worked closely with Business Analysts in the understanding of the reporting requirements.
• Imparted the training sessions to the Business Analysts on Business Objects functionalities and capabilities which helps the Business Analysts for more analysis and feasibility of the user requirements.
• Designed Universes with multiple dimensional tables and fact tables for Stips and Vendor Management.
• Created the Business Objects Reports for the Loan Operations audience viz, Loan Managers, Credit Analysts, Associates etc.
• Created some of the reports like Team Reports Associate Reports, Credit Analyst Reports which are integrated to the Manager's Portal for the real time Metrics like and created Dashboards and Scorecards using Application Foundation for more personalization of the reports.

Environment: Business Objects 6.1.a, Web Intelligence 6.1a, Business Objects Designer, Business Objects Supervisor, Broad Cast Agent, Publisher, Application Foundation, Oracle 9i, Oracle Reports 6i, SQL Loader, Microsoft Excel, Visio 5.0, HTML, DHTML, CSS, Java, JMS, JSP, J2EE, XML, XSL, XSLT, Web logic portal 8.1, Web Logic Server 8.1, Informatica Powercenter 7.1, Informatica Power Analyzer 4.1.1

Confidential

Reporting / Extraction Analyst

• Involved in gathering of Reporting Requirements for CRS Reporting.
• Involved in preparation of various documents viz. Reporting Requirements Draft, Design draft for Dimensional Model, Source-to-Target Data mapping draft for ETL process, Data Source Definitions draft and Testing Documents, involved in the preparation of High-level architecture Business Objects Process flow and High-level graphical representation of Sources and Targets and involved in the understanding of different source systems, in the process of designing an ETL Process.
• Designed Dimensional Model using Ralph Kimball Methodology of Data warehouse bus matrix.
• Created Confirmed Dimensions and multiple Fact tables using star schema technique and created and managed the Business Objects universe using Star schema model.
• Developed various kinds of reports for Project Management Team, Program Office Team in the analysis of Budgeting and Forecasting.
• Created the ad-hoc Webi Reports and created Data warehouse tables to populate the data from heterogeneous sources.
• Involved in developing java interface for creating data structures and extracting the data from heterogeneous sources into staging environment and in developing UNIX shell scripts for the ETL Scheduling process.

Environment: Business Objects 6.1.a, Business Web Intelligence, Business

Objects Designer, Business Objects Supervisor, Oracle 9i, SQL Loader, MS SQL Server 2000, DTS, DB2 UDB, UNIX, Microsoft Excel, Visio 5.0, Java, JDBC

Confidential

Reporting Analyst

• Prepared and supplemented in preparation of various documents viz. Scope Of Work, Requirements and Gap Analysis, Design Document and Testing Documents.
• Created, Managed and distributed the universe through Development, Testing and Production phases of the Project.
• Supported the Database Team in making necessary changes in the database as well as the web front end based on the Reporting requirements.
• Reviewed and implemented necessary changes in creating individual and group profiles with data security in focus and helped the client team in tuning the deployment and Migration to Production from Development/Test environment.
• Involved in the creation of SalesRep, Leasing and YTD reports to be used by different users, District Managers and Regional Managers for the effective decision-making.
• Testing of the Business Objects Reports for data validations.
• Also created Webintelligence reports.
• Implement features like Customized prompt and report pages.
• Imported the data from Excel files into MS SQL Server using DTS.
• Developed Stored Procedures to populate the data into a SQL Server tables.

Environment: Business Objects 5.1.6, Business Objects Web Intelligence 2.7, Business Objects Designer, Business Objects Supervisor, MS SQL Server 2000, SQL Query Analyzer, DTS, Windows XP