Data Analyst Developer

ADITYA DIXIT

CA 510-***-**** adjkmy@r.postjobfree.com

PROFESSIONAL SUMMARY

5+ years of experience in data analysis, data engineering, and statistical modelling, including data extraction, manipulation, visualization, and validation techniques, reporting on various projects.

Proficient in SQL databases DB2, MySQL, MS SQL, Oracle, and NoSQL databases MongoDB.

Strong development and support knowledge on Oracle, SQL, PL/SQL programming and creating objects such as Stored procedures, packages, functions, triggers, tables, and views.

Experience in writing Subqueries, Stored Procedures, Triggers, Cursors, and Functions on MySQL and PostgreSQL database.

Experience in Data Transformation, Metadata, Data Dictionary, Data Loading, Modelling, and Performance Tuning.

Experience implementing dashboards, data visualization, and analytics using Tableau desktop.

Experience in implementation of Data Clean-up Procedures, Transformation, Scripts, Stored Procedures, and execution of Test plans for loading the data successfully into Targets.

Good Knowledge of web services using SOAP and REST protocols.

Hands-on experience with bug tracking tools JIRA and Bugzilla.

Good Knowledge of SDLC, Waterfall, Test-driven development (TDD), and Agile/Scrum Methodologies.

SKILLS

Operating systems: Mac, Windows, Unix, Linux, RedHat, Ubuntu.

Programming languages: Python, C, C++, JavaScript, Shell, Power Shell.

Databases: Microsoft SQL Server, Oracle, MySQL, MongoDB, PostgreSQL.

Data Visualization: Tableau and Power BI.

Source Control: SVN, CVS, Git, GitHub.

Bug Tracking Tools: Bugzilla and JIRA.

Web Technologies: HTML, XML, CSS, AJAX, JavaScript, jQuery, PHP.

RDBMS: Oracle, MySQL, MS-Access,PostgreSQL, SQL Server, Teradata.

EDUCATION

Bachelor of Science : Computer Science

Pune University - Pune

Master of Science : Business Analytics

California State University - East Bay

WORK HISTORY

SR. DATA ANALYST 06/2020 to Current

Freddie Mac, CA

Automated the process to generate reports and dashboards by using Power BI .

Conducted activity-based analysis of business processes and made recommendations based on the findings.

Generated RTF, HTML, and PDF formatted files using the SAS Output Delivery System.

Experience working with Oracle SQL Developer and ORM (Django ORM).

Experience with ETL, SFTP/SSH, Unix/Linux, as well as Git or other version control systems.

Converted and built load files from CSV files using Oracle SQL Developer.

Worked on writing complex SQL queries in performing Data analysis using window functions, joins, improving performance by creating partitioned tables.

Wrote Subqueries, Stored Procedures, Triggers, Cursors, and Functions on SQL and PostgreSQL database.

Developed and executed HIVE queries for deformalizing the data.

Prepared dashboards with drill-down functions such as date filters, parameters, actions using Power BI to reflect the data behaviour over time.

Performed and documented unit testing and system testing of the entire ETL process.

Experience working with Agile and Test-Driven development (TDD) within the software development lifecycle (SDLC).

Participated in grooming backlog, daily scrums, retrospectives, and sprint reviews with product owner and technology partners to meet release timelines and adding business value.

DATA ANALYST 01/2020 to 05/2020

24 Hour Fitness, San Ramon, CA

Accurately performed maintenance Budget Forecasting for Equipment used in all 422 Gyms for next 10 years.

Eliminated pre-existing budget assessment methods that required a manual labour.

Gathered Pre-historic data from multiple sources by facilitating meetings with cross functional teams.

Extracted information from data ledger using MySQL Server and categorized 85% of unknown records using text mining and advanced excel VBA.

Used JMP to identify data dependencies and omit unrelated data to trim and normalize dataset.

Gathered requirements from VP and Director of facilities on a daily basis to create crucial data insights, KPI dashboards.

Streamlined their monkey survey reporting process by creating dynamic spreadsheets and reporting tool configurations.

Created PowerBI and excel dashboards to display daily assets summary for Ad-hoc analysis.

Created Geological Dashboard for all gyms HVAC systems giving visual information of all gyms across USA and assisting in suggestion for HVAC tonnage for new Gym clubs.

DATA ANALYST 07/2018 to 05/2019

CSU East Bay, Hayward, CA

Developed new web-based asset management system for the CSU (Web Checkout).

Reduced average item issuing time by 65% and User report generation time by 50%.

Prepared Business Process Models that include modelling of all the activities of the business from the conceptual to procedural level.

Followed top-down, levelled technique for building Business Process Models.

Extracted required data and built data model using Oracle SQL Developer.

Designed Use Cases and Use Case Models after accessing the status and scope of enhancement and understanding the business processes.

Helped the QA team in test case preparation and was actively involved in project management and resource planning in a SCRUM environment with bi-weekly release cycles.

Created complex SQL queries for accessing database during testing phase.

Acted as liaison between stakeholders and the developers.

Conducted user acceptance testing (UAT) and reported errors using JIRA.

Created OTBI Analysis reports regularly for inventory status of loaner laptops and other loaner items.

DATA ANALYST INTERN 09/2017 to 07/2018

Cigna Health Insurance, CA

Building KPI reports for the cubes and optimizing the reports. Ran SQL queries to verify the number of records and validated the referential integrity rules as per the design specifications.

Participated in the collection of business requirements from end-users and transferring them as reporting requirements for the Tableau platform.

Experience in Data Integration, Report development (MIS), and Data mining using SQL, Tableau & Excel.

Used Power BI Power Pivot to develop a data analysis prototype and used Power View and Power Map to visualize reports.

Installed MongoDB, configured, setup backup, recovery, upgrade and tuning and data integrity.

Developed ETL packages included the use and implementation of stored procedures, data conversions and error logging.

Worked on Jenkins to implement continuous integration (CI) and Continuous deployment (CD) processes.

Performed data analysis using SQL; conducted statistical analysis and built an analytical dashboard using SSRS and Tableau.

Involved in data cleansing to remove unnecessary columns eliminate redundant and inconsistent data by using SSIS transformations.

DATA ANALYST 01/2014 to 07/2016

BrightMind Technologies, Vadodara, GJ

Captured functional requirements from business clients along with IT requirement analysts by posing suitable questions, analysing the requirements by collaborating with team and system architects by following the standard templates.

Configured data extraction and scheduled incremental refreshes for data sources on Tableau server to improve the performance of reports.

Supported the team in planning activities for Data staging, development, and UAT activities.

Produced quality customized reports by using PROC REPORT, TABULATE, SUMMARY, and descriptive statistics using PROC MEANS, FREQUENCY, and UNIVARIATE.

Experience working with T-SQL, DDL, and DML Scripts and established Relationships between Tables using Primary Keys and Foreign Keys.

Hands-on experience in Using DDL and DML for writing Triggers, Stored Procedures, and Data manipulation.

Worked with star schema, snowflakes schema dimensions, SSRS to support large Reporting needs.

ACADEMIC PROJECTS

Black Friday Expenditure Prediction using JMP Neural Networks

Filtered a dataset with close to 500K transactions done in Black Friday Week 2018 using R-Programming.

Analysed the dataset using neural patterns acquired and predicted the expenditure a future customer would do using their parameters.

Prediction Engine using Sentiment Analysis (Sponsored Project)

Designed and prototyped a prediction engine that grabs real-time tweets and runs sentiment analysis on them automatically.

Tools used: Python IDE, Tweepy API, AWS, Shell Script.

.

Contact this candidate