SUMMARY:

• Around 10 years of experience in IT industry focusing on analysis, reporting, documentation, testing and deployment.
• Extensive experience in project management life cycle for project environments such as data center migrations, cloud, online website enhancements, content management, adhoc reporting, etc.
• Solid understanding of Business Requirements Gathering, Evaluating Data Sources, Translating Requirements into Specifications, Application Design.
• Experienced in SCRUM based iterative incremental development showing increasing business value every Confidential . Experienced in techniques such as Confidential planning, Product Backlog management, story estimation, daily SCRUM, metrics such as Burn - down & Velocity charts, Confidential summary report, Confidential review/retrospective meetings etc.
• Experienced in Agile, improving development team motivation, process innovation, SCRUM based emergency procedures, removal of project impediments.
• Responsible for the creation and delivery of content for the websites.
• Developed and presented creative concepts/content.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Experience in Data Analysis, Data Migration, Data Cleansing, Data Import and Data Export
• Experience in writing SQL queries to manage SQL Server and Oracle databases.
• Experienced in conducting Joint Application Development (JAD) sessions for requirements gathering, analysis and design. Organized weekly Project Status and Task Review meetings.
• Excellent in preparing UML diagrams - Use Cases, Activity Diagrams, Sequence Diagrams, Class Diagrams, Process Flow Diagram, etc. using modeling tools like Rational Rose and MS Visio.
• Extensive experience in creating Screen Mockups, conducting Gap Analysis, Impact Analysis and Risk Analysis.
• Strong expertise in building Templates, Graphical Analysis Charts and reports using MS Excel and also expertise in MS Word, MS PowerPoint, and MS Project.
• Accustomed to working in large and small team environments, cross-functional teams & distributed teams.

TECHNICAL SKILLS:

Reporting Tools: Excel, Tableau

Business Modelling Tools: UML, Visio, Enterprise Architect

Methodologies: SDLC - Waterfall, Agile Scrum

Databases: MS Access, Oracle 11g, SQL Server, Razor SQL

Project Management Tools: MS Project, MS Excel, MS PowerPoint, MS Visio, JIRA, MS Word, SharePoint

CRM Tools: SATUIT

Web Technologies and Tools: HTML, XML, CSS, Enterprise Content Management, Documentum, Adobe CMS

WORK EXPERIENCE:

Confidential, San Francisco, CA

Business Systems Analyst

Responsibilities:

• Worked on Confidential application which is the primary application used by WellsCap Sales for tracking pipeline progress, commission requests and sales reporting.
• Performed client side web based validation in Confidential against the data in the database.
• Created test plan and test cases for testing in all environments.
• Extensively used SQL for extracting data from database and performed data validation.
• Created various ad hoc reports for management.
• Interacted with various business user groups for gathering the requirements.
• Involved in transformation and loading of data from the source systems to the target system.
• Worked on importing and cleansing of data and reported data quality issues post migration.
• Verified the Business Scenarios on new builds to allow extended testing.
• Analyzed business requirements, system requirements and data mapping requirement specifications.
• Executed data compares using V-look up to ensure right data got migrated into Confidential .
• Assisted the Project Manager with project scope and project plan.
• Worked closely with the development team to communicate client requirements.
• Updated the Business Requirements Document (BRD) with change request for any changes in requirements.
• Handled other projects like adding factsheet distribution field in the contact screen, enhancing annual guideline review reports

Environment: MS-OFFICE, MS Visio, Razor SQL, Confidential, Waterfall

Confidential, Los Angeles, CA

Sr. Business Analyst/Scrum Master

Responsibilities:

• Held fully accountable for leading an Agile team in writing user stories, use cases, managing the product backlog and iteration task board to deliver an end-to-end functional integrated system.
• Facilitated Iteration Planning meetings and coordination of release management activities for deployments. Closely tracked iteration progress reporting velocity and managing capacity.
• Maintained the Agile schedule including start and end dates of each iteration, build and deploy dates, stakeholder and senior management demos, and retrospective.
• Facilitated daily scrums, iteration planning, iteration reviews, defect reviews and retrospectives meetings and also Facilitated Scrum of Scrum for offshore teams.
• Handled special projects and ad-hoc reporting requests.
• Provided data analysis using Tableau business intelligence reporting tools.
• Created various dashboards for management review as per the reporting requirements.
• Wrote SQL queries to extract data from target tables. Performed client side and web based validation using SQL queries.
• Created reports using Excel for requirements and issue tracking, prepared presentations and reports using MS Power point, and analyzed data generated from SQL queries.
• Worked with business leads to refresh the content for website enhancement.
• Collaborated with other BA’S to produce final content based on marketing requirements and site re-designing.
• Ensured that business processes were followed and specifications met before launching new content.
• Tested all content updates and functionality in staging environment prior to implementation
• Identified issues and bugs that required escalation.

Environment: Agile Methodology, Enterprise Architect, Tableau, Adobe CMS, Content Coordination UML, Visio, SQL Server 2000

Confidential, CA

Business Analyst

Responsibilities:

• Developed Wire frames, screen mock ups, workflow diagrams for documentation and presentations.
• Maintained digital content and created new webpages using CMS/HTML editor.
• Update site menus, headers, editable categories and page metadata.
• Worked closely with writers on content development, marketing initiatives in order to drive unique visitor acquisition.
• Work closely with Graphics team to ensure web images meet necessary specifications
• Managed product marketing, awareness and thought leadership for EMC’s Enterprise Content Management core platform, Documentum, including introduction of new releases and functionality.
• Researched industry trends to identify new and engaging opportunities for content creation and features.
• Drove market research, product positioning, messaging, collateral development, launch, naming, field enablement and demand generation.
• Ensure all new content is approved before launch.
• Worked with developers for pre-launch administrative development, such as accumulating, creating and editing content and designing the website.
• Analyzed visitor browsing behavior and audited business rule performance.
• Used CSS for making templates for website and also to give uniform look and feel of all the pages.

Environment: Agile methodology, Enterprise Content Management, HTML, Documentum, CSS, MS Office Suite, SQL Server.

Confidential, Hayward, CA

Business Analyst

Responsibilities:

• Interacted with team leads to gather requirements about functionalities that need to be added/updated/enhanced.
• Recommended design improvements and developed webpage mock-ups.
• Worked with multiple stakeholders to refresh the content, ensuring it aligned with their business goals and secured necessary approvals.
• Created MS-Visio diagrams to depict the “AS-IS” and “TO-BE” workflow of the system in place.
• Defined system scope and objectives and prepared BRD (Business Requirement Document) and FSD (Functional Specification Document).
• Collaborated with other business analysts, quality analysts and developers to produce final content based on site functionality.
• Tested all content updates and functionality in staging environment prior to implementation.
• Assisted CMS users with posting web content.
• Accomplished daily and weekly meeting with the development and testing team for status review and to relay any changed requirements.
• Used SharePoint to upload all documents related to digital content.
• Identified CSS issues and bugs that required escalation; assisted with troubleshooting.
• Coordinated bug fixing activities related to issues raised during end - User Acceptance Testing (UAT).

Environment: MS-OFFICE, MS Visio, Content Management, CSS, SharePoint

Confidential

Project Analyst

Responsibilities:

• Handled mutual fund account reconciliation by doing back end processing and matching general ledger entries to the book entries.
• Involved in various activities of the project, like information gathering, analyzing the information, documenting the functional and non-functional requirements.
• Worked extensively with MS- Visio to document requirements, create the AS-IS and TO-BE process flow diagrams.
• Helped the project manager in developing and managing project management plan, establishing risk management process and metrics for the deliverables.
• Used MS Project for project management, milestone tracking, planning and status updates to ensure efficient and responsive operations along with senior management.
• Updated the standard operating procedures and process flows in SharePoint to keep the SharePoint data up to date for knowledge management and access by other team members.
• Performed internal cross-trainings to obtain shared knowledge base among the team members.
• Developed timelines for project delivery, and managed projects and resources to successful completion using Gantt Charts.
• Ensured that the project meet corporate SDLC standards, compliance and industry best practices.
• Handled mutual fund account reconciliation by doing back end processing and matching general ledger entries to the book entries.
• Was the sole admin for managing access requests from various team members.
• Built and published interactive reports.
• Conducted weekly and bi-monthly meetings with business teams on-shore and off-shore to report status.

Environment: MS-OFFICE, MS Visio, MS project