MSc Computer Science with 9 years of experience in Software Industry. Seeking challenging position in software development to contribute my knowledge for the growth of the company and self, also to improve my domain and technical expertise in Business Int
/ Year
46709.6 USD-
Immediate: Available
11 Years
Now you can Instantly Chat with S.S.!
About Me
IBM Cognos Certified Report Author and Modeler with over 9 years of experience in Database, Data Warehousing & Business Intelligence with strong experience in tools like Cognos with 6 Yrs. and Tableau with 3 Yrs. Involved in Full Life-Cycle project a...
Show MoreSkills
Positions
Portfolio Projects
Description
-
- User raises the ticket with the screen shot and issue in the JIRA software and ticket will pick up by the support team and analyze the issue later team has to give points on how to resolve the issue.
- Developed reports according to user requirements.
- Design & development of multiple reports using various templates like list reports, cross-tab reports and chart reports.
- Involved in working with cubes and developed various dashboard reports.
- Extensively worked on Analysis Studio to develop multi dimensional reporting.
- Developed Standard Reports, Charts, Drill Through Reports, Master Detail Reports, Map Reports Using Report Studio and Query Studio.
- Created complex dashboards with pie charts, crosstab and Multi prompts in Report Studio.
- Developed various reports using functionalities like Render Variables, Conditional Blocking, Cascading Prompts, and Conditional Formatting.
- Performance tuning by analyzing and comparing the turn around times between SQL and Cognos.
- Used SQL Server Management Tool to check the data in the database as compared to the requirement given.
- Exposure on Cognos development Software development kit like SDK in order to customize reports.
- Coordinating with Development Team tasks& Deliverables and working on high priority issues.
Description
- Analyzed the requirements and created Models, connecting various data sources, reports, sub queries, creating users, scheduler and joins using Framework manager.
- Designed and Analyzed the requirement for this project which has database as SQL server
- Used various kinds of Filters, List reports, Cross tab and sub queries.
- Created a dashboard for merchandising department to have a display of all the aspects of the merchandising report, which is roughly a combination of eight reports and few extra fields using Tableau.
- Monitor and manage support queues on a day to day basis to ensure SLAs are met and to ensure a high level of customer satisfaction
- Provide ongoing internal reporting of performance measures and service levels
- Use project management best practices to support and guide staff project and maintenance related activities
- Responsible for performance management of direct reports, career development and creation of development opportunities to meet the needs of direct report employees
- Serve as a user experience advocate and the escalation point for application support issues
Description
- Coordinated testing, rollout & deployment of Cognos 10.1 Business Intelligence reporting solutions.
- Worked closely with business users to define reporting requirements and documenting the requirements in order to design, develop and maintain, and secure Cognos reports.
- Closely worked with ETL team to design Data Marts by understanding user requirements and increasing the reporting efficiency.
- Developed Metadata models and DMR models using Framework Manager and created filters, prompts, calculations, summaries and functions as per Functional Requirement Specifications.
- Implemented Framework Manager Security for row level access and package access based on the Department, Region and Store Level.
- Created simple to complex reports as well as Dashboard like reports using Report Studio by applying various concepts and functionalities such as drill-through, conditional reporting, block, tables, charts, master-detail, maps, various calculations and joins using tabular sets and models.
- Extensively worked on Active reports to create static reports for offline users.
- Performed burst of Reports against the regions, districts, and stores for delivering by email; appropriate outputs to the concerned District Managers & Team Ambassadors in Cognos Connection.
- Created several different types of Ad-hoc (simple list, grouped list, section heading, crosstab, and nested crosstab) reports and represented data graphically by charts using Query Studio.
- Implemented prompt validation and added various functionalities to prompt pages using JavaScript in order to extend and customize the reporting functionality, visualization and presentation experience.
- Created agents and added tasks in Event Studio to run reports based on specific business criteria.
Description
- As a Team lead, interact with business partners to identify information needs and business requirements for reports, and distribute the requirements to the team members
- Develop reports in Cognos 10 based on business requirements
- Identify and analyze data according to specific needs
- Prepare report and maintain database of application and processes through Cognos application
- Engage in project planning, controlling, and writing technical documentation
- Access web browser, develop web applications and write reports
- Use Cognos Connection to access the Cognos data
- Monitor metrics and create business intelligence reports