SUMMARY

• Extensive experience in Cognos Tools such as Cognos 11 Analytics, 10.2.1 BI suite, 10.2.0 BI Suite, 10.1 BI Suite, Cognos 8 BI Suite (Framework Manager, Cognos connection, Report Studio, analysis Studio, Query Studio & Event Studio) Cognos Impromptu 7.x, and Analysis Tools such as Cognos Transformer & Power Play 7.x.
• Experience in Designing models using Framework Manager and deploying packages to the Report Servers.
• Experience in Sales Reporting and worked on ERP and CRM systems.
• Four plus years of experience in power BI toolset in modelling complex data, creating reports, dashboards.
• Four plus years of experience in tableau in designing reports, dashboards, data blending and data cleansing.
• Created Drill through, drilldown, sub reports and nested data regions in SSRS.
• Experience in creating DAX queries to generate computed columns in power BI.
• Created power BI Dashboards in order to visualize client’s data and make decisions.
• Used power query in power BI to pivot and un - pivot data for data cleansing and data massaging.
• Worked with Azure data factor in creating hybrid ETL and ELT processes.
• Created tableau dashboards with interactive views, trends and drill downs along with user level security.
• Developed tableau reports that provide clear visualizations of various KPI’S.
• Created complex dashboards and visualizations using Tableau Desktop.
• Sound working knowledge of building Complex reports, Burst Reports, Drill Through reports, Cascading Reports, Cross Tab Reports and Summary Reports. Created complex reports, drill through reports, dashboards using report studio.
• Experience in developing multi-dimensional model design and cube building, security using Cognos Transformer.
• Used Cognos Connection for scheduling and bursting reports across the Business segments.
• Created complex dashboard reports in cognos 11.
• Experienced in performance tuning and optimizing of the reporting solution.
• Experience in writing SQL, PL/SQL, Oracle, Teradata, Stored Procedures, Functions, Packages as per business requirements.
• Knowledge in working on Extraction, Transformation and Loading (ETL) using Informatica 8.X.
• Strong knowledge in data warehousing concepts (Star schema, Snow Flake Schema, Fact constellation schema).
• Proficient in building front-end BI applications according to specifications.
• Strong analytical, conceptual, and problem-solving abilities.
• Created cubes using TM1 perspective by defining measures and dimensions as required by business.

TECHNICAL SKILLS

• Power BI(Power BI Desktop
• Power BI Service
• Power BI Mobile) SSRS
• SSIS
• SSAS
• SQLserver 2008/12
• Azure Data Factory
• Tableau (10.5/10.4/9.2 )
• Cognos 11 Analytics (11.0.8 11.0.6 ) 10.1 10.2 0.2.1
• BI Suite
• Framework Manager
• Cognos Transformer
• Cognos connection
• Query Studio
• Report Studio
• Analysis Studio 10.2.2
• Cognos 8.1 8.2 8.3 8.4
• Cognos TM1 10.2.0
• Cognos TM1 9.5.2
• Cognos EP Series 7.x
• (Power play Transformer
• Power play Windows/
• Web
• Impromptu
• Upfront)
• C
• C++
• Core Java
• HTML
• JavaScript
• R Studio
• PL/SQL.
• Oracle 9i/10g 11g 12c
• IBM DB2
• Teradata.
• Informatica PowerCenter 8.1/8.6
• Cognos 8 BI Data Manager.
• IIS
• Tomcat
• Apache.
• Active Directory
• Windows 10/7/XP/VISTA
• UNIX.
• MS Office
• QTP.

PROFESSIONAL EXPERIENCE

Sr BI Developer

Confidential, CO

Responsibilities:

• Created complex DAX queries to analyze year over year growth of the products compared to market trends.
• Modelled Sales data in power BI by creating relationships across various objects.
• Developed power BI reports and dashboards from multiple data sources using data blending.
• Had interactive sessions with the stake holders and updated business requirement document accordingly.
• Published power BI reports and dashboards to the web using power BI service.
• Created complex framework manager models based on Oracle HR database objects.
• Created trending reports in cognos to get the headcount over a period, as well as active employees as of particular date.
• Created cognos reports based on employee footprint, recruitment and compensation metrics.
• Created various data source connections in cognos admin console to access data across dev, tst and UAT systems.
• Created test cases to validate and tie the data to the source system.
• Deployed reporting solution to across systems and helped user with UAT testing.
• Designed data models from scratch to aid data collections to be used for tableau visuals.
• Created action filters, parameters and calculated sets in order to build dashboards and worksheets in tableau.
• Developed tableau visuals for fluid power department across asia pacific region.
• Creating, publishing customized interactive reports and dashboards, report scheduling using tableau server.
• Involved in transforming, enriching and publishing the data using Azure Data Factory.

Environment: Cognos Analytics 11.0.12, (Report Authoring, Framework manager, Administration), Power BI, Tableau 10.5, Oracle SQL Developer12 c, SQL server 2016, AZURE Data Factory, Motio CI, Windows 10.

Senior BI Developer

Confidential, SC

Responsibilities:

• Created complex reports in cognos analytics for life and health line of business, for various departments including claims, compliance and finance.
• Created framework manager models in order to pull premium, claims and commissions for reporting.
• Deploying cognos objects from one environment to another at different phases of SLDC.
• Worked with BA’s in order to clarify the questions related to the requirement and assist them technically if needed.
• Performed various type of testing say unit, regression, performance and data integrity testing while testing models and reports.
• Created complex dashboards that represent various measures and KPI’s that are required by business teams.
• Developed custom reports and deployed them on to the server using power BI.
• Provided continuous development, as well support on bug fixes of new and existing power BI reports.
• Generate Standard monthly reports using Tableau.
• Work on massive datasets through filtering, grouping, aggregation and statistical calculation in tableau.
• Written complex sql queries, procedures in order to validate the reports and provide with business calculations.
• Created multipage, multi query reports with complex and customized layout as per user requirement.
• Defined relationships and cardinalities among query subjects, set the determinants as well to define granularity.
• Worked with jira ticketing system for ticket tracking and project implementation.
• Created reports involving conditional reporting, conditional blocks, master detail and drill through functionalities,
• Worked on complex list, crosstab and chart reports with various types of filters, aggregations, prompts and functions.

Environment: Cognos Analytics 11.0.6, (Report Authoring, Framework manager, Administration),Power BI, Tableau 10.4, TOAD, Oracle 11g,SQL server 2016, Motio CI, JIRA, Windows 7.

Senior BI Developer

Confidential, OH

Responsibilities:

• Created framework manager models for license and contracts department to track their license and appointments.
• Created complex control reports for users which is very critical in maintaining audits for their respective departments.
• Worked on end to end, following all SDLC process in delivering cognos reports to the users.
• Optimized the performance of the reports at framework manager and report level.
• Created test cases, performed unit testing for validating data in the reports with source systems.
• Used Motio CI in order to deploy reports and models to various environments, as well as for versioning.
• Created Integrated custom visuals on power BI desktop based on user requirement.
• Worked on various types of transformations that are available in power query editor.
• Created power BI reports using time intelligence calculations and functions.
• Created drill through within the same report as well as drill through pointing to a different report, Worked on master-detail functionality as well.
• Created complex framework models with DQM capability.
• Strong understanding of advanced tableau features such a calculated fields, parameters, R integration, data blending so on.
• Modelled billing and claims data and created operational tableau visuals.
• Created business requirement documents based on user requests and developed BI solutions.
• Troubleshoot and provide user support for data analytic issues by reviewing report and data source for data integrity.
• Enhanced the existing applications and implementations of fixes for defects reported in reporting applications.
• Worked with VSTS ticketing system for ticket tracking and project implementation.

Environment: Cognos Analytics 11.0. 8, Cognos 10.2.2(Reporting studio, Analysis studio, Query studio, workspace advanced, Cognos connection, Framework manager, Administration),Power BI, Tableau 9.2, R Studio, Oracle sql developer, Oracle 11g,SQL server 2014, Motio CI, VSTS,, Windows 7.

Senior BI Developer

Confidential, NJ

Responsibilities:

• Developed various framework manager models based on business requirement and published packages to cogon’s connection.
• Worked on various complex reports from the scratch level to meet user requirements at various levels such as trade, position, desk and sub desk.
• Developed SSIS package to extract, transform and load the data in to warehouse from database.
• Used power BI gateways to create reports and dashboards to current.
• Created computing tables in power BI using DAX queries.
• Worked on complex power BI dashboards that are directly used by executives.
• Optimized the performance of the reports by tuning database query.
• Assisted users in creating TM1 web and TM1 reports.
• Designed and developed tableau dashboards for various ROI metrics.
• Created complex tableau visuals for compliance and risk department.
• Consolidated multiple tableau workbooks in to single work book for AMER finance team.
• Involved in regression, unit, performance and user acceptance testing at various stages before used by the business.
• Used Motio CI in order to deploy reports and models to various environments, as well as for versioning.
• Using and understanding the prolog, epilog tabs in turbo integrator process.
• Created complex business calculations in TM1 using rule editor.
• Designed and built cognos powerplay cubes.
• Worked on complex conditional formatting, calculations and created active reports for users so that they can use them on the go.
• Worked on reports with various objects such list, crosstabs, charts, repeater tables which involved using conditional blocks and layout component reference.
• Used java scripts to create tab buttons within the reports and provide commentary functionality within the reports.
• Created complex stored procedures and pipeline functions that are accessed by the report for pulling summary level records and detail level rejects.
• Worked extensively on various dimensional functions such as tuple, children, caption, ancestors, descendants and so on.
• Involved in administering data source connections and checking if dispatchers and query services are working properly.

Environment: Cognos 10.2.0(Reporting studio, Analysis studio, Query studio, workspace advanced, Cognos connection, Framework manager, powerplay Transformer, Administration), Cognos 11.0.6 Analytics, Cognos TM1 10.2.0(Perspectives, Turbo Integrator, Architect, Performance modeler), SSRS,SSAS,SSIS, Power BI, Tableau 9.2, Oracle 11g, SQL server 2012, Teradata 14.10, Windows 7.

Senior Cognos BI Developer

Confidential, FL

Responsibilities:

• Created complex reports including multiple pages and queries to calculate closing cost involved in closing contract.
• Created multiple adhoc reports for deeding and documents compliance department.
• Created source packages for reports and published packages based on them.
• Upgraded from cognos 10.1 to 10.2.1, involved in configuring the content store and validating the reports.
• Created Projects, Namespaces, Models and Packages using Cognos Framework Manager and deployed packages to Cognos Connection.
• Used sql as a source, based upon which reports were generated.
• Use TM1 rule editor to create and edit various business calculations.
• Created and arranged different TM1 rule statements and performed complex calculations for cubes at different level.
• Implemented security socket layer (ssl) protocol on web server hosting cognos BI gateway.
• Created multiple dashboard reports involving drill through, master detail functionality, as well as applied conditional formatting.
• Created cubes in TM1 architect by using subset editor, dimension editor.
• Created SSRS reports in report designer and report builder.
• Created report specifications based on user requirement and then developed and implemented business intelligence solutions.
• Created active reports for the users such that they can be consumed by them through ipads or their mobiles.
• Managed all activities and schedules on daily basis, monitored and restarted dispatcher when required.
• Created multiple lists, crosstabs and charts reports with filters, calculations, summaries, prompts and functions.
• Created reports based on dimensional functions such as ancestor, closing period, period to date, aggregate and so on.
• Optimized the performance of the reports, created multiple prompt pages and conditional variables.
• Used java script in order to change the prompt controls in report studio.
• Involved in unit, functional, regression, performance and acceptance testing while in different stages of report design and development.

Environment: Environment: Cognos 10.1.0,10.2.1(Reporting studio, Analysis studio, Query studio, Business insight, Cognos connection, Power play Transformer, Frame work manager, Administration), Cognos TM1 9.5.2(architect, performance modeler), SSRS, SQL server 2012, Oracle 11g, Windows 7.

Cognos BI Developer

Confidential, PA

Responsibilities:

• Created source iqds in order to build OLAP cubes through power play modeling tool transformer.
• Worked on designing complex dimensional models by creating various dimensions, measures and calculations in transformer.
• Worked on various impromptu reports and power play (.ppr) reports in cognos 7.
• Created multiple complex reports for the top management, which are firm based, fund based and has overall sales and redemptions.
• Configured access manager to set up an authentication source, which defines the servers, and data sources that users can access.
• Did perform upgrade from cognos 7.4 to 7.5 v and configured the products using configuration manager and also installed cognos fix packs.
• Involved in migration from cognos 7.5 to cognos 8.4 and then to cognos 10 version and verified the corresponding reports.
• Deployed dimensional cubes to cognos connection and then published them as packages to be used for reporting.
• Interacted with the business users, documented their queries and reporting needs.
• Created multiple reports adhoc reports using query studio based on user’s request.
• Worked with decision stream an ETL tool to load and transform the data such that it is suitable for reporting.
• Created complex dashboards in cognos 10 business insight with a combination of lists and crosstabs.
• Created various monthly, weekly and quarterly reports in reports studio by creating parameterized filters and prompts.
• Created Projects, Namespaces, Models and Packages using Cognos Framework Manager and deployed packages on Cognos Connection.
• Created folders, filters, prompts, and complex financial calculations in Framework Manager and Report Studio.
• Created active reports in report studio which are highly interactive and can be consumed by the user offline.
• Developed stored procedures and user defined functions using PL/SQL

Environment: Cognos 10.1.0(Reporting studio, Analysis studio, Query studio, Business insight, Cognos connection, Power play Transformer, Frame work manager), Cognos 8.4, Cognos 7.4,7.5(Impromptu, power play, decision stream, Upfront), IBM DB2, SQL server 2008, Oracle 10g, Windows XP/7)

Cognos BI Developer

Confidential, MI

Responsibilities:

• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Multi-query, Cubes in Report Studio.
• Created custom prompt reports and dashboards in Report Studio.
• Involved in Query Optimization, Creating Query Prompts, Developing Prompt pages and Conditional variables.
• Worked on reports, which are based on Sales packages and dealt with ERP AND CRM systems.
• Developed standard Templates for various kinds of reports.
• Added prompts and filters to modify existing reports to accommodate change in user requirements.
• Created professional reports in Report Studio and ad hoc reports in Query Studio.
• Created dashboards (crosstabs and charts) to display the business details from different aspects and using different representations.
• Modified the existing reports by adding required prompts to comply with changes in the business requirements.
• Created simple to complex reports as well as Dashboard like reports using Report Studio by applying various concepts and functionalities such as drill-through, conditional reporting, block, tables, master-detail, charts, various calculations and joins using tabular sets and tabular models
• Worked on Cognos 10.1 Report Studio to build multiple crosstab, list and chart reports.
• Created folders, filters, prompts, and complex calculations in Framework Manager.
• Involved in design and development of joins, filters and calculations in Packages within Framework Manager.
• Worked on Relational Models in order to built multipage prompts and complex crosstab reports.
• Created complex reports such as Customer Invoice, Bookmark, Product Analysis and Multi-Prompt reports.
• Created complex custom queries to optimize the Report Studio report performance.
• Created Drill through from Analysis Studio to Report Studio Reports.
• Created new calculated columns which are not present in the published packages.
• Used Cognos Connection for scheduling and bursting reports across the Business segments.

Environment: Cognos Suite 10.1(Report Studio, Query Studio, Analysis Studio, Cognos Connection, Framework Manager, PowerPlay Transformer), Oracle 10g,DB2, Teradata, Windows XP.