Database Developer Business Analyst
Resume:
TING LEONG
Concord, CA *****
***********@*****.***
SUMMARY OF QUALIFICATIONS
Information services professional with experience in Project Leadership, database development and report creation and development in various industries such as Advertising, Business Services, Communications Services and Marketing, Consumer Lending. Have worked with Fortune 500 and with mid-size to large-size companies. My technical skills include T-SQL coding of stored procedures, views and functions, database development using Microsoft SQL Server (Versions 2000, 2005 and 2008R2, 2014, 2016) and SSIS packages to load data files into SQL tables, report development using Microsoft SSRS and Crystal Reports, data analysis skills, relational databases. A hard worker with a good attitude that strives to produce good results.
TECHNICAL SKILLS
Hardware: IBM Mainframe and PC’s using MVS, LAN NetWare and Novell, NT.
Operating Systems: Windows 95, Windows 98, Windows 2000, Windows Server 2008, NT.
Programming Languages: VBA, T-SQL.
Software: SSRS 2008 and 2016, Visual Studio 2008 and 2016, Crystal Reports Writer 7.0, 8.5 and 9.0, XI, Great Plains Service Advantage CS+ 5.0 and 6.0, Great Plains 9.0, SQL Enterprise Manager 7.0 and 2000, SQL Management Studio 2008 and 2016, COBOL, JCL, TSO, Control-M, ECS.
RDMS: Access 97, 2000 and 2007, SQL Server 7.0, 2000 and 2005, 2008R2, 2014 and 2016.
Office Suite: MS Word, MS Excel, Visio.
PROFESSIONAL EXPERIENCE
Veritas Investments, Inc, San Francisco, CA Aug 2019 – Nov 2019
Database Developer
Developed and engaged in the database development process to support internal client data platform, from inception through delivery.
Automated data gathering from several data sources such as Salesforce SOQL queries and MySQL to build data pipelines to transfer data to be ingested and integrated into the SQL data warehouse.
Collaborated with stakeholders, end-users, and others to facilitate and understand functional and non-functional requirements and application functionality for the purpose of implementing database models and code.
Implemented queries, stored procedures, and other Data related tool and processes using SQL Server 2016 databases that enabled and enhanced data analysis and analytics.
Successfully created, modified and designed SQL Server Reporting Services (SSRS) reports that empowered management during the decision-making process, and produced time/cost savings.
Deployed SSRS report files to report server and managed report permissions on the SSRS report server for end users to view SSRS reports.
iManage, San Francisco, CA Sep 2018 – Mar 2019
Database Developer/SSRS Report Developer
Collaborated with other team members to translate functional specifications and business requirements into technical designs for implementation and deployment of SQL database objects.
Single-handedly managed the creation, development and maintenance of a complex SSRS main report with several sub-reports for all client’s software deployment to meet the needs of the business.
T-SQL coding of stored procedures for data extraction for SSRS reports based on business requirements provided by business analysts or Product Managers (VP of Product Development).
Wells Fargo, San Francisco, CA July 2017 – July 2018
Business Systems Analyst
Responsible for analyzing and resolving DQE’s for WCIS application to ensure the data in Source Staging tables matches the Production tables.
RAPP, San Francisco, CA May 2016 – July 2017
Database Developer
Responsible for ensuring Eloqua data has been integrated into production data.
Designed and programed ETL solutions with SSIS and advanced T-SQL that improve the collection, cleansing, moving, importing, and exporting data between databases and external files/sources.
Created ad-hoc T-SQL queries for data marketing analytics purposes for the client.
Worked with business analysts and other team members on data gathering, data analysis and data verification per Blackrock’s business needs for marketing analytics.
Created, maintained and deployed SSRS reports including data driven subscriptions per end-user requirements.
Analyzed existing queries and stored procedures for potential improvements, including tuning.
Stanford Health Care, Oakland, CA Feb 2015 – May 2016
SQL Developer/SSRS Report Developer
Responsible for creation of SSRS reports to report claims data to create the evidence of coverage/benefits per business requirements from end-user.
Created new SSRS reports and enhanced existing SSRS reports according to business requirements from end-user for clinical data reporting.
Coded T-SQL stored procedures and functions using SQL Server 2008R2. This was used by the SSRS report as the dataset for the report.
Wells Fargo Contract, San Francisco, CA Aug 2014 – Feb 2015
Database Analyst
Responsible for loading of data for home equity portfolio.
Ran production SQL agent jobs to load data from various source files into SQL 2008R2 tables. Trouble shooted the cause of job failures to determine where to restart the production SQL jobs.
Verisight, Walnut Creek, CA Feb 2013 – Feb 2014
SQL and SSRS Developer
Created T-SQL stored procedures and user defined functions in a SQL Server 2008R2 database that were used by SSRS reports for reporting purposes.
Designed and created simple to complex SSRS reports using graphs, row groups, expressions and page breaks on row groups, subreports, report parameters for various departments including upper management. Used SSRS 2008. Deployed SSRS reports to production reporting server.
Created and maintained SSIS packages to import data from flat files into SQL Server 2008 R2 databases.
Gathered requirements from end-users for various reporting requests.
American HealthCare, Rocklin, CA Mar 2012 – Jul 2012
SQL Developer/Crystal Reports Developer
Created T-SQL stored procedures and user defined functions in a SQL Server 2008R2 database that were used by Crystal reports for reporting purposes.
Designed and created pharmacy and claims reports for various departments using Crystal Report Writer XI.
Direct Partners, San Francisco, CA May 2011 – Jan 2012
Database Developer
Created and maintained simple to complex T-SQL stored procedures which automated processing of daily Sony PlayStation data files in various formats into production SQL Server 2008R2 database.
Developed and maintained SSIS packages which allowed the import of various file formats into SQL tables. These packages were called by SQL stored procedures.
Disney, North Hollywood, CA Feb 2008 – Apr 2011
Database Developer
Designed an Access application from scratch, including requirements, database design, object/component design, and security design, user interface design.
Consolidated numerous market-survey excel files into a single excel file that was imported into SQL tables using SSIS.
Reduced time spent by compensation analysts to perform a job leveling from several hours to a less than a minute.
Axium International, Burbank, CA Aug 2006 – Jan 2008
Software Developer/Report Developer
Completed work assignment requests relating to creation of new reports and enhancing existing production payroll reports using Crystal Report Writer 9.0.
Created and maintained simple to complex SQL stored procedures and user-defined functions for build release of PayTrax application that was deployed to production.
Resolved issues with report inaccuracies such as missing records and, incorrect report summary totals. Documented the errors.
OTHER RELEVANT EXPERIENCE
Crystal Report Consultant, NTS, Culver City, CA
Application, Developer/Business Analyst, Masterplan, Northridge, CA
Developer/Senior Project Lead, Burbank, CA
Data Conversion Projects with Disney, Various Locations in Southern CA
EDUCATION + TRAINING
Computer Systems and Programming, Computer Learning Center, Los Angeles, CA
Bachelors of Arts in Economics, University of South Florida, Tampa, FL
Various SQL classes including Introduction to Data Mining Using SQL Server and MS Server: Database Development.
Contact this candidate