NEHA SANDHIR
Email:
******************@*****.***
Phone: 559-***-****
SUMMARY
* ***** ** ********* ********** as a Business Analyst and a Team Player in
Architecting, Designing and Documenting IT, Finance, Insurance, Education,
and Consumer Goods business solutions following various phases of SDLC
(software development life cycle), experience in client interaction,
requirements gathering understanding communicating and implementation, for
some of the top corporations.
TECHNICAL SKILLS
Well versed in the following -
ERP: SAP 7 CRM, Familiar with MM and FICO.
Modeling Tools: Rational Requisite pro, Rational Rose, Familiar with MS
Visio.
Databases: MS Access, Oracle, MySQL.
Reporting Tools: Business Objects (BOXI R2 & R3).
Versioning Tools: Familiar with IBM Rational Clear Case.
Tools: Microsoft Office tools namely Excel, Outlook, PowerPoint and
Word, IBM Rational Clear Case and Clear Quest, TOAD for
SQL.
Work EXPERIENCE
Saber Surge Inc, CA January 2011 -
Present
Saber Surge Inc. is a software product development and business solution
company. It offers a range of software development solutions to a variety
of corporations that include networking, enterprise application software
companies, B2B, B2C, finance, ecommerce, customer-facing web publishers and
others.
As a Sr. Business Analyst Intern, my responsibilities include -
. Gather customer requirements, perform the analysis for current business
systems and processes, provide automation solutions, and create the
Functional Design Document for end users and developers. This involves
interaction with new and existing customers, developers and vendors.
. Work with existing reporting and analytics tools and suggest
improvements. This also involved creating BI reports for executives.
. Create Presentations, UI Wireframe designs, UML Diagrams and Sitemaps
based on the requirements.
. Preparing the Test Cases, Test Strategy and Test Plan.
. Supporting the technical team in the product development, delivery
process and translating the business requirements into Functional
Specification Document.
. Interviewing Clients, stakeholders and IT experts to have a successful
collection of requirements. Coordinated IT and Stake holder meetings and
brainstorming sessions for the projects.
. Worked on SWOT and Cost Benefit analysis for the projects.
International Technological University, CA August 2010 -
January 2011
As an Intern - Customer Relationship Management, my responsibilities
included -
. Identify and provide user problem resolutions for existing and
prospective students.
. Documentation - Interaction with students and staff to find, resolve and
document solutions.
. Assisted IT Web development team with requirement gathering by
interacting with students.
New York Life Insurance Co. March 2007 -
January 2008
New York Life Insurance Company (NYLIC) is the largest mutual life
insurance company in the United States, and one of the largest life
insurers in the world. New York Life has the highest possible financial
strength ratings from all four of the major credit rating agencies.
As a Sr. Business Analyst in EFS (Enterprise Financial Systems) team my
responsibilities included -
. Working with Sr. Analyst and Developers to analyze Business
Requirements for "Training and Networking portal" project and "Group
P&L" project.
. Gathered business requirements to enhance and improve routing,
reporting capabilities and drill-down features
. Communicated and maintained strong working relationship with various
business groups such as Project enlargement and clients regarding
requirements and workflow.
. Understanding about SOX Compliance and HIPAA Compliance and
observance of all aspects for credentials and SOX Compliance Sign-Off
. Worked with the ETL Team to identify and translate the transformation
rules and business logic of insurance and claims processing for the
Source ETL process, simulated it as ETL transformation and conversion
rules and documented them in the Mapping Document.
. Proficient experience through the whole SDLC from requirement
analysis till deployment, using highly efficient RUP process of
software development.
. Functioned as a data analyst to gather, quantify and convert atomic
level data into relational dimensional model format for reporting
purposes.
. Coordinated with the ETL Team to ensure the correct transformation
and loading of the data according to the business requirements.
. Conducted Brain-storming sessions and Joint Application Development
sessions and documented the Concept Description Document (CDD)
. Involved in Joint Application Development (JAD) sessions with
trainers, agent advisors, sales managers and stakeholders to define
technology applications for business requirements, to communicate
their perspective, resolve any issues, and come to an agreement
quickly.
. Functioned as a data analyst to gather, quantify and convert atomic
level data into relational dimensional model format for reporting
purposes.
. Responsible for preparing the Test Cases, Test Strategy and Test
Plan.
. Facilitating User Acceptance Testing (UAT) for the project.
. Creating Project deliverables such a Business Requirements Document,
Functional Specification Document, Use Case Scenarios Document,
Activity diagram and Use Case diagrams.
. Utilizing Rational Unified Process (RUP) to develop process and
procedures for the project.
. Assisting project manager in managing project resources, project
timelines, identify and escalate project risks and issues.
. Developing and maintain strong working relationships with all key
internal stakeholders including customer executives, product managers
and resource managers.
Allegro Capital Advisors April 2006 -
March 2007
Allegro Capital is a comprehensive Investment Bank that comes with years of
expertise in offering financial solutions and advisory services across the
corporate world. The company is in the business of managing the assets of
individuals and corporate. List of its corporate clients include senior and
middle management from organizations that include Intel, IBM, HP, Coke,
Pepsi, Whirlpool Corporation, Hindustan Levers, 3M, Gillette and Cisco
amongst others.
As a Business Analyst-II in Investment Management team my responsibilities
included -
. Involved in writing Use Cases, Functional Specifications, Scenarios,
Business processes, Work flow diagrams and process flows for the Web
based portal to handle client investment portfolios along with
Advisor details.
. Defined and baseline functional requirements that were used by the
development, testing and client organizations.
. Reviewed time and cost estimates for the project.
. Reviewed and approved system feature and design requirements.
. Provided Project Management support as needed to ensure projects were
successfully delivered.
. Experience with SQL queries to retrieve, validate and manage data in
Data base.
. Involved in conducting GAP analysis, conducting JAD sessions, User
Acceptance Testing (UAT), SWOT analysis, Cost benefit analysis and
ROI analysis
. Exceptional ability to maintain and build client relationships, able
to comfortably converse with all facets in the client's organization
for gathering requirements and validation.
. Create Test readiness and Test Status Summary report.
. Participate in daily defect meeting and taking status from each
vertical manager.
. Manage the overall coordination of the testing activities for System
testing and UAT.
. Interacting with higher management people to identify and analyze the
given information, processes and decision flows. Contributed ideas
towards building the company's core business and marketing plan;
implementing them into the business and functional requirements of
the system.
. Working with different design tools and UML to create use case
diagrams and activity diagrams for better understanding of the
project.
. Monitoring the progress of project with respect to schedules and
effort estimates. Providing AGILE project plans and timeline
schedules.
. Using Business Objects reporting tool (BOXI R2) to create reports for
business.
. Educated advisors and stakeholders on the benefits and risks
associated with the project.
. Business Development through Making strategies and organizing various
events in communities to create brand awareness and acquire clients,
Making Corporate presentations with a view of creating awareness of
the brand and also marketing the financial advisory services
(presented in Wipro, Ambuja), and Arranging corporate desks (arranged
in Keane, Coca- Cola).
Gillette February 2005 -
April 2006
Gillette (India) Ltd. The Company's principal activity is to manufacture
and market consumer products. The Company operates in three segments:
Grooming, Oral Care, and Portable Power. Grooming segment includes blades,
razors and toiletries. Oral Care segment includes toothbrushes and oral
care products. Portable power segment includes batteries, torches and
lamps.
As a Business and Data Analyst in the Gillette Vector Plus launch team my
responsibilities included -
. Used ExCenium and Sombol proprietary analysis and reporting tools to
analyze the Gillette Vector campaign data and create summarized data
stores based on business rules.
. Gathering user requirements, analyzing and preparing project
deliverables like Business Requirements Document (BRD) and Functional
Specification Document (FSD).
. Supporting the technical team in the product development, delivery
process and translating the business requirements into Functional
Specification Document (FSD).
. Interviewing Subject Matter Experts (SMEs), stakeholders and IT
experts to have a successful collection of requirements. Coordinated
between Research, Marketing, Sales and Stake holders for the projects.
. Managed all the requirements in Rational Requisite Pro, making
requirements available to all team members and stakeholders involved
in the project.
. Monitored stakeholder expectations and skillfully negotiated with
stakeholders throughout the lifecycle of the project.
. Followed UML based methodology using Rational Rose for creating
Business Cases and Use Case Models after assessing the status and
scope of the project and implementing Business Intellegence reports
that will meet their strategic business processes needs.
. Identified Use Cases from the requirements and wrote Use Case
Specifications document.
. Reported status to project management and project owners on a weekly
and monthly basis.
. Used MS Project 2000 for status reporting and project planning.
. Involved in the periodically held JAD sessions for the purpose of
project updates as well as involved in the weekly meetings to discuss
the current project status.
. Actively involved in developing, executing and coordinating functional
and user acceptance testing (UAT).
. Leading the Requirements Gathering Sessions and Joint Application
Development (JAD) Sessions to gather and document the business
requirements.
. Analyzing large volumes of data, SWOT analysis of the brand, locating
trends, providing strategic recommendations, report writing and
presentation of analysis. Main focus of the reports was on CSD
customers.
. Training Customer support staff and updating them about Gillette
Vector Plus's features.
Skills: Windows XP/2000, SQL, MS Office Suite, RUP methodology, Project
2000, HTML, DHTML, XML, Oracle 9i, BOXI (R2 & R3)
EDUCATION
. Master of Science in Engineering Management, ITU University, Currently
Pursuing.
. Master of Business Administration, Marketing-IT, ICFAI University.
. Bachelor of Engineering in Electrical Engineering, Pune University.