SUMMARY

• 9+ Years of IT experience in the designing, developing and testing of Data Warehouse and Business Intelligence applications.
• Over 5 years of working experience with Cognos 11.0.5/10.2.1/10.1/8. x BI Suite (Framework Manager, Cognos connection, Report Studio, Metric Studio, Analysis Studio and Query Studio).
• 4+ years of experience with design and development of Tableau Reports.
• Expertise in gathering business requirements and creating models & reports to meet the requirements. Handling complete range of BI capabilities: reporting, analysis, dashboards and business event management.
• Experience with Framework Manager Modeling (Physical Layer, Business Layer, Packages) and Complex Report building with Report Studio.
• Expertise in developing and testing Complex reports (List, Cross tab, Charts, Maps, Drill - through, Master-Detail, and Cascading) and Dashboards using Report studio.
• Extensive experience in various Tableau Desktop objects like Measures, Dimensions, Folder, Hierarchies, Extract, Filters, Table Calculation, Calculated fields, LOD, Sets, Groups, Parameters, Forecasting, Blending and Trend lines.
• Extensive Experience in various Tableau Desktop objects like measures, Dimensions, folder, hierarchies, Extract, filters, table calculation, calculated fields, Parameters, blending and trend lines.
• Experience in the Development, Implementation of Database/Data Warehousing Environment, BI Analytics and Dashboards applications using Data Profiling, Data Extraction, Data Transformation, Data Loading, Data Visualization using Tableau, Informatica, SSIS technologies.
• Expertise in the design and development ofTableauvisualization and dashboard solutions using Tableau Desktop and publishing the same on Tableau Server/ Public/ Reader and external websites.
• Experience in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie-charts, donut chart, geographic visualization (Integrated Google maps in a dashboard) and other making use of actions, other local and global filters according to the end user requirement.
• Extensive experience with SQL Development - Querying data, creating tables, creating views, stored procedures, Triggers etc.
• Extensive knowledge of Tableau Server Concepts like tabcmd, tabadmin, creating/ adding users, sites and projects.
• Proficient in developing Entity-Relationship diagrams, Star/Snow Flake Schema Designs, and Expert in modeling Transactional Databases and Data Warehouse.
• Excellent understanding of ETL process, Data modeling (Dimensional & Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases and client/server applications.
• Extensive experience in Multiple Relational Databases including SQL Server, Oracle & DB2. Experience with writing SQL queries, Oracle PL/SQL Stored Procedures, Functions, Cursors and Triggers.
• Provide best practices for day to day operations, performance analysis, tuning and capacity planning. Have clear understanding of Business Intelligence and Data Warehousing concepts with emphasis on ETL and Software Development Life Cycle (SDLC)
• Involved in training end users and providing technical support and documentation. Ability to adapt and learn new technologies and to get proficient very quickly with them.

TECHNICAL SKILLS

BI Tools: Cognos 11.0.5, Cognos10.2.1, 8.x (Report Studio, Framework Manger, Analysis Studio, Query Studio, Business Insight), Transformer 8.3, Microstrategy, Tableau

ETL Tools: Informatica 8.6, Data stage 7.5

Databases: Oracle 9i/10g/11g, SQL Server 2000, Teradata, DB2

Languages Scripting: C, C++, Java, Cobol, VB.net, VB Script, Java Script, HTML, CSS.

DB Tools: SQL *Plus, SQL *Loader, TOAD 8.3

Web Servers: IIS, Apache

PROFESSIONAL EXPERIENCE

Confidential, Alabama, AL

Tableau Developer/Cognos Developer/Administrator

Responsibilities:

• Worked closely with product owners and business analyst in estimating tableau development to satisfy business needs.
• Conducted JAD sessions, design discussions and SOS meetings to come out with the appropriate data mart.
• Experience defining enterprise data location architectures for ODS, Data mart, and Data Warehouse data.
• Involved in setting up the cluster environment in Tableau Server to process concurrent users.
• Defined security in the creation of users, groups, projects,workbooks and the appropriate permission setup for tableau server logon .
• Implemented Tableau Server security with SSL and SAML authentication.
• Created workbooks to display the capacity of the environment, user traffic which connects to the Tableau SQL Server DB.
• Integrated Tableau server with Alteryx using tableau trusted authentication.
• Created Incremental refreshes for data sources on tableau server.
• Used Alteryx for data preparation in Tableau for visualization and reporting.
• Worked on Adhoc data cleansing and standardization using Alteryx.
• Perform maintenance activities like log clean ups and archiving log files in prescribed intervals used for the business continuity during disaster.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Created line charts to display trends over a period of time and tied it with bar charts to show revenue growth based on users upgrading to additional features of the mobile app additionally adding filter to choose between business and personal users.
• Generated Interactive Dashboards with Quick filters, Parameters and Actions to handle views more efficiently
• Integrated Tableau views/workbooks/dashboards on external websites using AngularJS which enable users to change certain fields as required
• Used commands in Tamed and Tabadmin utility tool for Tableau Server
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle and MS Excel.
• Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation.
• Experience on Load performance tuning and report performance
• Created reports using Custom SQL for complex report views.
• Created test cases for carrying out unit testing and part of functional testing.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.

Environment: Cognos 11.0.5 (Framework Manager, Report Studio, Query Studio), Oracle SQL Developer, LOANIQAlteryx 11.0 & 11.3,Tableau 2019.3

Confidential

Sr. Tableau Developer/Cognos Developer

Responsibilities:

• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Creating New Schedule's and checking the task's daily on the server.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's.
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Defined best practices for Tableau report development andeffectively used data blending feature in tableau.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.
• Connect to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.
• Creating users, groups, projects, Data connections, settings as a tableau administrator.
• Involved in creating dashboards and reports in Tableau and Maintaining server activities, user activity, and customized views on Server Analysis.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Good SQL reporting skills with the ability to create SQL views and write SQL queries highly recommended.

Environment: Tableau Desktop/Server, SQL Server 2008, Oracle 11g, SQL,Microsoft office Suite ( Word, Excel, PowerPoint)

Confidential, Montgomery AL

Cognos Administrator/Developer

Responsibilities:

• Installed Cognos 10.2 on a multi-server environment (Dev/QA/Prod).
• Implemented complex row level security in FM and implemented Cognos security folders, users and groups.
• Created maintenance tasks on content store and run them on demand at scheduled time or based on trigger.
• Worked on performance tuning of servers by increasing the logging levels to run the reports faster.
• Implemented Framework manager security for Data access, Object level access and Package access based on the Organization Level.
• Define the security structure for the complete user community, by adding roles and groups to the Cognos Connection directory and mapping all the users to one or more of these roles/groups.
• Enhanced framework manager models out of FSLDM (Financial Services Logical Data Modeling)
• Developed complex active reports and dashboards using HTML applications for different business subjects such as Enterprise, Marketing, Claims and P&C as per requirements.
• Upgraded 30 legacy reports with the new ALFA reporting standards and prepared test cases for the same.
• Worked on improving the performance of dashboards and tuned the stored procedures accordingly.
• Created reports with the bursting functionality for different departments of insurance.
• Developed balanced queries to verify report output against database queries and also to see the data variance between the source environments (Guidewire) and target EDW.
• Engaged with testing activities within ALM during SIT and UAT phase.
• Created Technical design documents and transferred technical knowledge specific to Cognos tools and existing data model to other team members.
• Assisted QA team in documenting and analyzing their current process and then make recommendations for improvement in their functional areas.
• Guided offshore team to develop and test reports.

Environment: Cognos 10.2.2 (Framework Manager, Report Studio, Query Studio), Teradata, TOAD

Confidential, Salem NH

Sr Tableau/Cognos Developer

Responsibilities:

• Participated in requirement sessions with project managers and assisted the user community with capturing and articulating their reporting needs.
• Involved in ETL Mapping Team discussions to solve the issues in mapping document or design. Worked as a part of sprint team in agile methodology. Utilized various agile methodology tools such as MKS and JIRA.
• Designed model based on the requirements for Risk functional and Loss Dashboard Reports by analyzing the underlying data. Created models using star schemas, packages using framework manager. Designed and developed reports using the capmat specifications.
• Developed various crosstab, list and chart reports using report studio 10.2.1 for commerce solutions line of business.
• Designed and developed mock-up Tableau Dashboards to explore options for visualization of data, presentation, and analysis.
• Created line charts to display trends over a period of time and tied it with bar charts to show revenue growth based on users upgrading to additional features of the mobile app additionally adding filter to choose between business and personal users.
• Generated Interactive Dashboards with Quick filters, Parameters and Actions to handle views more efficiently. Developed various dashboards, used Context filters, sets while dealing with huge volume of data.
• Created sophisticated dashboard reports for various reporting requirements like using legacy charts for the loss dashboard reports and also created multi page reports by using Cascading prompts, conditional formatting and page rendering.
• Conducted page quality reviews and validation of the quantitative and qualitative content on the report pages prior to them distributed.
• Worked within ALM for all testing activities and produced status updates. Tested and validated the report output against the database to measure the performance of the reports. Involved in writing SQL queries using TOAD.
• Deployed packages, folders and content store from a development environment to test and then to production environments. Involved in writing test cases for user acceptance testing.
• Worked on the BI anatomy tool for generating the flow diagrams and logic implemented in each report for documentation purposes. Scheduled reports to run on monthly basis using control-m.

Environment: Cognos 10.2.1 (Framework Manager, Report Studio), Oracle 11g, Teradata, Tableau (desktop/server) 9.x/8.x TOAD, PL/SQL, Netezza.

Confidential, Orlando, FL

Sr Tableau/Cognos Developer

Responsibilities:

• Gathered and analyzed business requirements from the users and transformed them into business intelligence reporting specifications.
• Interacted with ETL team to gather the requirements for the reporting.
• Designed DMR models in Framework Manager.
• Created and published packages for different functional areas and assigned security rules to them in Framework Manager.
• Generated List, Crosstab, Drill through &Master Detail reports for HR Department in Report Studio.
• Standardized prompt pages for consistent user experience and to let users choose between different filters.
• Extensively used Prompts, Filters, Cascading Prompts, Calculations, Conditional Variables, and Multiple Queries for data extraction in reports.
• Involved in bursting and scheduling the reports to various Labor Relations managers using Cognos connection.
• Defined best practices for Tableau report development and effectively used data blending feature in tableau.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.
• Connect to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.
• Creating users, groups, projects, Data connections, settings as a tableau administrator.
• Involved in creating dashboards and reports in Tableau and Maintaining server activities, user activity, and customized views on Server Analysis.
• Created dashboards for Employee Relations and Operations (Internal Labor Market). E.g. the core cases received by case type for the various Fiscal Years were compared and also highlighted where there are increasing issues.
• Created complex reports that had Multiple Pages, Multiple UI items like Lists, Charts & Charts etc.
• Trained users in business Insight & Business Insight advanced for Ad-hoc reporting.
• Worked on JavaScript for format customization of Dashboard i.e. created toggle and collapse buttons.
• Involved in writing Queries in SQL Server.
• Performed data validations, unit testing and preparation of unit test cases.
• Involved with making changes in the reports generated as business requirements changed and carried out validation and verification of the reports.
• Created models in Transformer built cubes and published cubes to Analysis Studio.
• Worked extensively to achieve the Performance and Tuned SQL Queries and Stored Procedures, improved the performance of the reports.
• Involved with the Solutions Architect and the QA team for validation and verification of the development.

Environment: Cognos 10.2.1 (Framework Manager, Report Studio, Query Studio), DB2, Oracle 11g, SQL Server 2008, TOAD, PL/SQL, SQL Navigator, Tableau (desktop/server) 9.x/8.x, Visual Source Code, Informatica v9.0, Java Script.

Confidential, Washington, DC

Sr. Cognos Developer

Responsibilities:

• Understood the source system and interacted with users to acquire the elaborate technical and business requirements and required documentation for clear understanding and traceability of requirements.
• Installation and configuration of the Cognos 10 in Development environment. Experience in building models using Framework Manager & creating simple to complex reports in Report Studio. Created database layer and business layer, defining appropriate relationship between query subjects in Framework Manager.
• Created Star schema dimensional model. Created Dashboard reports using the Cognos Report Studio.
• Knowledge in developing Active reports. Developed ad-hoc reports using Query Studio. Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, multi-query, Cubes in Report Studio, Burst Reports against database.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups. Deployed Cognos OLAP Cube from Testing Environment to Production Environment using Batch script.
• Involved in writing Stored Procedures and imported into Framework Manager to create complex reports. Trained end users effectively to use reporting tool, to build and customize their ad-hoc reports. Implemented Cognos SDK code for extracting the report schedules defined by power users.
• Worked on Java Script to perform Prompt page validations. Created the reports with data level security.
• Performance tuning of the reports implemented by creating summarized tables, views and appropriate indices. Involved in creating the User Training manual to help the Business Users understand the reporting architecture.
• Documented the Lessons Learnt and Best Practices. Conducted training on Cognos technology to the Business users. Mentored the Project Team on latest trends in Reporting.
• Deployed the Cognos content from Development environment to UAT/Production environments.

Environment: Cognos 10.2.1 (Framework Manager, Transformer, Report Studio, Query Studio), DB2, Oracle 11g, Cognos SDK, WAS, SQL Server 2008, TOAD, PL/SQL, Java Script, Data Stage, Linux.

Confidential, Weston,MA

Cognos Administrator

Responsibilities:

• Installed and configured Cognos 10 BI Application with complete suite of tools on distributed environment over windows operating system. Installed and configured IIS Web server.
• Configured the LDAP Namespace for the novel Directory server to be used for third party authentication tool. Created maintenance tasks and run them on demand at scheduled time or based on trigger.
• Worked on performance tuning of servers by increasing the logging levels to run the reports faster and Evaluated the system performance by creating a score card. Secured Cognos Connection security by assigning users to the groups and roles defined in Cognos Namespace.
• Deployed framework models and reports from Dev to test and then to production environments. Enhanced the Powerplay, Framework Models and Reports to meet the changing business requirements.
• Created models (. cpf) in Framework Manager Modeling tool and publish packages in Cognos Connection. Created a Framework Manager Model with calculated columns, filters and Macros from different data source and created packages to suit the reporting needs of the client.
• Develop new reports on timely bases, by extracting new data from database by running the DTS packages and rebuilding the OLAP cubes. Created Powerplay cubes using multiple data sources, which are retrieved by Cognos Packages and Reports.
• Created Complex Multi-Object Reports using Lists, Charts, Crosstabs and Images using Report Studio and Ad-hoc reports in Query Studio. Applied Security and User Authentication to the various User Groups.

Environment: Cognos 8.2 BI Series (Report Studio, Query Studio, Analysis Studio, Metric Studio), Framework Manager v8.2, Series7.3 (Transformer, PPES and all Server Administration), Python, Informatica Power Center v7.1, Toad v7.6, Java, JSP, Oracle 9i, DB2, Win2K, UNIX (AIX)

Confidential

Cognos Developer

Responsibilities:

• Interviewed business community to identify business, data, and delivery requirements.
• Designed models in Framework Manager.
• Worked with Complex reports in Report Studio using master-detail relationship, drill through, burst options, cascading options and Prompts depending on user requirements.
• Created reports using cascaded prompts, value prompts, sections, dynamic filtering, conditional layouts and multi lingual reports in Report Studio
• Created reports containing multiple data containers like List, Cross-tab and Repeater tables
• Created dashboards for a managerial overview with drill up and drill down capabilities.
• Created models in Transformer, built cubes and published cubes to Power Play server.
• Scheduled reports using Cognos scheduler and emailed to various recipients as required.
• Worked on TOAD for Oracle database systems for creation of Adhoc queries and for improving various performance issues.
• Experience with oracle as the target for the data marts.
• Used Data Source Query Subjects, Model Query Subjects and Stored Procedure Query Subjects in Framework manager.

Environment: Cognos 8, Transformer 8, Report Studio, Query Studio, Metric Studio, Oracle 10g, Erwin 4.0, TOAD, PL/SQL, Data stage, UNIX, Cognos 8 SDK.