SUMMARY:

• Over 8 years of experience with Information Technology especially working with Data Visualization, Analytics, Data Management, Data Integration, Implementation and Maintenance of Business Intelligence, and the related Database Platforms.
• Extensive experience in Analysis, Development, Administration, Implementation, Testing, Support and Project Management of Business intelligence, Data Warehouse and Database solutions.
• Professional experience in Tableau Business Intelligence Suite including Tableau Desktop 10.0,10.1,9.X, Tableau Server 10.0,10.1,9.2 and Tableau Online 9.2. Business Intelligence Professional with in - depth knowledge and understanding of Tableau platform, architecture and implementation.
• In-depth knowledge in formal Project development methodologies, Systems analysis design, implementation of Operational/Database systems, utilizing Oracle RDBMS Methodologies.
• Experience involving in Lead roles whenever required and also at shortage of resources.
• Involved in creating dashboards and reports in Tableau 9.2,9.1. Created report schedules on Tableau server.
• Hands on experience in installation, administration and configuration of business intelligence tools like Tableau Server and Tableau Professional
• End to end implementation experience in designing and deploying data visualizations using Tableau
• In-depth knowledge on Tableau Desktop, Tableau Server and Tableau Viewer.
• Involved in Tableau platform upgrades and installation in single, distributed and clustered environments
• Mastery in the ability to design and deploy rich Graphic visualizations with Filters, Drill Downs and Parameters.
• Created different visualizations e.g. side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps, Symbol Maps, KPI’s and predictive models according to deliverable specifications.
• Established Standards and Best Practices for Enterprise Tableau Environment, application on boarding and development processes.
• Extensively worked on Tableau 9.x/8.x/7.x (Desktop, Server & Reader), Micro Strategy.
• Worked on Cognos BI tools including Business Intelligence Suite, Congo’s Framework Manager, Report Studio, Query Studio, Analysis Studio and Power play Transformer.
• Excellent proficiency in the usage of Congo’s tools such as Framework Manager, Report Studio, Query Studio, Analysis Studio and Power play, Transformer.
• Assisted in the installation and configuration of Congo’s software across multiple environments.
• Strong experience in creating and publishing packages and Models in Framework Manager.
• Proficient in developing reporting applications employing Congo’s 10.1 & Report Net components like Framework Manager, Report Studio, Query Studio, Analysis Studio and Congo’s Connection.
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups.
• Provided technical and analytical expertise in responding to complex, specialized report requests requiring complex business logics and detail-level data analysis.
• Provided 24X7 Operational/Application support for business critical applications.
• Extensive working experience in writing Packages, Procedures and Functions.
• Good working knowledge of Oracle 8.x/9.x,10.x/11.x/12c SQL server 2016, Teradata, DB2, Postgres, SQL and PL/SQL.
• Experience in administering security by defining roles and groups, monitoring/modify scheduled reports/jobs using Schedule management tool.
• Good understanding of connectivity architecture and networking protocols
• Involved in all phases of testing, which includes Unit Testing, Performance Testing, system Testing and Integration Testing.
• Extensive experience in troubleshooting, performance tuning and supporting business applications and reporting solutions.
• Excellent communication and inter-personal skills, an excellent team player accustomed to work in a team environment with tight schedules and capable of working efficiently under pressure, manage multiple projects.
• Excellent problem solving, troubleshooting and decision-making skills.
• Owned the design, development and maintenance of ongoing metrics, reports, analyses, dashboards, etc., to drive key business decisions and communicate key concepts to readers.
• Developed rich interactive graphics and data visualizations of large structured data in browser-friendly formats.
• Analyzed data requirements, application and processing architectures, data dictionaries and database schemas while designing, developing, amending, optimizing and certifying database designs to satisfy client needs.

TECHNICAL SKILLS:

BI Tools: Tableau, Congo s, Spot fire, Micro Strategy

Data ware: Oracle 8i/9i/10g/11g,12c, Teradata, MS SQL Server 2012/20015/2016, DB2 and Postgres

Tools: /Utilities TOAD, SQL developer, R Studio

Web Server: IIS Web Server, Tomcat

Operating Systems: Windows NT/2003/XP/ME/95/98, Windows 7, Windows 8

PROFESSIONAL EXPERIENCE:

Confidential, Rocky Hill, CT

Sr. Tableau / Business Intelligence Developer

Tableau Desktop 10.3, 10.2 Tableau Server 10.3, 10.2, Oracle 11g, Microsoft SQL Server 2016

Responsibilities:

• Building, publishing customized interactive dashboards/reports, dashboard/reports scheduling using Tableau server.
• Developing dashboards in Tableau 10.5, 10.3. Created report schedules on Tableau server 10.5, 10.3.
• Optimized Tableau Visualizations with huge amount of data to fit into the business requirements and repaired existing dashboards to make them business friendly by applying various filtering and parameterizing techniques.
• Recording dashboard/report performance to identify the issues and improve the efficiency.
• Analyzed and gained understanding of the underlying data and generated tableau dashboards with forecast and reference lines and Worked on querying data and creating on-demand reports and publishing the same to Tableau Server.
• Manipulating the data front end by writing custom and tuning SQL queries for enhancing the database performance SQL.
• Creating requirement specific queries to validate the data and also to build reusable tables on the backend.
• Utilized the JavaScript API to create a customized portal for the property management group.
• Using Java Script, HTML, CSS based API’s to create filter / interacting with the dashboard through interface.
• Liberating the codes to shared folder through GIT, CMD commands.
• Created TDE files as templates for continuous reporting which eliminated the need for creation of multiple new Tableau files for every report and reduced dashboard creation times.
• Suggested best practices in optimizing Tableau desktop for its peak performance resulting in a significant decrease of development and delivery time.
• Designed and developed the most suitable user interface such as dashboards, multiple charts types, trends, custom requests for excel export and objects for management dashboard/reports.
• Created data visualization using Pareto's, combo charts, heat maps, box and whisker charts, scatter plots, geographic map, cross tabs, histograms.
• Developed donut charts for analyzing demographic data. Building different KPI's using table calculations and calculated key figures manipulating strings, arithmetic calculations, aggregation options and logical functions.
• Created various mappings by using different kinds of transformations like source qualifier, expression, join, lookup, filter, rank, sequence generator, stored procedure, router, normalize, transformations.
• Developed complex calculated fields for the business logic, field actions, sets and parameters to include various filtering capabilities for the dashboards, and to provide drill down features for the detailed reports.
• Using Level of Detail Expressions (LOD) for complex calculations, filtering huge dataset for required fields, advanced grouping and to implement semi additive measures.
• Built dashboards with floating objects and capitalizing the various dashboard actions features like URL, images, web integrations
• Structured the dashboard with a consistent layout with visuals chart at the top and corresponding crosstab data and the bottom.
• Represented portfolio data as crosstab in directing from one dashboard to another for detailed information/view through dashboard actions.
• Created symbol maps to understand the geo-spatial distribution of projects with custom symbols made of represent the application category.
• Customized the tooltips and labels, to user understandable format, the numerical measure was changed to its appropriate formats like representing the member counts, expense and margins as currency values
• Implemented hierarchies in Tableau with portfolio as the highest level followed by application and project details.
• Generated groups for the application field to do category based analysis.
• Involved in creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logins and security checks whilst reviewing various compatibility issues between Tableau server and Tableau desktop.

Confidential, Columbia, MD

Sr. Tableau Developer / Data Analyst

Tableau Desktop 10.0, 10.1, 10.2 Tableau Server 10.0, 10.1, Microsoft SQL Server 2016, MS Access, MS Excel 2010, Postgres 9.6.2 Oracle 11g

Responsibilities:

• Understand the Requirements and Functionality of the application from specifications.
• Designing, developing, testing, and maintaining Tableau reports and dashboards based on user requirements.
• Working closely with business in creating dashboards based on the data from various Data sources.
• Utilizing Tableau server to publish and share the reports with the business users.
• Developing Tableau data visualization using Waterfall, Cross Map, Scatter Plots, Geographic Map, Pie Charts, Bar Charts, Dual axis, dashboards using stack bars, scattered plots, Gantt charts and various other charts based on the business desired.
• Creating Key performance Indicators view for year-over-year comparison.
• Distributing Tableau reports using techniques like Packaged Workbooks, PDF to different user community.
• Creating New Schedule's and checking the task's daily on the server.
• Maintaining server activities, user activity and customized views on Server Analysis.
• Extracting data from databases like Salesforce, Postgres, Excel, Statistical File and Text File for getting data to Tableau for creating various dashboards.
• Creating Business requirement documents and plans for creating dashboards.
• Providing customer support to Tableau users.
• Expert level capability in Tableau calculations and applying complex, compound calculations to large, complex data sets.
• Strong report/dashboard design experience and passionate practitioner of effective data visualization.
• Experience with the design and development of Tableau visualization solution.
• Developing Congo’s report and performed various tasks like cross data base joins, modifications to existing reports, publishing reports to the server.
• Working with Business user to analyze requirements and create user requirement document.
• Experience with report maintenance both in development and production environment.
• Providing production support for Congo’s reports.

Confidential, Richmond, VA

Sr. Tableau Developer / Data Analyst

Tableau Desktop 9.1,9.2, Tableau Server 9.0,8.2, Oracle 9i and PL/SQL

Responsibilities:

• Experience with the design and development of Tableau visualization solution
• Provided support for Tableau developed objects and understand tool administration.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
• Created Custom Hierarchies to meet the Business requirement in Tableau.
• Manage Production, Test and Development environments including installation of patches, security administration and access controls in Tableau.
• Created Workbooks and dashboards for analyzing statistical billing data using Tableau 9.1
• Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
• Responsible for the implementation of Row level security with the existing Data Mart
• Involved in the prototyping based on the user requirements and interacting with the management.
• Responsible for the performance tuning of Dashboards based on the best practices of Tableau.
• Involved in the Adhoc reporting for the various teams across the organization.
• Creation of user, groups, folder structures, library and repository Tableau server logons and security checks.
• Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Developer.
• Created Complex workbooks and Dashboards by connecting to multiple data source using data blending.
• Created Tableau scorecards, dashboards, Heat maps using show me functionality.
• Good Experience in publishing reports and dashboards to Tableau server
• Created complex data Views Manually using multiple measures, also used sort, Filter, group, Create Set functionality.
• Published Reports, workbooks & data source to server and exporting the reports in different Formats.
• Good experience in using URL's, Hyperlinks, Filters for developing Complex dashboards and worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures.

Confidential, Minneapolis, MN

Tableau Developer / Data Analyst

Tableau Desktop 6.02,7.0, Tableau server / Administrator, Oracle 10g, Microsoft Excel 2007, MS Access, Microsoft office 2007

Responsibilities:

• Worked in developing strategy and technical specifications for implementing reporting portal/semantic layer in conjunction with data layer.
• Involved in creating dashboards and reports in Tableau 7.1. Created report schedules on Tableau server.
• Installed and upgrade Tableau server form Tableau 7.0 to Tableau 7.1 and experienced in server performance tuning for optimization.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• 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.
• The ability to interact professionally with a diverse group including executives, managers.
• Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions to their requirement.
• Excellent experience and expertise in creating Tableau Workbook's, Publishing workbooks and Dashboard.
• Find efficient ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Proof-read all documents and maintain accuracy of information and preparing SOP.
• Responsible for Developing a Dashboard and preparing ad hoc Reporting.
• Working knowledge on Tableau Server / Administration.
• Worked in Agile environment with Rally and involved in Conducting scrum meetings.
• Extensively worked with the QA Team and the Business users during UAT in Sign-off process. Track issues or bugs to resolve.
• Involved in Regression testing, Unit testing (UAT) and fixing issues in the Reports during validation and before approving the reports to Production Environment.

Confidential, Miami, FL

Tableau/Cognos Developer

Cognos10.1/10.2 Framework Manager, Tableau 8.1, Teradata Profiler, BMC Footprint, Data stage, Sql Server 2008.

Responsibilities:

• Involved in Designing and creating various Subject areas like Provider, Recipient, Claims and Financial for State and Federal reporting in Framework Manager 10.2
• Structured Metadata and Congo’s Models using Framework Manager.
• Involved in creating complex Report Studio reports with Provider Claims subject area.
• Created different types of reports like List, Cross-tab, Chart, Drill-Thru and Master-Detail Reports
• Formalized the reporting process by creating the technical specification and requirement specification document.
• Involved in Data profiling of Teradata with the ETL team to assist them to check the Data Quality.
• Provided day-to-day support for all COGNOS Report studio and Query studio Reports Using Numara BMC Foot Print 11.5
• Interacted with the business users and assist/train them to use query Studio to develop ad hoc reports.
• Created Dashboards for a better understanding of the business performance metrics.
• Developed and published reports and dashboards using Tableau Desktop/server.
• Redistributed tableau server processes based on tableau's recommended configuration in a distributed environment to improve server's performance.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Configured tableau server for subscriptions enabling business to receive dashboards periodically.
• Collected data on various process measurements and formatted into graphs using Tableau software.
• Prepared graphical depictions of User stories, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagrams using MS Visio.
• Worked throughout the SDLC, which included requirements, specifications, design, analysis and testing utilizing RUP methodology.
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.

Confidential, Chicago, IL

Cognos Developer

Congo’s 8.4 (Report Studio, Analysis Studio, Event Studio, Metric Studio, Query Studio), Congo’s PowerPlay Transformer v7.4, PeopleSoft ELM v 9.1, SQR, PL/SQL, Web Sphere application server, Java, Shell Script, ParAccel, Oracle 10g, MS SQL Server 2005, Win 2K, HP-UNIX

Responsibilities:

• Discussed with clients about their present reporting system and understand their current reporting issues to meet their needs
• Built POC reports to showcase how to achieve client needs using real time scenarios.
• Demonstrate the flexibility of Congo’s using Congo’s Report Studio, Analysis Studio and how Congo’s could help them to meet their reporting needs.
• Performed the distributed installation and configuration of Congo’s 8.3 on new servers in Production, Testing and Development environments.
• Fact and Dimension tables were used in the Congo’s FM model for Package building.
• Built new packages using Congo’s Framework Manager and converted the existing reports from Excel to Congo’s reports using Congo’s Report Studio.
• Used ROLAP and OLAP models as source to create reports using Report Studio.
• Built complex reports using SQL scripts.
• Created complex calculations, various prompts, conditional formatting and conditional blocking etc., accordingly.
• Deployed the Congo’s Content from Development environment to UAT/Production environments
• Closely worked with Congo’s Support team for troubleshooting complex issues.
• Responsible for creating the Cubes and Reports and scheduling them accordingly
• Extensively used Power Play Transformer to move relative data mart data into Power Cubes.
• Maintained users, groups, and roles and assign them respective privileges as per business needs
• Created logical model including Entity-Relationship diagram.
• Converted logical model into physical model
• Developed over 1000 T-SQL stored procedures, functions, triggers and views.
• Worked on optimization SQL Server performance, monitoring, and queries tuning using Microsoft tools Performance Monitor
• Creating user requirements document for companywide reports by interacting with end users and developers.
• Interact with the developers and defined the needs to update the design of the Graphical User Interface.
• Helped QA team in testing SQL scripts and validated the enhancement of the project by creating test cases which were developed for Development team. A major responsibility included interacting with the users and business relationship managers and implementing changes on the database in order to ensure UAT approval.
• Experience with web-based applications, database query tools, and Microsoft Office products.

Confidential

SQL Developer

SQL Server 2000, SQL Server 2005, SSIS, T-SQL, Windows 2000, Visual Studio.NET, Windows 2000 & Windows2000 Server

Responsibilities:

• Monitored testing servers for long running stored procedures, queries using profiler and recommended clustered and non-clustered indexes using DTA.
• Creating and managing schema objects such as tables, views, joins, clusters, indexes, functions, procedures, triggers& maintaining Referential Integrity.
• Improved query performance by adding covered indexes, adding file groups.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Extensive experience in designing, creating and deploying SSIS packages for transferring data from flat files, excels spreadsheets and heterogeneous data to and from SQL Server.
• Creation and scheduling of Maintenance plans (database and log backups and cleanups), DTS to SISS package conversions.
• Designing & Development of Standard Reports, Sub Reports, Cross Tab Reports and Charts using crystal Reports.
• Exported crystal/SSRS reports into various formats like PDF, HTML, Excel and Word for end users.
• Configured Reporting Services in SQL Server 2005.
• Created standard Reports and Cross Tab Reports and Drill Through reports in SSRS.
• Generated Reports using Global Variables, Expressions and Functions for the SSRS reports.
• Designed and implemented schema
• Designed and implemented Warehouse
• Designed production database maintenance schema
• Designed release management procedures for Development
• Designing, debugging, and optimizing T-SQL and MDX queries, T-SQL and CLR stored procedures, functions, views and dynamic queries for SQL Server, OLAP Server
• Designing and creating ETL and Integration Services packages.