Venkat Polineedi

Cognos Developer / Architect

ac7ykz@r.postjobfree.com Ph. 847-***-****

Professional Summary

** ***** ** ************ ********** in IT industry including expertise experience in all phases of project life cycle namely analysis, design, coding, testing and implementation phases.

10 years of strong experience in COGNOS Suite of Products including, Cognos Analytics 11.0.3/11.0.8, Cognos 10.2.2/10.1, 8.4 & 8.3 Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Business Insight/Cognos Workspace, Power Play Transformer, Dynamic Cubes and Dynamic Query Analyzer.

Experience in migration and involved in unit testing after the upgradation from Cognos 10.2 to Cognos Analytics 11

Experience in Tableau design and deploy rich Graphic visualizations, scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.

Designing and developing Business Intelligence (BI) solutions with Microsoft Power BI Desktop and Power Pivot to meet new and existing business demands and ensuring integrity of design through to implementation.

Experienced in designing and developing SSRS reports using data from ETL loads, SSAS cubes and various heterogeneous data sources.

Experience in Cognos TM1 including Server, Architect, Turbo Integrator, Web Client and building Cubes, Dimensions using TM1 Turbo Integrator processes.

Creation of rules using the rules editor and adding Business Rules to Cubes. Scheduling of TM1 process for data population.

Extensive experience in designing and building applications using AWS services like EC2, EBS, S3, RDS, DynamoDB, Amazon Redshift, IAM, VPC, and ELB Administration.

Implementation, Integration, Problem Resolution, Root Cause Analysis of AWS resources and experience in maintenance of continuous integration based on Git and Jenkins.

Experience in designing models with Framework Manager involving Relational Models and Dimensional models.

Created and published packages in Framework Manager from various data sources.

Deployed packages and reports from one environment to another environment (Dev, QA and Prod).

Strong Experience in star, snowflake schema designs, DW SDLC and Performance tuning.

Developed OLAP applications using Cognos suite of tools and extracted data from the enterprise data warehouse to support the analytical and reporting for all Corporate Business Units.

Experience in deploying right combination of EC2 instances (on demand vs. Reserved vs. Spot) to make cost effective solutions. Administrated EC2, S3, RDS instances using Boto3.

Experience in controlling source code with Clear Quest Clear Case and SCCS on Windows and UNIX environment.

Experience in large databases such as Oracle 11g/10g/9i, PL/SQL, SQL*Loader, Teradata, and DB2.

Experience in requirements gathering from Business Users and Product Leadership and translate in to functional/technical specification and experience with Water Fall and Agile Methodologies.

Demonstrated leadership and worked independently with the development and QA teams to build/test all components of a software product, to keep up with changes in the product releases.

Education : Master of Computer Applications (M.C.A)

Certifications:

IBM Cognos 10 BI Author

IBM Cognos 10 BI Metadata Model Developer

Technical Skills:

Reporting Tools : Cognos Analytics 11, Cognos 10x/8x Report Studio, Framework Manager, Transformer, Dynamic Cubes, Dynamic Query Analyzer, Tableau, Qlikview, Microsoft Power BI, SSRS, SSAS, SSIS and Cognos Planning Analytics (TM1).

Cloud Technologies : Amazon Web Services (AWS)

ETL : Data Stage 8x/9x, Informatica 9, SSIS

Database : Netezza Oracle 11g/10g/9i, Teradata Studio 15x, SQL Server, DB2

Languages : SQL, PL/SQL,

Scripts : HTML, JavaScript, VB Script and UNIX Shell Script.

Operating Systems : Windows NT/2000, HP-Unix, Sun Solaris.

Other Tools : Pentaho, CA Rally, Jira, Toad, SQL/PLSQL Developer, Clear Quest, Clear Case, Visio, Excel, Teradata SQL Assistant, VSS, SCCS, SharePoint

Professional Experience:

Sabre (Westlake, TX) Aug 2017 to Present

Sr. Cognos Developer / Architect

Environment: Cognos Analytics 11.1/11.0.10, Framework Manger, Report Studio, Microsoft Power BI Desktop, Tableau, Pentaho, Netezza, SQL, PL-SQL, AWS Services EC2, S3, EBS, ELB, RDS etc., HeidiSQL, Git, CA Rally, Jira and SQL Developer.

Responsibilities:

Worked in an Agile Software Delivery methodology highly focused on developing & enhancing build pipelines for Continuous Integration and continuous deployment.

Created projects, designed models for reporting and created & published packages in Framework Manager from various data sources CR and RDS.

Created model query subjects, shortcuts, calculated fields, namespaces, folders and filters in appropriate layers in model to make it simple and more user friendly.

Conduct troubleshooting, root cause analysis, Data Validation, and problem resolution for Cognos Framework Manager models/packages.

Created complex, multi-page reports involving prompts, cascading prompts, conditional rendering, and conditional highlighting.

Design & development of multiple reports using various templates like list reports, cross-tab reports and chart reports.

Worked on report studio, to create complex reports and dashboards for the given requirements.

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as Revenue Vs Quota along with slicers and dicers enabling end users to make filtering.

Optimized Microsoft Power BI dashboards with a focus on usability, performance, flexibility, testability, and standardization.

Created Java Scripts to default the values in the Prompts and also to default the search options for the prompts in Prompt page.

Proficient in deploying, managing, and operating scalable, highly available and fault tolerant applications using various AWS services. Experienced in disaster recovery of servers.

Created and retained backups of EC2 instances by snapshot feature using automated scripting.

Experience in using elastic load balancer (ELB) and Auto Scaling for elasticity.

Setup of Auto Scaling of EC2 instances based on CloudWatch alarms of CPU and memory usage.

GameStop (Grapevine, TX) May 2016 to Aug 2017

Sr. Cognos Developer / Architect

Environment: Cognos Analytics 11.0.3, Cognos 10.2.2, Framework Manger, Report Studio, Workspace, Workspace Advanced, Cognos TM1, Power BI, Tableau, AWS Services, Tableau, Netezza, SQL Server 2008/2010, Teradata 12/15.

Responsibilities:

Developed Cognos Framework Manager Model and packages for metadata layer using Cognos best practices.

Conduct troubleshooting, root cause analysis, Data Validation, and problem resolution for Cognos Framework Manager models/packages

Added business rules to the Cognos Framework models by creating calculations, filters, prompts, session parameters and parameter maps, cardinalities.

Developed Tableau visualizations and dashboards using Tableau Desktop, developed Tableau workbooks from multiple data sources using Data Blending.

Generated ad-hoc reports in Excel Power Pivot and shared them using Power BI to the decision makers for strategic planning.

Experience in deploying the project tools are in AWS EC2 instances, using S3 for storing cookbooks and backups.

Implemented object/row/package level security in Cognos Framework Manager Models, developed DMR model for Collectibles project.

Created complex dashboards Collectible Stats with area charts, pie charts, crosstab and multi prompts in Report Studio.

Building Dimensions, Cubes and loading and maintain data in Cubes using TM1 Turbo Integrator processes.

Used HTML items and Java scripts in the Dashboards and reports to make them every interactive and show more content during layering functionality.

Created drill through reports for the pie charts created in the interactive dashboard as per the requirement.

Extensively worked with DW team to create indexes, consolidate multiple objected in to views to improve the FM model performances and reduce load and processing time on Cognos servers.

Experience in Branching/ Merging/Conflict resolution using source control tools such as Git, SVN.

Orthofix Inc. (Lewisville, TX) Feb 2014 – May 2016

Role: Senior Cognos Developer / Architect

Environment: Cognos 10.2.2, Cognos 8.4, Frame Work Manager, Report Studio, Query Studio, Analysis Studio, Cognos Workspace, Workpace Advanced and Event Studio, Tableau, Cognos TM1, AWS Services, Oracle 11g, TOAD, Business Objects, Oracle Apps R12

Responsibilities:

Involved in gathering the requirements from the end users.

Created the Technical Specifications document based on the gathered requirements.

Built models, packages and published them using Cognos Framework Manager.

Involved in defining Relationships and Cardinality between query subjects. Define the data, object and package level security in FM.

Created Dashboard in active reports to identify all the order made through online.

Involved in training end users to use Query Studio to build Adhoc reports on the fly.

Created folders, filters, prompts, and complex business calculations in Framework Manager and Report Studio. Worked on Standard Reports in Cognos Report Studio and Ad-hoc reports in Query Studio for users.

Worked on portal reports, created web parts for Cognos in SharePoint so that users can access Cognos from SharePoint Portal.

Developed Prompt pages, used Conditional Variables for Conditional Formatting.

Created complex reports using Report Studio including Conditional Blocks, Stored Procedures.

Designed and developed reports on SSRS (SQL Server Reporting Services), SSAS (SQL Server Analytical Services).

Develop TM1 Application by adding TM1 objects and External files to an application.

Create temporary Views, Subsets using Turbo Integrator and populated data for Actuals.

Optimize the Rule Performance by adding SKIPCHECK and FEEDERS.

Deploy TM1 cubes with Cognos 10.2 and used as a source to build BI reports in Report Studio.

Wrote complex custom sql to create reports which were having high visibility in terms of higher management.

Extensively involved in performance tuning in Oracle environments.

Managed hardware, software, and networking for a large scale cluster on Amazon EC2.

Used security groups, IAM roles, scaling groups, load balancers, Monitored EC2 instances with CloudWatch.

Used Amazon S3 to backup database instances periodically to save snapshots of data.

Alcon Labs (Fort Worth, TX) May 2012 – Feb 2014

Role: Senior Cognos Developer

Environments: Cognos 10.1 Report Studio, Analysis Studio, Framework Manager, Transformer, Cognos TM1, SQL Server SSIS and Oracle PL-SQL.

Responsibilities:

Designed and developed Cognos reporting solutions using the Cognos suite of tools for versions 8.4 and 10 to meet release and project requirements

Worked on production support for Cognos versions 8.4 and 10 environments.

Designed, developed Cognos Framework models in versions 8.4 and 10.

Strong exposure in SQL including ETL.

Exposure to both Agile and Waterfall methodologies / environments

Building Dimensions, Cubes and loading and maintain data in Cubes using TM1 Turbo Integrator processes.

Create reports using TM1 Cubes, develop TM1 Application by adding TM1 objects and External files to an application.

Create temporary Views, Subsets using Turbo Integrator and populated data for Actuals.

Used TM1 rules editor to create and edit rule to create various calculations.

Deploy TM1 cubes with Cognos 10.2 and used as a source to build BI reports in Report Studio.

Ability to transform business requirements into deliverables with minimal supervision.

Good analytical and problem solving skills.

JPMorgan Chase (Lewisville, TX) Jan 2012 – May 2012

Role: Cognos Developer

Environments: Cognos 10.1 (Framework Manager, Report Studio, Analysis Studio, Cognos Connection), Cognos 10.1 Business Intelligence Transformer, SQL Server SSIS and Oracle PL-SQL

Responsiblities:

Worked on report studio, to create complex reports and dashboards for the given requirements.

Involved in deployment of development environment into production.

Created metadata model using framework manager, created packages and published the packages.

Created calculations for model in the Framework Manager to get appropriate data into the reports.

Created Stored Procedures from Oracle 10g and imported then to Framework Manager for complex reports.

Converted Excel sheet scorecards into Cognos Reports scorecards in report studio to see data that runs weekly.

Created complex dashboards with area charts, pie charts, crosstab and Multi prompts in Report Studio.

Developed the Information Security (IS) Monthly Reports and ad-hoc reports to the stakeholders and provided the Information Security (IS) metrics to Chase Executive Management.

Used HTML items and Java scripts in the Dashboards and reports to make them every interactive and show more content during layering functionality.

Created drill through reports for the pie charts created in the interactive dashboard as per the requirement.

Participated in User Acceptance Testing for the reports developed and reported defects in the Mercury Quality Center Tool.

Nike (Beaverton, OR) Sep 2011 – Dec 2011

Role: Cognos Developer

Environments: Cognos 8.4.1, Cognos 10.1.1, Framework Manager, Report Studio, Analysis Studio, Power Play Transformer, Oracle 10g, PL/SQL, SQL Developer, HP Quality Canter

Responsibilities:

Experienced in full lifecycle data warehouse involving Cognos implementation.

Worked closely with Business Analysts to understand the business requirements.

Designed and develop Framework Manager Models with multi-layer technique (Import, model, DMR, Relational, Business and Presentation models).

Developed the model and build the cubes using Transformer model and doing the drill-up and drill-down analysis in Analysis Studio.

Created complex, multi-page reports involving prompts, cascading prompts, conditional rendering, and conditional highlighting

Involved in report-setup, scheduling reports and publishing the reports onto Cognos Connection.

Experienced in Cognos 10 new features like BI Insight, Active Reports, Managing External database etc.

Collaborated with other Cognos developers, multiple business analysts, subject matter experts, and users to fulfill reporting requirements

State Street (Boston, MA) Jan 2011 – Sep 2011

Role: Cognos Developer/Analyst

Environments: Cognos 8.4/8.4.1 Transformer, Framework Manager, Query Studio, Analysis studio, Report Studio, Clear Quest, Clear Case, Autosys, Oracle 10g, Toad, Sun Solaris, Shell scripts, Excel and Share point.

Responsibilities:

Created both relational and dimensional Framework Manager Models that could be deployed by various user communities with a wider range of perspectives.

Offshore coordination, User interaction, consolidation of business requests, daily status meetings with user community.

Built Framework Manager model, and established the cardinalities to suit the business needs

Developed regular dimensions and relative time dimensions; define measures and calculated measures, build and deploy the cubes on Windows and Linux environments.

Experienced in development of complex Cognos reports using Cognos Report Studio, Query Studio, Analysis Studio, and Event Studio.

Implemented the platform to define and measure Information Security risk, process, threat and operational indicators.

Involved in Administration activities like Creating data sources, Export and Import jobs to deploy the Packages and reports on various environments, monitoring and scheduling the jobs.

Performed analysis of existing Cognos-related System Problem Reports and provide recommended solutions to estimates and resolve the issues.

Worked with end users to address ad-hoc data analysis requests; determine the proper course of action; and prioritize tasks and responsibilities to properly manage one's own workload.

Involved in End-to-end deployment process with Clear Quest, Clear Case and Autosys.

Nielsen (Chicago, IL) Apr 2009 – Dec 2010

Role: Cognos Developer

Environments: Cognos 10 Beta/Cognos 8.4/8.3 Framework Manager, Report Studio, Analysis studio, Query studio, PowerPlay Studio, Transformer, Netezza, Composite, Oracle 10g, PL/SQL, Unix, Visio, Shell scripts.

Responsibilities:

Implemented various features in Framework Manager Model like Macro Functions with Session Parameters and Parameter Maps, Filter Item Reference, Model Filters & Prompts, Stored Procedure Query Subjects, Aggregate properties, Governor Settings, Package Security and Segmentation, Link Segment, star schema group by, Shortcuts to avoid loop joins …etc.

Implemented Drill up/Drill down and Drill through features.

Designed and Developed Analysis studio reports using cube packages.

Created Query Studio reports for Adhoc users on the mentoring/support process.

Created and maintaining a unique/standardized prompt page and providing a facility to run a report by selecting the report name as a prompt value from the prompt page.

Wrote stored procedures & packages for data load, backup and restore

Used Autosys & Unix scheduling to run the jobs for building and deploying Cubes and Oracle scripts

Coordinated with offshore team for task assignments

Documented the design/development work in the form of Framework Manager Model & Report Design Templates.

GE Healthcare (Milwaukee, WI) Feb 2008 – Mar 2009

Role: Cognos Developer/Analyst

Environment: Cognos ReportNet 1.1 (Framework Manager, Report Studio, Query Studio), Impromptu 7.3, Impromptu Web Reports 7.3, Impromptu Administrator 7.3, Upfront, Cognos Scheduler, Cognos Connection, Windows 2003, Oracle 9i, SQL*Plus, Toad, Teradata.

Responsibilities:

Worked closely with the User group and gathered reporting requirements and converted in to functional/technical specification.

Prepared Cognos - System Requirement Design Documents (SRDS) and involved in System Requirement Specifications (SRS).

Created multi-layer models as per business requirement, created and published packages using Framework Manager.

Developed multi pages List, Crosstab, Chat, Repeater and Section Reports using Report Studio, created analysis reports with Analysis Studio.

Designed/Created well-tuned Power Play Transformer models and with/without drill through reports and also created alternative drill down paths as per user requirements.

Generated Power Play Cubes, IWR Reports and deployed on server using SunOS 5.8, Putty, SSH File Secure Transfer Client.

Setup the drill through Report Studio and query studio reports from PowerPlay Cube.

Created multiple cubes using Transformer model and resolved the functional/ technical issues that arise in the development cycle.

Mahindra British Telecom (MBT)/ Tech Mahindra July 2004 – Feb 2008

Role: Senior Technical Associate

Environment: Cognos ReportNet, Oracle 9i, PL/SQL, Pro*C 8.1.5, and Visual Basic 6.0

Responsibilities

Making system study and requirement analysis

Modified the Framework Manger Models to incorporate the new data elements.

Designed and developed the reports as per the requirements in Cognos ReportNet.

Involved in coding and unit testing

Making integration and performance testing on the application.

Taken care of total back-end integration of the application using stored procedures

Generated reports on Pro*C.

Contact this candidate