We provide IT Staff Augmentation Services!

Data Analyst Resume

0/5 (Submit Your Rating)

Westlake-, TX

SUMMARY

  • 6+ years of extensive IT experience in Business Intelligence applications like Tableau, Data Warehouse, Cogno’s, OBIEE, SSRS and Data Analyst.
  • Experienced in Database applications like Oracle, Netezza, MYSQL, SQL Server, Teradata, Hive and DB2.
  • Worked on various projects in Health care, Insurance and financial domains.
  • In - depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
  • Proficient in Tableau data visualization tool to analyze and obtain insights into large datasets and create visualizations like bar charts, pie charts, line graphs, doughnut charts, heat maps, stacked bars, Gantt charts etc.…
  • Created dashboards using Facts, Attributes, Hierarchies, filters, calculated fields, Sets, Groups, Parameters etc., in Tableau.
  • Excellent understanding of data warehouse, OLAP and OLTP concepts.
  • Performed Data Analyst role in analyzing, modeling and implementing various enhancement projects using Tableau.
  • Good interaction with end users while working on KPI’s, requirements and designs.
  • Published extract data sources on server and scheduling extract refreshes for dashboards.
  • Involved in providing permissions to users and groups on Tableau Server and creating directories and also migrating to tableau versions.
  • Experience in analytical tools such as Google Analytics and worked on Alteryx for data pre-processing.
  • Experienced using SDK Python in Tableau Desktop.
  • Extensive experience in performance tuning and data analysis using SQL queries with use of TOAD, Aginity Workbench, MYSQL, and Oracle.
  • Involved in API JavaScript and implementing reports on server.
  • Worked on ETL workflows and monitored the ETL Jobs.
  • In depth knowledge of Software Development Life Cycle (SDLC) Phases such as Requirement analysis, Design, Development, Testing and Deployment
  • Strong working knowledge in software development methodologies like Agile, Waterfall using tools like JIRA and RALLY
  • A highly motivated self-starter with excellent communication skills.

TECHNICAL SKILLS

BI Tools: Tableau Desktop, Tableau Server, Cognos, SSRS, ETL, Informatica,MS Excel

Databases: Oracle 10g/11g, MS Access, MySQL, MS SQL Server, Teradata Studio, Netezza, Hive

Languages: SQL, PL/SQL, HTML, API Java Script, Python

Applications: MS Office, MS Excel, Outlook, PowerPoint, Pivot, Eclipse, GitHub

Packages / Tools: Toad Data Analysts 3.1, Aginity Workbench, Google Analytics, Alteryx, Putty, Rally, JIRA

Operating Systems: Windows XP/7/8, UNIX.

PROFESSIONAL EXPERIENCE

DATA ANALYST

Confidential, WESTLAKE- TX

Responsibilities:

  • Gathering the requirements and documentation for existing and future business systems and working with the Business Unit to define business requirements and analyze the possible technical solutions.
  • Created mockup designs for the users and various dashboards on Tableau desktop based on the data by importing and data blending from MS EXCEL, .CSV, Oracle database.
  • Developing visualizations on Tableau Desktop like line graphs, doughnut charts, stacked bars for the project Incident Management.
  • Developed actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau
  • Worked on the enhancements on dashboards and validating the data on Oracle (DIPIT) to match the Servicenow Data and created charts by using Pivot Tables.
  • Worked on HTML, API Javascript and Angularjs for tableau filters on web applications.
  • Scheduled data refresh on Tableau server for hourly and also for extract data sources.
  • Involved in providing access to the users on Tableau Server to view and edit the dashboards.
  • Used Alteryx for creating workflows using unstructured data.
  • Developed and published user security dashboards on server.
  • Creating JIRA tickets and working on the issues during UAT testing.
  • Involved in scrums meetings and daily stand up meetings with the team and users.

Environment: TableauDesktop 10.3,TableauServer, Tableau API JavaScript,Servicenow, Oracle, MS Excel, JIRA.

TABLEAU DEVELOPER

Confidential, DALLAS-TX

Responsibilities:

  • Currently working on Proof of Concepts (POC) presentation and review with project and IT lead along with developing Tableau Dashboards.
  • Develop, Organize, manage and maintain graphs, tables, slides and document templates for the efficient creation of reports.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scatter plots, geographical maps, Gantt charts using show me functionality.
  • Experienced with other BI tools like Cognos & Netezza.
  • Cleanse and normalize data in MS Excel by combining from various data sources.
  • Involved in creating dashboards by extracting data from different sources and writing custom SQL queries on Tableau Desktop.
  • Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
  • Tested dashboards and queries in database to ensure data was matching as per the business requirements and if there were any changes in underlying data.
  • Worked on SDK python for data processing and data manipulation.
  • Reviewed basic SQL queries and edited inner, left, and right joins inTableauDesktopby connecting live/dynamic and static datasets.
  • Attended agile meetings, daily standup calls and interact professionally with diverse group of professionals in the organization including managers and users.

Environment: TableauDesktop 10.0,TableauServer 10,MS Office Suite,Aginity Workbench, Netezza, MS Excel, JIRA.

TABLEAU DEVELOPER

Confidential, LAFAYETTE, LA

Responsibilities:

  • Involved in reviewing business requirements andanalyzingdata sources from Teradata for design, development, testing, and production rollover of reporting and analysis projects withinTableauDesktop.
  • Created Users, Groups, and sets in Tableau environment.
  • Combined views and reports into interactive dashboards inTableauDesktop that were presented to Business Users, Program Managers, and End Users.
  • Loaded data from disparate sources into PowerPivot, Created relationships, formulas and hierarchies.
  • Build reports and dashboards based on the relationships created in PowerPivot and performed model enhancements to improve report readability.
  • Scheduled data refresh on Tableau Server for weekly and monthly increments based on the new changes to ensure that the views and dashboards were displaying the changed data accurately.
  • Implemented various data connections from data source to Tableau Server for report and dashboard development and guided navigation links for Interactive dashboards in Tableau.
  • Developed metrics, attributes, filters, reports, dashboards and also created advanced chart types, visualizations and complex calculations to manipulate the data.
  • Used multiple Measures like Individual Axes, Blended Axes, and Dual Axes and designed interactive dashboards in Tableau Desktop and published them to Tableau Server.
  • Daily use of reporting, analytics, including but not limited to Google Analytics and to ensure proper reporting in Google Analytics for QA tagging across all campaigns.
  • Extensive experience in writing SQL queries on Teradata to validate the data to compare the data in database and tableau report and data given by users.
  • Worked on UAT changes and updated User Stories on Rally according to business requirements.
  • Involved in Agile Methodology, daily status call with users and team.

Environment: TableauDesktop 9.0,TableauServer 9,MS Office Suite,Teradata, Toad Data Analyst, MS Excel, RALLY.

TABLEAU DEVELOPER

Confidential, FOSTER CITY, CA

Responsibilities:

  • Involved in reviewing business requirements andanalyzingdata sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects withinTableauDesktop.
  • Created views inTableauDesktop that were published to internal team for review and further data analysisand customization using filters and actions.
  • Created dashboard using parameters, sets, groups and calculations and complex dashboards.
  • Created drill down and drill up in worksheets.
  • Assisting users in creating and modifying worksheets and data visualization dashboards.
  • Experienced using Hive database for POC project and Creating reports with user security.
  • Created report schedules on Tableau server.
  • Combined views and reports into interactive dashboards inTableauDesktop that were presented to Business Users, Program Managers, and End Users.
  • Used Github to share the tableau reports and required documentation with the team.
  • Working knowledge on SSRS for reporting and data visualization
  • Reviewed basic SQL queries and edited inner, left, and right joins inTableauDesktopby connecting live/dynamic and static datasets.
  • Perform UNIT testing and help the UAT testing team to performing various testing scenarios.
  • Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
  • Participated in daily scrum calls, reviews, and user groupdiscussionsas well as communicating with stakeholders and business groups.

Environment: TableauDesktop 9.0,TableauServer 9,MS Office Suite,Oracle SQL Server, TOAD, MS Excel, JIRA

SOFTWARE DEVELOPER/ BUSINESS ANALYST

Confidential

Responsibilities:

  • Gathered and documented business requirements for existing and future business systems.
  • Worked with the business unit to define business requirements and analyze the possible technical solutions.
  • Responsibilities included requirement gathering, business process flow, business process modeling and business analysis.
  • Designed and developed project document templates based on SDLC methodology.
  • Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and Collaboration Diagrams.
  • Conducted workflow, process diagram and gap analyses to drive requirements for the automation process.
  • Using detailed knowledge of application features and functions access scope and impact of business needs throughout analysis and completion of all enhancement specifications.
  • Worked on ETL workflows using Informatica.
  • Monitored ETL Jobs and created scripts to run the ETL jobs in Informatica.
  • Design and developed shell scripts to schedule data loading process to staging server.
  • Providing Support and Maintenance for all the clients.
  • Performed User Acceptance Testing (UAT) and describing the bugs to the development team
  • Coordinated between the on-site coordinator and development team at Offshore to derive correct requirements for the product
  • Responsible for directing analysis and need assessments to get the present manual medical records and translates them to Electronic Health Records.
  • Helped to develop a Knowledge Management (KM) portal subsystem, for doctors to keep abreast of the latest
  • Evolutions.
  • Understood the Business Logic, User Requirements and test-objectives to develop Use Case, Test plans, Test
  • Cases, Scenarios to reevaluate the Business Process and models.
  • Co-authored detailed Business requirement document (BRD) and Functional architecture and solution specification Document.

Environment: UNIX, Oracle 9i, MS Access, MySQL, MS Office Suite.

SQL DEVELOPER

Confidential

Responsibilities:

  • Communicated with clients regarding system requirements, ensuring the development and implementation of customized products to customer satisfaction
  • Preparedfunctional specificationsfor user requirements.
  • Experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions, packages to implement business logic.
  • Developed and modified applications, authored database procedures and triggers for data processing.
  • Createdentry forms/reportsfor various modules. Createddatabases, loaded initialization data, generated users, and assigned rolesandaccess.
  • CreatedTables, Indexes, Table Spaces, Views synonyms,andintegrity constraints.
  • Involved in creation ofschema objects, rolesandprivileges, users.
  • PreparedUser manual, Technical documentsfor the end user.
  • Prepared executable for system deployment and led the release of applications following
  • Experience in UNIX Environment in file transfers, job scheduling and error handling
  • Maintenance and support for the system. Involved inend user.

Environment: SQL, PL/SQL, Oracle, Windows XP, UNIX

We'd love your feedback!