EXPERIENCE SUMMARY

• 12+ years of experience as a Software Engineer/ Consultant in the development of Data Warehousing and Reporting Solutions.
• Extensive experience in working with Tableau 10.x, Tableau 9.x,8.x, Alteryx 10.5(ETL tool), Cognos 10.X, Cognos 8.x BI Suite, Datastage 11.0, Business Objects BOXI
• Have excellent understanding of Relational Database concepts and possess strong knowledge in writing SQL and PL/SQL queries in SAP HANA, Hadoop Hive,Spark SQL,Greenplum, Teradata, SQL Server 2014, Azure, Oracle 11i and Db2
• Worked as a Tableau Developer as well as Tableau Administrator managing Projects, Users, Groups, Extracts, and Workbooks. Have provided End - to-End solutions on Tableau from Installation till deployment of Dashboards to users on Tableau Servers.
• Worked on the designing the models (Analytic view and Calculation view) in SAP HANA.
• Worked on Alteryx 10.5 and created workflows to fetch data from different data sources, cleanse, transform and analyze the data.
• As a team lead involved in creating the Project Plans, requirement document, provide estimation for the project.

TECHNICAL SKILLS

Operating System: Windows 7 vista/XP/2000/NT/9x

RDBMS: SAP HANA, Hadoop Hive, Spark SQL,Greenplum, DB2, Oracle 10g, Teradata, SQL Server 2014

BI Tools: Tableau 10.x, Tableau 9.x(Desktop and Server), 8.x, Cognos 10.2 (FM, Report Studio, Query Studio, Analysis studio, Metric studio, Cognos Workspace, Workspace Advanced), Cognos 8.x BI Suite, Business Objects BOXI, Datastage 11.0, Alteryx 10.5

Languages: SQL, PL/SQL, MDX and core Java

Web Technologies: HTML, XML

Tools: Toad, pgadmin, Teradata SQL Assistant, QMF Workstation, PL/SQL Developer, SQL*plus, WINSQL, MS-VISIO, Share Point

PROFESSIONAL EXPERIENCE

Confidential, Bentonville, AR

Senior Tableau Developer

Tableau Developer /Alteryx Developer (Alteryx- ETL Tool),

Software Used: Alteryx 10.5, Tableau 10.3,Hadoop Hive,Spark.

Responsibilities:

• Gather requirements from Market leads for each market across the globe and design Alteryx (ETL Tool) Workflows with respect to the requirement and generated the source for Tableau Dashboard
• Have developed 30+ Alteryx Workflows and developed 10+ Tableau workbooks and more than 40+ views across different Confidential financial markets of Confidential .
• Worked on Agile Methodology with Sprints, releases and providing daily updates to scrum Masters.
• Created Interactive dashboards combining multiple views pointing to different data source tables ( Hadoop Hive, Spark SQL) through Data Blending as well as through cross data base Joins. Also created story boards on dashboards to describe the outcome of the view.
• Also created out of the box views like Donut view,upward and downward trend arrow view,Sankey diagram, implemented bernford’s law etc.
• Created Interactive views with Quick Filters, Parameters, and Action filters
• Created complex views using Table Functions, Dual axis charts, combination charts, applying various types of actions (filter, highlight, url).
• Have created Level of Detail Expressions to aggregate data specific to a particular dimension
• Created geographic dashboards and used actions to display the drill through reports specific to the location selected on the map.
• Created various types of filters, Context filter to improve performance, cascading quick filters.
• Used parameters to filter across multiple data sources, to toggle between views etc.
• Imposed security at Dashboard level as well as implemented row level security in views and performance tuning of Dashboards.
• Have worked on providing the end to end solution starting from preparation of the Source data, cleansing, transforming the data using Alteryx and output is used as a source from Alteryx to design the Tableau Dashboards showing different perspective of the anomalies in Confidential Financial Markets.
• Created interactive Alteryx workflow using Action tool. Involved in automating the process by scheduling the Alteryx workflows to create an extract file in Tableau server and make the data to get automatically refreshed by pointing to the generated extract file from Alteryx Workflows.
• Involved in creating tables in Hadoop system and writing Hive Queries. Connected Alteryx to Hive and pulled data for transforming and for data analytics

Confidential

Alteryx Developer, Senior Tableau Developer, SQL Server developer

Software Used: Alteryx 10.5, Tableau 9.0, Greenplum, SQL Server 2014

Responsibilities:

• As a Team lead involved in gathering the requirements with Business as well as provide suggestions for analyzing the data and visualizing the same.
• Involved in creating the Tables in Greenplum and loading the data through Alteryx for Confidential Audit Tracker.
• Created iterative macro in Alteryx to send Json request and download Json response from webservice and analyze the response data.
• Created Alteryx workflow to download xml response from webservice and parse the xml files for data preparation and analysis.
• Migration of all tax related tables and data from Greenplum to SQL Server 2014 through Alteryx.
• Creation of Alteryx workflow for loading flat files to SQL server Database and scheduling the workflow in Alteryx Server.
• Created interactive Alteryx workflow using Action tool for Giftcard & Donation Tracking related projects.
• Created procedures in SQL server for PBT Application and coordinated with webservice and Angular JS Team for developing the screens.
• Created dashboards for Head office as well as individual tax type departments in Tableau for Confidential Tax Audit Tracker.
• Published Alteryx workflow in Alteryx Gallery as well as scheduled the flow in Alteryx Server.

Confidential

Senior Tableau Developer, SAP HANA DB

Software Used: Tableau 8.3, Tableau 9.0, Greenplum, SAP HANA

Responsibilities:

• Worked closely with business users and gathered requirements from them, created technical specifications, estimation documents.
• Created Tableau dashboards on Big data Analytics platform of Greenplum and SAP HANA broadly for two major business one providing the sourcing analytics for Pharmacy Domain and the other for General Merchandise.
• Also, worked on the end-to-end reporting by creating the HANA Models and HANA Procedures which were used as source for creating Tableau Dashboards as well as for creating Dashboards on D3.
• Created Interactive dashboards combining multiple views pointing to different tables through Data Blending. Also, created story boards on dashboards.
• Created complex views using Table Functions, Dual axis charts, combination charts, applying various types of actions (filter, highlight, url).
• Created geographic dashboards and used actions to display the drill through reports specific to the location selected on the map.
• Created various types of filters, Context filter to improve performance, cascading quick filters.
• Used parameters to filter across multiple data sources.
• Imposed security at Dashboard level as well as implemented row level security in views.
• Worked on migrating the Tableau Dashboards pointing from Greenplum to SAP HANA Datasource.
• Created Models in SAP HANA for consuming those models for Tableau Reporting. Provided SQL queries, procedures in SAP HANA to Webservice team for developing some dashboards on D3.

Confidential,Plainsboro, NJ

Senior Tableau Developer & Administrator

Software Used: Tableau 8.1, Oracle 11i, Excel

Responsibilities:

• Worked closely with business users and gathered requirements from them, created technical specifications, estimation documents.
• Created Data sources, Extracts, published data sources to tableau server, refreshed extract in Tableau server
• Created different Interactive views with Quick Filters, Parameters, and Action filters to dynamically visualize and analyze the data.
• Used different Mark properties in views to provide better insights into large data sets.
• Created Interactive reporting dashboards by combining multiple views and published to Tableau Servers
• Reshaping of data in Excel for use in tableau and creating dashboards using the same.
• Performance tuning of Dashboards.
• Embedding tableau views into PowerPoint for presenting them to Senior Management.

Confidential

Senior Tableau Developer & Administrator

Software Used: Tableau 8.1 & Tableau 8 (Server, Desktop), Oracle 11i

Responsibilities:

• Involved in Installation and configuration of Tableau Software. Have also configured distributed installation of Worker Servers for production environment.
• Created Users, groups and Domains from Active directory and created different License level for each User on Tableau Servers.
• Worked closely with business users and gathered requirements from them, created technical specifications, estimation documents.
• Created Data sources, Extracts, published data sources to tableau server, refreshed extract in Tableau server
• Created different Interactive views with Quick Filters, Parameters, and Action filters to dynamically visualize and analyze the data.
• Used different Mark properties in views to provide better insights into large data sets.
• Created Interactive reporting dashboards by combining multiple views and published to Tableau Servers
• Created complex views using Table Functions, Dual axis charts, combination charts.
• Created various types of filters, Context filter to improve performance, cascading quick filters.
• Imposed security at Dashboard level as well as implemented row level security in views.
• Used Data Blending, groups, calculated fields, and aggregated fields and Highlighting data to compare and analyze data in different perspectives.
• Created custom hierarchies and bins for use in Dashboards.
• Used dimension on Page shelf for a detailed analysis of the view by members of the dimension.
• Created sets to display top products based on their sale.
• Embedded Tableau Dashboards into web pages.
• Involved in creation of groups and users in Tableau server using Active Directory settings.
• Created different Projects on Servers. Have migrated Workbooks and Dashboards from one environment to another.
• Used Tabadmin utility tool to cleanup log files and take backup of the server on a regular basis and restore them in case of any system failures.

Confidential

Tableau Developer

Software Used: Tableau 8, Tableau 7 Desktop, Tableau server, Oracle 11i

Responsibilities:

• Gather and analyze the business requirements and then translate them to technical specifications.
• Created different views in workbook to visually analyze data.
• Created extracts, published datasources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Created External filter, internal filter and Context filter to improve performance.
• Used Data Blending, groups, combine fields, calculated fields, and aggregatedfields and spotlightingto compare and analyze data in different perspectives.
• Used dimension on Page shelf for a detailed analysis of the view by members of the dimension.
• Created parameters and quick filters. Created sets to display top products based on their sale.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Created Dashboards with interactive views, trends and drill downs.
• Published Workbooks and Dashboards to the Tableau server.
• Created groups and users in Tableau server
• Used TABCMD and TABadmin utility tool.
• Migrated Workbooks and Dashboards from Tableau 7 to Tableau 8
• Implemented new features in Tableau 8 to the existing Workbooks and Dashboards.

Confidential

Senior Cognos Developer

Software Used: Cognos BI 10.2, Cognos 8.4, Framework Manager, Report Studio, Query Studio, Metric studio, WinSQL, Windows XP Professional, Lotus Notes, CA Service Desk, IBM DB2

Responsibilities:

• Worked closely with business users to understand project requirements.
• Involved in upgradation of Reports from Cognos 8.4 to Cognos 10.2.
• Involved in creating complex Reports as well as performance tuning of Reports.
• Created custom Dashboard pages using Cognos Portlets and provided users with several Trend Analysis Graphs to help them make balanced decisions and linked these as Drill through from the Dashboards. This gave users a complete picture of how they are doing against the projected performance.
• Handling Production issues and fixing Reports/Dashboards/package/data issues. Handling priority tickets in case of Cognos production environment failures.
• Worked on Data Analysis, Validation of reports and find data quality issues.
• Handling Deployment of Cognos reports from one environment to the other using the Deployment feature of Cognos.
• Involved in preparing the estimation documents, design document for new reports that are to be developed and involved in preparing the impact analysis document for a change that is imminent.
• Involved in making changes to the existing Framework Manager model accordingly in case of any new reporting requirements.
• Creating and setting privileges on Users/User Groups.
• Developed Dashboards, Complex Reports having many calculations, complex layouts, HTML items etc. inReport Studio.
• Involved in setting up security in Framework Manager. Implemented package level, object level and data level security in Framework Manager Model.
• Prepared User documentation to train users on functionality of each report.
• Have undertaken responsibilities such as identifying areas of improvement and making necessary changes to alleviate the problem, suggesting various solutions with respect to implementation approach and performance issues.
• Ensuring that team members are adhering to SLA’s in Incident Management for Priority tickets raised in CA Service Desk.

Cognos Developer

Software Used: Cognos 8.4, Cognos 7 series (PowerPlay Transformer, Impromptu), Access Manager, Transformer, Unix, SQL, Oracle 10g, Toad, Windows XP Professional, HP Service Manager, Datastage 8.1

Responsibilities:

• Interacting with the clients to gather requirements.
• Involved in upgrading Cognos 8.3 BI reports to Cognos 8.4 BI series using Upgrade Manager
• Worked on the Framework Manager to solve ambiguous relationships in metadata models, and published packages.
• Responsible for improving report response time by creating appropriate joins between Query Subjects.
• Simplified many complex queries and involved in performance tuning of Reports, debugging issues in cubes in case of cube build errors.
• Created manual levels and developed appropriate Models and cubes in Transformer
• Developed list, chart, burst, master-detail, drill through, repeating, and multi-page reports in Report Studio
• Created complex reports that involve query prompts, layout calculations, conditions, and filters inReport Studio
• Created cross tab reports to summarize and compare complex data in Report Studio
• Improved the performance and usability of the reports by creating appropriate prompts and filters
• Developed Multi page reportswith prompt pages and conditional variables per the end user requirements
• Deployed Reports and Models from one Environment to Another
• Customized Cognos Connection Portal to personalize the homepage
• Managed scheduling of reports, maintenance of public and individual folders, distribution lists, users, groups and roles using Cognos Connection
• Production Support and prepared documentation of each report created.
• Used DataStage as an ETL tool to extract data from sources systems, loaded the data into the ORACLE   database.
• Created Datastage jobs using different stages like Transformer, Aggregator, Sort, Join, Merge, Lookup, Data Set, Funnel, Remove Duplicates, Copy, Modify, Filter, Change Data Capture, Change Apply, Sample, Surrogate Key, Column Generator, Row Generator, Etc.
• Extensively worked with Join, Look up (Normal and Sparse) and Merge stages.
• Extensively worked with sequential file, dataset, file set and look up file set stages.
• Extensively used Parallel Stages like Row Generator, Column Generator, Head, and Peek for development and de-bugging purposes.
• Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions on ad hoc or scheduled basis.
• Creation of jobs sequences
• Maintained Data Warehouse by loading dimensions and facts as part of project. Also, worked for multiple enhancements in FACT tables.

Confidential

Cognos Developer

Software Used: Cognos 8.2,8.3 Bi, Cognos 7 series (PowerPlay Transformer), Access Manager, Transformer, Unix, Teradata, Toad, Windows XP Professional

Responsibilities:

• Worked closely with business analyst and mangers to understand project requirements
• Attended the meetings and involved to reach the project deadlines.
• Involved in preparing the design document for Power Play cubes, Cognos Reports, Coding standards document, Naming conventions document, Defect logs, Review Logs
• Involved in creation of Model and Packages in Framework Manager.
• Migrated Reports from Cognos Impromptu to Cognos 8.2 and later to Cognos 8.3.
• Developed data specific reports with various filter conditions to retrieve specific data.
• Created master-detail relationship reports based on a time and trend over time reports using Report Studio.
• Developed Several Reports includingburst reports.
• Involved in building Multidimensional Cubes, Sub cubes for user groups using PowerPlay Transformer
• Created Time based partition Cubes, cubes with incremental updates using Cognos Transformer.
• Created reports in Analysis Studio using cubes and DMR models.
• Created the shell scripts for scheduling the cube build process.
• Involved in code review and testing of cubes as well as reports.
• Maintaining review logs and defect tracking documents.
• Involved in Quality Management and Defect Prevention activities.
• Created and performed the Unit and Integrity test cases and assisted the testing team in System Test and Production move process

Confidential 

Cognos Developer

Software Used: Cognos 8.2 Bi, Cognos 7 series (PowerPlayTransformer, Impromptu), Access Manager, Transformer, Unix, Oracle 10g, Toad, Windows XP Professional

Responsibilities:

• Created business model based on requirements.
• Involved in creation of Model and Packages in Framework Manager
• Migrated Reports from Impromptu to Cognos 8.2. Consolidation of 200 Catalogs into one single model in Framework Manager was a challenging task and was implemented successfully.
• Created model in Framework Manager for all Reports, maintaining the model, enhancing the model for new requirements without any discrepancies to the reports developed.
• Developed list, chart, burst, master-detail, drill through, repeating, and multi page reports inReport Studio
• Created complex reports that involve query prompts, layout calculations, conditions, and filters in Report Studio
• Created cross tab reports to summarize and compare complex data in Report Studio
• Improved the performance and usability of the reports by creating appropriate prompts and filters
• Developed Multi page reports with prompt pages and conditional variables per the end user requirements.
• Creation of Drill through Reports for Drill through from Cube to Report as well as from Report to Report.
• Development of Cubes in Cognos Transformer and building the cubes in Unix.
• Involved in validating and testing the reports.
• Deployed Reports and Models from one Environment to Another

Confidential

Cognos Developer

Software Used: Cognos 8.2 Bi, Cognos 7 series (PowerPlayTransformer, Impromptu), Access Manager, Transformer, Unix, SQL, Oracle 9i, Windows XP Professional

Responsibilities:

• Gathered the needs and requirements from business end-users, management and other users for setting up environment to start.
• Developed models and published packages using Framework Manager
• Designed star/snow flake schemas and dimensional models using Framework manager
• Worked on the Framework Manager to solve ambiguous relationships in metadata models, and published packages
• Created different layers to hide the data complexity for end users in FWM
• Responsible for improving report response time by creating appropriate joins between Query Subjects
• Importing data sources using ODBC
• Involved in unit testing, preparation of test cases, Validating and testing the reports.