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 in Core Documentation, Data Analysis and Process Analysis Design, Development and Testing phases.
• Reporting, BI tools like Informatica, Cognos, Market analytics
• HTML, XML, MS Powerpoint, MS Project, Visio
• Clear, concise, communication in both written and oral
• Experience working on EDI transactions and following norms of HIPAA.
• Knowledge of health information technologies such as ICD9, ICD10 and CCD verification.
• 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.
• Experienced in Business Data Analysis and Business Modeling in various projects
• Extensive experience in Gathering, Refining, Managing Requirements, preparation of BRD.
• 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 Cases, 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.) .

TECHNICAL SKILLS

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

FrontEnd 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, SQLReporting Tools Business Objects XI R2, Crystal Reports XI, Informatica, Cognos

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

PROFESSIONAL EXPERIENCE:

Confidential, East Hanover, NJ

Manager

Responsibilities:

• Analyzing the system workflow of the legacy Point of Sales System.
• 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.
• Used the guidelines and artifacts of the Rational Unified Process (RUP) to strategize the implementation effort in different iterations and phases of the Software Development Life Cycle (SDLC).
• Built requirements based on IT SMEs (Subject Matter Experts), partnered with Business heads and SMEs.
• 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.
• Categorized requirements into Functional Specification Groups (FSGs) and scheduled these FSGs by design phases viz. Build 1, 2, 3 etc.
• 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.
• Communicated changes to requirements promptly and precisely to all personnel involved.
• 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.

Environment: Business Objects Xi, Oracle, Informatica, Rational Rose, Ms Project, Ms Power Point, UNIX, windows.

Confidential, Parsippany, NJ

Senior Business Analyst

Responsibilities:

• Implementing commercial Models in Pharmaceutical Clients using IMS Data sources.
• Handled team size of 7 analysts offshore / onshore arrangement
• Clients handled Pfizer, BMS, Confidential, Novo Nordisk, BI, Forest
• 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. team on new processes and design tools.
• 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 methodology NGPS at Confidential, Forest, Sandoz.
• Solid Business, communication and presentation skills. Adept at creating, editing and coordinating extensive communication networks. Facilitation of JAD sessions, interviews,

Confidential Parsippany, NJ

Business Analyst

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.
• Conducts market analysis on various drugs primarily in Oncology, cardiovascular and CNS market
• Support Confidential, Confidential Oncology, BMS, Forest, Bayer Diabetes, BI Rx and Consumer business, Forecasting, Pipeline Marketing and Analytics teams to analyze Brands to measure growth and venture into new Therapeutic classes
• Developed a business plan to identify potential sales forecasts for matured products in Emerging markets
• 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.
• Successfully worked on new product launches by segmenting high deciles physicians, payers and consumer centric marketing using IMS secondary data.
• 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

Confidential, Wilton, CT

Business Analyst

Responsibilities:

• As a client service analyst, provided top line business reports, analyses, and solutions using both syndicated and customized data analysis to client defined business objectives using Nielsen data. Conducted market research that captured data on target market, demographics, competitor initiatives and industry trends
• 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