SUMMARY

• Has 12 years of experience in Business Intelligence Reporting. Used Tableau, Power BI, Cognos (Framework Manager, Report studio, Query Studio, Analysis Studio), Cognos 11.x, Cognos 10.2.x, Cognos 8x, Cognos 7x (Framework manager, Report Studio, Query studio, Active Reports, Workspace Advance), Cognos SOA, Impromptu Administrator, Impromptu Web Reports (IWR), PowerPlay, Transformer, Powerplay, Cognos Visualization, Dynamic Cubes, MY Data Sets, Cognos Gomobile, Access Manager and OLAP Cubes, ESRI maps.
• Extensive Experience of around 5 years in Tableau Desktop and Tableau Server Administration in various versions of Tableau 2019.1, 2018.1, 10.5, 8.0, 8.1, 8.2.
• Has installed and upgraded the Tableau environment and created the security.
• Proficient in creating Calculations (Cube Calculations, Hide Columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop.
• Have 14 Years of experience in working within United States and 4 1/2 Years of Experience working with Confidential and 5 Years of Experience with State Farm Insurance and worked with Business users Team and IT side as well.
• Experience in Health care data analysis and providing the Cognos and Tableau reports and Dashboards to the users.
• As a Cognos Administrator was involved in Installation and configuration and Monitoring servers, Creating data sources, Publishing reports, packages, and cubes between environments.
• Providing security and access to the Cognos tool and Solving Environment related issues.
• Strong experience in Cognos administration, Access Manager Security, LDAP, User Groups’, Roles Configuration, Deployment/s and Content Administration.
• As a Data Analyst Involved in designing the Aggregates for the Dimensions in the data warehouse as per the Business requirement. Analyzed the data to come up with the report fields for the reports.
• 2 Years of Experience in Power BI, SSRS, OBIEE, OTBI, visualization and Dashboard development.
• Worked on PL/SQL, stored procedures, functions and packages.
• Has good knowledge on Health Claims and created reports using the Claims data.
• Strong Experience in Health, Insurance, Manufacturing, Human Resource, Pharmaceutical and Financial Domains.
• Provided the Impact Analysis reports and GAP analysis report to the team management for the business change.
• Created Cognos Mobile Reports, Visualizations and Dashboards for the iPad users.
• Has functional knowledge on the HR Systems (Human Resource) and worked on the Oracle HCM tool.
• Used Netizza stored Procedures as input to create the Cognos Reports and used the Netizza SQL to validate the data.
• Experience in Creating and publishing packages using Framework Manager Models with Data layer, Business Layer and Presentation layers.
• Experience in creating Data sets and generating different kind of reports including Templates, List, Cross - tab, Maps, Charts, Conditional formatting, report scheduling and report bursting using Report studio in Cognos 11.x, 10.x/8x/7x.
• Have extensively used MDX functions for creating the reports using the Cube data.
• Strong work experience of Agile and Waterfall methodologies.
• Provided key project inputs by working with Business/Functional Team and developers in defining several functional and technical issues of project and system requirements.
• Worked with large Databases in Data warehousing such as ODS, OLAP data sources and Data Marts.
• Good Knowledge and understanding on ODS, Data Warehouse, Datamarts, Star and Snow Flake Schemas.
• Created the reports using different types of Prompts such as Cascading Prompts, Tree Prompt, Text Prompt, Date and Time Prompt, Select and search Prompt and value Prompts.
• Databases: Teradata OLAP 14.10, Oracle 11.2/10g/9.x/8.x/7.x/, MS SQL Server, DB2, Teradata, PL/SQL, SQL, WINSQL, TOAD, PL/SQL Developer, PS Query and Teradata SQL Assistant (TSA), Alteryx.
• Expertise in preparing Test Plans, Cases & Scripts based on Requirement specifications. Worked on HP ALM QC tool and Remedy.

TECHNICAL SKILLS

BI Tools: Tableau, Cognos 11.x, Cognos 10.2.x, 8.x (Cognos Connection, Framework Manager, Report Studio, Query Studio, Analysis Studio, Metric Studio, Event Studio), ReportNet MR1, MR2, EP Series7.0, (Impromptu, PowerPlay Transformer, Access Manager,, Busines Objects, Data Stage, Informatica, Alteryx

Databases: Oracle 10g/9.x/8.x/7.x/, DB2, Teradata, MS SQL Server, MySQL, MS Access, IMS DB, IMS DC, Netezza

Languages: SQL, PL/SQL, Python, R, C, Java, J2EE, Microsoft Visio, VSCOBOL II, Focus, JCL, SQL and REXX

Operating Systems: MS DOS, WinNT/2000, UNIX MVS/ESA, OS/390 Mainframe, MS-WINDOWS NT

Hardware: IBM 3090, ES/9000, IBM PCs

Host Tools & Utilities: Epic Clarity, Panvalet, Endevor, MS Project, MS Office, Changeman, CHAMP, CA-7, Auto Job Schedule, Princeton, ISPF Panels, VSAM, SPUFI, File-Aid, CABS, COGEN, Xpeditor, Teradata SQL Assistant (TSA) and Inter Test

Front End: CICS, IMS/ DC

PROFESSIONAL EXPERIENCE

Confidential, Berkeley, CA

Sr. BI Report Developer/Tableau

Responsibilities:

• Understanding the business requirements by interacting with the business users.
• Created own customized visualizations in tableau
• Conduct kick off and follow up client meetings for these dashboards
• Development of dashboard in Tableau for data visualization to expedite the data analysis process and report automation.
• Design, configure, and document Tableau Data Source and Extract
• Built the Data Visualizations using Charts, Drill - Downs, and Quick Filters.
• Built the Dashboard View for Senior Executive Team.
• Involved in writing SQL queries using Oracle 10g Data Services.
• Created the KPIs (Key process Indicators) to display the HR data.
• Liaise with various stakeholders to gather requirements and write functional requirement documents and mapping documents.

Confidential

BI Report Developer/ Data Analyst

Responsibilities:

• Design interactive dashboards in Tableau Desktop and published them to Tableau Server.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps.
• Worked on motion chart, Bubble chart, drill down analysis using tableau desktop.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Users to interpret functional requirements into report specifications. Involving in writing complex SQL queries to verify data from Source to Target Performed data validation testing writing SQL queries
• Accountable for creating financial Reports and Dashboards. Application has been designed driver-based planning - an approach that bases financial forecast on operational drivers supports Companies performance management. Created rolling forecast based budgeting, this will help FP&A team to plan ahead and more often and updated forecast with actuals. Developed several data input forms for Inventory, Accounts Receivables, Accounts Payables, Workforce and Financial statement planning.
• Had conducted deep dive meetings with the business users to understand the current automation process and Adhoc jobs for budget/forecast calculations
• Understanding the business requirements by interacting with the business users.
• Created own customized visualizations in tableau
• Developed Proof of concept to showcase and measure the efficiency of the proposed solution
• Conduct kick off and follow up client meetings for these dashboards
• Development of dashboard in Tableau for data visualization to expedite the data analysis process and report automation.
• Design, configure, and document Tableau Data Source and Extract
• Built the Data Visualizations using Charts, Drill - Downs, and Quick Filters.
• Built the Dashboard View for Senior Executive Team.
• Involved in writing SQL queries using Teradata, Oracle 10g.
• Liaise with various stakeholders to gather requirements and write functional requirement documents and mapping documents.

Environment: Tableau Desktop 9.0, Tableau Desktop 10.0, Oracle SQL, PL/ SQL Developer, Cognos 10.x and Cognos 11.x, Frame Work Manager, Report Studio, Cognos Cube Designer 10.2 for Dynamic Cubes, Workspace Advanced, Workspace, Big data Hadoop, Business Objects, Query Studio, Analysis Studio, Power play Transformer, Dynamic Cubes, SSAS, Active reports, Db2, Oracle 11.2, Data Stage, Informatica.

Confidential, Tea Neck, NJ

BI Report Developer

Responsibilities:

• Involved in upgrading / migrating the reports from Cognos 10.x to Cognos 11.05.
• Created DMR and Relational Model in Framework Manager.
• Have extensively used MDX functions for creating the reports using the Cube data.
• Created Dashboards using the Tableau tool with the Oracle data.
• Coordination for Integration testing, UAT, UTC and resolving the support issues.
• Provided the training and documentation to the users on creating the reports using the Cube Packages and relational Packages.
• Created the Cognos reports using the Transact SQLs in the Report Studio and also converted some of them into Framework Manager Package.
• Conducted/Organized end user training sessions to utilize reports effectively on Tableau and Cognos environments.
• Designed, developed and modified complex reports.
• Created intuitive and user friendly reporting environment, ad-hoc and static reports.
• Monitored and scheduled tasks, created data sources, managed and deployed content in Tableau Server and Tableau Desktop

Environment: Tableau Server 9.2/10.1, Tableau Desktop 9.2/10.1., Cognos 10.2, Cognos 11.05, IBM Life Cycle Manager, Frame Work Manager, Report Studio, Dynamic Cubes, PL/ SQL Developer, MY Data Sets, Query Studio, Analysis Studio, Power play Transformer, Active reports, Winsql, SQL Developer, Oracle 11.2

Confidential, Pleasanton, CA

Tableau Developer

Responsibilities:

• Extracting data from different sources connecting them and used the same to create dashboard
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
• Creating data blending in case of merging two different datasets.
• Created rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Analyzed the source data and handled efficiently by modifying the data types.
• Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
• Generated context filters and used performance actions while handling huge volume of data.
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery.
• Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
• Used Sheet filters to produce multiple chart types in a single view.
• Used calculated fields extensively for different logics for Trend, Extended price calculations for the different cost types.
• Worked on creating reports for every item under working capital such as Inventory, Accounts Receivables, Accounts Payables etc.

Sr. Cognos Developer

Confidential

Responsibilities:

• Involved in maintain the Cognos 10.2 version environment.
• Created DMR and Relational Model in Framework Manager.
• Have extensively used MDX functions for creating the reports using the Cube data.
• Created Dashboards using the Tableau tool with the Oracle data.
• Coordination for Integration testing, UAT, UTC and resolving the support issues.
• Provided the training and documentation to the users on creating the reports using the Cube Packages and relational Packages.
• Created the Cognos reports using the Transact SQLs in the Report Studio and also converted some of them into Framework Manager Package.

Environment: Tableau Server 8.3/9.0, Tableau Desktop 8.3/9.0., Cognos 10.2, Frame Work Manager, Report Studio, Dynamic Cubes, PL/ SQL Developer, MY Data Sets, Query Studio, Analysis Studio, Power play Transformer, Active reports, Winsql, SQL Developer, Oracle 11.2