Hardware Configuration Data Manager

Lakshmi Bhargavi Email: adwdg6@r.postjobfree.com

Phone: +1-559-***-****

PROFESSIONAL SUMMARY

Around 5+ years of IT Industry experience encompassing a wide range of skill sets specifically in Business Intelligence area including IBM CognosBI, DataStage, Cognos Administrator, Oracle and AWS basics,

Experience in Data warehousing and business intelligence technologies along with 2 years of data visualization using Tableau

Hands on experience on Tableau desktop, Tableau reader and Tableau server

Maintenance of TM1 user, role, and security.

Document TM1 and planning-related processes, model design and data flow

Preparing project documents at various stages of project

Supporting user queries and production support once the application is live

Thorough knowledge of Cognos administration, tuning and report-writing, data warehousing and BI architectures, user administration, report development, data modeling, and integration, system software, and hardware configuration and updates, Cognos testing and troubleshooting

Proficiency in using IBM Cognos BI Suite and components such as cognos connection and Query, report, event and analysis studios.

Ability to gather business or user requirements and develop and maintain reports using Cognos 10 and 11

Strong analytical skills with the ability to solve complex Cognos BI and performance issues

Effective communication and presentation skills along with the ability to provide technical support to team members and clients

Solid leadership and mentoring skills as well as the ability to work independently and in cross-functional teams

Strong organizational skills as well as the ability to perform multiple tasks simultaneously and complete projects under specified deadlines

Experience in the field of analysis, design, development, customizations, and implementation of software applications including Data Ware housing

Proficient in analyzing and translating business requirements to technical requirements and architecture

Executed software projects for Data Warehouse industry under manufacturing and healthcare domain

Strong functional abilities, flexible and goal oriented, good communication and interpersonal skills with self-motivation and quick learning at the work

Assisted senior admins and developers in implementing effective Cognos BI and relate analytical solutions as well as provided support in the designing and deployment of new reports and modification of existing ones as required

Installed, upgraded, and maintained security of all Cognos BI components, software applications and systems and monitored and controlled server usage as required as well as implemented and documented best practices of Cognos infrastructures

Certified in AWS Certified Solutions Architect - Associate certificate

SKILL SET:

Cognos 11/10 (Report studio, Query studio, Analysis studio, Cognos workspace, Cognos administration) Cognos TM1

Modeling Tools

Cognos Cube designer, Cognos transformer and Cognos framework manager, oracle data integrator (ODI)

Operating Systems: Windows server, Linux

Languages: SQL, PL/SQL

Database: Oracle 11g

Tableau Desktop, Tableau server

PROFESSIONAL EXPERIENCE:

BAXTER -July 2019 to Dec 2021

Role: Developer and Cognos Administrator

Environment: Cognos BI, Framework Manager, IBM Data manager, Oracle, AWS, Cognos TM1

Project:

1. HEALTHCARE

Client : A leading Global Medical Devices and Pharmaceutical company

Role : Developer and support

Project Environment: Cognos BI, IBM Data manager, Oracle, AWS,

Description:

The client is a leading Global Medical Devices and Pharmaceutical company headquartered in US. Responsible for transitioning from the existing team and providing support to various critical BI applications for meeting day to day business intelligence reporting needs. These applications are based on Cognos reporting platform along with IBM Data Stage and Cognos Data Manager as the core tools.

Responsibility:

Responsible for supporting applications based on Cognos 10.2 and Cognos 11 reporting platform.

Generating new reports, modifying existing reports (Dashboards, Drill through reports, Master Detail relationship reports, Cross tab, List, Chart) using Cognos report studio, Analysis Studio, Workspace advanced.

Leading the team and mentoring junior resources.

Implementing security - Managing user profiles, creation of groups and data sources.

Responsible for Server Administration.

Deployment of reports/ packages from DEV to ACP and to Production

Accountable for performance tuning of Cognos reports.

Coordinate and communicate with the client for resolving issues. Resolving user issues through BMC remedy ticket management.

Migrated Cognos from on premises IBM data center to AWS cloud platform. Implementing and leveraging AWS solutions to optimize the cost and improve performance.

Collaborated with stakeholder groups across the organization to ensure business and technology alignment. Proposed solutions meeting defined specification and needs.

Gathering requirements from the client side and implementing reports by utilizing Cognos BI tools.

Partnered with developers to automate manual process, saving time and money while decreasing errors.

Interacting with the clients on a regular basis to discuss day-to-day issues and matters.

Provide support for DataStage jobs developed which are running into production environment.

Conduct training and knowledge sharing sessions for the onsite and offshore developers and testers on investment banking domain and functional areas.

Involved in Performance tuning of sessions, mappings, ETL procedures, processes for better performance and support integration testing.

Involved in data analysis and handling the ad-hoc requests by interacting with business analysts, clients and resolving the issues as part of production support.

Performed debugging and made appropriate changes to generate the required results.

Liaison with cross functional teams across the enterprise, including development team and various data-warehouse teams (on site and offshore team members)

2. LIMS: Laboratory Information Management System

Project

BaxLIMS Stability Reports:

The purpose of this project is to analyze the stability of the products manufacture in the Laboratory and test at various timepoints and storage conditions using the Cognos Reports from underlying oracle views.

Global COA Template:

The purpose of this project is to design the certificate template required to handover to the distributor after the release of the product. This report has created in Cognos and it is a single report satisfied all the requirement of multiple facilities. The requirement of the certificate is different in every facility.

Quality Analytics Data:

The intent of this project is to present the data flows in Track wise application to the users to create Ad hoc reports in Cognos. Report package has been created and published from framework manager which is used to build the reports.

PMDA and CAPA Archival Reports:

This project has archived the PMDA and CAPA Application Data from Oracle to OPTIM and objective of Cognos is to generate reports from the archived data for FDA Audit purpose.

Role & Contribution

Professional 2: Application Designer

Published Relational model framework Package.

Involved in creating Reports and Dashboards in Cognos

Written Java scripts to enhance the functionality of Cognos.

Written Custom SQL queries to achieve the Report requirement.

Analyzed the data in source database and suggested the suitable visualization for the Business.

Involved in Code Review and IQ Process in HPALM

Involved in Design documentation and ARO Handover

KPIT-July 2016 to Jun 2019

Role: Cognos Developer, Tableau support

Roles and Responsibilities:

Design reports in IBM Cognos Report Studio, Metrics Studio, Query Studio, and Analysis Studio & Event Studio.

Create Reports and graphs using the Power cubes.

Drill Down/Up behavior on Reports.

Create master detail relationships in reports and dashboards.

Develop, maintain, and manage Cognos packages using Framework Manager

Works with internal and external business users and developers to assist with the development and implementation of new reports.

Develop Star /Snowflake schema using Framework Manager

Develop new / enhance existing COGNOS BI reporting & cube structure solutions including framework manager models.

Interact with various development teams, project managers, internal and external customers, and senior management.

Provide estimates for development work and understand deadlines.

Creates, modifies, enhances, and maintains Framework Manager Model within Cognos

Published Relational model framework Package.

Involved in creating Reports and Dashboards in Cognos

Written Java scripts to enhance the functionality of Cognos.

Written Custom SQL queries to achieve the Report requirement.

Analyzed the data in source database and suggested the suitable visualization for the

Business

Involved in Code Review and IQ Process in HPALM

Involved in Design documentation and ARO Handover

Designed and developed Standard Reports, crosstab reports in Tableau.

Prepared Test Cases for unit Testing created various test cases to validate the data, performance and look feel of the reports.

Environment: Tableau 8.2

Role: Developer and Support

Created dashboards for analyzing POS data using Tableau 8.0

Consistently attend meetings with the client subject matter experts to acquire functional business requirements.

Scheduled extract refresh for weekly and monthly reports

Experienced in requirement Gathering /Analysis, Design, Development,Testing, and Production rollover of Reporting and Analysis projects

Involved in trouble shooting of performance issues which were associated with Tableau reports

Provide production support to tableau users and wrote custom SQL to support business requirements.

Utilized Tableau Server to publish and share the reports with business users.

Also involved in administration tasks such as Setting permissions, managing ownership, and providing access to the users and adding them to the specific group

Distributed Tableau reports using techniques like packaged workbooks to different user communities.

Education:

Bachelor of Technology Computer Science, Gayatri vidya parishad college of engineering, Visakhapatnam, India.

Contact this candidate