SUMMARY:

IT Professional with over 6 years of experience as a Business Analyst acting as a liaison between the business and the technical teams across global teams. Worked closely with management on assigned projects from inception through implementation to ensure adequate internal communication between end user and developer. Comprehensive knowledge of Software Development Life Cycle (SDLC), having thorough understanding of its various methodologies like Waterfall and Agile. Interface regularly with all levels of Management, Internal and External product Vendors. Expert (SME) in different techniques like Brainstorming, JAD sessions, Focus groups, Question and Answer sessions, and shadowing. Knowledge of Project Life cycle with Business Analysis, Project Planning, Workflow, Execution and control with ability to support multiple simultaneous short and long - term projects.

PROFESSIONAL EXPERIENCE:

Business Analyst

Confidential

• Worked as an Interface between the users and the different teams involved in the application development for better understanding of the business and IT processes.
• Analyzed Business Requirements from Black Box testing perspective. Reviewed Test Strategy and Test Plans to ensure that test cases reflect user needs for the functional, User Interface, Performance, Usability and Security requirements.
• Followed a structured approach to organize requirements into logical groupings of essential business processes, business rules, and information needs, and ensure that critical requirements are not missed.
• Followed the UML based methods using Rational Rose to create: Use Cases, Activity Diagrams, Sequence Diagrams, Collaboration Diagrams.
• Coordinated work plan between project manager and client with Microsoft Project; Implemented and managed migration process & developer fixes; Retested fixes; Scheduled and tracked progress for team members of project through completion.
• Prepared basic SQL test scripts analyzing complex test scenarios and conducted System Integrated Testing (SIT), User Acceptance Testing (UAT).
• Established Incident Reporting and Change Control procedures using Clear Quest.

Business Analyst

Confidential

• Gather the various reporting requirement from the business analysts.
• Gather all the Sales analysis report prototypes from the business analysts belonging to different Business units; Participated in JAD sessions involving the discussion of various reporting needs.
• Reverse engineered the reports and identified the Data Elements (in the source systems), Dimensions, Facts and Measures required for new enhancements of reports.
• Conduct Design discussions and meetings to come out with the appropriate
• Data Mart at the lowest level of grain for each of the Dimensions involved.
• Designed a STAR schema for the detailed data marts and Plan data marts involving confirmed dimensions.
• Created and maintained the Data Model repository as per company standards.
• Conduct Design reviews with the business analysts and content developers to create a proof of concept for the reports.
• Participated in modeling activities including building the star schema as per the business requirements and configuration of Logical layer, Logical tables, dimensions and columns
• Created dimension hierarchies and assigned keys for each level required to support drill-down aggregation.
• Created the repository using Administration tool by importing tables into the Physical layer and the Business and Mapping model to in corporate the business logic.
• Development, importing data into the physical layer, modeling it in the business modeling and mapping (BMM) layer, aggregation, time series modeling, calculation wizards, dimension hierarchies, managing session and repository variables, creating users and adding groups for security, deploying the repository to the presentation services.

Mortgage Business Analyst

Confidential

• Interacted with Business Analysts and users in gathering and analyzing and designing the reports and dashboards.
• Developed the 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.
• Used AIM methodology in creating clear, concise use instructions as well as accurately documenting processes and application development.
• Created connection pools, alias tables, joins in the physical layer of RPD.
• Used the visual analyzer /Data Visualization Desktop tool to prepare data sources, create visualizations, and narrate stories with presentations, in OBIEE 12c.
• Created report projects from flat files (Excel spread sheets, CSV files) using visual analyzer /Data Visualization Desktop.
• Developed custom reports queries using OBIEE Answers and assigned them to application specific dashboards
• Performed Performance Tuning of Dashboards / Reports by aggregate navigation, cache management, and Oracle materialized views and making changes to reports.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Utilized the capability of repository and session variables in the catalog.
• Designed, Developed, Tested and Maintained BI Publisher reports and supported all aspects of Oracle BIP report development in support of information sharing and application development initiatives.
• Worked with the interactive reporting online using BIP tool and delivered the output in various formats like HTML, PDF, excel files.
• Developed custom reports queries using OBIEE Answers and assigned them to application specific dashboards.

IT Support Specialist

Confidential

• Supported multiple field offices, delivered personnel handheld support and execution/implementation of strategic IT directives of IT director and executive team.
• Performed general technical support and troubleshooting of desktop systems hardware and software, local telephony, in-truck tablets, multi-function printers, scanners, mobile devices and tank monitors.
• Manage company wide support requests, following up until completion
• Constantly handled changing flow of requests, was able to multitask effectively and presented excellent time management skills
• Set up accounts and hardware for incoming hires and tearing down the same for departing employees building accounts, imaging and deploying hardware, retrieving hardware.
• Setting up, monitoring, and troubleshooting of audio-visual systems for company meetings, events, conference rooms, and guest speakers. AV and meeting support experience a plus.
• Assisted the team with basic inventory and stock room tasks and scanning delivered hardware into inventory