I Develop and perform tests on various environments and provide dashboard solutions with help of Cognos 10.2. Coordinate with Data architecture/DBA’s/SME’s and modeling team to design databases and tables in to the databases.Investigate and resolve all data issues. Create and execute test plans/scripts for internal testing of new and existing reports. Prepare all designs and code for various Cognos reporting objects and ensure compliance to all best business practices in industry… Show more I Develop and perform tests on various environments and provide dashboard solutions with help of Cognos 10.2. Coordinate with Data architecture/DBA’s/SME’s and modeling team to design databases and tables in to the databases.Investigate and resolve all data issues. Create and execute test plans/scripts for internal testing of new and existing reports. Prepare all designs and code for various Cognos reporting objects and ensure compliance to all best business practices in industry. Schedule and ensure compliance to all design code and test activities and prepare plans for same and design various dashboards and maintain required framework for all processes.Monitor work and ensure optimal utilization of all SQL scripts in oracle 11 and document all database requirements and analyze data anomalies and prepare reports for the sprint cycles. Prepare functional design documentation for reporting objects, monitor and resolve all Service/Incident request ticket issues and perform troubleshoot. Provide support to all Cognos/Data issues and maintain knowledge on all new techniques and prepare reports for all the campus management functions.Communicate with various business groups to gather requirements and prepare functional and technical documents. Develop Standard Reports, Charts, and Drill through Reports, Master Detail Reports, Bursting Reports and Multilingual Reports using Report Studio. Build Metadata models in Framework Manager Modeling with best practices. Show less

• Analyzed business and user needs to design Business Intelligence solutions that supported business and operations.• Interacted with ETL team and the DBA to make available certain tables and data modifications required to successfully execute report requirements. • Involved in Metadata modeling of both Relational and Dimensional data using Framework manager.• Experience in implementing security based on user roles in Framework Manager and publishing reports.• Used static choice… Show more • Analyzed business and user needs to design Business Intelligence solutions that supported business and operations.• Interacted with ETL team and the DBA to make available certain tables and data modifications required to successfully execute report requirements. • Involved in Metadata modeling of both Relational and Dimensional data using Framework manager.• Experience in implementing security based on user roles in Framework Manager and publishing reports.• Used static choice value prompts, cascading prompts, conditional variables (Boolean and string) to create reports.• Created Conditional Block reports to dynamically hide or show report objects and provide the end user the option to view the data in different formats.• Extensively used insertable objects like query calculation, layout calculation, and tables to generate efficient and user-friendly reports.• Created temporary Views, Subsets using Turbo Integrator and populated data for Actuals.• Implemented Conditional formatting and Java Scripts for customizing the reports. Used Java Scripts for validating Date/Time controls and adding customized buttons to facilitate the Show/Hide requests.• Developed various Dashboard Reports such as the Loan Originations dashboard to see at-a-glance the volume and characteristics of new loan originations, such as credit scores and loan-to-value calculations throughout the portfolio.• Scheduled Burst Reports for regions, zones, and districts which delivered the appropriate output for the concerned managers in Cognos Connections by email.• Involved in performance tuning of several Reports.• Mentored the end users to effectively use the reporting tool to build and customize their ad-hoc reports.• Involved in unit testing of all the reports and documented all the test cases worked on. Show less