Data Analyst

• With over ** years of IT experience in the field of data analysis,

• Strong experience in business and data analysis, data profiling, data migration, data integration, and metadata management services

• Assisted the association in performing the data compiling, mining, and psychoanalysis required to assess the given data's ability to collaborate with peers in both business and technical areas to deliver optimal business process solutions in line with corporate priorities.

• Develop Power Apps applications with interface forms to allow users to submit data to databases or spreadsheets, and use Power Automate to control the workflow with some automation scheduling.

• Experience in understanding stored procedures and stored functions using PL/SQL

• Good data warehousing concepts include meta data and data marts from an Active Directory source.

• Connected data tables to TOAD for fixing data anomalies and discrepancies, data comparison, source to target, and target to source.

• I wrote SAP scripts to speed up redundant steps for transferring data into the SAP Online System.

• Performed calculations with aggregate functions, dynamic charts and graphics, data sets, connected joins, and combined data sources using Tableau and Tableau.

• Gathering business and technical requirements that would best suit the needs of the technical architectural development process.

• Proficient in Advanced Excel and Excel Visual Basic for Applications to Automate Tasks, especially for multi-task assignments.

SOFTWARE AND SOFTWARE OPERATING SYSTEM SKILLS

Backend: MSSQL Server, SAP HANA EE

Frontend: Power Apps, SAP

Programming: MS Access, MS Excel VBA, Python

RDBMS: MS Access, MSSQL Server, Oracle 11g, SharePoint

ETL Tools: SSIS, Toad Data Point, Power Automate

Operating System: Windows 10, 11

Visualization: Google Data Studio, Tableau, Tableau

Some Knowledge: MS Access VBA, HTML, JavaScript, Cascading Style Sheets, Office Scripts,

SAS Base 9

DEGREES, CERTIFICATION & OTHER TRAINING

Solano College, Fairfield, California: Associate degree in Computer Science (May 2014)

Prometric Testing, San Francisco, California: SAS 9 Programming (Sep 2010)

Navel Technologies, SAS Training Completion

Amazon Warehouse Services Online Training (2023)

Techpoint Solutions, Milpitas, CA, Data Warehousing Training (Oracle, SQL/PLSQL, ETL, Informatica, Crystal Reports) . Tutorials Point, Tableau Training Course

ACCOMPLISHMENTS

Sempra, Remote July 13, 2022 – November 15, 2024

Data Analyst:

• [Migration and Automation]. Developed window functions, user-defined tables, and translated business questions into SQL scripts. Store procedures, views, and complex queries using SAP HANA EE.

• Translated scripts from other languages, such as Excel, VBA, and SAS, into SAP HANA EE SQL Scripts.

• Used Toad Data Point to automate many of the department tasks, such as SQL scripts, uploading and downloading data from MS SQL Server, SAP HANA EE, Microsoft Excel, etc.

• I created easy step-by-step documentation for performing certain tasks in Microsoft Word and PowerPoint. Develop Power Apps applications with interface forms to allow users to submit data to databases or spreadsheets.

• I created complex workflows that involved automation scheduling, calculations, updating data, validations arrays, conditions, loops, HTML tables, and cascading style sheets in Power Automate to be used for Power Apps.

• Migrated reports from Google Analytics into Tableau, cleansed and formatted data, created reports, DAX functions for more complex reports, and key performance indicators for better visuals. Create visuals using Tableau to extract data from various sources such as Google Analytics, Sharepoint List, MSSQL Server, SAP HANA, etc.

• Python scripts for parsing, cleaning, and preprocessing raw data from multiple formats (CSV, JSON, Excel) for use in analysis for especially for datasets that have more than 1,048,576 rows.

• Identified and troubleshooted software problems, developing corrective action plans and implementing solutions.

• Schedule and automate reports to be submitted in a particular date and time depending on criteria with Toad Data Point and Power Automate

• Produced ad-hoc reports, summary statistics, and other outputs requested by clients, improving turnaround times by 20%.

• Implemented robust data cleaning routines using Python’s Pandas module, effectively handling missing values, duplicates, and outliers in large datasets.

• Retrieve archived maps for projects that need to be updated per client requests.

SWITO, Remote August 04, 2016 – June 23, 2022

• Data Analyst: [Data Analyst]. I created tables and imported all personnel information into an Access database.

• Develop reports from Tableau; use some Excel and Access VBA to quickly complete some tasks with efficiency, and develop complex SQL scripts to retrieve data tables and queries.

• Created detailed documentation for various tasks using step-by-step methods.

• I self-trained myself to use new software and then performed live training with over 30 personnel online on how to use new software.

• Use PostgreSQL to connect to other sources and create financial summary data, tables, and views using complex SQL queries.

• Discover zero-cost or low-cost solutions to complete big tasks, allowing the organization to use those funds for other projects.

• Effectively addressing missing values, duplicates, and incorrect entries in Excel workbooks using Python’s OpenPyxl module

• I also attended refresher and new courses on SSRS, SSIS, Access and Excel, VBA, PowerShell, and C# during my spare time. Send out mass emails to various news media for the different departments within the organization in a timely manner.

• Created Tableau reports from datasets which many involved using DAX Functions. Many of the reports required cleaning datasource using M Code in the Advance Editor before proceeding to upload the data

• I extracted data from various online sources to compile contact lists for different groups to send out solicitations.

• Work with the upper management and designated special projects personnel to implement data strategies, tables, keys, and measures, build data flows, and develop conceptual data models.

Pacific Gas & Electric, San Francisco, California: March 30, 2015 – August 4, 2016

• Data Analyst: [Data Analyst]. Migrated the Planned Outage Dashboard Process from Microsoft Access Macros into SQL Server 2012 Store Procedures.

• I used Microsoft Visual Studio to create SSIS packages for faster import and export of tables to and from different database formats. Process various reports and upload them to the performance management site for multiple divisions to review.

• Enhance Microsoft Excel spreadsheets using Excel Visual Basic Code to enhance worksheet performance and cut down on errors and downtime.

• Developed procedures for multiple tasks using step-by-step instructions with friend illustrations.

• Audited and corrected data received from different sources before positing the results to the’ division's performance dashboard.

• Forecasting data using Microsoft Access/Excel and PL/SQL to help prevent overspending and the MOD SQL function to calculate the total amount from the value of extra items to be set aside for the next year budget helped save the department from overspending.

• Used SAP accounting software to extract reports from the business warehouse and production. Assisted the department’s data operations analyst using Oracle SQL Developer to pull meta data information from different tables.

• Developed and maintained SAS programs to extract, transform, and load data from various sources into SAS datasets.

• Created and maintained SAS macros and other programming tools, resulting in a 15% increase in efficiency.

• Generated reports, summaries, and other data outputs using SAS, improving data accuracy by 20%.

• Collaborated with cross-functional teams to develop and maintain data security and validation processes, reducing data errors by 25%.

• Implemented data quality checks and data warehousing processes, leading to a 30% increase in efficiency.

• Conducted data analysis, data mining, and data manipulation utilizing SAS and related tools.

• Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations, and complex calculations to manipulate the data using Tableau software.

• I volunteered to be the main contact source for converting questions into SQL queries and providing detailed information back to the coworkers.

• The Linux/Unix matching command allowed me to extract, filter, and export out the necessary data using a nice-readable format instead of manually separating the data into separate columns.

• Cleaning data using different functions in MS Excel and pattern matching criteria using SQL commands I was able to assist coworkers with their questions; this allows other personnel in my group to spend more time completing their work, keep the department workflow moving at a good pace, and help minimize backlogs.

Chevron, San Ramon, CA September 29, 2014 — December 23, 2014

• Data Analyst: [STRATA Site Benchmarking Project]. Performed data analysis, data entry, and cleanup on over 1,000 records from different business units, checking and fixing anomalies, formatting issues, and inconsistencies.

• Create complex charts and graphs with interactive filters and drilldowns that will allow managers from various divisions to quickly locate outliers and correct any anomalies.

• I gathered requirements from remotely based business users and defined and elaborated on the requirements by holding meetings with the users (who are also fifth-third employees).

• Analyzed historical documentation, supporting documentation, screen prints, e-mail conversations, presented business, and wrote the business requirements document.

• Prepare an auditing analysis to identify trends, patterns, and/or system issues that may contribute to coding and documentation deficiencies and risk areas. I made recommendations on data metrics to upper management and co-workers before submitting the final metrics to the vice president of the company.

• Experience in developing stored procedures, functions, views, triggers, and complex SQL queries using SQL Server, TSQL, and Oracle PL/SQL Proficient in the integration of various data sources with multiple relational databases like Oracle 11g/Oracle 10g/9i, MS SQL Server, Relational and Flat Files into the staging area, ODS, Data Warehouse, and Data Mart.

• Involved in performance tuning at source, target, mappings, sessions, and system levels.

• I converted the technical documentation into plain language so even a non-technical person could understand the analysis.

ACIS Software Solutions Inc, Park Ridge, IL January 8, 2014 – July 31, 2014

• SQL/ETL Developer: [Data Warehouse/ETL Developer Advanced Training]. Responsibilities: Informatica 9 Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools – Informatica Server, Repository Server manager.

• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.

• Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server; Relational and Flat Files into the staging area, ODS, Data Warehouse and Data Mart. Involved in Performance tuning at source, target, mappings, sessions, and system levels. Concepts using Slow Changing Dimension Type: 1, 2, and 3).

• Documented Informatica mappings in Excel spread sheet. Used various transformations like Filter, Router, Expression, Lookup (connected and unconnected), Aggregator, Sequence Generator, Update Strategy, Joiner, Normalizer, Sorter and Union to develop robust mappings in the Informatica Designer.

• Worked on complex Source Qualifier queries, Pre and Post SQL queries in the Target.

• Worked on different tasks in Workflow Manager like Sessions, Events raise, Event wait, Decision, E-mail, Command, Worklets, Assignment, Timer and Scheduling of the workflow.

• Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.

Pacific Gas & Electric, Concord, California: February 18, 2011 – November 22, 2013

• Data Analyst: [Safety Environment Management System & Maximum Allowable Operating Pressure Project]. Exported data from the department’s database and then used MS SQL Server 2012 SSRS to populate for Chart, Summary Reports, Tablix, Lookups.

• Proficient in Advance Excel and Excel Visual Basic for Applications to automate tasks especially for multi-tasking.

• Advise SAP developers and project managers of much needed enhancements to database to prevent use errors during development.

• Wrote SAP Scripts to speed up redundant steps for transferring data into SAP Online System.

• Use Excel’s statistical, lookup & other advance functions to create summary reports, graphs, and extract polluted quantitative data.

• Data prepped, mapped and imported over 15,000,000 image files into 3 different databases.

• Forecasted remaining amounts from budgets using the SQL MOD Function to route extra amounts from the forecasted amount to budgets for other items’ purses that the department orders the most.

• Connected data Tables to TOAD for fixing data anomalies and discrepancies; data comparison, source to target and target to source.

• Analyzed historical documentation, supporting documentation, screen prints, e-mail conversations, presented business and wrote the business requirements document.

• Proficient in Advance Excel and Excel Visual Basic for Applications to automate tasks especially for multi-tasking.

• Performed calculations with aggregate functions, dynamic charts and graphics, data sets, connected joins, combined data sources using Tableau Cleaned and formatted dirty data using SAS Software to be presented in more readable format for my peers.

• Ability to understand current business processes and implement efficient business process.

• Maintained an account of field studies and collected geographical data.

• Tested GIS software and recommended new software purchases.

• Updated the existing geographical database and identified data that appeared to be outdated.

• Put together visual presentations for clients after all relevant data was collected and interpreted. Updated data collection standards with management approval.

MV Transit, Fairfield, California: February 4, 2010 – October 29, 2010

• Data Analyst: [Post-Conversion Project]. Performed data analyst, data entry, and cleanup on over 1,500 invoices; checking for errors, formatting issues, and inconsistencies.

• Grouped and combined invoice information using Microsoft Excel for creating Pivot Tables for generating page reports.

• Advanced levels skills in Crystal Reports; connecting different data sources, functions, hierarchies and more.

• Uploaded cluttered data into SAS Software and exported data into other sources in a more manageable format with SAS SQL Created easy expense reports so the novice and expert users could easily navigate using filters, drill downs and export reports in a professional-presentable format.

Wells Fargo, San Francisco, California: April 7, 2008 – December 18, 2009

• Data Analyst: [Personnel Access Project] Combined over 8,000,000 records from over 51 system applications to be cleaned, formatted and filtered using Microsoft Word’s Edit and Replace [wild card feature].

• Worked on exporting reports in multiple formats including MS Word, Excel, CSV and PDF.

• Performed Data Profiling and Data Quality. Designed and implemented report layouts according to reporting standards of the department.

• Queried the databases, wrote test validation scripts and performed the System testing.

• Uploaded cluttered data into SAS Software and exported data into other sources in a more manageable format with SAS SQL.

• Assisted the Sr. Data Modeler with the Entity Relationship Diagrams, and creating alternate keys instead of social security numbers for security purposes.

• Created data trace map and data quality mapping documents.

• Created interfaces, advanced complex SQL queries, functions, VBA coding, and reports using Microsoft Access.

• Worked with Technical Experts to Improve Report Performance and performed System testing.

• Created Procedures with Input/output Parameter so less experienced users could retrieve the records needed for their use.

• Created regular expression scripts in Oracle and Linux to extract sophisticated and masked data to be presented to low and high level workers to be corrected immediately

Pacific Gas & Electric (PG&E), San Francisco, California: August 14, 2007 – February 28, 2008

• Data Analyst: [Minority Cash Balance Project] Research and summarized PG&E Monthly Budget Amounts and used SAP to summarize, calculate and export data into Microsoft Access for creating Data Access pages on the intranet.

• Forecasting data using Microsoft Access/Excel and PL/SQL to help prevent overspending.

• Gathered requirements from remotely based business users and defined and elaborated the requirements by holding meetings with the users (who are also Fifth-third employees).

• Analyzed historical documentation, supporting documentation, screen prints, e-mail conversations, presented business and wrote the business requirements document.

• Wrote the test cases and technical requirements and got them electronically signed off.

• Created new reports based on requirements.

• Created Report-Models for ad-hoc reporting and analysis.

• Cleaned and formatted dirty data using SAS Software to be presented in more readable format for my peers.

• Ability to understand current business processes and implement efficient business process.

• Communicating with 3rd party vendors and assisted with the actual programming while testing in Quality Assurance Environments.

Contact this candidate