SUMMARY:

• I am a Senior Power BI Consultant with more than 16+ years of experience in designing, building and customizing the Power BI 2.8x version and various Oracle EBS modules. I also have vast experience writing functional documentation as a Business Analyst as well as preparing and presenting the User Training Manuals.
• I have experience in managing the offshore and onsite teams as a Support Lead and in setting up and training the offshore support team.
• I am a very good team player and a quick learner.
• I have good communication and interpersonal skills. I am a quick learner and am open to new ideas.
• I not only remain motivated all the time but also motivate the team members by my abilities; I have extensive experience working with Financial, Communication, Pharmaceutical and Insurance clients.
• Around 12+ years of total IT experience in implementing end - to-end of various functionalities of Data Warehouse, Data Marts, Business Intelligence and Transactional applications.
• Migration of OBIEE Reports to Power BI Reports
• Conversion of OBIEE cross functional reports to Power BI
• Extensive experience in providing end-to-end business intelligence solution by dimensional modeling design, building business models, configuring metadata, Answers, Delivers/iBots, creating Reports/Dashboards, cache monitor, and building Siebel Analytics/OBIEE Repository.
• Developed many Reports using different Analytics Views (Pivot Table, Chart, and Column Selector), Dynamic / Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters. Extensively used Siebel Delivers and iBots
• Worked extensively in Oracle BI Security, Web Object Security and Data Level security.
• Executed the SQL queries using TOAD
• Involved in writing SQL queries using Oracle 10g
• Proficient experience in different Databases like Oracle and SQL Server
• Excellent problem-solving skills with strong technical background and good interpersonal skills. Quick learner and excellent team player, ability to meet deadlines and work under pressure.
• Excellent Written and Verbal Skills; Results oriented and Self- Starter looking for challenges; Ability to rapidly learn and apply new technologies and improve processes; Self motivated and results- oriented with solid work ethic.

PROFESSIONAL EXPERIENCE:

Confidential, NY

Power BI Consultant

Responsibilities:

• Implemented Real Time reporting, Fragmentation to fetch data from different Schemas, Data level and Object
• Interacting with Business users to understand KPIs, Measures, and
• Dimension of dashboard and created the same as per the requirement.
• Created Meta data modelling in Power BI desktop using Fact and Dimension Tables.
• Developed Power BI reports using visualizations using various charts such as bar and column charts, Line chart, scatter chart etc.
• Created Calculated Measures & Columns using DAX functions.
• Creation of Power BI reports and Published to Workspace.
• Support deployment of reports in Development and higher environment workspaces.
• Conduct unit testing and troubleshooting.
• Used Power BI Gateways to keep the dashboards and reports up to date.
• Develop and update technical documentation with report design and visualization details
• SIT and UAT Support for defect fixing
• Provide Power BI reports demo to customer
• Expertise in Power BI, Power BI Pro, Power BI Mobile.
• Expert in creating and developing Power BI Dashboards into rich look.
• Experience in developing Dashboard Report, Parameterized Reports, Linked reports, Sub reports by Region, Year, Quarter, Month and Week.
• Developed Power BI model used for financial reporting of P & L and Headcount.
• Designed and documented the entire Architecture of Power BI POC
• Expertise in writing complex DAX functions in Power BI and Power Pivot.
• Automated Power Query refresh using power shell script and windows task scheduler.
• Used various sources to pull data into Power BI such as Sql Server, SAP BW, Oracle, SQL Azure etc.

Confidential, Berkeley Heights, NJ

Power BI Consultant

Responsibilities:

• Created Meta data modelling in Power BI desktop using Fact and Dimension Tables.
• Developed Power BI reports using visualizations using various charts such as bar and column charts, Line chart, scatter chart etc.
• Created Calculated Measures & Columns using DAX functions.
• Creation of Power BI reports and Published to Workspace.
• Support deployment of reports in Development and higher environment workspaces.
• Conduct unit testing and troubleshooting.
• Used Power BI Gateways to keep the dashboards and reports up to date.
• Develop and update technical documentation with report design and visualization details
• SIT and UAT Support for defect fixing
• Provide Power BI reports demo to customer
• Expertise in Power BI, Power BI Pro, Power BI Mobile.
• Expert in creating and developing Power BI Dashboards into rich look.
• Created Star schemas and Customized Logical tables/columns, defined Dimensions, Aggregate tables, Dimensional Hierarchies.
• Implemented Real Time reporting, Fragmentation to fetch data from different Schemas, Data level and Object Level security in Admin Tool by setting up users, groups, access privileges and query privileges.
• Created dimension sources for each level of aggregated fact data and specified aggregate levels for each source in the Power BI.
• Created dimensions, dimension hierarchies, levels (to support drilldown), level-based calculations and defined level attributes, level keys.
• Defined static and dynamic repository variables to modify metadata content dynamically to adjust to a changing data environment.
• Configured Dashboards, Charts, Pivot table views, and filters in user interface. Configured Global Filters and Prompts in Web.
• Created Alerts to show the exceptional reports, Conditional Reports and Navigation Reports with conditional formatted columns.

Confidential, Iselin - NJ

Sr. OBIEE Lead

Responsibilities:

• Worked closely with Business Users, discussed and gathered the requirements from different user groups to perform gap analysis, Data Modeling and designing the application.
• Preparing Technical Design Document for OBIEE.
• Followed SDLC Process and Implemented Best Practices in OBIEE.
• Worked extensively creating complex interactive Union Reports from different subject areas, drill downs to the detail reports, Management specific formatting reports and design complex multiple Dashboard pages for the IMS/Product/Strategic Team.
• Metadata Configuration - Physical Layer (connecting Data sources & import schema), Business Model & data mapping (create Logical tables & data source mapping) & Presentation layer level (create presentation catalogs), create presentation folders, test and validate the model in the OBIEE.
• Created Star schemas and Customized Logical tables/columns, defined Dimensions, Aggregate tables, Dimensional Hierarchies.
• Implemented Real Time reporting, Fragmentation to fetch data from different Schemas, Data level and Object Level security in Admin Tool by setting up users, groups, access privileges and query privileges.
• Created dimension sources for each level of aggregated fact data and specified aggregate levels for each source in the OBIEE BMM Layer.
• Created dimensions, dimension hierarchies, levels (to support drilldown), level-based calculations and defined level attributes, level keys.
• Defined static and dynamic repository variables to modify metadata content dynamically to adjust to a changing data environment.
• Created users and groups and assigned explicit and individual permissions and privileges to access the data.
• Configured Dashboards, Charts, Pivot table views, and filters in user interface. Configured Global Filters and Prompts in Web.
• Created Alerts to show the exceptional reports, Conditional Reports and Navigation Reports with conditional formatted columns.
• Creating and Applying patches to RPD in DEV/QA/UAT Environments.
• Performing RPD Merge for DEV/QA/UAT and other forms of testing.
• Performed the Server Administration tasks of migrating the RPD, Webcat between the DEV/QA/UAT/PROD environments by creating the release plans.
• Guide team development efforts towards successful project delivery.
• Provide technical leadership to teammates through coaching and mentorship.
• Maintain high standards of software quality within the team by establishing good practices and habits.
• Identify and encourage areas for growth and improvement within the team.
• Collaborate with other software developers, business analysts and software architects to plan, design, develop, test, and maintain web- and desktop-based business applications built on Microsoft technologies.
• Assist in the collection and documentation of user's requirements, development of user stories, estimates and work plans.
• Prepare reports, manuals and other documentation on the status, operation and maintenance of software.
• Design, develop, and unit test applications in accordance with established standards.
• Participate in peer-reviews of solution designs and related code.
• Performed Unit and Integration testing, Involved in End User training and creating manuals.

Confidential, Horsham - PA

Sr. OBIEE Developer

Responsibilities:

• Worked closely with Business Users, discussed and gathered the requirements from different user groups to perform gap analysis, Data Modeling and designing the application.
• Preparing Technical Design Document for OBIEE.
• Followed SDLC Process and Implemented Best Practices in OBIEE.
• Worked extensively creating complex interactive Union Reports from different subject areas, drill downs to the detail reports, Management specific formatting reports and design complex multiple Dashboard pages for the IMS/Product/Strategic Team.
• Metadata Configuration - Physical Layer (connecting Data sources & import schema), Business Model & data mapping (create Logical tables & data source mapping) & Presentation layer level (create presentation catalogs), create presentation folders, test and validate the model in the OBIEE.
• Created Star schemas and Customized Logical tables/columns, defined Dimensions, Aggregate tables, Dimensional Hierarchies.
• Implemented Real Time reporting, Fragmentation to fetch data from different Schemas, Data level and Object Level security in Admin Tool by setting up users, groups, access privileges and query privileges.
• Created dimension sources for each level of aggregated fact data and specified aggregate levels for each source in the OBIEE BMM Layer.
• Created dimensions, dimension hierarchies, levels (to support drilldown), level-based calculations and defined level attributes, level keys.
• Defined static and dynamic repository variables to modify metadata content dynamically to adjust to a changing data environment.
• Created users and groups and assigned explicit and individual permissions and privileges to access the data.
• Configured Dashboards, Charts, Pivot table views, and filters in user interface. Configured Global Filters and Prompts in Web.
• Created Alerts to show the exceptional reports, Conditional Reports and Navigation Reports with conditional formatted columns.
• Creating and Applying patches to RPD in DEV/QA/UAT Environments.
• Performing RPD Merge for DEV/QA/UAT and other forms of testing.
• Performed the Server Administration tasks of migrating the RPD, Webcat between the DEV/QA/UAT/PROD environments by creating the release plans.
• Performed Unit and Integration testing, Involved in End User training and creating manuals.

Confidential, NY

Lead OBIEE Developer

Responsibilities:

• Effectively interacted with the end users for requirement gathering and defined requirement specifications document by access and retrieval of financial and personnel data from one single source.
• Identified & Created Facts, Dimensions, and Hierarchies of the business model.
• Understanding Peoplesoft Source system (OLTP) data.
• Understanding Node structures in Peoplesoft
• Developed Segment Value Detail, Work Order Detail and Repositories (RPD) by importing metadata into Physical Layer, applied Business rules in the Business Modeling and Mapping layer and created customized user views in the Presentation layer.
• Created Catalog Groups and set permissions for items in the presentation catalog and privileges and rights to users and groups.
• Designed and Tested Reports in the Dashboards for the Oracle Financial Analytics modules like GL, AP, AR and created the Ad-hoc report according to the client needs.
• Configured Interactive Dashboard with drill-down capabilities using global and local Filters, Metadata Objects and Web Catalog Objects.
• Identified issues, performance bottlenecks, and optimized the Business Intelligence Dashboards and Reports.
• Developed different kinds of reports (pivots, charts, tabular) using global and local Filters.
• Involved in Creating and Administering the Physical Layer, Business Model & Mapping Layer and Presentation Layer using Oracle Business Intelligence Admin tool.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Created Dimensional Hierarchy, Level based Measures and Aggregate navigation in BMM layer
• Wrote Custom SQL Codes for the reports.
• Applied Optimization Techniques for the better performance of the reports
• Involved in writing SQL queries using Oracle 11g

Environment: OBIEE 11.1.1.5, Windows Enterprise, Oracle 11g, PL/SQL, SQL Server, TOAD, DAC, OLAP

Confidential, Pennington, NJ

Sr. OBIEE Developer

Responsibilities:

• Customized Oracle BIEE 11.1.3.3 Metadata Repository (.rpd) using Siebel Analytics/OBIEE Admin Tool by importing some of the required objects with integrity constraints into Physical Layer.
• Installation of OBIEE on XP, Windows Server 2000.
• Created Dimensional Hierarchies and modeled the BMM Layer in OBIEE 11.1.3.
• Used Look up tables in OBIEE 11g
• Used Enterprise Manager in OBIEE 11g.
• Established permissions for Users using Manage Identity.
• Highlighted the issues between 11.1.3 and 11.1.5
• Involved in development and review of System documentation and Validation deliverables
• Developed and debugged many Dynamic / Interactive Dashboards /Reports with different Analytics Views, drill-down & drill-across capabilities, Contextual Navigation, Guided Analytics, roles & web groups, and Alerts using Presentation Services
• Designed and developed Siebel Analytics Web catalog, Reports/Dashboards with different Analytics Views using Oracle Business Intelligence Presentation Services.
• Developed and Debugged Dashboards /Reports with different analytics views (Pivot table, Chart, Tabular and View Selector), Alerts, Guided Navigation and Dynamic /Interactive Dashboards with drill down capabilities using global and local filters
• Worked extensively in Oracle BI Security, Web Object Security and Data Level security.
• Administering the OBIEE Dashboards and Reports, Data Visibility, Caching and RPD file migrations
• Executed the SQL queries using TOAD
• Involved in writing SQL queries using Oracle 10g

Environment: OBIEE 10.1.3, Windows 2008, Oracle 11g, PL/SQL, SQL Server, TOAD, DAC, OLAP

Confidential, Jersey City, NJ

Sr. OBIEE Developer

Responsibilities:

• Install OBIEE 10g in the Development environment Windows 2003 and XP
• Translate BI requirements into analytics metadata and Logical Data Model (rpd/webcat development)
• Assist with OBIEE reports performance tuning.
• Communicate design, build and test progress and issues to Client and overall Project team Design rpd and webcat migration methodology Build and Test Metadata.
• Worked extensively on Hedge fund tables.
• Worked extensively on Unionizing the requests and troubleshooting.
• Experience in performing BI Infrastructure ( toolset installation & configuration, administration and security)
• Involved in development and review of System documentation and Validation deliverables
• Developed and debugged many Dynamic / Interactive Dashboards /Reports with different Analytics Views, drill-down & drill-across capabilities, Contextual Navigation, Guided Analytics, roles & web groups, and Alerts using Presentation Services
• Experience in Scheduling iBots and Configuring LDAP Server.
• Designed and developed Siebel Analytics Web catalog, Reports/Dashboards with different Analytics Views using Oracle Business Intelligence Presentation Services.
• Developed and Debugged Dashboards /Reports with different analytics views (Pivot table, Chart, Tabular and View Selector), Alerts, Guided Navigation and Dynamic /Interactive Dashboards with drill down capabilities using global and local filters
• Worked extensively in Oracle BI Security, Web Object Security and Data Level security.
• Administering the OBIEE Dashboards and Reports, Data Visibility, Caching and RPD file migrations
• Executed the SQL queries using TOAD
• Involved in writing SQL queries using Oracle 10g
• Written test scripts to compare OLTP vs. OLAP for ETL testing.

Environment: OBIEE 10.1.3, Windows 2003, Oracle 9.0.2, PL/SQL, SQL Server, TOAD, DAC, OLAP

Confidential, Princeton, NJ

Sr. OBIEE Developer / Onsite Lead

Responsibilities:

• Involved in development and review of System documentation and Validation deliverables
• Installation of OBIEE on Linux, Windows Server 2000
• Customized Oracle BIEE 10.1.3.3 Metadata Repository (.rpd) using Siebel Analytics/OBIEE Admin Tool by importing some of the required objects with integrity constraints into Physical Layer.
• Developed and debugged many Dynamic / Interactive Dashboards /Reports with different Analytics Views, drill-down & drill-across capabilities, Contextual Navigation, Guided Analytics, roles & web groups, and Alerts using Presentation Services
• Designed and developed Siebel Analytics Web catalog, Reports/Dashboards with different Analytics Views using Oracle Business Intelligence Presentation Services.
• Developed and Debugged Dashboards /Reports with different analytics views (Pivot table, Chart, Tabular and View Selector), Alerts, Guided Navigation and Dynamic /Interactive Dashboards with drill down capabilities using global and local filters
• Worked extensively in Oracle BI Publisher and provided the capability to download the reports in the user defined formats
• Designed and Tested Reports in the Dashboards for the Oracle Financial Analytics modules like GL, AP, AR and created the Ad-hoc report according to the client needs.
• Worked extensively in Oracle BI Security, Web Object Security and Data Level security.
• Administering the OBIEE Dashboards and Reports, Data Visibility, Caching and RPD file migrations
• Executed the SQL queries using TOAD
• Involved in writing SQL queries using Oracle 10g
• Also participated in analyzing ETL mappings using Informatica 8.1, used Transformations like Aggregator, Update, Filter, Lookup, Sorter.
• Worked in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Scheduled and Monitored ETL (SIL and SDE) runs using DAC.
• Also participated in developing ETL design using Informatica, used Transformations like Aggregator, Update, Filter, Lookup, Sorter.
• Written test scripts to compare OLTP vs. OLAP for ETL testing.

Environment: OBIEE 10.1.3, Windows 2003, Oracle 9.0.2, PL/SQL, SQL Server, TOAD, DAC, Informatica 8.1, OLAP, UDB DB2

Confidential, Ashburn, VA

OBIEE Developer

Responsibilities:

• Participated in Requirements gathering of the various work streams by meeting with the business user and base lining the details.
• Migrate the Repository between environments like Dev, Test, QA, Maintenance and Performance.
• Maintain different environments like Dev, Test, and QA and resolve issues.
• Handled the implementation stages for EDI, Packaged HR Analytics, Purchasing and setting up the interface for HR Management system.
• Participated in a fully integrated solution utilizing HR Analytics for HR Reporting, Productivity and Development Reports & Metrics, Attrition and Retention Reports & Metrics Using Oracle eBusiness Suite we have made the application globally work
• Worked on Oracle BI EE Administration tool for customizing the Physical layer, Business layer, Presentation layer and modifying it according to the business requirements.
• Design, build and test-reports, Dashboards, BI Publisher and Microsoft Integration and other functionality within the OBIEE suite.
• Worked and developed Repository (.rpd), configured metadata objects (Subject Area, Table, Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Developed a separate system using Disconnected Siebel Analytics/ OBIEE
• Also participated in analyzing ETL mappings using Informatica 8.1, used Transformations like Aggregator, Update, Filter, Lookup, Sorter.
• Developed PL/SQL Procedures, Packages and Triggers
• Created mappings using PL/SQL packages to implement business rules while loading data
• Worked in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Scheduled and Monitored ETL (SIL and SDE) runs using DAC.
• Written test scripts to compare OLTP vs. OLAP for ETL testing.

Environment: OBIEE 10.1.3, Sun Solaris 5.9, Oracle 9.0.2,PL/SQL, DB2.

Confidential, NY

Siebel Analytics Developer

Responsibilities:

• Identified key dimensions and measures for business performance.
• Installation of Siebel Analytics/OBIEE and related components for development, QA and production environments
• Involved in development and review of System documentation and Validation deliverables
• Customized Oracle BIEE 10.1.3.3 Metadata Repository (.rpd) using Siebel Analytics/OBIEE Admin Tool by importing some of the required objects with integrity constraints into Physical Layer.
• Worked on Siebel Answers to build Interactive Dashboards with drill-down capabilities
• Designed and developed Siebel Analytics Web catalog, Reports/Dashboards with different Analytics Views using Oracle Business Intelligence Presentation Services, Semantic Layer.
• Executed the SQL queries using TOAD
• Extensively worked on KPI notifications and Security
• Involved in writing SQL queries using Oracle 10g
• Excellent working Knowledge of Oracle Financials 11i Project Accounting, Accounts Payable, and Accounts Receivable for three European locations in a Multi-Org, Multi-Reporting, Global Accounting environment.
• Handled the implementation stages for EDI, Oracle Financials, Purchasing and setting up the interface for Order Management system.
• Participated in a fully integrated solution utilizing Oracle Financials 11.03 for Financial Reporting, General Ledger, Accounts Payable and Project Accounting
• Setup and implementation of Oracle Financial Analyzer

Environment: Siebel 7.8.2, Siebel Call Center, eSales, Windows 2003, Oracle 9.0.2. IIS 5.0

Confidential

Siebel Developer

Responsibilities:

• Developed and debugged many Dynamic / Interactive Dashboards /Reports with different Analytics Views, drill-down & drill-across capabilities, Contextual Navigation, Guided Analytics, roles & web groups, and Alerts using Presentation Services.
• Installation and configuration of Siebel dev, test and prod support environments.
• Maintain different environments like Dev, Test, QA and resolve issues.
• Troubleshoot timeout issues in respect of various Interfaces.
• Monitor the Workflow logs and troubleshoot issues.
• Prepare System Design Documentation for enhancements and new releases.
• Prepare Project Plan for the team to carryout the new releases and enhancements.
• Prepare the Siebel Anywhere Components and Upgrade Kits for every srf release.
• Migrate the Repository between environments like Dev, Test, QA
• Designed and developed graphical user interface and configuration of the application to customize the Siebel sales enterprise using Siebel tools (Screens, Views, Applets, Business Objects, Business Components, Links and Joins etc).
• Extensively customized and added new Siebel GUI layer objects to add new functionality as per requirements in Siebel using Siebel tools.
• Involved in creation and customization of Dynamic and Static Pick lists.
• Created Extension columns to add columns to existing tables.
• Used SQL for Querying the DB2 database in UNIX environment
• Responsible for design and implementation of workflow manager based on sales process.
• Responsible for analysis of performance of the system and giving suggestions for poor performance.
• Was a member of production support team that give real time support to the users around the globe, responsible for solving many real time problems in time.
• Reviewed documentation for correctness and clarity.

Environment: Siebel 7.7 Call Center, UNIX, Oracle 9i, UDB DB2, Sun Solaris.