We provide IT Staff Augmentation Services!

Senior Data Analyst Resume

5.00 Rating

Dallas, TexaS

SUMMARY

  • Nine 9(+) years of experience in IT industry with a strong background in Analysis, Design and Development in the field of Database and implementation of Business Intelligence applications.
  • Experience with the BI tools Tableau, Tibco Spotfire Professional and Business Objects.
  • Experience with BASE SAS, SAS SQL, SAS/MACROS and SAS/ODS in UNIX Environment.
  • Programming Experience in Basic SAS with different Procedures like Proc SQL, Proc Report, Proc tabulate, Proc Print, Proc Sort, drop, keep, retain, and date manipulations, formats and SAS EG etc.
  • Experience with Cloudera Hadoop Echo system tools and databases HDFS, Sqoop, HBASE, HIVE, PIG and Map Reduce
  • Experience in creating Complex Tableau Visualizations and Spotfire Dashboards.
  • Good Experience in Data analysis, data extraction using SQL.
  • Experience with SAP HANA and HANA Studio.
  • Experience with Microsoft reporting tools SSRS.
  • Experience with Job Scheduling tools Autosys and Control - M.
  • Experience with PL/SQL procedures, Stored Procedures in Netezza, Functions and Triggers.
  • Strong Experience with tableau server, security access, publishing the dashboards and access control.
  • Expert in Writing SQL Queries on Oracle, Netezza, Microsoft SQL Server, Teradata, MS Access and DB2.
  • Created various Reports using Tableau and involved in Performance tuning.
  • Knowledge in Data warehousing Concepts in OLTP/OLAP System Analysis and developing Database Schemas like Star Schema and Snowflake Schema for Relational and Dimensional Modeling.
  • Extensively worked on Relational Databases like Oracle 11g/10g, IBM Netezza, Teradata, MS SQL Server, Sybase, Access, DB2 and database access tool TOAD, Rapid SQL and Aginity.
  • Domain Knowledge in Banking and Financial, Mortgage, Manufacturing and Utilities.
  • Experience on ETL tools like Informatica Power center, workflow manager and workflow Monitor.
  • Good Programming Experience in COBOL, DB2 and JCL.
  • Proven ability to understand business problems and able to apply technology to formulate workable solutions with excellent Interpersonal and Communication Skills.
  • Ability to write and maintain technical documentation to describe Reports development, logic, coding, testing, changes, and corrections.

TECHNICAL SKILLS

Business Intelligence Tools: Tableau 6.0,8.1,9.1,Tibco Spotfire Professional 3.2,3.3,4.0,5.5,6.5,Spotfire Web playerBusiness Objects X2, X3

Servers: Application Servers (WAS, Tomcat), Web Servers (IIS, HIS, Apache).

Operating Systems: Windows 7/VISTA/NT/ XP/ ME/ 2000/, UNIX.

Databases: IBMNetezza, SQLServer, Sybase, Oracle11g/10g, Teradata, SAP HANA, Hbase, Hive, MS Access and DB2.

Programming Languages: SAS, C, C++, SQL, PL/SQL, COBOL, XML.

PROFESSIONAL EXPERIENCE

Confidential

Senior Data Analyst

Responsibilities:

  • Gathered Business requirements and perform data analysis and reporting.
  • Responsible for consolidating the reports and re writing the SAS programs.
  • Extract the data from SAP HANA views, Teradata and various RDBMS data bases.
  • Expert in writing the SQL quires against Oracle, SAP HANA, Netezza, Teradata and DB2.
  • Identified data anomalies and reported the issues for the business to correct.
  • Used SQOOP to copy the data from RDBMS to Hadoop Hive and experience with HDFS commands.
  • Created Hive tables, Partitioning and performance tuning.
  • Utilized Teradata utilities Fast Load, Fast Export and Multi load for loading and Exporting data to Teradata tables.
  • Extracted data from various data sources using Pass through SQL, created macros, exported and imported data into SAS, created PROC sort, email automation etc.
  • Experience with various formats and date maupulations and sas functions.
  • Build and enhanced Tableau dashboards and created and scheduled the data sources.
  • Experience in SQL performance tuning.
  • Working with Teradata utilities BTEQ for DDL and DML operations.

Environment: SAS, SAS EG,Tableau9.2, SAP HANA, Hadoop Hive, HDFS, SQOOP, Teradata, Teradata SQL assistant, SAP HANA Studio,DB2,Control-M

Confidential, Dallas, Texas

Senior Business Analyst

Responsibilities:

  • Gathered Business requirements and designed technical requirements documentation.
  • Involved in data analysis and Data reporting.
  • Responsible for gathering the requirements from Business, Analyze and build the SQL query to extract the data from various data bases Oracle, SQL server and Netezza using Toad and Aginity.
  • Extracted data from various data sources using Pass-through SQL, created macros, exported and imported data into SAS, created PROC sort, email automation etc.
  • Consolidated several reports in a business group into a single Tableau dashboard for both Managerial and Analysts use.
  • Used Hadoop Open system tool SQOOP to Export the data from RDBMS systems Oracle, Netezza to HDFS.
  • Experience with processing tools Hive, Pig and Knowledge on Map reduce using Java programming.
  • Experience in copying the data from different RDBMS systems using Informatica.
  • Published dashboard to Server and involved in Access controls. Worked with Filters, calculated columns etc.
  • Experience with data blending, sets, context filters, parameters etc.
  • Involved in Performance tuning of Tableau reports and Scheduling.
  • Experience with Complex Filters, Action Filters, Sets, calculated Fields, Parameters etc.
  • Created various complex Cross tables, Bar Charts, Line Charts and Tree map and Geo Maps.
  • Created Data sources for Report creation.
  • Customized data by adding Property Controls, Filters, Calculations, Summaries and Functions.
  • Created Information Links By using Information Designer to pull the data from Oracle Database and SAS data sets required to create the reports.
  • Created stored procedures in Netezza for Performance Improvement.
  • Used Automation Job Service Builder to Export DXP file during Migration Process.
  • Developed reports using Spotfire Professional and published the same to Spotfire Server for Business Users use.
  • Experience in Writing SQL Queries.
  • Worked on Tableau and Hadoop integration.
  • Created various prototypes and showed them to the users.
  • Created Action Controls using Python Scripting.
  • Experience in enhancing the visualizations using Custom expressions.
  • Experience in creating Bookmarks.
  • Experience in Handling Multiple data tables in Analysis.
  • Converted Various Excel, Tableau and BO Reports to Spotfire.
  • Conducting Unit testing of the reports developed in Spotfire Professional.
  • Responsible for the migrating the reports from Development to Acceptance / Production Server.
  • Worked on developing training program, user guide for Spotfire Professional and Spotfire web player in terms of best developing and design practices.

Environment: Tableau6.0, 8.1,9.1, Microsoft SQL Server, SAP HANA,IBM Netezza, MS Access, Aginity, Sybase, Rapid SQL,SAS,SAS Enterprise Guide, Autosys,Humming bird, Hive, Sqoop, Cloudera Hadoop echo systems. Informatica Power center 9.2.Spotfire professionals 3.2, 4.0, 5.5, 6.5, Spotfire web player, Spotfire enterprise player, Business objects, Oracle 11g, SAS, and Toad.

Confidential, NJ

Senior Data analyst

Responsibilities:

  • Created various complex Cross tables, Bar Charts and Line Charts.
  • Created Data sources for Report creation .
  • Customized data by adding Property Controls, Filters, Calculations, Summaries and Functions.
  • Created Information Links By using Information Designer to pull the data from Oracle Database required to create the reports.
  • Developed reports using Spotfire Professional and published the same to Spotfire Server for Business Users use.
  • Experience in Writing Complex SQL Queries.
  • Created various prototypes and showed them to the users.
  • Experience in enhancing the visualizations using Custom expressions.
  • Experience in Handling Multiple data tables in Analysis.
  • Conducting Unit testing of the reports developed in Spotfire Professional.
  • Responsible for the migrating the reports from Development to Acceptance / Production Server.

Environment: Tableau 8.0, Spotfire professionals 5.5, Spotfire web player, Oracle 10g, Teradata, Toad

Confidential

Spotfire Consultant

Responsibilities:

  • Gathered Business requirements and designed functional and technical requirements documentation.
  • Created various complex Map Chart, Cross tab Reports and Chart Reports.
  • Customized data by adding Property Controls, Filters, Calculations, Summaries and Functions.
  • Established Database Connection and Created Dashboard file (DXP) in Spotfire Server.
  • Developed reports using Spotfire Professional and published the same to Spotfire Server for Business Users use.
  • Experience in Writing Complex SQL Queries.
  • Experience in enhancing the visualizations using Custom expressions.
  • Experience in creating Bookmarks, Tags and Lists.
  • Experience in Handling Multiple data tables in Analysis.
  • Knowledge on Information Designer and Creating Information Links.
  • Created reports using Tableau and Involved in Performance tuning.
  • Worked on IBM Optim tool to Extract and Load the data from Production to Development Environments.
  • Worked on developing training program, user guide for Spotfire Professional and Spotfire web player in terms of best developing and design practices.

Environment: Spotfire professionals 3.3, Spotfire web player, Spotfire enterprise player, DB2 9.5SQL Server.

Confidential

BI Developer

Responsibilities:

  • Interacted with the Business users and documented their Query, Business and Reporting needs and Analyzed the data and Business logic underlying the requirement.
  • Created Reports /Visualizations using Tableau Desktop and published them on the Server.
  • Created Bar charts, Line Charts and tabular visualizations.
  • Used various complex expressions to create calculated columns used in the reports.
  • Published the Reports on the server for Tableau Readers and granted tab level access.
  • Experience in writing Complex SQL Quires.
  • Established data source connections from Oracle.
  • Unit testing of all the reports.
  • Created various prototype visualizations and Demoed to the Users.
  • Worked on developing training program, user guide for Tableau desktop and Tableau Reader in terms of best developing and design practices.

Environment: Tableau 6.0, Tableau Reader, Oracle 10 g, Excel

We'd love your feedback!