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