Manish Kumar

Experience

• 

  Accenture

  Jul 2010 - now

  My Role as a senior Cognos report developer are as follows:Creating Pl-Sql scripts to automate the generation of reports in sql server Performing gap analysis, requirement gathering for cognos FM modelDesigning and developing technical design document, business requirement document for the reports developed.Creating error logging mechanism in Pl-Sql scripts to pin point the bug and fixes themDeveloping cognos reports using cognos 10.2Performing performance tuning to optimize the report run timeWorking on Cognos8.4 framework manager to import metadata from data sources and to create and publish packages to Cognos 8 server for reporting.Creating Models using model query subjects and structured SQL method. Show less Developed Multi page reports with prompt pages and conditional variables according to the end user requirementsDeveloped List, Repeater, Conditional Blocks and Drill through reports using Report Studio which involved Multiple Prompts, Filters, HTML items query prompts, layout calculations, conditions, filters and Multi-page.Used Framework Manager to model metadata from different data sources and published packages to Cognos ConnectionInvolved in the complete Software Life Cycle Development of the projectHave successfully handled migration of entire project from cognos V8.2 to Cognos 10.1Coordinating with the BAs and the Business team for understanding the requirements and issues clarificationCreated Queries in PL/SQL - to verify the UI results and SQL Query OptimizationCoordinate with the other QA teams to accomplish the end-to-end testing of the application. Show less Involved in the entire project life cycle from analysis, development, testing, production and end user supportWorked closely with business users while gathering requirementsInteracting with the BI Team at the Client side for developing the reports and solving the issuesWorked on Cognos8.4 framework manager to import metadata from data sources and to create and publish packages to Cognos 8 server for reporting.Create Models using model query subjects and structured SQL method. Created different layer’s to hide the data complexity for end users in Framework Manager. Efficient in writing SQL Queries in Oracle/SQL serverWorked on Production Support and fixing report/package/data issuesCreated Scripts to clean production bad data using SQL based on conditionsInvolved in SQL Query Optimization Show less

  • Senior Software Engineer

    Sept 2013 - now

  • Software Engineer

    Sept 2011 - Aug 2013

  • Associate Software Engineer

    Jul 2010 - Aug 2011