SUMMARY

• Over 8+ years of strong experience in Business and Data Modeling/ Data Analysis, Data Architect, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Governance, Data Integration, MDM, NoSQL and Metadata Management Services and Configuration Management.
• Expertise and Vast knowledge Enterprise Data Warehousing including Data Modeling, Data Architecture, Data Integration (ETL/ELT) and Business Intelligence.
• Experience in working with Tableau Desktop, Tableau Server, Tableau Online, and Tableau Reader in various versions of Tableau 2018.1, 10.5/10.4/10.0/9.2/9.0/8.2/8.0 as a developer and administrator.
• Extensive experience in Installation, configuration, upgrade, and administration ofTableauDesktop/Server.
• Experience in creating dashboards using calculations, groups, sets, parameters, calculated fields, and hierarchies.
• Expertise in development of SQL Server 2008/2008 R2/2012/2014 with specialized skills in working with the Business Intelligence Development Studio (BIDS), which includes SSIS, SSRS and report builder
• Extensive Tableau Experience in Enterprise Environment and Tableau Experience including technical support, troubleshooting, report design and monitoring of system usage.
• Knowledge of best practices and principles for data visualization, dashboard and report design, marketing analytics, and data mining.
• Strong development experience with the Microsoft BI Stack - SQL-Server, SSIS, SSRS, SSAS, Power Pivot, Power BI and SharePoint.
• An in-depth grasp of database structures, SQL reporting, analytics, Data warehousing and ETL.
• Experienced in Designing queries using T-SQL in the SQL Server Management Studio (SSMS) environment.
• Data Analyst with strong experience in Python, SQL, Teradata, SAS, Tableau and Power BI.
• Extensively usedPython libraries Pandas forData Munging,NumPy and SciPyfor numerical and scientific computations.
• Skilled in data manipulation using Pandas and generating customized reports using matplotlib in Python.
• Experienced in data cleaning and data wrangling of large datasets usingSAS, SQL, Python.
• Experience in creating dashboards and charts/reports using Tableau and Power BI and proficient in Data collection, Data cleansing, Data modelling and interpretation of large data sets.
• Skilled at database management using SQL Server to create complex Stored procedures and triggers.
• Extensive experience in enterprise data modeling and analytics (SSRS, SSAS, SSIS, ETL, MDM, Entity Data Models, and data warehousing) incorporating transaction-oriented business/service level data processes and metadata collection techniques to enhance informatics strategies.
• Application areas: Business Intelligence,DataWarehousing, ETL,DataIntegration,OperationalDatastore, Application Interfaces, ERP, MasterDataManagement,DataGovernance.

TECHNICAL SKILLS

Programming Languages: SQL, PL/SQL, and Python.

Statistical Software: BI Server Base SAS, SAS Enterprise Guide and SAP.

Databases: MS Access, Oracle, Sybase, SQL Server, DB2

Software Packages/Tools: MS Office (Word, Excel, PowerPoint), MS Project 2000, Micro strategy, SQL Navigator, Tableau, Microsoft Power BI, Spark.

Operating Systems: Windows 9x/NT/2K/XP, DOS, UNIX.

Web Technologies: HTML/DHTML, Java Script, VBScript, ASP, Front Page.

Visualization tools: Tableau, Power BI, QlikView.

PROFESSIONAL EXPERIENCE

Confidential | Los Angeles, CA

Data Analyst

Responsibilities:

• Created SSIS packaged and used Analysis Services processing task to update thecubewith current data.
• Actively involved in creating Custom Reports by understanding the Management and senior level Management’s need to support in business.
• Performed the administration, configuration, maintenance, and upgrade of Tableau Servers.
• Developed web applications in Django Framework model view control (MVC) architecture.
• Involved in building database Model, APIs and Views utilizingPython to build an interactive web-based solution.
• Ensured Tableau Server configuration settings are optimal.
• Managed Data Extract Schedules and Access to Reports.
• Created custom SQL connections and calculated fields within Tableau to facilitate automated production of data visualizations.
• Build interactive Tableau dashboards and publish Tableau reports utilizing parameters, calculated fields and table calculations, user filters, action filters and sets to handle views more efficiently.
• Worked on the development of Tableau Dashboard reports for Key Performance Indicators for management.
• Rebuild existing Reports into Tableau Visualizations with user and action filters.
• Published Workbooks by creating user filters so that only appropriate users can view/edit them.
• Generated context filters and handled performance issues while dealing with huge volume of data.
• Generated tableau dashboards with forecast and reference lines.
• Installing and Configuring of Tableau Server and Tableau Desktop.
• Usage of Tableau Desktop for blending databases and creating different interactive views and dashboards.
• Creating groups, projects, workbooks and the appropriate permissions for Tableau server and security checks.
• Involved in Tableau Administration Tool for configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platform like web portals.
• Creating Bookmarks, Actions, worksheets and workbooks.
• Created extract files for improving the performance and Tableau server performance tuning for optimization.
• Involved in troubleshooting and resolving issues within Tableau Server and Reports.
• Used Tableau command line commands to publish workbooks periodically.
• Created SQL Agent Jobs, Alerts, to schedule DTS/SSIS packages.
• Created several SSIS packages using advanced tools to pull data from various data sources including flat files, MS-Access, Excel, SQL Server/Oracle databases, etc.
• Excellent Knowledge in Data Warehouse Concepts, Data Modelling, ETL and worked on OLTP & OLAP in all environments which includes development (DEV), test (QA) and production (PROD).
• Experience with Teradata/ Oracle/ MS SQL Server and ability analyse data sets using SQL.
• Experience in working with Oracle 12g/11g/9i/8i, MS SQL Server 2000/2010/2012/7. x running on Windows.
• Automation of sending Email process daily, to view refreshed tableau dash boards.
• Established database connections forPythonby configuring MySQL- Python.
• Performance tuning of workbooks, data sources, and providing best practices for user community.
• Provided guidance and insight on data visualization and reporting/dishoarding best practices.
• Documented reporting requirements and defined report templates and dashboard specifications.
• Established, maintained, and ensured adherence to application standards for data reporting.
• Used Tableau to contextualize information in a manner suitable to executive audiences.
• Identified key business metrics measurements and developed methods to represent data in support of the measurements.

Environment: Tableau desktop 8.x, Tableau Server 8.x, Tableau Reader, Tableau Public, Tableau online, MS SQL Server, SQL server reporting services (SSRS), MS Excess, and MS Excel.

Confidential | Bloomfield, CT

Data Analyst

Responsibilities:

• Works closely with BI subject matter experts and developers to implement best practices for designing, developing, and deploying applications in a multi-tenancy environment.
• Assisted with application installations, upgrades, and migrations within virtualized environments.
• Researches and assists with scaling new data analytics products within the department including, but not limited to R Studio Server, Tableau, and Microsoft Power BI.
• Supports the development, maintenance, and configuration of reports/dashboards within Oracle Business Intelligence Enterprise Edition (OBIEE).
• Creating SSIS packages using proper control and data flow elements improving the performance of the package run time and unit test the developed packages as an ETL developer.
• Work on ETL process using Microsoft SQL Server Integration Services (SSIS) process to provide the data quality, data cleansing, business rule transformations, and data loading, support the data loads and transformations using SSIS for the iterative conversion project.
• Involved in migration from SQL Server 2008 R2 to Oracle databases using SSIS on CSS Conversion Project.
• Develops and maintains basic workflows, mappings, and sessions within Informatica Power Centre.
• Create necessary documentation for all charts and dashboards using multiple data sources.
• Write, interpret, and optimize complex queries working with large sets of data.
• Develop and maintain tableau visualizations and reports and developed ad-hoc Business Objects Web Intelligence Reports.
• Developed Packages to Load data from MS SQL server to Oracle destinations and in the flow created new SSIS packages according to the requirement for the fields.
• Troubleshooting the issues on the SSIS packages.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.
• Developed Tableau visualizations and dashboards using Tableau Desktop and Provided production support for Tableau users.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Working on tuning SQL queries and T-SQL according to the desired output.
• Worked on ETL process in SSIS packages and improved the progress time. Used all different transformations required.
• Worked atconceptual/logical/physical data model level using Erwin according to requirements.
• By using cached mode in Tabular Models, integrate data from multiple sources including relational databases, data feeds; excel files and flat text files.
• Conduct extensive quality control and record-keeping procedures to ensure the highest levels of data integrity.
• Manage and track end-user requests and troubleshoot Tableau issues.
• Provide best practices in data visualization and business intelligence software, including recent versions of Tableau and also provided automation for Tableau dashboards functional and performance testing.
• Works with end users, the team's analysts, technical staff, and project team members to plan, design, develop, implement, and enhance business analytics capabilities using Tableau’s Business Intelligence tools.

Environment: Tableau Desktop 2018.3, Teradata SQL Assistant, Tableau Server, MS Excel, MS SQL Server 2012, SSRS 2012 -MS SQL Server Reporting Services (SSRS), T-SQL, PL-SQL, Oracle SQL Server, SQL Server Integration Services.

Confidential | Richmond, VA

Data Analyst

Responsibilities:

• Created thebusinessrequirements, identified issues encountered anddataneeds related to theEMR, billing, analytics systems and custom applications throughout the hospital system and proposed solutions to meetbusinessneeds.
• Worked with the development and testing teams about the ETL processes involved in the project.
• Worked on Requirement Analysis, Data Analysis and Gap Analysis of various source systems sitting and coming from multi-systems. Responsible for BI Data Quality.
• Extracted Data using SSIS from DB2, XML, Oracle and flat files, Excel perform transformations and populate the data warehouse.
• Expert hand on knowledge of SAS/BASE, SAS/MACRO, SAS/STAT, SAS/GRAPH, SAS/ACCESS.
• Performed Teradata SQL Queries, Creating Tables, and Views by following Teradata Best Practices.
• Conducted JAD sessions to allow different stakeholders such as editorials, designers, etc.
• Performed Business Process mapping for new requirements.
• Use SQL, PL/SQL to validate the Data going into the Data Warehouse
• Creating complex data analysis queries to troubleshoot issues reported by users
• Evaluates data mining request requirements and help develop the queries for the requests.
• Defined data requirements and elements used in XML transactions.
• Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
• Independently designed and developed project document templates based on SDLC methodology.
• Prepared Entry and Exit criteria for Testing cycles, review with functional leads and PMO.
• Exported Requirements, test plans and test cases to QC 9.2.
• Created Traceability Matrix to ensure that all requirements are covered in test cases.
• Prepared Kick-off meeting PowerPoint and gave a presentation on testing activities for each cycle of testing and for different releases.
• Wrote complex SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application. Expert in writing Complex SQL/PLSQL Scripts in querying Teradata and Oracle.
• Used TOAD Software for Querying ORACLE and Used WinSQL for Querying DB2.
• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting Test cases, Test Scripts in Quality Center 9.2
• Created defects, manage defect reports and defect status in ClearQuest tool
• Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.

Environment: Informatica Power Center 8.6(Repository Manger, Designer, Server Manager), Oracle 10g, MS SQL, HP Quality Center 9.2, Netezza, Requirement traceability Matrix (RTM), XML, Assistant, Teradata V2R6, Teradata SQL Assistant, IBM DB2, SSAS, SAS/Stat, SAS/Graph, SAS/ODS, SAS/SQL, SAS/Connect, SAS/Access.

Confidential

Data Analyst

Responsibilities:

• Analyzed customer data and created reports using Excel features pivot tables, VLOOKUP, Charts Performed database testing validating database tables, stored procedures, and triggers
• Involved with Data Analysis primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats
• Created and modified database triggers, stored procedures, or complex analytical queries including multi-table joins, nested queries, and correlated sub queries optimized the performance
• Extensively used SQL function such as SUM, COUNT, CASE Statements for creating, transformation logic for data mapping
• Managed the planning and development of design and procedures for metric report.
• Optimized data collection and procedure to generate reports weekly, monthly, and quarterly.
• Developed the application using agile methodology and planned the scrum meetings.
• Involved in exhaustive documentation for technical phase of the project and training materials for all data management functions
• Conducted major stakeholder interviews involving SME’s, Business Analysts, and other stakeholders
• Used various SQL commands like Create, Delete, Update, and Inner, Outer, Left, and Right Joins to update the database and retrieve data for data analysis and validation.
• Created action plans to track identified open issues and action items related to the project Prepared analytical and status reports and updated the project plan as require.
• Created SQL queries in Toad to perform data analysis, data validation and data manipulation operations.
• Analyzed data throughqueryingviaSQLfrom various database sources (i.e., Oracle, SQLServer, MySQL).
• Retrieved and validatebusinessrequirements to set upSQLqueries for reports.
• Conducted UAT (User Acceptance Testing) to make sure that all the user stories are catered by the application.

Environment: PowerPoint, MS Visio, MS Excel, MySQL, Tableau, SQL, PostgreSQL

Confidential

GIS Analyst

Responsibilities:

• Assisted in publishing GIS data, maps, analysis, reports, charts, and graphs in the form of static Created and online content.
• Experienced in GIS database editing, geocoding, geoprocessing, data conversion, workflow management, spatial analysis, and quality control processes in desktop and web-based environments. Developed and maintained GIS files and associated spatial and tabular databases.
• Created, and produced spatial layers, analysis, maps, reports, charts, and cartographic displays.
• Created documents and presentations to convey planning recommendations, division/departmental communication initiatives, and GIS-related technical/business documentation.
• Created maps and graphs, using GIS software and related equipment to meet with users to define data needs, project requirements, required outputs, or to develop applications.
• Conducted research to gather, analyze, and integrated spatial data to determine how best the information can be displayed using GIS.
• Compiled geographic data from a variety of sources including censuses, field observation, satellite imagery, aerial photographs, and existing maps.
• Analyzed spatial data for geographic statistics to in corporate into documents and reports.
• Entered new map data through use of a digitizer or by direct input of coordinate information using the principles of cartography including coordinate systems, longitude, latitude, elevation, topography, and map scales.

Environment: Arc GIS, ESRI, ARC DESKTOP, PowerPoint, MS Excel, MySQL