Judul: Tom Nassayan Resume
Penulis: Asha Wonder
THOMAS A. NASSAYAN
331 Kingswood Lane
Danville, CA 94506 (925) 389-0028 tom@nassayan.com
Professional Summary
Career built on professionalism and excellence in many areas of expertise with consulting and leadership experience with Fortune 500 companies
Possess invaluable business skills, excellent analytical, interpersonal and communication skills
Entrepreneurial, Self-motivated, team player with leadership and management qualities and capabilities
Business Intelligence consultant with focus in the consumer packaged goods (CPG), energy and financial industries as well as Web and Web related technologies
Tableau BI Consultant (Tableau Partner, Certified Developer & Administrator)
High level of success as a certified Tableau consultant with rapid business intelligence application implementations driving actionable insights through data visualization
Experience as a DBA, database architect, data modeler and database programmer with extended capabilities with large data warehouses combined with strong skills in database & query optimization techniques has facilitated superior Tableau output performance in terms of speed, storage and content
Have successfully installed Tableau support and programming teams within larger IT organizations due to knowledge of Tableau Server administrator and superior management abilities
Skills Summary
Database
Extensive experience with Oracle (9i-11g) and SQL Server with expertise in database design, data modeling and procedural language (PL/SQL, Transact-SQL) programming in large data warehouse environments
Expert in database automation, data migration, performance tuning, shell scripting, SQL*Loader, ETL in Linux, UNIX and Windows environments
Good understanding of columnar database, multi-dimensional OLAP cubes, big data implementations
Web
Design & Development experience with static/dynamic/data-driven websites in Intranet, Commercial or general use applications
Conceptual Design & Project Management experience with focus on User Interface and User Experience
Working experience in Programming, Middleware, Server and Database technologies for the Web
Working knowledge with SEO/SEM, Web Analytics, Ad Campaigns, Social Networks, Lead Generation
Other
.NET programming experience including Visual Basic, #C and Silverlight
Thorough understanding and programming experience with Object Oriented Programming platforms
Experience programming mobile devices including the Apple iPhone
Development & Business knowledge of Mobile Marketing platforms (SMS/MMS/WAP) and Digital Signage Applications
Work Experience
Sempra Energy, Trading Floor, April 2012 to November 2013 Lead Consultant & Developer
Designed and implemented the trading group EDW by consolidating data from multiple systems from multiple subsidiaries to normalize and store complicated trade transactions, counterparty, price index, hourly and daily pricing information, etc. on an on-going basis. Created data extract and export and import mechanisms to exchange data with third party companies. Created data extracts for Dodd-Frank. Created datamarts and Tableau standardized data sources for use by other Tableau users. Created Tableau guided dashboards for management to report on MtM, risk analysis, credit status, profitability, etc. Mentored other Tableau users, provided training and served as administrator.
Accenture, Workforce Planning, October 2010 to March 2012 Lead Consultant & Developer
Created a DW for the Workforce Planning group by integrating top-down, high level actual, budgeted and forecast data for headcount demand and supply, revenue, charge rates, etc. imported from SAP with complicated Excel models containing, geographic areas, country information, operating groups, service groups, career levels, etc. to breakdown the data to its most granular form for the purpose of reporting historical and forecast reports and trends from the bottom-up. Designed a UI to replace the Excel models and led a team of programmers to create a web based, globally used application to capture the data. Created many stored procedures to replicate the Excel spreadsheet logic for the purpose of future ease of maintenance. Created more than 60 dashboards to provide the required reporting.
Premier Source, January 2010 to September 2010 Lead Consultant & Developer
Created a RDW (Reporting Data Warehouse) that aggregates and normalized data from multiple databases where each database represents a pharmaceutical client with a different medical service or product. Created Tableau standardized data sources for use by the account managers assigned to each client. Provided internal Tableau financial and business reports, internal data quality and data anomaly reports, provided external client financial and tracking reports all while observing HIPAA rules. Mentored users, provided training and served as administrator.
Charles Schwab, Retirement Planning Services, July 2009 to December 2009 Project Manager, Senior Developer, Tableau BI Tool Expert
Designed new data mart using ERwin data modeling tool to facilitate new requirements on data collection and classification. Created & scheduled UNIX shell scripts, SQL scripts and PL/SQL packages and facilitated the automation of daily and monthly jobs to collect large amounts of data from data warehouse and various other sources into data marts. Wrote various PL/SQL stored procedures for asset classification, categorization and summarization. Tuned database for performance using optimization techniques, table partitioning, bitmapped indexing, etc. Developed a financial reporting platform with interactive live dashboards using Tableau software to create and disseminate information to upper management. Served as mentor on BI reporting to other developers.
Astound Mobile Inc, January 2009 to June 2009
Project Business & Development Director, Oracle (11g) Developer, Adobe Flex Developer
Creating a comprehensive mobile marketing platform for a startup utilizing SMS/MMS technologies. In charge of creating the business plan, mobile marketing strategy, website and portal conceptual design, SMPP server evaluation and selection, business use case analysis, database design and development, portal design and development. Designed Oracle database and developed several PL/SQL packages to handle automated responses for various vertical market strategies. Designed and developed the user portal with Adobe Flex Builder and PHP.
Chevron Corporation, December 2007 to December 2008
Database Architect, Project Development Director & Developer, Oracle (10g) PL/SQL Developer
As the project director, analyzed a complicated set of interrelated and cross-referenced government and corporate accounting rules stored in legacy formats and created a team to redesign & rewrite the platform. Designed database models and the various pieces of information to be accessible to Chevron's accountants and other business users worldwide via the Intranet. Created a data administration interface to allow and track rule changes. Utilized SQL Server and ASP .NET with Telerik controls.
Additionally, worked on new and existing PL/SQL procedures, SQL loader scripts, UNIX shell scripts to load financial data from various Chevron divisions. Worked on performance tuning issues on the Chevron data warehouse.
Developed migration path from the legacy accounting system into Hyperion Enterprise for the Comptroller's division. Negotiated software contract and ultimately implemented Hyperion Enterprise.
Clorox Services Company, March 2006 to October 2007
EDW Modeler, Oracle (10g) PL/SQL Developer, Hyperion Expert
Designed various data marts and wrote numerous shell scripts to support retailer data feeds into the EDW. Developed BI processes and created Hyperion reports to evaluate and manage inventory, stock levels, transportation information, production, etc. Created numerous Oracle objects to facilitate internal database processes. Redesigned and created new processes to enhance performance to meet service level agreements with internal and corporate customers. Tuned database for performance and tuned many queries by creating new indexes and views and rewriting the queries to gain maximum performance.
Information Resources Inc., October 2004 to March 2006 IRI/PepsiCo Chief Technology Officer
Leading a team of business analysts, analytical modelers, developers and other technologists to support PepsiCo's Business Intelligence unit. Key player in development of the SKU optimization and assortment planning solution, Ad feature insights tool, Out of Stock reporting and management system, promotional calendar system and Single SignOn/SAML initiatives. Managed, designed and participated in development of a complete reporting and alerting system for Costco and 7-11 teams within PepsiCo. MS Visual .NET platform (.ASP, C#)/MS Reporting Services using MDX operating on Microsoft Analysis Server (MSAS) running multi-dimensional SQL Server OLAP cubes.
Wells Fargo Bank, Wholesale Banking Division, March 2004 to September 2004 Database Architect (Oracle 9.2), PL/SQL Developer
As a leading member of a team of 50 individuals, developed a back-end system that automated the consolidation and management of various business entities within the bank based on a multitude of rules and attributes using complex matching algorithms. Designed an advanced 3-tier table structures to enhance performance for the presentation layer. Oracle 9.2/PLSQL/Unix/Scripting.
PG&E, Risk Analysis Department, August 2003 to February 2004 Database Architect (Oracle 9.1), PL/SQL Developer, BRIO Developer
Designed and developed a BRIO EIS presentation layer on top of an Oracle database back-end with interfaces to PG&E's data warehouse and Risk Analysis and Trading system (GenTrade) for the purpose of reporting and managing company's exposure and risk in the electrical and gas markets.
Pepsi-Cola Company, September 2001 to August 2003 Designer & Developer
Contracted to produce a Microsoft Pocket PC based PDA application for PepsiCo's field auditors to collect inventory, POS, out of stock, sales, promotions, marketing and competitor information from supermarkets and C&G stores. Hired and managed a team of technologists to analyze, design and recommend a solution to PepsiCo. Successfully delivered and deployed an integrated system that used an Oracle database as the central repository for data collected from the users through the synchronization of their PDA and their PC. Used BRIO to produce management reports. MS Embedded Visual Basic/MS Outlook OLE/BRIO.
Separately, developed a generic application with field level mapping capability for the purpose of validating, auditing and reporting discrepancies between two data reporting agencies.
PG&E Energy Services, August 1997 to August 2001
System Architect, data warehouse & database architect, DBA, developer, project manager
Oversaw the full life-cycle software development process and created the software foundation of the Operations department. Created a data warehouse in Oracle 7.3.4 and later converted to Oracle 8i to take advantage of the data warehousing and other new technologies in Oracle 8i to increase efficiency and performance. Using global temporary tables, views, stored procedures and dynamic SQL including in-line functions, devised a sophisticated new scheme to model 5 year/24 hour power usage forecasts on the fly and aggregated that information into new data structures called proxies to be used by a risk analysis system. Wrote parameter-driven dynamic PL/SQL procedures to handle evolving pricing structures. Used ERwin for data modeling. Used Oracle Discoverer to setup queries and reports for power users.
Created an ASP/HTML application for the Sales and Marketing departments to facilitate the input of customers' data and their specific load, discount and deal information. Also created a Visual Basic application for the operations department complete with interfaces to various other internal and external systems to obtain tariff, generic pricing and load forecasting template information for the purpose of purchasing energy from the Power Exchange (PX) through a B2B e-commerce web site. The system produces the daily power schedule for the entire portfolio per geographical zone that was then transmitted automatically to the Independent System Operator (ISO) through their web site. These applications in conjunction with stored procedures in the Oracle database, utilize a series of complicated calculations to create risk analysis information. The GUI allows any combination of user-specified criteria to create and export risk related information to other tools for manipulation and decision-making purposes. The system prepares the proxy transactions created within the database and feeds the data automatically into a commercial portfolio risk management system called Openlink™. The Visual Basic product uses Sheridan libraries, Crystal Reports, incorporates ADO calls and ODBC connections to communicate with other systems. XML and EDI documents are parsed and created to and from other sources. Live price feeds provided by TIBCO.
Installed, maintained and supported a SQL server based third-party software product named ETRM™. Modified and added functionality to the product's Access based GUI. Created various Access & Crystal reports from the SQL server database.
Hewlett Packard, January 1997 to July 1997
Wells Fargo Bank, October 1996 to December 1996
Gallo Winery, April 1996 to September 1996
Hilltop Aviation Services, October 1995 to March 1996
Access Online, June 1993 to February 1996
Gallo Winery, July 1991 to August 1993
Toshiba America Information Systems, Multiple contracts starting February 1990
Technical Skills
RDBMS and related tools
Oracle 9i/10g/11g Developer skills: Strong dynamic PL/SQL and SQL DDL; extensive use of language constructs and database objects; application tuning, SQL scripting, etc.
Oracle 9i/10g/11g DBA skills: Experience with database installation, creation and setup; database tuning; database security; database backup, import & export, replication, migration, scheduling; Oracle Enterprise Manager, Management Server, Application Server, DBAStudio, etc.
Microsoft SQL Server Developer and DBA, MSAS Cubes, Microsoft Access
ERwin Data Modeler, Rational, SQL Navigator, SQL Monitor, Embarcadero tools
Data Warehousing, Data Marts, Data Mining, OLAP, OLTP, DSS, EIS
Database architecting, Data Modeling, System prototyping
Web Development
Adobe CS5 (Photoshop, Fireworks, Dreamweaver, Illustrator, InDesign)
Adobe Flex Builder, Cold Fusion, Lightroom
Internet Information Server (IIS), Apache
PHP, HTML/DHTML, XML, AJAX, CSS, ASP .NET, JavaScript, VBScript, Joomla
MySQL, Toad for MySQL
RAD and related tools
Oracle Developer, Oracle Designer, Oracle Reports
Microsoft Visual .NET, ASP, VB, C#, Telerik controls
Delphi, PowerBuilder, Superbase, Access
Crystal Reports, MS Reporting Services
InstallShield Professional, Wise Installation, RoboHelp, PVCS
BI tools
Hyperion/BRIO, Microstrategy, Cognos, Tableau
Productivity tools
Microsoft Office, PowerPoint, Project, Visio
Microsoft Exchange, SharePoint, Office Live
ABC Flowcharter, Jetform, Multi-edit, Ultraedit
Operating Systems and other technologies
DOS, Windows Desktop & Server (all versions)
Mac OS X, Linux, UNIX
ODBC, TCP/IP, DHCP, DNS, RAS, Active Directory, etc.
References are available upon request.
Terimakasih telah membaca Tom Nassayan Resume. Gunakan kotak pencarian untuk mencari artikel yang ingin anda cari.
Semoga bermanfaat
0 komentar: