PROFESSIONAL SUMMARY

• Over 8 years of work experience in the IT, acquiring both technical and functional skills

• 4+ years experience in implementing OBIEE, Informatica for reporting, ETL, Data warehouse
• Experience in development and implementation of OBIEE 11.1.1.6.7 , 11.1.1.3 and 10.1.3.4 Technical Developer with expertise in OBIEE Admin Tool, Analytics Web, Presentation Services, Security setup
• Experience in configuring and customizing the reports of Procure and Spend, Revenue Financial Analytics in OBIA 7.9.6.4
• Experience in OBIEE Design, Development and Production support Including Business modeling, Requirements gathering, Development, Configuration, Testing and Deployment for Oracle BI Enterprise
• Experienced in using oracle BI administration tool to design and develop application metadata for three layers (presentation layer, business model and mapping (BMM) layer and physical layer)
• Actively involved in performance tuning by setting cache management, clustering (vertical), lookup tables, connection pool management, session and other properties accordingly
• Experience in Security Setup at both Object and Data levels, which involved creation of users/groups, LDAP authentication
• Experience in Merging Repositories and experience in setup and configuration of Multiuser Development Environment (MUDE) and using merge utility to facilitate the development of application metadata in enterprise scale deployment
• Expertise in complete lifecycle Implementation of Business Intelligence with Star and Snow flake Schemas
• Expertise in Report Bursting using BI Publisher
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate wide ETL Solution
• Extensively Developed Informatica Complex Mappings
• Experience in developing, testing and implementing Triggers, stored procedures and functions using PL/SQL
• Experienced in development, database maintenance, enhancement and production and batch support environments for applications involving Mainframe technologies as COBOL, JCL, DB2, VSAM
• Working experience in developing applications with Object Oriented Programming concepts
• Knowledge of extracting the data from Essbase cubes

TECHNICAL SKILLS

• OBIA 7.9.6.4,DAC 11g

• BI Reporting Tools: OBIEE 11.1.1.5,11.1.1.6, 11.1.1.6.7 , 10.1.3.3/10.1.3.4 , BI Publisher, Hyperion 11.x Interactive Reporting
• Databases: Oracle 11g/10g/9i, Microsoft SQL Server, DB2,XML and Flat files
• DB Analysis Tools: SQL* Plus, SQL Developer, TOAD
• Languages: PL/SQL, C, C++, SQL,T SQL, COBOL,JCL,VSAM, CICS
• Operating Systems: Windows All versions
• ETL TOOLS: OWB 11g ,Informatica Power Center 9.1/8.6.0/8.5.1/8.1/7.1.1
• Methodologies: SDLC (Software Development Life Cycle), Agile Methodologies

PROJECTS

Confidential,Massachusetts

Senior OBIEE/ETL Consultant

Responsibilities

• Worked closely with Business to gather Analytics requirements to develop KPI Dashboards using OBIEE 11.1.1.6.7

• Involved in the Migration of OBIA modules such as Procurement and spend, Fiancials,HR modules to Production
• Actively involved in Post Production Support of all the OBIA modules
• Customized oracle out of the box Financial analytics and Procure and spend dashboards from oracle out of the box
• Modified the Procure and Spend SDE Mappings in order to customize the data flow as per the user requirements
• Developed the scripts of Procure and Spend reports to test the data after full and incremental loads
• Scheduled the Daily and Incremental load in DAC in production environment
• Monitoring and supporting the daily incremental load in production
• Customizing and cleaning up the RPD from the oracle out of the box according IDC standards
• Customized the permission setup on Subject areas in RPD and in Catalog Manger
• Resolved security issues related to Agents, Briefing Books and Dash boards
• Set up the Usage Tracking in RPD and created various reports for Usage tracking as per the Oracle standards
• Implemented MUDE functionality in the project to enhance parallel usage of the RPD
• Designed and customized home grown Revenue data mart using OWB 11g
• Involved in the fit gap analysis for moving the Revenue Analytics project to OBIA
• Developed revenue pre stg table according to OBIA standards to move home grown revenue data mart to revenue OBI Analytics
• Running and supporting the OWB revenue loads on a monthly basis

Confidential, Massachusetts

Senior OBIEE Consultant

Responsibilities

• Participated in the design, development, deployment and production support of reporting solutions that meet requirements of business users. This includes documenting the processes to ensure standards and compliance.

• Developed PL/SQL scripts for complex business logics like to calculate measures inward, outward premiums, claim payments and reserves.
• Designed dashboards/reports to track Forecast, Goals, Claim Bookings, Discount %, No of Claims, No of Customers per Theater, No of Policies Renewed.
• Experience in working on Sales Bookings, Forecast, Theater (Geographical View), and Product, Solutions, Customer, and Opportunity data.
• Working on OBIEE 11G Sandbox versions to migrate reports from 10g to 11g.
• Created Dimensional Hierarchies for Drill Down, Level Based Measures and Created Aggregated Tables to improve the Performance of the Reports.
• Gathered requirements to implement OBIEE Security (Object Level and Data Level Security in the OBIEE Repository and Answers) using Repository Variables, Session Variables.
• Created Global Prompts, Charts, Pivot Tables, Compound layouts to design the dashboards.
• Created different Time series reports (using Month ago,To date) to develop more enhanced reports.
• Worked on BI Publisher importing data from the data source and delivered Reports, common dashboards, metadata, security, calculation, caching, and intelligent request generation services.
• Performed Unit testing, integration testing to verify the report functionality and debugged dashboard reports to verify data matches as expected.
• Conducted workshops to increase adoption of the dashboards that help users to use reports than Ad hoc data.
• Conducted User training for several dashboard/ Reports to help them improve metrics that help them drive critical decisions.

Confidential, Maryland

OBIEE Consultant

Responsibilities

• Performed gap analysis and feasibility study for the given requirement.

• Created mockup reports and dashboards for review by the business users.
• Customized the OBIEE Repository (physical, BMM, and presentation layers).
• Created connection pools, imported physical tables and defined joins in the physical layer of the repository.
• Created dimension hierarchies, aggregates, and keys in the BMM layer.
• Modified Presentation Layer to add presentation tables and columns to meet the business user needs.
• Worked on repository and session variables.
• Modified Presentation Layer to add presentation tables and columns to meet the business user needs.
• Created materialized views and aggregates to improve performance.
• Created different Time series reports (using Month ago, To date) to develop more enhanced reports.
• Setup Usage tracking option to monitor frequently run reports in order to provide caching for the reports and perform database optimization by analyzing query performance.
• Performed Data Validation of data in the reports and dashboards.
• Performed Unit testing, integration testing to verify the report functionality and debugged dashboard reports to verify data matches as expected.
• Worked extensively with BI Publisher 11g.
• Created Data Models and RTF Templates for various reports.
• Unit, integration and system testing for all components in OBIEE. Test cases have been prepared and documented the results.
• Documented the design for intuitive understanding and future reference.
• Performed production support for the project.

Confidential, Boston,Massachusets

OBIEE/ETL Developer

Responsibilities

• Worked during the whole life cycle of the project from requirements gathering to deployment.

• Analyzed the data and developed Logical Star Schema model with consultation from Data Modelers and Business Analysts.
• Created new logical columns, dimensional hierarchy, calculated measures, and aggregate
• Developed Time Series Objects using Ago and ToDate functions for time series comparisons.
• Created security settings in OBIEE Administration Tool and set up groups, access privileges and query privileges and also managed security for groups in Answers.
• Designed and developed various Interactive Dashboards and reports with drilldowns, guided navigation, filters, and prompts.
• Used various cache management techniques for performance tuning including configuring, defining cache parameters, cache persistence time, cache seeding and purging, and event polling.

Confidential, USA

ETL Developer

Responsibilities

• Understood the Business requirement documents for an ETL design and source to target specifications

• Design and develop Informatica Mappings and Sessions based on user requirements and business rules to load data from source flat files and RDBMS tables to target tables
• Used transformations like Connected and Unconnected Lookups, Aggregator, Expression, Joiner, Update, Router and Sequence generator
• Created reusable transformations and mapplets and used them in complex mappings
• Involved in unit testing by debugger tool and analyze the bottlenecks for better load performance the ETL processes
• Developed and scheduled Workflows using task developer, worklet designer and workflow designer in Workflow manager and monitored the results in Workflow monitor
• Applied CDC logic to load incremental data from source to Data warehouse (EDW)
• Performed unit testing and Involved in tuning the Session and Workflows for better performance
• Deployed ETL mappings from development to multiple environments.
• Participated in Team Meetings, knowledge transfer and change Management process

Confidential, Hartford, USA

ETL Developer

Development/Maintenance Responsibilities

• Involved along with the Business analysts in requirements gathering and building specifications documents, in accordance with Insurance business rules

• Extensive research into Legacy systems to find data anomalies and report it to the source systems
• Co ordinate with the source system personal to achieve the requirements of GCS
• Extracted data from various Legacy systems like Genius, WINS and Phoenix systems, transform the data according to the business logic and load the transformed data into relational targets
• Worked on complete SDLC from Extraction, Transformation and Loading of data using Informatica
• With extensive knowledge of Insurance business, developed Source to Target Mappings using Informatica Power Center 8.6.1.
• Extensively used Transformations like Router Transformation, Filter Transformation, Aggregator Transformation, Normalizer Transformation, Source Qualifier Transformation, Union Transformation, Joiner Transformation, Lookup Transformation, Expression Transformation, Stored Procedure Transformation and Sequence generator Transformations
• Extensively used the Informatica Debugger for debugging the Mappings associated with data failures or failed Sessions
• Created and managed daily, weekly and monthly data operations, workflows and scheduling processes
• Actively participated in the client meetings and suggested solutions for critical tasks
• Involved in enhancement, maintenance, and documentation support for ETL program using Informatica

Environment

Informatica Power Center 8.1.6, SQL Server 2008, SSIS, Autosys

Confidential, Chennai,India

Mainframe Systems Analyst

Responsibilities

• Arranging the joint discussion sessions for requirements gathering and reviewing the inputs given by users & clarify any queries with the end user

• Preparation of the requirements document and technical design document for the enhancements
• Modify and enhance the existing programs for different line of business as per the requirements detailed in the technical design document within the given time lines
• Involvement in production support activities such as monitoring the daily batch cycle, fixing the abends, resolving critical or high priority call tickets within stipulated SLA i.e. 24hrs
• Participation in daily meetings with the client to discuss and update about the batch abends and to update the status on the Call tickets
• Scheduling the batch jobs based the new user requirements
• Update the clients about the progress on the changes in the programs during daily meetings

Confidential, Chennai,India

System Analyst/Mainframe Developer

Responsibilities

• Analyzed the current system and understood the as is process and documenting the same

• Understanding the requirement for developing of a new Batch process to Compute and Store the QualityGuard+Plus Dealer Dividend Trend Information) for QualityGuard+Plus contracts in the host database
• Developed a new pop up screen from the VESR DDTR option to display the QG+Plus DDTR information for NISSAN and INFINITI dealers
• Enhancement of VSC Host system to process any QG+Plus dealer dividend bonus program Chargeback's for Nissan and Infiniti dealers during the 1st and 2nd half dealer dividend program close
• Review the inputs given by NNA & clarify any queries with the onsite team
• Work on the changes as per the requirements after interaction with the clients to understand the requirement specifications
• Preparation of understanding documents with the knowledge gained by analysis of the systems
• Monitoring and adhering to the pre defined Quality norms and procedures