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