Professional summary

• Over 12 years of IT experience with an emphasis on Oracle Business Intelligence and Data warehousing solutions and partly in Oracle Applications.
• Experience in Dimensional Data Modeling, Software analysis, Design, Development and Testing for Data Warehousing solutions.
• Extensively worked on New Data Procurement, which includes converting Functional to Technical specifications HLD to LLD Documents involving Data Analysis, Creating Scoping and Assessment Documents, ETL Design Documents, Mapping Documents and Run books.
• Experience in developing ETL solutions using Informatica Power Center 7.1, 9.0.1 using Oracle 9i/10g RDBMS.
• Very proficient in suite of oracle tools including Oracle Warehouse Builder OWB 9i/10g/11g, Oracle Data Integrator 11g, OBIEE 10g/11g, Discoverer 4i/9i/10g, SQL, PL/SQL, SQL Loader, Export/Import and other tools like SQL Navigator, Toad, SQL Developer.
• Hands on working experience in performance tuning of the SQL queries database tuning. Hands on experience with the Explain Plans and TKPROF.
• Extensive experience in dealing with high volumes of data, partitioning, materialized views and tuning the code units to meet the performance requirements.
• Implemented Oracle data pump feature in Oracle 10g as a part of the custom data warehouse solution which is much more efficient than normal Export/Import.
• Extensive experience in writing queries, stored procedures, functions, packages triggers using SQL and PL/SQL and also new features in Oracle 9i and higher like External Tables on files, Table Functions, Merge Upsert data.
• Implemented partitioning and partition exchanging loading PEL to load the data into Oracle table partitions.
• Developing discoverer reports Oracle Discoverer 4i/9i/10g , Siebel Dashboards Now a part of OBIEE over Oracle Application modules and custom data warehouse applications.
• Usage of Analytic functions, Grouping Sets etc to create complex SQL queries to retrieve data for the reports.
• Experienced in core architecture of Oracle Applications and using the different responsibilities for defining users, menus, responsibilities, Request Groups and maintaining concurrent programs.
• Expertise in system requirement study, system analysis, technical design development, test plans preparation, unit testing, system integration testing and documentation.
• Involved in all aspects of Software Development Life Cycle and Production troubleshooting, Software testing, Requirement Analysis, Design Documents, SDLC including Client Support.
• Having excellent problem identification and solving skills with experience in all aspects of commercial software development.
• Ability to quickly identify root causes of problems. Consider both the long and short-term impact of proposed solutions and develop workable solutions. Ability to manage Multiple project tasks with changing priorities and tight deadlines.
• Excellent communicator and quick learner with an ability to work independently as well as part of a team.
• Good communication skills and team player with analytical, problem solving, interpersonal skills.

IT EXPERIENCE

• Oct 2002 Dec 2005 IVY Comptech, Hyderabad, INDIA
• Jan 2006 Oct 2012 Material Software Systems, USA
• Oct 2012 Till Date Paramount Software, USA

Technical skills

Environment : SunSolaris, Red Hat Linux, Windows NT/2000/XP/7 Professional, SQL, Oracle PL/SQL, Knowledge of Core Java jdk 1.3 , Oracle 8i/9i/10g, OracleApplications For Discoverer Reporting Custom.pll .

Tools :

• Oracle Data Integrator ODI 10g/11g, Oracle Warehouse Builder OWB 9i/10g Release 1 2,
• Informatica 7.1, 9.0.1, Discoverer 4i/9i/10g, OBIEE 11g/10.1.3.4 Siebel Analytics Oracle Answers, Oracle Delivers, BI Publisher , Rational ClearCase, WinCVS,Rational ClearQuest, TOAD, SQL Plus, SQL Navigator, PL/SQL Developer, SQL Developer, Tivoli Scheduler, Cron Tab.

Professional experience

Confidential

Responsibilities: -

• Gathering, analyzing and interpreting functional specifications and user requirements.
• Providing leadership for ETL architecture and design.
• Developing system features, including ETL interfaces and job scheduling.
• Migrating and configuring ETL jobs in test and production environments.
• Developed data mapping documents that contain transformation rules to implement the business logic.
• Developed various Mappings that perform Extraction, Transformation and Loading of Source data into the OLAP Schema, and used different Transformations like Source Qualifier, Expression, Lookup, Update Strategy, Aggregator, Stored Procedure, Filter, Router, Joiner, and XML.
• Extensively worked with DBA's for SQL tuning and fine-tuning existing Informatica mappings for Performance Optimization.
• Used power center workflow manager for session management, database connection management and scheduling of jobs to be run.
• Prepared DAC jobs for scheduling daily batch.
• Involved in ETL code optimization, performance enhancements and code reviews.
• Coordinate with QA team and the Informatica development groups to support end-to-end testing in term of new release code from development to production.
• Involved in designing and developing the RPD in OBIEE at all the levels of physical, business and presentation models.
• Developed reports in Oracle Answers 10g, 11g over the existing data warehouse.
• Using the Time Series Wizards in OBIEE to develop the reports based on comparison of different time periods.
• Developed several reports and dashboards using Oracle Business Intelligence tools OBIEE for different Key Performance Indicators KPI's and metrics.

Confidential

Responsibilities: -

• Analysis of source system, Design, Develop and Implementation of new data marts in the warehouse.
• Understanding Maintenance of the existing functionality of the warehouse.
• OWB upgrade and patching from Release 1 to Release 2 10.1.0.4 to 10.2.0.3 and 10g to 11g upgrading.
• Implemented POC's in OWB 11g for upgrading from OWB 10g Release 2.
• Develop and schedule ETL Process Flow's using OWB 10g, 11g for all the functional areas from source systems to staging and staging to the data marts.
• Deploy Process Flows to the workflow manger. Monitored the process flows using Oracle Workflow monitor.
• Monitoring the Audit details using Repository Browser and scheduled purging the audit data frequently.

Environment:

OWB 10g / 11g, Informatica 9.0.1, ODI 11g, Discoverer 10g, DAC 10g, Oracle Applications R12, OBIEE 10g.

Confidential

Responsibilities: -

• Understand the client requirements and design the technical specifications.
• Provide suitable project flow enhancements based on requirements.
• Designing facts and dimensions based on the specifications.
• Developing OWB mappings for loading facts and dimensions.
• Implementation of SCD Type 2 dimensions using OWB mappings.
• Creating process flows for OWB mappings.
• Creating materialized views for increased performance while providing data to OBIEE reports.
• Creating schedules to automate the OWB processes.
• Involved in migrating the repository from development environment to QA and to Production.
• Managing complex process flows, providing multi-level status periodical write-ups summarizing:
• Scope evolution.
• Project state from a development perspective.
• Milestone management.
• Signoff coordination.
• Coordinate with fellow process architecture team members to produce master project status as well as periodical reports drawn from individual reports prepared .

Environment:

CURAM 5.1 / 6, OWB 11gR2, OBIEE 10.1.3.4, Erwin, Oracle 10g.

Confidential

Responsibilities

• Analysis of source system, Design, Develop and Implementation of new data marts in the warehouse.
• Understanding Maintenance of the existing functionality of the warehouse.
• OWB upgrade and patching from Release 1 to Release 2 10.1.0.4 to 10.2.0.3
• Implemented POC's in OWB 11g for upgrading from OWB Release 2.
• Developed complex views involving Analytic Functions, grouping sets etc based on requirements.
• Involved in designing and developing the RPD in OBIEE at all the levels of physical, business and presentation models.
• Developed reports in Oracle Answers 10g over the existing data warehouse.
• Using the Time Series Wizards in OBIEE to develop the reports based on comparison of different time periods.
• Developed several reports and dashboards using Oracle Business Intelligence tools OBIEE for different Key Performance Indicators KPI's and metrics.
• Configured iBots in Oracle Delivers to manage the schedules, dependencies and notifications etc.
• Developing new discoverer End User Layer EUL , discoverer 10g reports using discoverer plus and viewer.
• Developed Materialized Views to replicate the data from distinct sources and improve the performance.
• Usages of Hints to change the query execution plan and improve the performance.
• Performance tuning of the Oracle SQL queries and database tuning.
• Developed and scheduled ETL mappings and process flows using OWB 10g Release 2 for all the functional areas from source systems to staging and staging to the data marts.
• Developed Process Flows using OWB and deployed to the workflow manger. Monitored the process flows using Oracle Workflow monitor.
• Monitoring the Audit details using Repository Browser and scheduled purging the audit data frequently.

Environment:

Oracle 10g, SQL, PL/SQL, Oracle Warehouse Builder 10g Release 2 10.2.0.3 11g 11.1.0.6 , ETL, Materialized Views, OBIEE 10g 10.1.3.4 - dashboards, BI Publisher, Oracle Answers, Oracle DB Scheduler, Oracle Workflow Manager, Oracle Discoverer 10g Administrator, Oracle 10g Discoverer Plus Reports, Windows XP Professional.

Confidential

Responsibilities:

• Analyze the client requirements and create the technical specifications.
• Assessed top-down versus bottom-up approach based on the requirements and situation decided to go ahead with the top-down approach.
• Participate in data warehouse architecture design the different components of the DWH and process of loading the DWH from different sources.
• Optimized the loading process by implementing an incremental loading process using the change data capture of oracle source system and merge feature in the oracle target system
• Involved in discussion and decision making to identify the attributes required to trigger history for slow changing dimensions, designed and implemented type 2 slow changing dimensions.
• Designed a robust model to maintain version of balances to be able to report balances before and after each recast/ adjustments.
• Analyzed source Oracle GL data and designed mappings from the base GL tables to the attributes of DWH.
• Designed cubes in Oracle Analytic workspaces with value-based ragged hierarchies.
• Responsible for developing code according to the technical design of the solution when ETL is required.
• Work with the Tech Lead to manage the technical implementation of the solution.
• Support the operations teams when required.
• Develop, test and maintain all ETL maps /scripts and physical data models.
• Load data for testing throughout the project lifecycle.
• Plan and execute deployments across all environments.
• Resolving design/development issues and interacting with infrastructure support partners DBA, Sys Admins .
• Implemented custom transformation using PL/SQL packages for Data reconciliation.
• Extensively involved in testing by writing QA procedures for testing the target data against source data.

Environment:

Informatica Power Center 7.1, Source Analyzer, Data Warehousing Designer, Debugger, Mapping Designer, Mapplet Designer, Transformations , Oracle 10g/11g, Toad, Oracle Discoverer 10g plus, Oracle Discoverer Viewer, SQL, PLSQL.