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