Seeking a challenging opportunity in the field of Business Intelligence where I can make optimum use of my knowledge and experience which would enable me to improve my skills and strengths and also contribute to the growth and success of an organization.
- Competent & result oriented professional with 7 years & 4 months of experience, currently working as an I.T Analyst with Confidential Consultancy Services, Kolkata.
- Exposure in BI tools: Cognos Series 7(Impromptu), Cognos 8.2, Cognos 8.4,Cognos 10, Framework Manager, Power Play Transformer, Tableau.
- A good Exposure of Cognos 8.4 Report Studio, Analysis Studio, Query Studio, Event Studio and Framework Manager.
- Good Exposure in ETL: Informatica 9.1
- Has good experience on Tableau Reporting and Tableau Server Admin activities.
- Has considerable knowledge in understanding Business and Functional specifications and requirements
- Excellent relationship management skills & ability to conceive efficient solutions utilizing technology.
- 6 months of experience as an Onsite coordinator in Janssen Pharmaceutical (Belgium).
- Industrious individual who thrives on a challenge, working effectively with all levels of management.
- Has experience working in Cognos Migration project and ETL implementation.
- Has been involved in development of Project asset and Process improvement initiatives.
- Has experience in Change management, Problem Management and Incident Management.
- Excellent communication and interpersonal skills. Ability to work effectively in a team.
Business Domains: Pharma Life Science, Finance and Insurance
Tools: Cognos 7.3,Cognos 8.2,Cognos 8.4, Framework Manager, PowerPlay Transformer, Informatica 8.6
Database: Oracle 10g
Language: C, JAVA, SQL
Operating System: Windows NT, 2000, XP, Vista
Skill/Tools: Datawarehousing,Cognos 10.1
Senior Developer/Cognos Administrator
- Migration of all objects from Cognos 8.3 to Cognos 10.1 environment.
- Setting up security in Cognos 10.1 environment.
- Setting up capabilities in Cognos 10.1 environment.
- Installation and configuration of Cognos 10.1 systems.
- Configuring & setting up cubes in the new environment.
- Schedule cubes in TIDAL for daily/weekly refresh .
- Testing of reports in new environment and fix issues.
- Writing Test scripts in HPQC and performing test executions.
- Updating existing documentations for the application.
- Communicating with users and stakeholders on different issues and risks.
- Understanding the Business Processes, Requirement Gathering and Analysis.
- Analysis of Data Acquisition processes for ETL process to load data in the Data warehouse for reporting purpose.
- Analysis of existing Reporting requirements and also propose future reports for Business.
- Provide High Level solution architecture for the proposed solution.
- Documentation of all business requirements in URS.
- Compare reporting tools in the market to identify the best reporting tool as per the proposed solution.
Skill/Tools: Informatica 9.1, Cognos 10,Framework Manager
- Understanding the Business Processes, Requirement Gathering and Analysis.
- Analysis and Design of Data Acquisition processes. Design the ETL process to load data in staging environment for further processing.
- Metadata modeling in Cognos Framework Manager and development of BI reports.
Skill/Tools: Cognos 8.4,Framework Manager
- As a Developer, involved in the Development, and Testing.
- Have been involved in extracting business logic from all existing actuate reports and implementing them for re - use in Cognos Reports.
- Developed the Metadata model for reporting.
- Prepared Report Specification and Design documents for reports.
- Have developed Cognos Reports and have done proper Unit testing before delivering for System Test.
- Developed Work product review materials for UAT.
Skill/Tools: Cognos 8.4,Framework Manager,Powerplay Transformer,Informatica 8.6
- Responsible for resolving incidents adhering to Service Level Agreements.
- Root cause analysis for problem tickets.
- Impact analysis for Change requests/Enhancements/bug fixes in Cognos BI reports.
- Analysis, definition & testing of enhancements of BI reports.
- Communicating with technical organizations including ITS and Vendors of application components.
- Communicating with users and stakeholders on problems, incidents and responding to Information requests
- Executing design, development, testing, validation and implementation for system enhancements.
- Maintaining documentation for applications and updating all relevent application related documents.
- Worked with Business Analysis team in gathering the requirements and created Functional and ETL specification documents.
- Analyzed the Business Requirement and laid out the steps for the data extraction, business logic implementation & loading into targets.
- Performed extraction, transformation and loading of data from different sources like Flat Files, Oracle DB in accordance with requirements and specifications.Extensively worked with Informatica - Source Analyzer, Transformation developer, Mapping Designer, Workflow Manager, and Workflow Monitor to develop various mappings, reusable transformations, session tasks and Workflows.
- Used workflow monitor to monitor the jobs, reviewed session/workflow logs that were generated for each session to resolve issues, used Informatica debugger to identify issues in mapping execution.
- Used Workflow manager to create and configure workflow and session task to load data. Used Informatica workflow monitor to create, monitor workflow in case of process failures.
- Estimation of FTE requirments and providing monthly forecast for Team.
- Involved in estimations for development work .
Environment: Unix and Windows
Skill/Tools: Cognos 8.2, Framework Manager,PowerPlay Transformer
Application Support and Development
- As part of application support I handle all Cognos 8.2 issues related to our application.
- Grant user access to our application.
- Created User groups roles and given access to the reports
- Perform daily activities and routine health check of our application and reporting the same to our clients .
- Test any new change implemented.
- Schedule daily and weekly and monthly reports.
- Interact with client to understand the business requirement for some adhoc reporting
- Deployment of new reports and packages to content store.
- Setting up Events based on user requirements in Event studio.
- Setting up jobs based on customer requirement .
- Worked on Cognos Macro scripts.
- As a Developer, involved in the Development, and Testing, Post Production Maintenance of the Reports.
- Created Packages and Published to Content store.
- Created security filters to restrict the access to packages
- Created Filters and Calculations within the Model.
- Created prompts in Framework Manager.
- Created IQD’s Using Framework Manager to build the cubes.
- Created different types of reports like List,Crosstab,Charts and Repeater in Report Studio
- Created different types of prompts like Textbox,Value,Date,Select&Search prompts
- Created Prompts, calculations, & Filters in report studio
- Created cascading prompts in report studio.
- Created Drill through reports in Report studio.
- Worked with conditional variables to highlight the data based on reporting requirements.
- Worked with Conditional Blocks to Display the report objects conditionally.
- Gather business users requirements for OLAP modelling .
- Create a Model Plan which includes design and data requirements for the model
- Identifying measures and planning dimensions and levels.
- Design and develop the PowerPlay model in Transformer .
- Created PowerPlay cubes and also setup deployment process for cubes.
- Has worked on macro scripts for automating cube creation and deployment.
- Defining security in cubes.
- Has experience in creating multidimensional reports .