SUMMARY:

• Around 3+ years of Experience as a Business/ Data Analyst with Project Management experiences working on enterprise class application development leveraging Waterfall and Agile methodologies.
• Extensive experience collaborating with business groups to business requirements and eventual deployment of software into production environment.
• Experience in complete Software Development Life Cycle (SDLC) - requirements gathering, conceptual design, analysis, high and low level detailed design, development, system testing.
• Experienced in process improvement of the ITIL practice areas of Problem, Configuration and Change Management.
• Assisted site operations in identifying areas for improving service levels, reducing operational costs , and providing other operational enhancements
• Data visualization for discovery and timely insights to decrease Cycle Time toAction (CTA)
• Expertise in various business operations and helped the organization to achieve cost-effective production with increased quality, efficiency and satisfied customer service, documenting the business process by identifying the requirements and also in finding the system requirements.
• Excellent knowledge in preparing required project documentation , tracking and regular reporting on the status of projects to all project stakeholders.
• Preparing, planning, documenting, and conducting requirements elicitation sessions using various techniques like Existing document analysis, Interface Analysis, Observations - Passive/Active, Prototyping - Proof of Concept; As Is/To Be, Requirements Workshops - Discussion and consensus sessions
• Excellent proficiency in creating Use case, Class, Sequence, Dataflow, Process flow, State chart diagrams in Design document using Rational Rose/ MS Visio.
• Expertise in creating Use case documents, Functional requirement documents (FRD) and Business Requirement document (BRD), Software Specification Document (SRS) across the deliverables of project.
• Experience in developing database solutions by designing proposed systems, defining database physical structure, functional capabilities, security, backup requirements, and recovery specifications.
• Very good understanding of Data Warehousing Design Methodology, Data Warehouse Concepts, Database design/architecture including both OLAP & OLTP.
• Experienced in writing SQL queries and optimizing the queries in Oracle, SQL Server.
• Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying Data mismatch.
• Execute tests, report and manage defects, troubleshoot and defect root cause analysis
• Extensive knowledge and experience in producing tables, reports, graphs, listings using various procedures and handling large Data bases to perform complex Data manipulations .
• Strong problem solving skills, ability to develop strategies for clients, and provide detailed documents to clients.
• Excellent Team coordinating Skills with the Development Team and Deliverable dates. Ability to quickly grasp business domain.
• Excellent Excellent Team coordinating Skills with the Development Team and Deliverable dates. Ability to quickly grasp business domain.
• Excellent team player at all levels with ability to perform independently. Proficient at developing and implementing training programs to enhance the efficiency, competency and motivation levels of the employees in line with organizational objectives.
• A keen communicator with honed problem solving & analytical abilities.

TECHNICAL SKILLS:

Operating systems: Windows NT/XP/2000/Vista/7,inux

Languages: C, C++, Java, SQL, UML, HTML, C#

Testing tools: Mercury (HP) Load Runner, Test director, Quick Test Pro (QTP), Win Runner, Clear Case

Business Modeling tools: MS Visio, MS Project, Rational Rose, Team Foundation Server, iRise and Guidewire Education

Change management tools: Rational Clear Quest, Rational Rose

Documentation tools: MS Word, MS Excel, MS PowerPoint

Requirement analysis tools: Rational Requisite Pro, Quality center

Project Methodologies: Rational Unified Process (RUP), Agile, Scrum, Waterfall.

Database: Oracle 8.x/9i/10g/11g, SQL Server 2000/2005/2012, MySQL 5.0/4, MS Access, TOAD

PROFESSIONAL EXPERIENCE:

Confidential, Texas

Business Systems Analyst

Responsibilities:

• Involved in entire project life cycle from analysis, development, testing, production and end user support
• Work Involved in complete Software Development Life Cycle (SDLC) - requirements gathering, conceptual design, analysis, high and low level detailed design, development, system testing.
• Collaborated with stakeholders from internal marketing sectors representing Originations, Servicing, Secondary Marketing, Enterprise Risk Management, Model Risk Management, Internal Audit, external auditors and consultants to elicit business needs, gather requirements, and offer solutions.
• Provided technical assistance in identifying, evaluating, and developing systems and procedures that are cost effective and meet business requirements.
• Documented and delivered Functional Specification Document to the project team.
• Coordinated with developers: Conducted JAD with SMEs, Developers, Project Managers and Quality Analysts to discuss business requirements, test planning, and defect tracking sessions.
• Solve complex interaction problems with simplistic approaches, illustrating your solution with user flows, wireframes, and visual mockups. Create and conduct training on ALM tools, including Visual Studio and Microsoft Test Manager (MTM)
• Administered and managed the Visual Studio Team Foundation Server platform, including SQL Server and SharePoint Server
• Setup and follow TFS collections, team projects, users and security
• Developed and maintained custom TFS reports using SQL Server Reporting Services
• Ensure communication and collaboration with stakeholders for system outages/deployments
• Involved in designing, developing and supporting custom database applications including working on developing stored procedures, conducting data modeling, database optimization, and going through the process with developers to enhance and modify databases to satisfy new client requirements
• Identify, direct, monitor and report on quality product delivery performance efforts including resolution plans and prioritization.
• Developed business context diagrams (flow charts) in an effort to identify and analyze process flows in the system.
• Develops standardized and ad hoc site and/or customer reporting
• Streamlines and/or automates internal and external reporting
• May investigate and recommend new technologies and information systems
• Worked on basic SQL queries for QA testing and report / data validation
• Created a detailed requirements document, test plan and procedures for application testing.
• Involved in modifying the existing Reports based upon the change requested by the user.
• Worked on the continuous improvement of QA Process by reviewing and evaluating existing practices with standard testing guidelines.
• Created Use cases, Test cases, Process flows, Test plans for QA team and noted user observation during testing product before release
• Assisted in creating the Data Mapping Specification.
• Collaborated with DBAs to perform data mapping and executed simple and complex SQL queries to verify the mapped data.
• Assisted with user testing of systems and maintained quality procedures and ensured appropriate documentation is in place.

Environment: Oracle 12c, AQT, SQL Developer, HP Quality Center, JIRA, Team Foundation Server, Version One and Framework Manager.

Confidential, Texas

Business Systems Analyst

Responsibilities:

• Functioned as the primary liaison between the business user, project sponsor, operations team, and the technical team throughout the project life cycle for commercial lines of Confidential business unit
• Serve as the project manager leading the proposal development process with minimal oversight, including the creation of proposal templates and schedules in order to meet the requirements as outlined in clients’ RFPs
• Performed task decomposition, delegated tasks and monitored project milestones using MS Project and prepared GANTT charts
• Worked with GUI development, requirements creation/design to create the initial UI wireframes, and mockups. Developed Mockup screens and prototypes for the learner’s home page requirements document using Axure.
• Maintained Microsoft TFS (Agile Backlog/Sprint System); included Sprint Planning, Grooming, and Prioritization.
• Formalizing and documenting enterprise standards for managing code and change management in TFS.
• Supporting team transitions from Rational tools to Microsoft Team Foundation Server (TFS)
• Generated ad-hoc reports writing ad-hoc SQL queries using joins and nested queries to fetch data from the Microsoft SQL Server database to see historical business performance.
• Instructed and modeled core agile principles of collaboration, prioritization, team accountability and visibility. Ensured consistent application of scrum methodologies across the team.
• Used SharePoint as Content Management System for maintaining documents and templates available across the organization.
• Used HPALM for requirements gathering, and writing the associated test cases against the requirements.
• Assisted in developing screen mockups, and wireframes using Balsamic.
• Assisted in User Acceptance Testing (UAT) in conjugation with the QA team. Also, created an error repository and managed the testing process with the QA team.
• Used JIRA for project and issue tracking and requirement traceability.
• Assisted QA team in creating Test Plan, scripting Test Cases and assisted in Regression Testing, Functional Testing and performed User Acceptance Testing (UAT) with different test scenarios and test cases using HP ALM.

Environment: Oracle 11g, PL/SQL, SQL Server, SQL Developer, HP Quality Center, Scrum Master, Team Foundation Server.

Confidential

Associate Service now engineer/Business Analyst

Responsibilities:

• Created various front end forms.
• Gathering the Details of the requirement with the client/customer.
• Developed the mock up screens,catalogs,flow charts.
• Participated in meetings with client on the daily basis for project development.
• Involved in creation and modification of various Business rules, Client Scripts, UI policies, UI actions.
• Created update sets to migrate customizations from one instance to another.
• Designed Workflows.
• Worked on CMDB and Asset Management.
• Service Catalog and Request Workflow Design and Configuration.
• Development of scheduled reports for stakeholders
• Extensively worked on Workflows and web service integrations.
• Created various SLA as per client requirement with the Incident Management applications.
• Worked closely with UI designers to understand the detailed UI prototypes and components.
• Developed the webpages that included JQUERY, JavaScript and AJAX.
• Developed web presentation layer using JQUERY, HTML and CSS according to internal standards and guidelines.
• Developed business context diagrams (flow charts) in an effort to identify and analyze process flows in the system.

Environment: HTML, DHTML, CSS, jQuery, JavaScript, AJAX, Java(JSP),JSF, SVN, AJAX, Angular JS, HTML5, XHTML, CSS3, XSL