SUMMARY:

• Senior Business Intelligence Architect with 12 years of experience in Oracle ERP implementation, Data Architecture, Data Modeling, Data Governance, Data Quality and Confidential with full development lifecycle project implementation.
• Extensively worked in development on ETL/ELT, Reporting, PLSQL and Unix for application development and enhancement activities.
• Managed project plans, scope, resources, change requests, risks and issues to ensure that maximum.
• Demonstrated ability to bridge the gap between IT, Business Users, & Managed team up - to 12 members.
• Proposed and presented project plans, status reports and cost/benefit studies and recommends funding and resources.
• Implemented Oracle ERP OBIA data warehouse project, using BIACM & BIAFSM for functional configurations, ELT (ODI) and OBIEE For Reporting.
• Intensive Report/Dashboard/Scorecard, development experience using OBIEE 11G and Oracle BI Application 11G with EBS Source and ODI/Informatica tool.
• Very Strong Knowledge in OBIEE Repository (.rpd) involving complex star and snowflake schema Confidential three Layer (Physical Layer, Business Model and Presentation layer).
• Experience in design, creation and customization of new Star and Snowflake schema (Fact/Dimension/Aggregate table)
• Experienced in working on ODI. Extensively worked in ELT Design, Development of Interface, procedure, package, data load plan and IKM.
• Experienced in leading Confidential (MDM) Projects for Customer and Supplier using Infomatica Data Quality tool.
• Knowledge in Informatica data quality (IDQ) Profiling, Standardization and Address Validation, Matching Consolidation, Mappings and Transformation.
• Experienced in using Informatica Power center 9.1 for ETL. Extensively worked in ETL Design, Development, code reviews and performance tuning of Informatica jobs.
• Knowledge on Oracle EBS R12 Application.
• Good Domain knowledge in Banking and Supply chain Management.
• Good knowledge of DB Estimation, DB Design, Partitioning and indexing strategies.
• Experienced in SQL/PLSQL and UNIX Shell Programming.
• Excellent knowledge in OLTP and Dimensional Data Modeling skills using Erwin 3x/ 7x in OLAP applications.
• Good knowledge of DB Estimation, DB Design, Partitioning and indexing strategies.
• Good knowledge of Oracle 9i/10g, DB2/UDB and SQL Server 2005.
• Basic Knowledge of DB Architecture, DB Administration and performance tuning.
• Six-Sigma certified professional with good Knowledge of Six Sigma / Lean quality standards.
• Good Knowledge of Agile and Critical Chain Project Management methodologies.
• Excellent Client interaction, Requirements gathering and presentation skills.

TECHNICAL EXPERIENCE:

BI Tools: OBIEE,OBIA, BusinessObjects

ETL Tools: ODI 11g and 12c,Terradata, Informatica and Informatica Data Quality

Modeling Tools: Erwin

Database Applications: Oracle 10g/9i, DB2/UDB SQL Server, Teradata and Vertica

Programming Languages: SQL, PL/SQL, Unix Shell Scripting

Other Tools: Oracle 11G,SQL, PL/SQL Developer, Maestro Scheduler, Oracle EBS forms, Crystal Report DAC and JIRA

PROFESSIONAL EXPERIENCE:

Confidential, California

Senior Lead/Specialist

Responsibilities:

• Design the solution for building the conformed dimension for Customer, Equipment and Product.
• Analyze the Source data from Hadoop, Teradata and Vertica and build design for developing conformed dimension .
• Develop complex btec/fast export script to extract data from different source .
• Develop Teradata script to Load huge volume of data to confirmed dimension and facts for building data lake .
• Build data lake using different source which can be referred and used as source from for new project and Data analyses.
• Developing customer required reports using OBIEE.

Confidential, California

Architect/Project Manager

Responsibilities:

• Design the solution based on the new requirement in OBIA12c
• Lead and participate in requirements gathering and functional design reviews.
• Performed techno functional role in OBIA Analytics for Supply Chain and Finance domain with EBS
• Responsible for rewriting code from Informatica to ODI for all the customization that exists in Informatica
• Installation, Setup and Implementation of OBIA 12c which includes OBIEE12c, ODI12c.
• Development and Customization of RPD, OBIEE Dashboards and Reports.
• Lead and assist 8 team members with technical issue in ODI 12c and RPD.
• Project planning and Development planning for implementation of OBIA 12c
• Developed PL/SQL packages, procedures, Functions, Triggers, views and Materialized Views .

Confidential, Atlanta

Senior Architect

Responsibilities:

• Responsible for creating Data Architecture and Data Modeling for OLTP and Data warehouse handling large volumes of data.
• Translate functional requirement to logical and physical data modeler by coordinating with business user.
• Established data architecture, Data Integration, Data governance standards and data models; recommended data warehouse and reporting performance-tuning techniques.
• Enforced naming standards, data dictionary and size allocation for data models.
• Responsible for defining the BI road map and creating solution architecture.
• Create data sets needed for reporting data to senior management.
• Guide team members in understanding data model and BI architecture and help in using data for downstream processes.
• Responsible for creating the data modeling for PostGreSql, NoSQL, DB2, UDB and Oracle.

Confidential

Project Manager

Responsibilities:

• Interacted with the business analyst and business users to understand the customer requirement documents.
• Responsible for Resource Management and Project Management while working on multiple JIRA ticket.
• Analyze EBS source, Oracle forms and recommend technical ETL and RPD changes.
• Impact analysis on the implementation changes and confirmation from Business user.
• Working closely with development teams and assign the tasks to the team and monitoring the project deliverables.
• Gathering functional requirements by working closely with business user to develop functional requirement MD20.
• Working on Technical design document that includes data model changes, ODI and RPD development changes.
• Working on ELT (ODI) design to customize new changes with no impact on the existing out of the box functionality.
• Working on RPD and reporting design to customize new changes with no impact on the existing out of the box functionality.
• Developing ODI Interface, Package, procedure and Scenario for 11G OBIA
• Developing Physical, BMM and Presentation layer changes in RPD.
• Developing complex canned reports and dashboard according to user requirement.
• Develop proof of concept BI reports and dashboards.
• Ensure that software implementation confirms to the business specification.
• Document all required changes for the production rollout.

Environment: OBIA 11g, Unix Shell Scripting, PL/SQL, OBIEE, RPD development, ODI, Oracle 10g, Informatica, Data modeling, SQL Developer, DAC and JIRA

BI Project Lead

Confidential

Responsibilities:

• Developed report on Informatica analyst tool to investigate the quality of data by closely working with Business User.
• Analyzed functional requirements and cross-verified them with business user on rules/transformation to be implemented to quality of data.
• Developing Technical design document by understanding the Business requirement.
• Implemented Informatica Mappings, Mapplets and workflow to improve the quality of Data for Item and Supplier.
• Responsible for the tracking and implementing the deliverables against the scope and project plan, while keeping the stakeholders up to date.
• Worked extensively in Linux environment and writing shell scripts to automate the process of sending/receiving customer data.
• Managed team of 4 members while working on multiple projects Item and Customer.
• Reports design and Development - RPD, Canned reports development.
• Production rollout and transforming knowledge to support team.
• Responsible for implementing the changes in different environment for functional testing.
• Accountable for implementation changes and confirmation from Business user.

Environment: Informatica 9.1, Informatica Data Quality, IDQ Analyst, Linux, Unix Shell script, OBIEE, PL/SQL and Oracle 10g

Confidential

BI Project Lead

Responsibilities:

• Conducted brainstorming and group discussion session elicit requirement and prepared relevant use case and Business Requirement document.
• Designed and developed data model and database required for implementation of Consumer List generation.
• ETL Design and Development in Informatica - Mappings, Mapplets and workflow development.
• Coordinated development and testing activities on BOXI to develop universe and Business reports.
• Tracked and managed ETL and Reporting deliverables based on project schedule/plan.
• Extensively worked on performance tuning of the Informatica Jobs for loading huge volume of Consumer data.
• Document all required changes for the production rollout.
• Impact analysis on the implementation changes and confirmation from Business user.
• Responsible for the production rollout and transforming knowledge to support team.

Environment: Erwin 7, Informatica 8.6, IDQ (Informatica Data Quality), BO XI, Linux, Unix Shell Script and Oracle 10g

Confidential

BI Project Lead

Responsibilities:

• Working with the business user and functional team, while effectively handling requirements elicitation and analysis.
• Analyzed business requirement and converted it to technical design document.
• Built Data Modeling and Database design using Erwin tool.
• Efforts estimation, assigning resource and status update with Team.
• ETL Design and Development in Informatica - Mappings, Mapplets and workflow development.
• Working on unit and Integration and following up with business user on sign of the requirement.
• Participate in daily Scrum and Scrum of Scrums meetings with customer.
• Reviewing and refactoring code to meet the code quality and to improve the performance of the code, implementing the comments from review on my code.
• Impact analysis on the implementation changes and confirmation from Business user.
• Documenting the changes done during the production release.

Environment: - Erwin 7, Informatica 8.6, Crystal Report, Linux, Oracle 10g, UNIX Shell Scripting, PL/SQL And SQL developer.

Confidential

BI Developer

Responsibilities:

• Involving in technical discussions and status meetings.
• Was responsible for coding the different customized Modules.
• Analyzing user requirements, designing, coding, testing and technical documentation.
• Executing the unit test cases and fixing the code based on the issue.
• Documenting the technical changes done.
• Production rollout and transforming knowledge to the support team.

Environment: - Informatica 9.1, Linux, Oracle 10g, Informatica analyst, Unix Shell Scripting.

Confidential

BI Developer

Responsibilities:

• Was responsible for coding Informatica transformation for different customized Modules.
• Executing the unit test cases and fixing the code based on the issue.
• Document technical change done during the ETL development process.
• Extensively work on the bug fix while testing with Business user.

Environment: - Erwin 7, Informatica 8.1, OBIEE, Linux, Oracle 10g

Confidential

Developer

Responsibilities:

• Developed and executed UNIX shell scripting for managing multiple file.
• Developed PL/SQL procedure, package and functions.
• Developed Maestro scheduler Jobs and procedure for running Unix Shell Script.
• Defect tracking, analysis and providing resolution during Integration Testing, System testing and UAT.

Environment: PL/SQL, UNIX Shell Scripting, J2EE, Linux, Oracle 10g and Maestro Scheduler