Resume

Sign in

Data Analyst

Location:
Irving, Texas, United States
Posted:
November 16, 2018

Contact this candidate

Resume:

Rajeev J

Email:ac7puf@r.postjobfree.com

Mobile: 510-***-****

EXPERIENCE SUMMARY:

Data Analyst with 3 years of experience using machine learning algorithms, data mining, data manipulation and data visualization. Achievements include building data regression models to predict company sales with 25% more accuracy than historical average. Experience in Entire Software Development Life Cycle (SDLC). Strong working experience in Data Analysis, Data Validation, Data Verification and identifying data mismatch. Professional expertise includes systems applications, disaster recovery planning and information protection analysis. Experienced Computer Systems Analyst with diverse industry experience in healthcare, insurance and government. Good experience in Agile, iterative & Waterfall Environments.

TECHNICAL SKILLS:

Python, Teradata, Sci-Kit Learn, Pandas, NumPy, Matplotlib, Seaborn, Stats models, SciPy, ResearchPy, Statistical Analysis, Machine Learning Algorithms, SQL, Tableau, HTML, CSS, Advance Excel.

EDUCATION DETAILS:

Pursuing Ph.D. in Information Technology, University of the Cumberland’s, KY.

Master’s in Computer Science, Silicon Valley university, CA

Bachelor’s in Electrical and Electronics from JNTU, India

CVS Health, Irving, TX Oct 2017- Till date

Data Analyst/Business Analyst

Responsibilities:

Responsible for analyzing business requirements Worked with business analysts, senior project managers, and programmers to gather business requirements and specifications.

As part of this team I was involved in Retrieve data from Database and developing reports based on the business requirements.

Generating the reports for Teradata and Oracle Database to analyze the customer behavior and plan strategies to improve the response rates of marketing Campaigns.

Created Numerous Volatile, Set, Multiset, Derived, and Global temp tables.

Extensively used joins while extracting data from multiple tables.

Developed Teradata SQL scripts using various characters, numeric and date functions.

Improved performance while using performance tuning techniques like primary Index and collection statistics on index columns.

Hands on Experience in Writing Python Scripts for Data Extract and Data Transfer.

Strong Experience in writing Python programs for manipulating the data reading from various Teradata and convert them as one CSV Files.

Strong experience in using Excel & MS Access to dump the data & analyze based on business needs.

Worked with Excel Pivot Tables for various business scenarios

Performed Verification, Validation and Transformations on the Input data (Text files) before loading into target database.

Designed and developed weekly, monthly reports by using MS Excel Techniques (Charts, Graphs, Pivot tables) and Power point presentations.

Used MS Excel and Teradata for data pools and adhocs reports for business analysis

and developing Reports using PowerPoint, Excel to provide data analysis solutions to business clients.

Shore Infotech India Pvt Ltd, Hyderabad, India July 2013 – June 2015

Data Analyst/Specialist

Responsibilities:

Interacted with Business Users for gathering, analyzing, and documenting business requirements and data specifications.

Worked on numerous ad-hoc data pulls for business analysis and monitoring.

Designed and developed various monthly and quarterly business monitoring excel reports by writing Teradata SQL and using in MS Excel pivot tables.

Performed in depth analysis on data and prepared ad-hoc reports in MS Excel and SQL scripts.

Performed verification and validation for accuracy of data in the monthly/quarterly reports.

Developed Teradata SQL scripts using various characters, numeric and date functions.

Created multi-set tables and volatile tables using existing tables and collected statistics on table to improve the performance.

Developed Teradata SQL scripts using OLAP functions like rank and rank Over to improve the query performance while pulling the data from large tables.

Utilized ODBC connectivity to connect Teradata from MS Excel to automate the data pull and refresh graphs for weekly and monthly reports.

Experience in performing Dual Data Validation on various Businesses critical reports working with another Analyst.

Developed Python programs for manipulating the data reading from various Teradata and convert them as one CSV Files.



Contact this candidate