SUMMARY:

• About 7 years of professional experience as a Business Analyst in a variety of industries with Extensive experience in analyzing, gathering requirements and writing system functional specifications including use cases.
• Excellent in Developing and evaluating business process models and ensure that the development team understands business requirements to guarantee the delivery of effective solutions that meet the business demand.
• Deep understanding of enterprise data warehouses.
• Strong experience in RUP Business Modeling Process.
• Expertise in UML (class diagrams, object diagrams, use case diagrams, state diagrams, sequence diagrams, activity diagrams, and collaboration diagrams) as a business analysis methodology for application functionality designs using IBM’s Rational Rose.
• Highly proficient in using advanced tools like MS Project, MS PowerPoint, MS office and MS Visio.
• Solid understanding of Business Process definition, Risk Analysis.
• Full life cycle Software Development (SDLC) experience including Analysis, Design and Review of Business and Software Requirement Specifications, Development and Testing.
• Key Team player in conducting Peer reviews, Brainstorming, walkthroughs sessions to confirm and playback business requirements for a project.
• Excellent quantitative and analytical skills combined with pragmatic interpersonal and communication skills.
• Experience in facilitating and moderating Joint Application Design (JAD).
• Proficient in technical writing & documentation such as Business Plan, Vision and scope document, User Requirements, Business Requirement, and Functional & Non Functional Requirements.
• Experience in writing SQL queries to retrieve information from databases.
• Experience in creating Requirements Traceability Matrix (RTM).
• Experience in creating test plan and test procedure development and review, project customization and administration, defect management, configuration management and version control, and also business documentation.
• Experience identifying, implementing and tracking organizational change management tasks.
• Coordinate business department with technical teams to resolve issues.
• Proficient in Unit Test Plans (UTP), Integrated Test Plans (ITP) Extensive experience in User Acceptance Testing (UAT).
• Assisted QA team in developing Test Scripts, Test Cases and Test Plans for the User Acceptance testing.
• In Depth understanding of the AS - IS and TO-BE business processes and experience in converting these requirements into technical specifications for preparing test plans.
• Excellent Analytical, methodical, and resourceful approach to problem solving, identifying and documenting root causes and corrective actions to meet short and long term business and system requirements.
• Exposure to Client/Server, Web Application developmental tools and Software development and design.
• Ability to manage (Multiple) project tasks with changing priorities and tight deadlines.
• Ability to work well in a team and open to Team related tasks, team meetings, team interaction and also conference calls.
• Translated and provided to end-users.
• Demonstrated ability to work well with a wide variety of people at various levels, foster cooperation and collaboration among individuals in the work unit.
• Help team to resolve conflicts constructively and ability to communicate when help is needed. A Self starter with a positive attitude, willingness to learn new concepts and acceptance of challenges.

TECHNICAL SKILLS:

Méthodologies: SDLC; Waterfall, Six Sigma (DMAIC), Spiral, Agile (RUP & XP tools, and SCRUM), LEAN Principles

System Platform: Windows 98/2000/XP/Vista/7 & Mac OSX

Business Management Tools: GAP, SWOT, MOST, RISK, ROI, COST-BENEFIT & IMPACT Analysis

Databases & DB Tools: MS SQL Server, Altova XMLSpy, TOAD, SQL Developer, SQL* Plus & MS Access

Business Process Modeling Tools: MS VISIO, RUP Tools

Test Tools: Manual Testing, User Acceptance Testing, HPQC

Documentation Tools: Share Point 2013, 2010, 2007, MS Office (Word/Excel/Power Point/ Visio/ Project), Rational Rose

Technologies & Languages: SQL, PL/SQL, UML, HTML, SOA (XML) & SOAP

PROFESSIONAL EXPERIENCE:

Confidential, Torrance, CA

Business System Analyst

Responsibilities:

• Implement best practices for master production scheduling, MRP, and production control.
• Gathered, documented high level project requirements and produced corresponding requirement artifacts such asBusiness Requirement Documents(BRD),Test Casesand all the affiliate artifacts likeUML diagrams (Use Case, Activity, and Sequence Diagrams).
• Develop and maintain close Manufacturing businessand IT relationship.
• Provide ERP process/application support and expertise.
• Conducted Gap Analysis to derive requirements for existing systems enhancements.
• Identified and documented different aspects of the system, which involved Web Services, Web Methods, and Data Mapping.
• Created test scripts and test cases iteratively to guarantee application meets the requirements.
• Facilitated the Design and development of Business Rule Engines to support SOA architecture and web services for both client side and server based validations. Created detailedUse Cases,andConducted User Acceptance Testing.
• Conduct system/process analysis to gather and document business requirements and functional requirements via workshops, questionnaires, surveys, site visits, workflow storyboards, use cases, scenarios, and other methods.
• Communicate application problems & issue to key stakeholders, incl. management, development teams, and other methods.
• Analyzes, defines and documents requirements for data, workflow, logical processes, interfaces with other systems, internal and external checks and controls and outputs.
• Design components, screen layouts, graphical user interfaces, printed outputs and interfaces with other systems.
• Provides technical assistance by responding to inquiries from others regarding errors, problems or questions about systems.
• Worked closely with System Architect to implement Service Oriented Architecture (SOA), Client side Validations, Server side Validations, Web Method definitions and data modeling using PL/SQL and SQL Server.
• Created and documented Standard Operating Procedures (SOP) for the generalized use in the projects.
• Writes documentation or reviews/maintains documentation written by others that describes installation and operating procedures.
• Worked closely with key customers to identify opportunities to improve and expand the use of businesssystems.
• Participated as a project team member on major systems initiatives, where your role would include system configuration, business& systems process analysis, development of functional specifications, all levels of systems testing and implementation.
• Assist in designing, planning and executing manufacturing process improvements.
• Understand and assist in managing cross-system process integration needs.
• Manage projects as assigned.
• Developed role-based security templates.
• Develop project plans specifying goals, strategy, resources, scheduling and identification of risks.
• Worked with Technical Services and Software Development to provide total solutions to our customers.
• Assisted with development of ongoing strategy for data management and reporting across any functional area.
• Managed Workflows, and project documentation using SharePoint 2010 & 2013.

Environment: Agile Scrum, UML, Use case, Activity, MS Visio, Windows 7, MS Office, SQL, Oracle, Webex, MS Visio, MS Project, SharePoint 2010 & 2013.

Confidential, Bethesda, MD

Business System Analyst

Responsibilities:

• Gathered, documented high level construction project requirements like raw materials, equipment and labor costs for an application that estimates project costsand produced corresponding requirement artifacts such asBusiness Requirement Documents(BRD),Test Casesand all the affiliate artifacts likeUML diagrams (Use Case, Activity, and Sequence Diagrams).
• Worked with Subject Matter Experts (SME) to determine requirements. Elicited the requirement using elicitation technique like Surveys, JAD, Brainstorming and Interviewing Sessions.
• Followed a structured approach to organize requirements into logical groupings and developed Business Requirement Documents (BRD) from essential Business Process, Business Rules, information needs and ensured that critical requirements are not missed.
• Worked with production staff to identify and map detailed current processes, identify gaps and failure points, perform Root Cause Analysis and develop functional requirements that supported overall strategy, goals and objectives.
• Assisted with user testing of systems, developed and maintained quality procedures and ensured that appropriate documentation was in place.
• Responsible for identifying and documenting Business Rules created detailed Use Cases and conducted User Acceptance Testing.
• Understand both concepts and details of the business objectives behind analyses and effectively communicate at either level.
• Identified and documented SOA aspects of the system, which involved Web services, Web Methods, and Data Mapping.
• Translate abundant and complex costing data into concise presentation materials for meetings with internal customers.
• Compile commodity forecast files, determine impacts of changes, and provide insight to drivers of movement. Partner with Category Managers to gather data, understand key impacts affecting costs, and summarize information for communication to internal customers.
• Perform scorecard and performance metric reporting in support of Supply Chain initiatives. Gather data and information, ensure accuracy, prepare reports and communicate to internal customers at all levels of the organization.
• Assist in documenting, analyzing, and improving Supply Chain business processes and procedures.
• Maintain template files for commodity forecasts and related reporting. Partner with Sr. Manager, Process Improvement and Category Managers to improve templates and in corporate changes to meet evolving expectations of internal customers.
• Assist in development of new Excel-based reports to support Supply Chain initiatives.
• Documented own work, create technical documents for requirements/design and internal communication
• Data expert and responsible for its quality and accuracy
• Create supply/demand forecasts and respective inventory targets
• Own it Owns, drives, and achieves desired results.
• Managed libraries, lists and workflows using SharePoint 2007.

Environment: Agile Scrum, UML, Use case, Activity, Rational Rose, Windows 7, MS Office, SQL, Webinar, MS Visio & SharePoint 2010.

Confidential, Bethesda, MD

SharePoint Business Analyst

Responsibilities:

• Served as liaison between Business Owners and IT Application Development to provide solutions to help meet end users needs.
• Worked with Subject Matter Experts (SME) to determine requirements. Elicited the requirement using elicitation technique like Surveys, JAD, Brainstorming and Interviewing Sessions.
• Followed a structured approach to organize requirements into logical groupings and developed Business Requirement Documents (BRD) from essential Business Process, Business Rules, information needs and ensured that critical requirements are not missed.
• Conducted GAP Analysis between Microsoft SharePoint 2007 and Microsoft SharePoint 2010.
• Expertise in Designing, Developing and Implementing SharePoint 2007 and 2010 with the help of SharePoint Designer2007, SharePoint2010 and MS Visio 2010
• Developed and integrated effective out-of-the-box workflows and Info Path forms for project Business Requirement Document.
• Conduct presentations through Microsoft Live meeting, for newly created SharePoint portals, and presenting instructions through the use of PowerPoint.
• Developed UML Use Cases for the application and prepared the detailed Work flow diagram based on the proposed enhancement for the system.
• Facilitated the Design and development of Business Rule Engines to support SOA architecture and web services for both client side and server based validations. Created detailedUse Cases,andConducted User Acceptance Testing.
• Prepared Level of Effort (LOE) for particular enhancements to be done for the business stakeholders and getting approval from the project manager.
• Facilitate Joint Application Development (JAD) sessions to identify the business rules and requirements and then documented them into a well format that can be reviewed and understood by both business people and technical people.

Environment: Agile Scrum, Rational Rose, UML, Use case, Activity, MS Visio, Windows 2000/XP, MS Office, SQL, Oracle, Microsoft live meeting.

Confidential, Warwick, RI

Business Analyst

Responsibilities:

• Compiled Vision and Scope documents to better define the rationale for the project. Gather requirements from businessto determine the functionality that should be provided to the users.
• Tracked Businessrequirement traceability matrix (RTM) and handled scope creeps.
• Worked toward claim processing such as Claim Adjudication and Claim Reimbursement.
• Determine which claim system to interact with to display data on the UI.
• Worked toward Healthcare Rewards, Incentive and wellness exposure.
• Considered HIPAA rules while data validation and testing.
• Was responsible for the research and analysis of data requirements and issue resolution as they related to the design.
• Participated in / facilitated data requirements definition (e.g. extracts, sourcing, reporting) and design sessions.
• Worked with ICD 9 encoding to verify the validity of incoming claims documented ICD 9 codes presently used by the system.
• Dealt with 834 import member lookup processes and resolving issues with member attributes, enabling multiple rules associated with member lookup process.
• Dealt with the EDI transaction 835 claims payments and remittance advice, which deals the payment from payer to provider.
• Developed an automated approach for capturing all 837 data received from GHI that supports claim utilization and reporting.
• Worked on multiple 837 and multiple Eligibility (270/271) and healthcare claim status (276/277).
• Understood Functional/Technical (Data Model) flow of 4010 HIPAA Transactions and identify the new segments/element changes required with minimum changes to system.
• Builds and Runs Test Claims from subscriber information on NPS, working on those claims to ensure that they process through the system, and obtaining the results from the claim processes.
• Used Process log browser to view different types of log history files to figure out issues with 834 transactions.
• Attended daily SCRUM and guided QA and Developer regarding the defects, Technical Specification
• Prepared and maintained data for Core Measure reporting.
• Provided all standard and ad hoc quarterly reports including data analysis and graphs.
• Developed a set of best practices with regard to Part 11 remediation and have implemented innovative and cost effective strategies for achieving compliance.
• Conducted Joint Requirements Planning (JRP) sessions with management, SME's (Subject Matter Expertise) users and other key members for open and pending issues to develop specifications.
• Designed Use Cases, Use Case diagrams, Activity diagrams, Sequence diagrams in UML methodology using MS Visio.

Environment: Mainframe, DB2, SQL Server 2005, MS Visio, Facets, BusinessIntelligence, MS Project, MS Office, SharePoint, UML, HPQC

Confidential

SQL Developer

Responsibilities:

• Responsible for gathering requirements, designing, developing and testing.
• Involved in creating logical and physical models using Erwin.
• Migrated data from heterogeneous data sources and legacy system to centralized SQL Server databases, which involved cleansing, data mapping and data conversion.
• Responsible for the end-to-end design, development and testing of assigned reports.
• Incorporating all the build rules, writing the code using SQL*PLUS, PL/SQL.
• Used SQL* Loader to load data into different tables.
• Involved in performance tuning to optimizeSQLqueries using query analyzer, execution plans.
• Mapping Operational Repository toBusinessRepository elements and incorporating the build rules.
• For designing packages, stored procedures, functions and database triggers PL/SQL is used.
• Monitoring of statistics taken by the process, narrow down most expensive and long running queries to perform query optimization using SQL Server Profiler results and query plans.
• Checking for missing indexes, adding Clustered and non-clustered indexes as required. Analyze and implement the best possible query plan
• Extensively used PL/SQL to extract data from different tables with million records in some of the tables.
• Based on the user selection and finally storing the output as a flat file for further processing for the next module.
• Extensively used SQL & PL/SQL in reports. Cardinalities and Joins were used.
• Identifying and automating repetitive tasks or processes to save time
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes

Environment: Oracle 8i, PL/SQL, SQL*Plus, Esp./Imp, SQL*Loader, Erwin, SQL developer tool.

Confidential

SQL Developer

Responsibilities:

• SQLServer and Oracle Integration
• Development and integration of Oracle databases withSQLServer 7.0
• Security, DTS, Stored Procedures, Views, Table Schema Design, Tuning and Optimization.
• PL/SL Oracle Data Analysis with Toad.
• Requirements Gathering, Discovery, and Design Documentation utilizing UP processes.
• Integration of multiple databases including: Oracle 9g,SQLServer 7.0 and MS Access XP.
• Created Triggers with error messages so as to ensure consistency during data entry.
• Creating and managing Schema Objects such as Tables, Views, Indexes and Constraints.
• Implemented different joins to retrieve data from multiple tables with Referential Integrity.
• Troubleshooting problems concerned with SQL Server 2000 Installation, Configuration andMaintenance.
• Created number of database Triggers using PL/SQL, T-SQL, DML, DDL.
• Unit testing of the Database using PL/SQL queries.
• Proficiency in understanding clients needs and generate, modify reports existing in Oracle Applications according to the requirements and specifications.
• Optimization the queries to improve the performance of the application.
• Strong knowledge in using views, Materialized views, Export and Import Utilities provided in Oracle TOAD
• Creating PL/ SQL stored Procedures, views, functions, packages, MS SQL SERVER 2008 stored Procedures, DML, DDL and functions using Rapid SQL, SQL Server Management Studio and TOAD.
• Performance Tuning of the data using indexes, views, Graphs in SQL Server.
• Identifying and correcting the DB data and log files to determine if this was the data problem.
• Database development by creating Oracle PL/SQL Functions, Procedures, Triggers, Packages, Records and Collections.
• Creation of new indexes to avoid the potential locking issue.

Environment: SQL Server 2005, Windows 2005/2003/2000, MS Access, T-SQL, PL/SQL, SQL, MS Excel, TOAD