A 500 - 700 word essay describing professional experiences and goals as they relate to the pursuit of the PHD in business administration

Position: Business Analyst,

Environment: Cognos 11/10.2/10.1.1, Report Studio, Query Studio, Metric Studio, Business Insight and Business Insight, Active Reports, Dash Board reports, Cognos Mobile, Teradata SQL.

.

Responsibilities:

· Involved in gathering Business requirements from business customers, analyzing and transforming them into business intelligence reporting specifications. Developed Technical Design and Functional Design Documents.

· Involved in discussions with business stakeholders to understand project goals and requirements in order to quickly deploy reports and analytics that enable better decision making.

· Strong understanding of Business Intelligence and Data Warehouse database concepts, Star schema and developed Report Studio queries that uses the relationships between fact tables in the Data Warehouse database.

· Prepare Solution/Application Design, Develop, and Go-Live execution.

· Involved in creation of Relational and Multi-dimensional models using Cognos framework manager and created packages, published to the server for reporting needs.

· Work directly with business customers to build portals, reports, dashboards with the COGNOS BI suite (Framework Manager, Report Studio and Transformer).

· Experience in writing with HTML/Java Script in Cognos report studio reports as per the requirements.

· Extremely proficient in writing complex reports, building portals, dashboards, scorecards, FM models, OLAP cubes and integrating with SharePoint.

· Maintained applications/reports & Validate results for the reports.

· Install and configure Content Server for 7.X on Unix/Linux/Solaris environment

· Experienced in implementing best practices on Cognos Dashboards, Scorecards, Portal, report design, development and testing.

· Design and develop Teradata presentation layer according to users' requirements

· Train end users on Teradata OLAP connector.

· Analysis of existing reports to determine the changes to be done post introduction of new modules in backend ERP system.

· Created dashboards for a managerial/Directorial overview with drill up and drill down capabilities in 10.2.1

· Created a dashboard on a relational framework model and performed the tuning at the database level for optimal performance.

· Debuged SQL from SSRS reports and convert them into Cognos reports.

· Experienced with Administration and Security Setups within Cognos.

· Created Multidimensional Power Cubes using Transformer and created Drill up/Drilldown reports using Report Studio and Analysis Studio.

· Created Drill through, Burst and Master Detail Reports. Created Active reports and dash board reports for the business needs and Cognos Mobile.

· Involved in Installation and Configuration of Cognos 11 version and Cognos Mobile and checking on the Issues on Client and Server side.

· Practiced new features in cognos 11 version in sandbox.

· Created self service reporting in cognos 11 version.

· Trained end users in creating the dashboards using the business Insight/workspace.

· Created Multi tab, Drill up/Down, Multi Query and multipage reports using report studio.

· Experienced with Offshore/Onshore business models for development activities and involved in daily calls for coordinating the work to offshore team and help them to understand and implement.

· Involved in Performance tuning of models/reports/cubes for better quality product delivery.

Client: Quantum Value IT Services Pvt.LTD ,Hyderabad,India. Nov 2013 – July 2014

Position: Business Analyst.

Environment: Cognos 8.2, Transformer 8.3, Report Studio, Query Studio, Metric Studio.

Responsibilities:

· Interviewed business community to identify business, data, and delivery requirements.

· Designed models in Framework Manager.

· Updated & administered the security privileges at object level and data level for the user profiles in Framework Manager.

· Worked with Complex reports in Report Studio using master-detail relationship, drill through, burst options, cascading options and PROMPTS depending on user requirements.

· Created reports using cascaded prompts, value prompts, sections, dynamic filtering, conditional layouts and multi lingual reports in Report Studio

· Created reports containing multiple data containers like List, Cross-tab and Repeater tables.

· Created models in Transformer, built cubes and published cubes to Power Play server.

· Scheduled reports using Cognos scheduler and emailed to various recipients as required.

· Worked on TOAD for Oracle database systems for creation of adhoc queries and for improving various performance issues.

· Experience with oracle as the target for the data marts.

· Used Data Source Query Subjects, Model Query Subjects and Stored Procedure Query Subjects in Framework manager.

· Test/validate system tables/files in System Test environment, UAT environment and finally in Production environment.

· Trained End users to operate the reports.

· Optimized and modified the triggers, complex store functions, procedures, user base data type.

4