In the event that any outside resources are used, those should be cited in APA format. Submissions should be a maximum of 500 words or 125 words per question/prompt. What are you research interests i
Anish Kumar Polasani
Business System Analyst
Tek Analytics LLC
(214)-728-9971
SUMMARY:
Cognos Business In experience intelligence with expertise in Software Design, Development, and Analysis, Teradata, Testing, Data Warehouse and Business Intelligence tools.
Expertise in Cognos 11/10.2, 10.1, 8.x (Query Studio, Report Studio, Analysis Studio, Business Insight/Workspace, Business Insight/Workspace Advanced, Metric Studio (Score carding), Framework Manager, Cognos Connection)
Expertise in Installation and Configuration of Cognos BI Products in Distributed environment on Windows
Expertise with Framework Manager Modeling (Physical Layer, Business Layer, Packages) and Complex Report building with Report Studio.
Expertise developing complex reports using drill-through reports, prompts, dashboards, master-detail, burst-reports, dynamic filtering in Cognos.
Expertise in creating Dashboard reports using Java Script in Report studio.
Expertise in building scorecard reports and dashboard reports using metric studio.
Expertise with Transformer models and cubes that were used in Power play analysis and also these cubes were used in various Analysis Studio reports.
Expertise with MDX Functions in Report Studio using Multi-dimensional Sources.
Expertise with Cognos security (LDAP, Active Directory, Access manager, object level security, data security).
Expertise with Tabbed Inter-phases and with Interactive Behavior of value based chart highlighting.
Sound Skills in developing SQL Scripts, PL/SQL Stored Procedures, functions, packages.
Expertise on production support and troubleshoot/test issues with existing reports and cubes.
Experienced with MS SQL Server BI Tools like SSIS, SSRS and SSAS.
Expertise in creation of packages, Data and Control tasks, Reports and Cubes using MS SQL Server BI Tools.
Ability to translate business requirements into technical specifications and interact with end users to gather requirements for reporting.
Good understanding of business process in Financial, Insurance and Healthcare areas.
Expertise in infrastructure design for the cognos environment and security setup for different groups as per business requirement.
Creating training material on all the Ad-Hoc training
Expertise in all the basic administrative tasks like deployments, routing rule setup’s , user group setup , folder level securities etc.
Have deployment knowledge of IBM Cognos report in Application servers like WAS.
Have knowledge on handling securities and administration functionalities on IBM Cognos 10.x
Good work ethics, detail oriented, fast learner, team oriented, flexible and adaptable to all kinds of stressful environments. Possess excellent communication and interpersonal skills.
Technical Skills:
BI Platform | Cognos 11,10.2, 10.1, 8.x (Query Studio, Report Studio, Analysis Studio, Business Insight/Workspace, Business Insight/Workspace Advanced, Metric Studio (Score carding), Framework Manager, Cognos Connection) |
Data Base | MS Access, MS SQL Server, Oracle, DB2, |
OLAP Tools | Cognos 11/10.x/8.x (Report Studio, Frame work manger, Analysis Studio, Business Workspace, documentum Content Server/Docbase,Metric Designer, Metric Studio, Business Workspace advanced), Transformers, Impromptu Administrator, Powerplay Transformer, Powerplay, Oracle 11g,Was 8.x, Documentum architecture and Content Server 6.X and 7.X, Teradata |
Languages | SQL, PL/SQL, C,C++ |
Application Software | MS PowerPoint, MS project, MS Excel |
Operating System | Microsoft Windows XP/2000/98/2003/NT, Unix, Linux |
EDUCATION:
Bachelor of Technology in Electronics and Communication Engineering from Jawaharlal Nehru Technological University, India.
Masters in Information Systems from Wilmington University, New Castle, Delaware USA.
PROFESSIONAL experiencE:
Employer: TEK- Analytics LLC May 2016 - Present
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.