Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app
Work Background
Onsite Health DiagnosticsBusiness Intelligence Developer (Remote)
Aug. 2022 - Feb. 2023Coppell, Texas, United States• Data warehousing • Remediated and enhance existing ETL process
• Requirement Analysis
• Report Design & Creation
• Business Data Subject Matter Expert
• Report/Dashboard Delivery Support & Response
• Tableau Dashboard Design and Creation
o Cohort analysis
o Cohort details
o Campaign summary o Campaign details
• Servicing Director Administration, Configuration & User Management
• Created Ad-hoc reports for Administrators.
• Created new SSIS data packages for basic data transfer request.
• Created new stored procedures, views and functions in SQL Server as requested by the different business units.
Acra LendingIT Report Analyst/ Database Engineer (Remote)
Jun. 2021 - Aug. 2022Irvine, California, United States• Requirement Analysis
• Report Design & Creation
• Business Data Subject Matter Expert
• Report/Dashboard Delivery Support & Response
• Power BI, Qlik, and Tableau Dashboard Design and Creation
o Objectives Dashboard
o Revenue Dashboard
o Loan Origination by Warehouse Line of Credit
o Wholesale Associate Execute Commission
• Servicing Director Administration, Configuration & User Management
• Created Ad-hoc reports for Servicing and Originations units
• Created new SSIS data packages for basic data transfer request
• Created new stored procedures, views and functions in SQL Server as requested by the different business units
• Led the data classification and labeling initiative to ensure compliance with industry regulations.
• Developed and documented data lineage processes, increasing transparency and trust in data sources.
• Collaborated with cross-functional teams to establish data stewardship responsibilities and improve data ownership.
• Managed access controls and permissions to enhance data security, resulting in zero data breaches during my tenure.
Los Angeles MetroSenior Software Engineer (Consultant)
Sep. 2019 - Mar. 2021Los Angeles, California, United States• SQL database development o Improve the performance of existing queries o Created new stored procedures o Created new functions o Created new triggers
• Maintained a comprehensive asset inventory and condition ratings within a consolidated database based on a Microsoft SQL Server platform with a Microsoft Access user interface.
• Created new cloud-based Microsoft Power BI workspace that holds 25 reports and 5 dashboards to provide information to management and users.
• Re-engineered VBA script code within MS Forms to improve user’s experience.
• Created 10 new reports using in SQL Server Reporting Services and published them in SharePoint
• SharePoint development o Created 3 new SharePoint sites for the different units within the organization
▪ Granted access to users based on their leadership level o Created SharePoint lists and synchronized them with MS SQL tables o Customized SharePoint lists
▪ Added webparts to map locations and facilities using Google Maps Geocoder
▪ Conditional format rows based on the Status for this I wrote a JavaScript
AEGSr. Power BI Data Architect- (Consultant)
May. 2019 - Sep. 2019Los Angeles, California, United States• Provided strategic, analytic, creative and project management support to strategy initiatives
• Reported the results back to the relevant members of the business
• Worked alongside teams within the business or the management team to establish business needs
• Defined new data collection and analysis processes
• Conducted requirement gatherings on requests for data / reports
• Developed Power BI reports • Interacted with business users to identify dashboard strategies, report layouts
• Modified and existing ETL program to include additional data into the staging tables.
agilon healthSenior Business Intelligence Developer (Consultant)
Jan. 2019 - May. 2019Long Beach• Responsible for creating and updating centralized data models in the Data Warehouse/BI platform using existing tools while following established standards, policies and procedures. • Conducted data discovery, data profiling and data modeling.
• Built ETL SSIS packages to normalize, apply business rules, and load data into tabular and multi-dimensional models within the Data Warehouse/BI platform.
• Responsible for proactive monitoring of assigned Data Warehouse/BI platform. • Leveraged expertise to troubleshoot more challenging issues, perform root cause analysis and take preventive actions.
• Created and maintained test scripts for validation and integrated testing. • Responsible for leading testing efforts to ensure existing reports, extracts and centralized data models will continue to work well after workflow changes or software upgrades.
• Helped troubleshoot more complex issues with reports, dashboards, and extracts. • Made recommendations to improve performance, turn-around times, readability and compliance of reports, dashboards, and extracts.
• Assisted BI Director with some application owner responsibilities for specific tools within the Data Warehouse/BI platform.
• Leveraged advanced analytics technologies within our Data Warehouse/BI platform and assist with implementation, maintenance and support of these technologies.
Union BankSenior Data Architect - (Contractor)
Aug. 2017 - Jan. 2019Monterrey Park, California• Single handily Developed an application called Data Quality Analyzer (DQA) o Automated the extraction of the technology information from an RSA Archer backend database o Uploaded technology and systems information into a SQL Database Server for analysis o Created a catalog of data quality business rules to assess the data integrity of all technologies and systems used within the bank o Developed stored procedures to run all the data quality business rules to produce data quality reports o Developed an interface for Systems Managers (SMs) and Technology Product Managers (TPMs) to help them access their technology and systems data quality information o Created dashboards for Administrators and Architects to help them manage their SMs and TPMs progress on aligning their technologies and systems with the banks certification standards
• Provided technical support in the area of Enterprise Architecture o Produced daily management reports of the technology lifecycle within the Bank o Identified areas of deviations from best practices within the Enterprise Architecture unit o Participated in activities that ensure the successful completion of the Bank’s annual technology certification: developing documentation, test applications, and training materials
• Participated in daily Data Quality working session with Systems Managers (SMs) and Technology Product Managers (TPMs) o Helped SMs and TPMs assess the bank certification process by provided training on the bank’s Enterprise Governance, Risk and Compliance tools such as Technology Standards Catalog, o Interviewed Subject Matter Experts (SMEs) on the state of the Bank’s technology and systems data quality program
Sempra EnergySoftware Developer (Consultant)
Jun. 2017 - Aug. 2017Greater Los Angeles Area• Software development. o Working directly with the Director of Pipeline Integrity in developing new reporting tools using MS Access, SharePoint, MS Excel to streamline the work for all Integrity Engineers in the division. o Brainstorming with team lead Integrity Engineers possible solutions for their monthly Assessment Planning meeting. o Currently they have a single user spreadsheet that is updated by an Integrity Engineer and shared via email to all participants. o Propose solution is the use of Microsoft Project Central so all participants can update their progress live. o Developing new MS Access databases o Gather business requirements from Integrity Engineers o Analyzed requirements o Designed solution o Developed code o Tested workbooks and databases o Deployed workbooks and databases o Maintained workbooks and databases o Recommending the use of other technologies not currently used Pipeline Integrity.
99 Cents Only StoresSr. Merchandising Systems and Process Developer - (Contractor)
Jan. 2017 - Jun. 2017Greater Los Angeles Area• Developed with VP areas process improvement of existing business practices
o Worked closely with the Planning Directors to design an application to help all sales units rank articles based on past and forecast sales.
o Recommended changes to improve and streamline existing processes
o Designed a model for a Water Allocation application to assist senior planners allocate bottle water orders to all 400 stores in California.
o Wrote algorithms to allocate produce orders based on weekly sales, existing inventory, and daily delivery schedules for all 400 stores.
• Extensive SQL query writing
• Administered merchandise allocation tools for fresh and GM
• Administered merchandising SharePoint pages
o Created new SharePoint lists to shared data across all functional units.
o Added new WebParts to new and existing SharePoint pages to enhance data sharing.
o Created Workflows to incorporate approval processes across the organization.
• Developed PowerApps models to expedite the existing order cancellation process.
• Supported Vice President of Planning & Allocations with Power BI and Excel Analysis.
Latham & WatkinsEnterprise Applications Programmer
Mar. 2008 - Jul. 2016Greater Los Angeles Area• HP Asset Manager Maintenance
o Created new workflows as required by user
o Gathered business requirements from users to create new wizards
o Created new wizards
o Created and updated action scripts
o Resolved issues with HP Server Application
o Set up new users into the HP Asset Manager system
o Researched and fixed daily database errors
• MS Access database development.
o Gather business requirements from Project Sponsor
o Analyzed requirements
o Scheduled progress meetings
o Designed solution
o Developed code
o Tested application
o Deployed application
o Trained users
o Maintained application
• Extensive SQL query writing.
• Created reports using Crystal Reports X.
• Automated excel spreadsheets for our accounting, finance, and HR departments.
• Developed InfoPath forms.
o Gather business requirements from users
o Analyzed requirements
o Designed solution
o Developed forms in InfoPath designer 2010
o Tested forms
o Published forms
o Maintained forms
• Created dynamic Adobe PDF forms in Adobe LiveCycle Designer.
o Gather business requirements from users
o Analyzed requirements
o Designed solution
o Developed Adobe PDF forms in Adobe LiveCycle Designer
o Tested forms
o Maintained forms
Sony Pictures EntertainmentManager, Sales Administration
Sep. 2007 - Mar. 2008Greater Los Angeles Area• Processed box office cash deposits
• Created new data universes in Business Objects 5.1.4
• Maintained a SQL query library locally.
• Created reports in MS Access using VBA.
• Extracted data from Oracle to create box office aggregate reports.
• Produced management reports in MS Access & Business Objects.
• Analyzed data in MS Excel using pivot tables.
• Prepared weekly market share report.
• Analyzed daily industry estimates.
Gibson, Dunn & Crutcher LLPReporting Analyst
Jan. 2005 - Dec. 2007Greater Los Angeles Area• Single handily develop MS Access databases for all our recruiting programs (include: tables, queries, forms, reports.)
o Gather business requirements
o Analyze requirements
o Design a solution
o Develop code
o Test
o Deploy
o Maintain
• Write SQL scripts in Query Analyzer for non-technical users.
• Maintain a SQL query library in PeopleSoft and locally.
• Create dynamic reports in MS Access using VBA.
• Extract data from MS SQL 2000 to create attrition analysis, hiring trends, recruiting efforts reports.
• Produce weekly management committee reports in MS Access & Crystal Reports.
• Analyze data in MS Excel using pivot tables.
• Validate data extracted from MS Access and MS SQL server using Index, Match embedded functions.
• Create recruiting summary reports in Excel with data stored in MS SQL via ODBC.
• Webmaster for the Legal Recruiting & Diversity site.
• Technical support to all 8 domestic offices on viDesktop (web base application).
• Preparing ad-hoc reports as needed in MS Access.
• Serve as a business analyst for our department for our new portal project.
Prudent RxProgrammer
Aug. 2004 - May. 2005Greater Los Angeles Area• Documented business rules of the existing MS Access applications.
• Improved SQL queries performance.
• Wrote new SQL queries.
• Maintained SQL query library locally.
• Created new stored procedures, and DTS.
• Prepared ad-hoc reports using MS Access as needed by Client Services.
• Designed, developed, tested, and deployed new interfaces into existing MS Access applications.
• Prepared daily, weekly, and monthly management reports using MS Access.
• Loaded client's data into our servers (30 million records approximately).
• Extracted client data into MS Excel for management reports as required.
AetnaBusiness User Specialist
Jan. 1998 - Dec. 2003
Intch is a Professional Networking App for the Future of WorkSee more people like Francisco on Intch
300k+ people
130+ countries
AI matching
Get Intch if you'd like to
451129 people
18
Technologist, Project/Program Manager
24
Data Scientist Intern @ Newell Brands
16
Program Manager @ DISH Network
47999 people
19
Manager @ Epic Force
15
Founder & CEO @ Cultivating Digital Inc
15
Data Analyst