Profileimage by Sachin Kadam BI Associate from

Sachin Kadam

available

Last update: 06.09.2022

BI Associate

Graduation: BE
Hourly-/Daily rates: show
Languages: English (Full Professional)

Attachments

1569910584712_IBM Cognos Developer.pdf

Skills

Cognos (Cognos 11, Cognos 10, Report Studio, Framework Manager, Core Java, IBM Cognos 11, SQL, ETL, Informatica, IBM, star schema, data model, physical data model, Informatica Power Center 9.1, SQL scripts, Oracle 9i Database, Oracle, determinants, data retrieval, Studio, development environment, cognos, metadata, ldap, ITIL, crosstab, bugs, Spotfire, Cognos - Report Studio, multipage, Query Studio, Database, IBM Cognos Framework, JAVA, UI, web services, Bug fixing, coding, testing software, web applications, J2EE, JSP, JavaScript, HTML

Project history

11/2019 - 11/2019
Programmer Analyst
APIDW and APDBC (JAVA Admin UI)

Team Size 2
Technologies Java
Description:
Web application is use for Sales data uploading on Server with validation.
Responsibilities:
* Implemented new web services to improve functionality.
* Migrated whole application with Production support including Bug fixing and enhancement.
* Helping to dev team for enhancement implementation.
* Handover exiting application to other team and on boarding application

11/2019 - 11/2019
Programmer Analyst

InFoMigrate Tool (Cognizant)

Role Programmer Analyst

Team Size 2
Technologies Java
Description:
We have design a web based application for Informatica admin team to reduce effort on multiple deployment without
reducing performance.
Responsibilities:

* Responsible for coding and Implemented Business logic.
* Accountable for analysing requirements, developing designs, implementing and testing software/web applications

using Java, J2EE, JSP, JavaScript, HTML etc.

* Adopting new technology to achieve team goals.

01/2017 - 12/2018
BI Developer
Allergan (Cognizant)

Team Size 4
Technologies IBM Cognos 10, SQL, Cognos - Report Studio
Description:

This project involves the development of a Life science industry Dashboard that demonstrates the Key Performance Indicators
of Life science industry business. This Dashboard shows the reports and analysis into functional segments namely Sales, Daily
calls, store operations.
Responsibilities:
* Creating Reports for end user's analysis
* Gathered and analysed business requirements from users and business community.
* Used some advanced features like Conditional Formatting in Report Studio in generating multipage Reports.
* Supported Business Users in generating Ad Hoc Reports using Query Studio.
* Understanding existing business model and customer requirements
* Created Complex Reports using Lists, Crosstabs, charts, graphs and Images.
* Scheduled Reports through Jobs to get the Daily, Weekly, Bi-Monthly and Monthly output of reports.
* Created filters, prompts, sub reports, provide drill through capabilities
* Deployed reporting objects from a development environment to test and then to production environments as per
the process.
* Played a team member role in a team of 4 with effective communication, negotiation and client handling skills.
Worked on Star Schema Database Design.

07/2016 - 01/2017
BI Developer
Allergan (Cognizant)

Team Size 2
Technologies IBM Cognos 10, SQL, IBM Cognos Framework Manager
Description:
As per the gather report requirements from different business departments like allocation, finance, sales distribution and
store operations. We have created packages and publish.
Responsibilities:
* Queried data from different database tables as per the requirement.
* Created packages using multiple data sources in the framework manager.
* Created Dashboard for the presentation using most of the Cognos functionality (such as Conditional Formatting, Drill
through and Dashboards etc.)
* Performed optimization on the existing reports to decrease the run time to meet the presentation time requirements
and made changes to the existing reports for good look and feel.
* Created step by step documents for the packages and Reports creation *
* Conducted User training for a batch of 10 on Cognos 10.
* Providing support and troubleshooting problems as required.

Local Availability

Only available in these countries: India
Profileimage by Sachin Kadam BI Associate from BI Associate
Register