SUMMARY

• Working as Senior Lead BI Tableau Developer with 8 years of IT experience analysis, design, testing, development and implementation of client/server applications.
• Experienced in designing and implementing each phase involved in DWH and BI SDLC (Software Development Life Cycle).
• Worked on Tableau Desktop, Tableau Server, and Cognos Suite.
• Experience to Resolve Help desk ticket issues.
• Warehousing and Business Intelligence applications using Tableau, COGNOS Suite.
• Worked with different data sources Sql server, Oracle, Excel, MS Access.
• Experience of Cognos 10.2.1 (Framework Manager, Cognos connection, Report Studio, Workspace, Workspace Advanced and Event Studio).
• Experience in creating Tableau Dashboard.
• Trained on R Language, statistical analysis, good in writing machine language coding.
• Experience with Triggers on Cognos for scheduling.
• Expertise in designing, modeling and architecting Data warehousing Concepts in OLTP/OLAP System. Analysis and developing Database Schemas like Star Schema and Snowflake Schema for Relational and Dimensional Modeling.
• Utilized Best Practices and Proven Methodology in data modeling, ETL and other BI development process
• Implemented Security in Cognos using Windows Active Directory.
• Expertise in Framework Manager Modeling (DMR and Relational Models) and Complex Report building with Report Studio
• Experience with the design and development of Tableau visualization solutions.
• Prepared fit gap analysis documents, Identified gaps.
• Expertise in creating Dash board reports and using Java Script in Report studio
• Created Ad - Hoc reports using Query studio and Trained power users to use Query Studio for Ad-Hoc reporting.
• Very good experience in customizing the Cognos connection portal.
• Interacting with the End users on a regular basis for gathering the requirements and resolving issues pertaining to the reports.
• Deploying models and reports from Development to Production and administering users/groups/roles
• Ability to meet deadlines and handle multiple tasks, flexible in work schedules and possess good communication skills.
• Ability to write and maintain technical documentation to describe Reports development, logic, coding, testing, changes, and corrections.

TECHNICAL SKILLS

Primary Skills: Data warehousing ( OLAP).

Operating Systems: Windows Xp

Languages: PL/SQL

ETL Tools: Informatica

Reporting Tools: Tableau Desktop, Tableau Server, Cognos Suite, FM, Report Studio, Transformer

Databases: Oracle 11g, Sql Server.

PROFESSIONAL EXPERIENCE

Confidential

Sr Lead Tableau Developer

Responsibilities:

• Involved in Gathering business requirements for various customers.
• Defined and guided the definition of technical architecture to meet business requirements in infrastructure and Applications products implementations.
• Providing infrastructure sizing, including hardware and software requirements.
• Developed and Documented technical architecture, system design, performance test results and other technical Aspects of the implementation.
• Prepared fit gap analysis documents, Identified gaps.
• Created Design documents such as Functional, Technical specs, and also package creation documents.
• Excellent knowledge of software development life cycle activities including analysis, design, development, unit testing, production deployment and Maintenance
• Developing, Designing and supporting interactive Tableau Dashboard reports.
• Experience with the design and development of Tableau visualization solutions.
• Created Bar Charts, Columns Charts, water fall charts, Heat Maps, And Geographical Maps.
• Experience in Marks, Action, Filters, Parameters, Cards, Publisher and Security..
• Created Derived Columns to fulfill the User Requirements.
• Created Parameters to reports be more User friendly to End Users.
• Connecting multiple data source with Data Blending technique.
• Formatting the Data by using Legends, Marks, Colors, Sizes, and Shapes.
• Providing the Security while Publishing to the Tableau Server.
• Applied various types filters like Data source filters, Quick filters and Context Filters.
• Created table calculations, calculated fields and parameters.
• Created groups, sets, bins and performed conditional sorting and filtering as per the requirements.
• Coordinating with Business Analyst in validating report requirements.
• Validate the data for each report and review the reports.
• Involved in the entire process of developing the new reports and delivering them to the client.
• Unit testing and peer reviews are done after report development.
• Interacted with the clients on a regular basis, for resolving issues pertaining to the reports.

Environment: Tableau Desktop, Tableau Server, Sql Server (SQL, PL/SQL), Cognos 10.2.1 (Framework Manager, Query Studio, Report Studio), Informatica.

Confidential

Tableau Developer

Responsibilities:

• Involved in Gathering business requirements for various reports by analyzing focus code.
• Prepared fit gap analysis documents, Identified gaps.
• Created Design documents such as Functional, Technical specs, and also package creation documents.
• End to End experience in designing and deploying date visualization using tableau
• Responsible for Preparing the Report Design specifications based on the User’s requirement.
• Involved in Data modeling.
• Created List, Cross Tab Reports with Quick Filters, Summarized Filters.
• Developing, Designing and supporting interactive Tableau Dashboard reports.
• Experience with the design and development of Tableau visualization solutions.
• Created Bar Charts, Columns Charts, water fall charts, Heat Maps, And Geographical Maps.
• Experience in Marks, Action, Filters, Parameters, Cards, Publisher and Security..
• Created Derived Columns to fulfill the User Requirements.
• Created Parameters to reports be more User friendly to End Users.
• Connecting multiple data source with Data Blending technique.
• Formatting the Data by using Legends, Marks, Colors, Sizes, and Shapes.
• Providing the Security while Publishing to the Tableau Server.
• Applied various types filters like Data source filters, Quick filters and Context Filters.
• Created table calculations, calculated fields and parameters.
• Created groups, sets, bins and performed conditional sorting and filtering as per the requirements.
• Coordinating with Business Analyst in validating report requirements.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Validate the data for each report and review the reports.
• Involved in the entire process of developing the new reports and delivering them to the client.
• Unit testing and peer reviews are done after report development.

Environment: Tableau Desktop, Tableau Server, Sql Server (SQL, PL/SQL), Flat files, SQL Developer, Informatica 9.x.

Confidential

Sr. Report Developer

Responsibilities:

• Involved in Gathering business requirements for various reports
• Prepared fit gap analysis documents, Identified gaps.
• Creation of reports using standard filters, calculations and conditions.
• Creation of reports with Prompts like Textbox prompt, Value prompt, cascading prompts.
• Developed different reports like drill through reports, conditional blocks, conditional formatting.
• Applied layout calculations, and written case statements for various conditions.
• Developing and testing of the different reports, Self-review of the reports after completion of development of the report.
• Interacting with the onsite coordinator on a regular basis for resolving issues pertaining to the reports
• Designing Cognos Framework manager Model for the Data Marts.
• Implementation of Framework Manager Model in Cognos 10.2.
• Implementation of Data Level, Object Level and Package Level Security in Framework Manager Model.
• Creation of Packages and publishing the same.
• Educating business users on how to make use of the Cognos Package/Namespace in Cognos Query Studio.
• Creation of Complex Reports in Report Studio.
• Made use of Value Prompt, Text Box Prompt, Date Prompt, Select and select search Prompts. Almost made use of all its properties and feature.
• Created DMR in Framework Manager Model against relational Data Source.
• Creation of Packages and publishing the same.
• Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements.
• Involved in complete Software Development project life cycle.
• Installation & Configuring the Cognos 10.2 on Windows Environment and Configured with LDAP.
• Responsible for creating User groups and roles to manage security in Cognos Connection and Access Rights of the Reports for the end users.
• Created Executive Dashboards, complex reports using Report Studio.
• Developed a prototype to demonstrate the benefits of Performance Indicator Reports that was developed in Metric Studio
• Modifying the existing report based upon the change request by the user.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Worked with Analysis Studio to develop multi-dimensional reporting.
• Coded and implemented PL/SQL packages.
• Deploying models and reports from Development to Production and administering users/groups/roles.
• Carried out Testing by developing test scenarios, test cases, test data to be used in testing based on business and user requirements, technical specifications and/or product knowledge.
• Assisted Quality Assurance Team in documenting and analyzing their current process and then make recommendations for improvements in their functional areas
• Created documentation for the complete project life cycle and Mentored the End Users and Provided the Technical Support.

Environment: Cognos 8.4.1 (Framework Manager, Query Studio, Report Studio, Analysis Studio, Metric Studio and Event Studio), Cognos Transformer, oracle10g (SQL, PL/SQL), Flat files, Toad, SQL Developer, Oracle Power Builder.

Confidential

Sr. Cognos Developer

Responsibilities:

• Involved in Gathering business requirements for various reports.
• Designing Cognos Framework manager Model for the Data Marts.
• Implementation of Framework Manager Model in Cognos 8.1.
• Implementation of Data Level, Object Level and Package Level Security in Framework Manager Model.
• Creation of Packages and publishing the same.
• Educating business users on how to make use of the Cognos Package/Namespace in Cognos Query Studio.
• Creation of Complex Reports in Report Studio.
• Made use of Value Prompt, Text Box Prompt, Date Prompt, Select and select search Prompts. Almost made use of all its properties and feature.
• Created DMR in Framework Manager Model against relational Data Source.
• Creation of Packages and publishing the same.
• Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements.
• Involved in complete Software Development project life cycle.
• Installation & Configuring the Cognos 8.4 on Windows Environment and Configured with LDAP.
• Responsible for creating User groups and roles to manage security in Cognos Connection and Access Rights of the Reports for the end users.
• Created Executive Dashboards, complex reports using Report Studio.
• Developed a prototype to demonstrate the benefits of Performance Indicator Reports that was developed in Metric Studio
• Modifying the existing report based upon the change request by the user.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Worked with Analysis Studio to develop multi dimensional reporting.
• Coded and implemented PL/SQL packages.
• Deploying models and reports from Development to Production and administering users/groups/roles.
• Carried out Testing by developing test scenarios, test cases, test data to be used in testing based on business and user requirements, technical specifications and/or product knowledge.
• Assisted Quality Assurance Team in documenting and analyzing their current process and then make recommendations for improvements in their functional areas
• Created documentation for the complete project life cycle and Mentored the End Users and Provided the Technical Support.

Environment: Cognos 8.4/8.2,Oracle 10g, Informatica 8.1

Confidential

Cognos Developer

Responsibilities:

• Developed Framework Manager Models with Physical layer and Presentation Layer
• To cater the various businesses needs (Folders, Filters, and Macros)
• Implemented Third Party Security and use those in creating Data Level security,
• Created Drill- through reports and Customized Reports with Prompts (List. Cross tab)
• Prepared User documentation to train users and functionality of each report
• Designed and implemented of Cognos IMB enterprise planning solutions
• Involved in Migrating reports from Impromptu/CRN to Cognos 8.
• Involved in building the Cubes and optimizing the cube creation.
• Importing the model from analyst to contributor, creating saved selections, access tables, e-list, user classes and user rights.
• Provide a prototype of the exact model which we actually build and get a sign off on the functionality.
• Creating a common library for the model which we are actually building.
• Published cubes and created Power play Reports for the web users.
• Played as a good mentor to the newly joining team by giving knowledge transition in both technical and functional areas.
• Performed major upgrades of unix utilities tool kits for windows 98,NT
• Responsible for overseeing the Quality procedures and Software configuration management related to the project
• Production Support which involves solving user problems.

Environment: Cognos Reportnet 1.1 MR2 (Framework Manager, Query Studio, Report Studio), Power Play Enterprise Server 7.3, Transformer 7.3, Oracle 8i