SUMMARY

• Having 11 Years of IT experience in Business Intelligence & Data Warehousing Technologies using Informatica Power Center 8.6.1, SAP BI 4.0, BusinessObjects R3.1/XI R2/6.5/5.1, Webi XI R2/R3.1 Dashboard Manager, Info View, Crystal Reports XI 2008/R2 and IBM Rational Tool.
• Gained substantial Business Knowledge related to Trades, Settlement & Repo Positions while working on reporting solutions for Back - office operations for a large Securities Trading Company.
• Hands on experience in creating Federal regulatory Reporting for regulatory teams.
• Hands on experience on creating Basel reports.
• Proven track record in planning, building, and managing successful large-scale Data Warehouse and decision support systems.
• Comfortable in both technical and functional applications of RDBMS, BI, OLAP, Data Mapping, Data management and Data transportation.
• Working knowledge and proficiency with SAP BI 4.0, Business Objects XI-R3.1/ XI-R2, INFORMATICA POWER CENTER 8.6.1.
• Designing and building ETL for data loading using up to date technologies in Informatica Powercenter 8.6.1
• Experience in working with different Databases like Oracle, MS SQL Server, DB2, VSAM Files and FLAT Files.
• Working Experience with Crystal Reports 10 and Crystal reports XI R2.
• Building infrastructure like installing & configuring the BO servers, and providing production supports of Servers and to users.
• Experience in creating large applications using Oracle SQL & PL/SQL.
• Expertise in writing Oracle Stored Procedures, Functions, Packages, Triggers and creating Views and Materialized views.
• Good experience on performing Load tests and Performance tests on Business objects and Database
• Good experience in OLTP system, IBM Mainframes
• Possess wide range of IT industry experiences with Finance, Banking and Retail Industries with strong analytical, problem-solving, organizational, communication, learning and team skills.
• Experienced with coordinating cross-functional teams.

TECHNICAL SKILLS

Business Intelligence: SAP BI 4.0, Business Objects XI-R3.1/R2/6.X, Crystal Reports XI R2, SSRS

Languages: SQL*Plus, PL/SQL, COBOL, JCL, VB Macro

RDBMS: Oracle 7.x /9i/10g, DB2 UDB 8.2, SQL Server

ETL Tools: Informatica Powercenter7.5/8.6.1

Data Modeling Tool: ERWin 3.5.2/4

Scheduling Tools: Control-M, AUTOSYS

Project Management Tools: IBM Rational (Clear Quest and Req Pro), Clarity, JIRA

Testing tools: Selenium, Jmeter

Monitoring Tools: Sitescope, Nagios, ICE

Operating Systems: Unix, Windows, IBM Mainframes (OS/390 & z/OS)

PROFESSIONAL EXPERIENCE

Confidential

Sr Business Objects Consultant

Responsibilities:

• Analyzed all FR2004 BOXI reports to identify necessary changes as per Federal Revisions.
• Analyzed Universes to Accommodate new objects/change existing objects as per new requirements.
• Changed all FR2004(A,B,C) reports to include new changes.
• Created new reports( FR2004 FA, FB,FC, FM) for Class A,B,C TBA settlements fails reports .
• Successfully migrated reports to production and trained users to use reports.
• Closely worked with ICI IMPACT and Business teams to understand the migration requirements
• Analyzed all BOXI reports to identify business requirements to convert BOXI Universes into a report specific sqls in SSRS.
• Analyzed the impact of the Settlement system Database migration from DB2 to SQL Server on reporting Data warehouse and on Reports.
• Analyzed Universes to do feasibility study to transform universes in cubes in sql server.
• Designed and Planned different phases of migration and lead team to consolidate existing universe and migrate them into SSRS.
• Successfully migrated reports to SSRS infrastructure and trained level 1support to support reports.
• Responsible to create Regulatory reports, Audit reports for external auditors, Client statements on monthly basis.
• Responsible for maintaining BO infrastructure for complete Fixed income business.
• Responsible for gathering user requirements and create Technical specs to allocate work to the developers.
• Worked on creating complex universes/canned reports for regulatory and operations teams
• Implemented row level/object level/report level security on regulatory/compliance data related universes to secure data from other regions.
• Extensively worked on enhancing report performance by consolidating data provider requirements and improving query performance.
• Expertise in leading teams across the different timezone to make sure the availability of the BOXI platform 24X7.

Confidential

Sr Business Objects Consultant

Responsibilities:

• Analyzing and Understanding the impact of the Settlement system migration from NTAPS to IMPACT on reporting Datawarehouse and on Reports.
• Worked with the Data modelers and Business Analysts to document the required changes for reporting database and Webi & Crystal reports.
• Worked with report writers to identify all the changes required for Universes, Business Views and Reports to estimate time and resources and also involved in planning complete migration plan.
• Designed and implemented Universes & Business views changes in order to minimize report level changes.
• Designed and implemented ETL changes for FAS157 datamart using Informatica as part of IMPACT migration.
• Remediated reports to reflect data changes due to new settlement system IMPACT
• Created test cases and worked with the report writers and business analysts to test the changes.
• Planned and implemented complete end-to-end migration of BusinessObjects content as part of IMPACT project.
• Worked with System administrators and BO administrators to understand the requirements for Upgrade from BOXI R2 to BOXI R 3.1
• Created complete project plane and resource planning for upgrade of the Business objects and full cycle testing of all BO components after upgrade.
• Worked with the BO administrators to upgrade Business Objects to BOXI R3.1 and fixed issues in universes and Business Views due to upgrade.
• Worked with the report writers to test all reports and worked with Business analysts and users to test user security after upgrade.
• Conducted user training sessions to provide the understanding on new version of the BusinessObjects
• Understanding the data availability and working with the data modelers to get the necessary data for reporting.
• Worked on Design and Development of Universes, Business Views and Canned complex reports for Fixed Income and EQ Back Office operations.
• Experience in creating and deploying Crystal Reports on BusinessObjects servers.
• Extensively worked on Migrating Crystal Reports to WebI reports
• Working with DBA team in tuning the Report SQL to improve the performance of the report by adding Hints.
• Administering BO Infrastructure and working on real-time production support.

Environment: Business Objects XI-R3.1/R2, Webi XI R3.1/R2, Oracle PL/SQL, Informatica 8.6.1 Client/Server platform, Windows, JIRA,TOAD,PL SQL Developer, Apache/TomcatProject

Confidential, NY

Sr Business Objects Consultant

Responsibilities:

• Worked with The Users and BAs to gather and understand the requirements and created technical requirements document.
• Extensively worked on BO Server management and trouble shooting BO infrastructure issues and on going reporting and Universe errors.
• Implemented and deployed Custom BO applications to improve the Usability of the CRRT application.
• Universe data Security analysis and Create the Universe using Group based row level security.
• Created Complex canned reports with more than 12 data providers in a report from different data sources and tuned the reports with Hints to improve the performance in terms of report run times.
• Conducting Load testing on Business objects and Database.
• Working with J2EE team to create custom reporting applications

Environment: Business Objects XI-R2, Webi XI R2, Business Objects XI-R3, Webi XI R3,Oracle PL/SQL, and Client/Server platform, SUN Solaris and Windows, Apache/Tomcat, Weblogic, EQM, SiteScope, Nagios, Autosys, Tripwire, Unison, JAVA, J2EE.

Confidential

Responsibilities:

• Involved in Designing enhanced Data model for Clarity BO Reporting
• Worked on Design and Development of Clarity Universe and Complex canned Webi reports
• Universe data Security analysis and Create the Universe using Group based row level security.
• Identifying key issues in Long running reports in Production and working with DBA team to resolve issues
• Conducting performance tests on BO reporting database and Clarity application
• Created Test data using Selenium IDE and conducted Load tests using Selenium RC.
• Working with DBA team in tuning the Report SQL to improve the performance of the report.

Environment: Business Objects XI-R2, Webi XI R2, Oracle PL/SQL, Client/Server platform, Windows, Selenium

Confidential

Business Objects Lead Developer

Responsibilities:

• As a Senior BO Developer, responsible for gathering requirements, analyzing and translating end user requirements in to functional Decisions support System.
• Extensively, worked with Data Warehouse/Data Mart Team, presenting end user reporting requirements, analyzing present Data Mart objects, requesting new objects and requesting new aggregation built within Data Mart.
• Extensively worked with Multiple Data providers, linking of Data Providers and Merged Dimensions to generate complex reports.
• Worked on all advanced reporting functionalities in WebI XI Drill Down, Drill Up, Breaks, Database Ranking & Report Ranking and report level variable based filtering to create complex reports.
• Extensively used IBM RATIONAL TOOLS (ReqPro, ClearQuest) for project management and issue tracking.

Environment: Oracle 9i, Business Objects XI-R2, WebI XI R2, Crystal Reports XI R2, EBI, Oracle PL/SQL, Informatica 7.1.2 Windows NT.

Confidential, WI

Business Objects Lead Developer

Responsibilities:

• Involved in the meetings with users to gather requirements for developing reports.
• Responsible for Building Business Objects infrastructure. Install Configure, Release and maintaining the full functional reporting infrastructure and User Groups.
• Created complex universe for Dashboard manager specific for creating metrics for developing analytics which will be placed on dashboard.
• Responsible for managing the BusinessObjects reporting environment including Administration, repository management, report specification, creation and development (report, template, Universes creation), production maintenance, distribution strategy.
• Creation of reports like Product Performance, Sales Forecast and Customer Retention.

Confidential

Software Engineer

Responsibilities:

• Analysis of existing programs as per the client requirement and identify the Impacted Programs.
• Coding of respective programs as per the Client coding standards.

Environment: H/w: OS/390 O/s: MVS/ESA S/w: JCL, COBOL, VSAM, CICS.

Confidential

Software Programmer

Responsibilities:

• Analysis of existing programs as per the client requirement and identify the Impacted Programs.
• Coding of respective programs as per the Client coding standards.

Environment: H/w: OS/390 O/s: MVS/ESA S/w: COBOL, DB2, JCL Tools: File Aid