SUMMARY

• Over 6 years of IT experience in gathering Business Requirements, Designing, Developing and Implementation of Data warehousing, and report development.
• Worked extensively with Oracle Business Intelligence Enterprise Edition (OBIEE) and ETL (Extraction, Transfer and Load) tools.
• Great exposure to various scenarios on developing Oracle Business Intelligence Enterprise Edition repository at three layers (Physical Layer, Business Model & Mapping Layer, Presentation Layer) and Time Series Objects.
• Well versed in developing Interactive Dashboards with drill - down capabilities using page and Dashboard prompts, Security Setup(groups, object and data level), External tables and Web catalog Objects (Dashboards, Pages, Folders, Reports).
• Experienced working with multi dimensional data model, star schema and snow flake schema. Also, has good knowledge in creating Dimension hierarchies, Repository variables, users and groups. Assigning permissions and cache management.
• Worked extensively with creating interactive dashboards using links, HTML text, links to documents, and embedded contents such as images, text, charts and tables.
• Created and maintained Dashboard/Report level security.
• Created and maintained Role based and data level security.
• Performed innovative and strategic reporting roadmaps utilizing key performance indicators (KPI’s) and business performance metrics.
• In-depth knowledge with SQL and PL/SQL concepts including implementing stored procedures and packages at database level.
• Experience in Extraction, Transformation, Loading (ETL) data from various sources including Legacy Systems into Data Warehouses and Data Marts using SSIS and Informatica.
• Extensive experience in indentifying and resolving bottlenecks to improve performance at database and reporting level.
• Willingness to work with new technologies.

TECHNICAL SKILLS

Reporting tools: OBIEE 11.1.1.6/11.1.1.5/11.1.1.3/10 x, SQL Server Reporting Services

ETL tools: SSIS 2012/2008, Informatica 9.1

Databases: ORACLE11g/10g/9i, Microsoft SQL Server 2008.

Tools: and Utilities: SQL Developer, TOAD, MS Project

Programming Languages: SQL, PL/SQL, C, JAVA using OOPS

PROFESSIONAL EXPERIENCE

Confidential, Clearwater, Florida

Sr. OBIEE Developer

Responsibilities:

• Gathered requirements from various LOB business users and created business and functional specification documents.
• Worked on source to target transformation as well as recommended alternatives for the gaps as per business requirements.
• Created various materialized views, stored procedure and aggregated tables to fit in business requirements and performance tuning.
• Configured security for Authentication and created Application roles in OBIEE 11g.
• Identified and Created facts, dimensions and grains of the dimensional model and referential joins.
• Developed the repository model for different work streams/LOB (Water Account details, Utilities and Payments, Check reconciliation, Vehicle Registration etc) with necessary logic that involved creating the Physical, Business Model and Presentation Layers.
• Created global filters, conditional reports, prompts, presentation variables in Analysis.
• Worked extensively on the presentation variables to make reports work dynamically/conditionally based on the user selection.
• Designed executive Dashboards to provide Business Critical Analytical view of the Sales for a set of Power users
• Setup the visibility of dashboards to employees with respect to their responsibilities. Administered permissions and privileges for dashboard visibility and modifications to users based on their groups or responsibilities.
• Extensively worked on Answers, created Reports using different Analytics, Materialized Views (Pivot Table, Chart, Column Selector and Table).
• Debugged & modified some of the existing reports and dashboards, and fixed some of the issues related to data quality, performance etc., during production support.

Environment: OBIEE 11.1.1.6, Toad, Oracle 11g, SQL Developer, PL/SQL.

Confidential, Atlanta, GA

Contractor - BI Developer

Responsibilities:

• Gathered and analyzed the business requirements and translated the business requirements into conceptual and detailed technical design. Performed gap analysis and feasibility study for the requirement.
• Analyzed and validated administration tool to create repositories by using Physical layer, Business model and mapping layer and Presentation layer.
• Created connection pools, imported physical tables and defined joins in physical layer of repository.
• Created Dimensional hierarchies with drill down analysis, aggregate navigation, level based and time series functions based on the requirements.
• Configured expression builder utility to create new logical columns in Business Model & Mapping layer and created various calculation measures.
• Enhanced performance by creating aggregate tables, indexes and managing cache.
• Organized the Presentation layer in a format that is easy for end users to use as basis for reporting.
• Configured dashboards with different views (pivot table, chart, tabular and view), dynamic dashboard prompts and guided navigation links.
• Responsible for set up visibility of dashboards to employees with respect to their responsibilities. Created privileges and permissions for the visibility of dashboard to the users based on their responsibilities.
• Created different type of filters using local and global filters.
• Created various server variables using variable manager dividing into repository variables and session variables within the Oracle BI Administrator.
• Documented the design for intuitive understanding and for further reference.
• Identified and debugged the errors before deploying and fixed issues related to the data quality, performance etc during the production support.

Environment: OBIEE 11.1.1.5, Oracle BI publisher, Oracle 11g, SQL Developer, PL/SQL.

Confidential, Lenexa, Kansas

Contractor (Developer)

Responsibilities:

• Involved in gathering the client requirements, Business Objectives, Source data and Key performance indicators.
• Used OBIEE administration tool to Develop and enhance the metadata.
• Developed the repository model for different work streams with the necessary logic that involved creating the three layers (Physical, Business Model and Mapping, Presentation). And also determined whether measure calculations should be done in ETL or in Metadata.
• Implemented Time comparison and calculation measures in the business model using time series wizard.
• Configured Row level security and Object level security using Application Roles.
• Organized the Presentation layer in a format that is easy for end users to use as basis for reporting.
• Created server variables using variable manager that divides variables into repository variables and session variables with in Oracle BI Administrator.
• Worked closely with the ETL team to get the granularity and worked out with facts and dimensions.
• Responsible for migrating the web catalog and repositories from various environments.
• Experienced in developing Reports, Web catalog Objects, Dashboards, Hierarchies, creating Users and giving permissions based on the requirements.
• Developed many Dashboards on Business requirements, implemented dynamic column naming and dynamic logo which is driven through DB tables. Also, displaying logo depending on user credentials.
• Worked on to bridge the Gaps by analyzing the Data Marts and provided alternative solutions and also recommended the changes to Database.

Environment: OBIEE, Oracle 11g, SQL Developer, Toad

Confidential

DW Analyst

Responsibilities:

• Responsible for requirements gathering and Business Analysis.
• Analyzed the requirements and created technical specification document for all the mappings.
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database.
• Done extensive testing and wrote queries in SQL to ensure proper loading of the data.
• Responsible for definition, development and testing of processes necessary to extract data from client's operational databases, Transform and cleanse data, and Load it into data warehouse using Informatica Power center.
• Created the repository manager, users, user groups and their access profiles.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Rank, Joiner, and Stored procedure transformations.
• Developed and documented Mappings/Transformations, Audit procedures and Informatica sessions.
• Analyzed the business requirements to identify the necessary tables that need to be sourced.
• Createdtechnical specifications and mapping documentsto design and implement ETL process.
• Supported and assisted the production ETL by identifying and recommending the necessary solutions to the production problems.

Environment: Informatica Power Center 8.6, Oracle 10g, TOAD, SQL Server 2008

Confidential

Programmer Analyst

Responsibilities:

• Developed SQL programs to query databases and feed front end applications.
• Prepared test scripts for the use cases provided by business.
• Worked on performance tuning activities like optimizing SQL Queries.
• Develop ETL code to transform and load data into target databases.
• Done testing, debugging and Data loading.

Environment: Oracle 9i, SQL Server 2008, UNIX, MS SSIS