SUMMARY

• Over 8 years of experience in all the BI Tools Tableau, IBM Cognos in Retail, Financial, Manufacturing, Pharmaceutical industries
• Over 4+ years of experience in designing, developing and publishing of Tableau Applications.
• Experience in Designing, Administration, Analysis, Management in the Business Intelligence Data warehousing, Client Server Technologies, Web - based Applications and Databases, UX Optimization.
• Creation of metrics, attributes, filters, reports, and dashboards. Created advanced chart types, visualizations and complex calculations to manipulate the data. Act as a Point of Contact in Data Interoperability, Analytics and BI and Production Support issue resolution.
• Designed, developed and supported BI solutions, Involved in Debugging and monitoring, and troubleshooting issues/tickets. Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.
• Experience in Developing Performance Dashboards, Score cards, Metrics, What if analysis, Prompts, Drills, Search (using Add-ons),Reports/Dashboards for the functional areas including Finance, Pricing, Purchasing, HR, Demand Planning, Discrete Manufacturing, Inventory Warehouse Management and Sales/Marketing.
• Experience in using advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Pie Chart, Gantt Chart, Histograms, Water Fall charts, Donut graph etc,. to assist business users in solving complex problems.
• Designed and Optimized Connections, Data Extracts, Schedules for Background Tasks and Data Refreshes for corporate Tableau Server.
• Hands on experience in working with SQL Server, Teradata, Netezza Databases, SAP BW, Jira, Hadoop, HIVE, Data Modeling and Data analytics.
• Strong understanding of Data warehouse architecture Enterprise Data Warehouse (EDW) and Operational Data Store (ODS).
• Experienced with Informatica Power Exchange (5.x/8.x) for Loading/Retrieving data from mainframe systems
• Experience in data warehousing using various ETL tools (Informatica 6.1/7.1/ 8) Extensively worked on Informatica Power Center tools- Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Worked on Developing Website (Portal) for Board Members which includes embedding tableau dashboards in the website which takes tableau to a whole new level.
• Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports
• Experienced in various Cognos tools such as Cognos 8 BI Suite(Framework Manager, Report Studio, Cognos Connection, Metric studio, Query Studio, and Event Studio), Report Net, Impromptu, Power Play Transformer; Impromptu Web Reports (IWR), Access Manager, and Cognos EP series 7
• Experienced with complete application development life-cycle including requirements gathering, analysis and design, implementing, testing and deployment
• Knowledge on HTML and JavaScript and ability to implement those technologies in Cognos reports

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Tableau Lead/Developer

Environment: Tableau 9.02, 8.3 Oracle, Netezza, Jira, MS Share point, SAP BW Windows 2008/Windows, Teradata, Hadoop

Responsibilities:

• Created dashboards, stories and visualizations inTableau. Created report schedules onTableau server.
• Created advanced chart visualizations in Tableau using Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Pie Chart, Gantt Chart, Histograms.
• Created C-Level KPI (Key Performance Indexes) dashboards with interactive visualizations.
• Innovated new ways for UX optimization of Tableau dashboards.
• Created dashboards for scenario analysis, variance analysis, monthly and quarterly reports and ad-hoc reports.
• Designed and Optimized Connections, Data Extracts, Schedules for Background Tasks and Data Refreshes for in corporate Tableau Server.
• Prepared analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Experience in working with SQL Server and Netezza Databases.
• Performance tuning of reports and working on tickets within Tableau Server and Reports.
• Tested SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Tested, Cleaned, and Standardized Data to meet the business standards using Execute SQL task, Conditional Split, Data Conversion, and Derived column in different environments.
• Created and developed Parameterized, Drill Down and AD Hoc Reports using SQL Server 2008 Reports Services (SSRS)
• Interacted with the existing database developers and DBA to understand the existing schema.
• Thorough analysis, unit testing and integrated testing with other applications of database objects & T-SQL statements before deployment to the production server.
• Experience in converting sales force and cognos reports in to rich Tableau Dashboards.
• Knowledge about integrating Java Script with Tableau.
• Worked on Developing Website (Portal) for board members by embedding tableau dashboards in the website.

Confidential, Memphis, TN

Tableau Developer

Environment: Tableau 8.1, Power BI, Oracle, Teradata, MS Share point, SAP BW, Windows 2008/Windows 7, Hadoop

Responsibilities:

• Designed and Optimized Connections, Data Extracts, Schedules for Background Tasks and Data Refreshes for corporate Tableau Server.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Hands on experience in administration, configuration, maintenance & upgrade setting up Tableau Server.
• Developed analytical reports from several data sources and blended data on a single worksheet in Tableau Desktop.
• Used advance chart visualizations in like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Pie Chart, Gantt Chart, Histograms, Water Fall charts, funnel charts.
• Experience in OLAP, OLTP.
• Set up time and frequency to refresh data sources for reports.
• Created user manuals and documented standard reports for user training.
• Resolved tickets and troubleshot issues in Tableau Server and Reports.
• Tested SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Used analytical features statistical functions and calculations, trend lines and forecasting
• Knowledge about integrating Java Script with Tableau.
• Created, deployed, and managed reports using SSRS (Sql Server Reporting Services).
• Interacted with the users and troubleshot the problems involved with the reports, dashboards and problems related to the privileges.

Confidential, Webster, MA

Tableau Developer

Environment: Tableau 6/7, Power BI, Windows 2008, SQL server 2008/2012, SSRS, SSIS, SSAS, Jira, Hive

Responsibilities:

• Worked with end users to understand the requirements, layout, and guidelines of the application to be developed.
• Worked on enhancements updating the tables, adding new tables, Joins, detecting loops.
• Created additional contexts, new dimension and measure objects in the Universe
• Develop Ad-Hoc reports and complex dashboards in Tableau.
• Created interactive, tabular, graphical, or free-form reports from relational, multidimensional, or XML-based data sources using SSRS (SQL Server Reporting Services)
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Gather data from different data sources like MySQL, Excel.
• Prototyped data visualizations using Charts, drill-down, parameterized controls using Tableau to highlight the value of analytics in Executive decision support control.
• Define best practices for creating Tableau dashboards by matching requirements to the charts to be chosen, color patterns as per user's needs, standardizing dashboard's size, look and feel etc.
• Developed Ad-hoc reports using Tableau Desktop, Excel.
• Developed visualizations using sets, Parameters, Calculated Fields, Dynamic sorting, Filtering, Parameter driven analysis.
• Used excel sheet, flat files, CSV files to generate Tableau adhoc reports.
• Generated context filters and used performance actions while handling huge volume of data.
• Generated tableau dashboards with forecast and reference lines.
• Used filters, quick filters, sets, parameters and calculated fields on Tableau reports.
• Designed dash boards for actionable, non-actionable complaints from Multidimensional database.
• Generated dashboards using dual axis for comparison.

Confidential, Bridgewater, NJ

Cognos Developer

Environment: Cognos 8.1, Windows XP, SQL Server - 2005, Oracle

Responsibilities:

• Created various reports using different lists in single and multiple pages according to filter conditions.
• Requirement gathering from business and client interaction.
• Created highly Complex Reports using OLAP CUBES as Data Source for Multi-Dimensional Analysis.
• Used Conditional Variable to display different colors and for text according to format.
• Used Designing the reports and bursting the reports.
• Used Schedule Management to schedule the reports.
• Involved in migration of Cognos ReportNet to Cognos 8.
• Implemented report bursting to distribute reports effectively.
• Used Cognos Event Studio to manage scripts, cubes refreshes, report runs and notifications.
• Worked closely with different business teams to gather requirements, prepare functional and technical documents and UAT Process.
• Coded Stored procedures and PL/SQL scripts to load, update data tables.
• Provided Training to different business users to develop dashboards in workspace and workspace advanced.

Confidential, Houston, TX

Cognos Developer

Environment: Cognos Report Net 1.1, SQL Server 2000, SAP BW and Windows XP

Responsibilities:

• Created List Reports, Cross-tab Reports, Chart Reports, Repeaters, Drill-Thru and Master Detail query Reports using Report Studio.
• Created Reports using Tabular SQL to reduce the load on the Framework Manager model
• Created Query Prompts, Calculations, Conditions and Filters in the reports.
• Developed Prompt Pages and Cascaded input Prompts to display only the selected entries in the report.
• Closely worked with ETL team to design data marts by understanding user requirements and increasing the reporting efficiency.
• Scheduled and Distributed reports using Schedule Management in Cognos Connection.
• Involved in Documentation and Training Users on Query Studio for Ad-Hoc Reporting
• Participated in the workshops for gathering requirements.
• Analyzed the impact on the reports due to the changes in the Source systems.
• Developed PowerPlay Cubes for better analysis of the data.
• Implemented the security setup for reporting and User setup for BI reporting Access Manager and Sun one Directory server.
• Published the Cubes to Cognos 8 Analysis Studio using Framework Manager.
• Modified existing reports to in corporate the changes in the Source System.
• Prepared Test cases for report validation.
• Involved in Unit and Integration testing.
• Responsible for code migration across environments (DEV,UAT, Prod)
• Responsible for documenting the code changes as per the User change requests

Confidential, Chicago, IL

Cognos Developer

Environment: Cognos Report Net 1.1, Informatica, SQL Server 2000 and Windows

Responsibilities:

• Interact with the business users and documented their query, business analysis and reporting needs.
• Understood business logic underlying the requirements, based on that developed test data.
• Involved in developing a Star Schema using Erwin.
• Oraganized daily status call with the team and Monitored Reporting and ETL developers.
• Provide the mockup reports to help the developers.
• Restructured and reorganized several tables, and created indexes for better performance.
• Involved in migration of catalogs, Reports from Impromptu to Cognos8 & Report Net using Migration Utility.
• Designed models using Framework Manager and deployed packages to the Report Net Servers
• Created different types of reports likeList, Cross-tab, Chart, Drill-ThruandMaster-Detail Reports.
• Created multipleDashboard reportsfor multiple packages.
• Developed Prompt Pages, Cascaded input Prompts to display only the selected entries in the report and also worked on the customization ofprompt parameters.
• Involved in extensive use ofconditional formattingwhile developing reports inReport Studio.
• Extensively worked on Informatica Power Center tools- Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager
• Responsible for performance tuning inInformatica Power Centerat the Target Level, Source level, Mapping Level, Session Level, and System Level.
• Initiated training for the users to do ad-hoc reporting usingQuery Studio.
• Extensive experience on StructuringMetadata and Cognos Modelsusing Framework Manager.
• Provided support for slowly changing dimensions in data marts
• Implemented data profiling and quality check inData Manager
• Designed and Prepared a Training Material for the Users.
• Closely Involved inRequirement gatheringandAnalysiswith the customers.
• Created List Reports, Cross tab Reports and Control Charts
• Implemented Security for Data access, Object level access and Package access
• Used Cognos Connection extensively for organizing, security, scheduling and distributing reports
• Extensive experience inSecurity Administrationbased along with LDAP.
• Formalized the reporting process by creating thetechnical specificationand requirementspecification.