SUMMARY

• 12+ years of IT experience in business analysis, design, development, implementation, testing and support with very good understanding of project life cycle using waterfall and agile methodologies.
• 1+ year of experience in Veeva CRM application
• 2 years of experience in Salesforce and call center application. Hands on experience in Salesforce configuration tool.
• 6+ years of experience in soliciting client requirements through interviews, workshops and existing systems documentation or procedures.
• 4+ years of experience in business intelligence tools, including report design, query writing, OLAP and OLTP designs.
• Knowledge of data warehouse methodologies and data modeling.
• In depth knowledge of relational database structures, theories, principles and practices.
• Experience in building multidimensional models and creating cubes
• Knowledge of documentation process of software system as per FDA regulations.
• Familiar with current industry standards, such as Title 21 CFR Part 11.

TECHNICAL SKILLS

SaaS: Saleforce.com,Veeva

BI Tools: Cognos Enterprise Business Intelligence, SQL Server 2000 Analysis Services, Crystal Enterprise 10

Data Modeling Tool: ERWIN 3.5.2/4.1,MS Visio

Databases: Oracle 7/8/8i, SQL Server 2000, Microsoft Access

Tools: Salesforce.com data loader, APEX Explorer and Toad (Quest Software)

PROFESSIONAL EXPERIENCE

Confidential, Palo Alto, CA

Business Analyst

Responsibilities:

• Worked on end to end Veeva Implementation
• Worked closely with external Vendor to configure the system as per business requirements for Veeva implementation
• Created functional requirements for new systems to support business requirements.
• Prepared existing business and system process models using Visio.
• Created System Testing Scripts
• Prepared UAT document and conducted the UAT sessions
• Participated in Train the Train session, reviewed and provide feedback on training documents prepared by Vendor
• Created FAQ documents
• Manage and support periodic upgrades and enhancements
• Working as SME for all Enhancement and Configuration Needs
• Support and facilitate the resolution of technical issues
• Operational support for data integrations
• Provide ongoing CRM support of local and remote business users.
• Participate and manage ongoing requirements gathering process for enhancements to Veeva\CRM system.
• Play Lead Role in Managing Veeva application
• Working on defining the change request documentation and process for implementation of new enhancement and fixing defects.
• Effective partnership with CRM business owners

Confidential, Alameda, CA

Sr. Business Systems Analyst

Responsibilities:

• Worked closely with business, external vendor and internal ADC IT team.
• Clarified client requirements, business needs and project objectives, via Workshops, feedback sessions and client meetings, in collaboration with all stakeholders.
• Interfaced with business users to prepare Report of Finding (ROF), User Requirements Specification (URS) and System Requirements Specifications (SRS).
• Created functional requirements for new or modified systems to support business requirements
• Prepared existing business and system process models using Visio.
• Performed GAP analysis of business rules, business and system processflows, user administration and requirements.
• Maintained good relationships with users and IT colleagues to meet expected customer service levels
• Performed data analysis of existing data model and prepared data mapping documents.
• Conducted JAD sessions with business through out the SDLC to resolve the open issues.
• Worked with software QA team to review all the documentation and ensured compliance requirements were met.
• Reviewed the documents prepared by the external vendor.
• Work with tester’s, review the test protocols and prepared the testing summary report.
• Traced test cases to SRS and URS documents.
• Prepared UAT scripts.
• Fully participated in the after go - live activities such as provide adequate training to the end users.
• Played the role of primary contact for business for day to day support.
• Prepared change request document, update existing documents for implementation of new enhancement and fixing defects.
• Currently administering the Salesforce.com application supporting the activities such as further business analysis, user management, profile configuration, data management, sharing rules, workflows report and dashboard development, etc.
• Ongoing analysis of the bugs, enhancements requested by the user community and discuss with business and communicate to project manager and technical team.
• Write the work instruction document.

Confidential

Sr. Business System Analyst

Responsibilities:

• Analyzed and determined deficiencies in existing reporting system.
• Performed GAP and risk analysis of existing Reporting system and evaluated benefits of new reporting system.
• Gathered the business requirement for reporting by analyzing the existing reports, excel file, charts, business users meeting and feedback sessions.
• Worked closely with technical team for schema designing and identifying facts, measures, dimensions, and hierarchies for multidimensional reports.
• Reviewed the model design in Framework manager, Dimensions and Measure to ensure that it meets the business needs and design is easy for end user to create reports
• Documented the business rules for reporting.
• Prepared reports mock up and reviewed with business users.
• Prepared the user requirement specification (URS) based on business user requirements.
• Prepared System Requirement Specifications (SRS) document.
• Reviewed reports design with end-user audience.
• Ensured compliance requirement were met in system documentation and development.
• Reviewed the model design in Framework manager, Dimensions and Measure to ensure that it meets the business needs and design is easy for end user to create reports
• Work with quality team for reports validations.
• Reviewed the test scripts prepared by testing team.
• Prepared UAT document and conducted the UAT sessions and review the UAT results with team.
• Wrote SQL queries in Oracle for data manipulations.

Confidential

Business Intelligence Analyst

Responsibilities:

• Created report and cubes for Sales and Marketing group using Cognos 7.
• Provided end user support to Market Research group for day-to-day use of the business intelligence reporting platform.
• Worked on IMS data (IMS is a data provider primarily in Pharmaceutical industry. They collect data from different sources) and integrated it with other data sources e.g. Sales Rep data for Sales and Marketing reporting.
• Enhanced the existing cube and created new cubes for Market Research group.
• Worked with vendor that was maintaining Physician and Sales Rep data to integrate the data with IMS data and bring the data in to ADC Data warehouse.
• Write SQL Queries for data analysis and manipulations.
• Worked on Schema designing and model designing for new reporting projects
• Prepared existing reporting process flow for sales compensation reporting group using Visio.
• Analyzed and gathered the existing data sources for sales compensation reporting.
• Interviewed and met with technical and functional members in Chicago supporting the existing sales compensation reporting system.
• Documented all the business rules, formulas, logic and steps involved in the existing system.
• Created vision, scope, and use case documents and business process models.
• Educated the business about the benefit of multi dimensional reports.
• Prepared multi dimensional reports mock up and reviewed with business.
• Prepared User Requirement Specification and System Requirement Specification documents.
• Responsible for design and development of Cubes and Reports that supports a range of analysis at Loan City
• Translated business requirements into Data Mart and Warehouse Architectural Designs
• Designed logical and physical enterprise data warehouse schemas using designer tool ERWIN.
• Prepared the business specifications and Prototype for data warehouse design and reports
• Identified facts, measures, dimensions, and hierarchies for OLAP models.
• Closely work with technical person in developing ETL Processes to load data from production databases to the data warehouse.
• Created join look up transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions
• Created Cubes using SQL Server 2000 Analysis Service.
• Created OLAP reports using Crystal Analysis 10 connected with Analysis service cubes.
• Created production reports, simple List reports, Cross-tab reports, Sub-reports & Drill-Through reports using Crystal Report ver.10.
• Administer Crystal Enterprise 10, Created Group, User and Folder publish report and schedule report.
• Work closely with the Production Support in ensuring all the necessary hardware and software are available for deploying the release/project into production
• Coordinated in training sessions and demonstration of application and usage to end-users .Assisted users in trouble shooting their reports
• Participated in successful implementation of Reporting System at Galileo International (Represented IGTS, India)