SUMMARY

• Seven (7+) Years of Business Intelligence experience with 5 complete life cycles using Business Objects Enterprises XI3.0/XI R2/XI R1/6.5/6.0/5.1, 4.7(BO SDK, Desktop / Web-Intelligence XI 3.0/ XI R2/XI R1/6.5, ZABO, CMC, CCM, CMS, Business Objects Data Services XI, Data Integrator, Data Quality, Live office, Import Wizard, Broadcast Agent (BCA), Publisher, Supervisor, Designer, Info view, Performance Manager, Dashboard Builder, Business Objects Reporting and Crystal Reports XI R2/2008, BO Set Analyzer, Application Foundation, Dashboard Manager, Crystal Xcelsius 2008/4.5).
• 4+ Years of Experience in ETL with Different Versions of Business Objects Data Services/Data Integrator.
• 3+ years of experience with Data Quality of data profiling, parsing, cleansing, standardization and matching capabilities to make sure data is correct.
• 5+ years of experience in Business Objects reporting tools Universe Designer, WebI, DeskI and Infoview for Ad-hoc/Canned Reports using Business Objects 6.5 / XIR2 / XIR3 and report Migration.
• Expert skills in Data Services/Data integrator in design, creation, and implementation of BODS/BODI scripts and performing perform simple and complex transforms in dataflow using different data integrator, data quality platform and transforms, hands on experience of Recovery Mechanism for unsuccessful batch jobs execution.
• Used various transformations like Case, Map Operation, Merge, Query, Row Generation, SQL, Validation, Data Cleanse, Address Cleanse and Match.
• Scheduled, monitored and fixed the errors of the jobs.
• Performance tuned Business Objects Data Services Real time and Batch jobs, complex transformations in Data Flows to improve efficiency.
• Experience in setting up Development, Test and Production environment by additionally setting up a central repository and migration of reusable of objects such as Jobs, Workflow, Dataflow both by Import/Export directly and Checking In/Out in Central Repository.
• Experience in migrating BO Universe, Reports, Dashboard reports, ETL jobs from one environment to another environment.
• Working Experience in designing, development and deployment of complex Universes.
• Expert in retrieving data using Business Objects Universes, Data files, stored procedures and free hand SQL methods.
• Expertise in generating Sub Reports, Cross Tab Reports, Financial Reports with graphs and summary using Desktop Intelligence and Web Intelligence.
• Experience in Upgrades/Migration from Business Objects XI/R2 to Business Objects XI/R3 and from Business Objects 6.5.1 to Business Objects XI/R2.
• Advanced experience with Business Objects XI R3 Central Management Console (CMC) including creation of Business Objects folders, documents, reports, user groups, profiles, schedules, publications, and security rights.
• experience usingBusiness Objects Administration, Web-Intelligence, BO Developer Suite using SDK Report application server (RAS), Application foundation. Broadcast Agent, Auditor, Web Admin tool, Supervisor, Designer, Web Intelligence/Info view.
• Experience in analyzed Reports using Slice and Dice, Drill Down, Cross Tab, and Master Detail Completely utilized various features in the Business Objects Web Intelligence and Crystal Reports such as Pre-defined Filters, Prompts, Cross-Tab, Report Linking, Sub-Queries/ Sub-Reports, Hierarchies, Charts/ Graphs, Report layout/ format features etc.
• Experience in developing Canned Reports and ad-hoc reporting environments using existing/modified universe.
• Experience in generating the Business Objects Reports using the universe as the main Data providers and writing the complex queries including Sub queries, Unions, Intersection.
• Experience in checking the Integrity of the Universes.
• Experience in resolving Loops using the functionality of Aliases and Contexts.
• Excellent administration skills to manage the environment, server, users, groups and security setup for BOE/DS/DI/DQ tools.
• Experience in Report Development using Crystal Reports 8.5/9.0/10/XI, (Designing, Sub-reporting, OLAP, Ad-hoc queries, Drilldown, Cross-tab etc.), Crystal Enterprise 8.5/9.0/10/XI (Publishing, Scheduling, Creating Users/Groups/Roles, Export/Import, Mailing reports to respective target users in Intranet/Internet), Client/Server and Web application development.
• Working Experience in creating Dashboards using Dashboard Builder, Performance Management, Crystal Xcelsius 2008/4.5, Excel.
• Expertise in Relational Database Systems such as Microsoft SQL Server 2008/2005, MYSQL, DB2 ,Oracle 10g/9i and Microsoft Access. Technical proficiency in Querying Databases, Writing Stored Procedures, Triggers, Functions , Creating Views.
• Knowledge in designing and developing Data marts, Data warehouse using multi-dimensional Models such as Snow Flake Schema and Star Schema while implementing Decision Support Systems. Experience in Fact & Dimensions tables, Physical & logical data modeling.
• Experience and Strong understanding of SAP BW integration with Business Objects.
• Extensive knowledge in SQL & PL/SQL programming, Writing Stored Procedures, Packages, Functions, Triggers, Cursors, Handling Exceptions and trouble shooting.
• Worked extensively on Cubes, Dimensions and Slowly Changing Dimensions, various Transformations, Workflow, Building Data warehouse, development, performance tuning, job automation, Scheduling and query tuning.
• Experience in user training and extensively involved in taking business and technical requirements and basing on that delivered the required reports to the project.
• Experiences working in all phases of the software development life cycle (SDLC), Strengths include good team player, excellent communication and interpersonal, analytical and technical documentation skills, good analytical reasoning and high compliance to new technologies and tools.

TECHNICAL SKILLS

Business Objects Development, Business Analysis, Data Analysis, Gap Analysis, Dashboard Creation for Performance Management, Report Generation Performance Tuning, Data Warehousing, ETL Processes, Oracle Database Administration, Production Support.

LANGUAGES & DEVELOPMENT TOOLS Languages: C, C++, Java, SQL, PL/SQL, C#.Net, .NET Platform, VB Reporting Tools: Business Objects XI 3.0/XI R2, 6.X, 5.X, CMS, CMC, Crystal Reports, Web Intelligence Rich Client, Publisher, Desktop Intelligence XI R2/6.x/5.x Supervisor, Designer, BO Reporter, Web Intelligence, Dash Board Manager, Infoview, Zabo, BCA, BO Auditor, Crystal Xcelsius 4.5 & 2008, Security Viewer 2.2 ETL Tools: Data Services, Data Integrator, Data Quality, Data Insight Internet Technologies: ASP.Net, HTML, Adobe Photoshop Scripting Languages: JavaScript, VB Script, XML

OPERATING SYSTEMS & SYSTEM UTILITIES: Windows XP/2000/98, Windows NT 4.0, UNIX NETWORK SYSTEMS & TECHNOLOGIES: Internet Information Services Server, Apache, Soap UI, Filezilla, WinSCP & Web Sphere DATABASE MANAGEMENT SYSTEMS & TOOLS: Oracle, MS SQL Server, DB2, MS Access, TOAD, SQL Developer DATA MODELLING: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin 4.5/4.0

EXPERIENCE

Confidential, NY Mar 2010-Till Date Business Objects Data Services Developer

Confidential is a global financial services firm headquartered in New York City serving a diversified group of corporations, governments, financial institutions, and individuals. In this firm I was member of Data Management Organization Team as a Business Objects Data Services Specialist. I was responsible for Data Services design, development, testing and support.

Roles & Responsibilities:

• Analyzed the Business Requirements (functional & technical) with the Business users.
• Participated in requirement gathering sessions and developed Business Objects Data Services jobs specifications on excel sheets based on information acquired from analysis of source data, user requirements, Business rules and Enterprise standards.
• Worked with Business analysts, SMEs and Business Users to understand Business process and Collaborated with business technicians to research existing business, system processes and functional requirements for modifying Job.
• Used Business Objects Data Services for ETL extraction, transformation and loading data from heterogeneous source systems.
• Developed/Modified Real time Business Objects Data Services jobs to generate the Web Services WSDL to integrate it with User Interface application.
• Developed, Maintained and Configured Web Service Definition Language (WSDL) in Business Objects Data Services Management Console and tested it extensively using SOAP UI.
• Used various transformations like Case, Map Operation, Merge, Query, Row Generation, SQL, Validation, Data Cleanse, Address Cleanse and Match.
• Used Business Objects Data Services cleansing transformations extensively for de-duplication, Standardization and address parsing.
• Extensively involved in Data cleansing and standardizing using USA and Multi Plug-in transforms in Business Objects Data Services Data Quality.
• Used Business Objects Data Services interactive debugger to test the jobs and fixed the bugs.
• Experience in debugging execution errors using Data Integrator logs (trace, statistics and error) and by examining the target data.
• Worked on SAP tables, doing data conversion, moving data from source to loading table and then to staging table and then target database.
• Scheduled, monitored and fixed the errors of the jobs.
• Performance tuned Business Objects Data Services Real time and Batch jobs, complex transformations in Data Flows to improve efficiency.
• Defined separate data store for each database to allow Business Objects Data Services to connect to the source or target database.
• Perform Unit testing and Document the results of Unit testing and ETL process.
• Upgraded/Migrated Business Objects Data Services from XI 3.1 to XI 3.2.
• Involved in complete Business Objects Data Services installation and configuration.
• Responsible for setting up Development, Test and Production Environment.
• Administering and maintaining BO Data Services management console and repository management.
• Developed various Workflows and Data flows where the data is extracted from the sources like Oracle, SQL Server and SAP ECC then loaded into staging tables from staging tables data loaded into relational tables and from Relational tables data loaded into Hubs, Satellites and Links.
• Worked on relational database management system (RDBMS) like Oracle, SQL server, MS Access.
• Helped the team in analyzing the data to be able to identify the data quality issues.
• Data quality checking and interacting with the business analysts.
• Testing and debugging of code in Business Objects Data Services transforms.
• Monitoring the identified Business Objects Data Services ETL processes, restarting the Business Objects Data Services ETL processes that aborted.
• Modified existing Data Services jobs to fix defects at the root cause as enhancement part of project.
• Handled time critical Development requirements, Delivery review, interacted with onsite team, prepared Test cases for the module and Fixed bugs during SIT.
• Created and maintained Enhancement, Bug tracking and Bug fix documents.
• Documenting the changes and training the end users.

Environment: Business Objects Data Services 3.x(Data Integrator, Data Quality), SQL Server 2005, Oracle 10g,PL/SQL, TOAD, Oracle SQL Developer, UNIX, Window XP/2000/2003 Server, Soap UI, Filezilla, WinSCP.

Confidential, PA Jun 2009 - Feb 2010 Business Objects Data Services Developer

Confidential is a diversified financial services company with operations around the world. I have involved in developing Business Objects Universes/Reports for Price Variance project and upgrade the BO versions from XIR2 to XIR3. I was also responsible for ETL systems design, development, testing and support.

Roles & Responsibilities:

• Involved in gathering business requirements, functional requirements and data specification.
• Responsible for system study & Business Requirements Analysis & Documentation.
• Involved in complete BOE installation and configuration.
• Prepared IQ and OQ document for installation and configuration.
• Migrated Business Objects from XI R2 to XI R3.
• Involved in Creation of jobs that specify data mappings and transformations by using Business Objects Data Services Designer.
• Working with different transformations like Map Operation, Table Comparison, Row-Generation, Query, History Generation, Key Generation, and Pivot.
• Worked with different Business Objects Data Services Data Quality Transform such as Global Address Cleanse, Data Cleanse and Match Transform.
• Creation of ETL Processes for the added new Subject areas, Develop Data Extraction, Transformation and Loading Program using Data Services.
• Involved in scheduling and running Batch jobs on time using Data Services Management Console.
• Involved in writing scripts and also used some built-in functions like To Date, lookup, key generation and Custom Functions like checking whether the load is a initial load or a bulk load.
• Creating complex Data flows and declaring parameters at different levels of Workflow.
• Scheduled, monitored and fixed the errors of the jobs.
• Involved in creation of Local Repository and associating job server to it.
• Involved in using Job Server in creation of batch jobs. And also involved in Performance tuning at source, transformation, and target levels.
• Created Data Services ETL jobs to load source data from to target table.
• Created Data Services for data cleansing and data standardizing.
• Worked with a Team to develop a complex universe and generated reports exclusively using Full client.
• Configured LDAP account.
• Used security viewer to generate security setup repots.
• Installed and Configured Data Services/Business Objects Enterprise Suite.
• Administering the entire Business Objects Suite including BO reports/Data Services management console, Data Services repository management.
• Created and Maintained Data Services local and central repositories.
• Developed Data Integrator jobs and Data Quality workflows.
• Extensively involved in Data cleansing and standardizing using Multi Plug-in transforms in Data Quality.
• Created Data Quality transactional jobs and Integrated jobs.
• Integrated Data Quality jobs with DI job for data cleansing and standardizing.
• Worked on Data Profiling using DI/DQ and Data Insight tools to know the quality of data.
• Designed Universe by creating the Business Objects Data Model selecting/joining tables, indicating cardinalities, creating aliases to resolve the loops, subdividing into contexts and creating the objects like Dimensions, Details and Measures which are grouped into Classes and checked the integrity of the universe.
• Created Hierarchies, complex objects using various @functions, Aggregate objects in the universe.
• Defined @Aggregate_Awarness, @Prompt, @Select, @Where functions in universe level.
• Designed cascading prompts in the universe to filter the list of account names based on the business units.
• Used Aggregate Navigation in Universe. Created reports using Business Objects functionalities like queries, Slice & Dice, Drill Down, Cross Tab, Master/Detail and Formulas etc.
• Linked multiple universes.
• Used Business Objects Java SDK to provide an interface through which file events, schedule events, and user events can be created and monitored.
• Created Dynamic Filters and Dynamic Conditions in universe level as per Business rules.
• Defined Customized Hierarchies in Universe level.
• Created Derived Tables in the universes.
• Resolved Chasm traps, Fan Traps & Loop problems.
• Applied User and Group Restrictions in selected objects in universe level.
• Involved in the creating the reports using the Web. Created the Reports (Master/Detail, Brake, Cross Tab, Chart, and Templates) in Business Objects using the Universe as the main Data Provides and writing the Complex queries including Sub-Queries.
• Created Report Level Variables, Objects and Formula.
• Synchronized queries from multiple data providers.
• Created Dashboard by using Dashboard Builder/Dashboard Manager and Xcelsius.
• Tuning the Universes & Reports.
• Created Users, User groups and setting up the user profiles.
• Created Objects / Data Level Security in universe level.
• Created User Groups Level Security in CMS.
• Developing reports using Crystal Reports including: extracting data from SQL server to satisfy standard reports, ad-hoc requests, developing databases, spreadsheets, and other applications to manipulate data.
• Created standard reports, cross-tab reports, Mailing reports & OLAP reports.

Environment: Business Objects Data Services 3.x, Business Objects XI R2 /XI R3 (Designer, Supervisor, Web Intelligence, Performance Manager, Data Integrator, Data Quality), IBM DB2, SQL Server 2005/2000, Oracle 10g/11i/9i, PL/SQL, TOAD, Crystal Reports 10, Xcelsius 2008, Erwin, Unix, Window XP/2000/2003 Server.

Confidential, NJ Oct 2008 - May 2009 Sr. Business Objects Data Integrator Developer

Confidential is one of the world's largest and most comprehensive drug development services company. Through its nonclinical, clinical and commercialization services, Covance has helped pharmaceutical and biotech companies develop one-third of all prescription medicines in the market today. I was part of Center of Excellence team involved in internal project in Validated Environment.

Roles & Responsibilities:

• Business Analysis and Requirements gathering.
• Migrated Business Objects from 6.5.1 to XI R2.
• Interacted with business analysts and End client to understand technical and functional requirements for creating new Job. Written Data Services/Data Integrator Scripts for File existence check, Daily incremental read, Daily Incremental update, workflow level Script read, workflow level Script update, workflow level Error Handling and Job Dependency.
• Defined database Data Stores to allow Data Services/Data Integrator to connect to the source or target database.
• Used Business Objects Data Services/Data Integrator for ETL extraction, transformation and loading data from heterogeneous source systems.
• Created Data Services/Data Quality workflow to clean and standardize names and address using USA and multi plug-in address transforms.
• Extracting Data from different sources like SAP ECC and flat files and loading them into requested target flat files, excel sheets, Oracle Tables in Data Services/Data Integrator.
• Integrated DQ workflows with DI ETL jobs with cleansing and matching logic.
• Cleaned data from different sources and matching among the source data and matched against the corporate data to find the Master and subordinates and avoid duplicates entries into the system.
• Used Data Insight to profile the source data to generate the quality of source data.
• Created Scripts like starting script and ending script for each job and declaring the variables local and Global Variables.
• Defined separate data store for each database to allow Data Services/Data Integrator to connect to the source or target database.
• Tune the simple and complex transformations in Data Flows.
• Used Business Objects Data Services/Data Integrator interactive debugger to test the jobs and fixed the bugs.
• Used various transformations like, Map Operation, Table Comparison, Row-Generation, Query and SQL transformation.
• Implemented performance tuning concepts to the whole Business Objects Data Services/Data Integrator ETL process.
• Design and developed Data Services/Data Integrator scripts for data transformation
• Created, validated and executed jobs to transfer data from source to target.
• Experience in debugging execution errors using Data Services/Data Integrator logs (trace, statistics and error) and by examining the target data.
• Used Scripts for declaring the variables and creating the tables and inserting data into them.
• Converting high-level design specifications to detailed functional and technical specifications.
• Interviewing and Coordination with end users communities understand their requirement.
• Designed, developed, modified and maintained Business Objects Universe using Designer for Ad-hoc and canned reports.
• Responsible for creating & managing the Business Objects repository and coordinating/performing universe development. Exported the universes to the Repository to make resources available to the users.
• Created joins, indicating cardinalities, checked integrity of the universe and resolved loops and traps using aliases and contexts.
• Created Hierarchies, complex objects using various @functions, Aggregate objects in the universe.
• Designed cascading prompts in the universe to filter the list of account names based on the business units.
• Import and export universes and reports to and from Repository using Import Wizard.
• Extensively used Report Conversion tool to convert DeskI reports to WebI reports
• Created users, users groups and maintained user access rights for BO universes and reports using Supervisor.
• Scheduled pre-canned reports through Broad Cast Agent Server for distribution and printing.
• Created reports and compare the daily sales using both tabular reports and 3-D graphical chart reports (bar graph & pie charts)
• Created variables, formulae and objects at report level.
• Generated reports using prompts, filters and conditions and testing these reports with all possible data for consistency.
• Created and maintained Business Objects reports in Web Intelligence Info View.
• Created queries to extract data from database for multi-dimensional analysis using Slice & Dice and Drill up/down functionality.
• Used stored procedures, free hand SQL, and excel files as data provider for creating reports.
• Tested reports before posting them to the repository (query optimization & performance).
• Analyzed Test cases and Test Plans. Involved in unit and system testing.
• Involved in Design, Development and Implementation of Reports using Crystal Reports Developer.
• Created Sub reports called from the main report to implement the business logic.
• Extensively created Complicated Formulas and used functions like InRepeatedGroupHeader, WhilePrintingRecords, WhileReadingRecords, and EvaluateAfter etc.
• Wrote Triggers, Procedures and Functions for products, catalogues, billing, shipping, registration, promotions and marketing.
• Responsible for creating the Complex Crystal Reports (on demand, Ad-Hoc Reports, Frequency Reports, Summary Reports, Sub Reports, Drill-Down, Dynamic Grouping, Cross-Tab, Graphical, Aging Reports).
• Created complex dashboards using Xcelsius which enhanced decision making.
• Exported reports into various formats like EXCEL, PDF, HTML and WORD according to user requirements.
• Performed Unit and System testing of the Business Objects Data Integrator ETL jobs
• Responsible for User Support and Training for Full Client and WebI and resolving Trouble Tickets/Cases reported by user.

Environment: Business Objects Data Services 3.x,Business Objects 6.5/XIR2/XIR3 (Designer, Supervisor, BO Full Client, Web Intelligence, Broad Cast Agent (BCA), Publisher, ZABO),Crystal Reports, Xcelsius 4.5, IBM DB2, SQL Server 2005/2000, Erwin, Data Integrator, Data Insight, Data Quality, Oracle 10g/9i, Unix, Window XP/2000/2003 Server, PL/SQL, TOAD.

Confidential, IL Jan 2008 - Sep 2008 BO/BODI Developer

Enterprise Data Warehouse for private clients division. The project was to build an operational data warehouse for the Private Clients division of Confidential. This division was handling the investment of high net worth individuals. The source system covered the various accounts of the clients like savings, term deposits, bonds, loans etc. The data from the different source systems was extracted it into one integrated data warehouse, which would allow for storage and reporting.

Roles & Responsibilities:

• Worked extensively on Full project life cycle (requirement gathering to implementation phase).
• Designed best practices for production support for day-to-day end user requirements.
• Installed and configured Data Integrator/Data Quality/Data Insight/Business Objects Enterprise suite.
• Created Data Integrator local/central repositories and configured to use different job servers and server groups.
• Integrated Data Quality jobs within DI job.
• Generate profiling reports using Data Integrator profiler.
• Administered complete Business Objects package.
• Developed functional requirements and data specifications for ETL Process.
• Used Data Integrator for migrating data from various OLTP databases to the Data Warehouse.
• Extensively worked on creating Dimensional Data Model for New Business from Operational Data Sources.
• The data migration included identifying various databases where the information laid scattered, understanding the complex business rules that need to be implemented and planning the data transformation methodology.
• Generated Custom variables, groups and formulas in Business Objects.
• Generated Reports on different data sources such as Business Objects Universes, Stored Procedures etc
• Created user groups and managed access privileges using Business Objects CMC.
• Responsible for Business Objects repository and BO Audit universe and reports.
• Performed release management of Business Objects reports using Broadcast Agent Server.
• Extensively used Designer to design various universes for different business groups. Created complex reports using cascading prompts, decode objects etc.
• Customized Business Objects web interface (intranet) to access the enterprise reports.
• Responsible for managing the Business Objects repository.
• Created complex dashboards using Xcelsius professional.
• Designed, developed and provided training in creating Ad-hoc reports, modifying universes, scheduling options in XIR2, Creating fiscal calendars in XIR2, XIR2 Desktop Intelligence/Web Intelligence to End users/Power user.
• Worked on User/System report documentation, user training and testing developed reports for final deployment.
• Worked on creating groups, conditions, filters ranking in reports prepared the following - Business/Technical Requirements, Design Templates, Development Standards document and Detailed Design documents.
• Developed various Charts, Graphs and drill down reports.
• Scheduled the weekly, monthly, quarterly reports using business objects.
• Worked on improving performance of reports with aggregate aware and using indexed columns in reports.
• Involved in gathering requirements, analyzing and Creating Reports.
• Created Standard reports, Cross-tab Reports, Sub Reports and Drill Down Reports using Crystal Reports XI
• Created Static, Dynamic and Dynamic Cascading Prompt parameters.
• Published reports on the web using Crystal Enterprise/BO XI Publishing Wizard and CMC (Central Management Console).

Environment: Business Objects 6.5/XI R2, Crystal Reports XI, Crystal Xcelsius 4.5, Oracle 8i/9i, PL/SQL Developer, SQL Server 2005/2000, Windows 2000/XP, Data Integrator , Data Quality.

Confidential, FL Aug 2006 - Dec 2007 Business Objects Developer Confidential provides managed care services exclusively for government-sponsored health care programs, focusing on Medicaid and Medicare. Headquartered in Tampa, Florida, WellCare offers a variety of health plans for families, children, and the aged, blind and disabled, as well as prescription drug plans.

Roles & Responsibilities:

• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @Functions, Cross Tab, Master Detail and Formulas etc.
• Created the Reports using the universes as the main Data providers and writing the complex queries.
• Involved in resolving the loops, Cardinalities, contexts and checked the Integrity of the Universes.
• Involved in the creating the reports on the web using the BO Web Intelligence from the online internet database and migrated from third party database.
• Exporting the universe to the Repository to make resources available to the users.
• Designed and developed universes for reporting generation from different database.
• Involved in the designing and building of universes, classes and objects.
• Created repository and user, user groups using supervisor module.
• Creating the various ad-hoc reports.
• Scheduled BO reports through Broad Cast Agent.
• Monitored the reports that were scheduled through Broad Cast Agent console.

Environment: Business Objects 5.0 (Designer, Reporter, Supervisor, Broadcast Agent and Web Intelligence), PL/SQL, Oracle 8i, SQL Server 7.0, and Windows 2000/98.

Confidential, TX Dec 2004 - Jul 2006 Business Objects Developer

Roles & Responsibilities:

• Designed Business Objects Universes and reports.
• Designed, developed, maintained and tested Universes for supporting ad hoc queries.
• Resolved Chasm traps, Fan traps and Loop problems.
• Created variables, formulae and detail objects at report level.
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @Functions, Cross Tab, Master/Detail and Formulas etc.
• Migrated Universes and reports from development to testing and production environments.
• Created Row level restrictions using create and manage restrictions in the Universe.
• Used Business Objects Data Integrator (BODI) to create Projects, batch jobs, Workflows and Dataflows.
• Exported the Business Objects reports to WebIto be viewed by all users on the Internet.
• Worked on creating robust ETL job to design, development, implementation, monitoring, troubleshooting and support of data extract staging, transformation and load procedures to populate and update the data warehouse from the source systems.
• Created transformations like Query, Case, Pivot, Row generation, Key generation, Table Comparison, History preserving and Data Flows using BODI Designer.
• Involved in administrative tasks like Repository Configuration, Job Server configuration, Central Repository configuration, Job Scheduling, Monitoring.
• Defined database Data Stores and File Formats to allow Data Integrator XI to connect to the source or target database and files.
• Effectively worked on Try and Catch mechanism to handle errors and scripts objects, variables and parameters at data flow and work flow level.
• Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions.

Environment: Business Objects XI R2, Central Management Server, Central Management Console, Infoview, WebI, Import Wizard, Business Objects Data Integrator, SQL Server 2005, PL/SQL Developer , Windows XP.

Confidential, India. Apr 2004 - Dec 2004 Oracle Developer CLIENT: HSBC

Confidential wanted to develop a system that was fast and incorporated secure banking sessions with login and password protection, encryption and authentication. The main focus was to build a network where independent branches could still transact as local servers even when wide area links were down. A full set of service was developed for bank personnel and end users, these included viewing account summaries, inter account fund transfers, online deposits. Our team developed functions for Internet business banking, and also some built-in features to aid with one-to-one marketing on the Web.

Roles & Responsibilities:

• Create and maintenance of Oracle Forms and Oracle Report.
• Create and maintenance of PL/SQL packages, stored procedures, functions and Triggers.
• Day to day communication with client related new requirement, support and development.
• Designed, developed, modified and maintained Business Objects universe using Designer 6.5 for ad hoc and canned reports.
• Created joins, indicating cardinalities, checked integrity of the universe and resolved loops and traps using aliases and contexts.
• Created Hierarchies, complex objects using various @functions, Aggregate objects in the universe.
• Preparation of Program Specs and Test cases.
• Unit testing and System testing with test cases.

Environment: Oracle 8i, Business Objects, MS Access, PL/SQLXML, HTML, Windows 2000/NT.

EDUCATION Bachelor of Commerce.