SUMMARY

• Innovative, business - focused Senior Business Intelligence Architect and Qlik Administrator with more extensive experience in designing, developing, and managing sophisticated DW/BI solutions.
• Strong expertise in building robust and scalable Qlik environments.
• Subject matter expert for technology planning and prioritization aligned with corporate growth goals.
• Demonstrated ability to lead cross-functional teams to execute high-risk projects.
• Fully versed in best practice-based design, architecture, and implementation supporting major reengineering initiatives and integrations due to merger/acquisition.
• Successfully managed multiple globalpharmaceutical commercial business intelligence systemsimplementation projects budgets of over $2M.
• Hands on experience in building multi-node scalableQlik SenseEnvironment
• Experience in Qlik Sense software upgrades including synchronized to shared persistence migrations.
• Extensive expertise in architecting scalable clustered Qlikview architecture leveraging horizontal and vertical scaling methods.
• Designed and deployed multi-tier data and application architecture to handle growing Qlik applications footprint.
• Extensive expertise in estimating RAM footprint for Qlik landscapes based on estimated size of applications and concurrent usage.
• Designed and deployed Governed self-service security architecture and enabled the easy governance of ever increasing user and application footprints.
• Developed complex Qlik data models, objects, reports, graphical interactive UI and dashboard integrating data from multiple data sources like Oracle, SQL Server, SAP BW, QVD files, Access, text files, excel documents as per user requirements.
• Designed and developed several Qlikview/Sense prototypes, presented to business executives and recommended and acquired approval for analytics solutions.
• Established Data modeling and UI design best practices and ensured the effective realization within power users and development team
• Hands-on expertise in Active Directory database configuration, tasks creation, External program setup, setting up security (NTFS, DMS Authorization, Section Access), managing Licenses (CAL) using QMC (Qlikview Management Console)
• Collaborated with vendor in installing Qliksense landscape.
• Managed Qlikview software upgrades from 9 to 10 to 11, 12 and server migrations.
• Designed and developed high performance Qlikview applications leveraging advanced scripting and data visualization capabilities
• Demonstrated proficiency in dimensional data modeling, database Schemas like Star, Snowflake Schemas and DW/BI concepts.
• Designed and implemented statistical datamart solutions leveraging Informatica ETL, Oracle and SAS that provided self-service capabilities
• Established data modeling process standards/best practices, created several conceptual/logical, physical data models, business process and data flow diagrams.
• Comprehensive experience in Technical Project Management, Project Scoping, Costing and Resource Planning, Technical Proposals and System landscape designing
• Assisted organizations to implement BI systems and strategies with strong technical leadership and effective project management.
• Build credibility, establishing rapport, and maintaining communication with stakeholders at multiple levels and provided information regarding the ongoing projects and initiatives, including those external to the organization
• Assisted with establishing Business Intelligence financial year strategic Road maps.
• Hands-on experience in creation of generic extractors conceptualized and enhanced extractors that pulled data from SAP SD/MM/PP and CRM systems into SAP BW.
• Functional and configuration experience with SAP BI/BW, SAP Business Objects Reporting, SAP Business Planning and Consolidation (BPC)
• Extensive experience in integration of SAP BI/BW with SAP-CRM Sales Planning, Territory management, Activity Management, Business Partner Management, SAP ECC’s consignment and HR modules

TECHNICAL SKILLS

• Mobile Intelligence: Qlikview 11
• Tableau 8x
• Spotfire 6x 7x 8.1 Veeva iRep and SAS
• Oracle 11G/10G/9i/8i/8.0
• Informix Dynamic Server v9.0
• SQL-Server 2005/2000 & 7.0
• DB2
• Brio Performance Suite 8.2
• SQR Developer
• Brio one 6.6
• Informatica iCloud
• Informatica Power Center 9.0.1
• VB script
• JAVA Script
• Unix Shell scripts
• SAP BW 7.3/7.1/3.5
• ECC
• CRM
• HR
• FICO/GL/AP/AR
• Business Objects Suite XI 4.0 3.1
• Dashboard design (Xcelsius)
• Crystal reports
• Life Cycle Management Console
• BO Data Services 4.0
• Business Explorer Suite
• BEx Query Designer
• Analyzer
• Web Application Designer
• Visual Composer
• Analysis process designer
• ABAP
• PL/SQL
• SQL
• Developer 2000
• SQR 8.2 and Perl
• Linux
• AIX
• HP Unix 11.0
• SunOS 5.8
• Windows 2003 Server
• Windows (Project
• PowerPoint
• Visio
• Excel
• Word
• Access)
• Remedy
• Visual source Safe
• Service Now.

PROFESSIONAL EXPERIENCE

Confidential

Senior Solution Architect

Responsibilities:

• Architected and managed the deployment of Qlik Sense self-service analytics platform for a global Pharmaceutical client.
• Installed and configured multi-node scalable Qlik Sense environment on Amazon VPCx servers.
• Configured virtual proxies using SAML authentication method and enabled Auth0 authorization for external users.
• Designed and deployed Governed self-service security architecture and enabled the easy management of ever increasing users, streams and application footprints.
• Installed and configured Qlik NPrinting 17.3. Developed and deployed formatted reporting and distributed to users.
• Established cross-functional relationships and directed all requirements gathering, data analysis and documentation for enterprise projects to build self-service data models and analytics.
• Improved team efficiency by 30% with the definition of a data analysis and analytics development practice including standardized processes, reusable templates and extensive business intelligence / data warehouse training.

Confidential

Business Intelligence Consultant

Responsibilities:

• Designing and developing Qlik analytics and dashboards using complex scripting and functions for integration of accounting position data with other trading systems data.
• Reviewed Qlik application architecture in Aflac Global Investments and developed and implemented solutions for fine-tuning the performance of various business dashboards.
• Assisted Citibank in establishing Business Intelligence Center of Excellence (COE) to realize full value of their BI Investments
• Analyzed the gaps in automation processes and established best practices for streamlining.
• Enhanced the automation framework for on-boarding business dashboards into enterprise architecture. Created document administrators, On-boarded, hosted several Qlikview projects and applications on Citi's centralized Qlik environment
• Enabled the power tools application in the Qlikview landscape and created customized Qlikview Governance dashboards for more sophisticated administration of the platform.
• Installed, configured scalable clustered QlikSense environment on AWS cloud servers

Confidential

Business Intelligence Manager/Architect

Responsibilities:

• Qlikview Landscape Redesign:
• Designed the architecture and deployed a scalable Qlikview environment considering complex demands of geographic expansion and multiple mergers and acquisitions.
• Analyzed existing systems/applications, defined and recommended effective strategy for handling RAM footprint and CPU capacity based on user/data growth.
• Drove the deployment, configuring/clustering new QV servers, migrating publisher tasks, defining CALs procurements in collaboration with infrastructure, SAP basis, and functional teams.
• Sales analytics platform:
• Designed and deployed a multi-tier, shared data model to address the needs of expanding sales force teams, product lines and flexible resourcing. The platform consists of 9 different Qlikview analytics (including Retail Sales analytics, Daily Activity dashboard, Monthly Plantrak analytics, Institutional Sales force analytics, National Sales dashboard, etc.)
• Designed and built Qlikview PoCs with redesigned UI and demonstrated to executive stakeholders and obtained approval sign-off.
• Developed shared QVD extraction layer which extract data from SAP BW, Oracle, Excel
• Developed complex business rules using advanced scripting to increase dashboard performance. Designed weekly data model with denormalized weeks for reducing data size and increasing the performance
• Used variables, Flags and Set Analysis in front end for increasing performance.
• Created Line charts, Pivot tables, Pie charts to compare prescription between different geographies (Area, Region, Division, Sales Force, Territory, Zip Code)
• Created tasks to reduce data for multiple level of geography, and to distribute to the field Sales Reps. (~3000 files)
• Designed and created conceptual/logical, physical data models for the SAP BW Data warehousing, built business process and data flow diagrams and gained approvals from senior management. These data model standards are implemented across other BI verticals like R&D, HR and finance.
• Mobile BI analytics:
• Developed and deployed Qlikview analytics for 3000+ U.S. sales staff on iPads that provided unprecedented performance metrics and decision-making capabilities. The solution included pre-call planning for key customers and day-to-day management of territory performance.
• Redesigned data visualization capabilities for iPad rendering and built Qlikview prototypes for approval.
• Designed and developed device based tabs displays leveraging existing data models.
• Sales and Marketing Datamart:
• Designed and implemented statistical Sales/Marketing datamart solutions leveraging Informatica ETL, Oracle and SAS that provided self-service and decision-making capabilities.
• Implemented various performance improvement techniques including table partitioning, efficient indexing strategy, Informatica session partitioning, parallelization, and aggregation to process more than 750 million records and reduce data load and accessing time. Enabled end-to-end automation from data loading to refreshing reports.
• Managed Qlikview server hardware upgrades and software product versions upgrades from 10 to 11 and 9 to 10.
• Managed SAP BI/BOBJ Reporting suite for huge pharmaceutical sales systems critical to tactical and strategic decision making for 3000+ field staff and executives.
• Achieved multiple merger and acquisition (M&A) synergy targets with Consolidation of Commercial Sales Data warehousing and BI analytics systems.

Confidential

Lead System Analyst

Responsibilities:

• Created Sales analytics to track the performance of the forest brands over competitor products. Provided the flexibility of selecting the analytics through various selection parameters such as Rx Type, Channels and pay types, Product View (Market, Product Group and Product), Product Order, Time Periods (last 13 weeks, last 12 months), Set up publisher job to do incremental weekly/monthly extract.
• Helped expand BI and analytics capabilities into Europe and Canada (integrated Qlikview tools with existing systems and applications, such as Veeva). Built Qlikview dashboards and scorecards to see Forest leading products and vs. direct competitors, and vs. indirect competitors.
• Developed a Messaging and Alerting BI solution that increased Sales Representatives’ knowledge of brand-specific customer behaviors and trends and helped bridge communication between the home office marketing teams and the mobile sales force.
• Served as key resource for automating SAP BW ETL loads of Realignment process that reduced manual inputs and associated overhead.
• Designed and implemented Sales and Distribution reporting and analytics capabilities using SAP Business Objects tools. Activated and initialized standard SD extractors such as 2LIS 11 VAITM, 2LIS 11 VASTI, 2LIS 12 VCITM for Sales Orders, Delivery, Billing items. Developed Dashboards using WAD and Visual composer and integrated them to Portal through iView’s. Developed several ABAP routines in transformation at start and end routines.
• Managed SAP CRM integration that extracted Business Partner, Call activity details data for BOBJ Reporting suite critical to tactical and strategic decision making and sales compensation programs

Confidential, NY

Database Architect

Responsibilities:

• Assessed the priority of the reports based on development timeline and consolidated 300+ public financial reports into 15 ‘core reports’.
• Redesigned long running sqls and optimized the financial applications performance. Designed and executed the DR strategy for all the SQL servers.