SUMMARY:

• Over 32 years of IT experience in data analysis, database design, development and programmingo Exposed to the total life cycle of project from the preliminary point of analysis to final test and documentation
• Expert in ETL, data extraction, conversion, cleaning, filtering, migration, integration, auditing and validation
• Proficient in OLAP dimensional data modeling and star schemas for data warehouse/mart
• Proficient in structured and object - oriented analysis & design and database relational modeling
• Proficient in SQL Server, T-SQL, DTS and SSIS, Microsoft Visual FoxPro, Access, and Excel
• Knowledge of Python, C++, Informatica, Oracle and PL/SQL
• Demonstrated ability to perform multiple projects and meet deadlines in a fast-paced environment
• Committed to personal growth, learning and continually seeking new experiences
• Strongly detail oriented, creative problem solver, team oriented, highly motivated, organized and accurate

PROFESSIONAL EXPERIENCE:

Senior ETL Developer

Confidential, Los Angeles

Responsibilities:

• Contract for consolidation of legacy separated databases from SQL Server and Access to a new database system in Microsoft Azure SQL Database.
• Participation in data modeling and designing destination database structure, analyzing data sources and mapping to destination database, ETL architecture and developing plan for moving data from sources to destination, data cleansing and conversion, developing enhancements and modifications to SQL scripts for new functionalities.
• Testing, diagnosing and resolving problems and issues of procedures, forms and BI/Reporting. Developing utilities, views and reports and query source system data for data quality validation.
• Testing data integrity and QA with original source data.

Quantitative Data Analyst

Confidential

Responsibilities:

• Using SQL and database technologies to perform quantitative analysis of financial markets data, work with large data sets to predict statistical market patterns, develop and code data-driven trading decision making, technical analysis on various time frames, exploring and testing trading ideas and patterns.
• Developing and coding indicators and strategies for algorithmic automated systematic trading. Strategy back testing, performance optimization, forward and out-of-sample testing.
• Fine tune and automatic adaptive asset allocation to address changing market regimes and programming dynamic profit target & stoploss based on historical probability.
• Implementing medium frequency, day-trading and swing-trading of futures market indices, bonds, commodities, currencies and other instruments.

Senior ETL Specialist

Confidential, Los Angeles

Responsibilities:

• Duties included preparing data and creating stacks in specified format for market and statistical research and modeling.
• Design, implement, and develop ETL processes against high volume and complex data sources in different formats, analyzing source/destination databases, data analysis, verification of source/target data elements, data mapping and building data dictionary, data cleansing and scrubbing, exporting and importing in different formats and QA testing of data files, transforming and aggregation of data, data de-duplication, eliminating redundant records caused by merging data, data assurance and data quality validation, testing data integrity and QA with original source data.
• Compiling and migrating codes to SQL Server and Microsoft Visual Foxpro.

Senior Programmer Analyst

Confidential, Los Angeles

Responsibilities:

• Duties included consolidating separated databases and applications used in CA, AZ, OR and northeast states from Access, FoxPro, AS400 and VAX environment to a nationwide application.
• Responsible for analyzing source and destination data systems to determines processes and procedures for moving data from source to destination, Architecting system structure, data modeling, data mapping, data conversion and cleansing from different sources and formats to Visual FoxPro tables,
• Developing enhancements and modifications and writing SQL scripts for new functionality, testing, diagnosing and resolving problems and issues of programs, forms and reports,
• Developing utilities, views and reports and query source system data for data discovery/validation/manipulation,
• Developing and tuning ETL mappings and sessions from/to DBC database container to/from Oracle 9i, Access and Excel including TXT and XML formats, Writing PL/SQL codes for stored procedures and triggers,
• Gap analysis, translating new business requirements to data requirements, data analysis and reporting.

Database Engineer

Confidential, Los Angeles

Responsibilities:

• Designing, developing and coding to automate process in SQL server, VFP 8 and Access for Standardization, Suppression, Deduplication and Cleaning data files, Writing codes and Transact-SQL scripts for database access, modifications, and constructions including stored procedures, triggers and cursors.
• ETL and automating file download/import process from ftp site with DTS packages, Auditing and detailed data analysis with Query Analyzer and Enterprise Manager, Complex ad-hoc SQL reports, ER diagrams modeling and Data warehouse architecting,
• Logical and physical design of DW, Schema design and mapping measures and dimensions into tables, creating materialized views for ODS,
• Data staging, movement and aggregation, Designing ETL, data extraction, data conversion, exporting, importing in different formats and QA testing of data files.

Database Analyst

Confidential, Los Angeles

Responsibilities:

• Duties included analyzing and changing the old flat separated database systems to an integrated relational database from Access and Dbase and FoxPro/Dos to Visual FoxPro, ETL, data extraction, data conversion, exporting, importing in different formats and verifying accuracy of data,
• Writing complex SQL scripts and testing, debugging, modification and enhancement of views, reports and forms, Reviewing, evaluating, designing, implementing and maintaining company databases,
• Developing and maintaining mailing list database retrieval system, Establishing customer support tracking database, Modifying tables, queries, reports and forms to improve speed, screen readability and reporting features,
• Interfacing databases with Word, Excel for statistical analysis.

Systems Analyst / Programmer

Confidential

Responsibilities:

• Duties included analyzing procedures, methods and operations of computer-based information systems for Confidential project, business, medical, health care, scientific, industrial and construction systems and client/server applications in different languages especially in FoxPro and Visual FoxPro 3 & 5.
• Interacted with technical staff and users to identify system requirements.
• Designed program logic and coded computer instructions in specific programming language.
• Reviewed specification of programs to ensure compliance with system requirements and installation standards. Assured proper integration of new programs.

Applications Programmer

Confidential

Responsibilities:

• Performed technical analytical work in the development, writing, debugging and implementation of computer programs in FoxPro, C, FORTRAN and Basic.
• Designed and drafted user support systems for divisional users.
• Tested programs and systems to make correction as necessary and trouble shooting users’ problems.
• Maintenance and support for installed software packages and extensive customer interaction to provide information and answer questions from users regarding computer programs and systems.
• Evaluated performance of existing systems and analyzed and modified programs as required to improve efficiency or to adapt to new requirements.