We provide IT Staff Augmentation Services!

Senior Developer/cognos Administrator Resume

CAREER OBJECTIVE:

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.

PROFESSIONAL SUMMARY:

  • 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.

TECHNICAL PROFICIENCY:

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

PROFESSIONAL EXPERIENCE:

Confidential

Environment: Windows

Skill/Tools: Datawarehousing,Cognos 10.1

Senior Developer/Cognos Administrator

Responsibilities:

  • 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.

Confidential

Environment: Windows

Skill/Tools: Datawarehousing

Senior Developer

Responsibilities:

  • 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.

Confidential

Environment: Windows

Skill/Tools: Informatica 9.1, Cognos 10,Framework Manager

Senior Developer

Responsibilities:

  • 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.

Confidential

Environment: Windows

Skill/Tools: Cognos 8.4,Framework Manager

Senior Developer

Responsibilities:

  • 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.

Confidential

Environment: Windows

Skill/Tools: Cognos 8.4,Framework Manager,Powerplay Transformer,Informatica 8.6

Team Lead

Responsibilities:

  • 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 .

Confidential

Environment: Unix and Windows

Skill/Tools: Cognos 8.2, Framework Manager,PowerPlay Transformer

Application Support and Development

Responsibilities:

  • 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.
  • Documentation.
  • 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 .

Hire Now