SUMMARY

• 20 Years of consulting experience in Business Intelligence technologies
• Excellent track record of successfully executing Upgrades and Execution of multiple Projects in BI space
• Excellent Communication & Problem - Solving skills with excellent domain experience in Animal Pharma
• Well versed in SDLC, Agile, Application Support and Maintenance methodologies
• Expert level proficiency in Cognos, Tableau, QlikView and Power BI
• Cognos Administrator and Senior Developer at an Animal Pharma Company for last 10 years
• Handled large project teams, across the globe and well versed in GDM
• Involved in all phases of project from Design till implementation for major manufacturer in US

TECHNICAL SKILLS

Cognos: Report Studio, Query Studio, Analysis Studio, Power play Studio, Event Studio, Map Manager, Framework Manager, and Server Administration, Lifecycle Manager, Business Insight Advanced, Transformer, Cube Automation, Report Fellow, Meta manager. Cognos Analytics, Tableau 10.5, QlikView 12

Databases: Oracle, SQL Server, DB2, IDMS, Exasol

PROFESSIONAL EXPERIENCE

Cognos Senior Developer / Administrator

Confidential, Duluth, GA

Responsibilities:

• Migrated Asia Cognos platform from Singapore Sanofi servers to BI
• Migrated Australia - New Zealand Reports, including new folder structure and new security into BI
• Involved in migrating all Cognos servers/ content from Transition Network to BI
• Worked on Integration tasks, including maintaining Cognos Inventory
• Solved BISM tickets / Service now Tickets
• Created Year End Packages and reports to ensure no issues during year end
• Developed Sales Agent Dashboard, Large Animal KPI report, Pets Performance Bonus report, Summer Pets Promotion report
• Supported RND TM1 Budgeting and forecasting application
• Integrating TM1 with Cognos BI
• Creation of Dimensions, Cube and Reports
• Writing business rules for complex calculations
• Developing various security levels (folder level, Report level, Data level)
• Integrating External data sources (Oracle, SQL-Server, CSV files) to fetch the data
• Lead move to Cognos Analytics - with tools like Metamanager, Reportfellow and Cube Automation
• Supported BIVI Cognos Platform

Cognos BI Senior Developer and Administrator

Confidential, Duluth, GA

Responsibilities:

• Worked on various projects for development of reports like RND, Varicent, Daily Sales Flyer, large Animal Scorecard, District manager Dashboard etc
• Developed complex cubes like US BISANGLO and modified Potential cubes, RND Cubes
• Helped in automating the setup of new cubes in Sanofi Servers
• Involved in testing of migrated content from Confidential to new NGDC servers
• Expert in Administration of Cognos Servers, including content migration, user security, schedule set up and monitoring
• Involved in framework manager Design of the model for Cognos reports and Dimensional Design for cubes
• Excellent expertise in creating High Level / Low level Design and architecture documents
• Well versed in Global Delivery Model, Coordination and Work allocation to Team members
• Involved in code reviews, Cognos Upgrades and test of the same
• Responsible for Customer Satisfaction and helped in achieving the same
• Involve in other organisational initiatives like recruitment on new team members
• Designed dimensions, hierarchies, attributes, and cubes and associated cube rules

Project Lead / Enhance Redistribution

Confidential, Peoria, IL

Responsibilities:

• Planning the project time lines and implementation of the plan
• Risk Management and Control of the cost of the project
• Design of framework manager for Cognos reports
• Involved in creation of HLD, LLD and architecture documents
• Involved in Onsite - Offshore communication, Coordination and Work allocation to Team members
• Involved in code review of the Cognos Reports, Confidential security code and make sure Quality and performance of the System are met

BI Install Project /Cognos

Confidential, Detroit, Michigan

Responsibilities:

• Involved in installation of Confidential for Cognos for product development environment in GM
• Involved in Cognos upgrade project from Report net MR3 to Cognos 8.2
• Planning the installation and following the GM specific SDP R10 process
• Preparation of technical documents for PDAT (Product Development Architecture Team)
• Installation and Testing of Cognos Confidential and BI in the UNIX environment
• Configuring the LDAP Security for BI installation
• Testing the Cognos 8 reports for performance using Load Runner
• Documentation of the installation in the GBD (Gold Build Document) Format
• Administer Cognos test environment servers
• Coordinate with multiple vendors for information and process
• Help debug the issues in Cognos 8 upgrade
• Fix warranty issues for the Fast track reports, Audit Usage reports
• Develop 2 new reports for the SMAD

Project Lead / Cost Reporting System

Confidential

Responsibilities:

• Planning and estimating for the project, keeping the plan up to date
• Tracking and monitoring the project as per the plan
• Preparation of technical documents
• Installation of Cognos 8 BI Test Environment at Offshore
• Guide team to design, code and test reports in Cognos 8
• Reporting project status to Delivery Manager and customer
• Getting the inspections/reviews done as per the plan
• Conducting project review meetings
• Customer communication
• Metrics collection, analysis and usage
• Maintaining quality records
• Requirements gathering and documentation
• Technical issue handling, Approval of technical documents
• Scope change management
• Effective customer feedback / requirement communication to team
• Ensuring timely finalization of reasonable acceptance criteria and timely sign-offs on project artifacts

Confidential

Responsibilities:

• I was part of Eden Phase II is extension of the Eden project. Trade and Promotion information is captured in the TIPS system. This data is extracted and loaded in the data warehouse using the Data stage as an extraction tool. Cognos powerplay is used to create the cubes
• NUTS SFA is for the Consumer Healthcare division. This project relates to the Sales Force Automation. From the Source system, Sales, promotion, calls related information is captured and put into the data warehouse. Cognos is used for reporting purposes. These reports are used for giving incentives to the Sales force
• Intent of project is to replace the current SCDW with a new Supply Chain Data warehouse (SCDW) with new set of tools
• Involved in migration and enhancement of reports from Micro strategy to Cognos
• Involved in Requirements gathering and documentation, preparation of technical documents
• Preparation and review of Design Documents
• Involved in preparation of Test Cases and Data Validation
• Design, code and test reports in Cognos Impromptu and Powerplay
• Design Transformer Cubes and resolve Cognos server issues
• Reporting project status to Onsite Project Manager
• Follow Quality procedures and get inspections/reviews done
• Involved in Onsite - Offshore communication and resolving technical issues
• Ensuring timely completion of project deliveries

Confidential

Responsibilities:

• Confidential is an international financial services company with offices around the globe.
• CCFS EMEA is the technology management unit which is responsible for managing multiple applications deployed across EMEA.
• EMIS is the reporting environment used by the Finance, Credit and Risk departments in Confidential .
• EMIS provides various reports and cubes to the users to analyse. EMIS has been in existence in Confidential since 2000. This project has evolved in stages, according to the user requirements. EMIS Packaging- Move to production project is to streamline the existing system and move the system into production. Current manual tasks and security concerns are addressed in this project
• As a project lead, went onsite to London, to gathered User requirements. Documented all the user requirements and got the project to offshore. Transferred knowledge to offshore team. Installed the test environment at offshore and implemented the changes required by the client

Confidential

Responsibilities:

• This project is to demonstrate the advantages of the Package products (Cognos Vs Hyperion) for planning, budgeting and reporting data
• Developed 3 Cubes and 8 Reports to demonstrate Powerplay tool. Developed Catalog and Impromptu report to demonstrate drill down capability in Powerplay

Confidential, New York

Responsibilities:

• DSS Cognos - DSS-Cognos (Decision Support System) project is part of the EDW (Enterprise Data warehouse) team, handling Reporting part of the various applications.
• Independently supported ARTS, Single bill, DBG Scorecard Applications. Provided data extracts for the development of PMP reporting. Maintained Cognos Impromptu reports and Powerplay cubes. Worked on Powerplay enterprise server, Impromptu Web Reports and Server administration, Cognos Access Manager, Cognos Script Editor, and Scheduler. Handled User support issues

Confidential, MA

Global Sourcing Data warehouse

Responsibilities:

• Confidential wanted its Sourcing data to be readily available so that it can be supplied on to the Internet and reports can be developed easily out of it.
• Designed, Coded and tested the data extract from IDMS database

Confidential

Global Supplier Net

Responsibilities:

• Confidential has taken a major Extranet Initiative for Providing access to its internal data to its supplier’s. As part of the Global Supplier net, Invoice and the Purchase Order Information was supplied to the Vendor’s on the Internet
• Extracted data from IDMS Database and supplied it to another team, which hosted the data on the Internet. Implemented this project for 3 months in Pittsfield, MA, USA as well as in Bergen op Zoom, Netherlands

Confidential, New Jersey

Aspire Conversion Project

Responsibilities:

• Agency, Sales Personnel Information Repository (ASPIRe) is the Prudential Database system maintaining the information about Prudential Agents.
• Project is to convert the Agency Database (ADB) from IDMS (Integrated Database Management System) to DB2.
• As Team member, developed Test Plans for testing the Conversion. Fine-tuned the system to improve the Response time of the converted system

Confidential, New Jersey

AOS Maintenance Project

Responsibilities:

• Advanced Ordinary System (AOS) is the software System used by the Confidential to maintain its Life Insurance Policies.
• This system generates reports about the insurance details of the policyholders at the end of every day.
• It consists of 2000+ modules divided into about 20 functions.
• Premium Remittance function is responsible for validating premium payments, updating the Master Record when premiums are paid and for performing accounting related to the premium payment/charge received.
• From a team member, became a Module Lead for premium Remittance Team. Promptly cleared all Tickets assigned to the Module. Worked on enhancements (SCMs) also