SUMMARY:

• 8 years of experience in Design, Analysis, Development, Dimension Modelling, Deployment and Testing. Experience in Data and Business Analysis. Worked on various versions of COGNOS and Tableau in implementing complete life cycle for BI/enterprise system.
• ExtensiveExperience in Tableau Desktop and TableauServer in various versions ofTableauas a Developerand Administrator
• Expertize in creating visual appealing dashboards and reports.
• Proficient in Cognos 10 report Studio, in creating Active Reports
• Very good noledge of metadata modelling using Cognos Framework Manager.
• Experienced in SQL Queries, Creating Views, PL/SQL Stored Procedures, Functions, Triggers, Cursors as per the business requirements
• Worked on databases such as Oracle 10g/9i, SQL SERVER 2000/2005, DB2 and Teradata
• Experience in Production/Customer Support, Deployment, Development and Integration.
• Implementing projects and enhancements in Agile methodology with daily scrums
• Good Knowledge of Sprint planning, conducting daily scrums, sprint reviews, sprint retrospectives, halping stake holders with user stories, preparing product backlogs, sprint backlogs and monitoring sprint progress with burn down charts.
• Good skills in strategic planning of the project and execution
• Good skills in designing infographics and Visio diagrams for workflow designs, presentations and Proof of Concepts
• Possess good communication skills and comprehensive problem solving abilities. Able to manage communications among members at diverse situations in a team
• Possess skills to influence situational awareness between the Business and the development team, team empowerment and to instill transparency into the team
• Excellent management and decision making skills, positive attitude even in bleak situations.

TECHNICAL SKILLS

Business intelligence tools: Tableau Desktop, Tableau Server, COGNOS BI Suite (Report Studio, Query Studio, Analysis Studio, Event Studio, Framework Manager), Nintex Workflows, Informatica

Databases: Oracle, SQL Server, DB2, Teradata

Data Bending Tools: Alteryx

Languages: SQL, PL/SQL, VBA, C, C++, C#.net

Querying Tools: Toad, SQL - Plus, AQT

ETL: Informatica

Data Modelling: Visio 2003, ER/Studio 3.5/4.0, Erwin 4.1

Other Tableau Plug-ins: Senturus BI Connector

Project Management: Microsoft Team Foundation Server (TFS), SharePoint, MS-Excel

SDLC Methodologies: Agile/Scrum, Waterfall Models, Iterative Models

EXPERIENCE SUMMARY:

Confidential, Portland, OR

Sr. BI Developer/ Business Systems Analyst

Responsibilities:

• Involved designing, developing and maintained catalogs, Impromptu reports, templates, hot files, PDF files, snapshots, drill through.
• Involved in creating IQDs using Impromptu Administrator
• Generated reports as per the requirements using Cognos Impromptu
• Had to create Hierarchies from providing drill down options for the end-user
• Multidimensional analysis was done for Data Retrieval using Power play structure
• Worked on the prompts based on the user needs and format required
• Defined conditions, calculations and prompts in the catalog
• Different department users used the Power play environment dat is customized for each user depending on the requirements
• Enabled users to access the distributed HTML reports through local network intranet/internet, and via email
• Used Impromptu’s optimizing features like table weighing, governors, bulk fetch
• Performed Reporter Operations such as Sum and Average, Intersection, etc., Exception Highlighting Sorting, Ranking etc.
• Created various reports (List, Crosstab, Mailing Labels, Form Letter, Free Style) using Cognos Impromptu tool by querying the database
• Created standard and Ad-hoc reports (Formats, Layouts, quality data to carry) using Cognos Query
• Published the IWR reports on the web server.
• Created User Prompts, Conditions and Filters to improve the report generation
• Involved in integration, performance, and user acceptance testing for BI solutions and reports.
• Creating the connection with DB2 to Tableau and executed custom SQL Expressions to ensure better performance
• Created several Dashboards in Tableau Desktop as per the requirements and published them to internal team for review, further analysed data and customized the live dashboards using filters and actions
• Involved in creating Proof of Concepts using Cognos 11
• Wrote complex SQL in Advance Query Tool and connected dat SQL to Tableau for better performance of the dashboards
• Created Stacked Bars, Heat Maps and other several visualizations showing Actual vs forecast project budgets into Cost centres allowing business user to plan and understand controlling, functions and operations
• Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global), Parameters, Groups and sets for various analytical reports and dashboards.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel
• Tested dashboards to ensure data was matching as per the business requirements and eliminate errors and issues caused due to changes in underlying data
• Developed storytelling dashboards inTableauDesktop and published them on toTableauServer which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Combined views and reports into interactive dashboards in Tableau Desktop dat were presented to Business Users, Program Managers, and End Users.
• Involved in supporting the Business users technically with their monthly Financial Planning, Budgeting and Forecasting
• Designed and built KPI’s for business users to determine and track the data transfers
• Involved in full development lifecycle of projects using the BI tools like Cognos reporting, Framework Manager, Tableau and Informatica for ETL.
• Worked on a POC for Senturus BI connector to Tableau, ran test cases by connecting Framework Manager to tableau.
• Got trained and attended workshops on Alteryx for data blending and data prep and connecting the data to Tableau
• Scheduled data refresh on Tableau Server for weekly and monthly increments to ensure dat the views and dashboards were displaying the most recent data accurately.
• The responsibly included to be the Business Systems Analyst for Financial Data Warehouse
• Understanding the Business functions, analysing the requirements, defining proper scope for the project, preparing technical and functional documents.
• Involved in ensuring operations, controls and support for the Business
• Monitoring the existing developed applications, test the performance of various Data Engines.
• Researched, attended several workshops and implemented In-memory applications/tools to give a faster and high performed data load results
• Involved in enhancing the business requirements and analysing data from the DB2 Warehouse and the SAP source ERP system for designing, developing, testing, production rollover of reporting and analysis projects within Tableau Desktop.
• Ensured better Team foundation in Microsoft Team Foundation Server, and followed agile methodology with Scrum Boards and Dashboards to track and monitor the progress of project, removing road blocks and accomplished successful sprints.
• Designed a SharePoint site and developed workflows in Nintex to improve working relationship between IT Team and Business Users
• Involved in weekly reconciliation of Data Warehouse with the ERP system to ensure successful ETL process

Confidential, San Diego, CA

COGNOS BI Developer / Tableau Analyst

Responsibilities:

• Designed and developed complex Active Report Dashboards for iPad.
• Installed Cognos Products like Cognos BI, Extended BI, Financial Performance Management and Transformer.
• Participated in integration, performance, and user acceptance testing for BI solutions.
• Worked with DBA’s in improving the report and framework performance/tuning
• Creating the connection with oracle OLTP to Tableau through drivers.
• Generated Tableau Data Extract (TDE) files direct from both Informatica Power Center and Informatica Cloud
• Created views in Tableau Desktop dat were published to internal team for review and further data analysis and customization using filters and actions.
• Created Heat Map showing current service subscribers by colour dat were broken into regions allowing business user to understand where we have most users vs. least users.
• Projected and forecasted future growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on which states were connected the most.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Specialized in writing data-driven applications, and will have lived through the lifecycle of the data dat drives them
• Tested dashboards to ensure data was matching as per the business requirements and if their were any changes in underlying data.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups
• Interacted with business users and performed Gap Analysis of Client requirements.
• Involved in reviewing business requirements and analyzing data sources form Excel/SQL Server for design, development, testing, and production rollover of reporting and analysis projects withinTableauDesktop.
• Designed and implemented proof of concept solutions and created advanced BI visualizations using Tableau platform
• Responsible for upgrading the Tableau 8.3 to Tableau 9.0.3
• Setup Distributed server system (configure Tableau Server to include worker machines along with the Primary)
• Written complex common table expressions to blend data and connected it to the Tableau data source
• Worked closely with business power users to create reports/complex dashboards
• TEMPEffectively used data blending, filters, actions, and Hierarchies feature intableau.
• Created interactive dashboards by combining views and reports inTableauDesktop
• Created users using Tableau Admin and assigning privileges to create report/publishing reports to server
• Tuned the reports performance using Cache options/ Timely refreshes of data.
• Involved in testing the SQL Scripts for report development,Tableaureports, Dashboards, Scorecards and handled the performance issues TEMPeffectively
• Responsible for creating /delivering monthly reports to business users.

Confidential, New York City, NY

COGNOS / Tableau Analyst

Responsibilities:

• Included developing of models using Framework Manager Techniques.
• Worked on creating Packages. Published them on to COGNOS Connection in order to create Ad-hoc reports using Query Studio, and to produce professional reports using Report Studio.
• Created new Query Subjects and arranged in different folder structure for Business View.
• Involved in creating of complex reports like Crosstab, Drill through, Master detail, Dashboards and Burst Reports using Report Studio.
• Also involved in creating reports using Conditional formatting, Conditional blocks, Conditional variables, Advanced Conditional styles and Conditional Layout features in Report Studio.
• Created queries in report studio using Join and Union
• Used Cognos 10.1 to develop the reports
• Built Multi-Dimensional Model with Relational Data using Framework Manager and Transformers.
• Worked with Global Drill- through Definitions to drill through from analysis studio reports to report studio reports (MOLAP - ROLAP)
• Gained experience in Deploying reports, cubes and packages from Development to Production environment.
• Used Cognos Transformer to build multidimensional cubes
• Created Data Warehouses using ETL tool SSIS
• Involved in created reports with custom prompt pages (using HTML and JavaScript) in Report Studio
• Also included setting up Cardinality (minimum, maximum & optional), Determinants so as to avoid double counting, and supporting loop joins, optimizing data source, and identifying dimensions and facts.
• Analysed requirements for various reports, dashboards, scorecards and created proof of concept / prototype for the same using Tableau desktop.
• Creating, publishing customized interactive reports and dashboards
• Extensive use of data blending, filters, parameters, sets, groups etc., with best practices
• Knowledge on installation, configuration, procurement assessment, machine uplifts.
• Defined best practices for Tableau report development.
• Mentored business power users to create reports/dashboards using tableau desktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global), Parameters, Groups and sets for various analytical reports and dashboards.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.
• Published developed dashboard, reports on the Tableau Server so dat the end users having access to the server can view the data.
• Responsible to facilitate load testing and benchmarking the load time of dashboards.

Environment: Windows Server 2012,TableauDesktop 8.2/8.0,TableauServer, Cognos, Oracle 9, IBM DB2.

Confidential, Atlanta, GA

Cognos BI Developer

Responsibilities:

• Developed complex reports using cognos report studio.
• Created Framework Manager Model for the gatheird requirements.
• Performed end to end testing on reports.
• Performed extensive testing on Cognos upgrade from 8.4 to 10.1
• Developed Relational and Dimensional Models for reporting using Framework Manager.
• Designed the framework for the report and developed dashboards using report studio
• Developed DMR Models & IQD’s in Framework Manager
• Developed Prompt pages and Cascading input prompts to display only selected entrees in the report
• Fine-tuned the queries for performance purpose and enhanced the performance of the reports.
• Developed Report Views to organize reports in Cognos Connection
• Gained expertise in handling Administration tasks like bursting and scheduling the reports.
• Obtained good experience in all phases of testing which majorly included defining user acceptance criteria, developing plans/scripts, documenting expected results, execution of scripts and validating actual results

Confidential, Chicago, IL

Cognos Developer

Responsibilities:

• Mainly involved in interacting with the business users and gathering requirements, report design, report development, and support of all client/server layers and components of the data warehouse.
• Involved building Multi-Dimensional Models (DMR) with Relational Data using Framework Manager, designed models and deployed Packages to the Report Servers.
• Created new Query Subjects and arranged in different folder structure for Business View and also manually created the query subjects using the complex SQL.
• Framework Manager Techniques were used to develop the models, implementing the logics which included joins, union, and multiple filters, within the Framework for the ad-hoc reporting to the end users
• Moreover, trained the end users on how to use the reporting tool, which included building and customizing the ad-hoc reports.
• Implemented Framework manager security for Data access, Object level access and Package access based on the Organization Level.
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model
• Involved in developing List, cross tab, drill through, master-detail, conditional blocks, chart and complex reports which involved Multiple Prompts in Report Studio and report bursting
• Also had to develop the new dashboard right from the start, which included gathering the requirements from end user and implemented and delivered in a time
• Developed Reports with multiple Cognos Viewers and integrated multiple Cognos reports onto a Single Page Report.
• Scheduled and Distributed Reports through Schedule Management in Cognos Connection.
• Data is moved from one data source to another by using SSIS. Created Star Schemas using SSIS packages.
• Obtained experience in Deploying reports, cubes and packages from Development to Production environment.
• Customized Reports by writing complex custom SQL, XML,HTML, JAVASCRIPT
• Worked with the Data analysis, development, SQL performance tuning, data warehousing ETL process, data conversions and user documentation.