Benjamin Su Email & Phone Number

Texas, United States

Plano, Texas, Us

- Designed and Created databases, tables, views, stored procedures, and triggers.- Established Joins and created Clustered/Non-clustered Indexes wherever necessary.- Responsible for the Extraction, Transformation, and Loading of data from Multiple Sources to the Data Warehouse using SSIS.-Used different Control Flow Tasks and Data flow Tasks for creating SSIS Packages. Designed packages using different types of Transformations for Data Conversion, Derived Columns with Multiple Data Flow tasks- Responsible for Deploying, Scheduling Jobs, Alerting, and Maintaining SSIS packages.- Developed a variety of reports using data that has been cleaned, manipulated and maintained on SSMS SQL database- Built a variety of reports in Power BI and Excel - Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI- Assisted in Automating, Configuring, deploying instances on AWS, along with managing security groups on AWS

Plano, Texas, Us

Bangalore, Karnataka, In

- Implemented several projects to assist the support of internal and client systems utilizing Java, Python, SQL, Salesforce, Tableau, and Power Bi- Created a website that submitted programming codes written in formats such as Python, Java, SQL, etc. Allowed users from the company to submit the code and be checked for things such as accuracy/correctness. The website used the framework AngularJS along with CSS and HTML. - Created Program code reviewer using Python and Flask framework to look at code and assess the validity of the code. Code could be written in Java, Python, or SQL - Created ETL tool in SalesForce for oil and gas client that allowed them to automate their reporting on Work Orders- Collaborated on creating an ETL tool in Salesforce for an Oil and Gas client- Collaborated on a team to write an anomaly detector to track sales, trends, etc. using the concepts of machine learning

Tulsa, Ok, Us

- Prepared weekly reports using Power BI based on statistical data that analyzed and summarized major companies bank activity throughout the week - Executed customer transactions, including deposits, withdrawals, official check issuing, and transactional reviews- Assisted in reviewing incoming loan and mortgage packages to make sure they ensured compliance with company policies and procedures

Santa Barbara, California, Us

- Provided customer support on over 100+ portfolios for Bank Reconciliations, Cash Flows, Financial Reports, Internal Control Reports, Auditing, and Income Statements - On a daily basis managed client portfolios that were worth millions of dollars - Assisted and trained new employees on a month to month basis on learning and understanding the company property management crm software

Kista, Stockholm, Se

- Pulled project financials of over millions of dollars from SAP and imported it into Excel to analyze work in progress, reserves on unrealized cost, and profit/loss on projects- Managed change requests on projects worth millions of dollars by updating project cost spreadsheet - Created monthly powerpoints on corporate reporting by pulling information from a specialized company server to show project life cycles on major vendors

Paris, Fr

- Prepared Financial Reports using GAAP principles, Internal Control Reports, True-up reports, and Income Statements - Created Excel Spreadsheets for fixed asset register- Used advanced excel techniques to conduct regression analysis, simulations, and time series analysis

Master'S Degree, Business Analytics

Bachelors, Accounting And Finance