PROFESSIONAL SUMMARY

• Experience working in all phases of Software Development Life Cycle (SDLC), using Project Management concepts involving Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting, Reporting and Drafting remedy procedures.
• Excellent ability to analyze research and test on Oracle, SQL Server and SAS.
• Strong Knowledge ofSDLC, RUP, AgileandWaterfallmethodology, project life cycle.
• Expertise in writing Business Requirements Document (BRD), Functional Requirement Document (FRD), Non - Functional Specification Document, System Design Specification, Use Case, Screen mockups and training manuals.
• Experience in ETL (Informatica) and data modeling
• Experience wif Data Analysis/Data Mapping on Data warehouse system for various reporting systems wifin an organization.
• Experience in Data Transformation, Data Loading, Modeling and Performance Tuning.
• Good understanding of relational database concepts and client server concepts
• Experience in data validation in RDBMS by writing SQL Queries.
• Proficient in SQL, Scrum and Agile methodology
• Extensive use and knowledge of MS-Excel features and tools like lookup functions, referencing, conditional formatting, data analysis, data filtering, creating pivot tables and charts, macro and form functionalities for reporting and connection to MS-Access database for data extraction
• Experience wif Data Analysis using Oracle as a backend and TOAD as teh querying interface
• Experience in SQL, DML, DDL, writing complex SQL and testing scripts for data validation against relational Databases including Data warehouse systems.
• Proficient in using UML for Business Process Modeling, Use Cases, Activity Diagrams, Sequence Diagrams, Data Flow Diagrams and document them using Microsoft Visio and Rational Rose.
• Experience in conducting User Acceptance Testing (UAT), SWOT analysis, Cost Benefit analysis, GAP analysis, Risk Analysis and ROI analysis.
• Expertise in writing test plans, Test cases, test scripts, test data, test checklist and RTM .
• Highly motivated team player wif excellent communication, presentation and interpersonal skills, always willing to work in challenging and cross-platform environment.
• Expertise in Acceptance Test-Driven Development ATDD development practices.
• Advance level expertise in MS Office tools such as Excel, Word, PowerPoint, Visio, Doors, Requisite Pro

TECHNICAL SKILLS

Business Modeling Tools: Visual Paradigm, MS Visio, PowerPoint, Rational Rose

Requirements Gathering Tools: Rational RequisitePro, MS Word, MS Excel

Microsoft Tools: MS Office, MS Visio, MS Project

SDLC Methodologies: RUP, Prototyping, RAD, Waterfall

Testing Tools: Mercury Test Director

Database: MS Access, Oracle 9i, MySQL

Operating Systems: Windows 2000/XP, Vista, DOS

Programming Languages: PL/SQL, VB.Net, QBasic, HTML, PHP, ASP.Net

Defect Management Tools: Mercury Test Director, Rational ClearQuest

PROFESSIONAL EXPERTISE

Confidential, George, TX

Business Analyst

Responsibilities:

• Worked wif project manager, traders, and other stakeholders to define project scope, plan, and requirements.
• Worked on modern Agile methodologies such as SCRUM,TDDand XP.
• Conducted user interviews; gatheird, and analyzed operational requirements in consultation wif traders, developers, and end users using Requisite Pro.
• Developed UML Use Cases using Rational Rose and developed a detailed project plan wif emphasis on deliverables.
• Performs analysis and presentation of information specifically addressing data analysis, data quality, workload, staffing ratios.
• Activities included analysis, programming and testing using Oracle tools; developed and tested teh Human Resource Personnel System which replaced teh mainframe personnel system.
• Identify and resolve barriers to performance from determining root cause analysis, creating process mapping and resolution - implementation.
• Worked through teh implementations of SDL Tridion Content Management Systems (CMS) using Web Services for integration of functionalities.
• Facilitated Project Management activities wifin Agile Methodology by using a Project Notebook which included Project Cost, Timelines, Cadence Calendars, Action Items and Sprint workflows.
• Moreover, I also authored functional requirements documents FRD by interacting wif development team for improving client's legacy system.
• Identified risks involved for teh desire project such as market risk, inflation risk, credit risk, and default risk. Supported SOA, data warehousing, data mining, and Enterprise Service model standards in designs, and developed standardization of processes like configuration management.
• Cash management practices were implemented in teh project for automated clearing house, sweep accounts, and balance reporting services.
• Consumed SOAP web services to collect teh 360°view of teh customers which was used for analyzing teh credit risk.
• Extensively worked in Web services and API Testing.
• Involved in migrating SharePoint 2010 on base environment to Office 365 SharePoint online 2013 environment.
• Involved in configuring and developing apps using teh layer2 third party tool to integrate on base environment to SharePoint online.
• Enterprise Risk Management - establishing and quantifying teh organization's 'risk appetite' by preparing teh Internal Capital Adequacy Process document.
• Involved in setting up different configuration environment for compatibility testing and manual testing.
• Conducted SouthTrust Bank mobile application testing on android and iOS smartphones.
• Worked extensively wif teh QA team for designing Test Plan and Test Cases for teh User Acceptance Testing. Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping.
• Involved in decision making of converting manual test cases into automated test scripts and analyzing their life time and time required to update teh scripts.
• Developed timelines for project delivery, and managed projects and resources to successful completion.
• Substantial report development experience utilizing SQL Server Reporting Services (SSRS) and Microsoft Excel.
• Performed gap analysis by identifying existing technologies, and subsequently, documented teh enhancements to meet teh end state requirements.
• Assisted wif users' testing of systems (UAT), and developed & maintained quality procedures.

Environment: MS Access, MS Excel, MS Word, MS PowerPoint, Visual Studio, XML Files, .NET framework, MS SQL, RUP, Requisite Pro.

Confidential, Rye Brook, NY

Business Systems Analyst

Responsibilities:

• Responsible for teh requirements gathering phase and prepared BRD and FRD.
• Involved in Planning and designing teh SharePoint Intranet for better employee engagement by simpler Layout and Improving Information architecture.
• Responsible for requirements analysis, design and developing technical requirements.
• Created and tested scripts for premium calculations and claims limits and deductibles (claims calculations).
• Developed complex forecasting tools using Access.
• Responsible for verifying teh eligibility of beneficiaries for providers and to process Medicare part D claims.
• Responsible for teh investigating teh tan existing business problems and halped IT development staff to complete systematic analysis of these problems to determine their impact on other work.
• Involved in processing Health Care Claim Transaction set EDI i.e. 837.
• Responsible for mapping XML data into EDI X12 using Extreme translator.
• Designed and developed integration solutions end-end.
• Responsible for capturing and managing all types of change requests throughout teh development lifecycle using Rational ClearQuest.
• Designed an application for teh management to analyze teh market trends, behavior, habits etc by collecting relevant data at various points and organizing teh data into appropriate data warehouses and data marts and through teh processing teh data into various statistical reports (ad-hoc/canned for strategic management decision making) by utilizing SAS.
• Responsible for requirements management using Requisite Pro
• Developed Base line scripts for testing teh future releases of teh application
• Applied teh SQL scripts to teh test database and execution of teh scripts on teh database
• Worked wif business representatives to understand data marts requirements, data models, data flows, Facets on-line, priorities and ensured that IT work is appropriately aligned.
• Responsible for creating business work flows and processes, design documentation, project plan documentation and creating management reports based on teh analysis.
• Conducted joint discussion sessions (JAD) wif business users, stakeholders to understand teh requirements in more detail.
• Clarified QA team issues and reviewed test plans and test scripts developed by development team and QA team to make sure all requirements were covered in scripts and tested properly.
• Maintained Test Matrix wif teh test results obtained.
• Followed teh UML based methods using Rational Rose to create use cases, activity diagram, sequence diagram, collaboration diagram that included functional and non-functional specifications for teh development teams.
• Used teh Agile methodology to build teh different phases of Software Development Life Cycle.
• Participated in enforcing teh rules of Scrum, removing impediments from teh team while promoting self-management and constantly improving teh standard of work.
• Interacted regularly wif teh business users and teh IT team for understanding teh requirements.
• Came up wif test cases for various reports on teh data marts and identified that teh test case documents are updated timely.
• Analyzed defects and performed bug testing by using Rational ClearQuest, configuration management and version control wif Clear Case.
• Reviewed high-level design documents and low level designs of classes and sequence diagrams.
• Conducted training and provided end-user support by providing tools training.

Environment: RUP, UML, HP Quality Centre, Win Runner, Rational Clear Quest, Windows, MS Office, XML, TOAD, Ultra Edit.

Confidential, Towson, MD

Business Analyst

Responsibilities:

• Assisted Project Manager in drafting teh Project plan; defining scope, and establishing work breakdown structure and project milestones using Microsoft Project
• Scheduled and facilitated meetings wif SMEs to establish rapport and sense of partnership wif internal business clients, involving them in project planning, and setting goals
• Analysis of Business Requirements, Process Modeling and preparation of Functional Design Specifications employing use case scenarios, sequence diagrams.
• Categorized search tool based on teh latest.NETFramework Technology.Adding, modifying or deleting ICD-9-CM codes wif teh click of a mouse.
• Worked on X837 processing of claims for electronic media claims (EMC), National Council for Prescription Drug Programs (NCPDP), and Office for Civil Rights (OCR) claims
• Used ICD9 codes for alphanumeric designations given to every diagnosis, description of symptoms and cause of death attributed to humans.
• Prepared functional specification and involved in implementation of architecture of SharePoint Server 2007 along wif Office 2007.
• Worked on Client/Server tools like SQL Server Management Studio to administer SQL Server.
• Evaluated data storage considerations to store databases and transaction logs. Created databases using SQL Server Management Studio, Database Wizard and Transact SQL Statements.
• Used MS Visio for Process modelling, Process mapping and Business Process flow diagrams.
• Analyzed teh Change Requirements on teh Confidential Medicare System (VMS) and identifying teh impacted modules
• Developed functional Requirements document, design specification document and Testing strategy document
• Conducted requirement feasibility analysis to determine teh technology feasibility of each requirement wif teh halp from System Architect/Developers
• Developed and conducted statewide HIPAA 5010 and ICD-9 awareness program for all IDS staff in teh client.
• Review teh Test Plan developed by teh testing team for testing teh application.
• Drew estimates for impacted components, wrote Functional specifications for teh gatheird requirements for CMS approval on teh approach and strategy taken up
• Worked wif System Analysts and Developers conducting extensive analysis and coding optimization changes on VMS Online Claim editing process and Claim Adjudication process
• Developed and Enhanced Online claims processing screens and programs for Online editing and Claim entry in CICS, working wif a developer
• Worked in all teh different processes of Claims processing from Claim Online editing /processing /Adjudication /Payments systems
• Assisted Quality Assurance Team wif system testing of programs to cover various scenarios, wif respect to functionality to ensure teh system met both business and functional requirements
• Communicated wif clients from CMS, ADMINISTAR, PALMETTO and HealthNow, answering any questions or problems regarding teh Releases
• Worked extensively wif other Analysts, Developers and Architects in Confidential to translate Business Requirements into efficient executable programs
• Manually tested teh new system using Mercury Test Director to ensure a reasonably bug-free system
• Assisted in teh development, preparation and analysis of reports and presentations for management review
• Coordinated and conducted User Acceptance Testing (UAT) wif all teh user groups

Environment: IBM 3090, COBOL, Assembler, CICS, DB2, JCL, ENDEVOR, Xpeditor, ASP.NET, Confidential - VM/CMS, VSAM, Oracle, SQL, PL/SQL, MS Excel, MS Word, MS PowerPoint, HTML, MS Visio, Mercury Test Director

Confidential . Nashville, TN

Business Analyst

Responsibilities:

• Analyze business requirements and segregated them into Use Case Diagrams, Activity Diagrams, Sequence Diagrams, and OOD using Borland Together according to UML methodology thus defining teh Data Process Models.
• Created SAS programs that are used for data validation, statistical report generation and program validation and automated teh Edit Check programs using Macros
• Directed teh clinical trial data capture and worldwide data collection systems for various therapeutic areas. Used SAS ODS to create output files in different formats including PDF and RTF.
• Also extend teh metadata to include new object based on teh clients need.
• Performed teh business requirements gathering by questioners, Interview business area experts, surveys and JAD sessions.
• Develop Technical specification, Use cases, data model etc.
• Assisted in on-going process improvement efforts to ensure Test Planning, Execution, and Reporting is TEMPeffective, efficient, standardized, coordinated, and integrated.
• Was responsible for indexing of teh tables in that data warehouse.
• Developed business case, objectives, cost analysis and budget for implementation clinical and financial business systems. Establish documentation for Agile methodology for implementation wif a very water-fall-centric development team.
• Heavily involved in writing requirements for teh ETL process that would occur after data comparison from Legacy system in order to succeed wif parallel testing.
• Coordinate wif other organizations to obtain an automated monthly data feed, from an external system, which in turn is used to update TrackWise.
• Work closely wif Business Owners and Stakeholders to outline Business Requirements.
• Work wif System analyst and IS teams to understand teh flow of data.
• Reviewed and analyzed data from various sources. Involved in coding using Java created web pages using HTML, Java script.
• Wrote automated Test Scripts for Regression Testing using Win runner.
• Designed conceptual and logical data models of Data Warehouse and tables.
• Identified gaps and performed gap analysis wif respect to CMS requirements
• Created Mapping Documents, Report Mockups and modified existing report mockups as to CMS requirements and finalized for development
• Provide technical expertise as an early engagement to different modules and enhancements to access impacts and define scope.
• Involved in set up of testing methodologies and improvement of process model.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Performed analysis on enterprise data/report integration & provided functional specification to development team to build Enterprise Reporting Systems.
• Formulated logical statements of business requirements researched and evaluated alternative solutions and recommend teh most efficient solution for system design.
• Review requirements and understand technical recommendations and constraints, and develop comprehensive and accurate functional specifications; Data Mapping, and process flows.

Environment: RUP, Rational RequisitePro, Rational Soda, Rational Rose, SAS BASE/MACROS, Rational Clear Case, Rational Clear quest, Java, J2EE, VISIO, Oracle 9, Sybase, UNIX, XML SPY, GOXML, LINUX, HTML, WINDOWS, MS Office.