Chandrashekhar Pinnapureddy

About Chandrashekhar Pinnapureddy

Over 13+ years of IT experience in the software life cycle in analysis, design, development, testing and deployment for many applications and out of which 12+ years in DWH Business Intelligence with strong technical exposure and good experience of OLAP Tool like Cognos BI/Analytics.Experience Summary:• Wide experience in developing Cognos architecture• Solid expertise on usage of IBM Cognos Analytics 11.XX/10.XX and 8.4 tools like (Framework Manager, PowerPlay Transformer, Cube Designer, Analysis Studio, PowerPlay Studio, Report Studio, Event Studio, Query studio, Cognos Workspace, CWA, Cognos Connection, Administration and Active Reports).• Familiarity with VISUALIZATIONS• As a Cognos Architect/Developer I possess dynamic technical knowledge, excellent report designing and creating skills.• Implemented security using AD, LDAP and Cognos Access Manager in Cognos reports and Packages.• Well versed with all Data Warehousing Concepts.• Proficient in implementing best practices in Framework Manager and Cognos Transformer in developing relational and dimensional packages (relational and DMR).• Proficient in developing, optimizing cubes and dynamic cubes in Cognos Transformer for OLAP reporting• Expertise in designing interactive dashboards, having user friendly capabilities such as dashboard Prompts, navigation, drill-down, etc.• Basic Knowledge on Cognos TM1 Architect (Cubes, Dimensions, Turbo Integrator), Loading Data into Cubes using Turbo Integrator, Creating TM1 Cubes, Dimensions and populating the Cubes.• Extensive experience in Manual testing using Black Box Testing Techniques.• I can adapt to any diverse environments well, handle critical issues, and can accept challenging assignments with enthusiasm.• Provide technical consulting for upper management, new programmers, and consultants regarding best practices in Business Intelligence.• Extensive experience in databases like Oracle, IBM DB2, SQL Server, Teradata, IBM Netezza and CLOUD (AWS)

Experience

1. Bi Consultant

   IBM

   Feb 2017 — Present · East Lansing, MI, US

   As a Senior Cognos Developer/Administrator, I am actively involving in the following activities.• Involved in installing, configuring and maintaining Cognos Products.• Developed DMR model for standard reports. • Created Relational FM Model for users Adhoc reporting purpose to create their owned reports using Query Studio and CWA.• Designing dashboard templates as per the requirement & dashboards content which includes complex tabular reports, bar charts, water fall charts, score cards, Bubble charts etc.• Converted numerous excel based reports and dashboards to rich Cognos visualizations.• Involved in up-gradation from Cognis 10.2.1 to Cognos Analytics 11.0.13/11.1• Performed query tuning and data modelling to improve performance efficiency. • Involved in creating Labels for Reports and Packages deployment using MotioCI• Developed dashboards using Cognos Workspace Advanced.• Involved in creation of Test scripts using MotioCI for Data validation and Performance testing of reports and fixed the bugs raised during testing.Environment: IBM COGNOS ANALYTICS 11.1/11.0.13/10.2.2(Framework Manager, Report Studio, Query Studio, Workspace, CWA), IBM Netezza SQL, SQL Server 2012, Informatica Power Centre 9.5, MotioCI and Windows 2012R2

Education

• JNTU Hyderabad

  Bachelor of Technology (B.Tech.), Electrical, Electronics and Communications Engineering

  2001 — 2005

Skills

• Microsoft Sql Server
• Sdlc
• Solution Architecture
• Business Intelligence
• Unix
• Ibm Db2
• Aws Redshift
• Business Analysis
• Cognos
• Software Project Management
• Oracle
• Requirements Analysis
• Pl/Sql
• Db2
• Software Development Life Cycle (Sdlc)
• Datastage
• Data Warehousing
• Sql
• Etl