SUMMARY

• Over 10+ years’ of experience in full life cycle development gathering requirements, documentation, developing, designing, testing, implementing, and deploying BI Solutions and has professional experience with various industries such as Retails, Manufacturing, Pharmaceuticals, Mortgage & Finance, and Telecom.
• Worked extensively in Implementation of OBIEE and OBIEE Admin end to end.
• Good Knowledge on DAC
• About 7 years of experience working with Oracle Business Intelligence (OBIEE), OBIEE Admin, Analytics, EM, Web logic Console
• About 3 years of experience working with Micro strategy tools like Micro Strategy Desktop, Web, Intelligence Server, OLAP Services, Report Services, Command Manager, and Administration
• Working with Tableau Desktop and Tableau Servers and Admin
• Very good Knowledge in Oracle BI Apps like Financials, Procurement & Spend, Supply Chain,
• Working with ETL tools such as, Informatica (Power Mart/Power Center), Oracle Data Integrator, Data Stage
• Good working experience in using Teradata database systems OBIEE
• Good working experience in using HCM
• Good Knowledge on Hyperion Planning, Essbase Cubes and MDX Query language
• Working experience on Oracle BI Publisher
• Good Knowledge on Siebel Applications
• Good understanding of overall BI Architecture
• Good understanding of WLST and Incident Management
• Worked on Informatica Power Center Designer, Workflow Manager and Workflow Monitor
• Involved in designing of Informatica Mappings and Monitor the log files By using Workflow Monitor
• Good working experience in upgrading OBIEE environments from lower version to higher version.
• Good Knowledge on Installation and configuration of OBIEE.
• Experience in Oracle BI Metadata Repository (RPD) and Web Catalog deployment activities
• Ability to restart the services from putty as well as from web logic console and EM.
• Experience in creating users and giving privileges and adding custom skins to the landing pages.
• Good knowledge and experience in managing Security in OBIEE.
• Enabled usage tracking in OBIEE 11g which would help to track the applications usage.
• Strong SQL knowledge
• Design and development of various Reports / Dashboards that is dynamic and interactive with drill - down capabilities and local & global filters prompts column selectors and view selectors. Provision of Report navigation features.
• Developed many dashboards using different Analytics Views (Pivot Table Chart and Column Selector) Dynamic / Interactive Dashboards with drill-down capabilities charts tabular using global and local Filters
• Knowledge in configuring and publishing the Agents to deliver analytics content based on schedule automated
• Very strong experience in developing OBIEE Repository (.rpd) at three layers (Physical Layer, Business Model & Presentation Layer), Time Series Objects, Interactive Dashboards with drill-down capabilities using global & local Filters, Security Setup (groups, access / query/report privileges), configured Analytics Metadata objects (Subject Area, Table, Column), Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Good Knowledge in Data ware housing Architecture and Technologies
• Expertise in using Micro Strategy 9/8.x/7i/7.x product suites including MicroStrategy Desktop, Web, Architect, OLAP Services, Administrator, Intelligence Server, Narrowcast Server.
• Expertise in working on Direct Project Source (Two-Tier) and Server Project source (Three-Tier).
• Expertise in Creating Schema Objects (facts, attributes, Hierarchies, Transformations) to Develop User Objects.
• Expertise in Developing Application Objects (filters, prompts, metrics, Custom Groups, Consolidations, DrillMaps, Templates, Searches) to develop Documents and reports.
• Expertise in creating Hyper Links in Documents and Drill Reports.
• Expertise in using Administration tools like Object Manager and Command Manager.

TECHNICAL SKILLS

Business Intelligence: OBIEE 11.1.1.9.0 , Micro Strategy 9/8.1. (Micro Strategy Desktop, Web, Intelligence Server, OLAP Services, Report Services, Command Manager, Administration), Business Objects XIR2/6.5, Tableau SAS, HCM

ETL: Informatica PowerCenter Designer 7.x/ 6.x, Workflow manager and Monitor, ODI. Data Stage, Pentaho, OBIApps 10G/11G

Languages: SQL, PL/SQL, C, ASP.Net, JSP.Net, SDK, XML. Basic JavaDevelopment Tools Oracle Developer 2000 (Forms 6i & Reports), SQL*Plus, Erwin, SQL*Loader, TOAD

O/S: Windows XP/2000/NT/98, UNIX, Linux, MS-DOS

Database: Oracle 11.2, 10G, MS SQL Server 2000/2005, Netezza 5.0DB2, Teradata, Essbase, Hadoop

PROFESSIONAL EXPERIENCE

Confidential, NC

Sr. OBIEE Technical Architect/ Admin

Responsibilities:

• Directly coordinating with user to gather the requirements.
• Creating Users, Groups and assigning roles as per security requirements.
• Raising and tracking Service Requests with Oracle Corporation on OBIEE issues.
• Deploying RPD and Web Catalog.
• Deployed Custom images help links, View.css files and common.css files.
• Supports monthly schedule activities for moving the code from Dev. to stage and Production.
• Configured usage tracking which would help to track the applications usage.
• Analyzing the specifications provided by the Business user.
• Understanding Business Data.
• Coordinate ETL team for the Production data issue and mapping failures.
• Involved in Control-M Changes for the job insertion and monitor the workflows.
• Developed RPD creation by including all the functional requirements.
• Inserting new Users and modifying the existing Users access by using the LDAP authentication.
• Creating hierarchies in business model.
• Designed different views view Selector, Legend, MAP viewer
• Working extensively in Answers and Dashboards.
• Experience on Discoverer Reports and dashboard development
• Created the requests and view the results in different views like table, compound layout, chart and pivot table.
• Developing different brand level reports, filters, and prompts by using web.
• Performing the Unit and Integration testing.
• Experience with Table partitioning and compression, materialized Views, Parallel Queries
• Created Initializations Blocks and variables to implement Security at RPD level.
• Worked on 24/7 support during the quarter close.
• Worked on Fragmentation at RPD level
• Complex SQL and PL/SQL with strong performance tuning capability
• Provide support in the implementation of OBIEE components
• Install, upgrade and configure all components of OBIEE
• Proficiency with Data Analysis tools with Analytical experience
• Design and implement data in various layers including physical, business and presentation
• Assist the teams in generating dashboards and reports properly
• Use the best practices of business intelligence to administer the analytical solutions
• Perform validation of data on the reports and monitor the performance status of the same
• Assist and administer the deployment process of UNIX, OBIEE and repository codes
• Prepare monthly reports and present it to the management
• Assess production faults and critical issues followed by identification of the root cause
• Provide remedial measures to the production issues or process failure
• Train the administration team on new OBIEE and ETL tools
• Converts business requirements and specifications into Tableau presentation and data layer application
• Designs and creates data views in SQL and influences decisions regarding infrastructure and back-end data solutions in order to enable evolving analytical needs.
• Designs and develops Teradata data structures based on reporting requirements.
• Utilizes presentation layer mock-up software to effectively visualize and demonstrate proposed user interface dashboard and scorecard solutions in order to gain buy-in on requirements.
• Actively participates in and influences discussions around reporting requirements, infrastructure needs, and design with matrix partners.
• Deep understanding of key business applications as primary sources of data for presentation and data layer application solutions.
• Increases organizational and personal capacity by mentoring and enabling team members to complete coding and testing assignments in coordination with on-shore delivery leads.
• Deploying Informatica jobs by using Control-M tool and Monitor the Job failures.

Environment: OBIEE 11.1.1.9.0 , Oracle11.2, EM, Web logic Console, Informatica, Control-M Changes, Windows NT

Confidential, NY

Sr. OBIEE Technical Architect

Responsibilities:

• Directly coordinating with user to gather the requirements.
• Creating Users, Groups and assigning roles as per security requirements.
• Raising and tracking Service Requests with Oracle Corporation on OBIEE issues.
• Deploying RPD and Web Catalog.
• Deployed Custom images help links, View.css files and common.css files.
• Supports monthly schedule activities for moving the code from Dev to stage and Production.
• Configured usage tracking which would help to track the applications usage.
• Analyzing the specifications provided by the Business user.
• Understanding Business Data.
• Coordinate ETL team for the Production data issue and mapping failures.
• Involved in Control-M Changes for the job insertion and monitor the workflows.
• Developed RPD creation by including all the functional requirements.
• Inserting new Users and modifying the existing Users access by using the LDAP authentication.
• Creating hierarchies in business model.
• Designed different views view Selector, Legend, MAP viewer
• Working extensively in Answers and Dashboards.
• Experience on Discoverer Reports and dashboard development
• Created the requests and view the results in different views like table, compound layout, chart and pivot table.
• Developing different brand level reports, filters, and prompts by using web.
• Performing the Unit and Integration testing.
• Experience with Table partitioning and compression, materialized Views, Parallel Queries
• Created Initializations Blocks and variables to implement Security at RPD level.
• Worked on 24/7 support during the quarter close.
• Worked on Fragmentation at RPD level
• Complex SQL and PL/SQL with strong performance tuning capability
• Provide support in the implementation of OBIEE components
• Install, upgrade and configure all components of OBIEE
• Proficiency with Data Analysis tools with Analytical experience
• Design and implement data in various layers including physical, business and presentation
• Assist the teams in generating dashboards and reports properly
• Use the best practices of business intelligence to administer the analytical solutions
• Perform validation of data on the reports and monitor the performance status of the same
• Assist and administer the deployment process of UNIX, OBIEE and repository codes
• Prepare monthly reports and present it to the management
• Assess production faults and critical issues followed by identification of the root cause
• Provide remedial measures to the production issues or process failure
• Train the administration team on new OBIEE and ETL tools
• Converts business requirements and specifications into Tableau presentation and data layer application
• Designs and creates data views in SQL and influences decisions regarding infrastructure and back-end data solutions in order to enable evolving analytical needs.
• Designs and develops Teradata data structures based on reporting requirements.
• Utilizes presentation layer mock-up software to effectively visualize and demonstrate proposed user interface dashboard and scorecard solutions in order to gain buy-in on requirements.
• Actively participates in and influences discussions around reporting requirements, infrastructure needs, and design with matrix partners.
• Deep understanding of key business applications as primary sources of data for presentation and data layer application solutions.
• Increases organizational and personal capacity by mentoring and enabling team members to complete coding and testing assignments in coordination with on-shore delivery leads.
• Deploying Informatica jobs by using Control-M tool and Monitor the Job failures.

Environment: OBIEE 11.1.1.9.0 , Oracle11.2, EM, Web logic Console, ODI, Control-M Changes, Unix, Tableau Desktop

Confidential

Sr. OBIEE Tech Lead/ Admin

Responsibilities:

• Directly coordinating with user to gather the requirements.
• Develop and implement strategies, policies and standards for OBIEE administration solutions in the enterprise
• Ensure that designing, recovery and implementation of an OBIEE suite is carried out effectively
• Perform testing sessions for reports and dashboards and resolve process issues (if any)
• Evaluate and set strategies to implement infrastructure and application changes in OBIEE system and processes
• Research and remain abreast with latest technologies and techniques to recommend new changes or up gradations
• Prepare documentation and communicate the status of the project to the management
• Perform other administrative duties related to OBIEE as and when assigned
• Creating Users, Groups and assigning roles as per security requirements.
• Deploying RPD and Web Catalog.
• Supports monthly schedule activities for moving the code from Dev to stage and Production.
• Analyzing the specifications provided by the Business user.
• Understanding Business Data.
• Developed RPD creation by including all the functional requirements.
• Inserting new Users and modifying the existing Users access by using the LDAP authentication.
• Creating hierarchies in business model.
• Worked extensively in Answers and Dashboards.
• Created the requests and view the results in different views like table, compound layout, chart and pivot table.
• Developing different brand level reports, filters, and prompts by using web.
• Performing the Unit and UAT testing.

Environment: OBIEE11.1.1.7, Teradata, Oracle11.2, EM, Web logic Console, Windows NT, Informatica, CA-7

Confidential, OH

Sr OBIEE Developer and Admin

Responsibilities:

• Directly coordinating with user to gather the requirements.
• Creating Users, Groups and assigning roles as per security requirements.
• Applying custom skins to the landing pages.
• Raising and tracking Service Requests with Oracle Corporation on OBIEE issues.
• Deploying RPD and Web Catalog.
• Deployed Custom images help links, View.css files and common.css files.
• Supports monthly schedule activities for moving the code from dev to stage and production.
• Configured usage tracking which would help to track the applications usage.
• Analyzing the specifications provided by the Business user.
• Understanding Business Data.
• Inserting new Users and modifying the existing users access by using the External table authentication.
• Creating hierarchies in business model.
• Working extensively in Answers and Dashboards.
• Created the requests and view the results in different views like table, compound layout, chart and pivot table.
• Developing different brand level reports, filters, and prompts by using web.
• Performing the Unit and Integration testing.
• Created Init Blocks and variables to implement Security at RPD level.
• Worked on 24/7 support during the quarter close.
• Worked on Fragmentation at RPD level.

Environment: OBIEE11.1.1.6, Oracle10G, EM, Web logic Console, Windows XP

Confidential, New Jersey

Sr. Microstrategy Developer

Responsibilities:

• Worked with client to gather requirements and prepared technical specifications Documents.
• Involved in design of proto type of reports based on requirements.
• Involved in Dimensional Data Modeling (Star Schema, Snow-Flake Schema) Data Architecture, Business and Data Analysis
• Actively involved in walkthroughs and meetings with Business team to discuss related issues and review of the Objects and reports..
• Involved in Creating Schema Objects (facts, attributes, hierarchies, Transformation) and application objects (filters, prompts, metrics, consolidations, custom groups, reports) needed to create the micro strategy objects necessary for the deliverable.
• Involved in Defining Logical Views to get data through queries from self-joined tables.
• Created Relation Ship tables to avoid Many-Many relationship between parent and child attributes.
• Involved in creation Aggregate tables to improve performance of reports
• Involved in moving the objects between two projects and two different environments by using Object Manager and merging the projects by using Project Merge Wizard.
• Involved in Developing Reports by using Free Form SQL Queries in micro Strategy Desktop.
• Create a test plan, perform unit test and send the test plan along with the files generated for QA.
• Training the users how to usemicro strategyfor their business analysis.

Environment: Microstrategy 8.1.1, Desktop Reports, Web Intelligence Reports, Oracle 10g, Windows 2000

Confidential, New Jersey

Microstrategy Developer

Responsibilities:

• Worked with client to gather requirements and prepared technical specifications Documents
• Involved in design of proto type of reports based on requirements.
• Involved in Dimensional Data Modeling (Star Schema, Snow-Flake Schema) Data Architecture, Business and Data Analysis
• Actively involved in walkthroughs and meetings with Business team to discuss related issues and review of the Objects and reports.
• Creating Schema Objects (facts, attributes, hierarchies, Transformations) and application objects (filters, prompts, metrics, reports) needed to create the Micro strategy objects necessary for the deliverable.
• Architected the projects and created all the necessary schema, application and configuration objects.
• Created transformational metrics (Sales, Sales Target, Market Share, and Growth) to compare monthly, quarterly and annual sales.
• Involved in creating Security filters to end users to access data Based on their privileges..
• Involved in Developing Reports by using Freeform SQL Queries in Micro Strategy Desktop
• Involved in migration of Schema Objects (facts, attributes, hierarchies, Transformations), Application Objects (filters, prompts, metrics, consolidation, custom groups), user groups from 8.0.2 to 8.1.1.
• Involved in optimization of code and tuning queries for performance.
• Provided post production support to end-users.

Environment: Micro strategy 8.0.2/8.1.1 , Desktop Reports, Web Intelligence Reports, UNIX, Toad, Excel, Oracl10g, Windows 2000.