Nirmala Pant
***************@*****.***
Professional Summary:
Over six years of experience as a Business Analyst, specialized in Testing
and Administration. I have been known to always deliver on timelines and up
to the expectations.
. Self-motivated and Flexible to adapt to any new environment and work on
any project.
. Strong communication skills with the ability to communicate
appropriately in business and technical situations at all levels.
. Project management skills with ability to coordinate multiple projects
simultaneously with little or no supervision.
. Experience in iterative agile project management methodology with Scrum
to manage the software development life cycle.
. Experience in creating Work Flow Diagrams, and Work Breakdown Structures
Project Charter, and Project schedules.
. Experience in developing Test Cases, from Use Cases, reviewing Test
Plans to ensure Use Cases accurately reflect Functional and User
Interface testing.
. Experienced in requirement Gathering Sessions, conducting Joint
Application Development sessions, coordinating with the Subject Matter
Experts and updating requirements.
. Experience in conducting GAP analysis, SWOT analysis, Cost benefit
analysis, ROI analysis and User Acceptance Testing.
. Used MS Project to manage schedules, meet deadlines and plan resources
in line with triple constraint. Followed up with weekly Project Status
and organized Task Review meetings.
. Excellent knowledge of standard industry methodologies like Software
Development Life Cycle, (Iterative Software Development Life Cycle
Process as per Rational Unified Process (RUP), Agile (SCRUM), and
Rational Tools used during various phases of RUP.
. High proficiency with SQL Server Architecture Good knowledge and
exposure to different phases of Software Development Life Cycle (SDLC).
. High-level proficiency with requirement analysis, system design, and
Object Oriented Design.
. Strong SQL Server Administration skills using various backup strategies,
Model (simple, bulk and full), database maintenance plan, user (NT/SQL)
security authorizations, database creation, Tables, indexes.
. In depth knowledge of developing complex stored procedures, views,
efficient triggers, required functions, and creating indexes and indexed
views for speedy performance using SSMS.
. Proficient in monitoring SQL Server Performance using SQL Profiler (Dead
Locks/Long running queries), Query Analyzer, Index Tuning Wizard,
Database Engine Tuning Wizard and Windows Performance Monitor.
. Experience in implementation and maintenance of Very Large Databases and
estimating the growth of the databases and maintaining Fill Factors.
Technical Skills:
Modeling tools MS Visio, MS Project, Rational rose
Methodologies Waterfall, Iterative (Agile), Prototyping, RUP, SCRUM,
RAD, JAD, SWOT, Cost/Benefit
Office Tools MS Office, Project outlook, MS Excel, Power Point
Quality Assurance Mercury Test Director, Win Runner
Operating Systems Windows 95/98/XP/2000/NT, MS-DOS, UNIX
Languages SQL, HTML, XML, Java, Visual Basic, UML
RDBMS MS Access, SQL server, Oracle
Work Experience:
Health Fitness, Plano, TX
Feb2012-Present Business Analyst
Health Fitness history began with on-site fitness management, but over the
years they expanded the services and programs to address the scope of the
population health spectrum. Today's Health Fitness leverages an
experienced, superbly trained workforce to integrate fitness, health
management, condition management and occupational health programs that meet
the individual needs of program participants, and the population health
goals of organizations.
Responsibilities:
. Assists business owners and project managers to identify, clarify,
define and document the objective and benefits of any project or
enhancement requests to be included in the project charter.
. Exposure and involvement with BPCS applications such as Configurable
enterprise financials, Supply chain management applications and Multi-
mode manufacturing applications.
. Independently coordinated with the business to assess and understand
business requests
. Conducted meetings, interviews and JAD sessions with SMEs, business
users and stakeholders to understand their business process and gather
requirements and produce the Business Requirement and Functional
Requirement.
. Created the as-is process map and to-be process map.
. Created and analyzed decomposition diagram & context level diagram.
. Analyzing and gathering of functional requirements & conducting review
sessions with project stakeholders.
. Conducting knowledge sharing sessions of the functional requirements
with the project development teams.
. Obtain sign-off on business and functional requirements.
. Ensured that the proposed solution concepts are aligned with existing
enterprise standard.
. Defined test cases, analyzing bugs by interacting with QA teams in
fixing errors.
. Involved in User Acceptance Test (UAT) for the final testing of the
application in the deployment environment.
. Responsible for providing documentation to team for troubleshooting
and resolving issues reported by system users
. Version control of the deliverable documents.
. Maintained clarification log, action logs and review feedback log.
. Conducted lessons learnt sessions with developers, testers and
stakeholders. Also documented the results for others to review.
Environment: RUP, UML, Rational Requisite Pro, Enterprise Architect, MS
Project, MS Office, DOORS, SQL Oracle 8i.
Liberty Travel, NJ Jan 2011-
Jan 2012
CRM Business Analyst
Our Entitlement for the project was to ensure the proper business control
over the service delivered to the customer. To ensure that, the company
delivers the best packages available for the customers. Our goal was to
gather requirements for the campaigns and campaign scheduling and design a
system where the company implemented Oracle applications 11.5.9 service,
marketing online, sales online to generate leads and campaigns.
Responsibilities:
. Setting up online implementation of marketing campaigns and campaigns
schedules.
. Conducted Use Case walkthroughs in an effort to identify and realize
the Process flows involved in the new system.
. Involved in Designing and developing Technical Design Documents,
Wireframes and requirement specification documents based on the
client's business and functional requirements.
. Worked with developers providing key specifications and user
requirements in the eCommerce travel accessories' division in order to
support a favorable customer experience and optimize the pages for
search engines.
. Developed the client specific Process Analysis Questionnaires.
. Configured the modules as per client process requirements. Performed
the functional testing for various scenarios. Prepared the Test
Scripts for the various modules and various scenarios.
. Conducted the Conference Room Pilot (CRP).
. Bug fixing and resolving the TARs (Technical Assistance Requests).
. Performed Database analysis, Data Mapping, Data Validations on
Database
. Worked with the UI developers for the more customization.
. Updated marketing tables with new territories writing SQL Queries.
. Planned, tested, and implemented system enhancements and conversions.
Extensively wrote SQL queries for QA testing, reporting/data
validation.
. Partner with IT team to develop reporting solution using MS Reporting
Services to improve daily reporting process and enhanced ad-hoc
reporting capabilities.
Environment: Oracle Applications 11.5.9, Crystal Reports, TeleService,
sales & marketing online, Agile Scrum, PL/SQL.
All State Insurance Company, Roanoke VA
Jan2010-Dec2010 Business Analyst
All state offers diversified services to its customers and is the leading
providers of Property, Auto, life, and casualty insurance. The project was
to lower the days taken to process the claims. Allstate was making
enhancement in legacy claim process system. I was involved in requirement
gathering, aiding the testing team to test the application and
conducted User Acceptance Testing using Agile Software development
methodology.
Responsibilities:
. Identified processes for developing and documenting detailed business
requirements. Requirements were collected from Stakeholders and SME's.
. Created Business Requirement Document (BRD) and Use-Case document as per
business needs.
. Help conducting release backlog, Attended scrum meetings, conducted
sprints and UAT in Agile methodology.
. Requirements were gathered conducting JAD sessions and periodic
walkthroughs with loan analysts, credit analysts and other potential
users of the application.
. Conducted User stories reviews and identified gaps, leading to
improvements/enhancements in the same.
. Created and maintained the Requirements Traceability Matrix (RTM).
. Ensured User stories were consistent and covered all aspects of the
Requirements document.
. Maintained documents and the effect of proposed changes on the project
schedule and costs.
. Worked directly with software engineers to ensure clear communications on
requirements and defect reports.
. Designed and developed scenarios based on business requirements.
. Created Prototypes, High-Level and Detailed Business flow diagram using
Tools like MS Visio and Axure.
. Very good understanding in XML language for filing claim online.
. Worked on claims module for filing claims online and receiving it in XML
language.
. Followed the Agile methodology for the entire SDLC.
. Created GAP and Impact Analysis based on AS-IS and TO-BE System.
. Strong Knowledge of Data Warehousing, Data mapping and Data mining.
. Professional expertise in MS SQL Server and Oracle and with Data modeling
techniques with special expertise in distinguishing between reference
data and master data requirements.
. Interacting with other teams through walkthroughs, teleconferences,
meetings, etc. to resolve various issues.
. Validated the scripts to make sure they have been executed correctly and
meets the scenario description.
. Conducted User Acceptance Testing (UAT) along with stakeholders, project
manager and Leads.
Best Buy, Minneapolis, MN
Oct2008-Dec2009 Business Analyst
The project involved the development of a software which was an integrated
application suite consisting of E-Commerce, supply chain & POS (Point of
Sale) and store operations, inventory management, planning, business
intelligence, payment processing and customer management. As a Business
Analyst, I worked on the credit card security transaction under POS system.
Responsibilities:
. Gathered Business Requirements, analyzed data/workflows & performed
GAP analysis.
. Facilitated JAD sessions for the collection of Functional Requirements
from system users, and prepared Business and Technical Requirement
Specification documents.
. Analyzed business and technical requirements, thus creating the
Business Use Case (BUC) and Application Use Case documents.
. Utilized RUP to configure and develop processes, standards, and
procedures, and to perform System analysis.
. Developed detailed BRDs and DFDs using various modeling tools and
developed databases based on the system model following the techniques
in Agile.
. Worked on Ecommerce application the B2B exchange of data.
. Documented approved change controls to add them into business design.
. Prepared Logical Process and Data Models that contained set of
diagrams and supporting documents containing the essential business
elements, detailed definitions, and descriptions of the relationships
between the data elements to analyze and document Business Data
Requirements..
. Developed Data Flow, Work Flow, Process Flow, and Entity Relationship
Diagrams in MS Visio, and analyzed them to create "AS IS" and "TO BE"
scenarios.
. Worked on requirements for various modules covered under Retail and
Global E-Commerce (POS) apps that include modules include FI (Account
Receivable, Account Payable, and General Ledger), SD (Sales Order
Process, Order Delivery), etc.
. Worked as an Interface between the users and the different teams
involved in the application development for the better understanding
of the business and IT processes.
. Maintained Project Glossary for the entire project team.
. Followed a structured approach to organize requirements into logical
groupings of essential Business Processes, Business Rules, and
Information Needs, thus ensuring that Critical Requirements are not
missed.
. Followed the UML based methods using MS Visio to create Use Case,
Activity/State Chart, Sequence, and Collaboration Diagrams.
. Participate in continuous process improvements that will result in
greater efficiencies, improved customer service, increased revenue,
and overall improved project performance.
. Worked with the Project Manager on various Project Management
activities like Resource Planning, Resource Request, keeping track of
Project Status, Deadlines, and Issues, Environment Request, and
Compliance Issues.
Macy's, New York, NY
Jan2007-August2008 Business Analyst
This project enabled customers an automated, self-service Gift Registry
available in stores via online at macys.com. This project encompassed
necessary deliverables to fully integrate a custom built Gift Registry
application with company's systems and develop reporting on performance
metrics. The gift registry was designed to support stores with vastly
different technical capabilities.
Responsibilities:
. Interacted with the users by interviewing them, and also by preparing
questionnaires and getting their feedback.
. Acted as a liaison between end users, developers, architect and the QA
team.
. Maintained clear understanding of project goals among stakeholders by
conducting walkthroughs and meetings involving various leads from BA,
Development, QA and Technical Support teams.
. Worked with management to create and communicate critical information to
the user community via email and discussion boards.
. Conducted interviews with the clients for gathering requirements and
evaluation/analysis of their data to convert the business requirements
into IT specifications.
. Created project plans, detailing projects Scope, process flow, timelines,
and requirement documents and analyze risks.
. Developed the business and functional requirements specification
describing and prioritizing of the requirements in detail.
. Created well-defined business vision documents, business glossaries and
requirements management plan as in Waterfall methodology.
. Conducted JAD sessions to develop architectural solutions to open and
conflicting issues
. Participated with QA team to conduct major functionality testing of the
different module such as enrollment, report etc. by manually
. Analyzed the Traceability matrix and conducted GAP analysis
. Analyzed "AS IS" and "TO BE" scenarios, designed new process flows and
documented the business process and various business scenarios.
. Wrote use cases and relevant UML diagrams such as Use Cases, Activity and
Sequence diagrams
. Involved to write UAT test plan and conducted User Acceptance Testing at
the end of the testing process and write the signoff document for the
future reference
. Worked directly with the UAT team to test various scenarios in the
desktop application.
Environment: Windows2000, Microsoft Project 2000, HTML, MS Visio, Oracle,
MS Visio, MS PowerPoint.
Education: Masters of business Administration from Mississippi College.
Professional References Available on Request.