| PROFESSIONAL SUMMARY - Around 8 years of experience in Business Intelligence (SAP Business Objects (4i//5i/6i/XI) with Crystal reports, Xcelsius 2008) and Data Warehouse applications.
- 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 on new features of Business Objects XI including WEBI XIR3 and Central management console and Crystal Xcelsius and Business Objects Framework (Architecture).
- Technical hands-on expertise using OLAP tool Business Objects 4/5.x/6.0 /XIR2(Reports, Designer, Web Intelligence, Info view , and Supervisor)
- Experience in implementing Business Objects report management with Finance, Sales and Marketing, Supply Chain Management, Healthcare sectors.
- Worked on Financial reports (P&L, Asset Management, Loan Processing and Acquisition) Healthcare reports (Top Diseases, Service class, Vendor details), Sales Reports.
- Expert in Optimizing, Debugging, Tuning and testing SQL queries, views and stored procedures in Oracle and SQL Server.
- Experience in Warehouse development, working with Data Migration, Data Conversion and Extraction/Transformation/Loading using Data Integrator XIR2 and Data Services with Oracle.
- Involved in designing Jobs using Data Integrator Designer to extract, transform and load data. Extensively used, Data stores, workflows, data flows and transformations in designing the Jobs.
- Designed and developed ETL solutions using SAP Business Objects Data Integrator.
- Written technical design documentation (e.g. data flow diagrams, mapping documents, etc) for Business Objects Data Integrator Jobs.
- Performs testing of ETL data flows.
- Develop a strong working relationship with the appropriate business users to understand the key business drivers and priorities
- Hands-on experience on Crystal Xcelsius in creating Dashboards, graphs, charts, inserting maps and complex analytics reports
- Worked with various types of reporting solutions including analytical, Operational and Adhoc reports for business users.
- Working knowledge of performance improvement measures including aggregate tables, Indexes and Explain plan
- Worked extensively on modules Supervisor, Designer, Info view, and Web Intelligence and Broadcast agent in Business Objects.
- Worked with Crystal Report XIR2 for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports, data reports along with LOV.
- Good knowledge of Data Warehousing/Data Mart concepts including star and snowflake design
- Analysis to design the Universes and Business Objects Reports to support the user requirements.
- Developed templates for data mapping and facilitated workshops with cross functional business users to understand complex legacy systems data structures, mapping data into to-be BO data warehouses and developed conversion/transformation rules
- Used aggregate awareness in universes and created reports employing functionality like Queries, Slice and Dice, Drill down, Functions, Filters & Formulae Exceptional experience in dealing with various databases like Oracle, DB2, SQL Server, MS Access, and Flat files.
- Worked with various types of reporting solutions including analytical, Operational and Adhoc reports for business users
- Excellent communication and interpersonal skills. Ability to work effectively as a team member and individually.
|
