Data Analyst Resume Sunnyvale, CA - Hire IT People

PROFESSIONAL SUMMARY:

8 years of experience in database technologies.
Data processing competency, with Analytics and reporting skills to directly impact business metrics.
Database modeling experience in Oracle for finance applications.
Sales - Trend Analysis and reporting with campaign management system experience, in Unica with Teradata.
Database maintenance and Support - periodic index re-building, collecting table and index stats, monitoring user sessions/locks/waits on database, periodic password renewals of DB accounts.
Query tuning for performance boosting of Oracle jobs.
Experience in developing Schema migration solutions in MySQL.
Application Support for data transformations between Oracle and Mongo DB, with Kafka as middle-ware streaming system.
Shell Script automations for application health monitoring.
Root-cause Analysis for issues in CRM applications.
Big data specialization certifications with Data Analysis project experience.
Compliance to Information security practices

COMPETENCY MATRIX:

Relational modeling in Oracle and MySql
Semistructured modeling with JSON data in MongoDB
Vector Space Models
Graph Data Models
Streaming data models
Fine understanding of Hadoop 1.0 and 2.0 YARN architectures
Data processing and analytics with MapReduce programming using Python.
HDFS administration and performance tuning
Fine understanding of Spark architecture and framework
Analytics with Spark RDD, DataFrames, SparkSQL using Python.
Spark analytics on Jupiter Notebooks
Machine Learning using Spark MLLib
Data Exploration and Pre-processing techniques on KNIME and Spark
Model building/training and predictions using Spark MLLib and KNIME workbench
Classification Algorithms - Naive Bayes, Decision Trees, K-Nearest Neighbors
Regression - Linear Regressions
Clustering - K-Means Clustering
Association Analysis algorithms
Fine understanding of Splunk's architecture.
Splunk queries, regular expressions, saved searches and dashboards
Columnar DataStores - HBASE
Hadoop SQL integrations - Hive
MapReduce Scripting - PIG
Hadoop Relational data ingestions - SQOOP
Coordination and stack management - Zookeeper
Extensive understanding of Oracle's DBMS architecture
5+ years of programming experience in Oracle PLSQL
Design tables/views
Procedures/Packages/Functions/Triggers
DBMS Job schedulers
Query/Performance tuning for Oracle SQLs
Data replication techniques - Streams/Golden Gate
SQLLoaders, Oracle Import/Export utilities.
Programming experience in MySQL
Design tables/views
Procedures/Packages/Functions/Triggers
Good understanding of Mongo architecture.
JSON Data modeling for Mongo
Mongo Queries and reporting.
Mongo MMS Console utilization for DB monitoring
Import/Transform/Load csv data to graph nodes and edges.
Path Analytics, Connectivity Analytics, Centrality Analytics, using Cypher queries for graphs
Community Analytics - Static, Temporal and Predictive
Good understanding of the Unix system.
Strong with Unix File System commands and Shell Scripting.

TECHNICAL SKILLS:

Ticketing: Espresso, Radar, ServiceNow - CentralStation

Monitoring: Hubble, Splunk

Deployment: Jenkins, Devops, Jumbotron

DB: Versioning Flyway

Code versioning: SVN, Git

Database: IDEs SQL Developer, RoboMongo, SEQUEL-PRO, Neo4j

Application Servers: Weblogic, Jetty

PROJECT EXPERIENCES:

Confidential, Sunnyvale, CA

Data Analyst

Responsibilities:

Exploratory Data Analysis using Splunk.
Machine Learning analysis using KNIME, Spark's MLLib
Reporting/Business presentation with recommendations

Confidential, Sunnyvale, CA

Production Support Specialist

Responsibilities:

Monitor DB Health - To keep a watch on DB session health, locks and waits
Suggest and implement database performance tuning techniques.
Watch for host performance parameters such as CPU, FSU and SWAP and act on escalations
Perform Weblogic/Jetty deployments for application releases
Emergency bug fixes and data corrections for user reported issues.
Ensure stability and availability of Production systems 24/7
Deploy Weblogic/Jetty applications

Confidential

PLSQL Developer

Responsibilities:

Collect expansion requirements of the system from the client and carryout feasibility analysis.
Design the system as per the requirement specifications
Developing procedures and packages and other Oracle objects for the system and Unit Testing
Integration Testing and User Acceptance testing support.
Production rollout for the new changes and warranty support.
Proposing new enhancements to the system and accomplishment of such enhancements.
Maintaining the data integrity in the system and adding value additions to the system.

Confidential

Campaign Management User

Responsibilities:

Build and Execute Confidential in Affinium Unica.
Provide periodical Sales-Trend Analysis to the clients.
Maintaining and executing periodically scheduled Confidential .
Providing technical assistance to clients in Email Campaigning for Confidential products

We provide IT Staff Augmentation Services!

Data Analyst Resume

Sunnyvale, CA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship