SUMMARY:

• Certified Senior BI professional with 11 years of experience involving complete development life cycle of Business understanding, requirement gathering, analyzing, designing, developing and delivering business intelligence solutions using a wide range of BI offerings, tools, methodologies, to convert large datasets into actionable insights.
• Good working experience in Data Visualization and complex report building using Tableauv10 and Tableau v2018.1
• Administration and support & maintenance on multiple tools like Tableau, Cognos, MicroStrategy
• Proficient in RDBMS and good programming experience in oracle10.x/SQLServer2008 and DB2
• Involved on complete lifecycle process to implement and follow the process with timelines.
• Knowledge on Power BI.
• Good experience in Data warehouse/ Data Integration using ETL tools.
• Have good understanding of Tableau architecture, design, development and end user experience.
• Knowledge on Java, HTML Scripting
• Ability to work in an Agile environment and drive projects forward independently
• Significant experience in data analytics & reporting
• Ability to profile large datasets for analysis or testing efforts, with multiple/multi - type table joins, multiple keys, and nested queries
• Ability to use advanced Excel functions such as pivot tables, lookups, and macros
• Ability to manage multiple deliverables simultaneously
• Knowledge on Power BI tool
• Good Experience with software development life cycle (Agile/Waterfall)
• Build strong customer relationships and deliver customer-centric solutions
• Published workbooks to Tableau Server and Scheduled full refresh and Incremental Refresh
• Handled change requests and provided support/maintenance for deployed projects

SKILL:

BI Tools: Tableau, Power BI, Cognos and Microstrategy

Databases: Oracle10g/9i, SQL Server 2005, 2008, Teradata, IBM DB2

Data Modeling: Star and Snowflake Schemas Modeling, Facts & Dimensions.

ETL Tools: Knowledge of Informatica 9, Alteryx, Python

Operating Systems: Windows and UNIX Server (Red hot, AIX) Python

EMPLOYMENT HISTORY:

Confidential, Boston, MA

Sr.Tableau Developer

Responsibilities:

• Working closely with the business users to gather requirements
• Created complex reports utilizing the features like hierarchy, New Calculated Columns, Drill functionality, Tables, graphs, line Charts and Bar Charts.
• Used Stored procedures and Custom SQL in Tableau as data source.
• Created Parameters to achieve desired functionality.
• Implemented Data Blending concepts in my Tableau Reports.
• Worked on Dual Axis concept while working with reports.
• Created Filters, Groups, Sets, Parameters on Tableau Reports.
• Created and modified some of the existing reports and dashboards.
• Publishing sheets and dashboards on server Using Tableau Desktop.
• Strong Knowledge on Alteryx tool to do transform the data
• Created conditional filters and Action links to filter the data on dashboard.
• Created Interactive Dashboards with multiple drill down reports
• Monitor the schedules and tasks on regular basis and create schedule job based on the user request
• Worked on the incident tickets raised by the user based on their requirement
• Applied row level security to the dashboard based on user specific groups
• Involved in trouble shooting of performance issues which was associated with Tableau reports and comparing with SSRS performance
• Used Jira Ticketing tool to resolve user tickets.
• Designing the Reports as per client Requirement and created the reports using database.
• Utilized Tableau server to publish and share the reports with the business users. Also, involved in administration tasks such as providing access to the users and adding them to the specific group.

Environment: s: Tableau Desktop, Tableau Server, Oracle, SQL server, excel.

Confidential, MA

Lead Tableau Developer / Administrator

Responsibilities:

• Worked on Complex Dashboard with multiple level of view the Sensidata by implementing Actions based on the providers and Sensi logic information
• Extensively worked on Dashboard reports in Tableau 10x analytics to get the interactivity of the member and enrollment information based on the year wise trend analysis
• Created all possible options in the dashboard reports to show the summary level of information about HMO & PPO based on domain with measure performance
• Creation of Dash Board Reports using groups, sets, hierarchy and by using Actions with summarized information about member’s enrollment
• Worked on score card dashboard to analyze CMS star rating for risk based on the product (HMO & PPO)
• Implemented the joins, unions and custom sql to import the data from multiple data sources to build the dashboard
• Worked on POC by using Alteryx for calculations and tranformations
• Working on High level & Low level design Documentation.
• Worked on Active Analysis dashboard for multiple level of data view with data blending
• Worked on dashboard reports on Tableau for Member Gap Analysis by using Actions and context filters, calculations, top n analysis with filters and conditions, then place them in the dashboard with more interactivity

Environment: s: Tableau Desktop, Tableau Server, Oracle, SQL server, excel.

Confidential, IL

Sr. Tableau Developer / Administrator

Responsibilities:

• Responsible for interaction with business stake holders, gathering requirements and managing the delivery, covering the entire Tableau development life cycle.
• Ability to define problems, collect data, establish facts, draw conclusions
• Designing, developing, testing, and maintaining Tableau reports and dashboards based on user requirements.
• Utilizing capabilities of Tableau such as Data extracts, Data blending, Forecasting, Dashboard actions and Table calculations
• Designing dashboard templates as per the requirement & dashboards content which includes complex tabular reports, bar charts, water fall charts, score cards, Gantt charts, Bubble charts.
• Created Filters, Groups, Sets on Tableau Reports.
• Implemented data blending advanced visualizations in Tableau.
• Worked on Dual Axes, Individual Axes, and Blended Axes concepts while working with reports.
• Generated Dashboard with Quick Filters, Parameters and Sets.
• Generated Tableau dashboards with combination charts for clear understanding.
• Created the Test Evaluation and Summary Reports.
• Performed unit testing.

Environment: s: Tableau Desktop, Tableau Server, Oracle, SQL server, excel.

Confidential

Cognos Developer

Responsibilities:

• Analyzed business requirements with the business users and train them in the new technology.
• Implemented Custom views with the user specific and cube specific
• Involved in analysis of functional business applications and design specifications.
• Created drill through and Master detail relationship reports as per the client requirements.
• Created Bookmarks and Table of contents in the report to drill through in the single report.
• Developed reports in Report Studio using dimensional and relational models.
• Developed interactive customized maps for Regions, district and Territories in report studio.
• Developed models in Framework Manager and Power Play Transformer
• Provided to power users in Analysis Studio and Report Studio.
• Instrumental in Coding, testing, debugging, maintaining and refining the computer software to deliver the solution.
• Prepared required documentation, including program-level and user-level documentation.

Environment: s: Cognos 8.4 (Report studio, Query Studio, PowerPlay Studio, Analysis Studio) Cognos Impromptu, SQL Server 2005.

Confidential

Cognos Administrator

Responsibilities:

• Monitored Daily jobs in the Production Catalog in the Data manager and informed the cube loads status to the Client.
• Designed multiple reports in the report studio using various templates like list reports, cross-tab reports and charts.
• Worked on filters, parameter based reports to show the rendering functionality
• Designed and Developed Framework Manager Models to be deployed as packages.
• Worked on complex reports such as dashboards, scorecards and reports with multiple drill through and Master Detail.
• Used Cognos Connection for organizing, security, scheduling and distributing reports.
• Created join conditions to the Fact table and the Dimensions table in Framework manager and published the Packages.
• Validated the Cognos Reports Data with the Oracle database.
• Enhanced the Cognos report in the Production portals according to the client’s requirement.
• Prepared the end user template for understanding the report functionality for the Business owners.

Environment: s: Cognos 8 (Cognos Connection, Framework Manager, Query Studio, Report Studio, Analysis Studio), Informatica, Oracle 9i, SQL, Windows XP.

Confidential

Administration

Responsibilities:

• Resolve the day to day incidents & Requests which have been raised by the business users.
• Worked extensively on enhancements of production reports.
• Providing the Access to the Business Users for the User groups in Access manager.
• Restarts the IServers on demand and Schedule
• Worked on Incident and request tickets on daily basis
• Involved on Schedule server maintenance all environments
• Installed patch and fix pack issues
• Monitor the servers and check the scheduled jobs
• Involved in migrating code from lower environment to higher environment through Object Manger
• Created the Users in Cognos Connections and given permissions to the reports.
• Created user groups in Cognos Connection from Access manager groups.
• Involved on Migration of reports, Packages SIT to UAT and UAT to Production environment.
• Involved on server restarts scheduled and on demand basis.
• Involved in setting up the Audit Data base in the Cognos configuration
• Involved in Migrated of Cognos 8.4 environment to IBM Cognos 10 environment.
• Involved in security settings, schedule management, data source creation and deployment.
• Performed Deployment of Cognos Content from DEV to PROD, Job Scheduling, Folder Security, and Framework Object Level Security.
• Involved in installation and configuration of the development environment
• Design and develop meta-data models by Importing Metadata from Multiple Sources.
• Created the Framework Manager model and publish the package to the Cognos connection
• Involved in preparing the Reports development estimations and deliverable plans.
• Involved in preparing Data validation sheets/Test Cases for the developed reports.

Environment: s: Cognos 10.2 (Query Studio, Report Studio, Analysis Studio, Active Reports, Work Space Advance, Cognos Connection, Framework manager), PowerPlay Transformer, Teradata SQL Server 2008, Windows 7 Professional.

Confidential

Cognos Developer

Responsibilities:

• Designed the Technical Design documents by understanding the Functional Design documents.
• Worked on the functionalities with Rendered variables, Conditional block, conditional styles
• Created reports by using experience with HTML, CSS, and JavaScript
• Involved in Unit testing the reports and designing the Unit Test cases template.
• Designed & developed multiple reports in Report studio using various templates like List reports, cross-tab reports and charts in the reports with Cognos Report Net.
• Enhanced Production reports based on the Change Requests.
• Worked on Java script in the reports to get the desired functionality.

Environment: s: Cognos 8 (Cognos Connection, Framework Manager, Query Studio, Report Studio, Analysis Studio), Oracle 9i, JavaScript, Windows XP.