SUMMARY

• Over 9 years industry experience as Business System Analyst with proficiency in Business Requirement gathering, Business Process flow, Business Process Modeling Business Intelligence, Business Objects, database/data warehousing, mining, Automatic and manual testing.
• Strong experience in Telecom, Logistics, Finance and Healthcare industry sectors.
• Strong knowledge of System Development Life Cycle including analysis, design and review of business and software requirement specifications, development and Testing Methodologies and Techniques.
• Facilitatedweeklyandmonthly business review meetingsto keep SME’s, Stakeholders, product managers, executive staff and team members apprised of goals, project status, resolving issues and conflicts and preparing product demonstrations.
• Used Requisite Pro, Quality Center for requirements gathering and managing the requirements.
• Experience in process modeling using Use Cases, Sequence Diagrams, Collaboration diagrams, Activity Diagrams.
• Experience in conducting Joint Application Development and Rapid Application Development sessions to converge early toward a design acceptable to the customer and feasible for the developers and to limit a project’s exposure to the forces of change.
• Experience in dealing with different data sources ranging from Flat files, SQL server, Oracle, My SQL, MS Access and Excel.
• Experience in Relational Data Modeling with very good focus on creating ER Diagrams and Dimensional Data Modeling.
• Elicit, analyze, validate and document user, functional and non - functional requirements, business rules, and business process models.
• Design and build SQL queries using Business Objects Intelligence tools and facilitated in data extraction and reporting. Have a strong knowledge of writing sql scripts for Store Procedures & T-SQL statements.
• Strong expertise in Data analysis, Data mapping, Data modeling and development of Databases for business applications in client/server applications and Data warehouse environments
• Experience in Relational Data Modeling with very good focus on creating ER Diagrams and Dimensional Data Modeling in designing Data Marts and Data warehouse using Star Schema and Snowflake Schema models in implementing decision support systems.
• Have a strong exposure and experience on Service Oriented Architecture (SOA) and object oriented methodologies.
• Experience in GAP analysis, SWOT analysis, Market research analysis of product prices, Risk analysis, Cost-benefit analysis, ROI analysis, User acceptance testing (UAT) and traceability matrices.
• Thorough understanding of testing for the entire software life cycle and across legacy, client-server and web platforms, including Version Control in new software rollouts.
• Excellent Business writing skills in writing business requirements document, USE Case specifications, functional specifications, systems design specifications, system requirements specifications, data dictionary, business continuity plan, and data/work flows.
• Experience in conducting GAP analysis, User Acceptance Testing, SWOT analysis, Cost benefit analysis and ROI analysis.
• Facilitated ofJAD (Joint Application Design) sessionsand coordinating extensive communication networks (interviews, FSR’s, RAD sessions, 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.
• Experience in Facilitate and monitor the development of Quality Control (QC) and User Acceptance (UA) test plans, test cases and related activities using tools like HP QC.

TECHNICAL SKILLS

Methodology: Waterfall, Agile (Scrum) & RUP

Databases: Oracle 11g/9i/8i/8.0/7.0, DB2, MS, SQL Server 2000/7.0/7.0 , Microsoft Access

Software: Microsoft Office Suite (Word, Excel, Access, PowerPoint, and Outlook), Microsoft Project, Microsoft Visio, Rational Rose, Lotus Smart Suite, Lotus Notes, TOAD for Oracle

Reporting Tools: Rational Rose, Microsoft Visio, Brio, Business Objects (Business Intelligence), Erwin 4.0, TOAD, Crystal Reports

Programming Language: SQL, HTML, ASP.Net, Java/J2EE

Operating Systems: Linux, MS-DOS, Microsoft Windows 7,Vista, XP, NT, 2000, 98 & 95

Environment: Oracle, Microsoft SQL Server, Teradata

Project Management: MS Project 2000/2003, MS Sharepoint 2010

PROFESSIONAL EXPERIENCE

Confidential

Sr. Business System Analyst/ Data Analyst

Responsibilities:

• Involved in knowledge transfer sessions with AT&T in gathering information about their systems and performed stringent data analysis to invoke the business solutions needed for Frontier Systems.
• Performed data mining on different AT&T sources using the data dictionaries provided and track the issues back to them to get constant solutions to keep the process aligned for implementation.
• Performed data analysis & mapping related to In-house Risk modeling and assessed scope and impact of business needs throughout analysis and completion of all enhancement specifications.
• Assisted the Project Manager & Team lead to develop the high-level specifications & business solutions to meet user requests and business need.
• Actively worked on large databases from different source systems that includes activities such as data modeling, mapping, development, integration, analysis and coordinating with testing team for defects.
• Performed data mapping on specifications related to customer care & billing that involves functionality related to Service Orders, Promotions, Discounts & Subscriber restricted content.
• Created SQL statements using ORACLE/DB2 that embed the functionality of the business process from different source systems to create solution specific to target systems.
• Understanding and querying the master data tables to develop the KPI’s to measure the actual data quality to increase the efficiency of customer and vendor master data.
• Verified the functional aspect as per the Business Process and validated the interfaces with the other systems and data conversion from the source legacy system.
• Created functional specification documents that includes the mapping & data analysis from different sources and coordinated with the development team for data conversion.
• Performed validation & Data Analysis on converted data according to target functionality through validating scripts in Oracle/DB2.
• Examined, analyzed the Test plans, Use Case Model cases & Test procedures based on AGILE methodology.
• Helped in creating data-mapping best practices document including visual processes and coordinated with team members on business documentation process.
• Worked with the defects from the testing team to evaluate the defects generated through system testing & UAT and implement those changes as needed in the target systems.
• Maintained and kept track of stakeholders’ requests for enhancements and changes using Unified Change Management tool (UCM) and traceability matrix.

Confidential

Sr. Business System Analyst/ Data Analyst

Responsibilities:

• Involved in requirement gathering including interviews, brainstorms and meetings with stakeholders and created requirement specification artifact (SRS’s and SDS’s).
• Performed Gap analysis for the modules in production, conducted feasibility study and performed impact analysis for proposed enhancements Involved in the creation and maintenance of the Workflow plans and artifacts.
• Modeled requirements related to In-house Risk modeling and assessed scope and impact of business needs throughout analysis and completion of all enhancement specifications.
• Assisted the Project Manager to develop both high-level and detailed application architecture to meet user requests and business need.
• Prepared Business Process Models that includes modeling of all the activities of the business from the conceptual to procedural level. Followed top down, leveled technique for building Business Process Models.
• Actively worked on large data warehousing and maintenance activities including data modeling, mapping, development, integration, analysis and testing
• Created Use-Case Models using MS Visio to depict Actors and Use-Cases in various Business Processes and identification of Basic/Alternative flows and definition of preconditions and post conditions of the System.
• Worked with the UI team to create the User Interface screenshots to be presented to the Business.
• Performed Data Analysis of existing data through SQL/Oracle, writing & validating SQL scripts for Stored Proc’s for applications.
• Proficient in UI Data Mapping that involved Defect Management process.
• Examined, analyzed and model Test plans, Use Case Model cases & Test procedures based on AGILE methodology.
• Designed and developed Quality Assurance standard and processes to all levels of project team.
• Verified the functional aspect as per the Business Process and validated the interfaces with the other systems and data conversion from the legacy system.
• Helped in creating of data-mapping best practices document including visual processes and trained team members on data mapping process and tools.
• Performed Basic Sanity Testing via navigation and workflow of the Application.
• Created PAD’s in conjunction with System’s architect to baseline System Performance, identify expected Bottlenecks and set Load and Stress Targets.
• Maintained and kept track of stakeholders’ requests for enhancements and changes using Unified Change Management tool (UCM) such as Rational Clear Quest.
• Used Rational Clear Case, a Configuration Management tool, to maintain different builds of the application with descriptions about all changes and versions.

Confidential, San Antonio, TX

Business Systems Analyst

Responsibilities:

• Business Process Modelingto understand the shortcomings of the existing system
• Performed and evaluated the benefits of the new system and generatedworkflows.
• UsedPrototypingmethod to gather additional requirements from the users in order to describe the business needs in terms of the system being created.
• Involved in creating business requirements document and Functional Requirements Document(FRD) and translating them to technical specifications.
• Performed Data Analysis and data manipulation of source data from SQL Server and other data structures to support the business organization
• Developed an analysis model that includesUse Case diagrams,andActivity diagramsusingUMLmethodologies inRational Rose, which provided the development team a view of the requirements for design and construction phases.
• Used the guidelines and artifacts of theRational Unified Process (RUP) to strategize the Implementation ofRational Unified Processeffort in different iterations and phases of the System Development Life Cycle(SDLC).
• Involved in requirements gathering, data modeling, planning /scheduling data extraction from source systems.
• Designed and built the application on SOA / web services based multi-tier environment.
• Used SQL to run ad-hoc queries and prepare reports to the management.
• Created new mappings and updated old mappings according to changes in Business logic.
• Completed business process design and development project, included logical data flow diagramming, research and definition of data aggregation, validation of credit risk calculations & report format designs.
• Performed extensive requirement analysis including data analysis and gap analysis.
• Responsible for completingweekly project status reports.
• Documented requirements associated change requests with requirements and connected requirements withUse casesinRequisite Proand created different traceability views.
• Designed and developed theTest planandTest casedocuments.
• Closely worked with Users and Technical team in managing and handling User requested Changes and User Conflicts.
• Developeddocumentationtemplates, specifications and schedules for technical writing deliverables.

Confidential, Horsham, PA

Business Systems Analyst

Responsibilities:

• Worked in full SDLC Lifecycle using Rapid Application Development (RAD) methodology
• Aided in coordination and development of project requirement gathering and documentation using Caliber RM tool, MS Word and MS Excel
• Conducted group discussions to gather requirements in JAD sessions with the User group and development teams and documented scope and business requirement, Functional Specifications and created User Interface Mockups/Prototypes
• Used Requisite Pro for gathering requirements and quality center for managing the requirements.
• Interfaced with SMEs to prepare comprehensive BRDs for major initiatives related to the on-going projects
• Prepared business process models and followed UML based methods using MS Visio to create Use Case diagrams, Activity Diagrams, and State Chart Diagrams
• Developed Use Cases, workflow, screen mock-ups and conversion requirements. Followed UML approach to organize requirements and grouped into business processes, business rules, information needs and ensured that critical requirements are not missed.
• Organized Business and process Use Cases, enhanced and developed Use Case Diagrams, Class, Sequence, Activity, State Chart diagrams and DFD diagrams using Star schema and adopted the UML standards to define modularity of the Data Process Models.
• Worked on Sales and material master data from the providers through different sources and applied transformation rules as per Master Data Management (MDM) practice from source to target level.
• Worked on ETL and target mapping documents for business object migration to enterprise data warehouse.
• Understanding and querying the master data tables to develop the KPI’s to measure the actual data quality to increase the efficiency of customer and vendor master data.
• Used SQL to run ad-hoc queries and prepare reports to the management, written & validated T-SQL scripts and Stored Procedures for application development.
• Worked assisting the developers in coding, designing and establishing connectivity’s to the database using C#.Net and other WEB 2.0 techniques and languages such as XML & HTML.
• Conducted Successful Graphical User Interface (GUI) sessions with Usability Team and UML Modeling for IT team.
• Created detailed reports with Drill-down capability using Web Intelligence and worked on Ad hoc Query, Reporting, and Analysis.
• Worked closely with the Development team to clarify system requirements
• Assisted the development team during design, build and test phase of the system to crystallize the business requirements when needed.
• Received updates related to critical open defects, worked with QA managers to have these defects closed before the target release of the projects.
• Identified the impacted QA area for testing and defined the user role and specific data to be used for testing.

Confidential, St. Louis, MO

Business Analyst

Responsibilities:

• Work with Project Manager in the development of AGILE methodology and documentation strategy.
• Assist the Project Manager in the performance review and strategy and act on behalf of the Project Manager during the PM’s absence.
• Co-ordinate with the PM, designers, the software development team and the testing team to enable seamless working across work groups and ensure on time delivery of project objectives.
• Conducted user interviews, JAD and RAD sessions, gathered Business requirements, FRS’s and analyzed the requirements using MS Visio and Requisite Pro.
• Involved in requirement gathering including interviews, brainstorms and meetings with stakeholders and created requirement specification artifact (SRS’s and SDS’s).
• Performed Gap analysis for the modules in production, conducted feasibility study and performed impact analysis for proposed enhancements Involved in the creation and maintenance of the Workflow plans and artifacts.
• Created Use-Case Models using MS Visio to depict Actors and Use-Cases in various Business Processes and identification of Basic/Alternative flows and definition of preconditions and post conditions of the System.
• Worked with the UI team to create the User Interface screenshots to be presented to the Business.
• Maintained and kept track of stakeholders’ requests for enhancements and changes using Unified Change Management tool (UCM) such as Rational Clear Quest.
• Used Rational Clear Case, a Configuration Management tool, to maintain different builds of the application with descriptions about all changes and versions.
• Examined, analyzed and model Test plans, Use Case Model cases & Test procedures based on AGILE methodology.
• Designed and developed Quality Assurance standard and processes to all levels of project team.
• Verified the functional aspect as per the Business Process and validated the interfaces with the other systems and data conversion from the legacy system.
• Performed Basic Sanity Testing via navigation and workflow of the Application.
• Extensively work on Access, MS Visio, Excel, Word, PowerPoint, SQL, and MS Project