Iti Mishra

Cell: 774-***-**** Email: adfbew@r.postjobfree.com

PROFESSIONAL PROFILE:

Having 7 years of experience in Data warehousing, Business Intelligence and Data Visualization technologies.

Experience with Tableau Desktop 2019, 10.x, 8.x, 7.x, Tableau Server, Cognos 10 Suite, Cognos 8.X Suite.

Expertise in complete Life Cycle Development Process of a reporting solution that involved Gathering Business Requirements, Analyzing Business Needs, Development, Testing, Deployment, Implementation and Production Support.

Experience in designing stunning visualizations using tableau software and publishing and presenting dashboards on web and desktop platforms

In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.

Mastered the ability to design and deploy rich Graphic visualizations with Drill Down menu option and Parameterized using Tableau.

End to end experience in designing and deploying data visualizations using Tableau

Extensive experience in using Tableau functionalities for creating different Reports, Interactive Dashboards with page and dashboard Prompts.

Mastered the ability to design and deploy rich Graphic visualizations with Drill Down menu option and Parameterized using Tableau.

Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.

Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations

Utilized Best Practices and Proven Methodology in modeling data, ETL (Informatica) and other BI development process.

Expertise in Data ware Housing Concepts in OLTP/OLAP System Analysis and developing Database Schemas like Star Schema and Snowflake Schema for Relational and Dimensional Modelling.

Lead the team with individual contribution. Acted as a moderator for technical reviews by doingCode review, technical issues resolution and delivered the project with high quality.

Good Functional knowledge of Supply chain management, Customer relationship management, Mortgage, Investment and Financial Domain.

Possess excellent debugging skill with the acumen to solve production issues within the timelines.

Expertise in Process Improvement, System Integration, Requirement Analysis, Design, Testing / QA, Software development life cycle, customer service, Estimations.

Strong analytical, presentation, problem solving and excellent inter-personal communication skills and flexible to learn new technologies

Strong problem solving skills, ability to develop strategies for clients, and provide detailed documents to clients.

Work Experience:

Organization

Designation

Duration

Total Years

Wipro Technologies

Sr. Software Engineer

(01/2011)- (06/2013)

2.6 yrs

IBM India Pvt. Ltd.

Application Developer

(03/2007)- (12/2010)

4 yrs

Education, Certification & Award

Bachelor of Engineering (B.E E&TC), RGPV University Bhopal(2005), MP, India

Tableau 2020 Certified Desktop Specialist

IBM Certified Designer - Cognos 10 BI Author

Oracle Certified Associate SQL & PL/SQL

SCJP certified for Java 1.5.

Got Special Contribution to Project Excellence (SCOPE) Reward for Citi project.

Got Pat on Back (POB) award for the contribution made to eCRM Project.

Professional Experience:

Citi (Sr. BI Developer) Jan 11 – Jun 13

Projects: Data Integration and Reporting, Cards Paperless Dashboard, Portfolio Loss Dashboard, Warehouse Metadata Dashboard, Cards Earning and Spending Dashboards.

Tools: Tableau Server/ desktop, Cognos, Teradata, Oracle, SQL/PLSQL, Informatica, Control M

Responsibilities:

Regular interaction with business units Managers, users, other stakeholders to understand the business problems and gather the requirements.

Worked with the design and business team to develop effective Tableau visualization solutions.

Analysis of the requirements and preparing the understanding documents and discussing with business on the gaps and correcting the gaps in understanding.

Design review & approval with Client SME’s and Client architect team.

Participate in technical design reviews, functional specifications reviews, and contribute to development Cognos Reports, planning, resourcing, scheduling, and test plans

Creation of weekly project status reports and attending the weekly status calls with the customer

Onsite Lead and coordinator. Setting up meetings with Client and Business Users for requirement gathering.

Preparation of report technical specification, Functional Specification, Report Detail Designs.

Setting up Meeting with offshore folks for design & development of Reports.

Leading the team, Invoicing, risk tracking, Defect tracking.

Prepared Functional requirement document, Detail Design Documents of reports, Development of the Actuate Reports. Unit, System, Integration, UAT testing.

Worked on critical Tableau Dashboard like Portfolio Loss Dashboard which is used by Top management where we are showing data for Monthly, Quarterly and Yearly View from 2004 to till date. We did multiple Tableau Extract so that performance will be quick.

Connecting tableau to Oracle database to build Metadata Dashboard which tells about what data Stored in Datawarehouse firmwide like Structure, LOB, Usage, SOR of data etc.

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

Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Provisioned Dashboard Visualization solutions using Live and Extract data connections, based on the need and volumes of the data

Created actions, parameters, Filter and calculated fields for preparing dashboards and worksheets using Tableau.

Effectively used Data blending, filters, actions, Hierarchies feature in tableau.

Create/Manage Groups, Workbooks and Projects, Database Views, Data Sources and Data Connections

Performance Tuning of reports / Dashboards. Improving the performance through Extracts.

Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, Gantt charts

Developed List, Crosstab, and Graph, Drill through and some Critical reports in Tableau.

Understanding Reporting Requirements, Developed Cognos & Tableau Reports, Fix Production Tickets, Performance Tuning of the reports to make sure report execute with the specified benchmark, End to End deployment of the reports and Work closely with SME and Business to make sure reporting requirements are met.

Reconcile the numbers between legacy reports and automated Cognos/Tableau reports using Teradata SQL queries for each reporting element.

Requirements elicitation working with cross-functional teams in understanding current business processes, challenges, pain points & future growth needs of business

Proactive liaison between executive management, business SMEs/owners and technology implementation teams(onshore and offshore) to translate business requirements into IT solutions

Define tasks, milestones, estimate effort, duration, cost and resource planning to develop project plans and status reports

Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.

Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.

Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.

Scheduled frequency and time to refresh data for the when sources are publishing or extracted to server.

Ensures issues are identified, tracked, reported on and resolved in a timely manner.

Gain formal acceptance, sign-off of the project by the sponsor or customer and validate that all conditions of satisfaction have been met.

Design and review of testing documents like test plans, test cases and co-ordination efforts with QA.

ABB, UK(BI Developer) Feb 08 – Dec 10

Project: Webshop NG/4.0

Tools: Cognos 8.3 Suite, DB2 8.1, Oracle 9i, SharePoint.

Responsibilities:

Worked in developing strategy and technical specifications for implementing reporting portal/semantic layer in conjunction with data layer.

Created database layer and business layer, defining appropriate relationship between tables, query subjects in Framework Manager

Analyzing requirement Specification document and preparing the Technical Specification document as per the Business requirement and development of Cognos reports.

Involved in writing Stored Procedures and functions in Oracle PL/SQL.

Performance tuning the by analyzing and comparing the turnaround times between SQL and Cognos.

Deploying the reports and packages from Development to Testing, Testing to Production environments.

Trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports

Prepared Functional requirement document, Detail Design Documents of reports & Unit Test Cases

Understanding Reporting Requirements, Developed Reports, Fix Production Tickets, Performance Tuning of the reports to make sure report execute with the specified benchmark, End to End deployment of the reports and Work closely with SME and Business to make sure reporting requirements are met.

Testing reports using review checklists for Quality Assurance before delivering to the end users.

ABB, UK May 07 – Feb 08

Project: Business Information Portal

Tools: Oracle Discoverer, Oracle 9i

Responsibilities:

Requirements analysis, design, development, testing and implementation of Reports

Preparing the Detail Design Document. Coordinating meetings with onsite peers.

Testing of Reports - Unit testing & Integration testing

Coordinating meetings with onsite peers

Analysis of the requirements provided by the clients

Contact this candidate