Helena SueJin Macy adkjgx@r.postjobfree.com

**** ******* ********* 619-***-****

San Diego, CA 92124 https://www.linkedin.com/in/helena-macy-695ab5/ OBJECTIVE: I wish to work with an organization that would allow me to use my mathematical talents. I seek variety, challenge, and a chance to learn/expand. I have yet to be given a challenge I couldn't meet and I've been asked to solve problems that companies have said were impossible. Also, I believe that being able to think through a problem is more important than having experience. You have both in me. Whatever I haven't done thus far is only because no one asked me for it yet.

EXPERIENCE: 10/2016 – 2/2021 Northrop Grumman Corporation San Diego/CA Sr Principal Database Software Engineer

Created full stack SQL Server project from scratch

Automated full process from file transfer, data

import, data parsing (XML), data cleansing

Data modeled, created and scheduled jobs with email notifications, SSRS website reporting

Requirements gathering, training, and manuals

Created and enhanced complex customer report designs

Reporting included cascading parameters, color coded collapsible drilldowns, document mapped hyperlinks to histograms based on Freedman–Diaconis's bin sizes for individual measurements and CpK values

Mentored coworkers to create database objects

Enterprise Hosted environment; Server lives in the cloud

Active Directory level security on data accessibility and logging historical changes Technical Environment: MS SQL Server 2012-2019, SSRS, SSIS, AWS, Azure, Visual Studio

.NET, VBA, Tableau, Jira, secret security clearance, manufacturing, test stations 3/2012 – 10/2016 Eastridge Workforce Solutions San Diego/CA Business Intelligence Developer

Created company’s first Reporting Server enabling the organization to generate true reports providing insight into the organization, identifying significant areas of risk, lost assets, and business opportunities

Created stored procedures, user defined functions, table relationships and constraints, and data modeling

Replaced, optimized and enhanced existing Crystal Reports

Combined data from a wide variety of data sources, created and automated SSIS/ETL packages via scheduled jobs

Scripted data manipulation

Created MS Access GUI tools and SSRS reporting to overcome eEmpACT (ERP/CRM) shortcomings

Provided a training class to understand and create MS Access databases, queries, forms and reports (formulate curriculum, exercises, group activities, office hours, tests, and time frame)

Taught SQL and SSRS coding to co-workers, and demonstrated SSRS reporting options to business users

Gathered and executed user requirements to provide solutions for report security

Developed a way for Excel-proficient users to access and upload data to SQL Server

Provided data for software conversions and update/insert/delete scripts to correct data. Created combined reporting between legacy systems and newer systems

Delivered complex vendor defined EDI files to secure FTP sites for HIPAA compliance Technical Environment: MS SQL Server 2008-2012, SSRS, SSIS, Visual Studio .NET, VBA, MS Access 2010, Crystal Reports, eEmpACT, Great Plains & GP CRM, Payroll, Benefits, Financial, Trending, Recruiting

3/2011 – 2/2012 San Diego Data Pro/California Neon Products San Diego/CA Datawarehouse Database GUI & Report Developer

Created stored procedures, user defined functions, managed table relationships and constraints, data modeling, replaced and enhanced reports

Adjusted GUI and developed additional functionality to an existing Access mdb

Troubleshot dataflow and developed/executed solutions to minimize inefficiencies

Gathered requirements, provide training and demonstrate reporting options

Automated DTS processes by creating and scheduling jobs

Gathered and executed user requirements

Technical Environment: SQL Server Reporting Services, MS SQL Server 2005/2008, Visual Studio .NET, VBA, MS Access 2010, Crystal Reports

Helena SueJin Macy adkjgx@r.postjobfree.com

5566 Antigua Boulevard 619-***-****

San Diego, CA 92124 https://www.linkedin.com/in/helena-macy-695ab5/ 9/2007 – 12/2007 AbleForce/Jack in the Box San Diego/CA Datawarehouse Database & Report Developer

Created stored procedures, wrote, standardized, and adjusted reports

Implemented error reporting, SQL Server Reporting Services, MDX data source reports Technical Environment: MS SQL Server 2005, Visual Studio .NET, Source Safe 6/2007 – 8/2007 Outsource Technical/Morgan Systems San Diego/CA Datawarehouse Database & Report Developer

Created stored procedures, performed ETL, implemented user defined functions, altered tables, wrote, standardized, and adjusted reports

Technical Environment: SQL Server Reporting Services, MS SQL Server 2005, Visual Studio

.NET, Source Safe

4/2007 – 6/2007 Apex Systems/Wachovia San Diego/CA Database Developer

Fixed, optimized, enhanced, and completed pre-existing code in MS SQL Server

Documented process, created indexes, normalized data types and column names

Created stored procedure, views, DTS packages, and the client’s test process

Implemented user requirements, analyzed data, ensured data integrity, trained others to use MS SQL 2000, etc

7/2005 – 11/2005 Tristaff/Mitchell One San Diego/CA Database Architect

Recreated, re-evaluated, and automated existing Universe database reporting with Microsoft SQL Server

Replaced Access databases, COBOL code, and complicated Excel practices to add visibility to data for end users

Data modeling, created and optimized stored procedures, indexes, scheduling jobs, DTS, views, relational databases

Gathered and implemented user requirements

Developed and maintained a reporting data warehouse, and used SSRS to create reports for the intranet and automated email

Trained others to use SSRS

Wrote project proposals including accurate timelines, data flow, relational database diagrams, and sample reports

8/2004 – 6/2005 Eastridge Infotech/Brandes Investment Partners San Diego/CA Database Consultant

Updated, enhanced, and automated existing metadata dictionary with Microsoft SQL Server backend and web front end

Created User Reference material and for varying knowledge levels, and gave presentations to various stakeholders in this financial environment

Implemented data modeling, creating and optimizing stored procedures, indexes, scheduling jobs, DTS, and views

Gathered and implemented user requirements. Developed and maintained a reporting data warehouse

Used SQL Server Reporting Services and Visual Studio .NET to create reports for the intranet

Self-taught and trained others to use SQL Server Reporting Services

Set up and maintained reporting website

Helena SueJin Macy adkjgx@r.postjobfree.com

5566 Antigua Boulevard 619-***-****

San Diego, CA 92124 https://www.linkedin.com/in/helena-macy-695ab5/ 9/2000 - 7/2004 Garrad Hassan America/WindLynx San Diego/CA Database Developer

Worked internationally with companies that had SCADA systems, relational databases, extensive statistical data, and database warehouse developing needs (particularly for reporting on Crystal Reports), started AI wind prediction project

Reconstructed MS SQL database for optimal performance, data modeling, parsing and routing data from various forms (including hexadecimal) and sources

Created and maintained stored procedures, scheduled jobs, DTS, triggers, indexes, views, user defined functions, and table structures

Made month-end reports as easy as a few buttons, and created a data dictionary for scientists to communicate to programmers

Gathered and implemented user requirements

Developed a merged system when Windlynx was bought by GHA 5/2000 - 2/2001 Maxim Group/Cox Communications San Diego/CA Consultant

Created and corrected existing reports in Crystal Reports, wrote ad-hoc queries and views in MS SQL

Created technical/business glossary

Documented technical and business rules, restructured coding standards

Implemented data modeling, relational databases, and database warehouse

Moved the database from Access, FoxPro, and Oracle to MS SQL, etc

Gathered and implemented user requirements

2/1999 - 5/2000 First American CREDCO San Diego/CA Programmer/Analyst

Wrote SQL queries, cleaned up databases, manipulated data, and prepared reports

Formally tested software, Informix, UNIX, Access97, Microsoft SQL, VB, Rational Rose, Source Safe, and Crystal Reports

Gathered and implemented user requirements for a financial/credit institution EDUCATION: 8/1997 San Diego State University San Diego/CA Certification

CLAD Teaching Credential with technology block (Morse/O'Farrell), WebWeaver (HTML), Macintosh, various multimedia software

6/1995 University of California, San Diego San Diego/CA Bachelor's Degree

Major: Applied Mathematics (UNIX, XWindows, Macintosh, Matlab, Mathematica & Fortran) Minor: Visual Arts (studio) and Music (Koto, African drumming, JangGu) VOLUNTEER WORK: 9/2010 – 6/2019 Vista Grande Elementary San Diego/CA Fine Artist Instructor

Teach special education students how to do various fine art projects inspired by real artists. Various mediums and styles

Computer Specialist (Excel)

Designing flyers, converting flat files to spreadsheets, manipulating volunteer information to an easily read format and aggregating data

3/2011 Adelante Mujer Conference San Diego/CA

Workshop Presenter

Conducted a workshop to advise 6th-10th grade girls on how to figure out what they want to be when they grow up and how to proceed once they find a focus INTERESTS: Music making, art making, math, logic puzzles, strategy games, data, learning, people, films

Contact this candidate