Project Manager Data

Ajay Nigam

*** ******** ****

Foster City, CA ***04

Phone: 650-***-**** (Cell)

650-***-**** (Home)

Email: ************@*****.***

CAREER SUMMARY

A Business Systems Analyst/IT Product Manager with over 15 years of experience working on Software Development Projects in Healthcare, Financial Services, and Retail industries. Special expertise in the following:

Eliciting business requirements from Business users on new system development projects including storyboarding and developing use cases.

Producing Business/Functional Requirements documents including functional specifications, use cases, and UML diagrams.

Completing data mapping between systems to ensure that data requirements are captured. This includes performing data analysis based off of SQL queries.

Experienced in working as a Business Systems Analyst on Data Warehousing projects, e-commerce web based systems, cloud based projects.

Acting as a liaison between the Business partners and the Development teams in order to translate requirements into system specifications.

Facilitate Joint Application Reviews and Design sessions in order to ensure that the requirements and design are completed and agreed upon from the key stakeholders.

Creating presentation decks on the overall architectural solution and recommendations for various projects and presenting to the Leadership teams.

Creating solution design documents which provide traceability to the Functional Requirements.

Creating solution alternative analysis and recommending the solutions to Stakeholders to get their approval.

Experienced in working in both Agile and Waterfall software methodology.

Experienced in the following applications: MS Word, MS Excel, MS Visio, MS PowerPoint, MS Project, MS Access, SQL, Salesforce, Oracle

PROFESSIONAL EXPERIENCE

Esurance.com, San Francisco, CA

March 2014 – Current

Senior Business Systems Analyst/Product Manager

Gathering requirements from Business SMEs on new Marketing web based applications which allow users to create quotes and purchase policy on auto and homeowners insurance.

Creating the BRDs and use cases along with the wireframes based on the requirements gathered.

Documenting the system solutions/specifications for the projects in support of the requirements.

Performing data analysis on policy information by creating SQL queries and root cause analysis.

Facilitating JAD sessions to review requirements and system solutions with Business and Development teams.

Kaiser Permanente, Oakland, CA

May 2008 – Feb 2014

IT Solutions Consultant

Performed as a Lead Solution Consultant for the Health Care Reform project called Summary of Benefits (SBC). Led a team of analysts to derive the detailed functional requirements and detailed design for a National solution to produce summary of benefit documents for clients of Kaiser.

Presented architectural solutions for the SBC project to the Leadership team for approval. This included the detailed process and system flows and cost/benefit analysis.

Completed data mapping documents based on the business requirements to ensure that all data was traced from the source systems to the target system in order to support the national SBC solution.

Worked on the new Claims Data Warehousing project in Oracle, which was to identify the business data requirements and reporting specifications and identify how to map that data back to the source systems.

Completed detailed requirements documents and logical solution design documents for new Healthcare projects involving enhancements to Benefits and Claims systems. Documented the high level architecture of the system solutions.

Facilitated JAR sessions with Business and IT SMEs in order to elicit detailed business and functional requirements on the new enhancements to the systems.

Gathered detailed business and functional requirements for a new Salesforce project which was used for managing the sale of benefit plans to various clients. Identified the workflow management requirements for creating cases and processing through completion.

WCIRB, San Francisco, CA

Nov 2006 – April 2008

Business Systems Analyst

Gathered and documented the business requirements to support the LSRP project. This project was to convert the legacy mainframe system into a web based transactional system using Microsoft technology.

Performed detailed analysis on how to migrate the data from the legacy systems to the SQL server database.

Interfaced with an offshore vendor to translate business requirements into system design specifications including the development of wireframes and technical solutions.

Facilitated meetings between the Business and our offshore vendor in order to identify project issues which required resolution.

Developed a detail project plan and helped manage the data conversion migration from the legacy mainframe system to the target SQL Server database.

Wells Fargo, San Francisco, CA

May 2006 – Nov 2006

Business Analyst (Wholesale Internet Solutions) - Contract position

Interviewed business partners through JAD sessions to gather and document business requirements for a new e-commerce IT Portfolio Management application.

Completed use cases and process flow diagrams representing the proposed solution.

Completed design mock up screens supporting the user requirements.

Worked with the Product Team to gather/document business requirements for an e-commerce web based application called CCER, which allowed customers to view/manage all credit card transactions made on their Corporate Credit card.

Delta Dental of California, San Francisco, CA

June 2002 – May 2006

Business Systems Analyst/Project Manager

Performed detailed analysis of enterprise data warehousing system containing Provider and Claims information.

Created a detailed data mapping document which mapped all data from the source to target systems. This included writing SQL queries against the Oracle database.

Gathered and documented business requirements for the implementation of a claims workflow management system called MACESS.

Coordinated and facilitated user group review sessions with clients in CA, PA, and GA in order to develop an enterprise solution for the MACESS system.

Created use cases, process flow maps, functional specifications, and test cases to support the development and implementation of the MACESS product to various clients.

Managed the defect tracking and resolution process for the Alternate ID project. This included leading a team of testers and developers to identify major defects and document the detail plan of resolving these defects.

Facilitated requirements sessions with the business users for the Enterprise Data Warehouse and documented business requirements. This system was to store all claims, provider, and patient data in one Oracle database.

Gap Inc., San Francisco, CA June 2000-March 2002

IT Business Analyst/Project Manager

Provided business analysis for various systems interfacing with the Stores and IT Infrastructure projects. This included gathering and documenting business requirements, creating the ‘AS IS’ and ‘TO BE’ business process models, and working with development teams to design solutions.

Managed the implementation of a Trickle Polling system to all North American stores. The purpose of this system was to provide real-time transmission of store sales data to Corporate Headquarters for their backend systems.

Interfaced with subject matter experts to gather and document business requirements for a web based application, which would allow users to retrieve and process journal sales transaction data retrieved from the stores.

United Airlines, San Francisco, CA January 1999 – May 2000

Industrial Engineer/Business Analyst

Completed a process analysis of the 747-maintenance check in order to identify redundant tasks and non-value-added tasks. Conducted a detailed business process reengineering effort to help improve productivity and reduce costs.

Developed and implemented an Access database system, which allows projects to be scheduled for different aircraft visits. Provided full support for the Access system including troubleshooting any problems and creating support documents.

Intel Corp, Chandler, AZ

June 1995 – August 1997

Systems Analyst

Performed the configuration, testing and implementation of UNIX based software applications which interfaced with the manufacturing equipment in the factory.

Coordinated with Developers, Process engineers, and the IT Network team to complete the infrastructure work necessary to successfully implement the applications in the Production environment.

Gathered user requirements from Process Engineers during application upgrades and translated these into system specifications for the Development teams.

EDUCATION

M.S.E. Industrial Engineering (Information Systems), ARIZONA STATE UNIVERSITY, 1994

B.S.E Industrial Engineering, ARIZONA STATE UNIVERSITY, 1992

Contact this candidate