SUMMARY:

• A globally experienced, multi - skilled, technical and functional Information Systems & Technology professional. Providing quality services in business applications analysis, design, development and implementation in full Systems Development Life Cycle. Familiar with Rapid Application Development and Agile Scrum methodologies, a Certified ScrumMaster (CSM). Knowledge, experiences and skills encompasses Data Analysis, Extract Transform Load, Data Warehousing, Business Intelligence, Quality Assurance,, Enterprise Resource Planning, Big Data, Data Science and Mobile Analytics.
• Versatile, flexible and possesses great ability to learn quickly. Strong analytical, diagnostic and problem solving ability. Excellent organizational, leadership, management and inter-personal skills.
• With solid quantitative foundation, an aptitude for programming, and infinite intellectual curiosity.
• Proven ability to interpret user requirements, develop specifications, design and develop custom applications and solutions. Possesses initiative and high attention to details. Passionate about Quality.
• Strong data analyst. Skillful in analyzing data for trends, anomalies, patterns and creating reports and data visualizations.
• Excellent presentation and communication skills. Excellent trainer, facilitator and mentor.

TECHNICAL SKILLS:

Operating System Environments: Windows, HP-UX, IBM AIX, Sun Solaris, Linux, Cygwin

ERP: SAP ECC: WM SD MM PP HR BW FI CO BASIS ABAP

BI, Reporting, Dashboarding, VisualizationOLAP Cube Tools, Analytics:Tableau, Oracle EPMS Fusion 11g, Hyperion Interactive Reporting 11, BusinessObjects, Cognos, Microsoft SSRS, Mobile Analytics, Datameer, Microsoft Excel Power View, Microsoft Excel PowerPivot

Data Integration, ETL: Informatica PowerCenter, Microsoft SSIS, Oracle Data Integrator, Talend Open Source Data Integrator, BODI, DecisionStream

RDBMS, OLAP, ODBC Compliant Databases, Big Data:Oracle12g, SQLServer, SSAS, Essbase, DB2, Access, MySQL, Teradata, Netezza, Apache Hadoop, Cloudera, Hortonworks

Web/Application Servers: BEA WebLogic Server, BEA eLink JAM (Java Adapter For Mainframe), Microsoft IIS, JRun, Apache, Tomcat, Node.js

Programming Languages And Development Tools: Cobol, Fortran, SQL, C, MDX, ABAP, Python, HTML, JavaScript, Java, VBScript, XML, Eclipse IDE, JSON, Caspio Bridge, AJAX, Node.js, jQuery, PHP, R, Octave

Productivity Tools, Scripting Shells: Microsoft Office (Project, Visio, Excel, PowerPoint), SharePoint,X-WinPro, SecureCRT, SSH, WinSCP, Perl, Windows/Unix/Linux Shell Scripting, PVCS, UC4, PerForce, JIRA, Toad, SQL Developer, Oracle VM

PROFESSIONAL EXPERIENCE:

Confidential, Redwood City, CA

Commercial Sales Operations Data Analyst/Architect, Tableau Developer & Administrator

Responsibilities:

• Developed BI reports and data visualization dashboards for Commercial Operations: Sales Calls, Prescribers, Prescriptions, DTC TV Commercials ROI, Sales-Territory Rankings, Return On Effort.
• Published dashboards to Tableau Server. Performed Tableau Server Administration.
• Processed weekly syndicated Commercial data: IMS, PDI, MedPro, HCP, SalesForce, Veeva data.
• Improved the system by automating and documenting the processes and designing and developing data marts, security access, user row-level access tables. Dell Boomi administration.
• Developed database table maintenance screens with HTML, JavaScript, JQuery, ADODB, Node.js, AJAX.

Environment: /Tools: Microsoft SQLServer Stack, Tableau Server and Professional 9, Hyperion IR, SFDC Veeva, MedPro, IMS, PDI, Dell Boomi.

Confidential, Palo Alto, CA

BI, Data Analyst/Architect, Tableau Specialist (Developer & Administrator)

Responsibilities:

• Developed Business Intelligence reports and data visualization dashboards for Faculty Research Analytics, s, Expenditures, and Faculty Productivity. Published dashboards to Tableau Servers.
• Implemented user filters and row level security. Interfaced with users to define requirements.
• Setup of Tableau Sites for use by other projects, teams and groups within the School of Medicine.
• Analyzed data for accuracy or anomalies. Testing and validation of data and dashboard functionalities. and mentoring of junior staff. Tableau Server Site Administration and maintenance.

Environment: /Tools: Oracle12g, Tableau Server and Professional 8/9, Hyperion IR, JIRA Agile Scrum.

Confidential, Emeryville, CA

BI, Data Analyst/Architect, Tableau Specialist (Developer & Administrator)

Responsibilities:

• Developed Business Intelligence reports and visualization dashboards for Clinical Trials and Studies, KPIs for Site selections, activations, screening and randomizations. Greatly aiding management and team members in the performance of the clinical trials and studies. Documentation with CRD.
• Installation, setup and administration of Tableau Server. Embedded Tableau into SharePoint.
• Developed application for clinical data submission and capture with Caspio Bridge into SharePoint.
• Developed Proof-of-Concept/Value application with Excel PowerPivot and Power View 2013.

Environment: /Tools: SharePoint, Tableau Server & Cloud, Desktop Pro 8.2, Caspio Bridge, Hyperion IR.

Confidential, Sunnyvale, CA

Mobile Analytics Senior Software Engineer (ETL BI Tableau QA Data Quality)

Responsibilities:

• Developed BI, analytics reports and visualization dashboards for Marketing: Business Insights, Customer Insights, Product Insights, Call Center reports and other areas for business and operations.
• Published Workbooks to Tableau Server and Motorola Mobile Analytics Portal. Tableau Server Administration. Created tabcmd scripts for triggering events, data extracts and reports refresh.
• Documentation - created and published standards and style guide for Tableau viz development.
• Created data models and database tables for use in reports and viz. Developed ETL processes. Provided production support for Motorola Mobile Analytics reports and portal.
• QA testing and data validation for accuracy, correctness and timeliness. Usability and UI testing of the Motorola Mobile Analytics Portal.

Environment: /Tools: Windows, Linux, Tableau Desktop 7/8, Tableau Server, Hyperion IR 11, Oracle11g, MySQL, Hadoop HDFS, HBase, Hive, HiveQL, Oozie, JobTracker, BigQuery, Datameer, JIRA, Talend OSDI.

Confidential, CA

Business Intelligence Analyst

Responsibilities:

• DoD SSBI Secret Clearance. Department Of Defense Contractor for the United States Department of the Navy, Command Fleet Readiness Center Southwest; created Basis For Measurement BFM (BRD) documents for the Executive Leadership Metrics Project. Documents will be used as basis in creating technical design specifications for building the BI dashboard and other ETL processes that may be required. Developed dashboard prototypes for the Enterprise Metrics using Tableau 7.

Environment: /Tools: NDMS CRS Enterprise DW, CAFIS, NAVAIR, Tableau, SAP BusinessObjects, Xcelsius.

Confidential

Senior SAP Technical Consultant, BI Consultant, Project Manager

Responsibilities:

• Worked on-site in Japan; as Scrum coach, imparted knowledge and experience on Agile Scrum software development methodology. Gave advice on English language and presentation skills to Japanese and Chinese team members. Advised BI team on best practices for developing reports and dashboards. Created Business Intelligence dashboard POV demos in Hyperion Interactive Reporting and Tableau.
• Developed GUI screen prototypes for NetWeaver Portal using NetWeaver Development Studio Eclipse IDE. Created NWDS Developer Guide and Tutorial. Created Change Management documents and evaluated change management and Agile Scrum software tools. Created SharePoint Server custom lists for project WBS and Change Management forms.

Environment: /Tools: SAP ECC 6.0, NetWeaver 7.2, Cognos10, SharePoint Server, Acunote Scrum, AVS.

Confidential, Santa Clara, CA

Business Systems Analyst, Apptio Technology Business Management (TBM) Lead Consultant

Responsibilities:

• Supported multiple, simultaneous Apptio implementation projects. Gathered functional and business requirements from customer and translated into a functional hosted solution design.
• Configured, developed, tested, and documented Apptio dashboards, reports and underlying data models to meet functional design and specifications.

Environment: /Tools: Cloud and on-premise instances.

Confidential, Foster City, CA

BI ETL QA Engineer

Responsibilities:

• QA tester for AB Initio ETLs and MicroStrategy Reports. Developed test plans, test cases and test scripts and reports for testing ETL and reports functionality, data accuracy and data quality.

Environment: /Tools: MicroStrategy, Ab Initio.

Confidential, Torrance, CA

Business Intelligence Analyst/Developer

Responsibilities:

• Developed reports and dashboards for Human Resources, Finance, Marketing and Sales applications (DRS, ASM, HR, CSC) which included charts and pivots using Hyperion and Tableau. Developed Informatica ETL mapping for loading aggregate tables.

Environment: /Tools: Oracle EPMS 11, Hyperion IR, JavaScript, Netezza, Tableau 5.

Confidential, Las Vegas, NV

Business Analyst, Business Intelligence Data Warehouse Developer

Responsibilities:

• Responsibilities included gathering requirements, development, testing and debugging of reports. Provided assistance, mentoring and advice to less experienced staff. Publishing BQY and BQYJobs onto the Oracle EPMS Workspace. Oversaw and assisted in architecting the Data Warehouse and ETL for an end-to-end Business Intelligence system. Developed reports and dashboards.

Environment: /Tools: Windows, Linux, VNC, MySQL, DB2, SQLServer 2005, SSIS, Oracle Data Integrator, Oracle EPMS 11, Hyperion Interactive Reporting v11, JavaScript, Essbase v11, JIRA, Lotus Quikr, Daptiv.

Confidential, Milpitas, CA

Senior QA Business Analyst - Finance Business Intelligence FinBI

Responsibilities:

• As Agile QA Lead, performed Business Analyst and User Acceptance Testing of the Decision Support Finance Business Intelligence System applications including Revenue, Bookings, Pricing & Discounts and Executive Metrics and other projects. Developed test plans, test cases and test scripts and reports for testing functionality, data accuracy and data quality. Staff of three testers. Used Agile methodology.
• Introduced much needed changes to methods resulting in more efficient and effective validation and testing.

Environment: /Tools: OBIEE, Oracle, Teradata, EssBase, HP Quality Center, Rally, BusinessObjects Enterprise XI R2 R3, Designer, Deski, Rich Client, WEBI, Hyperion IR Studio, Excel programming.

Confidential, Fairfield, CA

Business Intelligence Specialist

Responsibilities:

• Evaluated and created Proof Of Concept/Value reports and dashboards with Tableau, QlikView and PerformancePoint. Developed OLAP Cubes and BI Reports, data source from SQL Server. Assisted in the development of SSIS packages for ETL of production data to the Operational Data Store (ODS). Performed analysis and validation of data loads. Used Scrum software development methodology.

Environment: /Tools: Microsoft SQL Server 2005/2008, SSAS, SSIS, SSRS, ProClarity, and PerformancePoint Server, T-SQL, SharePoint, Tableau 4, QlikView.

Confidential, Torrance, CA

Business Analyst, BI Architect - Parts Recovery System

Responsibilities:

• Responsibilities included requirements gathering, development, testing and debugging, user liaison and management of the BI Reporting Project. Ensured data quality by creating validation reports.
• Developed, tested and delivered all core reports on time and within budget.

Environment: /Tools: T3, HPSu 8.3. Brio Designer, JavaScript, Rational ClearCase, Oracle9i, Informatica.

Confidential, Palo Alto, CA

Project Manager - DM&R

Responsibilities:

• As hands-on Agile PM, delivered smoothly and successfully the Hyperion8.5 to System9 Bi+ 9.3.1 and PeopleSoft8 to PeopleSoft9 RDS Upgrade Projects, despite a critical timeline and resource crunch.
• Developed custom Impact Analysis Tool and other IR documents for administration uses. Wrote Python programs to parse XML files and load into database tables.

Environment: /Tools: Solaris, Windows XP, Toad, SQL Developer, Oracle10g, Cognos DecisionStreams, Informatica, Apache, Tomcat, SecureCRT, Python, Eclipse Pydev, JavaScript, JIRA.

Confidential, Mountain View, CA

Business Intelligence Engineer

Responsibilities:

• Installed setup and configured SQL Server 2005 database engine, Analysis Services, Integration Services and Reporting Services. Evaluated QlikView and Tableau. Developed Metrics reports using SQL Server 2005 SSRS, T-SQL and SSIS Packages. Others: SharePoint, PerForce, Windows Scripting.

Environment: /Tools: Windows, Microsoft Stack: SQLServer, SSRS, SSIS, SSAS.

Confidential, San Francisco, CA

Informatica ETL Developer, HPSu8 Brio Administrator, Technical Lead

Responsibilities:

• Developed Informatica ETL mappings for new and changed tables from the OS/390 DB2 CorDaptiX to Oracle ODS RSS. Merant/Serena Version Manager Administrator. RSS Production support 24x7.
• Installed then setup and configured HPSu 8.5.0. Migrated Brio6. Developed Java SDK APIs for administration use. Created much needed documentations and Admin and User Guides.

Environment: /Tools: Oracle9i/10g, Solaris, AIX, Informatica 7.1.3, SecureCRT, SFTP, WinSCP, WinaXe, Apache, Tomcat, SunONE, BEA WebLogic8, Brio Designer, JavaScript, UC4, Toad, SQL Developer, PuTTY Tools, Perl, Python, UNIX and Windows Shell scripting, Open SSH Administration.