Business analyst

Lovneet Singh

************@*****.***

732-***-**** Extn: 109

Lovneet Singh is a versatile Business Analyst with 8 years of experience in Financial Industry (Trade order/portfolio Management) and Publishing Software Industry. He has experience in all phases of the SDLC including Customer Requirement Analysis, GAP Analysis, and Testing and Documentation techniques. He also has expertise in project focusing areas like Workflows, Business Process Modeling, and Quality Assurance. He has worked with various SDLC methodologies including, waterfall, Agile Scrum, and RUP.

Being accomplished with reviewing test plans, defining test cases, reviewing and interacting with team members in rectifying errors and executing QA and User Acceptance Testing (UAT), he is also a focused troubleshooter and a team player with excellent interpersonal and communication skills. He has ability to work cohesively with developers, other team members, and testers. His worthiness can also be seen in his analytical skills in conducting Data Requirement Analysis, Timing Analysis and his proficiency with Microsoft Office, including Visio, Project, Excel and Access.

Highlights

● Hands-on experience in all phases of Software Development Lifecycle (SDLC) using Waterfall, Iterative, Agile, RUP (Rational Unified Process), and technology delivery frameworks.

● Excellent skills in Business Analysis, Data Analysis, Requirement Analysis, Business Process Reengineering and Use Case Development using UML methodology.

● Highly proficient in creating Use Cases, Use case diagrams, Sequence Diagrams, Collaboration diagrams, Activity Diagrams, Class Diagrams etc.

● Worked extensively on Business Requirements Elicitation, Process Modeling, Gap analysis, Risk analysis, SWOT analysis and development of Functional Specifications.

● Creating efficient and effective Test Scripts to implement and execute the Test Procedures. Execution of Test cases manually using HP Quality Center. Extensive use of HP and Rational Tools for Functional and Performance Testing.

● Hands on Project coordination experience along with working with vendors across the globe.

● Experienced with creation of project plan and project status reports.

● Hands on experience with SQL (intermediary).

● Effective communicator with excellent skills in making Business Presentations, Documentation and Technical Specifications.

● Hands on experience in IPv6 handling and software and hardware migration.

TECHNICAL SKILLS

Programming Language: C++, SQL, PL/SQL, HTML

OOAD tools: Rational Suite, MS Visio, MS Project

Tools: Rational Robot, Rational Test Manager, Mercury Win Runner, Load Runner, QTP

Graphical User Interface: MS Office suite, Adobe Acrobat, MS Share point

Processes/ Technologies: Rational Unified Process (RUP), Agile Scrum , Use Cases, Work Flow and Data Flow

Office tools: MS word, MS Excel, MS Access, MS PowerPoint, Lotus Notes, MS Project.

Databases: Oracle 9i/10g, MS Access, MS-SQL Server 2005/ 2000, Toad

Document and Project Management: JIRA, SharePoint, VersionOne.

EDUCATION

Bachelors of Technology, Electronics and Communication, P.T.U., PB, India

PROFESSIONAL EXPERIENCE

Novartis, NJ Dec’11- Till date

Business Analyst

Novartis is a leading Pharmaceutical company. It’s a division of Nestle. I am working on the following projects currently:

1. Migration of a BPM application to SharePoint: this application is used in Mexico for contract Management. Key points for this project are:

a. Developing an FS document for development of the BPM application in SharePoint

b. Developing a migration plan and data migration document for Migration of the current database to support legacy data in new environment.

c. Mapping all the fields to the active directory, thus eliminating the need to migrate the current PeopleSoft user database.

d. Working with offshore development team to generate the BPM process flows in SharePoint using Nintex workflows.

2. Lotus Notes to SharePoint Migration plan: Responsibility includes preparing a migration project plan to accommodate migration of 50+ applications and databases based on the release cycles, usability, criticality and time needed to migrate all the data.

3. SharePoint- iPad testing: project is to test the internal SharePoint websites and find out all the possible failures and document them according to the company’s template.

4. Creating a user manual for an internal Project planning and tracking tool.

Rackspace Hosting, TX Apr’ 11-Oct’11

Business analyst

Founded in 1998, Rackspace is based in San Antonio, TX. It has nine data centers: San Antonio, TX (2); Dallas, TX; Herndon, VA; Chicago, IL; Ashburn, VA; London, UK; Slough, UK; Hong Kong. Rackspace hosting provides managed hosting, email & apps and cloud hosting; all backed by fanatical support.

I worked on three different projects.

1. Project scope was to migrate all the internal and customer facing IT infrastructure from IPv4 to IPv6. Phase 1 was to make customer facing applications and infrastructure IPv6 ready. Project ended on June 15th with 98% success.

2. Migration of all the applications and related hardware which currently reside in San Antonio locations to other Datacenters.

3. Upgrade the Core process application to a new hardware and OS and make the SOA environment around it compatible to these changes. There are more than 60 applications which interact with this one application. I am responsible to work with all 60 teams in order to make this upgrade successful.

Responsibilities:

● Gathered and analyzed the requirements and converted them into User Requirement Specifications and Functional Requirement Specifications including Use case, activity, and class diagrams using Visio.

● Identified the critical applications and servers to be upgraded for 1st project’s phase I.

● Performed GAP and Impact analysis.

● Conducted Joint Application Development (JAD) sessions to identify business rules and requirements and documented them in a format that can be reviewed and understood by both business people and technical people.

● Facilitated daily stand up scrums, and weekly status meetings.

● Coordinated between teams to ensure the delivery of the goal for all three projects.

● Extensively involved in contacting the Executive Management Senior Management Project leads and Project Managers in the process of discussing and resolving technical and functional problems and assisted management in resource and budget planning.

● Maintained the project plan, status reports and SharePoint site.

● Tracked the progress of the project with each team using Gantt charts, burn down charts using JIRA, SharePoint and VersionOne..

● Assisted QA team to prepare test plan and test cases. Worked with Onshore (San Antonio) and Off-shore (Goa, India) QA teams for smooth performance, quality and functional testing.

● Drafted ROs based on specific team’s requirements.

● Assisting security team to make sure all infrastructures are compliant to company’s security policies.

● Gathered all the hardware information for various applications residing in San Antonio locations and created documentation for their dependencies on other applications. Worked with DB and Technical Support team to get this information.

● Coordinated with vendors including, Cisco, IBM, HP and Dell to ensure the timely delivery of systems required for the migration.

● Pulled and pushed relevant data from/to DB using SQL queries.

● Created, updated and maintained gathered data in excel and assisted architects in creating a logical architectural diagram.

● Developed (UAT) User Acceptance Test plans to validate the installed configuration and operation against detailed technical specifications.

Environment: JIRA, SharePoint, MS-Excel, MS-Project, SQL, VersionOne, Visio.

Clear Channel Communications, NY Jan’11-Mar’11

Role: Product Owner

Clear Channel Communications, Inc. (OTCBB:CCMO) is a global media and entertainment company specializing in mobile and on-demand entertainment and information services for local communities and premiere opportunities for advertisers. Based in San Antonio, Texas, the company's businesses include radio and outdoor displays.

I worked on following projects simultaneously:

1. Integrating iheartradio™ with Ford SYNC ™.

2. Developing iheartradio™ for iPad, Blackberry Playbook, and Android 2.2.

3. Developing station apps for radio stations.

Responsibilities:

• Gathered requirements by conducting interviews with the stakeholders

• Created user stories and maintained and tracked them using JIRA.

• Maintained and tracked the backlog and candidates.

• Assisted in creating wireframes.

• Worked with creative team to develop the artwork in accordance to the requirements.

• Participated in daily scrum to keep track of the project deadlines.

• Took MOMs and distributed for all the scrum meets.

• Worked with QA team to create test cases.

• Tracked the bugs using JIRA, Redmine and greenhopper.

• Created Project status reports and PowerPoint presentations for stakeholders.

• Used MS Visio to create UML diagrams.

Environment: C++, Kyte framework, MS Visio, JIRA, Redmine, Greenhopper, Ford Sync

American Express, Phoenix, AZ Mar’ 10- Dec’10

Business Analyst/ Project Coordinator

American Express is a Leading credit card company which provides various charge and lending on charge cards for the consumers. The project I am associated with is in MYCA-Money Movement, and I am working in two projects simultaneously for the Payment Center division and OBC. This project in Payment Center deals with enhancing the already existing application in PBC and Plum accounts. The project with OBH is in creating a new experience for small business owners by providing an easy to operate business center associated with their open cards.

Responsibilities:

• Worked closely with SMEs, and identified, analyzed the core requirements and key features of the ongoing project.

• Facilitated user interviews and workshops to gather requirements.

• Developed K245 as well as user stories with project teams. Extracted, discussed, and refined business requirement from business users.

• Converted Business Requirements documents into Functional Requirements Specification and Technical Specification.

• Participated in creating User manuals. Documenting all user and system requirement along with the work flow process. Conducted User Acceptance Testing (UAT).

• Successfully used Waterfall and SDLC Method for gathering requirements by facilitating Use Case Workshops and sessions.

• Managed third party vendor for GUI requirement.

• Performed extensive Gap analysis to determine the risks and assisted the PM in budget and resource planning.

• Lead design and status meetings with team members to discuss problem identification, prioritization and resolution, scope creep, and solution architecture.

• Created and transformed business requirements into software requirement specification (SRS) and designed business models using UML diagrams such as use case model, class diagrams, activity diagrams, sequence diagrams and collaboration diagrams in Visio thereby helping development and quality assurance in understanding the requirements.

• Participated and contributed in daily scrums, Sprint meeting and Sprint review meetings.

• Managed and coordinated between offshore and onshore resources.

• Conducted JAD sessions to allow different stakeholders to communicate their perspectives, resolve issues, and reach agreements.

• Maintained Project Plan and SharePoint site along with project status reports and scheduling.

Environment: Agile, SDLC, Java, Visio, Quality Center.

Trade and Brokerage, Schwab Corporate Services, NY June’09–Mar’10

Business Analyst

Charles Schwab is one of the nation's largest financial services, providers of securities brokerage, wealth management, and related financial and investment services. The project that I was involved in was an online financial bundle trading system. The application supports interaction between the public trader and the market maker. The system also includes a real-time order matching between offers in order to maximize the trader’s market surplus.

Responsibilities:

● Analyzed requirements modeled current business environment and produced cost effective redevelopment options for a system to capture property project details and calculate return on investment.

● Gathered and analyzed the requirements and converted them into User Requirement Specifications and Functional Requirement Specifications for the designers and developers to understand them as per their perspective.

● Extensively involved in contacting the Executive Management Senior Management Project leads and Project Managers in the process of discussing and resolving technical and functional problems.

● Involved with teams for root cause analysis activities and data collection plans.

● Performed GAP analysis of AS IS and TO BE systems and modeled them for better understanding of the business process.

● Facilitated Joint Application Development (JAD) sessions to identify business rules and requirements and documented them in a format that can be reviewed and understood by both business people and technical people.

● Used Rational Requisite Pro for managing the Requirement Analysis.

● Used Rational Rose to carry out the Business Use Case Modeling and Business Object Modeling effort to develop the business architecture for rapid and controlled application development.

● Created various types of UML Diagrams like Use Case Diagram, Activity Diagram, Class Diagram and Sequence Diagram to model the business use cases, business activities, business entities and business workflow and the interaction between them.

● Conducted meetings with users and other stakeholders to elicit, organize and document the requirements.

● Interacted with teams for troubleshooting break/fix of existing equipment and software related issues and installation of new equipment.

● Worked with business units to ensure organizational and team effectiveness and to help manage change initiatives.

● Enhanced the Test Cases by analyzing the Specification Documents.

● Assisted DB team to tune SQL queries to get project related data.

● Created Traceability Matrix to ensure that all the requirements are covered by the test cases using HP Quality Center.

● Worked on on-shore/off-shore model. Co-ordinated with the off-shore testing team to ensure smooth functioning of the team.

Fitch Ratings, NY Oct’08– March’09

Business Analyst

The main concentration was on reporting application that supports Ad-hoc reporting of all the different sectors related like credits, equity, preferred stocks. My responsibility involved handling preferred stocks and Munis.

Responsibilities:

● Gathered detailed requirements from the legacy system and performed BPR to analyze, documenting them in the NextGen Business Requirements and Components Detailed Requirements documents and obtaining sign -off.

● Identified, interviewed, and maintained relations with key project stakeholders to determine and document system requirements and use cases.

● Decomposed high-level business requirements into functional and non-functional requirements.

● Worked on Use case diagrams in conjunction with writing use cases along with the functional specifications for each work streams.

● Documented meeting outcomes, and coordinated all internal and external follow-ups to close issues in support of the project requirements.

● Liaised with business and functional owner, SMEs during requirement gathering and high-level review sessions to derive and execute action plans, meeting deadlines and standards.

● Used agile scrum methodology concept in the design and development with the application being divided into modules and developed in cascading stages.

● Conducted Joint Application Development (JAD) sessions with stakeholders throughout SDLC to resolve open issues.

● Performed GAP analysis on existing application to produce functional specification document.

● Helped technical teams to understand the requirements by presentation of artifacts, and by interacting with them on a regular basis.

● The user interface screens were prototyped in Microsoft Visio and reviewed with the end users prior to programming to solicit user acceptance.

● Interfaced with business users to prepare and update analysis artifact for Software Change Requests and Service Requests.

● Involved in designing and developing test plans based on the functional specifications and Business and user requirements.

● Developed (UAT) User Acceptance Test plans to validate the installed configuration and operation against detailed technical specifications.

● Achieving results by effectively communicating using analytical, interpersonal, and presentation skills to provide key personnel with the right information at the right time.

Quark Media Private LTD, Mohali, India Jan’06-June’08

Business Analyst

Quark is one of the leading publishing software developing companies. Its flagship product is QuarkXPress followed by a suite of application including QCD, QPC, and QLA etc. Scope of the project (codename: Wasabi) was to develop an upgrade version of QuarkXPress 7(QuarkXPress 8).

Responsibilities:

● Accomplished experience through whole SDLC from requirement analysis till deployment, using highly efficient RUP process of software development

● Acted as liaison between business units(sales, marketing and customer service teams) and technical units

● Facilitated JAD sessions with the Business Users to capture Business requirements.

● Prepared Business Requirement Document and converted it into Functional requirements specification.

● Extensively used Rational Tool Suite to gather and manage requirements. Created and managed project templates, use case templates, requirement types and traceability matrix in Requisite Pro.

● Prepared test cases for Navigational testing, Functionality testing under load and GUI testing using Test Director.

● Maintained relationship with external and internal subject matter experts.

● Developed required SQL scripts for database testing and Performed Backend Testing, by executing the SQL queries.

● Created Test Plans, Test cases in Test Case Design Documents for different scenarios.

● Documented entire testing process, test cases and test results.

● Performed black box testing on the builds.

● Tested the reported bugs from QuarkXPress 7 to make sure they are fixed in version 8.

HFCL Connect, Mohali, India May’04-Jan’06

Business Analyst

The scope of the project was to integrate TV channels with DSL to provide customers freedom of watching TV online (www.connectzone.in)

Responsibilities:

● Actively participated in the development of written, detailed business requirements and defined the Functional and non-Functional requirements.

● Identified and Created Business Process flows using MS Visio.

● Followed agile methodology and SCRUM meetings to track, optimize and tailor features to customer needs.

● Performed process analysis of Claims and Premium manual and system workflows, documenting them using Visio and MS Office Suite, for reinsurance contract maintenance and insurance policy administration.

● Facilitated JAD sessions with the Business Users to capture Business requirements.

● Gathered Customer Business Requirements Proposals and defined pre-sales action plan.

● Worked with the project manager to come up with Project related deliverables using MS Project extensively.

● Captured the AS IS Existing Screens and Views and Developed TO BE Screen Mock ups.

● Audited database files for accuracy of information produced for special research projects by using SQL.

● Executed the Test Scripts on different releases and validated the actual results against the expected results.

Contact this candidate