SUMMARY:

• Dedicated professional with more than 10 years of information technology experience
• Extensive experience of creating, modifying, troubleshooting, and running ETL processes using Ab Initio
• Broad experience of creating, migrating to production, and supporting Ab Initio graphs, SQL scripts, UNIX scripts, and loading data to Teradata database
• Strong Teradata SQL skills. Knowledge of BTEQ, Teradata macros, stored procedures, MultiLoad, FastLoad; experience working with huge Wells Fargo bank databases
• Extensive knowledge and understanding of SAS, SAS SQL, and SAS macros
• Strong Excel, Excel formula, pivot table, Excel macro, and VBA skills. Deep experience in writing Excel macros to create automatic reports. Deep experience analyzing and presenting data in Excel
• Skilled in Autosys scheduling tool, SQL Server Business Intelligence Development Studio, SQL Server Management Studio, SSAS, SSIS, T - SQL, Oracle, Access, DB2, Crystal Report, BI, BRIO, VISIO, PowerPoint
• Experience working in Windows, Unix, and Linux operating systems

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

Apps Systems Engineer

Responsibilities:

• Responsible for troubleshooting and supporting production processes for EFD and FDCS projects for BMG data warehouse. Migrated graphs/psets/scripts from development to production. Created documentation for production graphs
• Participated in EFD and FDCS projects for Business Modeling Group (BMG) data warehouse. Responsible for creating, updating, troubleshooting, and running ETL processes for Wells Fargo BMG. Created Ab Initio graphs and psets to load data from ASCII, EBCDIC, and XML files, Oracle, and Teradata to Teradata. Reviewed and audited tables before the data were loaded to production database. Created UNIX and SQL scripts to automate loading data into Teradata
• Created UNIX/SQL script for checking status of daily/hourly jobs
• Participated in development of the ERD, table structures, joins and indexes, and transformation rules for ETL processes
• Modified and simplified CAPB quarterly programs to analyze the most valuable customers’ data for Wells Fargo by using Teradata SQL and UNIX. Responsible for running CAPB quarterly programs using UNIX
• Conducted numerous researches to check the accuracy of data in Wells Fargo BMG Teradata database tables and the possibility of using BMG Teradata tables instead of tables created by different vendors
• Modified CAPB programs to run them using BTEQ. Used BTEQ to create a script to check daily/weekly/ running jobs, wrote BTEQ scripts to automate processes for Wells Fargo, update data, and create various reports. Developed Teradata stored procedures and macros to update and modify BMG and C2T data. Created and ran ETL processes to move data from C2T database to BMG database for CAPB and CAPB quarterly processes using mload, Teradata Export and Import
• Conducted research to solve the problem with the Payee Taxonomy project, which identifies payee information uploaded from different data source to Teradata C2T (Dun & Bradsttreet, BillPay) and Teradata BMG (ACH, CreditCard and DebitCard). Examined how the stored procedure was working and found out why executing the stored procedure made the Teradata database freeze
• Analyzed Wells Fargo Bank information and produced different reports and data sets using SAS and SAS Enterprise Guide. Used SAS to map distance between Wells Fargo Bank ATM locations and other bank ATM locations to determine optimal locations for new Wells Fargo ATMs. Modified SAS UNIX programs to get correct customer information and avoid using third party programs
• Modified and simplified the Hemisphere project’s programs written using Unix SAS and Teradata to run using only Teradata SQL for Wells Fargo in order to decrease run time and reduce database space usage
• Created a demo data set using SAS, with data and statistics similar to actual Wells Fargo data and with over 1.3M rows, to demonstrate and finalize the functionality of a new dashboard, which should show advantages of a new dashboard without compromising Wells Fargo’s clients’ privacy
• Created an automated version of CMIS 11, CMIS 12, CMIS 13, and CMIS 14 Excel reports that significantly reduced the time necessary to create reports for Wells Fargo. Excel, Excel VBA, and Teradata SQL were used to analyze the bank’s data and calculate results. Data was sent from Teradata to Excel through ODBC connections. CMIS 14, that previously required more than 40 human hours to run, became a 100% automated process
• Design and created macros using Excel and VBA, including a macro to get customized reports for VP and Directors of Charles Schwab. Wrote a macro using VBA to automatically retrieve data from Teradata to Access
• Modified cubes on SQL server 2008 using SSAS by adding new dimensions from new views to existing cubes. Created SSIS packages, jobs, and scheduled certain jobs to run. Created OLAP and menu items to show cubes data on Wells Fargo’s BMG web pages. Created Excel verification files. Pulled different Excel reports for customers using BMG cubes
• Managed projects of modifying production SQL scripts and cubes because of changes in BMG Teradata databases’ tables
• Was responsible for managing, troubleshooting, and processing BMG dashboard weekly and monthly production processes using Teradata and SQL Server 2008. Running the production processes includes checking initial data, executing preparation packages, checking BTEQ files, running cubes and validating results, updating OLAPs names, manually generating and uploading Excel/HTML reports, verifying reports, saving back-up etc.
• Developed detailed documentation using Word, Excel, and Visio for newly created and updated programs and processes
• Managed projects and mentored junior coworkers.

Math Instructor

Confidential, Charlotte, CA

• Worked with students to improve their knowledge of statistics, mathematics, reasoning, and theoretical skills