SUMMARY

• 12 + years’ Experience in developing the Business requirements and converting the business Requirements into Functional and Technical Requirements and Formulated specifications and requirements for reporting and Analytical Purposes and Prepared and implemented Test Cases based on the Business Requirements.
• Experience on Power BI to Deliver high quality BI Solutions in an Enterprise Data Warehouse environment.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Utilized Power BI gateway to keep dashboards and reports up to - date with on premise data sources.
• Experience in Developing visual reports, Dashboards and KPI Scorecards using Power BI Desktop
• Adept in Developing, Publishing and schedule Power BI Reports as per the Business Requirements
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star Schema & Snowflake Schema used in relational, dimensional, and multidimensional modeling.
• Experience with Creating Tables/views. Experienced in writing and understanding complex SQL queries.
• Experience in Validating the Analytical reporting data against the source systems.
• Experience in OBIEE to provide end-to-end Business Intelligence solutions.
• Involved in publishing various kinds of interactive data visualizations, dashboards, reports from OBIEE.
• Skilled in Power BI & OBIEE for data visualization, Reporting and Analysis; Geographic Map, Pie Charts and Bar Charts etc.
• Created Power BI & OBIEE Scorecards, dashboards using stack bars, bar graphs and scattered plots.
• Extensive Experience in Creating Dashboard Reports, Portal pages, Complex Reports involving Drill through, Master-Detail, Bursting, Conditional Formatting, Page sets, Conditional blocks, Variables, Multiple Prompt Templates, Bookmarks.
• Skilled in creating reports using BI Publisher including custom Financials AP Check.
• Strong familiarity with Oracle ERP out-of-the-box reports.
• Experience in OBIEE in out of the box analytics like Financials, HR, Supply Chain and Order Management, Assets.
• Experience in ETL tools, especially Informatica and Oracle Data Integrator (ODI).
• Experience working with ThoughtSpot.
• Worked with Cross functional teams to provide ad-hoc queries for day-to-day operations.
• Experienced in Agile Methodology and responsible for creating Product Backlog items and conducting daily scrums (updating the tasks).
• Responsible for Backlog Refinement and driving the sprint planning meetings.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Highly motivated and focused problem solver with a passion to improve business processes by implementing innovative business solutions.
• Excellent team player, quick learner, ability to work and deliver under tight deadlines.

TECHNICAL SKILLS

BI Tools: Power BI Desktop, Power BI Services, ThoughtSpot, OBIEE, Oracle Analytics Cloud (OAC), OTBI, BI/XML Publisher, SSRS

ETL Tools: Informatica Power center, Oracle Data Integrator, SSIS (SQL Server Integration Services)

Operating Systems: Windows, Windows XP Professional, Windows NT, UNIX, Linux

Databases: Snowflake, Oracle 8i/9i/10g/11g/12c, MS-Access, DB2, SQL Server 2000/05/08/12/16 , Teradata

Database Tools: TOAD, SQL Developer

Data Modeling Tools: MS Visio, Erwin

PROFESSIONAL EXPERIENCE

Confidential, PHOENIX, AZ

LEAD BUSINESS INTELLIGENCE DEVELOPER

RESPONSIBILITIES:

• Responsible for working closely with business partners and business analysts to help gather requirements and translate requirements into system work.
• Define and create a variety of standard IT project deliverables throughout all project lifecycle phases. Also, interface with and drive work with team members at different levels.
• Experienced in Developing Power BI reports using PowerBI Desktop and publishing them on to Power BI services (on Power BI Premium workspace).
• Created Power BI models and made the model available for Data Analyst teams to create different set of reports for Analysis and developed the reports using Direct query in Power BI Desktop.
• Created Pixel perfect, multi-page, heavy Excel extraction-based reports using Report Builder/Paginated reports.
• Developed the Key weekly and monthly financial reports in Power BI for Accounting & Finance Team for the financial book closings.
• Designed Power BI Visualization utilizing cross tabs, drill-through, drill down, hierarchy, maps, scatter plots, pie, and bar charts etc.
• Use Power Automate to schedule Power BI and Paginated reports to deliver directly to emails, SharePoint.
• Extensively use Power Query, DAX to transform data, creating calculated columns, measures etc respectively.
• Responsible for creating new reports/enhancement requests for different areas of the business using Power BI.
• Responsible for the migration of OBIEE reports to Power BI and Paginated reporting.
• Experienced in development of OBIEE, RPD modelling.
• Created reports using different kinds of variables, views and scheduled for daily/weekly/monthly report deliveries.
• Responsible for migrating reports from OBIEE 11g to OBIEE 12c.
• Responsible for creating new reports/dashboards using OTBI during Oracle Financials source system migration.
• Experienced in creating variety of reports using BI/XML publisher, including the custom AP check for payments.
• Experienced in creating reports using Oracle Analytics Cloud (OAC).
• Experienced in creating reports using ThoughtSpot.
• Validating the Analytics and Reporting data against the source systems.
• Interacted extensively with ETL and Report developers, quality assurance engineers, and project teams regarding scheduling, requirements, design, implementation, testing, and support.
• Responsible for the Deployment of Dashboards into Production Environment.
• Created documentation for the complete project life cycle and mentored the End Users and Provided Technical Support.
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports.

Environment: Power BI Desktop, Power BI Services, Paginated Reports, OBIEE, Oracle Analytics Cloud, OTBI, BI Publisher, ThoughtSpot, Snowflake, Oracle, Teradata, DB2, Microsoft office 365

Confidential, BEDFORD, MA

LEAD BUSINESS INTELLIGENCE DEVELOPER

Responsibilities:

• Work with Business Units to define Business strategy and create a centralized reporting capability for users to perform analytical and ad-hoc reporting for business applications and provide accurate information available to Decision Makers.
• Responsible for working with the Business, Data and Reporting teams to identify the Oracle Data Integrator (ODI) ETL issues.
• Worked on enhancing/modifying existing interface/procedures/packages as per the requirements for ODI & OBIEE.
• Experience in working with EBS R12 views, which were used as a source of reporting in OBIEE.
• Experienced in developing and supporting reporting solutions, dashboards using OBIEE.
• Utilized OBIEE Agent services to share the reports with the business users.
• Deploying models and reports from Development to Production and administering users/groups/roles.
• Worked with DBA in creating aggregate tables and Indexes to increase the performance and meet the requirements for performance analysis and tuning the report.
• Tested the reports with various testing methodologies like Functional testing, Regression testing and UAT.
• Experience working with onshore-offshore model.

Environment: OBIEE, Oracle EBS R12, Oracle Data Integrator (ODI)

Confidential, PHOENIX, AZ

SR BUSINESS INTELLIGENCE DEVELOPER

Responsibilities:

• Worked on decommissioning existing MicroStrategy reporting structure and migrating the reports/dashboards to OBIEE.
• Worked closely with business analysts and end users to analyze the business process and user requirements to cater their needs for reports.
• Participated in meetings amongst functional analysts, developers, and database administrators to ensure database designs provides appropriate levels of accuracy, flexibility, performance, and customer satisfaction as required by business rules and end-user agreements.
• Designed and Developed Reports for Accounting & Finance, Supply Chain, Marketing, Retail teams using OBIEE.
• Created Star/Snowflake models in RPD layer to achieve the modeling required by the reporting structure.
• Created hierarchies, levels for drill down functionality using RPD.
• Extensively used different kinds of variables in the modeling and reporting structures.
• Developing reports interactively using multiple widgets on the dashboard.
• Developed list reports, cross tab reports, chart reports, reports with multiple prompts, cascading prompts, and filters.
• Created complex reports-dashboard reports, Conditional blocks, master detail reports, drill through reports, and burst reports.
• Used features like HTML, Presentation Variables, Prompts, Cascading prompts, Conditional Formatting and Style Formatting.
• Experienced in migrating repositories across development, testing and production environments.
• Performed optimization on the existing reports to decrease the run time to meet the real time requirements and made changes to the existing reports for good look and feel for the users.
• Documented all requirements document, technical document, Unit Test process document and User’s approval documents and preserved them in SharePoint/Shared drive for use by others and for future references.

Environment: OBIEE 11g, MicroStrategy, Teradata, Oracle

Confidential, ROCKVILLE, MD

LEAD BUSINESS INTELLIGENCE DEVELOPER

Responsibilities:

• Experience in working directly with the end users, gathering business requirements, and preparing BRD’s and involved in preparing Data Dictionary
• Interact with the Line of Business (LOB’s) for requirement gathering by participating in Joint Application design/development sessions to understand and document business requirements and development process.
• Experience working with Out of the box Oracle BI Applications Supply Chain & Order Management modules.
• Worked with Stored Procedure Query and Direct SQL reports.
• Led the effort to identify and address the existing issues in the ETL process and implement new enhancements.
• Decommissioned reporting based on SQL packages, migrated to ETL process using Informatica.
• Created various List Reports, Cross Tab Reports, Chart Reports, Drill-Down Reports etc using the tables based on the new ETL process.
• Worked on migrating existing reports based on custom VBA applications to OBIEE.
• Created Complex reports using various prompts like Date & Time Prompts, Text Box Prompts, Cascading prompts etc.
• Created Conditional Block reports to dynamically hide or show reports objects and provide the end user the option to view the data in different formats.
• Extensively used BI Publisher to generate reports and schedules.
• Created many BI Publisher reports using Excel & Word templates including multi-tabbed reports using Excel.
• Migrated existing Excel macro reports into BI Publisher reports using Excel template.
• Implemented Write-Back functionality for ad-hoc reporting.
• Provided training to different business users to develop reports ad-hoc.
• Training and guiding end users to help understand BI reports and reporting parameters.
• Responsible for migrating OBIEE report, BI Publisher reports, ETL across development, testing & production environments.
• Experience working with onshore-offshore model. Led the offshore team to support the project 24x7.

Environment: OBIEE, OBIA, Informatica, Oracle, Oracle EBS, BI Publisher, SQL Developer

Confidential, MERRIMACK, NH

BUSINESS INTELLIGENCE DEVELOPER

Responsibilities:

• Interacted with Business Users to prepare and update the Business Process Requirements and Software System Requirements.
• Effective involvement in Analysis and Design Phases, Enterprise reporting design, estimation, and development.
• Implementation of custom OBIEE reports for Fidelity’s Investment business.
• Designed the Logical model that conforms to Data Modeling (Star schema, Snowflake schema concepts) as per Business requirement.
• Worked with the Data Warehousing team to create the necessary models and identify certain enhancement requirements.
• Created reports, dashboards using different kinds of views, graphs, charts etc.
• Worked on creating ad-hoc space for the users to create their own reports.
• Provided training to different business users to develop reports ad-hoc.

Environment: OBIEE, Oracle, SQL Developer

Confidential, BOSTON, MA

BUSINESS INTELLIGENCE DEVELOPER

Responsibilities:

• Analyzing Requirement Specification document and preparing the Technical Specification document as per the Business requirement.
• Experience in different phases of software development life cycle (SDLC) including analysis, design, development, testing and production.
• Acted as the Liaison between the business and the development team.
• Ran all the requirement gathering and validation sessions with the business teams.
• Implemented OBIEE custom reports using Noetix views.
• Development plan included RPD development and building reports on historical and real-time data (Noetix views and Analytics).
• Created multiple complex lists, cross tab, and chart reports, which involved lot of conditional formatting and different report outputs which include Excel, PDF, and HTML.
• Designed summary and detail reports which involves the key functionalities like conditional blocks, conditional layouts. Designed reports which involve drill down functionalities in OBIEE.
• Experience in working with Noetix DBAs to modify/fix the Noetix views required for OBIEE reporting.
• Worked with Noetix based BI Apps to create historical reports. Used Agents to run the reports on a daily/weekly basis.
• Unit testing, Integration testing and System testing of the reports in development, testing, and production environments.
• Maintained the configuration and change control of all application environments and associated documentation.
• Bug fixes the existing reports and problem resolution to the issues raised by the users.

Environment: OBIEE, Noetix Views, SQL Developer

Confidential, BRAINTREE, MA

BUSINESS INTELLIGENCE DEVELOPER

Responsibilities:

• Interacted with Business Users to prepare and update the Business Process Requirements and Software System Requirements.
• Effective involvement in Analysis and Design Phases, Enterprise reporting design and development.
• Supported existing Oracle BI Applications Supply Chain & HR Modules, which included fixing existing/new issues.
• Created new reports based on custom EBS forms.
• Supported ETL by monitoring jobs regularly and fixing when needed.
• Prepare Project Plan and other Quality Documents and Knowledge transition.
• Responsible for analysis of the service requests, Problem Identification and fixing the root-causes, and for Requirements gathering and Resolving Issues.

Environment: OBIEE, OBIA, Informatica, Oracle EBS

Confidential, BOSTON, MA

BUSINESS INTELLIGENCE DEVELOPER

Responsibilities:

• Interacted with Business Users to prepare and update the Business Process Requirements and Software System Requirements.
• Effective involvement in Analysis and Design Phases, Enterprise reporting design and development.
• Implemented Custom OBIEE reporting using Oracle Project Accounting module.
• Designed the Logical model that conforms to Data Modeling (Star schema, Snowflake schema concepts) as per Business requirement.
• Extensively used Presentation and Repository Variables to achieve the desired functionalities.
• Responsible for analysis of the service requests, Problem Identification and fixing the root-causes, and for Requirements gathering and Resolving Issues.

Environment: OBIEE, Oracle EBS

Confidential, MA

BUSINESS INTELLIGENCE DEVELOPER

Responsibilities:

• Worked with a multitude of clients to successfully implement and maintain BI reporting strategies using OBIEE, Informatica, Oracle BI Applications.
• Interacted with Business Users to prepare and update the Business Process Requirements and Software System Requirements.
• Acted as the Liaison between the business and the development team.
• Effective involvement in Analysis and Design Phases, Enterprise reporting design and development.
• Experience in implementing/maintaining BI reporting with Oracle General Ledger, Financials, Supply Chain modules.
• Created/Modified out of the box Oracle BI Applications reports and custom reports.
• Worked on maintaining the ETL structures using Informatica.
• Designed the Logical model that conforms to Data Modeling (Star schema, Snowflake schema concepts) as per Business requirement.
• Responsible for analysis of the service requests, Problem Identification and fixing the root-causes, and for Requirements gathering and Resolving Issues.
• Experience working with onshore-offshore model.

Environment: OBIEE, Oracle EBS, Informatica, Oracle, SQL Developer, BI Publisher