OBJECTIVE:

Seeking a position in a challenging organization which will expand my skill set and knowledge base resulting in a overall development of the organization.

SUMMARY:

• 10 years of total experience in Business Analysis, OBIEE and Tableau Dashboards and Report development and Project Management.
• Conducted weekly MRA Café sessions where business users from various financial groups discuss their current and future reporting requirements.
• Followed the SDLC process in the implementation of various dashboards and reports.
• Work closely with business users to formalize a business idea and define requirements
• Analyze gathered requirements data, verify requirements and create business requirement specifications documents (BRS) and functional requirement document.
• Define processes and tools best suited to each project. Move between Agile and Waterfall approaches depending on project specifics and client goals
• Conducted daily Scrum Calls to track the progress of the project and also to eliminate risks.
• Create User stories and acceptance criteria
• Assists the Scrum Team in developing the Sprint Backlog
• Create detailed project road maps, plans, schedules and work breakdown structures
• Expertise in designing and development of OBIEE Repository (OBIEE 10g and 11g).
• Strong experience in providing end - to-end business intelligence solution by configuring metadata and building OBIEE Repository consisting of three layers (Physical Layer, Business Model & Presentation Layer).
• Responsible for planning, scoping and following up of this project.
• Explain about the status, progress and issues in the simplest and concise terms to the Management
• Validate and verify that business, stakeholder, functional and non-functional requirements are satisfied by the technology solution
• Work with Development and QA teams to transition business requirements into QA test cases and assist in UAT.
• Experience in managing the OBIEE technical team.
• Prioritize reporting requirements from various Corporate Finance and Planning Teams and ensure timely delivery of all the dashboards and reports.
• Develop a project plan based on details contained in the Business Requirement Specification and also a project plan to schedule and assign work and manage the project.
• Developed test cases and participated in UAT (User Acceptance Testing). .
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using OBIEE.
• Excellent ability to understand and analyze the client requirements.

TECHNICAL SKILLS:

CRM/Warehouse: OBIEE 10g/ 11g, Tableau 9.2, Siebel Analytics, Siebel Answers, Oracle BI Server, Oracle BI Scheduler, BI Publisher and familiar with Informatica 7.1.2/6.2.1 Designer/OEM Workflow Manager, Tableau

RDBMS: Oracle7.x/ 8i/9.i, 10g,11g SQL Server (2005, 2008) and MS-Access.

Scripting: HTML.

Languages: C/C++, PL/SQL.

Operating Systems: Windows2000/NT4.0/98/95,UNIX & MS-DOS, Sun Solaris.

Design & Other Tools: MS Project, Microsoft Visio, MS Word, Power Point, Excel, TOAD

PROFESSIONAL EXPERIENCE:

Confidential

Senior Business Analyst, Charlotte, NC

Responsibilities:

• Interact with the various Corporate Finance and Planning Analysis (CFP&A) business units to understand their current and future reporting requirements and document them.
• Act as a liaison between the IT and the business
• Analyze gathered requirements data, verify requirements and create business requirement specifications documents (BRS) and functional requirement document.
• Followed the SDLC process in the implementation of various dashboards and reports.
• Moved between agile and waterfall approaches depending on project specifics and client goals, creating detailed project road maps, plans, and work breakdown structures
• Worked Extensively on Oracle BI Answers, and Oracle BI Interactive Dashboards and Tableau Reports and Dashboards.
• Ensured that the Scrum board and the Impediment Log remain updated
• Conduct weekly MRA Café sessions where business users from various financial groups discuss their current and future reporting requirements.
• Conducted daily Scrum Calls to track the progress of the project and also to eliminate risks.
• Create User stories and acceptance criteria
• Responsible for planning, scoping and following up of this project.
• Explain about the status, progress and issues in the simplest and concise terms to the Management
• Create detailed project road maps, plans, schedules and work breakdown structures
• Develop various Dashboards and Reports for the Finance Management and Information Delivery (FMID) team using OBIEE 10g and 11g
• Translate high level business requirements into detailed functional specifications
• Worked in automating Client P&L reports from Smart View to OBIEE and Tableau dashboards
• Provide training to different financial business units on how to use OBIEE and Tableau Dashboards and Reports.
• Work on breaking down reporting requirements into different sprints using the agile methodology.
• Work with Development and QA teams to transition business requirements into QA test cases
• Develop ad-hoc reports for the various financial users using OBIEE answers
• Translate the reporting requirements into business requirements and work with the IT Partners during the OBIEE rpd build.
• Develop test cases and participate in UAT (User Acceptance Testing)
• Demo the capabilities of OBIEE reporting to the executive management of various business units
• Built the Service Provider and Service Receiver dashboard which gives a detailed analysis of the cost allocations for the various business units.
• Work with the FMID data management team to automate some of their manually generated reports using OBIEE.
• Knowledge transfer to resources on how to build effective/efficient dashboards.
• Work closely on the requirements, progress, scoping and deliverables.

Environment: Oracle Business Intelligence 10.1.x/11.1.x, Tableau, SQL Server 2000/2005, Oracle 9i/10g, Essbase Cubes

Confidential

Responsibilities:

• Work with the FMID/MRA senior management to understand the requirements for the SharePoint site.
• Strategize on the goals and design for the FMID site.
• Ensure that the project is delivered on-time, within scope and within budget
• Gather requirements from the various FMID members on what information to be displayed.
• Assist in the definition of project scope and objectives, involving all relevant stakeholders and ensuring technical feasibility
• Manage changes to the project scope, project schedule, and project costs using appropriate verification techniques.
• Perform risk management to minimize project risks

Confidential

BI Business Analyst, Indianapolis, IN

Responsibilities:

• Worked in the design and development of dimensional data model and metadata layer with OBIEE for Immunization program
• Assisted the technical team in developing dashboards and various reports using OBIEE
• Conducted daily Scrum Calls to track the progress of the project and also to eliminate risks.
• Worked with different members of the scrum board to eliminate risks
• Interact with the business clients and gather all the report requirements and communicate that with the BI technical team.
• Part of the Scrum Core Team to provide lessons from the current project.
• Lead the OBIEE and ETL team of Immunization division.
• Design, develop and implement reports using Immunization data model in conjunction with business intelligence solutions created at Confidential using OBIEE
• Developed various dashboards and reports in the OBI Answers
• Responsible for planning, scoping and following up of this project.
• Explain about the status, progress and issues in the simplest and concise terms to the Management
• Validate and verify that business, stakeholder, functional and non-functional requirements are satisfied by the technology solution
• Knowledge transfer and train Immunization developer team and resources in how to build effective/efficient dashboards.
• Develop test cases and participate in UAT
• Created users table, groups table and user-groups table to implement security for various users.
• Assisted in scheduling iBots to the users as per the requirements.
• Created various presentation variables in BI answers as per the requirements.
• Configured Repository, Session variables to generate dynamic reports
• Defined Primary key-Foreign key relationships, bridge tables between dimension tables and Fact tables in the physical layer

Environment: Oracle Business Intelligence 10.1.x/ 11.1.x, Data Warehousing, SQL Server 2000/2005, Oracle 9i/10g, Oracle Data Integrator.

Lean Six Sigma Project Manager

Confidential

Responsibilities:

• Meet with the Immunization Dept. Director and the Program Manager regarding the data quality issues.
• Responsible for planning, scoping and following up of this project.
• Explain about the status, progress and issues in the simplest and concise terms to the Immunization committee which includes: Asst. State Health Commissioner, Director of IT, CHIRP registry manager and the lean six sigma green belt members.
• Track the progress made by each team member and reviewing the weekly status reports.
• Follow the Lean Six steps and outline the step by step process that was being carried out in setting up import accounts and the process that was used by providers to send the data.
• Communicating to the team on the issues related to the current process and outlining steps to revamp the import process.
• Managed the entire life cycle of the EMR project.
• Worked on project resource estimation, time and cost estimation and issues documentation.
• Explain all the complex technical details about the HL7 VXU messages to the immunization staff in a simple and a concise manner.
• Documenting all the progress being made and also keep a track of all the issues.
• Work with the Mirth developer and review, track and document the progress.
• Communicate with the director on the progress and the issues regarding the MIRTH channel.
• Work with the MIRTH developer and assist him in terms of CHIRP database.
• Prioritize the goals and tasks for the green belt lean six sigma team.
• Test all the error emails from the MIRTH channel to make sure that it is picking up the right imports, correct facilities, correct locations and the right error count.
• Discuss with the MIRTH developer during the development phase regarding the errors that are coming through the channel and work with him in resolving such issues
• Set up the process for the phase by phase roll out of the project to the providers.

Confidential

OBIEE Business Analyst, St. Louis, MO

Responsibilities:

• Analyzed the functional specification provided by the data architect and created technical specification for the mapping.
• Interact with the business clients and gather all the report requirements
• Creating hierarchies and new logical columns as per the business requirements.
• Organizing the presentation layer (.RPD) in a format that is easy for end user to use as basis for reporting.
• Implemented OBIEE security at the data and object levels.
• Utilized variables and initialization blocks in the repository.
• Implemented caching to increase performance.
• Creating the Oracle BI Interactive Dashboards, Pages and the requests.
• Creating the reports with embedding the Column selectors, charts.
• Worked on the OLAP Cubes.
• Troubleshooting all the issues related to OBIEE server
• Debug and optimize the OBIEE Dashboards / Reports.
• Worked on WEBCAT(Catalog stores content created with Dashboards, Answers, Delivers)
• Configured the OBIEE scheduler for integration with the email systems to send the alerts.
• Created new mappings and updating old mappings according to changes in Business logic.
• Developed and modified the SDE mappings to extract the data from Siebel OLTP application to staging area.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.
• Used BI Publisher to create reports as per the user’s requirements.
• Executed SQL queries using joints to retrieve data from multiple tables using TOAD to check database values.
• Taking the backup of repository on regular intervals depending on the amount of work done.
• Scheduling iBots to the user as per the requirements.
• Defect tracking, defect reporting and summary report analysis using test director.
• Constructively interacted with business and system analyst team members to produce quality applications.

Environment: Oracle Business Intelligence 10.1.x, Data Warehousing, SQL Server 2000/2005, Oracle 9i/10g.

Confidential

Intern

Responsibilities:

• Communicated with clients regarding system requirements, ensuring the development and implementation of customized products to customer satisfaction
• Prepared functional specifications for user requirements
• Developed and modified applications, authored database procedures and triggers for data processing.
• Created entry forms/reports for various modules.
• Created Tables, Indexes, Table Spaces, Views synonyms, and integrity constraints
• Involved in creation of schema objects, roles and privileges, users
• Prepared User manual, Technical documents for the end user
• Maintenance and support for the system. Involved in end user training