SUMMARY

Expert knowledge in Datawarehousing, ETL, BI, and Web Analytics.Experience with open stack development, QA frameworks and Hadoop.Strong skills in coding and QA automation scripting.

TECHNICAL SKILLS

• Datawarehouse Experience: ETL, OLAP, BI, Data Modeling, QA
• Programming Languages: Hive/SQL,C/C /Java,Python/Perl/Ruby/PHP/Bash
• Databases: Oracle,SQLServer,Teradata,MySQL,Postgres,Hive
• App/WebServers: JBoss/Tomcat,Tableau,MicroStrategy,Pentaho,Omniture
• QA Frameworks: JUnit, TestNG, DbUnit
• Operating Systems: UNIX: Solaris, AIX, HP-UX, Linux Redhat, Centos, Ubuntu and other variants Windows: NT, Mac OS X

PROFESSIONAL EXPERIENCE

Confidential

Senior BI/ETL Test Engineer.

• Automate QA using Hive HQL, Oracle SQL, Groovy and Python scripts for Lending Club Data Services Department in an Agile/Scrum environment.
• Design and code SQL to validate Source to Target Mappings.
• Code Regression tests to verify ETL migration from Postgres to Hadoop.
• Code API Tests for RESTFUL Services for LC Monthly Statements.
• Develop Analytical SQL queries to validate Tableau BI Reports.
• Automate QA tasks using Hive HQL, Oracle and Postgres SQL, Groovy, and Python scripts.
• Write QA Test Plans.

Environment: Hadoop, Hive, Oracle, Postgres, Tableau, Centos, Java, Groovy, Python.

Confidential

Senior QA Lead.

• Automate QA using SQL, BTEQ, Perl, and Shell scripts for GAP Global FLashboard BI project in an Agile/Scrum environment.
• Design and code SQL to validate 120 simple and derived BI Sales/Revenue metrics.
• Develop Analytical SQL queries to validate MicroStrategy BI Reports.
• Automate QA tasks using Teradata BTEQ, SQL, Perl and Shell Scripts.
• Code custom ETL used for MicroStrategy BI cubes using BTEQ and SQL.

Environment: Teradata 13, SQL Assistant, MicroStrategy 9.2, Excel, AIX, Windows 7.

Confidential

Senior ETL Developer.

• Develop ETL and RESTful API for Salesforce data.com BI Datawarehouse in an Agile/Scrum environment.
• Design and code ETL for Data.com Datawarehouse using Kettle and MySQL procedures.
• Develop Java-based RESTfulAPI inPentaho/Kettle.
• Develop and integrate web Omniture API in Pentaho/Kettle.

Environment: MySQL 5.5, Apache HBase, SQL Workbench, Pentaho PDI, MicroStrategy 9.3, Ruby 1.9, Rails 3.2, Java 1.7, Perl, Shell Scripts, XML, SOAP, REST, JSON.

Confidential

Database QA Engineer.

Develop QA automation scripts in SQL, Ruby, and Shell/TCL scripts for GAP new Order Management Datawarehouse.

• Design and code SQL validation for Gap Order Management Datawarehouse using PL/SQL.
• Develop Analytical SQL queries to validate MicroStrategy Reports.
• Automate QA tasks with Ruby and Shell scripts.

Environment: Oracle 11g, Toad 11.0, MicroStrategy 8, SQL, Ruby 1.9, Shell Scripts, TCL/Expect.

Confidential

Database QA Engineer.

Develop SQL reports and scripts to validate Intuit internal Visa Card database and measure Email campaign effectiveness and conversions.

• Design and code SQL validation for Intuit Consumer Money Card daily loads.
• Validate Email Campaign data with Responsys email vendor data.
• Validate site traffic and email campaign data in Omniture SiteCatalyst with backend Netezzadatawarehouse. Develop queries for Omniture datawarehouse and validate results with Omniture SiteCatalyst including visits, visitors, pageviews, conversions, and custom events.
• Create pivot queries in Netezza DWH to for campaign marketing effectiveness and conversion reports.

Environment: Oracle 11g, Netezza Release 6, SQL Developer 3.0, Aginity Workbench 2.1, SiteCatalyst v14, SQL, Perl, Java, Shell Scripts.

Confidential

Data Warehouse Engineer QE

Develop QA automation SQL/Perl scripts for validating ETL processes and BI reporting for Yahoo advertiser reporting datawarehouse. Smokes, Regressions, Black Box/Grey Box testing.

• Design and code PL/SQL and Perl scripts for testing ETL processes of multi-dimensional datawarehouse comprised of several hundred facts/dimensions used for advertiser reporting.
• Perform statistical database profiling of source data, range, max, count, outliers.
• Analyse data requirements and design rule-based software to validate and flag source data.
• Design and code TestNG functional validation tests for Mondrian BI reporting application using Java web API.
• Design and code web services automation using Perl SOAP and web API.
• Participate in design reviews of datawarehouse ETL and modeling.

Environment: Oracle 11g, SQL Developer, Eclipse, Mondrian 3.0, Perl, Java, PL/SQL, Hadoop, PIG, MDX, SOAP/XML, XQuery, JBoss 7, TestNG, Bugzilla, SVN.

Confidential

Unica Consultant

• Setup and configure UnicaNetInsight for web analytics and Unica campaign management reporting.
• Code preprocessing scripts for web logs to filter out robots, cookie parsing, and base64 transform.
• Setup and configure Unica Campaign Management, A/B, and multivariate testing for marketing department.
• Setup and configure UnicaNetInsight for over 200 websites.
• Reason for leaving: fulfilled contract.
• Integrate customer profiles into UnicaNetInsightdatamart for reporting.

Environment:Unica 8, SQL server 2008, TSQL, Windows PowerShell.

Confidential

Data Warehouse ETL/Developer

• Analyzed, designed, developed, tested and implemented ETL processes, programs, and scripts for the Guess Loyalty CRM DW. Used PL/SQL, SQL Loader, XML, XQUERY, XSLT, XPATH, SQL Server stored procedures, and Shell Scripts on Windows and UNIX environments. Developed data and metadata models using ERWIN.Implemented work scheduling using Autosys/SQL Server Agent Jobs.Provided technical support.
• Reason for leaving: was brought in to fill in for someone who was on an extended leave.
• Design logical and physical model for CRM datamart for Guess loyalty program using Erwin r7.
• Map data and design transformations from SQL server source to Oracle.
• Code ETL extraction scripts using SQL Server 2008 stored procedures and Oracle PL/SQL.
• Assist DBA in fine tuning SQL Server and Oracle extract queries and recommend indexes.
• Write SQL diagnostics on SGA and shared pool in Oracle 10g to resolve out of memory MicroStrategy error.
• Provide technical support to Guess Asia DW ETL production system.

Environment: SQL Server 2008 Management Studio, Oracle SQL Developer, DTS, PL/SQL, Bash

Data Warehouse ETL

• Predict cars at risk of high ERR Empty Return Ratio for Union Pacific RR client using data mining techniques.
• Reason for leaving: department was outsourced due to budget shortfall.
• Interfaced with IT and Car Management teams to collect Empty Return Ratio business causes and requirements.
• Analyzed UP transportation database and translate business requirements into data requirements.
• Correlated car empty miles with transportation factors such as reservations, assignments, and directional loading.
• Coded custom ETL custom scripts to extract data from Teradata V2R6 and Oracle 10g.
• Predicted High ERR cars using heuristics and data mining techniques. Deployed daily actionable Excel reports to Car Management resulting in potential savings of 50K empty miles per day.

Environment: SQL 99, Clementine 12.0 ,Weka 3.5, Oracle 10g, Teradata V2R6, Java, Excel 2007, Oracle PLSQL Developer 7.1, Teradata SQL Assistant 7.1

Data Warehouse ETL

• Created design and implementation solutions based on Unica Web Analytics system at Slacker for reporting on site metrics and campaign ROI.
• Reason for leaving: start-up company, laid off due to funding issues.
• Interfaced with Engineering, Accounting, Marketing, QA, and IT teams for data reconciliation and validation.
• Configured and Administered Unica'sAffiniumNetInsight product and data warehouse for Slacker website. The system processed over 5 million page views per day and stored over 2 TB of weblog data using an Oracle 10g backend.
• Developed custom visit sessionizer using object-oriented Perl. The algorithm buckets weblog requests by visitor based on session cookie stored in flash object. The sessionizer parses large data sets and pre-fills the cookie parameter field in weblog requests before handing off to NetInsight Update module.
• Created custom SQL and pivot reports to measure stickiness, visitor to listener conversion, tracks plays, session length, visitor Dollar value, and various ROI metrics for CEO and Marketing Department.
• Responsible for merging, analyzing, and correlating page and Ad click-through data and return rates with demographics, sales, and shopping cart data to calculate buyer propensity and recommend Ad design and placement.
• Published Organic and Paid referrals and sales by referrer reports for Ad campaign effectiveness.
• Constructed trending and forecasting summary reports using Excel with ODBC-connected Oracle back-end.
• Specified Unica's based JavaScript tags for tracking flash and WMP media file usage/download.
• Aggregated daily metrics data for high-performance reporting using Oracle Stored Procedures.
• Fine Tuned Oracle SQL queries using Oracle's TKPROF and Explain Plan.

Environment: UnicaNetInsight, Oracle 10g, SQL, DW, ETL, Perl, Web Analytics, Excel, ODBC, Shell

Data Warehouse ETL

• Created customized solutions for enterprise web analytics reporting data warehouse system using UnicaAffiniumNetInsight 7.2 and MicroStrategy BI for clients in health, medical, e-Commerce, entertainment, financial, telecom, and manufacturing sectors.
• Reason for leaving: laid off, the company ended product line which this position was supporting.
• Senior Implementation Consultant/Data Warehouse Developer
• Implemented SPSS Web Analytics data warehouse at client's sites. Creating specifications to properly size and design Oracle and SQL Server databases for optimal performance. Script database Indexes, Partitions, and Stored Procedures, ETL, and audit procedures. Document procedures for managing daily data growth, expiration, and aggregation. Detail requirements for database hot and cold backups for over one TB databases.
• Interfaced with business users to collect business reporting requirement and map business attributes in MicroStrategy metadata to data warehouse entities.
• Documented design and post engagement maintenance procedures.
• Worked with Development team and Oracle DBA to resolve and manage high-volume database performance, recovery, error, and locking issues. Setting database events and trace file dumps.
• Integrated customer databases with NetGenesis Web eDatamart using custom ETL Oracle PL/SQL, Stored Procedures, Perl, and Unix Shell scripts to map, validate, cleanse, and transform data.
• Prepared data for SPSS Data Mining team at AOL Customer Retention Department and automate scoring and categorization of large volume of customer feedback messages over 6 million . Designed and coded ETL scripts using Shell Scripts and Perl.
• Incorporated demographics, historical, and user profile data into Clementine using Visual interface that is used to score the data mining model and discover clustering parameters. Predicted cancellation rate to within 10 of historic cancellation rate. The system used Clementine 8.0, Lexiquest 2.0, SPSS Reporter 13, Active Perl, C on Windows 2000, and Netezza ODBC version 3.5.
• Designed, constructed, and created OLAP-based online reports using MicroStrategy Desktop and InfraLens Reporter. This involved setting up MicroStrategy drilling hierarchies, facts, metrics, attributes, and filters.
• Administered all components of the NetGenesis and MicroStrategy OLAP toolset, including email, scheduling, maintenance, optimization, roles, security, patches, upgrades, and migration.
• Integrated visitor data with LDAP profiles for user and vendor identification systems using client side cookies to track marketing campaigns and specific customer segments.
• Designed and integrated MicroStrategy web reporting UI for Seagate Tiibco-based Portal development.
• Collected and managed high volume weblogs from multiple domains and multiple sites within a domain. Implemented parsers for IIS W3C, Apache Combined, and custom weblogs.
• Wrote and debugged JavaScript image tags for Washington Mutual client. Addressed issues such as on-page load, tag placement, query parameter keys, and byte limits.
• Designed and code of custom database to XML parser and web db access functions using Perl/CGI.

Environment: Microstrategy 7i OLAP and BI Reporting, NetInsight 7.2, Oracle 8i -10g, SPSS 12-14.0

Confidential

Senior Oracle DBA/Developer

• Key member for the design of database-driven streaming SMS messaging system. The project consists of processing near real-time web-based SMS messages with Oracle 8i.
• Reason for leaving: start-up company lay off due to funding issues.
• Administered Oracle 8i database using Embarcadero, TOAD, and Oracle Enterprise Manager.
• Responsible for modeling SMS database schema using Erwin.
• Coded Oracle SQL procedures for real-time high-volume transaction database 4K TPS .
• Optimized and tuned SQL queries.
• Assisted development staff with various duties as needed.

Environment: Sun Solaris 7, Oracle 8i, PHP 3.0.12, Apache 1.3.9, XML, Perl, TOAD, SQL, Shell

Confidential

Oracle Consultant

Reason for leaving: short-term contract, project completed.

Key member for the design and implementation of BD-Biosciences E-commerce project. The project consists of web-enabling five BD divisions product Catalogs and setting up site for internet e-commerce.

• Analyzed of pharmaceutical product lines.
• Designed database models.
• Set-up dual Sun 250 Servers.
• Installed and configured Oracle 8i Server, Apache Web Server, and PHP extension modules on Solaris 9 server.
• Coded PHP and HTML scripts using Oracle data access API.

Environment: Sun Solaris 7, Oracle 8i, PHP 3.0.12, Apache 1.3.9, XML, and Perl