Sekhar

Sr. Cognos Developer

www.linkedin.com/in/sekhar8468

Email: ad34hr@r.postjobfree.com

Phone: 470-***-****

Professional Summary:

More than 11 + years of IT experience in Software Design, Development, and Analysis, Testing, Data Warehouse and Business Intelligence tools.

Expertise in Cognos Analytics 12,11.2.2,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), CognosReportnet 1.1, Cognos Impromptu, Cognos Power Play Transformer, Cognos Power Play, Cognos Scheduler, Cognos Access Manager.

Involved in gathering the requirements from the end user and translated them into the technical specifications.

Expertise with Framework Manager Modeling (Physical Layer, Business Layer, Packages) and Complex Report building with Report Studio.

Hands on experience in Report building (Crosstab, List, Dashboard reports) using Report Studio and Analysis Studio.

Experience 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.

Experienced in building scorecard reports and dashboard reports using metric studio.

Experience with Transformer models and cubes that were used in Power play analysis and also these cubes were used in various Analysis Studio reports.

Experience working with Longitudinal Data Survey

Experience working in AIX Environment.

Experience working on Informatica Power Center.

Good Experience with MDX Functions in Report Studio using Multi-dimensional Sources.

Extensive experience with Cognos security (LDAP, Active Directory, Access manager, object level security, data security).

Worked on complex Active reports in a multidimensional environment using Cubes

Strong experience on performing tuning techniques at Report and ETL level.

Having good experience on ETL Tool such as IBM Cognos Data Manager and good knowledge on Informatica power center.

Experience on working various project development lifecycle like Agile/SCRUM and SDLC methodologies and involved in Sprint planning.

Experience working with Motio CI .

Created Active Reports with Tabbed Inter-phases and with Interactive Behavior of value based chart highlighting.

Development and enhancement of Cognos Portal through SDK

Sound Skills in developing SQL Scripts, PL/SQL Stored Procedures, functions, packages.

Expertise in Oracle 10G, 9i and MS SQL Server 2005& 2008.

Involved in OLTP/OLAP system study, analysis and E-R modeling, developing database schemas including Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.

Extensive experience on production support and troubleshoot/test issues with existing reports and cubes.

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.

Good work ethics, detail oriented, fast learner, team oriented, flexible and adaptable to all kinds of stressful environments. Possess excellent communication and interpersonal skills.

Certifications:

IBM Certified Developer – Cognos 8 BI Professional Studio (Cog – 180).

Certified AWS Associate Architect.

Education Details :

Btech computer Science and Engineering (2008) JNTU, Hyd.

Masters in Computer Science – University of Northern Virginia 2011,Virginia .

Technical Skills:

Hardware

IBM PC Compatibles and NT servers

OS

Windows, UNIX, Linux

OLAP tools

Cognos 10.x,8.x (Report Studio, Frame work manger, Analysis Studio, Business Workspace, Business Workspace advanced), Transformer 8.3, Impromptu Administrator,Powerplay Transformer, Powerplay, ReportNet,Oracle

ETL Tools

Informatica 6.0, 7.1,8.1,8.6, Data stage 7.5

Databases

Oracle 7.x/8.x/9.x/10g, SqlServer 2005 2008,sql* loader, Teradata

RDBMS

Stored Procedures, Database Triggers, and Packages.

Languages

Multimedia

C, C++, Java, Cobol, VB, .net,php, Assembly language

Adobe Photoshop, Flash, Dreamweaver.

Tools

Make, RCS, Autosys, Clear Case,Toad, BTEQ

Miscellaneous

TCP/IP Sockets, Sun RPC, XML

Version Control

CVS

Professional Experience:

Role: Sr Cognos Developer

Optum, State of West Virginia Charleston WV Jan 2019 – Present

Description:Optum's three businesses, OptumRx, OptumHealth and OptumInsight focuses on five core capabilities: data and analytics, pharmacy care services, population health, healthcare delivery and healthcare operations. Optum serves employers, government agencies, health plans, life science companies, care providers and individuals and families offering products in data and analytics, pharmacy care services, health care operations and delivery, population health management and advisory services

Optum's three businesses, OptumRx, OptumHealth and OptumInsight focuses on five core capabilities: data and analytics, pharmacy care services, population health, healthcare delivery and healthcare operations. Optum serves employers, government agencies, health plans, life science companies, care providers and individuals and families offering products in data and analytics, pharmacy care services, health care operations and delivery, population health management and advisory services.

Worked with Business users to gather Business strategy and created a centralized reporting capability for users to perform analytical and ad-hoc reporting for business applications.

Developed Business Requirement Documents based on Client’s Requirements.

Developed and managed dimensionally Modeled Relational model (DMR) using Framework Manager.

Created complex SQL views and stored procedures to join multiple tables for contract data interface files.

Defined the keys, Joins, cardinalities, and global filters in Framework Manager.

Used package level security and folder level security.

Developed Burst reports, Drill through, Master Detail, List, Chart, cross tab and complex reports (which involves Joins, Unions, Prompts, Report Library, Table of Content, Report Layout, template, Dashboards etc) in Report Studio based on the business requirements involved Multiple Prompts in Report Studio.

Altered calculations in the Report studio for the Active report and Making enhancements of the reports based upon the requirements of the user.

Created reports with Optional filters and custom prompt pages (using HTML and JavaScript) in Report Studio.

Setting up all the backups of all environments with backup and restore Databases.

Responsible for installation, configuration, upgrading and maintaining Cognos 10 BI platform in a distributed windows environment.

Utilized Tableau Desktop to create multiple rich dashboards that appropriately told stories of business status and success, strengths and weaknesses, and potentials; also offered at a glance, visual representations of profitability, products, and customers Customized Reports using HTML and JAVA SCRIPTS.

Design and executed test plans and test cases according to product backlog and user stories.

Demonstrated to client/product owner in sprint review sessions that all requirements are met as per sprint back log.

Utilized Tableau Desktop to create multiple rich dashboards that appropriately told stories of business status and success, strengths and weaknesses, and potentials.

Utilized Tableau Desktop to create multiple rich dashboards that appropriately told stories of business status and success, strengths and weaknesses, and potentials.

Importing Source/Target tables from the respective databases.

Understanding existing business model and client requirements.

Experience on versioning control tools like MotioCI for reporting and modeling tools lie Erwin, Visio etc.

Extensive experience using IBM Cognos Analytics Report studio, Active reports, Workspace and Workspace Advanced and Framework Manager to build Dashboard and Reports.

Resolving of Cognos Environmental issues which affect the Scheduled Jobs and Reports

Testing of the reports and updating the Bug Tracking Tool

Created custom templates and custom toolboxes for the use of reporting.

Performance Tuning of the reports.

Served as a Tableau Liaison to mentor our team on all Tableau best-practices while supporting other developers specifically in data-source identification.

Lead meetings with technical peers regarding the solution designs on Tableau.

Working with Cognos BI product suite (Report Studio, Analysis Studio, Query Studio, Framework Manager, Transformer, and Workspace Advanced)

Created Reports and Dashboards using Cognos 11.0.9.

Upgraded successfully Cognos 10.2.1 to Cognos Analytics.

Experience in creating transformers and applying Data warehousing/ETL techniques like Lookup, slowly changing dimensions, creating surrogate keys, creating levels and templates at ETL level.

Good experience in debugging the transformers if any issues and fixing them on priority.

Experience in accessing the data from various data sources and creating transformers and applying business logics in enterprise layer to meet user requirement.

Experience in creating and amending the data ware house system in such a way everybody in the team including new joiners can understand and work easily.

Involved in ETL, Framework and reports deployment between the different environments like Dev to UAT and Production.

Role: COGNOS Developer / Administrator

American College of Cardiology (ACC), Washington DC Aug 2018 – Jan 2019

Description: American College of Cardiology facility-wide subscription to virtually all of ACC's online educational resources. Subscription can provide everyone at your facility with access to Board prep activities in general cardiology, adult congenital heart disease, heart failure, interventional cardiology, echocardiography, and nuclear cardiology. Thousands of high-quality self-assessment questions. Hundreds of points toward Part II of the ABIM's MOC program. Yearly highlights from ACC's annual scientific session. Subscription unlocks the power of the single most authoritative and comprehensive professional resource on cardiovascular medicine to students, practitioners and other professionals in the medical field.

Analyzed SQL to determine background query processing and interaction between Cognos and Sql Server. Led team meetings, providing status and defining go-forward approach based on achievable results.

I am responsible for Requirement gathering and Understanding, analyzing and submitting technical Efforts Estimation, Coordinating with Client and Assigning tasks.

Designed Cognos Framework Model, Cognos Transformer Cubes, Report Development.

Enhancement of writing HTML/ Java Scripts based on requirement.

Involved in handling/supporting Cognos production tickets and unit testing and deployment of reports.

Created Reports and Dashboards using Cognos 11.0.7.

Upgraded successfully Cognos 10.2.1 to Cognos Analytics.

Creating prompts with query macros by including references to parameter maps.

Created Stored Procedure Query Subject, Used Filters, Custom Calculations, User Defined Functions, Macros, Parameter Maps, and Session Variables while designing the framework model. Stored Procedure Query Subjects, Custom Calculations, Filters, Maintain the Security (All Levels).

Worked on framework manager to import metadata from multiple data sources and to create subject oriented business models, create and publish packages.

Created and maintained all Framework Manager Models and packages including Row Level security to the Framework Models which will cater Report level security for different level of down line users.

Worked on Workday HR reports and Dashboards.

Created complex SQL views and stored procedures to join multiple tables for contract data interface files.

Experience writing complex SQL Queries and Procedures.

Worked with the team attending escalation tickets and did root cause analysis for repetitive errors.

Use Motio CI to remediate and version reports daily.

Working on Service Requests, Change Requests and ensuring that they are completed within time.

Environment: Cognos Analytics,Transformer, Report Studio, Query Studio, Metric Studio, SDK, Oracle 10g, Erwin 4.0, Sql Server 2014, Data stage, UNIX,ArcGis,LDAP.

Role: COGNOS Developer / Administrator

Information Technology Department ITD, Bismarck ND January 2015 – Aug 2018

Description: The North Dakota Information Technology Department (ITD) supports the IT needs of state government, higher education. Because of the diverse needs of state entities, ITD provides varied amounts of support to its customers. While some entities have their own IT departments that partner with ITD for necessary services, others utilize ITD for all their IT needs.

Projects Expertise on

NDUS (North Dakota University Systems)

DHS (Department of Human services)

DOT (Department of Transportation)

Develop Dashboards using IBM Cognos Analytics 11.0.8 and Business Insight Advanced in 10.2.2. Developed Story Board using Cognos Analytics 11.0.8.

Tested and modified JavaScript, Drill through reports in Cognos Analytics 11.0.8

Experience in report writing using Report Studio 10.2.2, Work Space, and Work Space Advanced.

Created Active Report which provides an interactive analytics experience in a self-contained Cognos Business Intelligence application for browsing and exploring data offline.

Worked with Security Administration within Cognos Connection in Defining roles and permission and matched them across all environments for multiple applications.

End-to-end report design expertise from requirements gathering through published reports.

Experience in gathering requirements from end users, specifying data fields and formulas, and performing analysis to determine task effort.

Experience working on Scheduling jobs in Informatica.

Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.

Created mapping documents to outline data flow from sources to targets.

Experience in Transformer model design and Power play cube building.

Created Relational and Dimensional Models using multiple data sources and publishing packages to Cognos connections in Framework Manager

Giving support to the existing model in Cognos Framework manager.

Interacted with Customers for requirement gathering, effective analysis and also to provide end-user training.

Created complex dashboards with piechart,Crosstab and Multiprompts in Report Studio and developed Active reports with custom filters and Visualizations.

Experience designing a variety of products such as scorecards, drill-through reports, data cubes, ad hoc queries, interactive visualizations, and models for analysis.

IBM Cube designer is the windows desktop tool used to create Dynamic Cubes.

Modeling and supporting the Cubes.

Several years of applied knowledge in dimensional data modeling concepts.

Enterprise-level database experience such as Oracle, Microsoft SQL Server.

Upgraded successfully Cognos BI applications within the target time.

Proven analysis, design, development, and testing skills.

Created complex reports that had multiple pages, multiple UI items like lists, charts, graphs, etc.

Ability to work independently with minimal supervision.

Strong analytical and problem-solving skills.

Training the Cognos users on the Report Studio, Query Studio.

Support for the Cognos Business Suite.

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

Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.

Integration of Tableau9 Desktop with R.

Published Workbooks by creating user filters so that only appropriate teams can view it

Able to communicate highly technical information to non-technical and technical users.

Wmata Washington Metropolitan Area Transit Authority, WashingtonDC February 2014 – January 2015

Role: COGNOS Developer / Administrator

Description: The Washington Metropolitan Area Transit Authority (Metro) was created by an interstate compact in 1967 to plan, develop, build, finance, and operate a balanced regional transportation system in the national capital area. Metro began building its rail system in 1969, acquired four regional bus systems in 1973, and began operating the first phase of Metrorail in 1976. Today, Metrorail serves 91 stations and has 117 miles of track. Metrobus serves the nation's capital 24 hours a day, seven days a week with 1,500 buses. Metrorail and Metrobus serve a population of 5 million within a 1,500-square mile jurisdiction. Metro began its paratransit service, MetroAccess, in 1994; it provides about 2.3 million trips per year.

Responsibilities:

Prepare Technical Design Documents based on Functional requirements and implement most complex business requirements using BI tools.

Develop List, Crosstab, Chart Reports in Report Studio using Framework Manager Package, SQL and PL/SQL.

Design and develop complex drill through, master detail and Burst reports using IBM Cognos 10.1.1 functionality.

Develop new relational and dimensional Framework manager Package using OLTP and OLAP data source and maintain existing packages to meet the business requirement.

Developed Reports for Mobile phone applications Cognos Mobile Reports

Extensively used prompts, filters, cascading prompts, calculations, conditional variables, multiple queries for data extraction in reports.

Database Management and Data Modeling.

Created Drill Through Reports & Master Detail Reports for Accounts Department.

Worked on Cognos mobile reports and testing.

Used Union, Intersection for creating queries.

Created dashboards, portlets for various HR and payroll related reports. E.g. investments related to 401Kplan were displayed as dashboards showing their investments, returns, losses, dividends earned, etc.

Experience working with Audit reporting and Financial report.

Developed various HR reports – MTD, QTD, YTD, last fiscal year, current fiscal year reports, employee taxable, paid time offs, holidays, sick leaves, workers compensation report (WCR) etc. These reports were mainly on employee level but I also developed scorecard and dashboard reports which were mainly developed for the departmental heads and regional heads.

Created complex reports that had multiple pages, multiple UI items like lists, charts, graphs, etc.

Develop dashboards using IBM Cognos 10.2.1 Business Insight Advanced.

Experience IBM Cognos Power Cubes on windows platform to fulfill business requirement which helps management and customers in making key business decisions based on cube analysis.

Develop complex reports using Tabular Set and Tabular SQL to meet business requirement.

Design and develop reports using of Conditional Blocks and Conditional Styles to fulfill complex business requirement into a single report and to highlight key data.

Developed complex, dashboard reports for Mobile Applications

Use various prompts like value, text and date prompts with customization for all the reports developed in IBM Cognos 10.2.1

Publish cognos power cubes as data source and packages to IBM Cognos10.2.1 connection.

Help off-shore development team members to overcome technical challenges in using IBM Cognos tools.

Used Cognos Transformer to build multidimensional Dynamic cubes and used it in Dashboards.

Prepare Business logic for existing reports.

Experience working and maintain Active Reports .

Help end users to understand Data warehouse and BI Tools.

Good Experience working on the Esri Maps 4 and 5.

Worked on content including ArcGIS Online Base maps, demographics, and landscape.

Worked on Geo spatial Mappings using ArcGIS 10.1

Environment: Cognos 10.2/10.1.1,Transformer, Report Studio, Query Studio, Metric Studio, SDK, Oracle 10g, Erwin 4.0, TOAD, PL/SQL, Data stage, UNIX,ArcGis.

Acosta Sales & Marketing, Jacksonville, FL April 2012 – January 2014

Role: COGNOS Developer

Description: Acosta is a sales and marketing is one of the top retailer in North America. Acosta works with every major food and grocery retailer in North America, offering our clients opportunities to get seamless coverage and huge efficiencies from north to south and east to west. Acosta also represent nearly 25 percent of the inventory that hits store warehouses, including many product categories' leading brands. In fact, we are a proven resource for any company that wants to give its products the ultimate in momentum and selling power.

Responsibilities:

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

Extremely proficient in writing complex reports, building portals, dashboards, scorecards, FM models and Cubes.

Working experience on BIRT Reporting tool.

Manage Cognos metadata, Folder structure and utilize Cognos 10.2 advanced features.

Responsible for implementing best practices on Cognos Dashboards, Scorecards, Portal, report design, development and testing.

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

Created BurstReports and MultilingualReports based on groups of users &Preferencesfor our Asian, African and European partners.

Created Drill Through Reports & Master Detail Reports for Accounts Department.

Creating OLAP cubes using Transformer, creating Framework models.

Developed various Management reports – MTD, QTD, YTD, last fiscal year, current fiscal year reports, and employee taxable. MTD, QTD, YTD, Clients, Costumers, sales,shops, Productsetc.

Environment: Cognos 10.2/10.1.1,Transformer, Report Studio, Query Studio, Metric Studio, Oracle 10g, Erwin 4.0, TOAD, PL/SQL, Data stage, UNIX.

Contact this candidate