SUMMARY:

• Am an accomplished Software Consultant with over 10 years of experience in the Software services industry, specializing in the design and implementation of Database and Data warehouse solutions with adequate experience and thorough understanding of the Software Development Life Cycle (SDLC) processes, involved in various phases like requirements, software prototyping, analysis & design, development, integration, testing, maintenance and enhancement.
• Successfully lead complex projects with global implementation, and rapidly evolving requirements.
• Effective communication skills and record for coordination between globally located teams.
• Project delivery under stringent timelines and high pressure.
• Adept in providing Analytical Support to key business Applications /solutions
• Excellent verbal and written skills, especially with regards to presenting findings to both technical and non - technical audiences
• Thorough Understanding of Software Development Life Cycle (SDLC), involved in various phases like Requirements, Analysis/Design, Development and Testing.
• Rich experience in translating Business requirements to understandable IT systems requirements’
• Extensive experience with analysis, design, development, customizations and implementation of software applications including Business Intelligence Applications.
• Proficient in analyzing and translating business requirements to technical requirements and architecture.
• Strong BI skills, OBIEE, ODI, SAP BO, Oracle Database and development knowledge
• Experience in leading and managing teams. Handled multiple roles - Project Lead, Developer, and System Admin.
• Excellent proficiency in developing Reports / Dashboards with different Analytics Views (Drill-down / Dynamics, Cascading style sheets, Pivot table, Chart, Column Sector, Tabular with Local and global filters) using OBIEE
• Ability to be flexible, proactively manage workload, meet aggressive deadlines, organize and prioritize work.
• Proficient in debugging, identifying bugs before release to production, documenting them, and Maintaining fixes across releases.
• Strong debugging and problem solving skills with excellent understanding of system development methodologies, techniques and tools
• Effective communication skills, interpersonal skills, self-motivated, quick learner, team player.
• Excellent in interacting with customers, provide support, coordinate follow up and updates, ensures and exceeds customer satisfaction. Have always been the most trusted and approachable member in every team
• Maintain strict adherence to schedules, on time in delivering deliverables and gives more importance quality in over quantity and always been the most trusted and approachable member in every team.

TECHNICAL SKILLS:

Database: Oracle SQL (10g, 11g).

Development Tools: Oracle Business Intelligence (10G, 11G, 12C).

ETL Tools: Oracle Data Integrator 11G.

Office Tools: MS Word, MS PowerPoint, MS Excel.

Operating System: Working knowledge of Windows 9X, XP, 2000 Professional.

Others: UNIX, SAP BO 4.1

PROFESSIONAL EXPERIENCE:

Confidential

Sr. OBIEE Consultant

Responsibilities:

• Participate in functional design transition sessions with Onsite and played Techno-Functional Role between offshore and onsite team
• Gather the requirements from End User for new reports/enhancements.
• Work on OBIEE RPD development
• Lead efforts involving analysis, design, development, testing, documenting, implementation and support of new and existing business intelligence applications and solutions, using the OBIEE 11g/12c.
• Lead/participate in business intelligence application/architecture design and development reviews as appropriate to ensure working within appropriate technology/standards. Responsible for helping establish best practices, standards, and architectures working with co-development leads/Developers.
• Hands on Data analysis, Data modeling, Data Quality, ETL design, architecture, implementation and testing experience in DWBI Solutions.
• Create complex Reports, Dashboard development.
• Configuring data level security using various techniques.
• Excellent SQL skills with strong ability to debug and diagnose BI tool generated code.
• Performance Tuning and server optimization.
• Scrum/Agile Development Processes and ability to work in a high-paced agile Development environment.
• Assist in the change management process and adhere to the defined change management guidelines. Serve as a change management role model by adhering to process guidelines and standards.
• Communicate effectively, verbally and written, with manager, peers and business users.
• Contribute skills to affect team's success. Support other project teams and co-team members as appropriate. Participate in training for subject matter experts, technical and functional alike.
• Responsible for any issues created in Jira for Get data, My Team, Student Survey and Case OBIEE Reports.
• Work directly with business users as required to ensure support of business objectives. Responsible for full technical knowledge of all phases of projects, also having a good understanding of related business functions.

Environment: Oracle Business Intelligence 11G and 12C, Informatica, Oracle Data Integrator, Oracle (11g), Oracle APPS, Windows 2003, Windows 2007 and UNIX.

Confidential

BI Consultant

Responsibilities:

• Maintain and support the existing system, access issues, user add requests, Performance tuning, New user Add requests, Data Issues, Tickets raised by users etc.
• Work on things like: Cache Configuration, Deploying the solution to mobile, Map Configuration, Patch Upgrade activities.
• Delivering new and high quality solutions to clients in response to varying business requirements.
• Maintaining / building the OBIEE repository model for different subject areas, to suit ad-hoc end user requirements.
• Building BI Answer solutions, maintaining the existing ones.
• Outage resolution and performance stabilization. Taking/tracking weekly code backups.
• Client co-ordination - status call to finalize requirements / change-requests in the adhoc reporting layer.
• Prepare Business Requirements Document (BRD) and Functional Requirements Document (FSD) during the requirement phase.
• Preparing, reviewing and updating report detail design document - Tech Spec during the design phase.
• Analysis of defects and tracking the same for closure using the defect tracking tools like Service Now.
• Involving Productivity improvement and data modeling in relation to the customization done for a given business requirement. Will be involved in Performance enhancement of the software solution provided in the existing solutions.
• Migrating RPD between environments. Unit Testing, Integration testing etc.
• Provide workaround solutions to the reported problems and provide detailed analysis document for the reported issues/Problems and upload to shared location or portal for reference to support team.
• Responsible for Code deployment from DEV to Test and Test to Prod Environment Following business defined standards.
• Create and review the test scripts required for testing purposes
• Provide test results for all data modelling framework and individual reports and get client approval and prepare for client testing ( UAT - User Acceptance Testing)
• Provide workaround solutions to the reported problems and provide detailed analysis document for the reported issues/Problems and upload to shared location or portal for reference to support team.
• Provide RCA (Root Cause Analysis) on the reported issues so that real issues can be identified and fixed so as to minimize the repeat of same issue.
• Install, upgrade and configure database solutions through the OBIEE tools.
• Worked on migration of repository of OBIEE 11G to OBIEE 12 C and worked on fixed issues in hierarchies, variables, joins, reports, filters, dashboards, prompts, security setup.
• Worked on connecting with different data sources like Oracle DB, Teradata, Essbase cubes.
• Having development knowledge in Essbase cubes using hyperion Essbase.
• Expertise in building and configuring repository in design and development of the three layers (Physical/Business Model and Mapping/Presentation) of an OBI Metadata Repository (RPD’s) using Oracle BI Administration Tool.
• Expertise in Data Modeling for the decision support system to build star schema, snowflake schema, galaxy schema having facts and dimensions with conforming dimensions.
• Expertise on creating Dimensional Hierarchies, Level Based Measure, Time series Dimension, and aggregation levels in BMM layer
• Worked in creating and using Initialization blocks, Dynamic, Static, Repository, Session Variables, Presentation Variables and Prompts.
• Worked and Implemented on Event Pooling, write back, Migration, Action links, Master Detail etc.
• Prepare, enhance and configure meta data and data models using OBIEE
• Develop and design dashboards, reports, ad hoc queries and analysis
• Expertise on creating analysis, filters, dashboard and prompts with customer requirements.
• Create various reports to meet development requirements (pivot, chart, tabular, drill down, etc.) through global and local filters
• Configure the domain specifications and create repositories
• Create domain groups and add users in the group
• Migrated Repository and Web Catalog from one environment to another environment. Migration RPD from one environment to another environment and deploy RPD
• Understand the Confidential position/organization Hierarchy from Oracle Apps application and associate with BI groups and roles and based on these hierarchy created report for each group of people and implemented permission and privileges for Dashboard Report access.
• Scheduled Dashboards and Reports to Handheld devices using iBots.
• Report to the manager with proper documentation for every release.
• Expertise on Merging Repositories, Cache Management Techniques
• Worked on Administration activities like Starting stopping services, maintaining releases for every project and maintaining SVN, merging and migration of repositories
• Security implementation with client production LDAP system, implementation of horizontal and vertical clustering, http configuration, Usage Tracking, SSL
• Extensively worked on defining Flat File, Relational Source & Targets, Designing Transformations Logic, created different Interfaces for various sources using different Knowledge modules
• Created and worked on Interfaces, mappings, scenarios, packages,lookups Deployments etc.
• Created domain groups and add users in the group.
• Involved in unit testing, integration testing, and peer reviews of the interfaces, scenarios and packages generated by ODI.
• Effectively communicating to the QA team and timely updating the status for the defects and further working in code fix and deployments to push higher Environments.
• Participated in designing, coordination and execution of User Acceptance Testing.
• Report to the manager with proper documentation for every release.
• Worked on creating test tables, test data for execution of obiee query
• Worked on DDL, DML Statements such as select, insert, delete, and DDL like Create, Alter, Drop Truncate etc.
• Worked on joins and relationships for the tables.
• Tested the source and target queries and also checked the data set with OBIEE and Database
• Participated in designing, coordination and execution of User Acceptance Testing.

Environment: Oracle Business Intelligence 11G and 12C, Data Stage, Oracle Data Integrator, Oracle (11g), Teradata, Essbase Cubes, Windows 2003, Windows 2007 and UNIX.

Confidential

OBI Cloud Integration Specialist

Responsibilities:

• As onsite coordinator, work directly with client to understand the requirement and prepare the documentation and provide the solution following IBM standards and work smartly with offshore team to ensure the Delivery.
• Provide extensive support to all application administrative activities
• Schedule and meet the client as per the client partner’s availability and discuss on the requirements for the proposed reporting platform
• Document the minutes of meetings with Client and communicate on the progress and the discussed topics with the offshore team
• Help and support users in the issues they are facing and provide solutions for the issues.
• Ensure no services fails during business hours and provide extensive support to users during business hours
• Ensure timely delivery of all reports scheduled through scheduler and make sure no report fails
• Conduct tool specific trainings to users
• Prepare Business Requirements Document (BRD) and Functional Requirements Document (FSD) during the requirement phase.
• To attend technical as well as functional discussion with end client to understand requirements to enhance productivity and efficiency.
• To perform Internal Quality Assurance activities as per IBM processes
• Coordinate with offshore team to design, build and test the reports.
• Interacted with business representatives and business analysts for requirements analysis and to define business and functional specifications.
• Analyzed requirements and participated in the documentation such as Low level Design(LLD) High Level Design(HLD) documents for Business Requirements.
• Attended corporate training on Oracle Data Integrator 12C at IBM by Confidential and Microsoft Azure.
• Expertise in building and configuring repository in design and development of the three layers (Physical/Business Model and Mapping/Presentation) of an OBI Metadata Repository (RPD’s) using Oracle BI Administration Tool.
• Expertise in Data Modeling for the decision support system to build star schema, snowflake schema, galaxy schema having facts and dimensions with conforming dimensions.
• Expertise on creating Dimensional Hierarchies, Level Based Measure, Time series Dimension, and aggregation levels in BMM layer
• Worked in creating and using Initialization blocks, Dynamic, Static, Repository, Session Variables, Presentation Variables and Prompts.
• Worked and Implemented on Event Pooling, write back, Migration, Action links, Master Detail etc.
• Prepare, enhance and configure meta data and data models using OBIEE
• Develop and design dashboards, reports, ad hoc queries and analysis
• Expertise on creating analysis, filters, dashboard and prompts with customer requirements.
• Create various reports to meet development requirements (pivot, chart, tabular, drill down, etc.) through global and local filters
• Configure the domain specifications and create repositories
• Create domain groups and add users in the group
• Worked on Oracle MD-50,MD-70 and MD-120 documentation
• Worked QA/UAT support cycle to fix bugs in tight schedules
• Worked on Release deployment activities
• Effectively worked with Oracle Support to fix complex issues in application and resolved the same
• Worked in BI Publishers 11g for transactional reports development
• RPD and report development for Intraday, Daily and weekly Dashboard
• KPI and scorecard implementation
• Implementation of RPD and catalog migration process
• Involved in resolving incidents and CRs. Gathering Business User Requirements and estimate the CRs
• Worked on creating test tables, test data for execution of obiee query
• Worked on DDL, DML Statements such as select, insert, delete, and DDL like Create, Alter, Drop Truncate etc.
• Worked on joins and relationships for the tables.
• Tested the source and target queries and also checked the data set with OBIEE and Database
• Participated in designing, coordination and execution of User Acceptance Testing.

Environment: Oracle Business Intelligence 11G and 12C, Data Stage, Oracle Data Integrator, Oracle (11g), Teradata, Microsoft Azzure and UNIX.

Confidential

BI Consultant

Responsibilities:

• Participate in functional design transition sessions with Onsite and played Techno-Functional Role between offshore and onsite team
• Responsible to understand business needs application requirements
• Provide OBI (Oracle Business Intelligence) and Analytics solution to business which will help them to track the history of sales, and equips the team to use this data for mining and analytics to identify potential customers and sectors where they can improve their business.
• Migrated and recreated Discoverer reports to OBIEE Reports
• Coordinate with offshore team to design, build and test the reports
• Create and review the test scripts required for testing purposes
• Preparing, reviewing and updating report detail design document - Tech Spec during the design phase.
• Analysis of defects and tracking the same for closure using the defect tracking tools like Service Now.
• Involving Productivity improvement and data modeling in relation to the customization done for a given business requirement.
• Will be involved in Performance enhancement of the software solution provided in the existing solutions.
• . Migrating RPD between environments.

Environment: OBIEE 11G on UNIX, Oracle Database, Oracle Data Integrator & Discoverer.

Confidential

Team Lead

Responsibilities:

• Responsible for leading a project team in delivering solution to our customer in the Telecom sector.
• Deliver new and complex high quality solutions to clients in response to varying business requirements
• Responsible for managing scope, planning, tracking, change control, aspects of the project.
• Responsible for effective communication between the project team and the customer. Provide day to day direction to the project team and regular project status to the customer.
• Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results.
• Utilize in-depth knowledge of functional and Technical experience in OBIEE, Oracle Database and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customer.
• Establish Quality Procedure for the team and continuously monitor and audit to ensure team meets quality goals.
• Expertise in installation, configuration, migration and administration of OBIEE Platform in Windows and AIX Environment.
• Expertise on creating analysis, dashboard and prompts with customer requirements.
• Expertise in building and configuring repository, creating and managing Dashboards, Answers, iBots.
• Expertise in design and development of the three layers (Physical/Business Model and Mapping/Presentation) of an OBI Metadata Repository (RPD’s) using Oracle BI Administration Tool.
• Expertise in Security Setup at both Object Report and Dashboard levels, which involved creation of users/groups/roles etc.
• Expertise on Dimensional Hierarchies, Level Based Measure, Time series Dimension, and aggregation levels in BMM layer
• Worked in creating and using Initialization blocks, Dynamic, Static, Repository, Session Variables, Presentation Variables and Prompts.
• Migrated Repository and Web Catalog from one environment to another environment. Migration RPD from one environment to another environment and deploy RPD.
• Understand the CricKet Communication position/organization Hierarchy from Oracle Apps application and associate with BI groups and roles and based on these hierarchy created report for each group of people and implemented permission and privileges for Dashboard Report access.
• Scheduled Dashboards and Reports to Handheld devices using iBots.
• Expertise on Merging Repositories, Cache Management Techniques.
• Daily Onshore- Offshore communication
• Define OBIA architecture for DEV, UAT and Production Environments
• On premise Installation, technical and functional configuration for Financial and HR Analytics.
• Worked on OOTB dashboard data testing with source EBS
• Worked extensively on configurations of calendars, Exchange rate types, Group account numbers, segments etc. Also worked on data load parameters and reporting parameter configuration through Business Intelligence Application Configuration Manager

Environment: Oracle Business Intelligence 10G and 11G, Infomatica, DAC and SAP BODI, Database & Tools - Oracle (11g) Sql Developer & Toad, Windows 2003, Windows 2007 and UNIX.

Confidential

Sr.Software Developer

Responsibilities:

• Install, upgrade and configure database solutions through the OBIEE tools
• Worked on migration of repository of OBIEE 10G to OBIEE 11 G and worked on fixed issues in hierarchies, variables, joins, reports, filters, dashboards, prompts, security setup.
• Configure the domain specifications and create repositories
• Create domain groups and add users in the group
• Develop and design dashboards, reports, ad hoc queries and analysis
• Work on data with physical, presentation and business layers
• Worked and Implemented on most advanced topics like write back, Migration, Action links, Master Detail etc.
• Prepare, enhance and configure meta data and data models using OBIEE
• Involving in development reports using Advanced OBIEE
• Create various reports to meet development requirements (pivot, chart, tabular, drill down, etc.) through global and local filters
• Report to the manager with proper documentation for every release.
• Scheduled Dashboards and Reports to Handheld devices using iBots.
• Expertise on Merging Repositories, Cache Management Techniques.
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to the OBIEE Repository.

Environment: OBIEE 10G, 11G, ODI, Oracle Database 11G, and UNIX

Confidential

OBIEE Developer

Responsibilities:

• Understanding the requirements of the client, business scenario(s) and the application whenever the Incident of Defect been raised.
• Working on Critical Defects and giving solutions in very less number of time
• Assigning the defects and updating the proper status in client tools
• Code review and giving solutions in particular defects/Incidents will be taken care by me
• Attending the calls in the call whenever the P1/P2/P3 Incident/Critical defect been raised
• Worked on rebuilding broken reports, prompts after migration.
• Validated the calculations in the reports where ever needed.
• Provided 24*7 Support to maintain strict adherence to schedules, on time in delivering deliverables and gives more importance quality over quantity
• Work with the Business Analyst in translating business requirements into Functional Requirements Document and to Detailed Design Documents.
• Expertise in planning, architecting and migration of OBIEE10g to OBIEE11g for this project.
• Expertise in Security Implementation in OBIEE11g.
• Expertise in GeoSpatial Configuration with OBIEE11g.
• Worked on most of the OBIEE 10g/11g platform development and production support.
• Worked on the RPD development and enhancement.
• Worked on the Reports, Prompts, Dashboard development and enhancement.
• Worked on the performance tuning of the existing reports to make the reports run faster.
• Expertise in Data Modeling for the Decision Support System to build star schema having facts and dimensions with conforming dimensions.
• Created ODI design documents from the existing Informatica mappings. Used these design documents in development of ODI interfaces/packages.
• Worked extensively with ODI Designer, operator and metadata Navigator.
• Good understanding of ODI architecture and installation of Topology, Security Manager, agents, Designer, Operator, Master repository and Work repository.
• Used Security Manager for managing privileges to the users.
• Participated in code reviews. Did code promotions from dev to test, staging and production environment using ODI.
• Wrote unit test cases, test scenarios, unit test documents and also verified the test scenarios of the QA team. Unit tested for all the possible test scenarios.
• Helped QA team in writing the appropriate test scenarios.
• Did error analysis for continued improvement of the system by catching data anomalies and code issues.
• Planning and prioritizing the tasks to meet the deliverable deadlines.
• Participated in all the phases of project - development, testing, deployment and support.
• Involved in release meetings and created release notes.
• Involved in rotational production support.

Environment: OBIEE 10G, 11G, ODI, Oracle Database 11G, AWM, OWB, OGG and UNIX