SUMMARY:

• Motivated, analytical and self - directed Senior Business Analyst with over 7 years of experience in the IT, HealthCare and financial domains. Strengths include strong business analysis and problem solving skills with the ability to successfully manage multiple projects with varying priorities.
• Proven skills in Business Analysis, Planning, Process Management, Customer Relationship Management (CRM), Change Management, Software Development & Implementation Management in diverse business & technical environments, with demonstrated leadership abilities and excellent communication skills
• Expertise lies in Data warehousing, Data Migration, Data Mining, Data Integration, Data Mapping, documentation and reporting of very large data.
• Experienced validating XML schemas adhering to specific data types, and created diagrams to graphically represent XML schema for better understanding of the data type and its validation.
• Expertise in Business Process Reengineering Initiatives, Continuous Improvement Initiatives, conducting Joint Requirements Planning (JRP) Sessions and Joint application development (JAD) sessions as a Facilitator to gather requirements from a group.
• Developed and iterated a full compendium of requirements for the portal, including a business requirements document, iRise simulation, and complete set of use cases.
• UX design experience in multiple projects - from conception, branding, wire framing to prototyping / testing
• Conducting daily scrum meetings and solving problems faced by teams
• Efficient knowledge on BRD and FSD
• Working experience of Java, HTML and SQL among other technologies
• Expert in writing Functional and non-functional requirements
• Expert in identifying gaps, which require operational change in order to optimize system solutions by GAP analysis.
• Experience in working with SOW
• Proactively identify Salesforce automation opportunities including 3rd party solutions and recommend process improvements to drive operational efficiency
• Support the Salesforce development pipeline by writing technical stories, completing UAT and managing feature releases and training
• Experienced in conducting User Acceptance Testing and coordinating with the UAT participants to gather the requirements.
• Proficient in Acting as liaison between management and development team and QA team for requirements and conducted JAD sessions.
• Proficient in creating Use Case diagrams, Class diagrams, Sequence Diagrams, Collaboration diagrams and Activity Diagrams using UML methodology in MS Visio.
• Extensive experience on Excel, Word, PowerPoint, MS Project, MS Visio, and Rational Suite.
• Strong customer/user advocate, apt negotiator with excellent analytical, communication, decision-making and organization skills

TECHNICAL SKILLS:

Platforms: Windows XP/ NT/ 2000, Unix

Testing tools: Quality Center

Languages: SQL, C, C++, .Net, APEX,HTML

Office Tools: MS Word, Excel, Outlook, PowerPoint

Technologies and Tools: UNIX, Facets,Visualforce Pages,Apex Class.Apex Triggers

Business Modeling Tools: Project Management Tools, Rational Suite (RUP, Rose, Requisite Pro, Clear Quest, Clear Case), Touch Point, Agile, UML, MS Project, Microsoft Office tools- Visio, Outlook, Word, Excel, PowerPoint, Technical Report writing, BRD

Version Control Systems: SharePoint

Database: MS Access, MS SQL Server, Oracle, Teradata

PROFESSIONAL EXPERIENCE:

Confidential, San Antonio, TX

Sr. Business Analyst

Responsibilities:

• Gathering and documenting of business requirement to support key enterprise projects and project team members.
• Identify and promoting process improvement opportunities for gathering requirements.
• Create and maintain Requirement Traceability Matrix (RTM) and Customer Requirement Template (CRT) for each of the assigned project.
• Developed Request for Proposal (RFP).
• Scope and access each project impacts from each Grouping and perform Risk Analysis from Subject Matter Experts.
• Update and create/develop Use Cases based on Project impact.
• Update and create process flow diagrams and sync up those diagrams with IT team for accuracy and maintain for future references.
• Perform GAP analysis between the current system and future system to make sure all the data elements to perform the business have been taken care of.
• Conduct JAD sessions with Business and IT Matrix partners to support all the business needs and requirements.
• Facilitating review of complete business requirement with stakeholders, business functional and IT partners in order to secure buy-in-sign-off requirement deliverables.
• Supporting and development of Functional Requirement and system design to ensure that they meet defined business and project objectives.
• Convert business goals to reports and dashboards.
• General administration in Salesforce.com including, maintaining user accounts, bulk data updates, territory management, reporting, analysis and other day-to-day tasks
• Designing and developing APEX classes, APEX triggers, Apex Web services, integration, Custom Controllers, Controller extensions.
• Working on SOW with specifiactions, deliverables,performance data, Period of performance.
• Support change controls of projects that comes in during and/or after the project being implemented.
• Make sure all the internal (Management) as well as external (Client facing) reporting requirements are met during detail requirement and validate that reporting requirement meets the project and business needs.

Environment: MS Visio, MS Office suite, Java, JavaScript, HTML, Oracle, MS project, MS Access, SQL

Sr. Business Analyst

Responsibilities:

• Gathering and documenting of business requirement to support key enterprise projects and project team members.
• Supporting and development of Functional Requirement and system design to ensure that they meet defined business and project objectives.
• Support change controls of projects that comes in during and/or after the project being implemented. Created complex SQL stored procedures and functions using Microsoft SQL Server 2008R2
• Involved in code review and code review meetings
• Involved in error handling, performance tuning of stored procedures
• Used Team Foundation Server for version control needs, track check-ins and roll back code as necessary
• Coordinated with Technical Analysts in understanding the business requirements and translated them in to technical specifications
• Analyzed the data as per business needs to build the Interface.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Created Views and Index Views to reduce database complexities for the end users.
• Modified existing databases by adding/removing tables there by altering referential integrity, primary key constraints and relationships according to requirements
• Deploy changes from SFDC sandbox environment to Production environment using change sets.
• Developing Visualforce pages, Visualforce custom components, portal pages with JavaScript and ExtJS for validation.
• Make sure all the internal (Management) as well as external (Client facing) reporting requirements are met during detail requirement and validate that reporting requirement meets the project and business needs.
• Implemented pick lists, dependent pick lists, lookups, master detail relationships, validation and formula fields to the custom objects.
• Successfully deployed SSIS Package into Production environment and used Package configuration to export various package properties to make package environment independent.
• Developed Scheduled Jobs to automate the packages.

Environment: ASP.NET, C#, MS Visio, MS Office suite, SQL Server 2005, Visio, Crystal Reports 10, HTML, CSS 10, HTML, CSS, SQL

Sr. Business Analyst

Responsibilities:

• Facilitated JAD (Joint Application Design) sessions and coordinated extensive communication networks (interviews, written correspondence, reports, implementation requirements, project status reports, oral presentations, e-mails, etc.) to keep executive staff and team members apprised of goals, project status, and resolving issues and conflicts.
• Elicited and gathered user and business requirements through open ended discussions, brainstorming and storyboarding/storyboarding/prototyping.
• Recorded project plans, Business Requirement Document, Business Specification Document and data models for the iteration.
• Interacted with the stakeholders, Business users, system architects, developers to understanding data model and structural data hierarchy.
• Translated business requirements into functional and Non-functional specifications to communicate with development team.
• Analyzed business requirements and segregated them into high level and low level Use Cases, Activity Diagrams and Sequence Diagrams using Rational Rose according to UML methodology.
• Recorded project changes on a weekly basis using change data to update the project plan and provide up-to-date information for project status reporting.
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Formulated test plans, test scenarios and test cases for core subsystems.
• Interaction with SMEs, understand business needs and determine technical solutions. Identifying use cases, system documentation in the form of written narratives and flowcharts (activity diagrams).
• Assisted in enhancement of training materials for new technology and process improvements.
• Identified and documented best practices for the product offering and provided analytical support and problem resolution for existing customers.
• Assisted quality assurance team in testing different releases and in designing test plans and test cases. Performed User Acceptance Testing (UAT)
• Developed Project Status Metrics for weekly evaluation of Project Status and analyzed the impact of the open issues and Change Request on the Project Plan.

Environment: MS Office, Rational RequisitePro, Clear Quest, Microsoft Excel, MS Visio, Crystal Reports.

Business Analyst

Responsibilities:

• Interviewed SMEs and Stakeholders to get a better understanding of client business processes and gather business requirements
• Conducted controlled brainstorming sessions with project focus groups for collecting high level business requirements
• Designed and implemented appropriate ETL mappings to extract and transform data from various sources to meet requirements
• Documented high level requirements by writing migration BRD, Prepared Provider Migration BRD
• Conducted several Requirement Gathering Sessions for gaining detailed requirements and finalizing Business Requirement Document (BRD)
• Involved in the ETL design and its documentation
• Involved in Data Mapping, field mapping of the data elements responsible for the migration BRD
• Used SQL for querying and analysis purposes on various source tables and conditions applied
• Performed GAP analysis of business rules, business and system process flows, user administration to be used for the new migration platform
• Experience in SOA including WSDL, XML, and / or SOAP messaging, MQ Series messaging
• Participated in the application scrum meetings and the sessions
• Requirement gathering, Business Process flow development, and Business Analysis
• Design, develop and deploy Business Processes Orchestrated in BPEL and Mediator using Oracle JDeveloper and SOA Suite 11g
• Created and maintained a project schedule using MS Project showing all target dates for deliverables
• Worked with the project manager for planning and organizing the project activities, and in communicating with other business center mangers and stakeholders of the project
• Validated the following: 837 (Health Care Claims or Encounters), 835 (Health Care Claims payment/ Remittance), 270/271 (Eligibility request/Response), 834 (Enrollment/Dis-enrollment to a health plan)
• Identified gaps in the business process.

Environment: Oracle 10g, MS Project, MS Access, Lotus Notes, MS office 2010, Sql Loader, SQL server 2005

Business Analyst

Responsibilities:

• Participated in all the phases in the project management life cycle
• Acted as a liaison between the business users and technical teams to enhance the applications based on the business requirements
• Provided a single point of contact for user communication, managed issue tracking, prioritization and resolution
• Helped in the development of the scope document that defines the primary goals and objectives
• Worked closely with the business users to gather the high-level user requirements and functional requirements
• Aligned properties in SOA environment like BPEL properties, SOA infrastructure properties and mediator service engine properties
• Developed functional requirements and specifications
• Organized meetings and worked together with the PM to during the various stages of project planning
• Developed use cases to explain / demonstrate business requirements / specifications to the IT team
• Refined the requirements (use-cases) and Business Process Models to detailed level requirement appropriate for technical analysis and system design
• Participated in various sessions to define the solution approaches, and identifying assumptions, constraints, risk and issues
• Revealed unidentified requirements, evaluated changes in requirements, and assessed impact of changes
• Recommended process or system changes intended to eliminate identified risks or gaps
• Provided regular verbal and written status reports to IT management team
• Published meeting minutes and maintained project plans
• Coordinated with the project team and testing team to revise project artifacts (such as use-case specifications, test scripts, and so on) to reflect requirement changes
• Worked independently with minimum supervision as part of a dynamic IT team

Environment: Windows XP, Quality Center, MS Visio, SharePoint, MS Office, MS Word, MS Project, MS PowerPoint, MS Excel

Business Analyst

Responsibilities:

• Worked with the SME’s (Subject Matter Experts), Business users, development teams, software architects to identify the key changes, and participated in Health Management to communicate effectively with them.
• Wrote and maintained Business Requirement Document and then converted business requirements into Functional Requirements Specification to analyze and optimize the process.
• Created and managed project templates, Use Case templates, requirement types and traceability relationships in Rational RequisitePro.
• Experience in Deploying SOA Composite applications, monitoring composite instances and recovery for faulted messages
• Testing, Debugging, Validation and Performance Tuning of ETL Architecture, developing optimum solutions for Informatica deliverables and performed Unit testing
• Used the Unified Change Management (UCM) tool, Rational Clear Quest to maintain and track the stakeholders requested enhancements and changes.
• Understanding of ETL test processes and software testing methodologies.
• Used Rational ClearCase, a Configuration Management tool, to maintain different builds of the application with description about all changes and versions.
• Tuning and configuring Oracle SOA Suite 11g environment for high availability and failover
• Used Rational Rose to create, analyze and implement use case diagrams,
• Created Use Cases using UML and managed the entire functional requirements life cycle using Rational Unified Process and Rational Rose.
• Created product documentation including online help, printed user manuals, and training materials.
• Scheduled meetings with developers, system analyst’s (SA) and testers to identify resource allocation and project completion using MS Project.

Environment: Rational RequisitePro, Rational Rose, Rational Clear Quest, Crystal Reports, MS Project, UML, MS Excel, Power Point, MS Word, MS-Project, MS Office.

BI Analyst

Responsibilities:

• Designed and developed Universe using Business Objects 5.5
• Developed complex universe using advance features in Business Objects like LOVs (List of Values) and prompts.
• Involved in resolving the loops using Aliases and Contexts
• Documented the requirement specification and the changes made to universe for future reference.
• Creating Dimensions and Facts in the physical data model.
• Documented the metadata to capture from the sources
• Created Work Flow Sessions and batches to extract the data.
• Created mappings using Power Center Designer to extract, cleaning, transforming and loading data
• Involved in the creation of jobs using work flow manager to validate schedule run and monitor the jobs.
• Involved in designing the procedures for getting the data from all systems to Data Warehousing system.
• Information is stored in table definitions in the repository and is entered using the Repository Manager.

Environment: Business Objects 5.5 (Supervisor, Designer, Reporter, Desktop Intelligence, Web Intelligence, CMC & Info View), MS Access, SQL, XML and Windows Server

Business Objects Analyst

Responsibilities:

• Worked with the Business analysts, end users, Data Modelers and the DBA for requirements gathering, business analysis, and testing, project coordination.
• Involved in the discussion with Business analysts, Data Modelers, DBA and End Users for requirement gathering, project coordination and testing.
• Created Universes, Business objects products, stored procedures, Repository and Document domains.
• Created User groups, Users, Database connections.
• Created new reports from the scratch for new requirements and modified some of the existing reports.
• Involved in creating new objects, filters and complex measure objects in the universe.
• Involved in creating new views and Aggregate tables for report performance.
• Involved in training sessions for end users about using Business Objects Full client version and creating ad-hoc reports.
• Involved in Migrating Objects from Development to Production and having strong experience trouble shooting skills.
• Involved with testing team to derive test cases for efficient Data reporting.
• Involved in creating Master/Detail, cross tab and chart (for trend analysis) reports.
• Involved in documentation of all the requirements and the changes made to universe for future reference.

Environment: Business Objects 5.5 (Designer, Reporter, Desktop Intelligence, Web Intelligence, CMC & Info View), MS Access, SQL and Windows Server