SUMMARY:

• 11+ years of IT experience in software analysis, design, development for various software applications with over 7 1/2 years experience in handling Data warehousing and Business Intelligence tools like OBIEE 11g, OBIEE 10.1.3.x and Siebel Analytics 7.7 and Informatica
• Involved in REG reports related to Credit Risk, CCAR/DFAST and Market Risk for internal reporting which are implemented in OBIEE reports, BI publisher reports.
• Experience and understanding in working with different domains like Finance, Retail, Health and Human Services
• Efficient working experience on AGILE Processing, in tight schedules and sprints.
• Expertise in building Metadata Repository, Designing Business and Presentation Layers, creating Interactive Dashboards and Reports using Siebel Analytics/OBIEE
• Experience in creation of BI Publisher reports with various complex calculations and integrating the reports with Frame to create packages for the BI reports, which eases the user
• Creation of Various complex reports in BI Publisher using templates like Microsoft word(RTF), Microsoft Excel (XLS)
• Expertise in creation of Complex SQL statements with respect to design of BI Publisher templates and other Adhoc queries
• Acted as Project Manager and played critical role in the planning, scheduling, monitoring and execution of projects to support of business objectives for different clients in financial domain
• Data modeling experience using Dimensional Data modeling, Star/Snow flake schema, Fact and Dimension tables, Physical and logical data modeling
• Experience in OBIA like Financial Analytics, Supply Chain and Order Management(OOTB Modules)
• Data sources include Oracle EBS 11i, R12, Custom Sources
• Experience using Informatica PowerCenter 9.1/8.1/7.1 and knowledge of Oracle Data Integrator(ODI)
• Expertise in ETL design, developing and loading of data into the Warehouse using Informatica.
• Expertise in scheduling tools like Autosys, DAC
• Study of Current Business Processes, Future Business Flow and identification of GAP/Workaround
• Expertise in implementing Dimensional hierarchies and OBIEE Security
• Strong working experience in using OBIEE/Siebel Delivers which includes configuring Delivery Devices, creating and configuring Agents/iBots, and building Alerts.
• Strong expertise in Implementing MUD (Multi User Development) Environment.
• Expertise in Data Warehousing, Data Analysis, Reporting, ETL, Data Modeling, Development, Maintenance, Testing and Documentation.
• Experience in Oracle, SQL Server & DB2 - design and developing Stored Procedures/Packages using SQL, PL/SQL
• Knowledge in Java Scripting
• Extensive Knowledge in troubleshooting, Debugging, Optimizing and Performance Tuning of Oracle BI Dashboards / Reports to improve performance at Database.
• Good Team player and an individual contributor with steep learning curve and good interpersonal skills.
• Good Knowledge in Performance Tuning of Dashboards and on database side on various RDBMS like Oracle, DB2
• Proficient in working with OLTP and OLAP database system
• Experience in working in Agile Environment
• Also handling project management activities like Invoicing, resource managing
• Strong organizational, multi-tasking, and time-management skills with outstanding data analysis skills, and exceptional analytical and problem solving skills
• Mentoring fresher’s in OBIEE

TECHNICAL SKILLS:

BI/Reporting Tools: Siebel Analytics 7.7, OBIEE 10.x, OBIEE 11g, BI Publisher

RDBMS: Oracle 8i/9i/10g/11g, SQL Server 2000/2005, DB2

Database Tools: SQL Developer, TOAD

Operating Systems: Windows, UNIX

Programming: Basic Java, PL/SQL, SQL

Data ware housing: Informatica 8.1, Informatica 9.1

CRM Technologies: EIM-Siebel CRM

Tools: Visual Source Safe, Autosys

Custom Tools: Frame

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

OBIEE/Informatica Lead

Responsibilities:

• Effectively interacted with the end users for requirement gathering and defined requirement specifications document.
• Working with business with new enhancements in fit-gap analysis and reuse the existing reports and model missing requirements.
• Designed and Built Oracle BIEE Repository at 3 layers i.e., Physical Layer (connecting Data sources & import schema), Business Model / data mapping (create Logical tables & data source mapping) and Presentation Layer level (create presentation catalogs), create presentation folders, test and validate the model.
• Developed many complex reports in BI Publisher using RTF and XLS templates.
• Designed new major enhancements in the system like Application Registration Dashboards which are Intra-day and Inter day requirement for Informatica and OBIEE
• Designed Data Models and Metadata Repository (.rpd) with multiple business layers using complex joins.
• Integration of OBIEE with existing Worker Portal to view online Reports which aids in quick actions and decisions.
• Actively developed Informatica mappings for the requirements
• Analyse the issues from the users and assign to the related team
• Create customizations in Informatica, Data Warehouse, RPD and in Dashboards
• Created Reports and Dashboards based on User specifications.
• Created Charts, Pivot Table, Tables, Filters and Prompts in Dashboard Reports.
• Developed custom reports/Ad-hoc queries using Oracle BI Answers and assigned them to application specific dashboards.
• Developed Informatica mappings with various transformations like Source Qualifier, Aggregator, Expression, Joiner, lookups, Filters, Sequence, Router, Normalizer.
• Good Knowledge of SQL which helps to understand the functionality and build BIP reports.
• Quick delivery of Adhoc SQL queries to the business as per the requirement.
• Design of delivery of BIP reports to the portal for the quick retrieval of the reports.
• Developed and implemented process enhancements for efficient and effective work flow.
• Performed unit and integration testing of reports and dashboards.
• OBIEE Report Development and Architecture Skills
• Preparation of training documents for the users as part of User Training
• Assisting Users to understand the system and use it accordingly.

Environment: OBIEE 11.1.1.7, Oracle 11g, Informatica 9.0.1, Microsoft Excel and Microsoft Word BIP Templates

Confidential, Jersey City, NJ

OBIEE Lead

Responsibilities:

• Effectively interacted with the end users for requirement gathering and defined requirement specifications document.
• Organized meetings with Business users and Management to analyze the KPI’s, reporting data levels and gaps.
• Created a project plan with task categorization high, medium and low gaps with timelines.
• Designed and Built Oracle BIEE Repository at 3 layers i.e., Physical Layer (connecting Data sources & import schema), Business Model / data mapping (create Logical tables & data source mapping) and Presentation Layer level (create presentation catalogs), create presentation folders, test and validate the model.
• Performed the Performance Tuning of Dashboards and Reports and made required changes to repository and database in consultation with DBA
• Expertise in creating Autosys jobs
• Designed Data Models and Metadata Repository (.rpd) with multiple business layers using complex joins
• Created Initialization Blocks, Session Variables and Presentation Variables for Use in Reports and Dashboard Prompts.
• Create customizations in Informatica, Data Warehouse, RPD and in Dashboards
• Created Reports and Dashboards based on User specifications.
• Created Charts, Pivot Table, Tables, Filters and Prompts in Dashboard Reports.
• Experience working on some Volcker reports based on Volcker rules.
• Working on implementing data level and object level security based on the requirements.
• Helped refine and determine feasibility, correctness, and completeness of end-user’s requirements.
• Developed custom reports/Ad-hoc queries using Oracle BI Answers and assigned them to application specific dashboards.
• Prepared and/or review monthly, quarterly and annual corporate and legal entity data (financial statements, board report data, management reporting packages, investor presentations.
• Took ownership of the month end close process (where assigned) by reviewing and resolving any exceptions to general ledger identified through financial analysis.
• Developed and implemented process enhancements for efficient and effective work flow.
• Created Summery level Dashboards which gives a high level understanding of data based on the requirements.
• Performed unit and integration testing of reports and dashboards.

Environment: OBIEE 11.1.1.7, DB2, Autosys, Informatica 9.0.1, Unix, Micorsoft Excel, Frame

Confidential, Wayne, PA

Affiliated Distributors

OBIEE Lead

Responsibilities:

• Gathered Report Requirement and Specification from the Business.
• Experience in understanding Financial analytics reports and build any new reports on top of the existing model
• Tweaking the existing financial analytics reports in order to meet the business requirements
• Working knowledge on fit gap analysis for any new custom reports of Financial Analytics model in order to avoid redundant design & measures
• Performed Unit testing on the Data and customized the ETL & OBIEE to cater to the Clients Business operations.
• Designed their custom reporting structure with few new Star schemas for their custom Datawarehouse.
• Created new Informatica Mappings, Workflows, DAC Tasks, Subject Areas and Execution plans to load the custom warehouse.
• Designed Data Models and Metadata Repository (.rpd) with multiple business layers using complex joins
• Created Initialization Blocks, Session Variables and Presentation Variables for Use in Reports and Dashboard Prompts.
• Create customizations in Informatica, Data Warehouse, RPD and in Dashboards
• Created Reports and Dashboards based on User specifications.
• Created Charts, Pivot Table, Tables, Filters and Prompts in Dashboard Reports.
• Involved in designing multiple hierarchies and Time series measures
• Improved Performance by creating materialized views
• Created Agents to run dashboards every day
• Worked on merging the repositories
• Building complex adhoc queries
• OBIEE Report Development and Architecture Skills

Environment: OBIEE 11.1.1.7, Oracle 11g, DAC, Informatica 9.0.1, Unix, Oracle Applications (EBS) R12/R11

Confidential, Fremont, CA

OBIEE Lead

Responsibilities:

• Gathered Report Requirement and Specification from the Finance Department.
• Worked as a Financial Analytics analyst in order to tweak existing reports as per the business requirements
• Gathered requirements for any new custom reports in order to create new reports on top of the OBIA application
• Documented a Business Requirement Document with the Input from the Business Users.
• Performed Unit testing on the Data and customized the ETL & OBIEE to cater to the Clients Business operations.
• Designed their custom reporting structure with few new Star schemas for their custom Datawarehouse.
• Created new Informatica Mappings, Workflows, DAC Tasks, Subject Areas and Execution plans to load the custom warehouse.
• Designed Data Models and Metadata Repository (.rpd) with multiple business layers using complex joins
• Created Initialization Blocks, Session Variables and Presentation Variables for Use in Reports and Dashboard Prompts.
• Create customizations in Informatica, Data Warehouse, RPD and in Dashboards
• Created Reports and Dashboards based on User specifications.
• Created Charts, Pivot Table, Tables, Filters and Prompts in Dashboard Reports.
• Involved in designing multiple hierarchies and Time series measures
• Worked and implemented Oracle 11i Financial EBS. Supported Oracle Modules which includes, General Ledger, Fixed Asset, Accounts Payables and Receivables
• Expertise in implementing the data level security
• Improved Performance by creating materialized views
• Created Agents to run dashboards every day
• Worked on merging the repositories
• Building complex adhoc queries
• Involved in debugging Informatica mappings and fixing the source queries
• OBIEE Report Development and Architecture Skills
• Creation of complex SQL Queries from source system for BI Publisher reports
• Provide remedial measures to the production issues or process failure
• Proactively involved in getting the process into the project
• Mentoring fresh resources in the project.

Environment: OBIEE 11.1.1.6, OBIA 7.9.6.4, Oracle 11g, DAC, Informatica 9.0.1, Unix, Oracle Applications (EBS) R12/R11

Confidential, San Francisco, CA

Sr. OBIEE Developer

Responsibilities:

• Fine Tuned the Customized Workforce Profile Subject Area by editing the Custom Dimensions and Hierarchies at the Report, RPD & Database level.
• Met the Business and gathered all the custom requirements for Pipeline and few more subject areas
• Customized the Business Analytic Warehouse by adding and modifying the Dimension and Fact Tables for the Custom requirement.
• Involved in designing Custom Star schemas
• Built New Reports and Dashboards using BI Answers apart from modifying the Vanilla Dashboards to analyze the Metrics using the custom Hierarchies.
• Documented every step across the SDLC and trained internal folks on Custom reports
• Worked with business to translate the business requirements into High level design, Detailed Level Design and Functional code
• Expertise in providing end-to-end business intelligence solution by configuring metadata & building Analytics Repository, dimensional modeling design, building business models, generating reports, and creating Interactive Business Intelligence Dashboards using Oracle Business Intelligence 10.x
• Use the best practices of business intelligence to meet project and company objectives
• Provided complex data structures, dashboards and ad hoc reporting
• Worked on production issues which need immediate resolution
• Caching the reports using ibots
• Creation of SQL queries from source system
• Import data, RPD development, hierarchies and in the BMM/logical layer
• Worked on resource management, invoicing data and other management activities
• Proactively involved in modifying the existing design model

Environment: OBIEE 10.1.3, Oracle 10g, DAC, Informatica, Windows, Siebel Sales 7.x, Oracle

Applications (EBS) R12/R11

Confidential, Irvine, CA

OBI Developer

Responsibilities:

• Worked with business to translate the business requirements into High level design, Detailed Level Design and Functional code
• Worked with SQL Server SSIS Packages
• Worked on monitoring the services of Siebel Services
• Worked on automation of Score card report data
• Fixing the production data issues
• Customized and developed the OBIEE Business Model and Mapping layer.
• Implemented logical column measures and calculations with well expertise in the Business Model and Mapping layer.
• Creation/ Modification of existing and new reports in Siebel Analytics
• Created, modified and formatted requests, along with charts and filters, in OBIEE Answers
• Developed various kinds of reports in various views (Pivot Table, Chart, Tabular, narrative, View Selector, etc.) for better user readability
• Created various user groups and assigned them appropriate permissions and privileges.
• Developed various Ad Hoc reports for business
• User training on the newly developed reports
• Worked with offshore team for on time deliverables
• Worked on data cleansing
• Worked on resource management, invoicing data and other management activities

Environment: Siebel CRM Sales 7.7, Siebel Analytics 7, SQL Server, Windows

Confidential

Module Lead

Responsibilities:

• Worked on EIM jobs for data manipulation
• Testing the developed EIM jobs
• Training new resources in the team technically
• Planning and delegation of the tasks to the offshore
• Worked on designing the solutions and responsible for the deliverables
• Interacting with business for requirement gathering
• Worked on the requirements for High level design, Detailed Level Design docs, Functional code

Environment: Siebel Sales 7.7.2, Oracle 9.2.0.6, EIM, Windows

Confidential

Developer

Responsibilities:

• Worked on the design documents for the development of requirements
• Worked on testing the requirements in order to deliver defect free artifacts
• Working with Oracle queries for support issues
• Creation of adhoc extracts for the users on need basis
• Coordination with business for support issues
• Actively worked on fixing Production issues
• Creation of EIM jobs as per the requirement
• Monitoring the services
• Coordination with onsite to understand the requirements

Environment: Siebel 6.0, EIM, Oracle, Windows

Confidential

Developer

Responsibilities:

• Worked on coding the requirements
• Develop test plans for the requirements
• Involved extensively in Testing: System Testing, Accessibility and Integration Testing
• Documenting the testing results and defect prevention technique
• Worked on Research & Analysis for couple of requirements
• Performed Backend testing by executing SQL commands.
• Interacting with the developers in resolving the defects.

Environment: XCode 2.2.1, Web Objects Builder 5.3.1, Java

Confidential

QA Tester

Responsibilities:

• Worked on Testing: Unit, Integration, Regression
• Documenting the testing results and defect prevention technique
• Developed and Updated Test Cases and Test Scripts based on business requirements
• Involved extensively in Testing: System Testing, Accessibility and Integration Testing
• Analyzing the results after executing Test Scripts.
• Detecting defects and classifying them based on the severity.
• Performed Integration, Cross browser and System testing

Environment: XCode 2.2.1, Web Objects Builder 5.3.1, Java, IOS