We provide IT Staff Augmentation Services!

Data Analyst Resume

Downers Grove, IL

PROFESSIONAL SUMMARY:

  • Over 8 years of IT experienceas Data Analyst and SQL developer
  • Expert in Statistical data analysis, data profiling and data managementfor large and complex data sets
  • Expert in Data Mining techniques: Data Preprocessing, Association analysis, Classification - Decision Tress and Naïve Bayes, KNN classification and Text mining
  • Expert in Star and Snowflake Data Warehousing using MSSQL Server DB, deploying CUBE using SSAS, ETL through SSIS and Informatica, performing OLAP tools and creating Reports
  • Proficient in Data Visualization techniques - creating pivot tables and dash boards (Tableau, Excel)
  • Expert in data retrieval, analysis, transformation,and reporting for Business Intelligence
  • Expert in Big Data Technologies, writing Hadoop MapReduce programs, HIVE and PIG
  • Expert in Star and Snowflake Data Warehousing using MSSQL Server DB, deploying CUBE using SSAS, ETL through SSIS and Informatica, performing OLAP tools and creating Reports
  • Expert in Big Data Science techniques: Collaborative filtering, Classification: Bayesian and Random Forest and Clustering: K-means, Hierarchical and Canopy
  • Excellent knowledge of designing and implementing databases including ER data modeling and physical design
  • Experienced in Iterative/waterfall/Agile/Scrum/XP development methodologies
  • Excellent communication, organizational and interpersonal skills
  • Proven ability to work efficiently in both independent and team environments

TECHNICAL SKILLS:

Databases: SQL, PL/SQL, Oracle (9i/10G/12C), T-SQL, MySQL, DB2, Teradata, PostgreSQL

Programming Languages: Java & C

Data Science: SQL, R, Python, Machine Learning

Data Analytics: R Studio, SAS, Tableau

Big Data: Hadoop, Cloudera, HDFS, MapReduce, Hive, Pig, Apache Spark, Scala

DW & BI: SSAS, SSIS, SSRS, Power-BI, Tableau, ETL, Informatica

Cloud-Computing: AWS, Azure, SaaS, PaaS, IaaS, XaaS

Design & Development: Visio,ERWin, UML, SQL Server Management Studio, Eclipse, Visual Studio, Oracle SQL Developer, Notepad++, Putty, WinSCP, GitHub, JIRA, MS Office, Excel, O365 and VMware.

Business Skills: SDLC, Scrum/Agile Development methodologies, Requirements Gathering, Team Management, Documentation, Data Governance

PROFESSIONAL EXPERIENCE:

Data Analyst

Confidential - Downers Grove, IL

Responsibilities:

  • Developed detailed business requirements and functional requirements
  • Performed data quality analysis and assessment
  • Evaluated data pulled from different sources for accuracy and relation to data requests
  • Developed statistical methods to evaluate and analyze numerical data using R studio, MS Excel, Oracle, SQL and Python for assigned projects
  • Developed analytical approaches and predictive modelling techniques for large and complex data for analysis, sampling and design
  • Developed reports to identify trends and patterns in data analysis through Tableau
  • Performed data profiling for accurate and better reporting and analysis
  • Created dashboards for data visualization through Excel, Tableau and Python
  • Developed advanced SQL queries with multi-table joins, group functions, subqueries, set operations stored procedures for data analysis
  • Created aggregates, hierarchies, filters and calculated measures
  • Designed and deployed reports with OLAP tools like Drill up, Drill down and Drill through
  • Providing expertise on data storage structures, data preprocessing, data mining and data visualization
  • Executed quality control checks in the form of SQL queries to ensure data integrity and enforce business rules
  • Summarize data into reports for product decision making

Data Analyst

Confidential

Responsibilities:

  • Extracted, compiled, tracked data and analyzed data to generate reports
  • Performed daily data manipulation using SQL and prepared reports on weekly, monthly, and quarterly basis
  • Used Excel functions to generate spreadsheets and pivot tables
  • Identified, analyzed and interpreted trends and patterns in complex data sets
  • Cleansing and blending multiple data sources to allow for different views on application data in a single dashboard
  • Performed data manipulation operations like import/export data from various external file formats using SQL
  • Generated variety of business reports from SQL Server using Excel with pivot tables and pivot charts
  • Checked for invalid/out of range data
  • Developed, updated and maintained current SQL programs
  • Acquired data from primary and secondary data sources and maintained databases/data systems

Junior Data Analyst

Confidential

Responsibilities:

  • Assisted Sr. Data Analyst in reporting and data visualization
  • Created reports and dashboards using Excel
  • Created SQL scripts to retrieve data for reporting
  • Performed statistical analysis in excel for reporting
  • Performed data cleaning and maintained data integrity
  • Designed, developed and maintained spread sheets for data analysis
  • Produced daily, weekly, monthly and quarterly reports
  • Documented client and user requirements

SQL Developer

Confidential

Responsibilities:

  • Gathered requirements for database design
  • Created conceptual data model to visualize database structure
  • Developed optimized SQL queries
  • Created database triggers for various projects
  • Created views, functions and stored procedures
  • Created logical data model from the conceptual model and its conversation into the physical database design
  • Developed various use case diagrams using MS Visio
  • Involved in modelling business processes through UML diagrams
  • Created documentation and test cases, worked with users for enhancements
  • Involved in designing and creating Tables, Views, complex Stored Procedures and Indexes using T-SQL.
  • Improved performance by optimizing queries.

Design Engineer

Confidential

Responsibilities:

  • Worked under Project Manager as design engineer
  • Coordinated with designing and planning under Architects and Senior Engineers
  • Prepared and documented project status reports
  • Worked on primavera for project estimation and billing for residential projects
  • Worked on critical path scheduling techniques

Hire Now