HIGHLIGHTS

• Proven BI solution delivery capabilities
• Expertise in Sales and Marketing analytics in Pharmaceutical commercial space
• BI advisory role at clients
• Business centric approach to managing project and solution delivery
• Manage engagements with onsite and offshore teams
• Plan and manage project budget, track accruals, forecast to completion
• Expertise in Performance Dashboard and Scorecard design, Information Visualization
• Direct communicator with strong leadership skills
• Technical leadership on solution approach, design and development

POSITIONS

Confidential

• IT liaison for Marketing organization, enabling IT functions and processes supporting Market Research
• Plan and manage delivery of performance dashboard solution and analytics platform for advanced analytics
• Solution recommendation to business, socialize solutions with business and IT stakeholders
• Business analyst role - lead business requirements sessions, metrics consolidation, feasibility analysis
• Partner with Enterprise Architecture, Data Management and vendors in solution and data architecture process
• Part of team that evaluated visualization tool most value add for business in alignment with Enterprise solutions roadmap
• Worked with business teams to define dashboard metrics, KPIs, data sources and gain alignment across functional areas on definitions
• Owned the process of refining metrics and confirming business rules
• Collaborate with external vendors and drive process to source data to meet project needs

Key Applications Used: MS Project, MS PowerPoint, Tableau, SQL Server, SQL Server Management Console

Confidential

• Technical leadership and guidance to team on Marketing Intelligence projects
• Manage and oversee delivery of self-service BI to Marketing groups Marketing data warehouse, performance dashboard and ad-hoc analytics platform
• Lead team of architects and analysts and collaborate with partner consulting firm in implementation and deployment of multiple BI solutions to Forest Marketing organization
• Partner with Market Analytics group to design dashboard and other analytics solutions
• Collaborate with consulting firm and data vendors IMS, SDI and Nielsen on building data extraction and integration of pharmaceutical audits on Prescriptions, Sales, Promotional Spend
• Drive adoption of BI solutions by business, and sunset of legacy reporting environment - build partnerships with Marketing business leads and executives
• Build and lead a team of customer focused BI professionals, drive cross training, mentor staff, align team to department goals
• SME on visual representation of data and corporate dashboard design methodologies
• Manage and track annual budgets up to 1.8 million USD

Key Applications Used: QlikView 11/10, SAP Business Objects Enterprise Suite XI 3, SAP BW, Oracle 11g, HP PPM, Adobe SiteCatalyst, IMS DataView, MS Project, MS PowerPoint

Confidential

• Key member of Analytics team delivering Multi Channel Marketing analytics solutions to major Pharmaceutical client
• Lead design and delivery of performance dashboards on Closed loop Multi Channel Marketing to clients
• Partner with customers, internal groups, third party vendors and technical groups to build dashboard delivery infrastructure
• Designed and developed dashboards on telesampling, e-sampling programs measuring KPIs on target response rates, drop offs, lifts and shifts, causal analysis
• Developed scorecards on web analytics KPIs for HCP and consumer facing brand websites - measuring and tracking web traffic, path optimization, literature downloads, sources, keywords and drop off websites
• Information support for Multi Channel Marketing campaigns touching various phases - Program Objectives/positioning, segment valuation, messages and tactics plan, metrics planning, reporting, campaign optimization and program learning
• Vendor evaluation for integrated Campaign Management solutions
• Designed and developed performance dashboards for HR on Recruitment Analytics analysis by agencies, fees paid, positions filled by agencies by skillset and positions left, reasons for separation
• Trained analytics group in Xcelsius dashboard tool

Key Applications Used: BusinessObjects Xcelsius 2008 SAP Crystal Dashboard , SQL Server 2008, Adobe SiteCatalyst, IMS DataView, MS Project, MS PowerPoint, MS Excel

Confidential

• Led a BI consulting team to execute projects and deliver solutions that added value to the clients' decision making process. Highlights from my engagements are:
• Wright Express - New England-based fleet expense management services firm: Setup and designed BusinessObjects analytical environment for Revenue reporting and analytics for KPIs, including dashboard on Xcelsius designed and implemented BusinessObjects security collaborated with BI stakeholders and business analysts trained senior management in ad-hoc analytical environment.
• AT T - major wireless telecom company: Developed BusinessObjects-based analytics that helped management plan to generate more business by effectively analyzing browsing patterns of their customers on their internet gateways WAP . Our team delivered a BI solution that became a source of invaluable knowledge that helped drive the company's critical decision making.
• Hoffmann La Roche now Genentech top pharmaceutical company: Designed and developed BusinessObjects based analytical platform for Sales and Marketing Analytics teams. The key success factors that we met were increased efficiency in Customer Segmenting and Targeting Strategy and higher returns in Calls Activity.
• Univision - leading Spanish-language media company: Implemented a replacement financial reporting system that is centralized and scalable, General Ledger rapid mart, allowed for budgets, forecasts, and other performance statistics to be compared in the context of operating results.

Key Applications Used: QlikView 11/10, BusinessObjects Xcelsius 2008 SAP Crystal Dashboard , SAP Business Objects Enterprise Suite XI 3/R2/6.x/5.x, Performance Manager XIR2 Application Foundation 6.5 , Business Objects Java SDK, Crystal Reports 2008/XI R2, SAP BW, Oracle 11g/10g, SQL Server 2000/2005/2008, Sybase 11.x, DB2, MS Access, CARS/IS Contract Administration and Reporting System , Oracle Siebel eClinical, Toad, Pl/SQL Developer, Windows Server 2008, MS Word, MS Excel, MS PowerPoint, MS Project

Confidential

• Helped sell the idea of BusinessObjects as standard analytical platform to corporate users.
• Successfully deployed a corporate dashboard on BusinessObjects platform. Played key role in requirements analysis, design, development and delivery of analytics on dashboard portal.
• Led the efforts to upgrade BusinessObjects environment packaging and deployment of BusinessObjects application migration security management Installed and configured BusinessObjects server on test machine.
• Single point of contact for issues resolution, report requests from key business user groups. Led BusinessObjects team of 2 developers responsible for report developments and enhancements
• Data analysis on target customers, market potential, market share, new product sales performance. Created presentable information on invoices, chargebacks, IMS-supplied market sales analysis for proposals to GPOs, GPO contract extension
• Trained business users nationwide on newly rolled out dashboard application. Created training documents for presentation.

Key Applications Used: Business Objects Enterprise Suite 6.x, BusinessObjects Application Foundation 6.5, Salesforce.com, Oracle 10g/9i, MS Access, Toad, Pl/SQL Developer, MS Word, MS Excel, MS PowerPoint, MS Project

Confidential

• Provided expertise in BusinessObjects-based BI delivery for Sales and Marketing at Hoffmann-La Roche, a major Pharmaceutical company. Played key role in providing actionable information to managers on demand.
• Helped increase the reliability of BusinessObjects reports and gain user confidence by efficient management of user requests
• Functioned in various capacities including: managing user requests, reporting issues, gathering requirements, developing prototypes, reports development, training users and development team in Business Objects
• Developed BusinessObjects universes and reports on contract sales, performed sales data analysis, tested application/interface

Key Applications Used: Business Objects Enterprise Suite 6.x/5.x, Oracle 9i/8, MS Access, Toad, Pl/SQL Developer, Crystal Reports, SQL Server 2000, Sybase, MS Access, CARS/IS Contract Administration and Reporting System , Toad, Pl/SQL Developer, Windows 2000 Server, MS Word, MS Excel, MS PowerPoint

Confidential

• Functioned as BusinessObjects developer at Fairchild Semiconductor - one of world's leading IC chip manufacturer for commercial market, and at Hoffmann-La Roche, a major Pharmaceutical company.
• Played visible role in popularizing ad-hoc reporting among the user groups and was responsible for BusinessObjects analytics development, testing, and change management
• Participated in joint requirements analysis sessions, developed close association with project sponsors and users that aided project success
• Developed BusinessObjects universes and reports around Sales, Market Analysis, Orders, Shipping Performance, Cycle Time, Inventory Age, Help Desk, Customer Contact and Change Management
• Wrote training documents, trained users in BusinessObjects applications and in principles of BI

Key Applications Used: Business Objects 5.x, MS Access, Toad, Sybase, MS Access, Pl/SQL Developer, MS Word, MS Excel, MS PowerPoint

Confidential

• Held programmer/analyst positions at Tata Consulting Services, in Mumbai India and with Price Waterhouse Associates later Price Waterhouse Coopers in Calcutta India.
• Developed Oracle applications using Oracle Forms, Oracle Reports and Pro C for Clearing and Settlement system at National Stock Exchange of India Limited
• Developed Decision Support prototype for National Stock Exchange of India Limited on Oracle Express and SAS
• Designed and developed a new Budgeting System for BPL Ltd., a leading player in consumer products manufacturing. The new system improved upon older excel based system by eliminating redundancy and human error, providing user friendly interface and improving budget cycle time.

Key Applications Used: Oracle Express, Cognos, Oracle 7, SQL Forms, SQL Reportwriter, SQL Menu, SQL Plus, PL/SQL, Visual Basic, C , Pro C, Windows NT Server/95, HP UNIX, MS Word, MS Excel

TECHNICAL PLATFORMS

Analytics and Development Platforms

• Tableau 8.2/8.1, QlikView 11/10, Xcelsius 2008 SAP Crystal Dashboard , SAP Business Objects Enterprise Suite XI 3/R2/6.x/5.x, Performance Manager XIR2 Application Foundation 6.5 , Business Objects Java SDK, Adobe SiteCatalyst, Crystal Reports 2008/XI R2, Cognos, Oracle Express, Adobe Forms
• Databases and SQL Tools
• SAP BW, Oracle 11g/10g/9x/8x/7x, SQL Server 2000/2005, Sybase 11.x, DB2, MS Access, Toad, Pl/SQL Developer, SQL Forms, SQL Reportwriter, SQL Menu, SQL Plus
• Business Applications
• CARS/IS Contract Administration and Reporting System , Salesforce.com, Oracle Siebel eClinical
• Programming Languages
• PL/SQL, Visual Basic, C , Pro C
• Operating Systems
• Windows Server 2008/2003/2000/NT/Vista/XP/95, HP UNIX
• Office and Productivity
• Word, Excel, PowerPoint, Project, MS Outlook, Thunderbird, Explorer, Google Chrome, Firefox