We provide IT Staff Augmentation Services!

Data Analytics Lead Resume

San, JosE

SUMMARY:

  • Extensive experience in EDW: Business Intelligence domain, Reporting and ETL
  • 15+ years of experience with databases: Teradata, Postgresql, Mysql, Oracle and SQL Server
  • Extensive working knowledge of Tableau, Perl, Python
  • Led technical teams for Solution Development and Project Management
  • Flexible and versatile to adapt to any new environment with strong desire to learn new skills
  • Self - motivated with excellent organizational skills including ability to multi-task and prioritize and good interpersonal communication skills
  • Received multiple employee excellence awards
  • Industry experience in Consumer Products, Media, Payments and Financials

PROFESSIONAL EXPERIENCE:

Confidential, San Jose

Data Analytics Lead

Responsibilities:

  • Led and implemented analytics/reporting solution including data mart design, resulting in significant cost reduction and eliminated dependency on contingent resources
  • Automated data collection, parsing and pattern matching from various sources into Teradata, and generated analytics/dashboards using Tableau for Security data remediation and SLA reporting.
  • Developed ETL techniques to get data from various sources such as APIs, databases, JSON, csv and Github repository files via Python
  • Improved SQL query performance.

Environment: Tableau, Teradata, SQL, Python and Splunk

Confidential, Santa Clara

Business Intelligence Lead

Responsibilities:

  • Designed and implemented Data warehouse for reporting and analytics
  • Implemented analytics for proactive monitoring of disk failures, and improved customer experiences via PERL
  • Deployed operational reports/dashboard via Tableau to gain insight on product distribution, characteristics, sales activities, utilization for potential sales opportunities

Environment: Tableau, Informatica, Vertica, MySQL, Greenplum, SQL, Perl, Unix Shell Scripts, ETL, R, Hadoop, Pig

Confidential, San Jose, CA

Senior Consultant

Responsibilities:

  • Automation of parsing techniques to prepare data for DB activity related reports
  • Developed UI and interactive web application for DB related activities

Environment: Perl, Shell Scripts, JSP, Oracle, HTML, Javascript, Unix

Confidential, Palo Alto, CA

Sr. Reporting Engineer

Responsibilities:

  • Interactively worked with various functional area owners in gathering requirements, design and development of finance and billing reports and web reports for mobile carriers
  • Designed and developed portal for trending/statistical report for mobile carriers using Perl/CGI
  • Developed windows phone apps for Windows Phone 7 using C#

Environment: Perl, C#, Java, Oracle, SQL Server, PL/SQL, Powershell, Perforce, Linux, Windows Azure

Confidential, Redwood city, CA

Sr. Database and Reporting Engineer

Responsibilities:

  • Design and Implemented data warehouse for subscriptions, downloads, financial information

Environment: Perl, Oracle, Toad, PL/SQL, Perforce, Unix

Confidential, Milpitas, CA

Data Warehouse Engineer

Responsibilities:

  • Designed the dimensional database schema and implemented data-mart using Siebel Analytics
  • Created dashboards to provide insight into the data stored in the static analysis

Environment: Siebel Analytics/OBIEE, Perl, Oracle, PL/SQL, Erwin, HTML, JavaScript, CSS, Unix

Confidential, Palo Alto, CA

Database Engineer, Research & Development Group

Responsibilities:

  • Designed database model, analyzing for annotation tracking and prototype for interacting eBooks
  • Developed replication techniques using MobiLink for data synchronization

Environment: Sybase, SQL Anywhere, Sybase MobiLink, Sybase Powerdesigner

Confidential, San Mateo, CA

Sr. Software Engineer, Product Engineering

Responsibilities:

  • Analyzed customer reported Siebel product defects/issues and resolving them using Visual C++
  • Worked on customer specific UI and scripts customization using Siebel Tools.
  • Designed and developed custom reports using Actuate in Siebel products

Environment: Siebel, Visual C++, Oracle, MS SQL Server 7.0, Sybase, Windows, Sun Solaris

Hire Now