SUMMARY:

• Energetic and dynamic pharmaceutical, Healthcare / Retail / CPG Business Analyst / Project Manager with 9+ years of International experience, fully utilizing strong Business analysis and project management in a growth oriented fast paced environment.
• Business Analyst with 8 years of hands - on expertise Pharma sales and marketing data and utilisation.
• Reporting, BI tools like Informatica, Cognos, Market analytics, Dataview
• HTML, XML, MS Powerpoint, MS Project, Visio
• Well conversant with IMS, CDC, WK, SDI data sets used in Pharma sales and marketing.
• Experience in payer, patient, physician, promotional data used in pharma sales and marketing
• Buisnes analytics, market research and sales force effectiveness data management
• Comprehensive knowledge of Software Development Life Cycle (SDLC), methodologies like Waterfall, Agile and RUP and Rational tools used during various phases like Requirements, Analysis/Design, Development and Testing phases.
• Comprehensive knowledge of XPONET, DDD, NSP, NPA data used in pharma commercial ops
• Therapy knowledge of AHY, Oncology, CNS
• Brand experience in Diova, Tekturna, Gleevec, Femara, Enablex
• Data warehousing experience
• Data integrity, quality control with pharma sales and marketing data
• Hands on experience in querying databases, and good knowledge of Data Mining.
• Worked extensively on Requirements management using tools like Rational Requisite Pro, and created project plans and timelines using Microsoft Project
• Extensive experience Conducting JAD sessions, Story Boarding and creating Request Requirements Traceability Matrix (RTM).
• Proficient in creating Use Case documents, Sequence Diagrams, Activity Diagrams, Process Flow Diagram etc.
• Familiar with XML Mapping
• Provide ADHOC Analysis based on Client Requests.
• Provided data modeling support for numerous strategic application development projects.
• Conduct data analysis using SQL & Excel as part of requirements analysis and to assist data quality teams.
• Provided data modeling support for numerous strategic application development projects.
• Experience with Basic and Complex SQL queries to retrieve and manage data in Data base.
• Familiar with RDBMS concepts of an SDLC cycle
• Hands on experience in creating variety documents like Business requirement documents, Functional specification, Use cases, Test Cases, Test Plan and Change Control documents using tools like Microsoft Office (Word, Excel, PowerPoint.) .

BUSINESS/TECHNICAL SKILLS:

Business-Modeling Tools: MS Project, Excel, Visio, PowerPoint, Front Page, Rational Rose

Front-End Tools: Microsoft FrontPage, Office, Project, Visio, and Dream weaver

Processes/Technologies: Rational Unified Process (RUP), Clear Case, Use Cases, Workflow and UML

Web/Application Servers: WebLogic 8.1/7.0/6/1, Tomcat and Apache

Database: SQL Server 6.5/7.0/2000 , MS Access 97/ 2000, DB2, Flat files, TOAD

Programming Languages: PL/SQL, SQL

Reporting Tools: Business Objects XI R2, Crystal Reports XI, Informatica, Cognos, Dataview

Testing Tools: Mercury Tools, Win Runner, Load Runner, Test Director

EXPERIENCE:

Manager, Global Business Analytics

Confidential

Responsibilities:

• Effectively utilized broad variety of internal and external market, customer, and competitor knowledge sources ( i.e. syndicated & customized market research, proprietary databases, equity research reports, therapeutic research ) to support constructive business models and future business decisions in multiple TA’s
• Maintain the multi-yearbrandand product roadmap. Prepare the marketing goals for the year based on the roadmap, competitive activities and consumer analysis.
• Market Analysis, Market Survey and Market Intelligence report generation.
• Product planning, including customer needs analysis, concept screening, feasibility assessments.
• Created user defined SQL queries based on requirements.
• Managed reporting, quality, intergrity of Pharma secondary data used in sales / marketing
• Data analysis and mapping between the new Point of Sales systems (Insured3) and the legacy Policy Management System (PMS). This includes reviewing the Logical Data Model (consisting of entities and relationships only), making necessary changes, creating and mapping attributes to the entities based on documentation provided by the clients. The new entities, attributes and data mapping resulted in a document called the Data Traceability Matrix.
• Pharma sales and marketing data analysis used in sales force effectiveness
• IMS, SDI, CDC, WK data analysis used in commercial ops
• Supervised and developed documentation effort from an analysis standpoint. Utilized Use Cases, Stated requirements documents, feature specifications, workflow diagrams etc throughout the analysis phase of the project.
• Maintained the artifact tracker using MS Project making sure all the deliverables were on time
• Involved in meetings to determine levels of effort and to check compatibility of the infrastructure and the requirements.
• Used time boxing to in corporate critical requirements and features in the first iteration and build
• Utilized the SDLC leading to UML analysis and design.
• Testing of several web based application used in pharma reporting
• Followed a structured approach to organize requirements into logical groupings of essential business process, business rules, information needs and insured that critical requirements are not missed.
• Constant involvement in meetings to maintain the project schedule.
• Utilized simple methods like PowerPoint presentations while conducting walkthroughs with the stakeholders.
• Conducted walkthroughs with the end users to gather the modification requests from the user to upgrade or change the business specifications for the product.

Tools: Waterfall, MS Office, MS Project, Rational Tools, QTP, Access, SPSS Dataview

Confidential, Parsippany, NJ

Senior Business Analyst

Responsibilities:

• Involved in understanding of business processes to learn business requirements.
• IMS data management, reporting, analysis
• Created physical and logical models using Erwin.
• Involved in the creation of mapping documents from sourceto data marts.
• Worked closely with data warehouse architect and business intelligence analyst in developing solutions.
• End to end consulting in areas of Sales management, market insights, supply chain, sales force, Pricing and reimbursement, rebates and discounts, pharma reporting
• Designed Logical Data Model and User Interface for the application.
• Worked with production staff to identify and map detailed current processes, identify gaps and failure points, perform root cause analysis and develop functional and technical specifications that supported overall strategy, goals and objectives.
• Acted as a liason between the technical staff and the users (staff and management). Also was responbile for communications between Project Team and other related departments.
• Used Business Process Modeling and Use Case Modeling, Sequence Diagrams, Collaboration Diagrams, Activity Diagrams, and Class Diagrams.
• Automated process to improve overall efficiency of project life cycle by developing a tool to compensate sales force.
• Project Planning for analysis phase of the project.
• Executed Test cases and maintained detailed defect report
• Generate Models to depict business process and information flows for commercial analytics
• Provided production assistance after project implementation.
• Strong knowledge of SDLC, RUP, RequisitePro, and Clearcase.
• Implemented new data projection methodology NGPS at Novartis, Forest, Sandoz.
• Solid Business, communication and presentation skills. Adept at creating, editing and coordinating extensive communication networks. Facilitation of JAD sessions, interviews,
• Written correspondence, reports, implementation requirements, project status reports, oral presentation to keep executive staff members apprised of goals, project status and resolving issues and conflicts

Tools: MS-Visio, JIRA, Rational Clear Case, Rational Clear Quest, MS Office, SharePoint, MySQL, QTP

Confidential, Parsippany, NJ

Business Analyst

Responsibilities:

• Assisted Market research teams to derive tactical insights from secondary data and qualified results of qualitative and quantitative primary market research to support promotion and sales campaign.
• Maintained drug intelligence and secondary data reports while working with brand researchers, new product planning teams to provide insights for commercial assessment and forecasting.
• Successfully worked on new product launches by segmenting high deciles physicians, payers and consumer centric marketing using IMS secondary data.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Tested the data and data integrity among various sources and targets. Associated with Production support team in various performances related issues.
• Maintaining drug intelligence and secondary data reports while working with brand researchers, new product planning teams to provide insights for commercial assessment and forecasting.
• Created business cases based on secondary data and competitive market intelligence to gauge potential commercial value for late stage products in IBS and Multiple sclerosis market.
• Assisted Market research teams to derive tactical insights from secondary data and qualified results of qualitative and quantitative primary market research to support promotion and sales campaign.
• Maintained drug intelligence and secondary data reports while working with brand researchers, new product planning teams to provide insights for commercial assessment and forecasting.
• Involved with the project from its planning phase to design and up to implementation phase.
• Provided projects with pre-project planning expertise, detailed project definition and acted as primary liaison between IT and Business partners on a daily and project basis.
• Developed use cases to introduce new terms like Mandatory, Required and RW (Required when) to the existing Catalyst Rx system.
• Closely interacted with technical team and development team to ensure they understood the application’s functionality and navigational flaw.
• Translated business requirement and user expectations into detailed specifications using Unified Modeling Language (UML) and business process flow diagrams using Rational Modeler.
• Worked with Development team to add many fields and redefine existing fields to further clarify the financial balancing of transactions.
• Prepared Test cases (using test data available from CMS test document) during Design phase with presence of QA team and implemented plan for integration and functional testing.
• Maintained HL7 regulations for interoperation between Rx software and third party software system.
• Logged defects using Clear Quest and helped Development team to assign defects to their team members.
• Designed and developed Use Cases, Activity Diagrams and Class Diagrams using UML.
• Developed and followed RTM (Requirement Traceability Matrix) to track the new requirement and to update the test cases related to some old business requirement

Tools: Scrum, HTML, MS Project, MS Office, UML, MS-Visio, Rational tools, SQL

Confidential, Wilton, CT

Business Analyst

Responsibilities:

• Closely supported brand teams in top CPG clients, Pepsi, Diageo, Unilever to provide basis of Forecasts, Data analysis, market measurement, sku optimization that lead to construction of analytical reports based on fact based market intelligence
• Participated in the identification, understanding, and documentation of business requirements, including the applications capable of supporting those requirements.
• Translated the business needs into system requirements, communicating with the business on a non-technical level, and with the System Analyst on a more technical level.
• Collaborated with development architect and the business to develop both high-level and detailed application architecture to meet the business needs.
• Documented and delivered Functional Specification Document to the project team.
• Participated in the logical and physical design sessions, developed design documents.
• Assist the PM in setting realistic project expectations and in evaluating the impact of changes on the organization and plans accordingly.
• Provided technical assistance in identifying, evaluating, and developing systems and procedures that are cost effective and meet business requirements.
• Tools and Technologies:
• MS Word, MS Excel, MS Access, MS Project, MS DOS
• MBA Graduate school Projects / internship
• Procter & Gamble India
• Performed intensive analysis of emerging markets focusing on business development to understand key segments to target for growth.
• Applied Porter’s Five Forces model to conduct a scenario analysis for new brand launches
• Global Marine Inc (Project Graduate school)
• Conceptualized a new venture idea by assessing and defining business potential, opportunities and strategies to capture new oil markets and forecast volume sales potential
• Performed SWOT Analysis and also different hedging alternatives for managing currency risk