SUMMARY:

• Over 12 years of total experience in Information Technology Industry with over 8 plus years of expertise in developing Business Intelligence and Data Warehouse applications using Oracle, PL/SQL, Business Objects XIR3/XIR2/6.X/5.X, and Crystal Reports 7.0/8.0, Crystal Reports XI, Web Intelligence, Xcelsius.
• Strong Knowledge in all phases of Software Development Life Cycle (SDLC) such as developing, testing, Migrating, Administrating, security management and production supporting on various platforms like UNIX, Windows NT/2000/XP/98.
• Extensive experience in Oracle SQL, PL/SQL programming and performance tuning.
• Written procedures and functions for ETL data loading from source systems, text files to target Oracle database.
• Performance tuning for Oracle database by Partitioning tables, appropriate Indexes and purging unwanted data.
• Written good and standard PL/SQL objects (functions, collections, Analytical functions, Piped Functions, Bulk Loading)
• Expertise in providing comprehensive data warehouse solutions by using Dimensional model design using Star Schema design methodologies.
• Expertise in BO Universe designing, developing and generating complex, Adhoc, dashboard Reports, Business views, List of values along with User Acceptance Test and data accuracy Test.
• Extensively worked on publishing reports to intranet through Web Intelligence.
• Rich ETL and OLAP experience using Oracle 10 g, SQL Loader, Reveleus and Business Objects.
• Experience designing and developing ETL components that are mapped in Reveleus and Oracle functions to load over 30 source feeds into the Non CMB target fact table using a Meta Data strategy.
• Experience in entire Software Development Life cycle involving Analysis, Design, Development and Testing. Hands on Experience in handling SOX Complaint Projects.
• Design, development and coding with ORACLE 10g/9.2/8.x/7.x, SQL Server 2000/2005
• Working Knowledge in Unix Shell Programming.
• Extensively worked on sourcing the Data from Oracle Apps ERP R11i, People Soft, IBM Mainframes (DB2).
• Extensive functional and technical exposure in Banking and Manufacturing Domain.
• Extensive knowledge in migration experience with strictly adhering to security and Business requirements.
• Worked with Crystal Reports - XIR2 / 3 for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports, data reports along with LOV.
• Lead and coordinated the migration of BO XI R2 to R3.
• An enthusiastic and project-oriented team player with solid communication and leadership skills and the ability to develop creative solutions for challenging client needs.

TECHNICAL SKILLS:

OLAP Tools: Business Objects XIR3/XIR2/6.X/5.X, Designer, Supervisor, Desktop Intelligence, Web-Intelligence, Info View,Xcelsius, Broadcast Agent, CMC Performance Management, Report Conversion tool and Import Wizard, Datastage 7.5, Ab Initio, Reveleus ETL.

RDBMS: Oracle8i/9i/10g, SQL Server 7.0/2000/2005, MS Access 2000, SQL*Loader.

Versioning Tools: PVCS

Languages: SQL, PL/SQL, GUI Tools Crystal Reports 7.0/8.0, Crystal Reports XI, Web Intelligence, Xcelsius,Oracle Toad.

Multimedia & Web Designing: HTML/DHTML, MS Office, Operating Systems Windows NT/XP/2000/98, MS DOS and UNIX

PROFESSIONAL EXPERIENCE:

Confidential

Senior Business Objects / Crystal Reports Developer

Responsibilities:

• Extensive documentation at each level of system development life cycle and coordinated the effort of implementation of change requests from requirement gathering stage, testing and implementation.
• Design and develop ETL components that are mapped in Reveleus and Oracle functions to load over 30 source feeds into the Non CMB target fact table using a Meta Data strategy.
• Prepare detailed source and target mapping document for the development of Data mart to cater for BaselII Reporting requirements.
• Performance tuning (partitioning of tables, Indexes, optimizing PLSQL codes, Analyzing/Gathering the tables etc) of oracle objects
• Lead and Coordinated effort for migrating of data from Data Standards Hub (DSH) to Data Standards Management tool (DSMT), coordinated DSMT migration effort with DSH, DSMT and UNIX Admin teams and also coordinated the testing effort with SIT and UAT teams.
• Developed partitioned tables, functions and configuring Reveleus ETLs to support Meta Data Rule component.
• Provide support, guidance, and in the deployment of the solution in various environments such as integration, QA, and production support by coordinating with cross functional Teams and testing effort with business users.
• Extensively used Crystal Reports for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports, data reports along with LOV reports, sub-reports.
• Good experience in BASELII systems like pre-processing, data enrichment of exposures, calculating PD, LGD, M, EAD, RWA, UL, EL and capital requirement of transaction and exposures.
• Worked on key management reports like data quality metrics, data validation metrics, trend analysis for a range of period, AFS and comparison reports using Business Objects XI R2
• Rich ETL and OLAP experience using Oracle 10 g, SQL Loader, Reveleus and Business Objects.
• Create database objects, universes with to support the development of Business Objects reports
• Designed adhoc / complex universes with contexts at Facility/Transaction /Exposure level, defined custom hierarchies, used alias for Business /Organization unit level regions, used derived tables to avoid the complexity of joins between tables.
• Created complex reports like Master/Detail, Trending reports, Data Quality Indicator reports, URL linking reports and also used Web Intelligence Rich Client to develop reports.
• Developed Xcelsius Dash board for Finance and Credit Risk business management.
• Scheduled the BO reports using UNIX script by segregating report scheduling based on different sectors.
• Lead and prepared detailed steps to be taken into account and testing scenarios to be considered at the infra-structure level, user level and developer level during the migration of BO XI R2 to R3 and coordinated the migration exercise with different teams.
• Extensively involved in Production support and coordinated with Operations, DBA and System Admin team for resolution of the issues.
• Extensively interacted with cross-functional teams to identify / resolve the issues related to infrastructure.
• Extensively involved in the migration of code from different environments and coordinated the migration process with deployment teams. Provided extensive tactical solutions for production secure data using UNIX script.

Environment: ERWIN, Oracle 10 g, Oracle PL/SQL, Unix, Business Objects R2/3, Crystal Reports XI, Web Intelligence,Xcelsius,Reveleus ETL, IBM-AIX, TOAD, PVCS, MERQURY Quality Center .

Confidential

Responsibilities:

• Primary responsibilities included but not limited to designing of Star Schema using ERWIN which includes over 65 dimension and 15 Fact tables.
• Prepare detailed sizing document based on the data available for each month from source system and Source and Target Mapping document and ETL loading strategy document.
• Prepare Architecture, design documents as per CITI document standards; Additional tasks included the creation of schema objects (partitioned fact tables, dimension tables, views, indexes, packages, functions etc.).
• Created BO Universe to cater Facility, Transaction and Exposure level contexts and also adhoc universe to enable users to generate adhoc reports according business needs.
• Involved in the development of Ab Initio graphs and providing the requirements for off-shore development team.
• Developed different BO Universes at Facility, Transaction and Exposure level contexts and also to cater for normal and adhoc reporting capabilities with row level security for the different Business Unit, Organizational Unit and Regional level users.
• Created complex drill-down, slice and dice, URL linking and graphs reports and segregated and published reports into different categories; Crystal Reports were used to connect to different data sources to cater for Business user need and created complicated reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports, data reports along with LOV reports.
• Prepared detailed requirement to enable Stress Testing team to undertake performance of each report.
• Performance tuning of data-mart, BO universe and Reports.
• Implemented row level security based on Business unit, Organization unit and Regions and Country.
• Created different categories based on the business requirement and published the reports.
• Migrated universes and reports to different environments using Business Objects Import Wizard.
• Coordinated with database and Ab Initio teams for the deployment of Ab initio graphs and database objects for every release and verified the completeness of the deployments.
• Provide Production Support as per raised Defects.

Environment: ERWIN, Oracle 10 g, Ab Initio 2.15, Business Objects R3, Crystal Reports XI, Web Intelligence, Autosys, IBM-AIX, TOAD, UNIX, PVCS, MERQURY Quality Center.

Confidential, NJ

Senior Business Objects Developer

Responsibilities:

• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Build the new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.
• Used Derived tables to create the universe for best performance, and use context and alias tables to solve the loops in Universe.
• Created different reports containing charts showing revenue and operating income by
• Involved in concerting existing PL/SQL ETL processes to Datastage 7.5.
• Provided the security access management by creating users/groups and folders.
• Implemented the ETL process and business logic by using PL/SQL.
• Prepared detailed migration document for migration from DEV to UAT and PROD.
• Developed BO Universe user documentation guide for the end users .
• Provided for end users for generating their own report including complicated report.

Environment: Business Objects 6.5.1/ XI R2 /R3, Crystal Reports XIR2, Designer, Desktop Intelligence, Web Intelligence, CMS, Oracle 10g,DataStage 7.5, SQL, PL/SQL, Windows XP,Unix.

Confidential, PA

Business Objects Developer

Responsibilities:

• Directly coordinating with user to gather the new requirements and working with existing issues.
• Designed & Implemented security architecture for Financial Group.
• Involved in Data Modeling and SQL server Database.
• Designed Universes for Financial Billing system and Order processing.
• Created Objects and prepared Reports like financial reports, HR reports, standard and adhoc reports, and universes using BO.
• Involved in joining the tables by creating aliases to resolve the loop.
• Created Reports based on sub total of Currency and General Ledger category.
• Prepared many other reports by using master details, cross-tabs, slice and dice and drill mode as per the requirement of the end-user.
• Converted Desktop Intelligence Reports to Web Intelligence using Report Conversion Tool.
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
• Performed unit testing, system testing and user acceptances test (UAT) for universe, reports and security management.
• Developed BO Universe user documentation guide for the end users

Environment: Business Objects 6.5.1/ XI R2 / 3, Crystal Reports XIR2, Designer, Desktop Intelligence, Web Intelligence, CMS, Oracle 9i, SQL, PL/SQL, Windows XP Oracle Apps 11i, STARGATE, FCS/FIS.

Confidential, CA

Business Objects Developer

Responsibilities:

• Prepared the Project Scope. Articulated and documented ETL Strategy, OLAP Strategy, Database Sizing, ODS Loading Strategy, Security implementation, Test Strategy and deployment strategy.
• Identified the Data points required from Promis System, Oracle ERP System and Peoplesoft.
• Developed data quality improvement strategies and creating, manipulating, and evaluating metadata
• Created Universes for various functional groups for high level reports group.
• Created Joins, Contexts, and Aliases for resolving Loops and Universe Tuning and checked the Integrity of the Universes.
• Created reports using Crystal Reports with Standard, Summary, Cross Tabs, SQL, Command Objects, Selection Criteria, grouping, sub reports etc.
• Prepared SIT Test & UAT Test Case and Plan.
• Deployment and User

Environment: Oracle 8i/9i, Erwin designer, datastage 7.1, Business Objects 5.1.6, Web Intelligence 2.7.3, Broadcast Agent, PL/SQL, XML, VISIO, Sun Solaris Unix, Oracle Apps 11i, Peoplesoft, CRM and DB2.

Confidential, CA

Business Objects Developer

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications about the financial system for Business Objects Universes and Reports.
• Defined Hierarchies in Universe to provide the users with Drill down option in reports and Predefined Conditions to use in Business Objects.
• Designed complex universes with alias / contexts to avoid the complexity and also used derived tables.
• Developed complex reports to cater Quality and Customer Corrective Action requests monitoring and management decision reports.
• Prepared SIT & UAT Test Strategy for the entire application.
• Wrote Alert Scripts to Page/email the Support Personal in case of intermittent failure.

Environment: Oracle 8i/9i, Erwin designer, Datastage 7.1, Business Objects 5.1.6, Web Intelligence 2.7.3, Broadcast Agent, PL/SQL, XML, VISIO, Sun Solaris Unix.

Confidential, CA

Programmer Analyst

Responsibilities:

• Gathered KPI measures and its associated dimensional data points
• Prepared KPI definitions and business rules and formulas.
• Developed SQL Loader Program to Load the external data into Data Mart.
• Mapped the KPIs and the dimensional data points with the Business Opportunities Data Mart.
• Developed PL/SQL Scripts to Create the Summary Views and summary tables and detail Views.
• Created ETL Scripts using Datastage.
• Created Business Area, Folders, Formula, Hierarchy using Discoverer Administrator.
• Prepared the SIT and UAT Test plans. Moved to Production (MTP).
• Provided UAT Bug Fixing and Production Support.
• Responsible for the users.

Environment: Oracle 8i, SQL Server, PL/SQL, Datastage 7..1, Discoverer Administrator 4.1.42, Discoverer User Edition 4.1.42, Business Objects 5.1.6, Web Intelligence 2.7.3, VISIO, Sun Solaris Unix and Windows NT

Confidential

Programmer Analyst

Responsibilities:

• Discovered the Data Points required by the business group in the Data Warehouse.
• Defined the Data Points: Its definition, Business Rules and its data sources.
• Created the Source Target Mapping Document with data point name, Source System name, Source table name/column name, ETL rules and Cleansing Rules.
• Designed the Data Model using Dimensional Modeling Star Scheme technique.
• Developed ETL strategy to handle Slowly Changing Dimension cases, History Maintenance and Exception handing.
• Developed BO Universe and Operational Reports with Drill Up/Down, Slice and Dice capability
• Prepared the SIT and UAT Test plans and performed UAT Bug Fixing.

Environment: Oracle 8i, Oracle ERP R11, Data Stage, Business Objects 5.1.6, InfoView, Discoverer Administrator 3.1.36 & Discoverer User Edition 3.1.36, Plumtree, Weblogic, Web Methods, Documentum, I-Planet(TIM/TAM)

Confidential

Programmer Analyst

Responsibilities:

• Developed Scripts to create the data warehouse Schema (Tables, Constraints, Indexes).
• Created PL/SQL Scripts to pull the information form Promis, Oracle Apps and Promis System.
• Developed PL/SQL Scripts to Create the Summary Views and summary tables and detail Views.
• Developed PL/SQL Stored Procedures using multiple Insert Statement, Dynamic Cursors, Merge Statement, with exception handling provisions.
• Created End User Layer (EUL) using Oracle Discoverer 4.1.42. Experience with Export/Import EUL

Environment: Oracle 8i, 9ias Application Suite, PL/SQL, Business Objects, Plumtree, Windows NT, Sun Solaris Unix

Confidential

Programmer Analyst

Responsibilities:

• Took the requirements from the users and provided the high-level design document to the developer to develop/modify reports.
• Developed forms by adhering to coding standards
• Heavily involved in the development of FSG Reports.
• Defined Concurrent Programs and executables
• Created Value Sets and provided System Support and UAT.

Environment: Sun Solaris, Oracle 8i, RACLE Human Resource, Developer 2000,Oracle 8I