SUMMARY

• Over 15 years of IT Experience and 11 Plus Years of extensive experience in Business Objects product suite, knowledge in Databases Oracle, Sybase, DB2, MS Access, and SQL Server , Knowledge in Datawarehouse tools Informatica and Kalido .
• Proficient in creating universes, designing and maintaining reports using Business Objects 5.x, 6.x and XI, Crystal XI, WEBI, SDK, Dashboard Manager, Performance Management and Xcelsius.
• Worked with Oracle Stored Procedures, Personal data files and Free hand SQL for loading data into reports.
• Expert knowledge in CMMI processes, Software Development Life Cycle SDLC , Agile, RUP, and SCRUM methodologies.
• Developed system documents like Functional Spec, Technical Spec, Release Notes, and User Manuals.
• Develop applications, implement, integrate and administer applications such that they meet organization requirements defined by business needs, SLAs, and IT governance policies.
• Experienced in working within the Sarbanes Oxley Act SOX guidelines within the financial services sector.
• Dedicated to successful project completion with the ability to work well as a Team Member or as an Individual.

SOFTWARE SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Lead BI Architect

• Design the data models necessary for the BI solutions, working with the DBA team and development team in the specification and development of the architecture for the BI systems.
• Constructed BI/DW projects with a standard technical architecture and methodology to ensure ETL, database, and BI components are optimally designed to seamlessly integrate within a project and across projects.
• Reviewed requirement documents with Data warehouse team for FBIS project.
• Used ETL tool Informatica to generate staging tables for FBIS group.
• Developed various mappings for extracting the data from different source systems using Informatica PowerCenter - Server, Workflow Manager, Repository Manager and Designer.
• Created Mapplets for reusable business rules.
• Facilitated multiple meetings involving project progress tracking, formulating communication requirements and agreement on project deliverables.
• Used Contexts for resolving loops to deal with Multifact and Confirmed Dimension tables and alias to deal with snowflakes.
• Involved in requirements gathering for developing Quick Query and Med Watch reports.
• Developed technical architecture design and documentation.
• Gave demo to client showcasing Xcelsius dashboard capabilities.
• Developed training documents/presentations to cross-train and share knowledge amongst Business Users.
• Worked with moderate guidance to track and report project progress and performance while managing a very agile set of requirements.

Environment: Business Objects XI R3, Xcelsius 2008, Live Office, QAAWS, Oracle 10G, Informatica 8.5, LDAP, Linux, Windows 2008, SQL and PL/SQL, Toad, StarTeam

Confidential

Lead BI Architect

• Led the BI team to develop prototypes and proof of concepts presenting feasible solutions to the upper management.
• Worked with Business Objects developers to establish best practices and standards for universe, report, and dashboard development.
• Involved in Fit-Gap analysis between the legacy and the target reporting database, analyzed the business entities for the warehouse.
• Developed System requirements design and documentation.
• Extensively used Business Objects CMC to manage categories, creating and managing the users, provision/deny access to a group or user to create/view/refresh/publish Business Objects Reports.
• Partnered cross-functionally with QA and Performance Test teams to improve application quality, reliability and performance for LLC Datamart.
• Designed Universe for LLC Datamart, LAD Summary and 4C Datamart team for Adhoc report generation.
• Developed LLC Summary application Universe which feeds on OLTP Apex application.
• Used Contexts for resolving loops to deal with Multifact and Confirmed Dimension tables.
• Developed Xcelcius Dashboard for 4C Datamart which would analyze and monitor Asset Performance.
• Developed 3G and 4G Counterparty Webi Reports for LMDM group.
• Responsible for Migration of Reports from Development to Production and wrote Release Notes for Migration of BOXI Reports from Development to Test and Development to Production Environments.

Environment: Business Objects XI R2, Xcelsius 2008, Live Office, QAAWS, Oracle 10G, SQL-Server, IDMS, Datastage 7.5,LDAP, Linux, Windows 2003, SQL and PL/SQL, Toad, StarTeam.

Confidential

BI Architect

• Lead software evaluations and provide recommendations to the project manager.
• Facilitated identification of business and technical drivers for the project using WSSC's Horizon Project Management Methodology in a dynamic and innovation-oriented environment.
• Part of the administration team in performing day-to-day BO administration support activities such as monitoring servers, handling parameters for BO server processes to deduce availability and better performance of the reporting system.
• Worked with moderate guidance to track and report project progress and performance while managing a very agile set of requirements.
• Used ETL tool Informatica to generate staging tables for SSO group.
• Created Mapplets for reusable business rules.
• Designed Universe for Customer support team for Adhoc report generation.
• Used Contexts for resolving loops to deal with Multifact and Confirmed Dimension tables.
• Created Crystal Reports using Universes as data Provider for UIEDSS and FIT groups.
• Created BOXI R2 Webi reports for SSO datamart.
• Developed Drill down Reports and used Open Document Syntax in Webi to give the drill down functionality to the report.
• Gave training to Users for building Adhoc reports using both Crystal and WebI.
• Vendor Management i.e. to work with Business Objects customer support team to report resolve issues/limitations/bugs in the off the shelf BO software.

Environment: Business Objects XI R2, Crystal Reports XI, Desktop Intelligence, Xcelsius, Live Office, Performance Management, Oracle 10G, SQL-Server, IDMS, Informatica 8.5,LDAP, ERWIN 7.1, Linux, Windows 2003, XP, SQL and PL/SQL, Toad.

Confidential

BI Architect

• Reviewed requirement documents with Data warehouse team for Securities Datamart Team.
• Created derived tables in Universe for some specific Adhoc report generation.
• Created Crystal Reports using BOXI R2 for Securities Datamart and using SDM Universe as data Provider.
• Created BOXI R2 WebI reports for Securities Data mart.
• Created Bar Charts, Line Charts, Pie Charts, Filters and According Menu in dashboards based on requirements.
• Developed drill down Reports and used Open Document Syntax in Crystal.
• Worked with FAPT Reporting Infrastructure Team to resolve some performance issues while running reports from BOXI Enterprise.
• Migrated Crystal Reports BOXI R2 from Development to Test environment for Security Datamart Project using Clear Case and Import Wizard.
• Made Enhancements to Securities Datamart Universe.

Environment: Business Objects XI R2, CMC, Crystal Reports XI, Performance Management, Ab Initio, Oracle 9i/8i/8.0, SQL Developer, TOAD, and Windows 2003.

Confidential

BI Architect

• Gathered requirement documents with BA's for Dashboard Creation in Xcelsius.
• Worked with DB, ETL and business analysts to identify tables and columns in both Development and Production Environments.
• Designed Universe for Customer Stewardship project.
• Used Contexts for resolving loops to deal with Multifact and Confirmed Dimension tables.
• Generated derived tables for building Custom Tables in the Universe.
• Meeting extensively with Business Analyst, end users/customers to understand report requirements for Web I.
• Created required restrictions sets to maintain the security for the users in Business Objects XI.
• Designed Xcelsius dashboards using Live Office and QAAWS as data providers.
• Created Bar Charts, Line Charts, Pie Charts, Filters and According Menu in dashboards based on requirements.
• Used Live Office connecter which enabled dashboards to refresh on a weekly basis.
• Used drill down functionality in Xcelsius to enable users to drill into more detail dashboards.

Environment: Business Objects XI R2, CMC, Crystal Reports XI, Xcelsius 4.5, Live Office, QAAWS, Performance Management, Informatica, Oracle 9i/8i/8.0,Teradata, SQL Developer, Citrix, Windows 2003.

Confidential

Sr BOXI Data Warehouse Developer

• Reviewed requirement documents with Data warehouse team for Policy and Claims groups and produce a Kalido DIW model.
• Involved in discussions for building Kalido data model for Policy and Claims data warehouses and identified BE Business Entities , CBE Common Business Entities and their relationships.
• Look at the data sources and produce ETL spec for data to be ready to be ready for DIW loading.
• Performance analysis of DIW for Reference and Transaction data loading.
• Wrote scripts for generating indexes in Kalido while building Mapping and DM tables in Post Script area.
• DIW model transfers.
• Built Mapping, Attribute, TDS, Reference file loads and DM tables in Kalido for Policy Data Warehouse.
• Wrote Scripts for creating indexes on delete T and delete thing T.
• Installed and configured BOXI R2 on Windows 2003 server for both development and Production systems.
• Designed Universes for Policy and Claims groups from Kalido data warehouse Skalido.

Environment: Business Objects XI R2, CMC, Crystal Reports XI, Xcelsius, Live Office, QAAWS, Performance Management, Informatica, Kalido 8E, Oracle 9i/8i/8.0, SQL Developer, Windows 2003.

Confidential

Sr BOXI Developer

Responsibilities:

• Reviewed requirement documents with Business Analysts for FDW Financial Datawarehouse , GL Datamart, Loans Datamart and Equity Datamart.
• Reviewed integration of Abinitio with Kalido and its application with Business objects BOXI R2 with Kalido consulting group.
• Designed Universe in BOXI R2 Designer for Equity Datamart project.
• Created Crystal Reports using BOXI R2 for Equity Datamart and using Equity Universe as data Provider.
• Created BOXI R2 WebI reports for Equity Datamart.

Environment: Business Objects XI R2, CMC, Crystal Reports XI, Performance Management, Ab Initio, Kalido 8E, Oracle 9i/8i/8.0, Unix Shell Scripting, Sun Solaris7.8, Clear Case, Mercury Quality Center, Windows NT.

Confidential

Business Objects Developer

Responsibilities:

• Involved in Installation and Configuration of BO XI R2 in a clustered environment.
• Migration implementation plan for upgrade of BO 6.5.x to BOXI R2.
• Involved in Infrastructure tasks such as Server Sizing estimations, server load balancing etc.
• Classifying BOXI Servers into server groups using CMC and their administration.
• Monitoring and Tuning Server performance.
• Train the users to build adhoc reports.

Environment: Business Objects XI, 6.5.1 Broadcast Agent, Business Objects Auditor, Web Admin tool, Application Foundation, Supervisor, Designer, Web Intelligence/InfoView, Ascential DataStage 7/6.0/5.2, Jobs, ETL, Oracle 9i/8i/8.0, Sybase 12, ERwin, Unix Shell Scripting, Sun Sparc, Sun Solaris7.8

Confidential

Business Objects Developer

Responsibilities:

• Involved in Installing the Business Objects 6.1b, creating Repository, creating Users and User Groups using supervisor module.
• Involved in the design and development of Universes, Classes, Objects and Conditioned Objects for Business Analysis and Report Generation.
• Created reports for various portfolios using universe as the main data provider.
• Tested and resolved loops and contexts to ensure the correct results from the query.
• Involved in training users in Business Objects.

Environment: Business Objects 6.1, WebI 6.x, Designer, Supervisor, BOSDK, ZABO, Dash Boards, Application Foundation 2.5, Oracle 9i, PLSQL, UNIX/ Shell Scripting.

Software Analyst

Responsibilities:

• Involved in Design of Screen Layouts and also Database design for Zenith Control Systems.
• Developed user interfaces using Oracle Forms to record employee information

Environment: Java, JavaServlets, JavaScript, HTML, Netscape Enterprise Server, Oracle 8.0,

Windows NT. Visual Basic 5.0, Oracle 7.0, and Crystal Reports 4.5.