PROFESSIONAL SUMMARY:

• Over 6 years of experience in IT, primarily focused on ETL Development and Reporting using Business Intelligence Tools: SAP Business Objects 4.0 / 3.1 and Informatica 8.6 / 9.1.
• Expertise in developing BO WebI, DeskI, Crystal reports and Xcelsius Dashboards.
• Strong knowledge on BO Architecture and good working experience in BO Administration using Central Management Console CMC , Central Management Server CMS , Central Configuration Management CCM , Import Wizard and Report Conversion Tool.
• Experienced in BO Administration with emphasis on installing, upgrading and troubleshooting
• Extensive experience in programming SQL Server - Stored Procedures, Cursors, Triggers, User-defined Functions, Joins and Views.
• Excellent Knowledge on Database Systems Oracle 11g/10g/9i/8i/7i, SQL Server 2008/2005, and Teradata.
• Strong knowledge in Data Warehousing and Dimensional Modeling concepts which includes Entity Relationship Modeling, Normalization, Fact tables, Dimension tables, Star Schema, Snowflake Schema and Slowly Changing Dimensions.
• Extensive experience in creating Universes with complex and advanced features using Universe Designer Tool UDT 3.1/4.0.
• Expertise in developing ad-hoc and complex BO reports using various functionalities like Queries, Slice and Dice, Cross Tab, Master Detail, Breaks, Alerts, Filters, Sorts, Ranking, Prompts and Calculations.
• Proficient in Performance Tuning and Optimization of BO reports at all levels.
• Hands-on experience developing ETL jobs using Informatica Power Center 9.1/8.6.
• Extensive experience in developing SQL, PL/SQL and T-SQL scripts to validate the database tables and reports data for backend database testing.
• Experienced in Documenting, Preparing Test Plans, developing test cases and Testing Unit, System, Integration, User Acceptance testing and Regression testing .
• Hands-on experience in using HP Quality Center 10 and BMC Remedy Action Request System for Defect Management to ensure Quality Assurance.
• Well Experienced in different phases of SDLC including Analysis, Planning, Designing, Implementation, Testing, and Support.
• Effectively communicate with business users to collect and understand requirements, socialize ideas among peers and document work product.
• Quick learner with strong interpersonal and communication skills and ability to work in a team and as an individual with minimal supervision.
• Exceptionally well organized, sound decision making capabilities and willingness to work hard to achieve employer objectives.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE

Confidential

SAP Consultant

Responsibilities:

• Interacted with business users and business owners to know their business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Designed and developed several Business Objects Report Mock-ups to finalize the requirements.
• Worked on Business Objects Architecture Administration by Creating Repository, Adding Users and Groups, Assigning Password Security, Assigning Privileges to Documents and Universes using Central Management Console CMC .
• Applied security features of Business Objects like row level, report level object level security in the universe so as to make the sensitive data secure.
• Designed and maintained complex Universes, resolved loops by creating aliases and contexts.
• Tuned and Enhanced Universes with SQL Queries for the Report Performance.
• Maintained and tested universes for supporting ad hoc queries.
• Created the reports using Business Objects functionality's like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulas etc.
• Wrote formulas, parameters and conditions depending upon selection criteria.
• Implemented dynamic cascading prompts and defined business views.
• Organized data in the report by inserting Filters, Sorting, Ranking and highlighting data.
• Involved in Modifying and Performance tuning of the existing reports.
• Published Reports to CMC Central Management Console and involved in Scheduling and exporting the reports in different Formats.
• Wrote complex SQL Scripts - Stored Procedures, Cursors, Triggers, User-defined Functions, Joins and Views for backend database testing.
• Extensively tested and migrated the BO reports and objects from development to Production system.
• Provided Production Support 24/7 to resolve the issues using BMC Remedy Action Request System as a Defect Tracking Tool.
• Efficiently mapped business requirements and processes to technical solutions.

Confidential

BO Admin and Developer

Responsibilities:

• Interacted with business users and business owners to know their business views in developing and modifying Dashboards, Reports, Universes and User Security.
• Analyzed the existing database and created/modified the universes using Universe Designer Tool UDT .
• Created new Classes, Objects and Conditions. Detected Cardinalities and Loops. Resolved the loops by creating Aliases and Contexts and checked the Integrity of the universes.
• Exported the universes to the Repository to make the resources available to the users.
• Created Webi reports with multiple data providers and synchronized the data using merge dimensions.
• Updated the Universe as per the changes of the Database table and notified the users about changes made to the Universe.
• Formatted the reports according to the user requirements using Business Objects functionalities like Dynamic cascading prompts, Breaks, Calculations, Slice and Dice, Drill Down and Variables.
• Organized data in the reports using Filters, Sorting, Ranking and highlighted data using Alerter.
• Scheduled BO Reports in CMC on Daily, Weekly and Monthly basis.
• Used the Publishing wizard to export different document types as objects to different folders in CMC.
• Managed the Servers using the Central Configuration Manager CCM .
• Responsible for setting up the Users/Groups, assigning the privileges to the Users using Central Management Console CMC .
• Used Import Wizard to import existing User accounts, Groups, Categories, Universes, Webi Reports, Connections and Universe restrictions to BO XI R2 environment.
• Performed Business Objects XI upgrades and Migration from DEV, TEST to PROD.
• Debugged issues which resulted from Migration. Provided support in enhancement and maintenance of the Reports and Universes.
• Involved in production support by modifying and correcting production reports.
• Developed and delivered complex and ad-hoc reports in-time.
• Worked extensively on SQL queries for client warehouse analysis and ad-hoc requests.

Confidential

ETL Informatica Developer, BO Administrator and Quality Analyst

Environment : Windows 2003

Responsibilities:

• Interacted with data modelers and Business Analysts to understand the requirements and framed the business logic for the ETL process.
• Used Informatica Power Center Designer for developing mappings, using transformations, which includes aggregation, Updating, lookup, and summation. Developed sessions using Server Manager and improved the performance details.
• Worked with Informatica Designer tool in developing mappings and mapplets to extract and loading the data from flat files, oracle to Oracle.
• Used update strategy and Lookup transformation to insert, delete, update or reject the records based on business requirements.
• Developed several complex Mappings, Mapplets and Reusable Transformations to facilitate one time, Weekly, Monthly and Yearly Loading of Data.
• Utilized the Aggregate, Join, Router, Look up and Update transformations to model various standardized business processes.
• Worked with Scheduler to run the Informatica session on daily basis and to send an email after the completion of loading.
• Responsible for providing admin support and system testing of BO reports.
• Installed and Upgraded Business Objects from BO 3.1 to BO 4.0.
• Migrated Reports, Folders and Universes from one repository to other repository using Import Wizard.
• Took a pre-migration backup, restoration of backups when needed.
• Maintained BO security User/User Group and Content Management .
• Involved in performance tuning of the BO environments to improve efficiency.
• Performed Manual Server Monitoring on a daily basis to avoid server crashes.
• Involved in designing and Preparing Test Scenarios, Test Plans, Test Cases and Test Data.
• Developed Test Cases and SQL Queries to perform various Validations of the BO Reports.
• Extensively tested several Business Objects Reports, Crystal reports and Dashboards to validate the reports data and cosmetics of the report.

Confidential

Informatica / BO Developer

Languages : SQL, PL/SQL, UNIX

Responsibilities:

• Worked on Informatica Power Center 7.1 Repository Manager, Mapping Designer, Workflow Manager and Workflow Monitor .
• Extracted, transformed data from various sources such as Oracle, Flat files, Excel, XML files and loaded into the target data warehouse Oracle 9i.
• Used update strategy and Lookup transformation to insert, delete, update or reject the records based on business requirements.
• Developed several complex Mappings, Mapplets and Reusable Transformations to facilitate one time, Weekly, Monthly and Yearly Loading of Data.
• Utilized the Aggregate, Join, Router, Look up and Update transformations to model various standardized business processes.
• Created Stored Procedure, Functions and Triggers as per the business requirements.
• Developed UNIX Shell Scripts and SQL Queries.
• Prepared Test cases based on Functional Requirements Document.
• Performed migration of mappings and workflows from Development to Test and to Production servers.
• Created Webi reports with multiple data providers and synchronized the data using merge dimensions.
• Updated the Universe as per the changes of the Database table and notified the users about changes made to the Universe.
• Formatted the reports according to the user requirements using Business Objects functionalities like Dynamic cascading prompts, Breaks, Calculations, Slice and Dice, Drill Down and Variables.
• Organized data in the reports using Filters, Sorting, Ranking and highlighted data using Alerter.
• Debugged and sorted out the errors and problems encountered in the production environment.