PROFESSIONAL SUMMARY:

Over Seven Years of IT experience, with 6 years expertise in Business Intelligence

• Extensively worked on BIRT Designer 2.3.2, IDE Eclipse for Java EE Developers ver 1.2.2, Business Objects 6.5, XI R2, Designer, CMC, Desktop Intelligence, Web Intelligence, Supervisor and Broadcast Agent.
• In-depth knowledge of Data warehouse concepts and methodologies.
• Expertise in Business Objects Full Client & Thin Client environment.
• Good Data Analysis Skills
• Good Understanding of SAP BW
• Good Understanding of SAP BO XIR2 suite
• Experience in creating BO Universes
• Managed Audit Universes and Audit Reports
• Experience in migrating BO 6i to BOXI R2
• Experienced in writing and debugging SQL and PL/SQL(Stored Procedures).
• Strong knowledge of Extraction, Transformation and Loading (ETL) processes.
• Knowledge in Star schema modeling, Snowflake modeling identification of fact and dimension tables, and Normalization.
• Self-motivated, Result oriented team player and quick learner of new concepts and technologies.
• Excellent communication, interpersonal and problem management skills.
• Strong analytical, troubleshooting, and problem-solving skills.

TECHNICAL SKILLS:

OLAP Tools: BIRT designer 2.3.2, BIRT designer 2.5.2, Business Objects XI R2/6.5/, Web Intelligence XI R2/6.x, Universe Designer, Crystal XI, Xcelsius 2008
Development Environments: IDE Eclipse for Java EE developers 1.2.2, Visual Basic .Net 2003, Microsoft Office 2000, HTML, XML, JSP
Database Tools: TOAD, SQL Analyzer, DBVisualiser
Database: DB2, Oracle10g/ 9x/8x/7x, SQL SERVER 2000, SQL 2005, MS Access 2003
Reporting Operating Systems: Windows 2000/NT/XP, UNIX

PROFESSIONAL EXPERIENCE: 
Confidential February 2009 – Current

BIRT Business Intelligence Reporting Tool – Lead
I was involved as Business Intelligence resource to integrate Students’ Assessment Reports into LMS (Learning Management System) software. Responsibilities included:

• Interfaced with business users & transformed business requirements into technical requirements.
• Implemented and designed Student Assessment Reports & Curriculum Reports.
• Lead the team of junior developers (offshore)
• Worked closely with ETL team.
• Extensively wrote Stored Procedures in DB2.
• Created numerous Student/Curriculum reports.
• Performed data validation and testing of the reports by running stored procedure calls.
• Maintained QA & Production environments.

Environment: BIRT designer 2.3.2, Eclipse DB2, DbVisualizer 6.5.4, TOAD, XML, SQL Server 2005, MS Office, Apache Tomcat, J2EE , JSP

Confidential September 2010 – May 2011

Business Intelligence Reporting Tool (BIRT) – Sr. Software Developer
I was involved in project to migrate financial canned reports from BO Crystal to Business Intelligence Reporting Tools (BIRT). Responsibilities include:

• Designed multiple financial reports, for multiple vendors, within web server environment using Business Intelligence Report Tool (BIRT)
• Using parameter functionality, created sub reports / drilled reports per customer need.
• Design and develop BIRT reports using handlers and controllers as data source.
• Performed data validation and testing of the reports by running BO Crystal reports in DEV environment.
• Heavily used Java script as conditions in BIRT reports.
• Worked closely with Java developers making sure that I receive desired data to create datasets to be used in BIRT reports.

Environment: IDE Eclipse for Java EE developers 1.2.2, BIRT designer 2.5.2, Crystal 2008, Business Objects Enterprise XI R3, Oracle 10g, TOAD for Oracle, XML, MS Office, Apache Tomcat, J2EE , JSP

Confidential December 2007 – September 2008

Business Objects Developer

• Involved as an outside resource to deliver Reebok Fold In as efficiently as possible. Responsibilities included:
• Involved in Universe creation, Report Testing & universe migration to production
• Worked on Reebok Fold Out projects.
• Created numerous Desktop Intelligence reports as well as Web Intelligence reports.
• Created complex reports using multiple data providers.
• Created full client and thin client reports making use of prompts, slice and dice, drill down/up/through
• Designed, developed and provided help in creating ad-hoc reports, modifying Universes, scheduling reports
• Building hierarchies, conditions, prompts, alerter, charts, breaks
• Used designer to design various Universes for different business groups, created classes, objects
• Involved in modifications for existing business objects Universes
• Worked with contexts/aliases based on business requirements. Optimizing performance at Universe level and report level
• Resolved fan traps in the Universes using aliases
• Implemented the best practices while designing Universes and creating corporate documents
• Involved in creating numerous Reebok users and their securities for the Fold In project
• Created user groups, users, database connections, managed user privileges, import/export of Universes in production environment
• Involved with Scheduling corporate reports
• Publishing Reports to the BCA. Configure BCA Parameters to improve performance
• Extensively used SQL Query tools and SAP to verify results

Environment: Business Objects 6.5, Business Objects WEBI, Business Objects DESKI, Crystal XI, Xcelsius 2008, TOAD, Oracle 8, SQL Navigator, MS Office, Window 2000, Windows NT

Confidential February 2005 – October 2007

Business Objects Developer 
Worked on a project for the Sales and Marketing team. Responsibilities included:

• Involved in project life cycle (Universe Creation/Report Testing/Report & Universe migration to production)
• Created reports in DESKI and WEBI of business objects version XIR2
• Used formatting options like cross tab representation, section breaks, calculations, font, colors
• Involved in designing various Universes for different business groups, created classes, objects, aliases, contexts, drill paths, aggregate awareness ,filters, SELECT functions
• Knowledge of all documentation related to version migration that is provided by business objects technical support
• Knowledge on new features of BOXIR2 including CMS, CMC, Dashboards, derived tables and discussions
• Created complex reports using multiple data provider, cascading prompts, and decode objects
• Worked on Import Wizard for migrating from 6i to XI R2.Using this wizard Desktop Reports (.rep) and WEBI reports (.wid) are migrated to higher versions (XI)
• Worked with the supervisor in setting up the security & scheduling, which is done manually in the central management console and publishing wizard
• Created a Business Objects User’s power point presentation for an introduction to first time users and also as a handy guide
• 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
• Created different kinds of reports like master/detail cross tab and chart (for trend analysis). Used filters, conditions, breaks, linking multiple data providers, variable creation, drills and calculations
• Extensively used breaks for white spaces and sections for better navigation. Created template documents with header and footer and company logo

Environment: Business objects 6i/XI R2, Business Objects WEBI, Business Objects DESKI, Java, JSP, TOAD, Broadcast agent Server, Oracle 8, SQL Server 2000, MS Office, Window 2000, SQL Loader, Informatica Power center 6i

EDUCATION:

Bachelor of Science (Computer Information Systems)