SUMMARY

• Senior established with 12+ years of experience in design, development, testing, implementation, documentation & Operations of Pharma, Financial, Clinical and Commercial technical applications in client/server and web based Business Intelligence environments.
• Experience in Cognos Administration, server management, migration and Installation & configuration activities.
• Experience in In - Memory analytics tools like Tableau, Qlikview. Well versed with ETL tools like Informatica PowerCenter & Datastage.
• Significant experience in Tableau Desktop version 9, 10 & Qlikview Desktop 12.
• Exposure in working with AWS, Redshift, S3.
• Working knowledge of Data Science programming including Python & R.
• Extensive experience in Cognos Tools such as Cognos 10 BI Suite, Cognos 8 BI Suite (Framework Manager, Cognos connection, Report Studio, analysis Studio, Query Studio & Event Studio) Cognos Report net 1.1.MR3, Cognos Impromptu 7.x and Analysis Tools such as Cognos Transformer & Power Play 7.x.
• Expertise in Dashboard & Reporting for Desktops and iPads with Active Reports
• Expertise in Advanced Reporting i.e. Bursting, Drill-Through, Cascading, Multi-Tab, Conditional Formatting, Search
• Expertise in developing complex Executive Dashboards in Report Studio & Cognos Business Insight.
• Expertise in designing models using Framework Manager and deploying packages to Report Servers.
• Well versed with Extraction, Transformation and Loading (ETL) using Datastage 8.X. & Informatica PowerCenter.
• Strong Experience of Admin activities like Installation & configuration of Cognos in Distributed Environment (Development, Test and Production), Go office and Go Search, Configuration of Third Party Security with LDAP, IIS installations and configuration, Certification deployment for secured access.
• Strong Experience of Cognos server management, Access Manager, Content Store & Content Manager configuration, content deployment activities.
• Involved in Migration activities from Cognos EP Series 7 (7.3 and 7.4) to Cognos 8 BI latest version 8.4.
• Experienced in performance tuning and optimizing of the reporting solution.
• Experience in SQL, PL/SQL, Oracle, Stored Procedures, Functions, Packages as per business requirements.
• Strong knowledge in Data Warehousing concepts (Star schema, Snow Flake Schema) and experienced working with large DataWarehouse & Operational Databases.
• Sound knowledge on Unix shell scripting, Control M.
• Proficient in building front-end BI applications according to specifications.
• Strong Experience in Sales Reporting, Marketing & Clinical Trials domains.
• Expertise on Change Management, Problem Management, Configuration Management and Release Management Processes and developed reports to see the performance of those processes under Business perspective.
• Strong analytical, statistical, conceptual, and problem-solving abilities.
• Able to work independently as well as collaborating with multiple teams to meet project requirements and deadlines.
• Working with the Customer Teams to resolve any functional and technical issues faced by the project team.
• Excellent written and verbal communication skills and expertise in working with multi-regional clients and functional teams.

TECHNICAL SKILLS

• Tableau Desktop 9,10, Qlikview 12, Cognos 8.x 10.x BI Suite), Business Objects XIR2, Informatica PowerCenter
• Datastage 8.x, Amazon Redshift, S3, MS SQL Server 2005/2008, Oracle 9i/10g/11g,IIS, REST APIs
• HTML, JavaScript, SQL, PL/SQL, Active Directory, Windows Server 2003, 2008, UNIX, MS Office suite, ITIL v3, BMC Remedy, ServiceNow

PROFESSIONAL EXPERIENCE

Confidential

Onsite BI Technical Lead

Responsibilities:

• Collaborate with multiple Business and IT Stakeholder teams to gather, analyze and document the requirement in the form of Business Requirements and translate them into Functional Specifications.
• Analysis of Functional Specifications and creation of Technical & Design Specifications for relevant mappings and data flows to integrate Business and Technology.
• Designing & Developing Logical and Physical data models that capture current and future state of data elements & attributes.
• Developing various Dashboards to support Customer needs for reporting solutions for Operational use as part of Data and Analytics solutions.
• Conduct & facilitate user trainings & Demo sessions for the Business & IT end users.
• Create and Review Test Plans and Test Strategy for the planned deployments. And support during User Acceptance Testing & Deployment.
• As part of Operations & Application Maintenance services to be involved in: Defects solving, Code debugging & troubleshooting, Performance tuning with the support of Service Now ticketing tool assisting Business to operate more effectively and efficiently.
• Propose value addition process and solutions to client resulting in reduction of manual efforts & increasing overall system efficiency.
• Conducting regular Scrum meetings with Regional Service Owner & Monthly Service Review meetings with Business Unit IT owners and Product line owners.
• Review all the operational change requests and prioritize it in collaboration with Business & IT stakeholders.

Confidential

Onsite Technical lead

Responsibilities:

• Responsible for Service Delivery of the Portfolio as per committed SLAs and KPIs while ensuring quality of deliverables and compliance
• Involved in the doing Proof of Concepts and designing Screens Layouts as per customer’s needs.
• Responsible for gathering Requirements, Analysis, Design, Development, Deployment, Testing and Support of rich Interactive Dashboards.
• Design & Development of data models & Reports for functional and Business required attributes.
• Demo sessions & relevant tools trainings for the application Business & IT end users.
• Create, Review Test Plans & Test Strategy and support during User Acceptance Testing & Deployments.
• Performance Tuning of reports & Dashboards.
• Manage the onboarding and off-boarding of applications
• Facilitate demand & capacity planning
• Review operational change requests and prioritize in collaboration with Novartis for release management
• Drive elicitation and implementation of approved ideas for continuous service improvement and transformation
• Participate in IGM audits, as required
• First level of escalation for IT & Business
• Responsible for overall team logistics