Now you can Instantly Chat with Janhavi!
About Me
COGNOSIBM Cognos 10 Certified Report DesignerExperience in Designing Cognos Reports, Dashboards, Framework Manager ModellingCreated Dashboards, reports using Report Studio. Used functionalities like drill through, drill down.Applied conditional forma...s using Report Studio. Used functionalities like drill through, drill down.Applied conditional formatting, conditional blocks, and different kinds of prompt for different functionalities inthe reportsImplemented Master detail relationship in to the reportApplied style variable , render variable, Block variableApplied security filters on reportReport scheduling ,Report BurstingReports with SQL queriesPackage designing in framework managerApplied package level , Object level, Data level security filters in FMApplied Governor settings, Specify DeterminantsUsed Parameter maps and session parametersInteraction with clients for scenarios designing and understanding of requirementsUnderstanding of Data warehousing concepts and Dimensional Modelling (Star and Snowflake Schema).Designing Cubes in Cognos TransformerKnowledge of writing SQL queries, Store proceduresInitiative, creative and able to learn new technologies and systemsStrong ability to perform as a part of TeamSSIS and SSRSSSIS Package development by using transformations like Conditional Split, Execute SQL tasks, DataConversion, Derived Column, Lookup, Union All, Multicast, OLEDB Command, Row Count, Script Task, ExecuteSQL Task, Data Flow Task etc. In SSIS.Implementing Error handling technique in SSISSSRS report development, deployments, rendering, scheduling.TableauTableau workbook development and publishing it on the server also give access to users on the server.Used Data blending, group, combined filed, aggregated field.Created parameters, quick filters, Context filters, Action filters.Used LOD, multiple measures like individual axes, dual axes, and blended axes.Bar chart, line chart, pie chart, scatter chart, bubble chart, Heat and Tree map.Created charts like bar chart, line chart, pie chart, donut chart, lolly Pop chart, scatter chart, bubble chart, Heatand Tree map.
Show MorePortfolio Projects
Description
Project Description : ACT is financial and business process outsourcing (BPO) Solutions are design
To assist clients with their business needs while building and retaining positive relationships with Consumers. Act’s financial and BPO solutions include:
1. Account Receivable management
2. 3rd party collection
3. Portfolio management
Roles & Responsibilities :
· Worked on requirement gathering of the report.
· Analysed the database tables and created database views on the column needed.
· Used data blending , group , combined filed, aggregated field
· Created parameters , quick filters, Context filters, Action filters
· Used LOD, multiple measures like individual axes, dual axes, and blended axes.
· Created Tableau dashboard containing dimensional hierarchy and calculations and visualisations.
· Created charts like bar chart, line chart, pie chart, scatter chart, bubble chart, Heat and Tree map.
· Publishing workbook on server and giving access to users.
· Generated auto Tabcmd batch file to export PDF’s using SQL server store procedure and SSIS.
Show More Show LessDescription
Project Description : KrampGroep has its headquarters in Varsseveld, The Netherlands.
KrampGroep implements Distributed Order Management Solution. It is one of Europe’s largest wholesalers in
Spare parts and accessories for the agricultural industry, forest and grass-care markets. Kramp is the essential
Partner for its customers and suppliers with over 500,000 products available online, 10 distribution centers and
24 sales offices spread all over Europe. The company supplies spare parts to dealers and repair companies
Throughout Europe.
Roles & Responsibilities :
· Run the Custom SQL scripts and created Tableau Data Extracts (.tde).
· Used different types of filters, sets, calculated fields and parameters.
· Applied same Dimension, Date filter conditions to various worksheets.
· Applied Action filters wherever required.
· According to requirement, Used Target lines or goal lines using reference lines.
· Applied various formatting techniques.
· Created views like bar charts, funnel charts, line charts and combination charts.
· Built Worksheets and dashboards based on the BA's requirements.
· Combine the visualizations into Interactive Dashboards and publish them
To Tableau server.
· Scheduled refreshes created on the dashboards during publishing of
Dashboards in Tableau server.
· Daily checkups to see whether the refresh is success full or not.
· Full refreshes also performed whenever required.
Show More Show LessDescription
Ag-IMS provides access to documents and records relevant under theWTO Agreement on Agriculture. The system allows users to search and analyze agriculture-related informationnotified by the Members and questions raised and responses provided in the context of the Review Processcarried out by the Committee on Agriculture.
Show More Show LessDescription
For better business control and maneuvering it is mandatory tohave data at fingertips. Therefore, Datamatics has created 4dashboards for CFO namely,1) Profit and loss dashboard2) Key Accounts Dashboard3) Share holder Dashboard4) Risk Management DashboardThe ETL is implemented in SSIS and data warehouse wasDesigned in MS SQL Server 2012 and BI reports are developed inCognos 10.2.1
Show More Show LessDescription
Convergent is one of Americas largest business process outsourcing, revenuecycle and receivables management companies, with fourteen North American operating centers across all four timezones. The company has more than sixty years of history serving a diverse industry customer base, including contactcenter solutions, receivables management outsourcing, commercial receivables management and healthcare revenuecycle management. Convergent empowers its clients with an innovative combination of an adaptable workflow engine,technology-enabled operations, next-generation analytics and professional services to deliver superior financialperformance and high levels of client and consumer satisfaction.
Show More Show Less24000 USD / Year (Expecting)
-
Start Date / Notice Period end date: 2019-07-01