SUMMARY:

• Accomplished Business Intelligence Developer with several years of experience leveraging business intelligence software in presenting functional dashboards, reports, analytical findings and practical solutions in the healthcare, finance and computer system design and related services. Adept at quickly learning new systems and operations that align with business goals to achieve consensus among stakeholders.
• Experienced working with SQL databases and Excel, performing various data analysis and ETL tasks
• Experienced in Data manipulation, Report creation, Importing & Exporting Data in different formats and from various sources
• Proven ability in working with enterprise level large data warehouse, RDBMS systems, and ETL and modeling tools/techniques.
• Expertise in writing SQL Queries, Dynamic - queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Experienced in working with querying tools such as TOAD, SQL Server Management studio and SQL plus for development and analysis
• Experience including Analysis, modelling, design and development of Tableau reports and Dashboards for analytics for reporting applications.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Experience working with various data sources such as Oracle, SQL Server, Teradata, ODBC and flat file sources
• Extensive Tableau Experience in Enterprise Environment in Tableau 8.0x, 9.0x and 10.0x, 2018x and Tableau Prep as a Developer and Analyst
• Highly analytical and detail-oriented, with strong organizational and reporting skills
• Advanced analytic skills and extensive experience with MS Excel and Access
• Proficient in Apache NiFi for data routing, transformation and system mediation logic
• Proficient in utilizing Kylo software platform for data ingestion preparation with integrated metadata management
• Multiple complex tasks-handling and excellence in self-audit work
• Excellent communication and project management skills
• Personal and group work organization coupled with time management skills
• Governance & Compliance Sarbanes-Oxley (SOX) for SDLC, HIPPA
• Full Lifecycle Project Management Systems Strategy & Implementation

TECHNICAL SKILLS:

Operating Systems: Win (10, 7, Vista, XP), Windows Server 2003, 2008 (X32, X64), UNIX

Databases: MS SQL SERVER (2014, 2012, 2008, 2005), Oracle 10g,11g,12c, MySQL MS Access

Query Tools: SQL Management Studio 2008/2012, Teradata SQL Assistant, SQL Plus, Quest TOAD and SQL Profiler, PostgreSQL

Programming Languages: SQL, PL/SQL, UNIX Shell Scripting

Business Intelligence Tools: Tableau 2018x, 10x, 9x, Power BI, SSRS, Grafana Excel

Project Management Tools: Jira, MS Project

Data Modeling Tools: ERWIN, Visio, ER Assistant, SSIS

PROFESSIONAL EXPERIENCE:

Confidential, Rockville, MD

Business Intelligence Developer

• Business Intelligence developer for the APS-CMS project providing data analysis and developing visual reports in compliance through the National Fraud Prevention Program (NFPP)
• Collaborate with the Production team, Data Analytics team and Testing team to drive the dashboard development for Center for Medicare and Medicaid Services (CMS) needs
• Create SQL queries to fetch data from different table by using JOINs, Sub-queries, Correlated sub-queries and derived tables with TOAD on an Oracle database platform
• Create and publish Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
• Create Dashboard reports by translating data into visually rich presentations using different types of charts, and other graphical elements to show multiple results together.
• Provides overall direction, guidance, definition and facilitation for the advancement of dashboard development effort to meet business strategies and goals
• Follow industry standard techniques and efficient approaches to connect Tableau with disparate data sources and target database
• Develop dashboards and prepare ad-hoc reporting for demonstration and illustration purposes for internal use
• Deliver high quality dashboards adhering to latest trends and complete project on time and work on fast paced development cycle

Confidential, Rockville, MD

Business Intelligence Analyst

• Business Intelligence Analyst for the Confidential by providing data analysis and visual reports in compliance with the Digital Accountability and Transparency Act (DATA Act)
• Created SQL queries and views to extract aggregated data to validate the accuracy of the data
• Played a significant role in UAT process by providing analysis and report which led to the discovery of a quarter billion obligations and outlays certified by the HHS Senior Accountability Officer/CFO
• Mastered the ability to design and deploy rich Graphic visualizations with Navigational sheets, Drill Down menu option, filters and Parameters using Tableau.
• Created Dashboard reports by translating data into visually rich presentations using different types of charts, and other graphical elements to show multiple results together.
• Gathered business requirements and translating them into clear and concise specifications and queries
• Produced clear, concise, relevant and accurate documentation based on captured requirements and information gathered from stakeholders and subject matter expert
• Created and published Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
• Collaborated with the Testing team to test and maintains data integrity.
• Developed dashboards for demonstration and illustration purposes for peer groups, senior leaders and business partners
• Supported peers and stakeholders as a Subject Matter Expert (SME) through troubleshooting analysis of results

Confidential, Wilmington, DE

Data Analyst/ Tableau Developer

• Provided data analysis and visual reports to the fraud investigation team in support of their investigation leads
• Used state-of-the-art decision support and neutral network tools to detect potential fraud and support investigations organizing case files, research violations and accurately and thoroughly document all steps taken in project development
• Created complex SQL queries using advanced SQL concepts like aggregate functions, Group By and OLAP (Online Analytical Functions).
• Created queries to fetch data from different table by using JOINs, Sub-queries, Correlated sub-queries and derived tables on Teradata platform.
• Worked with OLAP and OLTP tools such as ETL, data warehousing and Modeling.
• Created numerous permanent tables, Volatile tables and Global Temporary tables.
• Created dashboards, charts, pivots in Tableau Desktop 9.3 or higher using calculations, parameters
• Create SQL stored procedures using SQL Query
• Developed Dashboard and prepared ad-Hoc Reporting .
• Handled Strong healthcare material including experience with transaction standards (e.g. HIPAA
• Assisted users in creating and modifying worksheets and data visualization dashboards, Gather Information, analyzed reports and presented reports

Confidential, Horsham, PA

Tableau Developer

• Assisted the organization in making strategic data-related decisions by analyzing, manipulating, tracking, internally managing and reporting data.
• Collaborated with users and developers to verify impacts of changes to design and cost estimates of the designs
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down menu option and Parameterized using Tableau.
• Generated Dashboards with Quick filters, calculated fields, Groups, Parameters and Sets to handle views more efficiently in Tableau.
• Building and publishing Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
• Extensive experience in Tableau Desktop, Tableau Server and Tableau Reader in various versions 8.1/9.0+.
• Created Dashboard reports by translating data into visually rich presentations using different types of charts, and other graphical elements to show multiple results together.
• Rich experience in writing SQL Queries.
• Involved in designing database, tables, ER diagrams and building table relationships using ERWIN.
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, dimensional modeling and reporting tools, worked with high volume databases with partitioned data.
• Communicated requests to development teams to support appropriate staging and configuration of data to make dashboard more per-formant.
• Developed reports with accurate, easy to read, useful information.
• Tested and maintains data integrity.
• Participated in the development of outcomes and process measures, including technical specifications, to enable population measurement, guideline implementation, and evaluation.

Confidential, Charlotte, NC

Tableau/SQL Developer

• Developed and corrected system interface specifications for a large mainframe mortgage system
• Teamed up with users and developers to verify impacts of changes to design and cost estimates of the designs
• Created SQL stored procedures using SQL Query Analyzer and Transact-SQL as data sources for reports.
• Assisted in the development of annual budget, scope of services, program goals and manage program expenses according to established projects and agency procedures.
• Created and Modified Stored procedures for various databases.
• Extensively used joins and sub queries to simplify complex queries involving multiple tables.
• Hands on experience on tableau desktop, tableau server and tableau public.
• Created dashboards using scatter plots, histogram, Box Plots, geographic map, Pie Charts and Bar Charts, trend charts.
• Experience in creating filters, quick filters, data source filters, local and global filters, context filters and user filters.
• Created different Calculation fields per requirement, various conditions and applied multiple Filters for various analytical reports and dashboards.
• Created dashboards using advance analysis actions, groups, parameters, background images, maps, groups, and sets.
• Experienced in writing SQL queries to extract data from databases and connecting live/dynamic and static datasets to tableau desktop.