SUMMARY

• Over 15 years of experience in the IT industry .Main area of expertise is in OBIEE/OBIA, Informatica and SSIS
• Over 10 years of experience in Data Warehousing, Data Analysis, Reporting, ETL, Data modeling, Development, Maintenance, Testing and Documentation
• Extensive experience in OBIEE repository development, OBIEE Answers, Dashboards, OBIEE Administration
• Good knowledge in Data Modeling (logical/physical) using Erwin 3.5/4.0
• Used ETL methodology for supporting data extraction, transformation and loading process, in a corporate - wide-ETL Solution using Informatica and other ETL tools
• Experienced in analysis of different systems for system study and data warehouse implementations
• Strong experience in client interaction and understanding business application, business data flow and data relations
• Good experience in implementing OBIA analytics packaged solutions after fit-gap analysis
• Good experience in leading teams and managing multiple projects
• Good communication, analytical skills and flexible to learn advancements in the IT industry

TECHNICAL SKILLS

OPERATING SYSTEMS: Windows Server, Unix, linuxDATABASES Oracle9i, Oracle 10g/11g, DB2, MS Sql Server

DOMAIN KNOWLEDGE: Confidential, Securities,Telecom, Pharma

OLAP: OBIEE 10.x/11g, Big data

Packaged analytics: OBIA SCM, HR analytics

ETL TOOLS: Informatica 8.x/9.x, SSIS, DataStage 7.5.2,DAC

PROFESSIONAL EXPERIENCE

Confidential, St Louis, MO

OBIEE Architect

Responsibilities:

• Source data analysis and profiling
• System study and analysis of as-is system
• Design and development of Reports/Dashboards for Primary Customers by IXI Tiers, Equity Tiers and Tenure
• Design and development of Reports/Dashboards for Primary Customers by Net New Assets and Gross New Assets
• Analysis and Performance tuning of Weekly Apps, Marketing, Service and AML Dashboards
• Customized out of the box financial module reports(Income statement, Cash flow statement)
• Unit testing, Regression testing, Integration testing, Implementation and support
• Analysis and Performance tuning of Weekly Apps, Marketing, Service and AML Dashboards
• Conversion of Discoverer reports to OBIEE
• Production support and regular maintenance work fixing data, reports/dashboards and report performance issues

Environment: OBIEE 11g, Informatica 9.x, Erwin, SQL developer

Confidential, Carmel, IN

OBIEE Architect

Responsibilities:

• Maintenance and support of existing OBIA/DAC implementation as administrator
• ETL and OBIEE design reviews and validations
• Master data management and data reconciliation testing
• Source data analysis and profiling
• Design and development of Informatica mappings
• MSAD integration for external authentication
• Security implementation and authorization to subject areas, reports and dashboards as per security role
• Migration of rpd, reports, dashboards through different environments and production validation
• Developed and customized Business objects Universe, Webi reports for comparative analysis and data reconciliation
• Developed spend analytics webi reports and implemented data level security
• DAC scheduling for full and incremental loads
• Implementation of financial, Procurement and Spend module analytics

Environment: OBIEE 11g, Informatica 9.x, Erwin, SQL developer, DAC, BOBJ

Confidential, Chicago, IL

OBIEE Architect

Responsibilities:

• System study and analysis of as-is system
• ETL and OBIEE design reviews and validations
• Master data management and data reconciliation testing
• Source data analysis and profiling
• Identifying the granularity and validation of data warehouse and data mart models
• String testing of data from source to stage, stage to data warehouse and from data warehouse to data mart
• Implementation of Sales analytics, Inventory analytics and Procurement analytics modules

Environment: OBIEE 10.x/11g, Informatica 9.x, Erwin, SQL developer, AS/400, SSIS

Confidential, Austin, TX

OBIEE Architect

Responsibilities:

• System study and analysis of as-is system
• Translating business requirements in to functional and technical specifications
• Installation of OBIEE 11g and upgrade of web catalog and rpd from OBIEE 10g
• Installation, configuration and Implementation of financial analytics and Service analytics modules both in development and production environments
• Implementation of security, reports and data testing after ETL loads

Environment: OBIEE 10.x/11g, Informatica 9.x, Erwin, SQL developer, Oracle EBS R12, Linux

Confidential, Atlanta, GA

OBIEE Architect

Responsibilities:

• Impact analysis after the source system Peoplesoft upgrade from 8.9 to 9.1
• Consolidation of reports across subject areas, upgrade, testing and migration
• Development of customized Taleo model for recruitment system
• OBIEE model, reports upgrade and testing

Environment: OBIEE 11g, Informatica 9.x, Erwin, TOAD, Oracle EBS R12

Confidential, Boston, MA

BI Architect

Responsibilities:

• Manage and participate in all phases of the implementation lifecycle
• Requirement and Technical specification documentation
• Estimation and execution of different modules of project
• Enhancement of the existing model to support history and new peoplesoft tables for analytical reporting
• Customizing seeded ETL mappings and developed new ETL mappings to match the reporting requirements
• Developed hierarchies, dimensions, and aggregates in BMM layer and presentation layer
• Developed HR analytics 9 box and Compensation heat map reports with different prompts and filters
• Modification and testing of the existing reports to support history
• Did performance tuning
• Extensively used SQL,PL/SQL to write procedures for data loading and data reconciliation
• Implemented best practices during physical and business layer design for developing intuitive reports
• Did code reviews, technical and functional document reviews
• Implemented object level and data level security based on user login profiles
• Used BI publisher to develop HR analytic reports with complex formatting
• Report bursting and distribution of OBIEE reports
• Unit testing, Regression testing, Integration testing, Implementation and support

Environment: OBIEE 10.x/11g, Informatica 9.x,TOAD, Oracle EBS R12, BI Publisher

Confidential, Middlebury, CT

BI Architect

Responsibilities:

• Manage and participate in all phases of the implementation lifecycle
• Estimation and execution of different modules of project
• Developed hierarchies, dimensions, and aggregates in BMM layer and presentation layer
• Usage of OBIEE time-series functions to develop sales & marketing reports to get sales numbers for different periods
• Developed commission & forecast reports
• Developed fill-kill reports for order management & forecast
• Developed demand-planning & inventory management reports
• Did performance tuning
• Developed Interactive Dashboards with drill-down capabilities.
• Extensively used SQL,PL/SQL to write procedures for data validations and data loading
• Implemented best practices during physical and business layer design for developing intuitive reports
• Did code reviews, technical and functional document reviews
• Implemented object level and data level security
• Used BI publisher to develop sales and finance reports for mass distribution
• Configured Agents to send the Reports through Emails to the user group

Environment: OBIEE 11g, Informatica 9.x, Erwin, SQL developer, BI Publisher

Confidential, NY

BI Architect

Responsibilities:

• Manage and participate in all phases of the implementation lifecycle
• Estimated work effort for delivery schedule
• Mentoring team members
• Implemented and customized financial analytics
• Identified the granularity level of the data required to be available for analysis
• Developed hierarchies, dimensions, and aggregates in BMM layer and presentation layer
• Developed and implemented ragged and skip level hierarchies in financial ratings reports
• Developed interactive reports with dynamic grouping and custom hierarchies
• Developed data visualizations for profiling
• Did performance tuning of the system
• Developed master detail linking compliance reports
• Developed Interactive Dashboards with drill-down
• Implemented best practices during physical and business layer design for developing intuitive reports
• Did code reviews, technical and functional document reviews
• Developed finance reports using BI publisher using different data sources
• Implemented object level and data level security
• Configured Agents to send the Reports through Emails to the user group

Environment: OBIEE 11g, SCM, Informatica 9.x/8.x, Erwin, Unix, SQL

Confidential, CA

OBIEE Architect

Responsibilities:

• Gathered the requirement, completed the proof of concept, Designed, Developed and Tested Physical Layer, Business Layer and Presentation Layer of OBIEE
• Defined dimensional hierarchies and associated the proper level of granularity to the fact table.
• Created new logical measures required as per the business requirements
• Leading teams, project estimations and execution
• Implementation of financial analytics
• Development and maintenance of Exposure and Breach OBIEE Dashboard reports
• Developed enterprise BI reports(List, crosstab, funnel, chart)
• Developed interactive reports with drill downs using OBIEE Business layer hierarchy
• Preparing the Documentation for the mapping according to the designed logic used in the mapping
• Developed Source-Target mappings for the transformations needed for data load
• Implementing the breach logic during transformations in ETL
• Performance tuning of the system
• Used SQL, PL/SQL for data validations, data extraction from different data sources
• Application administration and support
• Developed BI publisher auto mail reports
• Document Administration environment and support processes

Environment: OBIEE 11g, Informatica 8.x, Erwin, Answers, Dashboards, Unix, SQL, Oracle EBS

Confidential, Rockland, MA

OBIEE Consultant

Responsibilities:

• Developed the functional and technical specification documents for PCD analytics solution
• Developed and Tested Physical Layer, Business Layer and Presentation Layer of OBIEE
• Experience in performance tuning at the Database level by creating aggregate tables, Bitmap, B Tree Indexes, RPD level by creating Database hints in physical Layer, Tuning Reports.
• Development and unit testing of Analytical dashboards/reports which were developed for various hierarchies in the organization
• Implemented and tested the data level security on analytic dashboards/reports
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner
• Created iBots to deliver scheduled reports with the desired frequency
• Create backup and recovery processes for critical components
• Worked with Oracle data integrator(ODI) for data transformations and loading

Environment: OBIEE 10.x, Answers, Dashboards, ODI

Confidential, Pittsburgh, PA

OBIEE Consultant

Responsibilities:

• End to end implementation of DWBI system
• Requirement study, analysis, architecture and report development
• Developed mappings and transformation in Informatica for data load
• Developed OBIEE 10.x repository
• Developed Physical and Business layer, was involved in developing complex parameterized, interactive reports
• Created business reports usingBI Answersas per requirements
• Generated variousAnalytics Reports using global and local filters
• Identified theaggregate levelsfor each source andcreated dimensionsources for each level of aggregates
• Implemented Security Features of like row level, object level and report level to make the data secure
• Developed different Dashboards/Reports with different view (Calculation, Detailed, Pivot, Charts, Filters) and different intuitive drilldowns, drill-across and drillable charts using the OBIEE Answers.

Environment: OBIEE 10.x, Informatica, Dashboards, Answers

Confidential

DWBI developer

Responsibilities:

• Tool evaluations, proposals, building competencies and accelerators.
• Tool comparisons and beta testing of BI tools
• Developed point solutions for Confidential domains with Dashboards and Scorecards
• Pre sales activities and BI tool selections

Environment: OBIEE, Informatica, BO XI R2/R3, Informatica

Confidential

BI developer

Responsibilities:

• Designed and developed complex graphical reports
• Created and Tested Reports in the Dashboard
• Developed complex metrics reports, Dashboards, Scorecards
• Used iBots to send alerts to the required recipients
• Implemented Security Features like row level, object level and report level to make the data secure
• Involved in fine-tuning the reports by working extensively on the Caching Strategy.
• Customized and developed repository, configured metadata objects (Subject Area, Table, Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports)
• Configured measures in the Business Model Layer and mapped to multiple logical source tables

Environment: OBIEE, iBots

Confidential, Denver, CO

BI developer

Responsibilities:

• End to End DWBI implementation
• Understood business needs and was able to translate them into a technical solutions
• Estimated work efforts and was responsible for delivery schedule
• Data modeling of the system
• Data loading from source system in to target through ETL process
• Designed, Developed and Tested Physical Layer, Business Layer and Presentation Layer
• Developed innovative BI analytical reports/Dashboards
• Extensively used Calculations, Variables, Drill Down and Slice and Dice for creating reports
• Developed complex formulas and measures reflecting the business users requirements

Environment: Siebel analytics, Oracle 8.x, Erwin 3.x

Confidential, MI

BI developer

Responsibilities:

• Involved in the requirement gathering and data modeling of the system, the underlying transaction system is in Sales domain
• Responsible for design and development of physical and presentation layers
• Developed the functional and technical specification documents for requirements
• Managed customer expectations
• Lead technical teams and mentored client teams
• Extensively involved in developing the Vendor interface Application for tracking PO information and for order lists.
• Extensively involved in setting up the data level security for web reports.
• Involved in developing and testing of the PO Reports for different PO types and different goods delivery Conditions to stores and distribution centres
• Implemented data security

Environment: Siebel Analytics, Erwin

Confidential, MN

Developer

Responsibilities:

• Manage and participate in all phases of the implementation lifecycle
• Understand business needs and be able to translate them into a technical solutions
• Interacted with business to get requirements
• Quickly adapted to clients business process
• Developed reports which measure vendor performance, which aid in parts shipment management with extensive search and drill down capabilities.
• Developed reports which deal with Parts Inventory and Parts Accounting.
• Developed the various complex KPI’s needed for reporting
• Development and Integration testing of Reports.
• Worked with graphical components of to represent data in graphical form for analysis.
• Developed unit test documents for use cases

Environment: Siebel Analytics

Confidential, CA

BI Developer/Analyst

Responsibilities:

• Requirement gathering in developing the system
• Developed the functional and technical specification documents for requirements
• Developed the Oracle, PL/SQL scripts for data load in to target system
• Created users, groups and filters to setup security
• Developed Reports for Order management and Inventory control.
• Developed Siebel analytics Reports for Micro/Macro Analysis of Supply chain management
• Application support and upgrade activities
• Data validation (data integrity).
• Document Administration environment and support processes.

Environment: Siebel Analytics

Confidential

BI Developer/Analyst

Responsibilities:

• Participated in all phases of the implementation lifecycle
• Used Sequential, Parallel, Cross Tab and Conditional sections to generate different Reports aid in Regional Accounting.
• Created internal, external and Dynamic Hyperlinks to generate Reports.
• Used Group sections and Conditional sections to develop Reports which aid in Regional sale analysis.
• Development and Integration testing of Reports.
• Developed Reports for Micro/Macro Analysis of Supply chain management.